ESH_S_CHANGE_RECORD_H

Search view -CHANGE_RECORD_H | view: ESH_U_CHGRCDH | Extraction: Not supported | Component: Change Record

Tables used: /IAM/D_I_DESC, /IAM/D_I_DESC_TX, /IAM/D_I_PARTY, /IAM/D_I_ROOT, /PLMI/CR_HDR_EXT, /IAM/D_I_OBJ_REF, /PLMI/CR_ITM_EXT, DRAT, /PLMB/AUTH_OBSID, /PLMB/AUTH_SIDRP, /PLMB/AUTH_UGUSR, /PLMB/AUTH_UGSID, AFKO, AFPO, MPE_EXEC_HOLD, EKKO, MARA, ADCP, ADRC, ADR6, ADR2, T416T, PLKZ, PLKO, PLVK, PLMB, BUT020, BUT021_FS, BUT000, BUT100, AENR, HRP7600, /IAM/C_ISSUETYP, /IAM/C_ISSUETYPT, /IAM/C_STATA_T, /PLMI/CR_MRG_STS, KLAH, DRAW, TDWS, TDWST, MPE_MEC_EBOM_INC, T416, /IAM/C_STAT, /IAM/C_STAT_T, UST10S, UST12, AUFK, MAST, MAKT, T001W, VMP_PLNSCP_HDR, CPNTYPE, CPVTYPE, POSVID, PVCMP, PVCMPD, PVCMPP, MKAL, T141, T141T, PNODID, PNODTX, POSVTX, T134, T134T, T006, T006A, USR21, ADR3, ADRP, CRHD, TB008S, TB008U, STKO, STZU, DOST, DRAW_LAST_CHANGE, MKAL_AEND, /PLMI/CR_TYPE, /IAM/C_ISS_REFOB, /PLMI/CR_STA_PF, AGR_1016, /PLMB/AUTH_OT_AC, /PLMB/AUTH_ACT_E, T416_CTRL_DATA, /PLMI/PPE_C_I2G

🔑 Keys (1)
💰 Amounts
∑ Quantities
📅 Dates (1)
☰ Categorical (5)
Other (43)
🔗 Relations (8)

Column Name	Description
CHANGERECORDUUID	NodeID

Column Name	Description

Column Name	Description

Column Name	Description
CHGRECDEXPECTEDCOMPLETIONDATE	Expected Completion Date

Column Name	Description
INSPPLNPROCGSTATUS	Item Processing Status	Show values
CHANGERECORDITEMPROCGSTATUS	Item Processing Status	Show values
CHANGERECORDLIFECYCLESTATUS	Issue Lifecycle Status Code	Show values
ISBUSINESSPURPOSECOMPLETED	Business Purpose Completed Flag	Show values
LOGACCMOBJECTTYPEISACTIVE	Access Control Activated for Object Type	Show values

Column Name	Description	Domain name
BILLOFMATERIAL	Bill of Material	STNUM
PLNGRTGGROUP	Key for Task List Group
INSPPLNRECIPEGROUP	Recipe Group key	PLNNR
RECIPEGROUP	Recipe Group key	PLNNR
BILLOFOPERATIONSGROUP	Key for Task List Group
TMPLRTGGROUP	Key for Task List Group
BILLOFOPERATIONSVARIANT	Recipe	ALTNR
RECIPE	Recipe	ALTNR
CHANGENUMBER	Change Number	AENNR
CHANGENUMBERDESCRIPTION	Change number description	CC_TEXT40
CHANGERECORD	Change Record ID	/PLMB/CR_ID
NEWPRODUCTVARIANT	Reference Object ID
NEWDOCUMENTID	Reference Object ID
NEWMATERIALIDOFBOM	Reference Object ID
NEWMATERIALID	Reference Object ID
CHANGERECORDSTATUS	Change Record Header Status	/PLMB/CR_HDR_STATUS
INSPPLNRECORDTYPE	Change Record Type	/IAM/ISSUE_TYPE
RECORDTYPE	Change Record Type	/IAM/ISSUE_TYPE
CHANGERECORDTYPE	Change Record Type	/IAM/ISSUE_TYPE
CHANGERECORDTYPEDESC	Description of Record Type	/IAM/DESCRIPTION
CHGRECORDDESCRIPTIONTEXT	Change Record Header Description	/PLMB/CR_HDR_DESC
CLASS	Class number	KLASSE
CREATIONDATETIME	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
DOCUMENTDESCRIPTION	Document Description
DOCUMENTINFORECORD	Document number	DOKNR
ISSACTYMGMTUSERSTATUSTEXT	Status Text	/IAM/USER_STATUS_TXT
LASTCHANGEDATETIME	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
LOGACCMOBJECTTYPE	Object Type	/PLMB/GOS_OBJECT_TYPE
MANUFACTURINGORDER	Manufacturing Order ID	AUFNR
MATERIALOFPSV	Product Number
MATERIAL	Material Number
MATERIALOFRTG	Material Number
MATERIALNAME	Material Description
PARTNER	Change Record Change Responsible (Person)	/PLMB/CR_CHG_RESPONSIBLE
PERSONFULLNAME	Full Name	TEXT80
PLANNINGSCOPEDESCRIPTION	Planning Scope Description	TEXT40
PRODSTRUCVARIANTCHANGENUMBER	Change Number in iPPE	PPE_AENNR
PRODUCTNAME	Product Description
PRODUCTSTRUCTURENODENAME	iPPE Node Description
PRODUCTSTRUCTUREVARIANTNAME	Variant
PURCHASEORDER	Purchase Order Number	EBELN
SOURCEMATERIAL	Material Number
TARGETMATERIAL	Material Number

Master Data Relations	Join Conditions
Authorization Group ? Authorization Group Client	`ESH_S_CHANGE_RECORD_H.[column in domain "BU_AUOBJ"] == TB037.AUOBJ` `ESH_S_CHANGE_RECORD_H.AUTHORIZATIONGROUP == TB037.AUGRP` `ESH_S_CHANGE_RECORD_H.MANDT == TB037.CLIENT`
Material Number Client Material Number Material Number for Order Material Number Material Number Material Number Material Number Product Number	`ESH_S_CHANGE_RECORD_H.MANDT == MARA.MANDT` `ESH_S_CHANGE_RECORD_H.MATERIALOFBOM == MARA.MATNR` `ESH_S_CHANGE_RECORD_H.MATERIALOFPRODNORD == MARA.MATNR` `ESH_S_CHANGE_RECORD_H.MATERIAL == MARA.MATNR` `ESH_S_CHANGE_RECORD_H.MATERIALOFEBOM == MARA.MATNR` `ESH_S_CHANGE_RECORD_H.MATERIALOFMBOM == MARA.MATNR` `ESH_S_CHANGE_RECORD_H.MATERIALOFRTG == MARA.MATNR` `ESH_S_CHANGE_RECORD_H.MATERIALOFPSV == MARA.MATNR`
Material Number Client Material Number Material Number for Order Material Number Material Number Material Number Material Number Product Number	`ESH_S_CHANGE_RECORD_H.MANDT == MARA.MANDT` `ESH_S_CHANGE_RECORD_H.MATERIALOFBOM == MARA.MATNR` `ESH_S_CHANGE_RECORD_H.MATERIALOFPRODNORD == MARA.MATNR` `ESH_S_CHANGE_RECORD_H.MATERIAL == MARA.MATNR` `ESH_S_CHANGE_RECORD_H.MATERIALOFEBOM == MARA.MATNR` `ESH_S_CHANGE_RECORD_H.MATERIALOFMBOM == MARA.MATNR` `ESH_S_CHANGE_RECORD_H.MATERIALOFRTG == MARA.MATNR` `ESH_S_CHANGE_RECORD_H.MATERIALOFPSV == MARA.MATNR`
Material Number Client Material Number Material Number for Order Material Number Material Number Material Number Material Number Product Number	`ESH_S_CHANGE_RECORD_H.MANDT == MARA.MANDT` `ESH_S_CHANGE_RECORD_H.MATERIALOFBOM == MARA.MATNR` `ESH_S_CHANGE_RECORD_H.MATERIALOFPRODNORD == MARA.MATNR` `ESH_S_CHANGE_RECORD_H.MATERIAL == MARA.MATNR` `ESH_S_CHANGE_RECORD_H.MATERIALOFEBOM == MARA.MATNR` `ESH_S_CHANGE_RECORD_H.MATERIALOFMBOM == MARA.MATNR` `ESH_S_CHANGE_RECORD_H.MATERIALOFRTG == MARA.MATNR` `ESH_S_CHANGE_RECORD_H.MATERIALOFPSV == MARA.MATNR`
Material Number for Order Client Material Number Material Number for Order Material Number Material Number Material Number Material Number Product Number	`ESH_S_CHANGE_RECORD_H.MANDT == MARA.MANDT` `ESH_S_CHANGE_RECORD_H.MATERIALOFBOM == MARA.MATNR` `ESH_S_CHANGE_RECORD_H.MATERIALOFPRODNORD == MARA.MATNR` `ESH_S_CHANGE_RECORD_H.MATERIAL == MARA.MATNR` `ESH_S_CHANGE_RECORD_H.MATERIALOFEBOM == MARA.MATNR` `ESH_S_CHANGE_RECORD_H.MATERIALOFMBOM == MARA.MATNR` `ESH_S_CHANGE_RECORD_H.MATERIALOFRTG == MARA.MATNR` `ESH_S_CHANGE_RECORD_H.MATERIALOFPSV == MARA.MATNR`
Plant Client Plant Plant	`ESH_S_CHANGE_RECORD_H.MANDT == T001W.MANDT` `ESH_S_CHANGE_RECORD_H.PLANTOFEBOM == T001W.WERKS` `ESH_S_CHANGE_RECORD_H.PLANTOFMBOM == T001W.WERKS`
Plant Client Plant Plant	`ESH_S_CHANGE_RECORD_H.MANDT == T001W.MANDT` `ESH_S_CHANGE_RECORD_H.PLANTOFEBOM == T001W.WERKS` `ESH_S_CHANGE_RECORD_H.PLANTOFMBOM == T001W.WERKS`
Supplier Client Supplier	`ESH_S_CHANGE_RECORD_H.MANDT == LFA1.MANDT` `ESH_S_CHANGE_RECORD_H.SUPPLIER == LFA1.LIFNR`