I_SpecificationPhrase

Specification Phrase | view: ISPCPHRASE | Extraction: Not supported | Component: Specification
Tables used: ESTPH
Column Name Description
SpecPhraseInternalID Specification Phrase Internal ID
SpecPhraseChgIntID Phrase Change State
Column Name Description
Column Name Description
Column Name Description
SpecPhraseValdtyStartDate Valid-From Date
SpecPhraseValdtyEndDate Valid-To Date
SpecPhraseCreationDate Created On
SpecPhraseChangeDate Last Changed On
Column Name Description
SpecPhraseIsDeleted Deletion Indicator Show values
Column Name Description Domain name
SpecPhrase Phrase ID (No conversion exit)
SpecPhraseCreatedByUser Created By USNAM
SpecPhraseLastChangedByUser Last Changed By USNAM
SpecPhraseNote Phrase Note
Master Data Relations Join Conditions
Change Number
  • Client
  • Change Number
  • I_SPECIFICATIONPHRASE.MANDT == AENR.MANDT
  • I_SPECIFICATIONPHRASE.SPECPHRASECHANGENUMBER == AENR.AENNR
Phrase Group
  • Unique phrase library identification
  • Client
  • Phrase Group
  • I_SPECIFICATIONPHRASE.SPECPHRASELIBRARY == TCG63.CATPIN
  • I_SPECIFICATIONPHRASE.MANDT == TCG63.MANDT
  • I_SPECIFICATIONPHRASE.SPECPHRASEGROUP == TCG63.PHRGRP
Language
  • Language
  • Client
  • I_SPECIFICATIONPHRASE.SPECPHRASELANGUAGE == TCG65.PHRLANG
  • I_SPECIFICATIONPHRASE.MANDT == TCG65.MANDT
Unique phrase library identification
  • Unique phrase library identification
  • Client
  • I_SPECIFICATIONPHRASE.SPECPHRASELIBRARY == TCG61.CATPIN
  • I_SPECIFICATIONPHRASE.MANDT == TCG61.MANDT
EHS: Foreign Key for Substance Authorization Group
  • Source of Data
  • Client
  • I_SPECIFICATIONPHRASE.SPECPHRASESOURCE == TCG56.SRSID
  • I_SPECIFICATIONPHRASE.MANDT == TCG56.MANDT