C_ChmlCmplncInfoCmplRqRslt

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_ChmlCmplncInfoCmplRqRslt.
-- 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_ChmlCmplncInfoCmplRqRslt AS
SELECT
  DngrsGdsRespUnit,
  cast( '' as ehpma_application ) AS ChmlCmplncApplication,
  LastChangeUTCDateTime,
  LastChangedByUser,
  cast( _LastChangedByUser.UserDescription as ehfnd_bo_lchg_uname_enhanced preserving type ) AS LastChangedByUserName,
  _isRawMat.ChmlCmplncInfoIsRawMatl AS ChmlCmplncInfoIsRawMatl
FROM I_ChmlCmplncInfoTP
LEFT OUTER JOIN C_ChmCmInCmplRqRsltSftyDataSht AS _ChmCmInCmplRqRsltSftyDataSht ON ChmlCmplncInfoUUID = _ChmCmInCmplRqRsltSftyDataSht.ChmlCmplncInfoUUID  -- association [0..*]
LEFT OUTER JOIN C_SftyDataShtRelatedAssmt AS _SftyDataShtRelatedAssmt ON ChmlCmplncInfoUUID = _SftyDataShtRelatedAssmt.ChmlCmplncInfoUUID  -- association [0..*]
LEFT OUTER JOIN C_ChmCmInCmplRqRsltDngrsGds AS _CmplRqRsltDngrsGds ON ChmlCmplncInfoUUID = _CmplRqRsltDngrsGds.ChmlCmplncInfoUUID  -- association [0..*]
LEFT OUTER JOIN C_PaChCoInCmplRqRsltDngrsGds AS _PaChCoInCmplRqRsltDngrsGds ON ChmlCmplncInfoUUID = _PaChCoInCmplRqRsltDngrsGds.ChmlCmplncProdUUID  -- association [0..*]
LEFT OUTER JOIN C_CmplRqRsltMarketability AS _CmplRqRsltMarketability ON ChmlCmplncInfoUUID = _CmplRqRsltMarketability.ChmlCmplncProdUUID  -- association [0..*]
LEFT OUTER JOIN C_PckgdCmplRqRsltMarketability AS _PckgdCmplRqRsltMarketability ON ChmlCmplncInfoUUID = _PckgdCmplRqRsltMarketability.ChmlCmplncProdUUID  -- association [0..*]
LEFT OUTER JOIN C_ChmlCmplncPrimMatl AS _MaterialDataPrimary ON _MaterialDataPrimary.ChmlCmplncInfoUUID = ActiveChmlCmplncInfoUUID  -- association [0..1]
LEFT OUTER JOIN P_ChmlCmplIsRawMat AS _isRawMat ON _isRawMat.ChmlCmplncInfoUUID = ChmlCmplncInfoUUID  -- association [1..1]
LEFT OUTER JOIN C_ChmlCmplncRespUnitDngrsGdsVH AS _RespDangerousGoodsVH ON _RespDangerousGoodsVH.ResponsibleUnit = DngrsGdsRespUnit  -- association [0..1]
LEFT OUTER JOIN C_ChmlCmplncRespUnitProductVH AS _RespProductStewardshipVH ON _RespProductStewardshipVH.ResponsibleUnit = ProdStewardshipRespUnit  -- association [0..1]
;