SAP ABAP Table CKML1 (Material Ledger Period Totals Records (Release 3.xx))

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ CKML (Package) Material ledger

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CKML1	Table Relationship Diagram
Short Description	Material Ledger Period Totals Records (Release 3.xx)

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	T000
2	KALNR	☑	CK_KALNR	CK_KALNR	NUMC	12	0	Cost Estimate Number for Cost Est. w/o Qty Structure	*
3	MATLED	☑	CK_MATLED	CK_MATLED	CHAR	4	0	Material ledger type	TCKM1
4	BDATJ	☑	BDATJ	GJAHR	NUMC	4	0	Posting Date YYYY
5	POPER	☑	POPER	POPER	NUMC	3	0	Posting period
6	UNTPER	☑	CK_UNTPER	CK_UNTPER	NUMC	3	0	Value Structure Type
7	STPRS_1	☐	CK_STPRS_1	WERT11	CURR	11	2	Standard price
8	STPRS_2	☐	CK_STPRS_2	WERT11	CURR	11	2	Standard price
9	STPRS_3	☐	CK_STPRS_3	WERT11	CURR	11	2	Standard price
10	PVPRS_1	☐	CK_PVPRS_1	WERT11	CURR	11	2	Periodic unit price
11	PVPRS_2	☐	CK_PVPRS_2	WERT11	CURR	11	2	Periodic unit price
12	PVPRS_3	☐	CK_PVPRS_3	WERT11	CURR	11	2	Periodic unit price
13	LBKUM	☐	CK_LBKUM	MENGV8	QUAN	15	3	Total valuated stock
14	SALK3_1	☐	CK_SALK3_1	WERTV8	CURR	15	2	Value of total valuated stock
15	SALK3_2	☐	CK_SALK3_2	WERTV8	CURR	15	2	Value of total valuated stock
16	SALK3_3	☐	CK_SALK3_3	WERTV8	CURR	15	2	Value of total valuated stock
17	SALKV_1	☐	CK_SALKV_1	WERTV8	CURR	15	2	Value based on the periodic unit price (only with pr.ctrl S)
18	SALKV_2	☐	CK_SALKV_2	WERTV8	CURR	15	2	Value based on the periodic unit price (only with pr.ctrl S)
19	SALKV_3	☐	CK_SALKV_3	WERTV8	CURR	15	2	Value based on the periodic unit price (only with pr.ctrl S)
20	KZ_ABGER	☐	XABGER	XABGER	CHAR	1	0	Material price will no longer be determined in this period
21	.INCLU-O	☐				0	0	Closing fields for material ledger
22	WEKUMO	☐	CK_WEKUM	MENGV8	QUAN	15	3	Total valuated qty of goods received in the period
23	WEWRT_1O	☐	CK_WEWRT_1	WERTV8	CURR	15	2	Total value of goods receipts for period
24	WEWRT_2O	☐	CK_WEWRT_2	WERTV8	CURR	15	2	Total value of goods receipts for period
25	WEWRT_3O	☐	CK_WEWRT_3	WERTV8	CURR	15	2	Total value of goods receipts for period
26	REKUMO	☐	CK_REKUM	MENGV8	QUAN	15	3	Total valuted invoice receipt quantity for the period
27	REWRT_1O	☐	CK_REWRT_1	WERTV8	CURR	15	2	Total invoice receipt value of period
28	REWRT_2O	☐	CK_REWRT_2	WERTV8	CURR	15	2	Total invoice receipt value of period
29	REWRT_3O	☐	CK_REWRT_3	WERTV8	CURR	15	2	Total invoice receipt value of period
30	LVREKUMO	☐	CK_LVREKUM	MENGV8	QUAN	15	3	Subcontracting: total valuated invoice receipt quantity
31	LVREW_1O	☐	CK_LVREW_1	WERTV8	CURR	15	2	Subcontracting: total invoice receipt value
32	LVREW_2O	☐	CK_LVREW_2	WERTV8	CURR	15	2	Subcontracting: total invoice receipt value
33	LVREW_3O	☐	CK_LVREW_3	WERTV8	CURR	15	2	Subcontracting: total invoice receipt value
34	ZUKUMO	☐	CK_ZUKUM	MENGV8	QUAN	15	3	Total quantity of goods received in period
35	ZUABW_1O	☐	CK_ZUABW_1	WERTV8	CURR	15	2	Receipts: Single-level price differences
36	ZUABW_2O	☐	CK_ZUABW_2	WERTV8	CURR	15	2	Variance to ML price
37	ZUABW_3O	☐	CK_ZUABW_3	WERTV8	CURR	15	2	Variance to ML price
38	LVABW_1O	☐	CK_LVABW_1	WERTV8	CURR	15	2	Subcontrac.: var. from planned value of mat. to be provided
39	LVABW_2O	☐	CK_LVABW_2	WERTV8	CURR	15	2	Subcontrac.: var. from planned value of mat. to be provided
40	LVABW_3O	☐	CK_LVABW_3	WERTV8	CURR	15	2	Subcontrac.: var. from planned value of mat. to be provided
41	LVWEKUMO	☐	CK_LVWEKUM	MENGV8	QUAN	15	3	Subcontracting: total valuated quantity of goods received
42	LVWEW_1O	☐	CK_LVWEW_1	WERTV8	CURR	15	2	Subcontracting: value of goods received
43	LVWEW_2O	☐	CK_LVWEW_2	WERTV8	CURR	15	2	Subcontracting: value of goods received
44	LVWEW_3O	☐	CK_LVWEW_3	WERTV8	CURR	15	2	Subcontracting: value of goods received
45	ZUOME_1O	☐	CK_ZUOME_1	WERTV8	CURR	15	2	Amount to be debited to material ledger price
46	ZUOME_2O	☐	CK_ZUOME_2	WERTV8	CURR	15	2	Amount to be debited to material ledger price
47	ZUOME_3O	☐	CK_ZUOME_3	WERTV8	CURR	15	2	Amount to be debited to material ledger price
48	ZUUMB_1O	☐	CK_ZUUMB_1	WERTV8	CURR	15	2	Revaluation Amount
49	ZUUMB_2O	☐	CK_ZUUMB_2	WERTV8	CURR	15	2	Revaluation amount for material ledger price
50	ZUUMB_3O	☐	CK_ZUUMB_3	WERTV8	CURR	15	2	Revaluation amount for material ledger price
51	LVPVP_1	☐	CK_LVPVP_1	WERT11	CURR	11	2	Subcontracting: periodic unit price (PUP)
52	LVPVP_2	☐	CK_LVPVP_2	WERT11	CURR	11	2	Subcontracting: periodic unit price (PUP)
53	LVPVP_3	☐	CK_LVPVP_3	WERT11	CURR	11	2	Subcontracting: periodic unit price (PUP)
54	.INCLU-A	☐				0	0	Closing fields for material ledger
55	WEKUMA	☐	CK_WEKUM	MENGV8	QUAN	15	3	Total valuated qty of goods received in the period
56	WEWRT_1A	☐	CK_WEWRT_1	WERTV8	CURR	15	2	Total value of goods receipts for period
57	WEWRT_2A	☐	CK_WEWRT_2	WERTV8	CURR	15	2	Total value of goods receipts for period
58	WEWRT_3A	☐	CK_WEWRT_3	WERTV8	CURR	15	2	Total value of goods receipts for period
59	REKUMA	☐	CK_REKUM	MENGV8	QUAN	15	3	Total valuted invoice receipt quantity for the period
60	REWRT_1A	☐	CK_REWRT_1	WERTV8	CURR	15	2	Total invoice receipt value of period
61	REWRT_2A	☐	CK_REWRT_2	WERTV8	CURR	15	2	Total invoice receipt value of period
62	REWRT_3A	☐	CK_REWRT_3	WERTV8	CURR	15	2	Total invoice receipt value of period
63	LVREKUMA	☐	CK_LVREKUM	MENGV8	QUAN	15	3	Subcontracting: total valuated invoice receipt quantity
64	LVREW_1A	☐	CK_LVREW_1	WERTV8	CURR	15	2	Subcontracting: total invoice receipt value
65	LVREW_2A	☐	CK_LVREW_2	WERTV8	CURR	15	2	Subcontracting: total invoice receipt value
66	LVREW_3A	☐	CK_LVREW_3	WERTV8	CURR	15	2	Subcontracting: total invoice receipt value
67	ZUKUMA	☐	CK_ZUKUM	MENGV8	QUAN	15	3	Total quantity of goods received in period
68	ZUABW_1A	☐	CK_ZUABW_1	WERTV8	CURR	15	2	Receipts: Single-level price differences
69	ZUABW_2A	☐	CK_ZUABW_2	WERTV8	CURR	15	2	Variance to ML price
70	ZUABW_3A	☐	CK_ZUABW_3	WERTV8	CURR	15	2	Variance to ML price
71	LVABW_1A	☐	CK_LVABW_1	WERTV8	CURR	15	2	Subcontrac.: var. from planned value of mat. to be provided
72	LVABW_2A	☐	CK_LVABW_2	WERTV8	CURR	15	2	Subcontrac.: var. from planned value of mat. to be provided
73	LVABW_3A	☐	CK_LVABW_3	WERTV8	CURR	15	2	Subcontrac.: var. from planned value of mat. to be provided
74	LVWEKUMA	☐	CK_LVWEKUM	MENGV8	QUAN	15	3	Subcontracting: total valuated quantity of goods received
75	LVWEW_1A	☐	CK_LVWEW_1	WERTV8	CURR	15	2	Subcontracting: value of goods received
76	LVWEW_2A	☐	CK_LVWEW_2	WERTV8	CURR	15	2	Subcontracting: value of goods received
77	LVWEW_3A	☐	CK_LVWEW_3	WERTV8	CURR	15	2	Subcontracting: value of goods received
78	ZUOME_1A	☐	CK_ZUOME_1	WERTV8	CURR	15	2	Amount to be debited to material ledger price
79	ZUOME_2A	☐	CK_ZUOME_2	WERTV8	CURR	15	2	Amount to be debited to material ledger price
80	ZUOME_3A	☐	CK_ZUOME_3	WERTV8	CURR	15	2	Amount to be debited to material ledger price
81	ZUUMB_1A	☐	CK_ZUUMB_1	WERTV8	CURR	15	2	Revaluation Amount
82	ZUUMB_2A	☐	CK_ZUUMB_2	WERTV8	CURR	15	2	Revaluation amount for material ledger price
83	ZUUMB_3A	☐	CK_ZUUMB_3	WERTV8	CURR	15	2	Revaluation amount for material ledger price
84	ZUOMP_1O	☐	CK_ZUOMP_1	WERT11	CURR	11	2	Theoretical subsequent debit/credit price per price unit
85	ZUOMP_2O	☐	CK_ZUOMP_2	WERT11	CURR	11	2	Theoretical subsequent debit/credit price per price unit
86	ZUOMP_3O	☐	CK_ZUOMP_3	WERT11	CURR	11	2	Theoretical subsequent debit/credit price per price unit
87	ZUOMP_1A	☐	CK_ZUOMP_1	WERT11	CURR	11	2	Theoretical subsequent debit/credit price per price unit
88	ZUOMP_2A	☐	CK_ZUOMP_2	WERT11	CURR	11	2	Theoretical subsequent debit/credit price per price unit
89	ZUOMP_3A	☐	CK_ZUOMP_3	WERT11	CURR	11	2	Theoretical subsequent debit/credit price per price unit
90	ZUOMMO	☐	CK_ZUOMM	MENGV8	QUAN	15	3	Cumulated quantity of subs. debit/credit in period
91	ZUOMMA	☐	CK_ZUOMM	MENGV8	QUAN	15	3	Cumulated quantity of subs. debit/credit in period
92	PEINH_1	☐	CK_PEINH_1	PACK3	DEC	5	0	Price unit
93	PEINH_2	☐	CK_PEINH_2	PACK3	DEC	5	0	Price unit for material ledger
94	PEINH_3	☐	CK_PEINH_3	PACK3	DEC	5	0	Price unit for material ledger
95	UMKUMO	☐	CK_UMKUM	MENGV8	QUAN	15	3	Quantity posted to previous period
96	UMKUMA	☐	CK_UMKUM	MENGV8	QUAN	15	3	Quantity posted to previous period
97	WEKUMVA	☐	CK_WEKUMV	MENGV8	QUAN	15	3	Total valuated GR quantity (carried forward)
98	WEWRT_1VA	☐	CK_WEWV_1	WERTV8	CURR	15	2	Total value of goods receipts (carried for.)
99	WEWRT_2VA	☐	CK_WEWV_2	WERTV8	CURR	15	2	Total value of goods receipts (carried for.)
100	WEWRT_3VA	☐	CK_WEWV_3	WERTV8	CURR	15	2	Total value of goods receipts (carried for.)
101	REKUMVA	☐	CK_REKUMV	MENGV8	QUAN	15	3	Total valuted invoice receipt quantity (carried for.)
102	REWRT_1VA	☐	CK_REWV_1	WERTV8	CURR	15	2	Total invoice receipt value (carried for.)
103	REWRT_2VA	☐	CK_REWV_2	WERTV8	CURR	15	2	Total invoice receipt value (carried for.)
104	REWRT_3VA	☐	CK_REWV_3	WERTV8	CURR	15	2	Total invoice receipt value (carried for.)
105	LVWEKUMVA	☐	CK_LWEKV	MENGV8	QUAN	15	3	Subcontracting: total valuated GR quantity (carried for.)
106	LVWEW_1VA	☐	CK_LWEWV_1	WERTV8	CURR	15	2	Subcontracting: value of goods received (carried for.)
107	LVWEW_2VA	☐	CK_LWEWV_2	WERTV8	CURR	15	2	Subcontracting: value of goods received (carried for.)
108	LVWEW_3VA	☐	CK_LWEWV_3	WERTV8	CURR	15	2	Subcontracting: value of goods received (carried for.)
109	LVREKUMVA	☐	CK_LREKV	MENGV8	QUAN	15	3	Subcontracting: Total Valuated IR Quantity (Carryforward)
110	LVREW_1VA	☐	CK_LREWV_1	WERTV8	CURR	15	2	Subcontracting: Total Invoice Receipt Value (Carryforward)
111	LVREW_2VA	☐	CK_LREWV_2	WERTV8	CURR	15	2	Subcontracting: Total Invoice Receipt Value (Carryforward)
112	LVREW_3VA	☐	CK_LREWV_3	WERTV8	CURR	15	2	Subcontracting: Total Invoice Receipt Value (Carryforward)
113	ZPLPR_1	☐	DZPLPR	WERT11	CURR	11	2	Future planned price
114	ZPLPR_2	☐	DZPLPR	WERT11	CURR	11	2	Future planned price
115	ZPLPR_3	☐	DZPLPR	WERT11	CURR	11	2	Future planned price
116	ZKPRS_1	☐	DZKPRS	WERT11	CURR	11	2	Future price
117	ZKPRS_2	☐	DZKPRS	WERT11	CURR	11	2	Future price
118	ZKPRS_3	☐	DZKPRS	WERT11	CURR	11	2	Future price
119	XKONCHK	☐	CK_XKONCHK	CK_XKONCHK	CHAR	1	0	Switch off consistency check
120	XINIT	☐	CK_XINIT	CK_XINIT	CHAR	1	0	Indicator: affected by initialization

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CKML1	MANDT	T000	MANDT		1	CN
2	CKML1	MATLED	TCKM1	MATLED		1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in