P_RawChmlCmplncStatus

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 P_RawChmlCmplncStatus.
-- 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 P_RawChmlCmplncStatus AS
SELECT
  ChmlCmplncInfoUUID,
  _CRRInProcCount.recordCount AS NmbrOfInProcessCmplRqRslts
FROM I_ChmlCmplncInfo AS ChemicalCompliance
LEFT OUTER JOIN P_RawChmlCmplncSupInProcCt AS _SupInProcCount ON _SupInProcCount.ChmlCmplncInfoUUID = ChemicalCompliance.ChmlCmplncInfoUUID  -- association [1..1]
LEFT OUTER JOIN P_RawChmlCmplncSupCompleteCt AS _SupCompleteCount ON _SupCompleteCount.ChmlCmplncInfoUUID = ChemicalCompliance.ChmlCmplncInfoUUID  -- association [1..1]
LEFT OUTER JOIN P_RawChmlCmplRqRsltInProcCt AS _CRRInProcCount ON _CRRInProcCount.ChmlCmplncInfoUUID = ChemicalCompliance.ChmlCmplncInfoUUID  -- association [1..1]
LEFT OUTER JOIN P_RawChmlCmplRqRsltReldCt AS _CRRReldCount ON _CRRReldCount.ChmlCmplncInfoUUID = ChemicalCompliance.ChmlCmplncInfoUUID  -- association [1..1]
LEFT OUTER JOIN P_RawChmlCmplRqRsltUnknownCt AS _CRRUnknownCount ON _CRRUnknownCount.ChmlCmplncInfoUUID = ChemicalCompliance.ChmlCmplncInfoUUID  -- association [1..1]
LEFT OUTER JOIN I_ChmlCmplncSuplrMatlStatus AS _SupplierStatus ON ChmlCmplncSuplrMatlStatus = _SupplierStatus.ChmlCmplncSuplrMatlStatus  -- association [0..1]
LEFT OUTER JOIN I_ChmlCmplncRawMatlProcgSts AS _CmplRawMatlProcgSts ON ChmlCmplncRawMatlProcgSts = _CmplRawMatlProcgSts.ChmlCmplncRawMatlProcgSts  -- association [0..1]
LEFT OUTER JOIN I_ChmlCmplncCmplRqRsltStatus AS _CmplRqRsltStatus ON ChmlCmplncCmplRqRsltStatus = _CmplRqRsltStatus.ChmlCmplncCmplRqRsltStatus  -- association [0..1]
LEFT OUTER JOIN I_ChmlCmplncRawMatlCmpstnSts AS _CmplRawMatlCmpstnSts ON ChmlCmplncRawMatlCmpstnSts = _CmplRawMatlCmpstnSts.ChmlCmplncRawMatlCmpstnSts  -- association [0..1]
LEFT OUTER JOIN P_ChmlAnalyticComposition AS _CompStatus ON _CompStatus.ChmlCmplncInfoUUID = ChemicalCompliance.ChmlCmplncInfoUUID  -- association [0..1]
LEFT OUTER JOIN P_ChmlCompsCompSumCT AS _ComponentCount ON _ComponentCount.ChmlCmplncInfoUUID = ChemicalCompliance.ChmlCmplncInfoUUID AND _ComponentCount.ChmlCompositionType = 'ANALYTIC1' AND _ComponentCount.ChmlCompositionStatus = 'IP'  -- association [0..1]
LEFT OUTER JOIN P_CChmlCmplConstants AS _Constants ON _Constants.ConstantNotExisting = _Constants.ConstantNotExisting  -- association [1..1]
;