| 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 | MYKEY | Valuation level for receipts relevant to LIFO/FIFO | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001Y | MYMP_KEY | Allow NULL? |
| 3 | MATNR | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | No | MARA | MATNR | Allow NULL? |
| 4 | EBELN | Purchasing Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | EKKO | EBELN | Allow NULL? |
| 5 | EBELP | Item Number of Purchasing Document | nvarchar | 5 | 0 | NUMC | (N'00000') | No | EKPO | EBELP | Allow NULL? |
| 6 | MBLNR | Number of Material Document | nvarchar | 10 | 0 | CHAR | (N' ') | No | | MBLNR | Allow NULL? |
| 7 | MJAHR | Material Document Year | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | MJAHR | Allow NULL? |
| 8 | MBLPO | Item in Material Document | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | MBLPO | Allow NULL? |
| 9 | BUDAT | Posting Date in the Document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BUDAT | Allow NULL? |
| 10 | ZUMNG | Receipt qty, LIFO/FIFO relevant material document | decimal | 13 | 3 | QUAN | ((0)) | Yes | | MYZUMNG | |
| 11 | ZUWRT | Receipt value of a LIFO/FIFO-relevant material document | decimal | 13 | 2 | CURR | ((0)) | Yes | | MYZUWRT | |
| 12 | REMNG | Invoice Quantity for Mat. Document Relevant to LIFO/FIFO | decimal | 13 | 3 | QUAN | ((0)) | Yes | | MYREMNG | |
| 13 | MEINS | Unit of Measure for Material Valuation | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | CKML_MEINS | Allow NULL? |
| 14 | BWTAR | Valuation Type | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | BWTAR_D | Allow NULL? |
| 15 | CPUDT | Day On Which Accounting Document Was Entered | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CPUDT | Allow NULL? |
| 16 | CPUTM | Time of Entry | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | CPUTM | Allow NULL? |
| 17 | BWART | Movement Type (Inventory Management) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | BWART | Allow NULL? |
| 18 | LIFNR | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | LIFNR | Allow NULL? |
| 19 | AUFNR | Order Number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | AUFNR | Allow NULL? |
| 20 | XTERN | Record Imported from External Source | char | 1 | 0 | CHAR | (N' ') | Yes | | MY_XTERN | Allow NULL? |
| 21 | FBASE | FIFO | char | 1 | 0 | CHAR | (N' ') | Yes | | MY_FBASE | Allow NULL? |
