C_CmplRqRsltDngrsGdsBscDetsTP

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_CmplRqRsltDngrsGdsBscDetsTP.
-- 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: CCRRBCTDETTP

CREATE VIEW C_CmplRqRsltDngrsGdsBscDetsTP AS
SELECT
  CmplRqRsltDngrsGdsBscDetsUUID,
  CmplRqRsltUUID,
  CreatedByUser,
  LastChangedByUser,
  ClassifiedAsDangerousGood,
  DangerousGoodsIdnNumber,
  DangerousGoodsIdnNumberType,
  DangerousGoodsClass,
  DangerousGoodsPackingGroup,
  DangerousGoodsListItemVariant,
  cast( '' as fap_machine_learning_active ) AS MachineLearningIsActive
FROM I_CmplRqRsltDngrsGdsBscDetsTP
LEFT OUTER JOIN C_CmplRqRsltDngrsGdsBscClfnTP AS _CmplRqRslt ON CmplRqRsltUUID = _CmplRqRslt.CmplRqRsltUUID  -- association [1..1]
LEFT OUTER JOIN I_ClassifiedAsDangerousGoodTxt AS _ClassifiedAsDangerousGoodTxt ON ClassifiedAsDangerousGood = _ClassifiedAsDangerousGoodTxt.ClassifiedAsDangerousGood  -- association [0..*]
LEFT OUTER JOIN I_DngrsGdsClassOrDivisionText AS _DngrsGdsClassOrDivisionText ON DangerousGoodsClass = _DngrsGdsClassOrDivisionText.DangerousGoodsClass  -- association [0..*]
LEFT OUTER JOIN I_DngrsGdsPackingGroupText AS _DngrsGdsPackingGroupText ON DangerousGoodsPackingGroup = _DngrsGdsPackingGroupText.DangerousGoodsPackingGroup  -- association [0..*]
;