P_SpecIdfrBscByAppScore1

Private view for basic idfr reading by app (score calc 1) | view: PSPCIDFRBSCAPP1 | Extraction: Not supported | Component: Specification
Tables used: ESTRITCG28/PLMI/SPC_IDLID
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
Column Name Description
SpecIdfgDescIsInheritanceSrce Truth Value Show values
InhtdSpecIdfgDescIsTmpChgd Truth Value Show values
InhtdSpecIdfgDescIsPermChgd Truth Value Show values
SpecificationIdnListingScreen Screen for Identification Listing Show values
SpecificationIdnListingAppl Application for Identification Listing Show values
Column Name Description Domain name
SpecIdfgDescSortSequence Sort Order NUMC4
SpecInheritanceTemplate Sequential Number of Data Record ESDRECN
SpecInheritanceTmplSortSeq Sort Order NUMC4
SpecIdfgDescInheritanceParent Sequential Number of Data Record ESDRECN
SpecIdfgDescInheritanceRoot Sequential Number of Data Record ESDRECN
SpecIdfgDescText Identifier TEXT132
InheritanceScore null
LanguageScore null
SpecificationCategoryScore null
Master Data Relations Join Conditions
Foreign key for identification category P_SPECIDFRBSCBYAPPSCORE1.SPECIDFGDESCCATEGORY == TCG21.IDTYPE
Foreign Key for Language Identifier
  • Language
  • Language
  • P_SPECIDFRBSCBYAPPSCORE1.SPECIDFGDESCLANGUAGEMOD == T002.SPRAS
  • P_SPECIDFRBSCBYAPPSCORE1.SPECIDFGDESCLANGUAGE == T002.SPRAS
Foreign Key for Language Identifier
  • Language
  • Language
  • P_SPECIDFRBSCBYAPPSCORE1.SPECIDFGDESCLANGUAGEMOD == T002.SPRAS
  • P_SPECIDFRBSCBYAPPSCORE1.SPECIDFGDESCLANGUAGE == T002.SPRAS
Identification Type
  • Identification Type
  • Identification Category
  • Client
  • P_SPECIDFRBSCBYAPPSCORE1.SPECIDFGDESCTYPE == TCG23.IDCAT
  • P_SPECIDFRBSCBYAPPSCORE1.SPECIDFGDESCCATEGORY == TCG23.IDTYPE
  • P_SPECIDFRBSCBYAPPSCORE1.MANDT == TCG23.MANDT
Specification Category P_SPECIDFRBSCBYAPPSCORE1.SPECIFICATIONCATEGORY == TCGOBJ.OBJTYPE