TCGTPLREL

Inheritance Relationships | #masterdata | Component: Product Safety
Column Name Description
MANDT FK Client
RECN Sequential Number of Data Record
ACTN Sequential Number of the Change State
Column Name Description
Column Name Description
Column Name Description
VALFR Valid-From Date
VALTO Valid-To Date
CRDAT Created On
UPDDAT Last Changed On
JOB_REQ_TIM Current Time of an Inheritance Request
JOB_REQ_DAT Date of an Inheritance Request
Column Name Description
DELFLG Deletion Indicator Show values
PARKFLG Data Record Is Inactive Show values
FLG_SRCDEST_REQ Request from Currently Called Specification Show values
APPRV_STAT Approval Status of an Inheritance Request Show values
CONS_STAT Status of an Inheritance Relationship Show values
FLG_INH Inheritance Relationship Is Inactive Show values
FLG_SUBCPY Relationship Is Not Relevant for Inheritance Show values
ESNTFLG Relevant Change Has Been Made Show values
Column Name Description Domain name
CRNAM Created By USNAM
UPDNAM Last Changed By USNAM
RECNROOT Sequential Number of Data Record ESDRECN
RECNROOT_SRC Sequential Number of Data Record ESDRECN
RECNROOT_DST Sequential Number of Data Record ESDRECN
RECN_TPLH Sequential Number of Data Record ESDRECN
CRTMSTMP UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
UPDTMSTMP UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
Master Data Relations Join Conditions
Change Number
  • Change Number
  • Client
  • TCGTPLREL.AENNR == AENR.AENNR
  • TCGTPLREL.MANDT == AENR.MANDT
Client TCGTPLREL.MANDT == T000.MANDT
EHS: Foreign Key for Substance Authorization Group
  • TCGTPLREL.MANDT == TCG56.MANDT
  • TCGTPLREL.SRSID == TCG56.SRSID