I_SpecPhraseSetPhraseAssgmt

Specification Phrase Set Phrase Assignment | view: ISPCPHRSETASM | Extraction: Not supported | Component: Specification
Tables used: ESTPJ
Column Name Description
SpecPhraseAssgmtInternalID Phrase Set - Phrase Assignment Internal ID
SpecPhraseAssgmtChgIntID Phrase Set - Phrase Assignment Change State
Column Name Description
Column Name Description
Column Name Description
SpecPhraseAssgmtValdtyStartDte Valid-From Date
SpecPhraseAssgmtValdtyEndDate Valid-To Date
SpecPhraseAssgmtCreationDate Created On
SpecPhraseAssgmtChangeDate Last Changed On
Column Name Description
SpecPhraseAssgmtIsDeleted Deletion Indicator Show values
Column Name Description Domain name
SpecPhraseAssgmtCreatedByUsr Created By USNAM
SpecPhraseAssgmtLastChgdByUsr Last Changed By USNAM
SpecPhraseSetInternalID Phrase Set Internal ID ESDRECN
SpecPhraseInternalID Specification Phrase Internal ID ESDRECN
SpecPhraseAssgmtSortSequence Sort Order NUMC4
Master Data Relations Join Conditions
Change Number
  • Change Number
  • Client
  • I_SPECPHRASESETPHRASEASSGMT.SPECPHRASEASSGMTCHANGENUMBER == AENR.AENNR
  • I_SPECPHRASESETPHRASEASSGMT.MANDT == AENR.MANDT
EHS: Foreign Key for Substance Authorization Group
  • Source of Data
  • Client
  • I_SPECPHRASESETPHRASEASSGMT.SPECPHRASEASSGMTSOURCE == TCG56.SRSID
  • I_SPECPHRASESETPHRASEASSGMT.MANDT == TCG56.MANDT