C_CmplRqRsltChmCmInSiCmTP

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_CmplRqRsltChmCmInSiCmTP.
-- 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: CCRRCCISCCTP

CREATE VIEW C_CmplRqRsltChmCmInSiCmTP AS
SELECT
  CmplRqRslt.ActiveCmplRqRsltUUID AS ActiveCmplRqRsltUUID,
  cast( '' as ehfnd_cci_up ) AS ChmlCmplncInfoUnpckgdProdName,
  CmplRqRslt._ChmlCmplncInfo.ChmlCmplncInternalName AS ChmlCmplncInternalName,
  cast ( '' as ehfnd_cci_raw_material_name ) AS ChmlCmplncInfoCombinedMaterial,
  cast( _CalculatedCmplncStsVH._Text[1: Language = $session.system_language ].CmplRqRsltCmplncStsTxt as ehpma_crr_mkt_stat_text preserving type ) AS CmplRqRsltCalculatedStatusName,
  cast(_ManuallySetCmplncStsVH._Text[1: Language = $session.system_language ].CmplRqRsltCmplncStsTxt as ehpma_crr_mkt_stat_text preserving type ) AS CmplRqRsltManualCmplncStsName,
  _CmplncStsConstantsManually.CmplRqRsltCmplncStsCriticality AS CmplRqRsltManualCmplncStsCritl,
  cast(_PreliminaryStsVH._Text[1: Language = $session.system_language ].CmplRqRsltCmplncStsTxt as ehpma_crr_mkt_stat_text preserving type ) AS CmplRqRsltPrelimCmplncStsName,
  _PreliminaryStsVH.CmplRqRsltCmplncStsCriticality AS CmplRqRsltPrelimCmplncStsCritl,
  cast( _ReleasedCmplncStsTxt[1: Language = $session.system_language ].CmplRqRsltCmplncStsTxt as ehpma_crr_mkt_stat_text preserving type) AS CmplRqRsltReldCmplncStsName,
  _CmplncStsConstantsReleased.CmplRqRsltCmplncStsCriticality AS CmplRqRsltReldCmplncStsCritlty,
  cast( '' as ad_namtext ) AS CmplRqRsltProcessorName,
  cast( '' as ad_namtext ) AS ReleasedByUserName,
  _CmplRqRsltProcgStsTxt[1: Language = $session.system_language ].ProcessingStatusText AS CmplRqRsltProcessingStatusName,
  CmplRqRslt._ChmlCmplncInfo.ChmlCmplncProdIsResearched AS ChmlCmplncProdIsResearched,
  cast( '' as ehfnd_cci_is_sold ) AS MaterialIsSold,
  cast( '' as ehfnd_cci_is_transported ) AS MaterialIsTransported,
  cast( '' as ehfnd_cci_is_sourced ) AS MaterialIsSourced,
  cast( '' as ehfnd_cci_is_produced ) AS MaterialIsProduced,
  CmplRqRslt.LastChangeDateTime AS LastChangeDateTime,
  CmplRqRslt.ValidityStartDateTime AS ValidityStartDateTime,
  CmplRqRslt.ValidityEndDateTime AS ValidityEndDateTime,
  cast( 0 as abap.int2 ) AS CmplRqVersNmbrOfExemptions,
  cast( 0 as abap.int2 ) AS CmplRqVersNmbrOfCmplncStmnt,
  CmplRqRslt.ChmlSuplrMatlUUID AS ChmlSuplrMatlUUID,
  CmplRqRslt.SubstanceUUID AS SubstanceUUID,
  CmplRqRslt.CmplRqVersUUID AS CmplRqVersUUID,
  CmplRqRslt.ChemicalCustomerMaterialUUID AS ChemicalCustomerMaterialUUID
FROM I_CmplRqRsltTP AS CmplRqRslt
LEFT OUTER JOIN C_ChmlCmplncInfoSiCmStmntTP AS _CmplRqRsltCmplncStmnt ON CmplRqRsltUUID = _CmplRqRsltCmplncStmnt.CmplRqRsltUUID  -- association [0..*]
LEFT OUTER JOIN C_ChmlCmplncInfoSiCmExmpTP AS _CmplRqRsltExemption ON CmplRqRsltUUID = _CmplRqRsltExemption.CmplRqRsltUUID  -- association [0..*]
LEFT OUTER JOIN C_ChmlCmplncPrimMatl AS _MaterialDataPrimary ON ChmlCmplncInfoUUID = _MaterialDataPrimary.ChmlCmplncInfoUUID  -- association [1..1]
LEFT OUTER JOIN I_CmplRqVersEnhanced AS _CmplRqVers ON CmplRqVersUUID = _CmplRqVers.CmplRqVersUUID  -- association [1..1]
LEFT OUTER JOIN C_CmplRqRsltSuplrMatlAssmtSts AS _CmplRqRsltSuplrMatlAssmtSts ON ActiveCmplRqRsltUUID = _CmplRqRsltSuplrMatlAssmtSts.CmplRqRsltUUID  -- association [0..*]
LEFT OUTER JOIN I_CmplRqRslt AS _ReleasedCmplRqRslt ON ChmlCmplncInfoUUID = _ReleasedCmplRqRslt.ChmlCmplncInfoUUID AND CmplRqVersUUID = _ReleasedCmplRqRslt.CmplRqVersUUID AND _ReleasedCmplRqRslt.CmplRqRsltProcessingStatus = 'RE'  -- association [0..1]
LEFT OUTER JOIN I_CmplRqRsltCalcdCmplncStsVH AS _CalculatedCmplncStsVH ON CmplRqRsltCalculatedStatus = _CalculatedCmplncStsVH.CmplRqRsltCmplncSts  -- association [1..1]
LEFT OUTER JOIN I_CmplncRqmtRsltCmplncStsVH AS _PreliminaryStsVH ON CmplRqRsltPrelimCmplncSts = _PreliminaryStsVH.CmplRqRsltCmplncSts  -- association [0..1]
LEFT OUTER JOIN I_CmplRqRsltProcgStsTxt AS _CmplRqRsltProcgStsTxt ON CmplRqRsltProcessingStatus = _CmplRqRsltProcgStsTxt.CmplRqRsltProcessingStatus  -- association [1..*]
LEFT OUTER JOIN I_CmplRqRsltMnlCmplncStsVH AS _ManuallySetCmplncStsVH ON CmplRqRsltManualStatus = _ManuallySetCmplncStsVH.CmplRqRsltCmplncSts  -- association [0..1]
LEFT OUTER JOIN I_CmplncRqmtRsltCmplncStsTxt AS _ReleasedCmplncStsTxt ON CmplRqRsltReldCmplncSts = _ReleasedCmplncStsTxt.CmplRqRsltCmplncSts  -- association [0..*]
LEFT OUTER JOIN I_CmplncRqmtRsltStsConstants AS _CmplncStsConstantsManually ON CmplRqRsltManualStatus = _CmplncStsConstantsManually.CmplRqRsltCmplncSts  -- association [0..1]
LEFT OUTER JOIN I_CmplncRqmtRsltStsConstants AS _CmplncStsConstantsReleased ON CmplRqRsltReldCmplncSts = _CmplncStsConstantsReleased.CmplRqRsltCmplncSts  -- association [0..1]
LEFT OUTER JOIN C_NmbrOfSupMaAssmtByCritlty AS _NmbrOfSupMaAssmtByCritlty ON ActiveCmplRqRsltUUID = _NmbrOfSupMaAssmtByCritlty.CmplRqRsltUUID  -- association [0..*]
;