C_ProdCmplncServiceRequestProd

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_ProdCmplncServiceRequestProd.
-- 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.
-- SQL view name: CPCMPLSERVREQPVH

CREATE VIEW C_ProdCmplncServiceRequestProd AS
SELECT
  _ChmlCmplncInfo.ChmlCmplncInfoUUID AS ChmlCmplncInfoUUID,
  _Composition.ChmlCompositionUUID AS ChmlCompositionUUID,
  _PhysChemProperty.PhysChmlPrptyUUID AS PhysChmlPrptyUUID,
  _SftyRelated.PCSftyPrptyUUID AS PCSftyPrptyUUID,
  _PrimeMatReferenced.ChmlCmplncInfoCombinedName AS ChmlCmplncInfoCombinedName,
  _PrimeMatReferenced.Material AS Material,
  _PrimeMatReferenced._MaterialData.ProductGroup AS ProductGroup,
  cast ( case when _LatestSrvcReqForProduct.LastChangeDateTime is null then ' ' else 'X' end as ehfnd_boolean preserving type ) AS ProdCmplncServiceReqIsExisting,
  _PrimeMatReferenced._MaterialData._ProductGroup_2 AS _ProductGroup_2
FROM I_ChmlCmplncInfo AS _ChmlCmplncInfo
LEFT OUTER JOIN C_ChmlCmplncPrimMatl AS _PrimeMatReferenced ON ChmlCmplncInfoUUID = _PrimeMatReferenced.ChmlCmplncInfoUUID  -- association [0..1]
LEFT OUTER JOIN C_ProdCmplncProdReqSftyDataSht AS _SftyDataSht ON ChmlCmplncInfoUUID = _SftyDataSht.ChmlCmplncInfoUUID  -- association [0..*]
LEFT OUTER JOIN C_ProdCmplncProdReqSendData AS _SendData ON ChmlCmplncInfoUUID = _SendData.ChmlCmplncInfoUUID  -- association [0..*]
;