I_ChmlCmplncInfo

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 I_ChmlCmplncInfo.
-- 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 I_ChmlCmplncInfo AS
SELECT
  ChmlCmplncInfoUUID,
  cast(creationutcdatetime as ehfnd_bo_crea_date_time preserving type ) AS CreationUTCDateTime,
  cast(createdbyuser as ehfnd_bo_crea_uname preserving type ) AS CreatedByUser,
  cast(lastchangeutcdatetime as ehfnd_bo_lchg_date_time preserving type ) AS LastChangeUTCDateTime,
  cast(lastchangedbyuser as ehfnd_bo_lchg_uname preserving type ) AS LastChangedByUser,
  ProdStewardshipRespUnit,
  DngrsGdsRespUnit,
  ChmlCmplncInfoType,
  ChmlCmplncInternalName,
  MaterialIsBaseProduct,
  MaterialIsSold,
  MaterialIsTransported,
  MaterialIsSourced,
  MaterialIsProduced,
  MaterialIsDisposed,
  MaterialIsEmissionRelevant,
  Specification,
  SpecificationInternalID,
  ChmlCmplncProdIsResearched,
  MatlIsNotProdMarketabilityRlvt,
  MatlIsNotProdSafetyRlvt,
  MatlIsNotSupplierRlvt
FROM ehfndv_cci
LEFT OUTER JOIN I_ChmlCmplncProdAssgmt AS _ProductAssignment ON ChmlCmplncInfoUUID = _ProductAssignment.ChmlCmplncInfoUUID  -- association [0..*]
LEFT OUTER JOIN I_ChmlCmplncPrpsAssgmt AS _PurposeAssignment ON ChmlCmplncInfoUUID = _PurposeAssignment.ChmlCmplncInfoUUID  -- association [0..*]
LEFT OUTER JOIN I_ChmlCmplncMktReq AS _MarketRequest ON ChmlCmplncInfoUUID = _MarketRequest.ChmlCmplncInfoUUID  -- association [0..*]
LEFT OUTER JOIN I_ChmlCmplncMktCvrg AS _MarketCoverage ON ChmlCmplncInfoUUID = _MarketCoverage.ChmlCmplncInfoUUID  -- association [0..*]
LEFT OUTER JOIN I_ChmlCmplncMatlAssgmt AS _MaterialAssignment ON ChmlCmplncInfoUUID = _MaterialAssignment.ChmlCmplncInfoUUID  -- association [0..*]
LEFT OUTER JOIN I_ChmlCmplncApplAssgmt AS _Application ON ChmlCmplncInfoUUID = _Application.ChmlCmplncInfoUUID  -- association [0..*]
LEFT OUTER JOIN I_ChmlCmplncSuplrMatlAssgmt AS _SuplrMatlAssignment ON ChmlCmplncInfoUUID = _SuplrMatlAssignment.ChmlCmplncInfoUUID  -- association [0..*]
LEFT OUTER JOIN I_ChmlCmplncWasteData AS _WasteData ON ChmlCmplncInfoUUID = _WasteData.ChmlCmplncInfoUUID  -- association [0..1]
LEFT OUTER JOIN I_ChmlCmplncMatlAssgmt AS _PrimaryMaterial ON ChmlCmplncInfoUUID = _PrimaryMaterial.ChmlCmplncInfoUUID AND _PrimaryMaterial.MatlAssgmtIsPrimary = 'X'  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_ResponsibleUnit AS _RespUnitForProductStewardship ON ProdStewardshipRespUnit = _RespUnitForProductStewardship.ResponsibleUnit  -- association [1..1]
LEFT OUTER JOIN I_ResponsibleUnitDngrsGds AS _RespUnitForDangerousGoods ON DngrsGdsRespUnit = _RespUnitForDangerousGoods.ResponsibleUnit  -- association [1..1]
;