| 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_VGABE | 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 | BEWTP | PO history category | char | 1 | 0 | CHAR | (N' ') | Yes | * | BEWTP | 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 | ZEKKN | Sequential Number of Account Assignment | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | DZEKKN | Allow NULL? |
| 11 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | NUMC | (N'000000000000') | Yes | * | CK_KALNR | Allow NULL? |
| 12 | POPER | Posting period | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | POPER | Allow NULL? |
| 13 | BDATJ | Posting Date YYYY | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | BDATJ | Allow NULL? |
| 14 | XWOFF | Calculation of val. open | char | 1 | 0 | CHAR | (N' ') | Yes | | XWOFF | Allow NULL? |
| 15 | HRKFT | Origin Group as Subdivision of Cost Element | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | HRKFT | Allow NULL? |
| 16 | KSTAR | Cost Element | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KSTAR | Allow NULL? |
| 17 | BWART | Movement Type (Inventory Management) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | BWART | Allow NULL? |
| 18 | CPUDT | Day On Which Accounting Document Was Entered | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CPUDT | Allow NULL? |
| 19 | CPUTM | Time of Entry | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | CPUTM | Allow NULL? |
