SAP ABAP Table CKMLMV001 (Procurement alternatives)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CO-PC-ACT (Application Component) Actual Costing/Material Ledger
     ⤷ CKMLMV (Package) Quantity Structure Tool

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CKMLMV001	Table Relationship Diagram
Short Description	Procurement alternatives

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	KALNR	☑	CKML_ALPROCNR	CK_KALNR	NUMC	12	0	Procurement alternative/process	*
3	OTYP	☐	CKML_OTYP	CKML_OTYP	CHAR	2	0	Object Type
4	BWKEY	☐	BWKEY	BWKEY	CHAR	4	0	Valuation area	*
5	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
6	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
7	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	*
8	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	*
9	KALNR_MAT	☐	CK_KALNR	CK_KALNR	NUMC	12	0	Cost Estimate Number for Cost Est. w/o Qty Structure	*
10	BTYP	☐	CKML_BTYP	CKML_PROZESS_TYP	CHAR	4	0	Process Category	*
11	FLG_PROCEQUAL	☐	CKML_FLG_PROCEQUAL	BOOLE	CHAR	1	0	Procurement Alternative Identical to Process
12	FLG_PLANOBJ	☐	CKML_FLG_PLANOBJ	BOOLE	CHAR	1	0	Procurement alternative only for planning
13	PROC_KALNR	☐	CKML_N_PROCNR	CK_KALNR	NUMC	12	0	Procurement Process	*
14	MAIN_PROCESS	☐	CKML_N_PROCNR	CK_KALNR	NUMC	12	0	Procurement Process	*
15	SORT_NAME	☐	CKML_SORT_NAME	CHAR10	CHAR	10	0	Sort string for differentiating procurement alternatives
16	NRULE	☐	CKML_NAME_RULE	CKML_NAME_RULE	CHAR	4	0	Controlling Level Key	*
17	LOEKZ	☐	CKML_LOEKZ	CHAR1	CHAR	1	0	Deletion indicator
18	.INCLU-_ND	☐				0	0	Fields for naming (process and procurement)
19	PRWRK_ND	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
20	PLWRK_ND	☐	CO_PWERK	WERKS	CHAR	4	0	Planning plant for the order	*
21	PMATN_ND	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
22	VERID_ND	☐	VERID	VERID	CHAR	4	0	Production Version	*
23	STLAN_ND	☐	STLAN	STLAN	CHAR	1	0	BOM Usage	*
24	STLAL_ND	☐	STALT	ALTNR	CHAR	2	0	Alternative BOM
25	PLNTY_ND	☐	PLNTY	PLNTY	CHAR	1	0	Task List Type	*
26	PLNNR_ND	☐	PLNNR	PLNNR	CHAR	8	0	Key for Task List Group
27	PLNAL_ND	☐	PLNAL	ALTNR	CHAR	2	0	Group Counter
28	EKORG_ND	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	*
29	LIFNR_ND	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	*
30	UMLWK_ND	☐	CK_SOWRK	WERKS	CHAR	4	0	Special Procurement Plant - Costing	*
31	UMLMA_ND	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
32	KDAUF_ND	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	*
33	KDPOS_ND	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
34	KUNDE_ND	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
35	PSPNR_ND	☐	PS_POSNR	PS_POSNR	NUMC	8	0	WBS Element	*
36	SPEZ_NAME_ND	☐	CKML_SPEZ_NAME	CHAR30	CHAR	30	0	User-defined name for procure.alternatives/consumpt.alternat
37	.INCLU-_PC	☐				0	0	Database Fields for Mixed Costing in QS Tool Table CKMLMV001
38	STLAN_PC	☐	STLAN	STLAN	CHAR	1	0	BOM Usage	*
39	STLAL_PC	☐	STALT	ALTNR	CHAR	2	0	Alternative BOM
40	LOSGR_PC	☐	CK_LOSGR	MENG13	QUAN	13	3	Costing lot size
41	MEINS_PC	☐	CK_MEINH_BEW	MEINS	UNIT	3	0	Valuation Unit of Measure	*
42	CSPLIT_PC	☐	CSPLIT	CSPLIT	CHAR	4	0	Apportionment structure	*
43	.INCLUDE	☐				0	0	Administrative Structure for QST Tables
44	ERNAM	☐	CKML_ERNAM	USNAM	CHAR	12	0	Created by
45	ERDAT	☐	CKML_ERDAT	DATUM	DATS	8	0	Created on

History

Last changed by/on	SAP	20110901
SAP Release Created in