C_ChmlCmplncInfoWorkView

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_ChmlCmplncInfoWorkView.
-- 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_ChmlCmplncInfoWorkView AS
SELECT
  ChmlCmplncInfoUUID,
  ChmlCmplncInfoUUID AS ChmlCmplncInfoNavgnLink,
  ChmlCmplncInternalName,
  ProdStewardshipRespUnit,
  ChmlCmplncProdIsResearched,
  MaterialIsSold,
  MaterialIsTransported,
  MaterialIsSourced,
  MaterialIsProduced,
  MaterialIsEmissionRelevant,
  _ChmlCmplncInfoAssgdPCPhys.PCPrptyIsActive AS PCPhysPrptyIsActive,
  _ChmlCmplncInfoAssgdPCEctx.PCPrptyNavgnLinkUUID AS PCEctxPrptyNavgnLinkUUID,
  _ChmlCmplncInfoAssgdPCEctx.PCPrptyIsActive AS PCEctxPrptyIsActive,
  _ChmlCmplncInfoAssgdPCSfty.PCPrptyNavgnLinkUUID AS PCSftyPrptyNavgnLinkUUID,
  _ChmlCmplncInfoAssgdPCSfty.PCPrptyIsActive AS PCSftyPrptyIsActive,
  _ChmlCmplncInfoAssgdPCTx.PCPrptyNavgnLinkUUID AS PCPrptyNavgnLinkUUID,
  _ChmlCmplncInfoAssgdPCTx.PCPrptyIsActive AS PCPrptyIsActive,
  _AnlytlCmpstn.ChmlCmpstnIsActive AS AnalyticCmpstnIsActive,
  _MatlBsdCmpstn.ChmlCmpstnNavgnLinkUUID AS MatlBsdCmpstnNavgnLinkUUID,
  _MatlBsdCmpstn.ChmlCmpstnIsActive AS MatlBsdCmpstnIsActive
FROM I_ChmlCmplncInfo
LEFT OUTER JOIN C_WorkViewCmplncData AS _WorkViewCmplncData ON ChmlCmplncInfoUUID = _WorkViewCmplncData.ChmlCmplncInfoUUID  -- association [0..*]
LEFT OUTER JOIN C_ChmlCmplncPrimMatl AS _MaterialDataPrimary ON _MaterialDataPrimary.ChmlCmplncInfoUUID = ChmlCmplncInfoUUID  -- association [0..1]
LEFT OUTER JOIN C_AssociatedProductComposition AS _Composition ON _Composition.ChmlCmplncInfoUUID = ChmlCmplncInfoUUID  -- association [0..*]
LEFT OUTER JOIN P_AssociatedAnlytlCmpstnProd AS _AnlytlCmpstn ON ChmlCmplncInfoUUID = _AnlytlCmpstn.ChmlCmplncInfoUUID  -- association [0..1]
LEFT OUTER JOIN P_AssociatedMatlCmpstnProd AS _MatlBsdCmpstn ON ChmlCmplncInfoUUID = _MatlBsdCmpstn.ChmlCmplncInfoUUID  -- association [0..1]
LEFT OUTER JOIN C_ChmlCmplncInfoAssgdPCPrpty AS _Properties ON _Properties.ChmlCmplncInfoUUID = ChmlCmplncInfoUUID  -- association [0..*]
LEFT OUTER JOIN P_ChmlCmplncInfoAssgdPCSfty AS _ChmlCmplncInfoAssgdPCSfty ON ChmlCmplncInfoUUID = _ChmlCmplncInfoAssgdPCSfty.ChmlCmplncInfoUUID  -- association [0..1]
LEFT OUTER JOIN P_ChmlCmplncInfoAssgdPCEctx AS _ChmlCmplncInfoAssgdPCEctx ON ChmlCmplncInfoUUID = _ChmlCmplncInfoAssgdPCEctx.ChmlCmplncInfoUUID  -- association [0..1]
LEFT OUTER JOIN P_ChmlCmplncInfoAssgdPCPhys AS _ChmlCmplncInfoAssgdPCPhys ON ChmlCmplncInfoUUID = _ChmlCmplncInfoAssgdPCPhys.ChmlCmplncInfoUUID  -- association [0..1]
LEFT OUTER JOIN P_ChmlCmplncInfoAssgdPCTx AS _ChmlCmplncInfoAssgdPCTx ON ChmlCmplncInfoUUID = _ChmlCmplncInfoAssgdPCTx.ChmlCmplncInfoUUID  -- association [0..1]
;