SAP CIF_MD_CHANGES Changes to BOM, Routing and Production Version Table data and field list

CIF_MD_CHANGES is a standard SAP Table which is used to store Changes to BOM, Routing and Production Version data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The CIF_MD_CHANGES table consists of various fields, each holding specific information or linking keys about Changes to BOM, Routing and Production Version data available in SAP. These include GUID (UUID in compressed form (22 character UUENCODEd)), MDTYPE (CIF: Master Data Category), MATNR (Material Number), WERKS (Plant)... 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. .

CIF_MD_CHANGES table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified

SAP CIF_MD_CHANGES table 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 CIF_MD_CHANGES 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
MANDT	Client	MANDT	CLNT	3	Assigned to domain		MANDT
GUID	UUID in compressed form (22 character UUENCODEd)	SYSUUID_22	CHAR	22			SYSUUID_22
MDTYPE	CIF: Master Data Category	CIF_MDTYPE	CHAR	1			CIF_MDTYPE
MATNR	Material Number	MATNR	CHAR	18	Assigned to domain	MATN1	MATNR	MAT	S_MAT1
WERKS	Plant	WERKS_D	CHAR	4	Assigned to domain		WERKS	WRK	H_T001W_C
VERID	Production Version	VERID	CHAR	4	Assigned to domain		VERID	VER
PLNTY	Task List Type	PLNTY	CHAR	1	Assigned to domain		PLNTY	PTY	H_TCA01
PLNNR	Key for Task List Group	PLNNR	CHAR	8		ALPHA	PLNNR	PLN	PLKS
ALNAL	Group Counter	PLNAL	CHAR	2		ALPHA	ALTNR	PAL
STLAL	Alternative BOM	STLAL	CHAR	2		ALPHA	ALTNR
STLAN	BOM Usage	STLAN	CHAR	1	Assigned to domain		STLAN	CSV
VBELN	Sales Document	VBELN_VA	CHAR	10	Assigned to domain	ALPHA	VBELN	AUN
POSNR	Sales Document Item	POSNR_VA	NUMC	6	Assigned to domain		POSNR	APO
PSPNR	Work Breakdown Structure Element (WBS Element)	PS_PSP_PNR	NUMC	8	Assigned to domain	KONPR	PS_POSNR
AEDAT	Changed On	AEDAT	DATS	8			DATUM
CHGTIME	Time of Last Change	UTIME	TIMS	6			UZEIT
CHANGE	PPM: Change Transfer - Object	CIF_CHANGE	CHAR	1			CIF_CHANGE
PROCESS	ALE processing indicator	ALE_PROCES	CHAR	1			ALE_PROCES

Key field

Non-key field

< CIF_MDCHGS - Changes to BOM, Routing and Production Version CIF_MEAN - Outbound Structure for multiple EANs >

How do I retrieve data from SAP table CIF_MD_CHANGES using ABAP code

The following ABAP code Example will allow you to do a basic selection on CIF_MD_CHANGES to SELECT all data from the table
DATA: WA_CIF_MD_CHANGES TYPE CIF_MD_CHANGES.

SELECT SINGLE *
FROM CIF_MD_CHANGES
INTO CORRESPONDING FIELDS OF WA_CIF_MD_CHANGES
WHERE...

How to access SAP table CIF_MD_CHANGES

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

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