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, /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 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