P_BasicDescForReldRglnScore

DDL: P_BASICDESCFORRELDRGLNSCORE Type: view COMPOSITE
6 Fields 2 Data Sources

P_BasicDescForReldRglnScore is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_CmplRqRslt, I_CmplRqRsltDngrsGdsBscDescT) and exposes 6 fields with key fields ChmlCmplncInfoUUID, CmplRqRsltUUID, Language, LanguageEthen10else0endasFallbackScore.

Data Sources (2)

SourceAliasJoin Type
I_CmplRqRslt I_CmplRqRslt from
I_CmplRqRsltDngrsGdsBscDescT I_CmplRqRsltDngrsGdsBscDescT inner

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PDGBDSCFRRS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY ChmlCmplncInfoUUID I_CmplRqRslt ChmlCmplncInfoUUID Chemical Compliance Information PP
KEY CmplRqRsltUUID I_CmplRqRslt CmplRqRsltUUID SDS Assessment
KEY Language I_CmplRqRsltDngrsGdsBscDescT Language Report Text Language
KEY LanguageEthen10else0endasFallbackScore
CmplRqVersUUID I_CmplRqRslt CmplRqVersUUID NodeID
DangerousGoodBasicDescription I_CmplRqRsltDngrsGdsBscDescT DangerousGoodBasicDescription Dangerous Goods Basic Description

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_BasicDescForReldRglnScore.
-- 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.

CREATE VIEW P_BasicDescForReldRglnScore AS
SELECT
  I_CmplRqRslt.ChmlCmplncInfoUUID AS ChmlCmplncInfoUUID,
  I_CmplRqRslt.CmplRqRsltUUID AS CmplRqRsltUUID,
  I_CmplRqRsltDngrsGdsBscDescT.Language AS Language,
  case when I_CmplRqRslt.ComplianceRequirement = 'UNRTDG' and I_CmplRqRsltDngrsGdsBscDescT.Language = $session.system_language then 51 when I_CmplRqRslt.ComplianceRequirement = 'UNRTDG' and I_CmplRqRsltDngrsGdsBscDescT.Language = 'E' then 50 when I_CmplRqRslt.ComplianceRequirement = 'IMDG-Code' and I_CmplRqRsltDngrsGdsBscDescT.Language = 'E' then 40 when I_CmplRqRslt.ComplianceRequirement = 'ADR' and I_CmplRqRsltDngrsGdsBscDescT.Language = $session.system_language then 31 when I_CmplRqRslt.ComplianceRequirement = 'ADR' and I_CmplRqRsltDngrsGdsBscDescT.Language = 'E' then 30 when I_CmplRqRslt.ComplianceRequirement = '49 CFR' and I_CmplRqRsltDngrsGdsBscDescT.Language = $session.system_language then 21 when I_CmplRqRsltDngrsGdsBscDescT.Language = 'E' then 10 else 0 end as FallbackScore AS LanguageEthen10else0endasFallbackScore,
  I_CmplRqRslt.CmplRqVersUUID AS CmplRqVersUUID,
  I_CmplRqRsltDngrsGdsBscDescT.DangerousGoodBasicDescription AS DangerousGoodBasicDescription
FROM I_CmplRqRslt
INNER JOIN I_CmplRqRsltDngrsGdsBscDescT ON /* join condition not captured in parsed metadata */
;

Learn More