ESH_N_CHANGE_RECORD_H

Anchor view -CHANGE_RECORD_H | view: ESH_L_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	PLNNR
INSPPLNRECIPEGROUP	Recipe Group key	PLNNR
RECIPEGROUP	Recipe Group key	PLNNR
BILLOFOPERATIONSGROUP	Key for Task List Group	PLNNR
TMPLRTGGROUP	Key for Task List Group	PLNNR
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)	TZNTSTMPS
DOCUMENTDESCRIPTION	Document Description	TEXT40
DOCUMENTINFORECORD	Document number	DOKNR
ISSACTYMGMTUSERSTATUSTEXT	Status Text	/IAM/USER_STATUS_TXT
LASTCHANGEDATETIME	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	TZNTSTMPS
LOGACCMOBJECTTYPE	Object Type	/PLMB/GOS_OBJECT_TYPE
MANUFACTURINGORDER	Manufacturing Order ID	AUFNR
MATERIALOFPSV	Product Number	MATNR
MATERIAL	Material Number	MATNR
MATERIALOFRTG	Material Number	MATNR
MATERIALNAME	Material Description	TEXT40
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	TEXT40
PRODUCTSTRUCTURENODENAME	iPPE Node Description	PVS_PNODE
PRODUCTSTRUCTUREVARIANTNAME	Variant	PVS_POSVAR
PURCHASEORDER	Purchase Order Number	EBELN
SOURCEMATERIAL	Material Number	MATNR
TARGETMATERIAL	Material Number	MATNR

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