C_ChmlCmplncMktCvrgProdAssgmt

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_ChmlCmplncMktCvrgProdAssgmt.
-- 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_ChmlCmplncMktCvrgProdAssgmt AS
SELECT
  ChmlCmplncProdAssgmtUUID,
  Country,
  ChmlCmplncInfoUUID,
  PckgdChmlCmplncInfoUUID,
  ChmlCmplncProdUUID,
  PckgdChmlCmplncInfoUUID AS ActiveChmlCmplncInfoUUID,
  _MarketCoveragePckgd.ChmlCmplncMktCvrgUUID AS ChmlCmplncMktCvrgUUID,
  cast(_ChmlCmplncInfo._MaterialAssignment[1: Material = Material]._Product._Text[1: Language = $session.system_language ].ProductName as ehfnd_cci_product_name) AS ProductName,
  _ChmlCmplncInfo._MaterialAssignment[1: Material = Material].Material AS Material,
  cast( '' as ehpma_specific_cov_exists_dsc ) AS ChmlCmplncPckgdCvrgExistsName,
  _MarketRequestPckgd.ChmlCmplncSalesIsReqd AS ChmlCmplncSalesIsReqd,
  _MarketCoveragePckgd.ChmlCmplncSalesAllwd AS ChmlCmplncSalesAllwd,
  cast( '' as ehpma_sales_covreq_status_dsc ) AS ChmlCmplncSalesAllwdReqdName,
  cast( 0 as integer ) AS ChmlCmplncSalesCvrgReqdCritlty
FROM I_ChmlCmplncMktCvrgProdAssgmt
LEFT OUTER JOIN I_ChmlCmplncMktCvrgTP AS _MarketCoveragePckgd ON _MarketCoveragePckgd.ChmlCmplncInfoUUID = PckgdChmlCmplncInfoUUID AND _MarketCoveragePckgd.Country = Country  -- association [1..1]
LEFT OUTER JOIN I_ChmlCmplncMktReqTP AS _MarketRequestPckgd ON _MarketRequestPckgd.ChmlCmplncInfoUUID = PckgdChmlCmplncInfoUUID AND _MarketRequestPckgd.Country = Country  -- association [1..1]
LEFT OUTER JOIN C_ChmlCmplncMktSpcfcCvrg AS _SpecificCoverage ON _SpecificCoverage.ChmlCmplncProdUUID = ChmlCmplncProdUUID AND _SpecificCoverage.ChmlCmplncInfoUUID = PckgdChmlCmplncInfoUUID AND _SpecificCoverage.Country = Country  -- association [1..1]
LEFT OUTER JOIN C_ChmlCmplncMktCvrgTP AS _MarketCoverage ON _MarketCoverage.ChmlCmplncInfoUUID = ChmlCmplncProdUUID AND _MarketCoverage.Country = Country  -- association [1..1]
LEFT OUTER JOIN I_ChmlCmplncInfoTP AS _ChmlCmplncInfo ON _ChmlCmplncInfo.ChmlCmplncInfoUUID = PckgdChmlCmplncInfoUUID  -- association [1..1]
;