SAP table CIF_MD_CHANGES (Changes to BOM, Routing and Production Version)

SAP table CIF_MD_CHANGES has 2 primary key fields being MANDT,GUID.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
GUID UUID in compressed form (22 character UUENCODEd) CHAR 22 0 SYSUUID_22
MDTYPE CIF: Master Data Category CHAR 1 0 CIF_MDTYPE
B Bill of Material
T Routing
V Production Version
MATNR Material Number CHAR 40 0 MATNR
WERKS Plant CHAR 4 0 WERKS_D
VERID Production Version CHAR 4 0 * VERID
PLNTY Task List Type CHAR 1 0 PLNTY
PLNNR Key for Task List Group CHAR 8 0 PLNNR
ALNAL Group Counter CHAR 2 0 PLNAL
STLAL Alternative BOM CHAR 2 0 STLAL
STLAN BOM Usage CHAR 1 0 * STLAN
VBELN Sales Document CHAR 10 0 VBELN_VA
POSNR Sales Document Item NUMC 6 0 POSNR_VA
PSPNR Work Breakdown Structure Element (WBS Element) NUMC 8 0 * PS_PSP_PNR
AEDAT Last Changed On DATS 8 0 AEDAT
CHGTIME Last Changed At TIMS 6 0 UTIME
CHANGE PPM: Change Transfer - Object CHAR 1 0 CIF_CHANGE
1 Production Version Changed
3 Production Version Deleted
PROCESS ALE processing indicator CHAR 1 0 ALE_PROCES
Not processed
X Processed