P_SpecIdfrBscByAppScore2

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_SpecIdfrBscByAppScore2.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PSPCIDFRBSCAPP2
-- Parameters: P_KeyDate : sydate

CREATE VIEW P_SpecIdfrBscByAppScore2 AS
SELECT
  SpecIdfgDescInternalID,
  SpecificationInternalID,
  SpecIdfgDescValidityStartDate,
  SpecIdfgDescValidityEndDate,
  SpecIdfgDescSortSequence,
  SpecIdfgDescIsInheritanceSrce,
  InhtdSpecIdfgDescIsTmpChgd,
  InhtdSpecIdfgDescIsPermChgd,
  SpecInheritanceTemplate,
  SpecIdfgDescInheritanceParent,
  SpecIdfgDescInheritanceRoot,
  SpecIdfgDescCategory,
  SpecIdfgDescType,
  SpecIdfgDescLanguageMod,
  SpecIdfgDescLanguage,
  SpecIdfgDescText,
  SpecificationCategory,
  concat( cast(( 9999 - cast(SpecIdfgDescSortSequence as abap.int4) + InheritanceScore + SpecificationCategoryScore + LanguageScore + P_SpecIdfrBscByAppScore1.SpecificationCategoryScore ) as abap.char(25)) , SpecIdfgDescInternalID ) as Score AS char25SpecIdfgDescInternalIDasScore,
  SpecificationIdnListingScreen,
  SpecificationIdnListingAppl
FROM P_SpecIdfrBscByAppScore1
;