C_CmplRqRsltChmCmInSupInTP

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_CmplRqRsltChmCmInSupInTP.
-- 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: CCRRCCISLITP

CREATE VIEW C_CmplRqRsltChmCmInSupInTP AS
SELECT
  CmplRqRslt.ActiveCmplRqRsltUUID AS ActiveCmplRqRsltUUID,
  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,
  cast(_PreliminaryStsVH._Text[1: Language = $session.system_language ].CmplRqRsltCmplncStsTxt as ehpma_crr_mkt_stat_text preserving type) AS CmplRqRsltPrelimCmplncStsName,
  _PreliminaryStsVH.CmplRqRsltCmplncStsCriticality AS CmplRqRsltPrelimCmplncStsCritl,
  cast(_ReleasedCmplncStsVH._Text[1: Language = $session.system_language ].CmplRqRsltCmplncStsTxt as ehpma_crr_mkt_stat_text preserving type ) AS CmplRqRsltReldCmplncStsName,
  _ReleasedCmplncStsVH.CmplRqRsltCmplncStsCriticality AS CmplRqRsltReldCmplncStsCritlty,
  cast( '' as ad_namtext ) AS CmplRqRsltProcessorName,
  cast( '' as ad_namtext ) AS ReleasedByUserName,
  _CmplRqRsltProcgStsTxt[1: Language = $session.system_language ].ProcessingStatusText AS CmplRqRsltProcessingStatusName,
  _CmplRqVersAction._CmplRqVersActionTxt[1: Language = $session.system_language].CmplRqVersActionText AS CmplRqVersActionText,
  CmplRqRslt.ValidityEndDateTime AS ValidityEndDateTime,
  CmplRqRslt._ChmlCmplncInfo.ChmlCmplncInfoType AS ChmlCmplncInfoType,
  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,
  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,
  _CmplRqRsltChmlCmpstn.MatlBsdCmpstnUUID AS MatlBsdCmpstnUUID
FROM I_CmplRqRsltTP AS CmplRqRslt
LEFT OUTER JOIN C_CmplRqRsltSupInStmntTP AS _CmplRqRsltCmplncStmnt ON CmplRqRsltUUID = _CmplRqRsltCmplncStmnt.CmplRqRsltUUID  -- association [0..*]
LEFT OUTER JOIN C_CmplRqRsltSupInExmpTP AS _CmplRqRsltExemption ON CmplRqRsltUUID = _CmplRqRsltExemption.CmplRqRsltUUID  -- association [0..*]
LEFT OUTER JOIN C_CmplRqRsltAddlActionInfoTP AS _CmplRqRsltActnInfo ON CmplRqRsltUUID = _CmplRqRsltActnInfo.CmplRqRsltUUID  -- association [0..1]
LEFT OUTER JOIN I_CmplncRqmtRsltCmplncStsTxt AS _CmplncRqmtRsltCmplncStsTxt ON CmplRqRsltPrelimCmplncSts = _CmplncRqmtRsltCmplncStsTxt.CmplRqRsltCmplncSts  -- association [0..*]
LEFT OUTER JOIN C_CmplRqRsltRawMatlIssue AS _CmplRqRsltRawMatlIssue ON ActiveCmplRqRsltUUID = _CmplRqRsltRawMatlIssue.CmplRqRsltUUID  -- association [0..*]
LEFT OUTER JOIN C_CmplRqRsltSuplrMatlAssmtSts AS _CmplRqRsltSuplrMatlAssmtSts ON ActiveCmplRqRsltUUID = _CmplRqRsltSuplrMatlAssmtSts.CmplRqRsltUUID  -- association [0..*]
LEFT OUTER JOIN C_ChmlCmplncPrimMatl AS _MaterialDataPrimary ON ChmlCmplncInfoUUID = _MaterialDataPrimary.ChmlCmplncInfoUUID  -- association [1..1]
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_CmplRqVersEnhanced AS _CmplRqVers ON CmplRqVersUUID = _CmplRqVers.CmplRqVersUUID  -- association [1..1]
LEFT OUTER JOIN I_CmplRqRsltProcgStsTxt AS _CmplRqRsltProcgStsTxt ON CmplRqRsltProcessingStatus = _CmplRqRsltProcgStsTxt.CmplRqRsltProcessingStatus  -- association [1..*]
LEFT OUTER JOIN I_CmplRqRsltMnlCmplncStsCalcVH AS _ManuallySetCmplncStsVH ON CmplRqRsltManualStatus = _ManuallySetCmplncStsVH.CmplRqRsltCmplncSts  -- association [0..1]
LEFT OUTER JOIN I_CmplncRqmtRsltCmplncStsVH AS _ReleasedCmplncStsVH ON CmplRqRsltReldCmplncSts = _ReleasedCmplncStsVH.CmplRqRsltCmplncSts  -- association [0..1]
LEFT OUTER JOIN P_CmplRqRsltChmlCmpstn AS _CmplRqRsltChmlCmpstn ON ActiveCmplRqRsltUUID = _CmplRqRsltChmlCmpstn.CmplRqRsltUUID  -- association [1..1]
LEFT OUTER JOIN P_CmplRqVersSingleAction AS _CmplRqVersAction ON CmplRqVersUUID = _CmplRqVersAction.CmplRqVersUUID AND _CmplRqVersAction.CmplRqVersObjectType = 'PR'  -- association [0..1]
LEFT OUTER JOIN C_NmbrOfRawMatlAssmtByCritlty AS _NmbrOfRawMatlAssmtByCritlty ON ActiveCmplRqRsltUUID = _NmbrOfRawMatlAssmtByCritlty.CmplRqRsltUUID  -- association [0..*]
LEFT OUTER JOIN C_NmbrOfSupMaAssmtByCritlty AS _NmbrOfSupMaAssmtByCritlty ON ActiveCmplRqRsltUUID = _NmbrOfSupMaAssmtByCritlty.CmplRqRsltUUID  -- association [0..*]
;