EHQMT_MAIN1

EH&S-QM: Subs. Value Assignmt Types for Insp. Plan Creation | #masterdata | Component: Environment, Health, and Safety / Product Compliance
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
Column Name Description
DELFLG Deletion Indicator Show values
PARKFLG Data Record Is Inactive Show values
COMP QM: Composition Show values
Column Name Description Domain name
CRNAM Created By USNAM
UPDNAM Last Changed By USNAM
RECNROOT Sequential Number of Data Record ESDRECN
ZAEHLER Plant for the Master Inspection Characteristic QZAEHLER
ATNAM QM: Name of Characteristic with Value to Specify ATNAM
ATWRT Characteristic Value ATWRT
RECNREF Reference to Reference Specification Header ESDRECN
Master Data Relations Join Conditions
Change Number
  • Change Number
  • Client
  • EHQMT_MAIN1.AENNR == AENR.AENNR
  • EHQMT_MAIN1.MANDT == AENR.MANDT
Value Assignment Type
  • Value Assignment Type
  • Client
  • EHQMT_MAIN1.ESTCAT == TCG11.ESTCAT
  • EHQMT_MAIN1.MANDT == TCG11.MANDT
Client EHQMT_MAIN1.MANDT == T000.MANDT
Master Inspection Characteristic
  • Plant for the Master Inspection Characteristic
  • Client
  • Master Inspection Characteristic
  • ?
  • EHQMT_MAIN1.ZAEHLER == QPMK.ZAEHLER
  • EHQMT_MAIN1.MANDT == QPMK.MANDT
  • EHQMT_MAIN1.MKMNR == QPMK.MKMNR
  • EHQMT_MAIN1.[column in domain "QVERSNRMK"] == QPMK.VERSION
EHS: Foreign Key for Substance Authorization Group
  • EHQMT_MAIN1.MANDT == TCG56.MANDT
  • EHQMT_MAIN1.SRSID == TCG56.SRSID