|
|
API MIN2
MIN2 - Item Imformation of MI Table
A/R Monthly Invoice OMIN SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | MinvNum | Monthly Invoice Number | Int | 11 |
|---|---|---|---|---|---|---|---|---|
| DocNum | Document Number | Int | 11 | |||||
| DocType | Document Type | nVarChar | 13) A/R Invoice 14) A/R Credit Memo | 20 | ||||
| DocDate | Document Date | Date | 8 | |||||
| LineNum | Row Number | Int | 11 | |||||
| ItemCode | Item No. | nVarChar | 20 | |||||
| ItemName | Item Name | nVarChar | 100 | |||||
| ItemPrice | Item Price | Num | 20 | |||||
| ItemCurr | Item Currency | nVarChar | 3 | |||||
| itemRate | Currency Price | Num | 20 | |||||
| ItemQuan | Item Quantity | Num | 20 | |||||
| ItemType | Item Type | VarChar | I) E) D) R) T) S) P) W) | 1 | I | |||
| ItemTotal | Item Total | Num | 20 | |||||
| TaxAmount | Tax Amount | Num | 20 | |||||
| LineTotal | Row Total | Num | 20 | |||||
| Entry KEY UNIQUE | Monthly Invoice Entry | Int | 11 | OMIN A/R Monthly Invoice | PRIMARY | Yes | ||
| AbsEntry | Document Entry | Int | 11 |
SELECT statement
SELECT
MIN2.MinvNum AS 'Monthly Invoice Number',
MIN2.DocNum AS 'Document Number',
MIN2.DocType AS 'Document Type',
MIN2.DocDate AS 'Document Date',
MIN2.LineNum AS 'Row Number',
MIN2.ItemCode AS 'Item No.',
MIN2.ItemName AS 'Item Name',
MIN2.ItemPrice AS 'Item Price',
MIN2.ItemCurr AS 'Item Currency',
MIN2.itemRate AS 'Currency Price',
MIN2.ItemQuan AS 'Item Quantity',
MIN2.ItemType AS 'Item Type',
MIN2.ItemTotal AS 'Item Total',
MIN2.TaxAmount AS 'Tax Amount',
MIN2.LineTotal AS 'Row Total',
MIN2.Entry AS 'Monthly Invoice Entry',
MIN2.AbsEntry AS 'Document Entry'
FROM MIN2 AS MIN2
Related information
A/R Monthly Invoice OMIN SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
