|
|
API MIV2
MIV2 - A/P Monthly Invoice - Item Table
A/P Monthly Invoice OMIV 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 | 18) A/P Invoice 19) A/P Credit Memo | 20 | ||||
| DocDate | Document Date | Date | 8 | |||||
| LineNum | Line 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 Exchange Rate | Num | 20 | |||||
| ItemQuan | Item Quantity | Num | 20 | |||||
| ItemType | Item Type | VarChar | I) Item E) Expense R) Rounding T) Tax Amount S) Service D) Down Payment Paid W) WTax Amount | 1 | I | |||
| ItemTotal | Net Total | Num | 20 | |||||
| TaxAmount | Tax Amount of Line Level | Num | 20 | |||||
| LineTotal | Gross Total | Num | 20 | |||||
| Entry KEY UNIQUE | Monthly Invoice Entry | Int | 11 | OMIV A/P Monthly Invoice | PRIMARY | Yes | ||
| AbsEntry | Document Entry | Int | 11 |
SELECT statement
SELECT
MIV2.MinvNum AS 'Monthly Invoice Number',
MIV2.DocNum AS 'Document Number',
MIV2.DocType AS 'Document Type',
MIV2.DocDate AS 'Document Date',
MIV2.LineNum AS 'Line number',
MIV2.ItemCode AS 'Item No.',
MIV2.ItemName AS 'Item Name',
MIV2.ItemPrice AS 'Item Price',
MIV2.ItemCurr AS 'Item Currency',
MIV2.ItemRate AS 'Currency Exchange Rate',
MIV2.ItemQuan AS 'Item Quantity',
MIV2.ItemType AS 'Item Type',
MIV2.ItemTotal AS 'Net Total',
MIV2.TaxAmount AS 'Tax Amount of Line Level',
MIV2.LineTotal AS 'Gross Total',
MIV2.Entry AS 'Monthly Invoice Entry',
MIV2.AbsEntry AS 'Document Entry'
FROM MIV2 AS MIV2
Related information
A/P Monthly Invoice OMIV SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
