SAP CMDC0_5_ALV Structure for SD_CMDC0 Table data and field list

CMDC0_5_ALV is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Structure for SD_CMDC0" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_CMDC0_5_ALV TYPE CMDC0_5_ALV.

The CMDC0_5_ALV table consists of various fields, each holding specific information or linking keys about Structure for SD_CMDC0 data available in SAP. These include KSCHL (Condition Type), KNUMH (Condition record number), DATAB (Validity start date of the condition record), DATBI (Validity end date of the condition record)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

CMDC0_5_ALV structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)

SAP CMDC0_5_ALV structure fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the CMDC0_5_ALV table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
KOTABNR	Condition table	KOTABNR	NUMC	3	Assigned to domain		KOTABNR	KON
KSCHL	Condition Type	KSCHL	CHAR	4	Assigned to domain		KSCHL	VKS
KNUMH	Condition record number	KNUMH	CHAR	10			KNUMB
DATAB	Validity start date of the condition record	KODATAB	DATS	8			DATUM
DATBI	Validity end date of the condition record	KODATBI	DATS	8			DATUM
IKNUMH	Condition record number	KNUMH	CHAR	10			KNUMB
IDATAB	Valid-From Date	DATAB	DATS	8			DATUM
IDATBI	Valid To Date	DATBI	DATS	8			DATUM
REMARK	Error message text - long text of the error	TEXT70	CHAR	70			TEXT70
HVAKEY	Variable key 100 bytes	VAKEY	CHAR	100			VAKEY
VAKEY	Variable key 100 bytes	VAKEY	CHAR	100			VAKEY

Key field

Non-key field

< CMDC0_4_ALV - Structure for SD_CMDC0 CMDC0_6_ALV - Structure for SD_CMDC0 >

How do I retrieve data from SAP structure CMDC0_5_ALV using ABAP code?

As CMDC0_5_ALV is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on CMDC0_5_ALV as there is no data to select.

How to access SAP table CMDC0_5_ALV

Within an ECC or HANA version of SAP you can also view further information about CMDC0_5_ALV and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).