| 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 | Procurement alternative/process | nvarchar | 12 | 0 | NUMC | (N'000000000000') | No | * | CKML_ALPROCNR | Allow NULL? |
| 3 | OTYP | Object Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | CKML_OTYP | Allow NULL? |
| 4 | BWKEY | Valuation Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BWKEY | Allow NULL? |
| 5 | WERKS | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | WERKS_D | Allow NULL? |
| 6 | MATNR | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | * | MATNR | Allow NULL? |
| 7 | BWTAR | Valuation Type | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | BWTAR_D | Allow NULL? |
| 8 | SOBKZ | Special Stock Indicator | char | 1 | 0 | CHAR | (N' ') | No | * | SOBKZ | Allow NULL? |
| 9 | KALNR_MAT | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | NUMC | (N'000000000000') | Yes | * | CK_KALNR | Allow NULL? |
| 10 | BTYP | Process Category | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | CKML_BTYP | Allow NULL? |
| 11 | FLG_PROCEQUAL | Procurement Alternative Identical to Process | char | 1 | 0 | CHAR | (N' ') | Yes | | CKML_FLG_PROCEQUAL | Allow NULL? |
| 12 | FLG_PLANOBJ | Procurement alternative only for planning | char | 1 | 0 | CHAR | (N' ') | Yes | | CKML_FLG_PLANOBJ | Allow NULL? |
| 13 | PROC_KALNR | Procurement Process | nvarchar | 12 | 0 | NUMC | (N'000000000000') | Yes | * | CKML_N_PROCNR | Allow NULL? |
| 14 | MAIN_PROCESS | Procurement Process | nvarchar | 12 | 0 | NUMC | (N'000000000000') | Yes | * | CKML_N_PROCNR | Allow NULL? |
| 15 | SORT_NAME | Sort string for differentiating procurement alternatives | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | CKML_SORT_NAME | Allow NULL? |
| 16 | NRULE | Controlling Level Key | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | CKML_NAME_RULE | Allow NULL? |
| 17 | LOEKZ | Deletion indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | CKML_LOEKZ | Allow NULL? |
| 18 | PRWRK_ND | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | WERKS_D | Allow NULL? |
| 19 | PLWRK_ND | Planning plant for the order | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | CO_PWERK | Allow NULL? |
| 20 | PMATN_ND | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | * | MATNR | Allow NULL? |
| 21 | VERID_ND | Production Version | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | VERID | Allow NULL? |
| 22 | STLAN_ND | BOM Usage | char | 1 | 0 | CHAR | (N' ') | Yes | * | STLAN | Allow NULL? |
| 23 | STLAL_ND | Alternative BOM | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | STALT | Allow NULL? |
| 24 | PLNTY_ND | Task List Type | char | 1 | 0 | CHAR | (N' ') | Yes | * | PLNTY | Allow NULL? |
| 25 | PLNNR_ND | Key for Task List Group | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | PLNNR | Allow NULL? |
| 26 | PLNAL_ND | Group Counter | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | PLNAL | Allow NULL? |
| 27 | EKORG_ND | Purchasing Organization | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | EKORG | Allow NULL? |
| 28 | LIFNR_ND | Vendor Account Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | ELIFN | Allow NULL? |
| 29 | UMLWK_ND | Special Procurement Plant - Costing | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | CK_SOWRK | Allow NULL? |
| 30 | UMLMA_ND | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | * | MATNR | Allow NULL? |
| 31 | KDAUF_ND | Sales and Distribution Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | VBELN | Allow NULL? |
| 32 | KDPOS_ND | Item Number in Sales Order | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | KDPOS | Allow NULL? |
| 33 | KUNDE_ND | Customer Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KUNNR | Allow NULL? |
| 34 | PSPNR_ND | WBS Element | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | * | PS_POSNR | Allow NULL? |
| 35 | SPEZ_NAME_ND | User-defined name for procure.alternatives/consumpt.alternat | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | CKML_SPEZ_NAME | Allow NULL? |
| 36 | STLAN_PC | BOM Usage | char | 1 | 0 | CHAR | (N' ') | Yes | * | STLAN | Allow NULL? |
| 37 | STLAL_PC | Alternative BOM | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | STALT | Allow NULL? |
| 38 | LOSGR_PC | Lot Size for Product Costing | decimal | 13 | 3 | QUAN | ((0)) | Yes | | CK_LOSGR | |
| 39 | MEINS_PC | Valuation Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | CK_MEINH_BEW | Allow NULL? |
| 40 | CSPLIT_PC | Apportionment Structure | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | CSPLIT | Allow NULL? |
| 41 | ERNAM | Created by | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | CKML_ERNAM | Allow NULL? |
| 42 | ERDAT | Created on | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CKML_ERDAT | Allow NULL? |
