I_SpecIdfrBscByAppForKeyDate

Specification Basic Identifier by Appl. for Key Date | view: IFRCPIDFRSCR | Extraction: Not supported | Component: Specification
Tables used: ESTRITCG28/PLMI/SPC_IDLID
Column Name Description
SpecificationInternalID FK Sequential Number of Data Record
SpecificationIdnListingAppl Application for Identification Listing Show values
SpecificationIdnListingScreen Screen for Identification Listing Show values
Column Name Description
Column Name Description
Column Name Description
SpecIdfgDescValidityStartDate Valid-From Date
SpecIdfgDescValidityEndDate Valid-To Date
Column Name Description
SpecificationIdnListingAppl Application for Identification Listing Show values
SpecificationIdnListingScreen Screen for Identification Listing Show values
Column Name Description Domain name
SpecIdfgDescInternalID Sequential Number of Data Record ESDRECN
SpecIdfgDescText Identifier TEXT132
Master Data Relations Join Conditions
Foreign key for identification category I_SPECIDFRBSCBYAPPFORKEYDATE.SPECIDFGDESCCATEGORY == TCG21.IDTYPE
Identification Type
  • Identification Category
  • Identification Type
  • Client
  • I_SPECIDFRBSCBYAPPFORKEYDATE.SPECIDFGDESCCATEGORY == TCG23.IDTYPE
  • I_SPECIDFRBSCBYAPPFORKEYDATE.SPECIDFGDESCTYPE == TCG23.IDCAT
  • I_SPECIDFRBSCBYAPPFORKEYDATE.MANDT == TCG23.MANDT