| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | RBLNR | Document Number of an Invoice Document | nvarchar | 10 | 0 | CHAR | (N' ') | No | RBKP | RE_BELNR | Allow NULL? |
| 3 | RJAHR | Fiscal Year | nvarchar | 4 | 0 | NUMC | (N'0000') | No | RBKP | GJAHR | Allow NULL? |
| 4 | LFNUM | Sequential number in aggregation table | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | VDLFNUM | Allow NULL? |
| 5 | MATNR | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | MARA | MATNR | Allow NULL? |
| 6 | RETPO | Returns Item | char | 1 | 0 | CHAR | (N' ') | Yes | | RETPO | Allow NULL? |
| 7 | MEINS | Base Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | MEINS | Allow NULL? |
| 8 | BPRME | Order Price Unit (Purchasing) | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | BPRME | Allow NULL? |
| 9 | XEINS | Include ID for aggregation | char | 1 | 0 | CHAR | (N' ') | Yes | | XEINS | Allow NULL? |
| 10 | ULFNR | Sequential number in aggregation table | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | VDLFNUM | Allow NULL? |
| 11 | SATNR | Cross-Plant Configurable Material | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | MARA | SATNR | Allow NULL? |
| 12 | MWSKZ | Tax Code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T007A | MWSKZ_MRM | Allow NULL? |
| 13 | WRBTR | Gross Amount in Foreign Currency with +/- Signs | decimal | 13 | 2 | CURR | ((0)) | Yes | | WRBTV | |
| 14 | WMWST | Tax Amount in Document Currency with +/- Sign | decimal | 13 | 2 | CURR | ((0)) | Yes | | FWSTEV | |
| 15 | LIEFFN | Vendor error (exclusive of tax) | decimal | 13 | 2 | CURR | ((0)) | Yes | | LIEFFN | |
| 16 | LMWST | Obsolete: tax in vendor error | decimal | 13 | 2 | CURR | ((0)) | Yes | | LMWST | |
| 17 | MENGE | Quantity | decimal | 13 | 3 | QUAN | ((0)) | Yes | | MENGE_D | |
| 18 | BPMNG | Quantity in Purchase Order Price Unit | decimal | 13 | 3 | QUAN | ((0)) | Yes | | BPMNG | |