I_ChmlCmplncInfoPckgdProdVH

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_ChmlCmplncInfoPckgdProdVH.
-- 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_ChmlCmplncInfoPckgdProdVH AS
SELECT
  ChmlCmplncInfo.ChmlCmplncInfoUUID AS ChmlCmplncInfoUUID,
  cast(ChmlCmplncInfo.Specification as ehfnd_internal_nr_nc preserving type ) AS Specification,
  ChmlCmplncInfo.ProdStewardshipRespUnit AS ProdStewardshipRespUnit,
  ChmlCmplncInfo.DngrsGdsRespUnit AS DngrsGdsRespUnit,
  ChmlCmplncInfo.ChmlCmplncInfoType AS ChmlCmplncInfoType,
  ChmlCmplncInfo.MaterialIsSold AS MaterialIsSold,
  ChmlCmplncInfo.MaterialIsTransported AS MaterialIsTransported,
  ChmlCmplncInfo.MaterialIsSourced AS MaterialIsSourced,
  ChmlCmplncInfo.MaterialIsProduced AS MaterialIsProduced,
  ChmlCmplncInfo.MaterialIsDisposed AS MaterialIsDisposed,
  ChmlCmplncInfo.MaterialIsEmissionRelevant AS MaterialIsEmissionRelevant,
  ChmlCmplncInfo.ChmlCmplncProdIsResearched AS ChmlCmplncProdIsResearched,
  ChmlCmplncInfo.MatlIsMultiComponentProduct AS MatlIsMultiComponentProduct
FROM I_ChmlCmplncInfoVH AS ChmlCmplncInfo
LEFT OUTER JOIN I_ChmlCmplncProdAssgmt AS _BrandedProductAssignment ON _BrandedProductAssignment.ChmlCmplncInfoUUID = ChmlCmplncInfoUUID AND _BrandedProductAssignment.ChmlCmplncInfoType = 'BP'  -- association [0..1]
LEFT OUTER JOIN I_ChmlCmplncProdAssgmt AS _UnpackagedProductAssignment ON _UnpackagedProductAssignment.ChmlCmplncInfoUUID = ChmlCmplncInfoUUID AND _UnpackagedProductAssignment.ChmlCmplncInfoType = 'BU'  -- association [0..1]
;