A_SpecIdentifier

Specification Identifier | view: ASPECIDENT | Extraction: Not supported | Component: Specification
Tables used: ESTRIESTRH/PLMI/SPC_TYPVAL
Column Name Description
SpecIdfgDescInternalID Sequential Number of Data Record
SpecIdfgDescChangeState Sequential Number of the Change State
Column Name Description
Column Name Description
Column Name Description
SpecIdfgDescCreationDate Created On
SpecIdfgDescLastChangeDate Last Changed On
Column Name Description
SpecIdfgDescIsDeleted Deletion Indicator Show values
Column Name Description Domain name
SpecIdfgDescCreatedByUser Created By USNAM
SpecIdfgDescLastChangedByUser Last Changed By USNAM
SpecIdfgDescSortSequence Sort Order NUMC4
SpecIdfgDescText Identifier TEXT132
Master Data Relations Join Conditions
Foreign key for identification category A_SPECIDENTIFIER.SPECIDFGDESCCATEGORY == TCG21.IDTYPE
Foreign Key for Language Identifier A_SPECIDENTIFIER.SPECIDFGDESCLANGUAGE == T002.SPRAS
Identification Type
  • Identification Category
  • Identification Type
  • Client
  • A_SPECIDENTIFIER.SPECIDFGDESCCATEGORY == TCG23.IDTYPE
  • A_SPECIDENTIFIER.SPECIDFGDESCTYPE == TCG23.IDCAT
  • A_SPECIDENTIFIER.MANDT == TCG23.MANDT
Recipe Authorization Group
  • Recipe Authorization Group
  • Client
  • A_SPECIDENTIFIER.SPECIFICATIONAUTHZNGROUP == TCG36.AUTHGRP
  • A_SPECIDENTIFIER.MANDT == TCG36.MANDT
Foreign key for substance type
  • Specification Type
  • Client
  • A_SPECIDENTIFIER.SPECIFICATIONTYPE == TCG31.SUBCAT
  • A_SPECIDENTIFIER.MANDT == TCG31.MANDT