| 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 | MLVNR | Material ledger transaction number | nvarchar | 12 | 0 | CHAR | (N' ') | No | | CK_MLVNR | Allow NULL? |
| 3 | VGABE | Type of Transaction in the Object History | char | 1 | 0 | CHAR | (N' ') | No | | CKI_VGAAU | 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 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | NUMC | (N'000000000000') | No | * | CK_KALNR | Allow NULL? |
| 8 | BUDAT | Posting Date in the Document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BUDAT | Allow NULL? |
| 9 | MENGE | Quantity | decimal | 13 | 3 | QUAN | ((0)) | Yes | | MENGE_D | |
| 10 | POPER | Posting period | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | POPER | Allow NULL? |
| 11 | BDATJ | Posting Date YYYY | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | BDATJ | Allow NULL? |
| 12 | HRKFT | Origin Group as Subdivision of Cost Element | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | HRKFT | Allow NULL? |
| 13 | KSTAR | Cost Element | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KSTAR | Allow NULL? |
| 14 | BWART | Movement Type (Inventory Management) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | BWART | Allow NULL? |
| 15 | AUFNR | Order Number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | AUFNR | Allow NULL? |
| 16 | POSNR | Order Item Number | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | CO_POSNR | Allow NULL? |
| 17 | SETTLE_POPER | Posting period | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | POPER | Allow NULL? |
| 18 | SAPRL | Release of SAP System | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | SYSAPRL | Allow NULL? |
| 19 | CPUDT | Day On Which Accounting Document Was Entered | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CPUDT | Allow NULL? |
| 20 | CPUTM | Time of Entry | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | CPUTM | Allow NULL? |
| 21 | XWOFF | Calculation of val. open | char | 1 | 0 | CHAR | (N' ') | Yes | | XWOFF | Allow NULL? |
| 22 | WERKS | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | WERKS_D | Allow NULL? |
| 23 | STORNO | Checkbox | char | 1 | 0 | CHAR | (N' ') | Yes | | XFELD | Allow NULL? |
| 24 | MEINS | Base Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | MEINS | Allow NULL? |
| 25 | BSTMG | Purchase Order Quantity | decimal | 13 | 3 | QUAN | ((0)) | Yes | | BSTMG | |
| 26 | BSTME | Purchase Order Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | BSTME | Allow NULL? |
| 27 | GRIR_ACTIVE | Multiple Usage | char | 1 | 0 | CHAR | (N' ') | Yes | | CK_MULTI | Allow NULL? |
