C_ChmlCmplncMktTP

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_ChmlCmplncMktTP.
-- 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 C_ChmlCmplncMktTP AS
SELECT
  ChmlCmplncInfoUUID,
  _ComplianceInfo.ActiveChmlCmplncInfoUUID AS ActiveChmlCmplncInfoUUID,
  _ComplianceInfo.ActiveChmlCmplncInfoUUID AS CmplRqRsltNavgnLink,
  _MaterialDataPrimary.MaterialName AS MaterialName,
  _MaterialDataPrimary.ChmlCmplncInfoCombinedName AS ChmlCmplncInfoCombinedName,
  _MarketKeyFig.NmbrOfChmlCmplncReqOpn AS NmbrOfChmlCmplncReqOpn,
  _MarketKeyFig.NmbrOfChmlCmplncPckgdProducts AS NmbrOfChmlCmplncPckgdProducts,
  _MarketKeyFig.NmbrOfChmlCmplncReqOpnWithTot AS NmbrOfChmlCmplncReqOpnWithTot,
  cast( '' as ehpma_application ) AS ChmlCmplncApplication,
  _MarketKeyFig.NmbrOfChmlCmplncMktCountries AS NmbrOfChmlCmplncMktCountries,
  _MarketKeyFig.NmbrOfChmlCmplncReqProcd AS NmbrOfChmlCmplncReqProcd,
  _MarketKeyFig.NmbrOfInProcessCmplRqRslts AS NmbrOfInProcessCmplRqRslts,
  _MarketKeyFig.NmbrOfReleasedCmplRqRslts AS NmbrOfReleasedCmplRqRslts,
  _MarketKeyFig.NmbrOfCmplRqRslts AS NmbrOfCmplRqRslts,
  0 AS ReleasedCmplRqRsltsCritlty,
  _MarketKeyFig.ReleasedCmplRqRsltsPctName AS ReleasedCmplRqRsltsPctName,
  _MarketKeyFig.ReleasedCmplRqRsltsPct AS ReleasedCmplRqRsltsPct,
  0 AS InProcessCmplRqRsltsCritlty,
  _MarketKeyFig.InProcessCmplRqRsltsPctName AS InProcessCmplRqRsltsPctName,
  _MarketKeyFig.InProcessCmplRqRsltsPct AS InProcessCmplRqRsltsPct,
  ProdStewardshipRespUnit,
  _RespUnitForProductStewardship._Text[1: Language = $session.system_language ].ResponsibleUnitName AS ResponsibleUnitName,
  LastChangeUTCDateTime,
  LastChangedByUser,
  _LastChangedByUser.UserDescription AS UserDescription
FROM I_ChmlCmplncInfoTP AS _ComplianceInfo
LEFT OUTER JOIN C_ChmlCmplncMktCvrgTP AS _MarketCoverage ON _MarketCoverage.ChmlCmplncInfoUUID = ChmlCmplncInfoUUID  -- association [0..*]
LEFT OUTER JOIN C_ChmlCmplncPrimMatl AS _MaterialDataPrimary ON _MaterialDataPrimary.ChmlCmplncInfoUUID = ActiveChmlCmplncInfoUUID  -- association [0..1]
LEFT OUTER JOIN C_ChmlCmplncMktSpcfcCvrg AS _SpecificCoverage ON _SpecificCoverage.ChmlCmplncProdUUID = ActiveChmlCmplncInfoUUID  -- association [0..*]
LEFT OUTER JOIN C_ChmlCmplncMktProdAssgmt AS _PackagedProducts ON _PackagedProducts.ChmlCmplncProdUUID = ActiveChmlCmplncInfoUUID  -- association [0..*]
LEFT OUTER JOIN I_ChmlCmplncMktKeyFig AS _MarketKeyFig ON _MarketKeyFig.ChmlCmplncInfoUUID = ActiveChmlCmplncInfoUUID  -- association [0..1]
LEFT OUTER JOIN C_ChmlCmplncRespUnitDngrsGdsVH AS _RespDangerousGoodsVH ON _RespDangerousGoodsVH.ResponsibleUnit = DngrsGdsRespUnit  -- association [0..1]
;