C_ChmlCmplncInfoQuickView

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_ChmlCmplncInfoQuickView.
-- 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_ChmlCmplncInfoQuickView AS
SELECT
  cast( '' as /ui2/semantic_object ) AS SemanticObject,
  cast ( ChmlCmplncInternalName as ehfnd_cci_unpckgdprod_name preserving type ) AS ChmlCmplncInternalName,
  ChmlCmplncProdCatztnPhrsUUID,
  cast('' as ehfnd_phrs_text ) AS ChmlCmplncProdCatztnPhrs1Text,
  cast('' as ehfnd_boole preserving type ) AS ChmlCmplncProdCatztnPhrsIsHidn,
  cast('' as ehfnd_boole preserving type ) AS CASNumberIsHidden,
  cast( '' as ehfnd_cci_type_name ) AS ChmlCmplncInfoTypeName,
  MaterialIsSold,
  MaterialIsProduced,
  MaterialIsSourced,
  MaterialIsDisposed,
  MaterialIsEmissionRelevant,
  cast('' as ehfnd_cci_log_role_info) AS ChmlCmplncCurLogsRole,
  _ChmlCmplncProdAssgmt.ChmlCmplncProdUUID AS ChmlCmplncInfoNavgnLink,
  cast('' as ehfnd_boole preserving type ) AS UnpckgdChmlCmplncInfoIsHidn,
  cast('' as ehfnd_boole preserving type ) AS PckgdChmlCmplncInfoIsHidn,
  ProdStewardshipRespUnit
FROM I_ChmlCmplncInfo
LEFT OUTER JOIN I_ChmlCmplncProdAssgmt AS _ChmlCmplncProdAssgmt ON I_ChmlCmplncInfo.ChmlCmplncInfoUUID = _ChmlCmplncProdAssgmt.ChmlCmplncInfoUUID AND _ChmlCmplncProdAssgmt.ChmlCmplncInfoType = 'BU'  -- association [0..1]
;