P_SpecIdfrBscByAppScore2

Private view for basic idfr reading by app (score calc 2) | view: PSPCIDFRBSCAPP2 | 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
SpecIdfgDescInheritanceParent Sequential Number of Data Record ESDRECN
SpecIdfgDescInheritanceRoot Sequential Number of Data Record ESDRECN
SpecIdfgDescText Identifier TEXT132
Score null
Master Data Relations Join Conditions
Foreign key for identification category P_SPECIDFRBSCBYAPPSCORE2.SPECIDFGDESCCATEGORY == TCG21.IDTYPE
Foreign Key for Language Identifier
  • Language
  • Language
  • P_SPECIDFRBSCBYAPPSCORE2.SPECIDFGDESCLANGUAGEMOD == T002.SPRAS
  • P_SPECIDFRBSCBYAPPSCORE2.SPECIDFGDESCLANGUAGE == T002.SPRAS
Foreign Key for Language Identifier
  • Language
  • Language
  • P_SPECIDFRBSCBYAPPSCORE2.SPECIDFGDESCLANGUAGEMOD == T002.SPRAS
  • P_SPECIDFRBSCBYAPPSCORE2.SPECIDFGDESCLANGUAGE == T002.SPRAS
Identification Type
  • Client
  • Identification Type
  • Identification Category
  • P_SPECIDFRBSCBYAPPSCORE2.MANDT == TCG23.MANDT
  • P_SPECIDFRBSCBYAPPSCORE2.SPECIDFGDESCTYPE == TCG23.IDCAT
  • P_SPECIDFRBSCBYAPPSCORE2.SPECIDFGDESCCATEGORY == TCG23.IDTYPE
Specification Category P_SPECIDFRBSCBYAPPSCORE2.SPECIFICATIONCATEGORY == TCGOBJ.OBJTYPE