| 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 | EBELN | Purchasing Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | EKKO | EBELN | Allow NULL? |
| 3 | EBELP | Item Number of Purchasing Document | nvarchar | 5 | 0 | NUMC | (N'00000') | No | EKPO | EBELP | Allow NULL? |
| 4 | GJAHR | Material Document Year | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | MJAHR | Allow NULL? |
| 5 | BELNR | Number of Material Document | nvarchar | 10 | 0 | CHAR | (N' ') | No | | MBLNR | Allow NULL? |
| 6 | BUZEI | Item in Material Document | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | MBLPO | Allow NULL? |
| 7 | LINE_ID | Unique identification of document line | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | MB_LINE_ID | Allow NULL? |
| 8 | CONSTY | Component Consumption Type for Subcontracting | char | 1 | 0 | CHAR | (N' ') | Yes | | CONSTY | Allow NULL? |
| 9 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | LFGJA | Allow NULL? |
| 10 | LFBNR | Document No. of a Reference Document | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | LFBNR | Allow NULL? |
| 11 | LFPOS | Item of a Reference Document | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | LFPOS | Allow NULL? |
| 12 | MATNR | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | MARA | MATNR | Allow NULL? |
| 13 | WERKS | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001W | WERKS_D | Allow NULL? |
| 14 | LAGME | Base Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | LAGME | Allow NULL? |
| 15 | ERFME | Unit of Entry | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | ERFME | Allow NULL? |
| 16 | BDMNG | Requirement Quantity | decimal | 13 | 3 | QUAN | ((0)) | Yes | | BDMNG | |
| 17 | ERFMG | Quantity in Unit of Entry | decimal | 13 | 3 | QUAN | ((0)) | Yes | | ERFMG | |
| 18 | WAMNG | Issued Quantity | decimal | 13 | 3 | QUAN | ((0)) | Yes | | WAMNG | |
| 19 | WAWRT | Sum of the values of goods issues | decimal | 13 | 2 | CURR | ((0)) | Yes | | WAWRT | |
| 20 | SHKZG | Debit/Credit Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | SHKZG | Allow NULL? |
| 21 | SOBKZ | Special Stock Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | T148 | SOBKZ | Allow NULL? |
| 22 | LGPRO | Issue Storage Location | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | LGPRO | Allow NULL? |
| 23 | CHARG | Batch Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | CHARG_D | Allow NULL? |
