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, /IAM/D_I_ROOT, /PLMI/CR_ITM_EXT, /IAM/D_I_OBJ_REF, /IAM/D_I_ROOT, /IAM/D_I_OBJ_REF, /IAM/D_I_ROOT, /PLMI/CR_ITM_EXT, /IAM/D_I_OBJ_REF, /IAM/D_I_ROOT, /PLMI/CR_ITM_EXT, /IAM/D_I_OBJ_REF, /IAM/D_I_ROOT, /PLMI/CR_ITM_EXT, /IAM/D_I_OBJ_REF, /IAM/D_I_ROOT, /PLMI/CR_ITM_EXT, /IAM/D_I_OBJ_REF, /IAM/D_I_ROOT, /PLMI/CR_ITM_EXT, /IAM/D_I_OBJ_REF, /IAM/D_I_ROOT, /IAM/D_I_OBJ_REF, /IAM/D_I_ROOT, /IAM/D_I_OBJ_REF, /IAM/D_I_ROOT, /IAM/D_I_OBJ_REF, /IAM/D_I_ROOT, /IAM/D_I_OBJ_REF, /IAM/D_I_ROOT, /IAM/D_I_OBJ_REF, /IAM/D_I_ROOT, /IAM/D_I_OBJ_REF, /IAM/D_I_ROOT, 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, 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, MARA, MAST, MAKT, T416, T001W, VMP_PLNSCP_HDR, CPNTYPE, CPVTYPE, POSVID, AENR, PVCMP, PVCMPD, PVCMPP, MARA, MKAL, T141, T141T, PNODID, PNODTX, POSVTX, MAKT, T134, T134T, T006, T006A, USR21, ADCP, ADR2, ADR3, ADR6, ADRP, USR21, CRHD, BUT021_FS, TB008S, TB008U, STKO, STZU, DOST, DRAW, DRAW_LAST_CHANGE, MKAL_AEND, 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, /PLMI/PPE_C_I2G
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