| 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 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | NUMC | (N'000000000000') | No | * | CK_KALNR | Allow NULL? |
| 3 | BDATJ | Posting Date YYYY | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | BDATJ | Allow NULL? |
| 4 | POPER | Posting period | nvarchar | 3 | 0 | NUMC | (N'000') | No | | POPER | Allow NULL? |
| 5 | UNTPER | Value Structure Type | nvarchar | 3 | 0 | NUMC | (N'000') | No | | CK_UNTPER | Allow NULL? |
| 6 | CATEG | Category in Material Ledger Data Display | nvarchar | 2 | 0 | CHAR | (N' ') | No | | CKML_CATEG | Allow NULL? |
| 7 | PTYP | Process category for procurement alt. or consuption alt. | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | CK_PTYP_BVALT | Allow NULL? |
| 8 | BVALT | Procurement alternative/process | nvarchar | 12 | 0 | NUMC | (N'000000000000') | No | * | CKML_ALPROCNR | Allow NULL? |
| 9 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | CHAR | (N' ') | No | | CURTP | Allow NULL? |
| 10 | LBKUM | Total valuated stock | decimal | 15 | 3 | QUAN | ((0)) | Yes | | CK_LBKUM | |
| 11 | MEINS | Unit of Measure for Material Valuation | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | CKML_MEINS | Allow NULL? |
| 12 | SALK3 | Value of total valuated stock | decimal | 15 | 2 | CURR | ((0)) | Yes | | CK_SALK3_1 | |
| 13 | ESTPRD | Single-Level Price Differences | decimal | 15 | 2 | CURR | ((0)) | Yes | | CKML_ESTPRD | |
| 14 | ESTKDM | Single-Level Exchange Rate Differences | decimal | 15 | 2 | CURR | ((0)) | Yes | | CKML_ESTKDM | |
| 15 | MSTPRD | Multilevel Price Differences | decimal | 15 | 2 | CURR | ((0)) | Yes | | CKML_MSTPRD | |
| 16 | MSTKDM | Multilevel Exchange Rate Differences | decimal | 15 | 2 | CURR | ((0)) | Yes | | CKML_MSTKDM | |
| 17 | WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERS | Allow NULL? |
| 18 | TPPRD | Price Differences from Transfer Prices | decimal | 15 | 2 | CURR | ((0)) | Yes | | CKML_TPPRD | |
| 19 | ESTKDM_ST | Exchange Rate Differences Not Relevant to Inventory | decimal | 15 | 2 | CURR | ((0)) | Yes | | CKML_ESTKDM_ST | |
