C_CmplRqRsltTP

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 C_CmplRqRsltTP.
-- 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: CCRRTP

CREATE VIEW C_CmplRqRsltTP AS
SELECT
  CmplRqRslt.ChmlCmplncInfoUUID AS ChmlCmplncInfoUUID,
  CmplRqRslt.ChmlSuplrMatlUUID AS ChmlSuplrMatlUUID,
  CmplRqRslt.SubstanceUUID AS SubstanceUUID,
  CmplRqRslt.CmplRqVersUUID AS CmplRqVersUUID,
  CmplRqRslt.ChemicalCustomerMaterialUUID AS ChemicalCustomerMaterialUUID,
  CmplRqRslt.PCESScenarioUUID AS PCESScenarioUUID,
  CmplRqRslt.ActiveCmplRqRsltUUID AS ActiveCmplRqRsltUUID,
  CmplRqRslt.CmplRqRsltReferencedObjectUUID AS CmplRqRsltReferencedObjectUUID,
  _ChmlCmplncPrimMatl.ChmlCmplncInfoCombinedName AS ChmlCmplncInfoCombinedName,
  CmplRqRslt.ComplianceRequirement AS ComplianceRequirement
FROM I_CmplRqRsltTP AS CmplRqRslt
LEFT OUTER JOIN C_ChmlCmplncPrimMatl AS _ChmlCmplncPrimMatl ON ChmlCmplncInfoUUID = _ChmlCmplncPrimMatl.ChmlCmplncInfoUUID  -- association [0..1]
LEFT OUTER JOIN C_CmplRqRsltHistory AS _CmplRqRsltHistory ON ChmlCmplncInfoUUID = _CmplRqRsltHistory.ChmlCmplncInfoUUID AND ChmlSuplrMatlUUID = _CmplRqRsltHistory.ChmlSuplrMatlUUID AND SubstanceUUID = _CmplRqRsltHistory.SubstanceUUID AND ChemicalCustomerMaterialUUID = _CmplRqRsltHistory.ChemicalCustomerMaterialUUID AND PCESScenarioUUID = _CmplRqRsltHistory.PCESScenarioUUID AND ComplianceRequirement = _CmplRqRsltHistory.ComplianceRequirement AND CmplRqRsltReferencedObjectUUID = _CmplRqRsltHistory.CmplRqRsltReferencedObjectUUID  -- association [1..*]
;