| 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 | * | MANDT | Allow NULL? |
| 2 | MBLNR | Number of Material Document | nvarchar | 10 | 0 | CHAR | (N' ') | No | MKPF | MBLNR | Allow NULL? |
| 3 | MJAHR | Material Document Year | nvarchar | 4 | 0 | NUMC | (N'0000') | No | MKPF | MJAHR | Allow NULL? |
| 4 | ZEILE | Item in Material Document | nvarchar | 4 | 0 | NUMC | (N'0000') | No | MSEG | MBLPO | Allow NULL? |
| 5 | STATUS | Status for RKWA entry | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | MR_RKWAST | Allow NULL? |
| 6 | BLDAT | Document Date in Document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BLDAT | Allow NULL? |
| 7 | BUDAT | Posting Date in the Document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BUDAT | Allow NULL? |
| 8 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001 | BUKRS | Allow NULL? |
| 9 | SOBKZ | Special Stock Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | T148 | SOBKZ | Allow NULL? |
| 10 | LIFNR | Vendor Account Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | LFA1 | ELIFN | Allow NULL? |
| 11 | WERKS | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001W | WERKS_D | Allow NULL? |
| 12 | MATNR | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | MARA | MATNR | Allow NULL? |
| 13 | SHKZG | Debit/Credit Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | SHKZG | Allow NULL? |
| 14 | GSBER | Business Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TGSB | GSBER | Allow NULL? |
| 15 | BWAER | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WAERS | Allow NULL? |
| 16 | WRBTR | Amount in document currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | WRBTR | |
| 17 | BSTME | Unit of measure for settlement | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | MR_BSTME | Allow NULL? |
| 18 | BSTMG | Quantity withdrawn for settlement | decimal | 13 | 3 | QUAN | ((0)) | Yes | | MR_BSTMG | |
| 19 | HKONT | General Ledger Account | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | SKB1 | HKONT | Allow NULL? |
| 20 | MWSKZ | Tax on sales/purchases code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T007A | MWSKZ | Allow NULL? |
| 21 | BELNR | Accounting Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | BELNR_D | Allow NULL? |
| 22 | GJAHR | Fiscal Year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | GJAHR | Allow NULL? |
| 23 | BUZEI | Document Item in Invoice Document | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | RBLGP | Allow NULL? |
| 24 | NAVNW | Non-deductible input tax | decimal | 13 | 2 | CURR | ((0)) | Yes | | NAVNW | |
| 25 | PRCTR | Profit Center | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | PRCTR | Allow NULL? |
| 26 | BWART | Movement Type (Inventory Management) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T156 | BWART | Allow NULL? |
| 27 | MENGE | Quantity | decimal | 13 | 3 | QUAN | ((0)) | Yes | | MENGE_D | |
| 28 | MEINS | Base Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | MEINS | Allow NULL? |
| 29 | WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERS | Allow NULL? |
| 30 | EBELN | Purchasing Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | EKKO | EBELN | Allow NULL? |
| 31 | EBELP | Item Number of Purchasing Document | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | EKPO | EBELP | Allow NULL? |
| 32 | BKLAS | Valuation Class | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T025 | BKLAS | Allow NULL? |
| 33 | CKONT | General Ledger Account | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | SKA1 | HKONT | Allow NULL? |
| 34 | ABWHK | Alternative G/L Account | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | SKA1 | ABWHK | Allow NULL? |
| 35 | PREIS | Net Price in Purchasing Info Record | decimal | 11 | 2 | CURR | ((0)) | Yes | | IPREI | |
| 36 | PEINH | Price Unit | decimal | 5 | 0 | DEC | ((0)) | Yes | | EPEIN | |
| 37 | CCBTR | Amount in document currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | WRBTR | |
| 38 | VGART | Transaction/Event Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T158V | VGART | Allow NULL? |
| 39 | XBLNR | Reference Document Number | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | XBLNR1 | Allow NULL? |
| 40 | EMLIF | Vendor to be supplied/who is to receive delivery | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | EMLIF | Allow NULL? |
| 41 | VBELN | Billing Document | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | VBUK | VBELN_VF | Allow NULL? |
| 42 | POSNR | Billing item | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | VBUP | POSNR_VF | Allow NULL? |
| 43 | DOCKZ | Movement category | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPNEA/DOCKZ | Allow NULL? |
| 44 | MVCTG | Movement category | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPNEA/DOCKZ | Allow NULL? |
