I_ChmlCmplncAddlDtaMnlDngrsGds

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 I_ChmlCmplncAddlDtaMnlDngrsGds.
-- 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: ICCIMNLDGADDLDTA

CREATE VIEW I_ChmlCmplncAddlDtaMnlDngrsGds AS
SELECT
  I_ChmlCmplncMnlDngrsGdsUnion.ChmlCmplncMnlDngrsGdsUUID AS ChmlCmplncMnlDngrsGdsUUID,
  I_ChmlCmplncMnlDngrsGdsUnion.ChmlCmplncInfoUUID AS ChmlCmplncInfoUUID,
  I_ChmlCmplncMnlDngrsGdsUnion.ChmlCmplncInfoUUID AS ActiveChmlCmplncInfoUUID,
  I_ChmlCmplncMnlDngrsGdsUnion.ChmlCmplncProdUUID AS ChmlCmplncProdUUID,
  _PackagedProdAsgmt.ChmlCmplncMatlAssgmtUUID AS ChmlCmplncMatlAssgmtUUID,
  _PackagedProdAsgmt.Material AS ChmlCmplncInfoPckgdProd,
  cast(_PackagedProdAsgmt._Product._Text[ 1: Language = $session.system_language ].ProductName as ehfnd_cci_material_name ) AS ChmlCmplncInfoPckgdProdName,
  I_ChmlCmplncMnlDngrsGdsUnion.CmplRqVersUUID AS CmplRqVersUUID,
  _CmplRqVersText.CmplRqVersName AS CmplRqVersName,
  I_ChmlCmplncMnlDngrsGdsUnion.ClassifiedAsDangerousGood AS ClassifiedAsDangerousGood,
  _ClassifiedAsDangerousGoodTxt.ClassifiedAsDangerousGoodName AS ClassifiedAsDangerousGoodName,
  I_ChmlCmplncMnlDngrsGdsUnion.DngrsGoodsPackagingType AS DngrsGoodsPackagingType,
  _DescOfDngrsGdsPckgText.DescOfDngrsGdsPckgCompleteName AS DescOfDngrsGdsPckgCompleteName,
  _DescOfDngrsGdsPckgText.DescOfDngrsGdsPckgName AS DescOfDngrsGdsPckgName,
  I_ChmlCmplncMnlDngrsGdsUnion.DngrsGoodsModeOfTransport AS DngrsGoodsModeOfTransport,
  _DngrsGoodsModeOfTransportTxt.DngrsGoodsModeOfTransportName AS DngrsGoodsModeOfTransportName,
  I_ChmlCmplncMnlDngrsGdsUnion.TransportPermission AS TransportPermission,
  _TransportPermissionText.TransportPermissionName AS TransportPermissionName,
  I_ChmlCmplncMnlDngrsGdsUnion.CreatedByUser AS CreatedByUser,
  _CreatedByUserText.UserDescription AS CreatedByUserDescription,
  I_ChmlCmplncMnlDngrsGdsUnion.LastChangedByUser AS LastChangedByUser,
  _LastChangedByUserText.UserDescription AS LastChangedByUserDescription,
  I_ChmlCmplncMnlDngrsGdsUnion._ChmlCmplncInfo AS _ChmlCmplncInfo,
  _PackagedProdAsgmt._Product AS _Product,
  I_ChmlCmplncMnlDngrsGdsUnion._CmplRqVers AS _CmplRqVers
LEFT OUTER JOIN I_ChmlCmplncMatlAssgmt AS _PackagedProdAsgmt ON ChmlCmplncProdUUID = _PackagedProdAsgmt.ChmlCmplncInfoUUID AND _PackagedProdAsgmt.MatlAssgmtIsPrimary = 'X'  -- association [0..1]
LEFT OUTER JOIN C_ChmlCmplncPrimMatl AS _MaterialDataPrimary ON ActiveChmlCmplncInfoUUID = _MaterialDataPrimary.ChmlCmplncInfoUUID  -- association [0..1]
LEFT OUTER JOIN I_DngrsGoodsModeOfTransportTxt AS _DngrsGoodsModeOfTransportTxt ON DngrsGoodsModeOfTransport = _DngrsGoodsModeOfTransportTxt.DngrsGoodsModeOfTransport AND _DngrsGoodsModeOfTransportTxt.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CmplRqVersText AS _CmplRqVersText ON CmplRqVersUUID = _CmplRqVersText.CmplRqVersUUID AND _CmplRqVersText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ClassifiedAsDangerousGoodTxt AS _ClassifiedAsDangerousGoodTxt ON ClassifiedAsDangerousGood = _ClassifiedAsDangerousGoodTxt.ClassifiedAsDangerousGood AND _ClassifiedAsDangerousGoodTxt.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUserText ON CreatedByUser = _CreatedByUserText.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUserText ON LastChangedByUser = _LastChangedByUserText.UserID  -- association [0..1]
LEFT OUTER JOIN I_TransportPermissionText AS _TransportPermissionText ON TransportPermission = _TransportPermissionText.TransportPermission AND _TransportPermissionText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_DescOfDngrsGdsPckgText AS _DescOfDngrsGdsPckgText ON DngrsGoodsPackagingType = _DescOfDngrsGdsPckgText.DescriptionOfDngrsGdsPckg AND _DescOfDngrsGdsPckgText.Language = $session.system_language  -- association [0..1]
;