C_ChmlCmplncMktCvrgCmplncInfo

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_ChmlCmplncMktCvrgCmplncInfo.
-- 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_ChmlCmplncMktCvrgCmplncInfo AS
SELECT
  MatlAssgmt._Product._Text[1: Language = $session.system_language].ProductName AS ProductName,
  cast('' as ehpma_application) AS ChmlCmplncApplication,
  cast('' as ehfnd_boolean) AS ChmlCmplncCustMultiAddrIsActv,
  cast('' as /ui2/semantic_object) AS SemanticObject,
  ChmlCmplncInfo.MatlIsNotProdSafetyRlvt AS MatlIsNotProdSafetyRlvt,
  cast(ChmlCmplncInfo.Specification as ehfnd_compliance_view preserving type) AS Specification,
  ChmlCmplncInfo.ProdStewardshipRespUnit AS ProdStewardshipRespUnit,
  ChmlCmplncInfo.ChmlCmplncInfoType AS ChmlCmplncInfoType,
  ChmlCmplncInfo.MaterialIsSold AS MaterialIsSold,
  ChmlCmplncInfo.MaterialIsTransported AS MaterialIsTransported,
  ChmlCmplncInfo.MaterialIsProduced AS MaterialIsProduced,
  ChmlCmplncInfo.MaterialIsSourced AS MaterialIsSourced,
  ChmlCmplncInfo.MatlIsMultiComponentProduct AS MatlIsMultiComponentProduct,
  ChmlCmplncInfo.ChmlCmplncProdIsResearched AS ChmlCmplncProdIsResearched,
  cast(_ChmlCmplncProdAssgmt._UnpckgdProdMatDataPrimary.ChmlCmplncInfoCombinedName as ehfnd_cci_raw_material_name preserving type) AS ChmlCmplncInfoRawMaterialName,
  _ChmlCmplncProdAssgmt._ChmlCmplncInfoProduct.Specification AS UnpckgdChemicalComplianceInfo,
  _ChmlCmplncInfoQuickVw.PckgdChmlCmplncInfoIsHidn AS PckgdChmlCmplncInfoIsHidn,
  _ChmlCmplncInfoQuickVw.UnpckgdChmlCmplncInfoIsHidn AS UnpckgdChmlCmplncInfoIsHidn,
  ChmlCmplncInfo._PurposeAssignment AS _PurposeAssignment,
  ChmlCmplncInfo._Application AS _Application,
  ChmlCmplncInfo._RespUnitForProductStewardship AS _RespUnitForProductStewardship,
  _ChmlCmplncProdAssgmt._ChmlCmplncInfoProduct AS _ChmlCmplncInfoProduct,
  MatlAssgmt._Product AS _Product
FROM I_ChmlCmplncInfo AS ChmlCmplncInfo
INNER JOIN I_ChmlCmplncMatlAssgmt AS MatlAssgmt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN C_ChmlCmplncProdAssgmt AS _ChmlCmplncProdAssgmt ON ChmlCmplncInfoUUID = _ChmlCmplncProdAssgmt.ChmlCmplncInfoUUID AND _ChmlCmplncProdAssgmt.ChmlCmplncInfoParentType = 'BU'  -- association [0..1]
LEFT OUTER JOIN C_ChmlCmplncProdAssgmt AS _BrandedChmlCmplncProdAssgmt ON ChmlCmplncInfoUUID = _BrandedChmlCmplncProdAssgmt.ChmlCmplncInfoUUID AND _BrandedChmlCmplncProdAssgmt.ChmlCmplncInfoParentType = 'BP'  -- association [0..1]
LEFT OUTER JOIN I_ProductGroup_2 AS _ProductGroupVH ON MaterialGroup = _ProductGroupVH.ProductGroup  -- association [0..1]
LEFT OUTER JOIN C_ChmlCmplncMktProdAssgmt AS _PackagedProducts ON _PackagedProducts.ChmlCmplncProdUUID = ChmlCmplncInfo.ChmlCmplncInfoUUID  -- association [0..*]
LEFT OUTER JOIN C_ChmlCmplncInfoTransptPrmssn AS _ChmlCmplncInfoTransptPrmssn ON ChmlCmplncInfo.ChmlCmplncInfoUUID = _ChmlCmplncInfoTransptPrmssn.ChmlCmplncInfoUUID  -- association [0..*]
LEFT OUTER JOIN C_ChCoInfoIntlTransptPrmssn AS _ChCoInfoIntlTransptPrmssn ON ChmlCmplncInfo.ChmlCmplncInfoUUID = _ChCoInfoIntlTransptPrmssn.ChmlCmplncInfoUUID  -- association [0..*]
LEFT OUTER JOIN C_ChmlCmplncInfoDngrsGdsDets AS _ChmlCmplncInfoDngrsGdsDets ON ChmlCmplncInfo.ChmlCmplncInfoUUID = _ChmlCmplncInfoDngrsGdsDets.ChmlCmplncInfoUUID  -- association [0..1]
LEFT OUTER JOIN C_ChmlCmplncInfoQuickView AS _ChmlCmplncInfoQuickVw ON Specification = _ChmlCmplncInfoQuickVw.Specification  -- association [0..1]
LEFT OUTER JOIN C_ChmlCmplncInfoQuickView AS _ChmlCmplncInfoQuickVwUnpckgd ON UnpckgdChemicalComplianceInfo = _ChmlCmplncInfoQuickVwUnpckgd.Specification  -- association [0..1]
LEFT OUTER JOIN C_ChmlCmplncInfoQuickView AS _BrnddChmlCmplncInfoQuickVw ON ChmlCmplncBrnddInternalNumber = _BrnddChmlCmplncInfoQuickVw.Specification  -- association [0..1]
;