I_SpecIdentifierForKeyDate

Specification on a Key Date | view: ISPECIDFR_KD | Extraction: Not supported | Component: Specification
Tables used: ESTRI
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
SpecIdfgDescValidityStartDate Valid-From Date
SpecIdfgDescValidityEndDate Valid-To Date
SpecIdfgDescCreationDate Created On
SpecIdfgDescLastChangeDate Last Changed On
Column Name Description
SpecIdfgDescIsDeleted Deletion Indicator Show values
SpecIdfgDescIsInheritanceSrce Truth Value Show values
InhtdSpecIdfgDescIsTmpChgd Truth Value Show values
InhtdSpecIdfgDescIsPermChgd Truth Value Show values
Column Name Description Domain name
SpecIdfgDescCreatedByUser Created By USNAM
SpecIdfgDescLastChangedByUser Last Changed By USNAM
SpecIdfgDescSortSequence Sort Order NUMC4
SpecIdfgDescInheritanceParent Sequential Number of Data Record ESDRECN
SpecIdfgDescInheritanceRoot Sequential Number of Data Record ESDRECN
SpecIdfgDescRootSpecIntID Sequential Number of Data Record ESDRECN
SpecInheritanceTemplate Sequential Number of Data Record ESDRECN
SpecInheritanceTmplSortSeq Sort Order NUMC4
SpecIdfgDescText Identifier TEXT132
Master Data Relations Join Conditions
Foreign key for identification category I_SPECIDENTIFIERFORKEYDATE.SPECIDFGDESCCATEGORY == TCG21.IDTYPE
Foreign Key for Change Number
  • Change Number
  • Client
  • I_SPECIDENTIFIERFORKEYDATE.SPECIDFGDESCCHANGENUMBER == AENR.AENNR
  • I_SPECIDENTIFIERFORKEYDATE.MANDT == AENR.MANDT
Foreign Key for Language Identifier I_SPECIDENTIFIERFORKEYDATE.SPECIDFGDESCLANGUAGE == T002.SPRAS
Identification Type
  • Identification Category
  • Client
  • Identification Type
  • I_SPECIDENTIFIERFORKEYDATE.SPECIDFGDESCCATEGORY == TCG23.IDTYPE
  • I_SPECIDENTIFIERFORKEYDATE.MANDT == TCG23.MANDT
  • I_SPECIDENTIFIERFORKEYDATE.SPECIDFGDESCTYPE == TCG23.IDCAT