SAP ABAP Table CKML_MULTI_TREE (Structure for Displaying Multilevel Document as ALV Tree)

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	INTTAB	Structure
Structure	CKML_MULTI_TREE	Table Relationship Diagram
Short Description	Structure for Displaying Multilevel Document as ALV Tree

Delivery and Maintenance

Pool/cluster
Delivery Class
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	LEVEL	☐	INT1	INT1	INT1	3	0	Dummy for B20 int1 (Local Everywhere)
2	NODE_KEY	☐	LVC_NKEY		CHAR	12	0	ALV Tree Control: Node Key
3	HTEXT	☐	LVC_VALUE	TEXT128	CHAR	128	0	ALV Control: Cell Content
4	BVALT_NAME	☐	CKML_N_BALT	TEXT50	CHAR	50	0	Procurement Alternative
5	PROCESS_NAME	☐	CKML_N_PROC	TEXT50	CHAR	50	0	Procurement Process
6	VNPRD_EA	☐	CK_VNPRDEA	WERTV8	CURR	15	2	Single-level adjustment to consumption from price difference
7	VNKDM_EA	☐	CK_VNKDMEA	WERTV8	CURR	15	2	Single-level adjustment to consumption from ExRt differences
8	VNPRD_MA	☐	CK_VNPRDMA	WERTV8	CURR	15	2	Multilevel adjustment to consumption from price differences
9	VNKDM_MA	☐	CK_VNKDMMA	WERTV8	CURR	15	2	Multilevel adjustment to consumption from exch. rt. diff.
10	EBPRD_MA	☐	CK_EBPRDMA	WERTV8	CURR	15	2	Multilevel Adjustment to End. Inv. Due to Price Differences
11	EBKDM_MA	☐	CK_EBKDMMA	WERTV8	CURR	15	2	Multilevel Adjustment to Ending Inv. Due to Exch. Rate Diff.
12	ZUPRD_MO	☐	CK_ZUPRDMO	WERTV8	CURR	15	2	Receipts: Price Differences from Lower Levels
13	ZUKDM_MO	☐	CK_ZUKDMMO	WERTV8	CURR	15	2	Receipts: Exchange rate differences from lower level
14	ABPRD_MO	☐	CK_ABPRDMO	WERTV8	CURR	15	2	Beginning Inventory: Price Differences from Lower Levels
15	ABKDM_MO	☐	CK_ABKDMMO	WERTV8	CURR	15	2	Beginning Inventory: Exch.Rate Differences from Lower Levels
16	MULTILEVEL_DIF	☐	KKB_ML_ABWE_M	WERTV8	CURR	15	2	Multilevel Differences
17	SINGLELEVEL_DIF	☐	KKB_ML_ABWE_E	WERTV8	CURR	15	2	Single-Level Differences
18	SUM_PRDIF	☐	CK_SUM_PRDIF	WERTV8	CURR	15	2	Sum of all price differences (settled single-/multi-level)
19	SUM_KRDIF	☐	CK_SUM_KRDIF	WERTV8	CURR	15	2	Sum of all exchange rate differences (single-/multi-level)
20	SUM_DIF	☐	CK_SUM_DIF	WERTV8	CURR	15	2	Sum of differences (settled sngl/multi-lvl price/ExRt diff.)
21	ABRMENGE	☐	CK_ABRMENGE	MENGV8	QUAN	15	3	Price Determination Quantity
22	MODIF	☐	CK_MODIF	CK_MODIF	CHAR	1	0	Type of BOM item
23	KTEXT	☐	KTEXT	TEXT20	CHAR	20	0	General Name
24	LTEXT	☐	KLTXT	TEXT40	CHAR	40	0	Description
25	OBART	☐	J_OBART	J_OBART	CHAR	2	0	Object Type	*
26	.INCLUDE	☐				0	0	Material Ledger Document: Structure for Overview Screen
27	.INCLUDE	☐				0	0	Material Ledger Document: Items
28	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
29	BELNR	☐	CK_BELNR	BELNR	CHAR	10	0	Number of a Material Ledger Document/Price Change Document
30	KJAHR	☐	CK_KJAHR	GJAHR	NUMC	4	0	Material Ledger Document/Price Change Document: Storage Year
31	POSNR	☐	CK_MLPOS	NUMC6	NUMC	6	0	Item in Material Ledger Document
32	URZEILE	☐	CK_URZEILE	NUMC6	NUMC	6	0	Original item in material or invoice document
33	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
34	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	T149D
35	BWKEY	☐	BWKEY	BWKEY	CHAR	4	0	Valuation area	T001K
36	KALNR	☐	CK_KALNR	CK_KALNR	NUMC	12	0	Cost Estimate Number for Cost Est. w/o Qty Structure	*
37	MEINS	☐	CKML_MEINS	MEINS	UNIT	3	0	Unit of Measure for Material Valuation	T006
38	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
39	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
40	BWMOD	☐	BWMOD	CHAR4	CHAR	4	0	Valuation grouping code
41	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
42	KTOPL	☐	KTOPL	KTOPL	CHAR	4	0	Chart of Accounts	T004
43	MLAST	☐	CK_ML_ABST	CK_ML_ABST	CHAR	1	0	Material Price Determination: Control
44	PSART	☐	CK_PSART	CK_VGART	CHAR	2	0	Item type in material ledger document
45	BELNR_EA	☐	CK_BELNR	BELNR	CHAR	10	0	Number of a Material Ledger Document/Price Change Document
46	KJAHR_EA	☐	CK_KJAHR	GJAHR	NUMC	4	0	Material Ledger Document/Price Change Document: Storage Year
47	BELNR_MA	☐	CK_BELNR	BELNR	CHAR	10	0	Number of a Material Ledger Document/Price Change Document
48	KJAHR_MA	☐	CK_KJAHR	GJAHR	NUMC	4	0	Material Ledger Document/Price Change Document: Storage Year
49	ASCHEMA	☐	CKML_ASCHEMA	CKML_ASCHEMA	CHAR	4	0	Material Update Structure	*
50	PTYP	☐	CK_PTYP_ORG	CKML_PROZESS_TYP	CHAR	4	0	Original process category	*
51	PTYP_KAT	☐	CK_PTYP_KAT	CKML_PROZESS_TYP	CHAR	4	0	Process category for category determination	*
52	PTYP_BVALT	☐	CK_PTYP_BVALT	CKML_PROZESS_TYP	CHAR	4	0	Process category for procurement alt. or consuption alt.	*
53	PTYP_PROC	☐	CK_PTYP_PROC	CKML_PROZESS_TYP	CHAR	4	0	Process category of the process	*
54	BEWARTGRP	☐	CKML_MLBWG	CKML_MLBWG	CHAR	2	0	Movement Type Group for ML Update	*
55	KATEGORIE	☐	CKML_KATEGORIE	CKML_KATEGORIE	CHAR	2	0	Category in Material Update Structure
56	BVALT	☐	CKML_ALPROCNR	CK_KALNR	NUMC	12	0	Procurement alternative/process	*
57	PROCESS	☐	CKML_F_PROCNR	CK_KALNR	NUMC	12	0	Production Process	*
58	CSPLIT	☐	CSPLIT	CSPLIT	CHAR	4	0	Apportionment structure	*
59	VBELN	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	*
60	VBELP	☐	POSNR	POSNR	NUMC	6	0	Item number of the SD document	*
61	PSPNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
62	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
63	KZBWS	☐	KZBWS	KZBWS	CHAR	1	0	Valuation of Special Stock
64	XOBEW	☐	XOBEW	XFELD	CHAR	1	0	Vendor Stock Valuation Indicator
65	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	*
66	XABRERR	☐	CK_XABRERR	CK_XERROR	CHAR	1	0	Indicates that error(s) occurred during last price determ.
67	BELNR_CONS	☐	CK_BELNR	BELNR	CHAR	10	0	Number of a Material Ledger Document/Price Change Document
68	KJAHR_CONS	☐	CK_KJAHR	GJAHR	NUMC	4	0	Material Ledger Document/Price Change Document: Storage Year
69	BELNR_WIP	☐	CK_BELNR	BELNR	CHAR	10	0	Number of a Material Ledger Document/Price Change Document
70	KJAHR_WIP	☐	CK_KJAHR	GJAHR	NUMC	4	0	Material Ledger Document/Price Change Document: Storage Year
71	MAKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description
72	BDATJ	☐	BDATJ	GJAHR	NUMC	4	0	Posting Date YYYY
73	POPER	☐	POPER	POPER	NUMC	3	0	Posting period
74	LBKUM	☐	CK_LBKUMD	MENGV8	QUAN	15	3	Quantity by which the total valuated inventory has changed
75	CURTP	☐	CURTP	CURTP	CHAR	2	0	Currency type and valuation view
76	SALK3	☐	CK_SALK3D	WERTV8	CURR	15	2	Amount by which the total valuated inventory changes
77	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CKML_MULTI_TREE	BUKRS	T001	BUKRS	REF	1	CN
2	CKML_MULTI_TREE	BWKEY	T001K	BWKEY	REF	1	CN
3	CKML_MULTI_TREE	BWTAR	T149D	BWTAR	REF	C	CN
4	CKML_MULTI_TREE	KTOPL	T004	KTOPL	REF	1	CN
5	CKML_MULTI_TREE	MANDT	T000	MANDT	KEY	1	CN
6	CKML_MULTI_TREE	MATNR	MARA	MATNR	REF	1	CN
7	CKML_MULTI_TREE	MEINS	T006	MSEHI	REF	C	CN
8	CKML_MULTI_TREE	SPART	TSPA	SPART	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in