|
|
API MIN1
MIN1 - Monthly Invoice Report Document Information 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 |
|---|---|---|---|---|---|---|---|---|
| AbsEntry | Document Internal ID | Int | 11 | |||||
| DocNum | Document Number | Int | 11 | |||||
| DocType | Document Object ID | nVarChar | 13) A/R Invoice 14) A/R 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 | Document Closed? | VarChar | Y) N) | 1 | N | |||
| MINumWnCls | Internal Number for Closed Document | Int | 11 | |||||
| Entry KEY UNIQUE | Monthly Invoice Entry | Int | 11 | OMIN A/R Monthly Invoice | PRIMARY | Yes |
SELECT statement
SELECT
MIN1.MinvNum AS 'Monthly Invoice Number',
MIN1.AbsEntry AS 'Document Internal ID',
MIN1.DocNum AS 'Document Number',
MIN1.DocType AS 'Document Object ID',
MIN1.DocDate AS 'Document Posting Date',
MIN1.DocDueDate AS 'Document Due Date',
MIN1.DocClsDate AS 'Document Closing Date',
MIN1.DocAmount AS 'Total Amount',
MIN1.DocExpense AS 'Document Expense',
MIN1.DocDiscSum AS 'Document Discount Sum',
MIN1.DocRound AS 'Document Rounding',
MIN1.DocTax AS 'Document Tax Amount',
MIN1.Closed AS 'Document Closed?',
MIN1.MINumWnCls AS 'Internal Number for Closed Document',
MIN1.Entry AS 'Monthly Invoice Entry'
FROM MIN1 AS MIN1
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
