C_ChmlCmplncMktCvrgTP

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_ChmlCmplncMktCvrgTP.
-- 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_ChmlCmplncMktCvrgTP AS
SELECT
  ChmlCmplncMktCvrgUUID,
  ActiveChmlCmplncMktCvrgUUID,
  ChmlCmplncMktReqUUID,
  ChmlCmplncInfoUUID,
  ActiveChmlCmplncInfoUUID,
  ActiveChmlCmplncInfoUUID AS ChmlCmplncInfoNavgnLink,
  _ChmlCmplncInfo.ChmlCmplncInternalName AS ChmlCmplncInternalName,
  cast(_ChmlCmplncMktCvrg._MaterialDataPrimary.ChmlCmplncInfoCombinedName as ehfnd_cci_up ) AS ChmlCmplncInfoCombinedName,
  cast( '' as ehpma_application ) AS ChmlCmplncApplication,
  LastChangedByUser,
  _LastChangedByUser.UserDescription AS UserDescription,
  LastChangeUTCDateTime,
  _ChmlCmplncMktCvrg.ChmlCmplncInfoCntryProdName AS ChmlCmplncInfoCntryProdName,
  cast(_Country._Text[1: Language = $session.system_language ].CountryName as ehfnd_country_desc_long) AS CountryName,
  Country,
  cast( '' as ehpma_specific_cov_exists) AS ChmlCmplncSpcfcCvrgExists,
  cast( '' as ehpma_specific_cov_exists_dsc ) AS ChmlCmplncSpcfcCvrgExistsName,
  _ChmlCmplncMktReq.ChmlCmplncProdnIsReqd AS ChmlCmplncProdnIsReqd,
  cast( 0 as integer ) AS ChmlCmplncProdnIsReqdCritlty,
  ChmlCmplncProdnAllwd,
  _CvrgStsProdnVH.ChmlCmplncCvrgStatusName AS ChmlCmplncProdnAllwdName,
  cast( 0 as integer ) AS ChmlCmplncProdnCvrgStsCritlty,
  cast( '' as ehpma_prod_covreq_status_dsc ) AS ChmlCmplncProdnAllwdReqdName,
  cast( 0 as integer ) AS ChmlCmplncProdnCvrgReqdCritlty,
  _ChmlCmplncMktReq.ChmlCmplncSalesIsReqd AS ChmlCmplncSalesIsReqd,
  cast(_ChmlCmplncMktReq._ReqStsSales._Text[1: Language = $session.system_language ].ChmlCmplncReqStatusName as ehfnd_cci_sales_is_rqstd_dsc) AS ChmlCmplncSalesIsReqdName,
  cast( 0 as integer ) AS ChmlCmplncSalesIsReqdCritlty,
  ChmlCmplncSalesAllwd,
  _CvrgStsSalesVH.ChmlCmplncCvrgStatusName AS ChmlCmplncSalesAllwdName,
  cast( 0 as integer ) AS ChmlCmplncSalesCvrgStsCritlty,
  cast( '' as ehpma_sales_covreq_status_dsc ) AS ChmlCmplncSalesAllwdReqdName,
  cast( 0 as integer ) AS ChmlCmplncSalesCvrgReqdCritlty,
  ChmlCmplncMktCvrgRemark
FROM I_ChmlCmplncMktCvrgTP
LEFT OUTER JOIN C_ChmlCmplncMktTP AS _ChmlCmplncInfo ON _ChmlCmplncInfo.ChmlCmplncInfoUUID = ChmlCmplncInfoUUID  -- association [1..1]
LEFT OUTER JOIN P_ChmlCmplncMktCvrg AS _ChmlCmplncMktCvrg ON _ChmlCmplncMktCvrg.ChmlCmplncMktCvrgUUID = ActiveChmlCmplncMktCvrgUUID  -- association [0..1]
LEFT OUTER JOIN I_ChmlCmplncMktReqTP AS _ChmlCmplncMktReq ON _ChmlCmplncMktReq.ActiveChmlCmplncInfoUUID = ActiveChmlCmplncInfoUUID AND _ChmlCmplncMktReq.Country = Country  -- association [0..1]
LEFT OUTER JOIN I_ChmlCmplncMktCvrgStsVH AS _CvrgStsProdnVH ON _CvrgStsProdnVH.ChmlCmplncCvrgStatus = ChmlCmplncProdnAllwd  -- association [0..1]
LEFT OUTER JOIN I_ChmlCmplncMktCvrgStsVH AS _CvrgStsSalesVH ON _CvrgStsSalesVH.ChmlCmplncCvrgStatus = ChmlCmplncSalesAllwd  -- association [0..1]
LEFT OUTER JOIN C_ChmlCmplncMktCvrgProdAssgmt AS _PackagedProducts ON _PackagedProducts.ChmlCmplncProdUUID = ActiveChmlCmplncInfoUUID AND _PackagedProducts.Country = Country  -- association [0..*]
LEFT OUTER JOIN C_ChmlCmplncMktCmplRqRslt AS _CmplRqRslt ON _CmplRqRslt.ChmlCmplncProdUUID = ActiveChmlCmplncInfoUUID AND ( _CmplRqRslt.Country = Country OR _CmplRqRslt.Country = 'Worldwide' )  -- association [0..*]
LEFT OUTER JOIN C_ChmlContactData AS _ContactData ON LastChangedByUser = _ContactData.ContactCardID  -- association [0..1]
;