|
|
API MIV1
MIV1 - A/P Monthly Invoice - Document 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 |
|---|---|---|---|---|---|---|---|---|
| AbsEntry | Internal Key | Int | 11 | |||||
| DocNum | Document Number | Int | 11 | |||||
| DocType | Document Object ID | nVarChar | 18) A/P Invoice 19) A/P Credit Memo | 20 | ||||
| DocDate | Document Posting Date | Date | 8 | |||||
| DocDueDate | Document Due Date | Date | 8 | |||||
| DocClsDate | Document Closing Date | Date | 8 | |||||
| DocAmount | Total Amount | Num | 20 | |||||
| DocExpense | Document Expense | Num | 20 | |||||
| DocDiscSum | Document Discount Sum | Num | 20 | |||||
| DocRound | Document Rounding | Num | 20 | |||||
| DocTax | Document Tax Amount | Num | 20 | |||||
| Closed | Is Document closed in MI | VarChar | Y) Closed N) Not Closed | 1 | N | |||
| MINumWnCls | absEntry when doc closed | Int | 11 | |||||
| Entry KEY UNIQUE | Monthly Invoice Entry | Int | 11 | OMIV A/P Monthly Invoice | PRIMARY | Yes |
SELECT statement
SELECT
MIV1.MinvNum AS 'Monthly Invoice Number',
MIV1.AbsEntry AS 'Internal Key',
MIV1.DocNum AS 'Document Number',
MIV1.DocType AS 'Document Object ID',
MIV1.DocDate AS 'Document Posting Date',
MIV1.DocDueDate AS 'Document Due Date',
MIV1.DocClsDate AS 'Document Closing Date',
MIV1.DocAmount AS 'Total Amount',
MIV1.DocExpense AS 'Document Expense',
MIV1.DocDiscSum AS 'Document Discount Sum',
MIV1.DocRound AS 'Document Rounding',
MIV1.DocTax AS 'Document Tax Amount',
MIV1.Closed AS 'Is Document closed in MI',
MIV1.MINumWnCls AS 'absEntry when doc closed',
MIV1.Entry AS 'Monthly Invoice Entry'
FROM MIV1 AS MIV1
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
