C_CmbndChmlCmplncInfoTP

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_CmbndChmlCmplncInfoTP.
-- 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: CCMBNDCCITP

CREATE VIEW C_CmbndChmlCmplncInfoTP AS
SELECT
  ChmlCmplncInfoUUID,
  I_ChmlCmplncInfoTP.ActiveChmlCmplncInfoUUID AS ActiveChmlCmplncInfoUUID,
  cast('' as ehfnd_phrs_text ) AS ChmlCmplncProdCatztnPhrsText,
  CreationUTCDateTime,
  CreatedByUser,
  LastChangeUTCDateTime,
  LastChangedByUser,
  cast(ProdStewardshipRespUnit as ehfnd_cci_responsible_unit preserving type ) AS ProdStewardshipRespUnit,
  ChmlCmplncInfoType,
  MaterialIsSold,
  MaterialIsTransported,
  MaterialIsSourced,
  MaterialIsProduced,
  MaterialIsDisposed,
  MaterialIsEmissionRelevant,
  cast('' as abap.char(100)) AS ChmlCmplncLogisticalRoleDesc,
  ChmlCmplncProdIsResearched,
  _MaterialDataPrimary.ChmlCmplncInfoCombinedName AS ChmlCmplncInfoCombinedName,
  _AnlytlCmpstnStatus.ChmlCompositionStatusName AS ChmlCompositionStatusName,
  _AnlytlCmpstnStatus.ChmlCompositionUUID AS AnalyticCmpstnNavgnLinkUUID,
  _AnlytlCmpstnStatus.ChmlCmpstnNavgnStatusCritlty AS ChmlCmpstnNavgnStatusCritlty,
  _AssocdWasteCode.ChmlCmplncWasteCodeStatus AS ChmlCmplncWasteCodeStatus,
  _AssocdWasteCode.ChmlCmplncWasteCodeIsHidden AS ChmlCmplncWasteCodeIsHidden,
  _AssocdWasteCode.ChmlCmplncWasteCodeStsCritlty AS ChmlCmplncWasteCodeStsCritlty,
  _AssocdPCPrpty.PCPrptyProcgStsText AS PCPrptyProcgStsText,
  _AssocdPCPrpty.PhysChmlPrptyUUID AS PCPhysPrptyNavgnLinkUUID,
  _AssocdPCPrpty.PCPrptyProcgStsCritlty AS PCPrptyProcgStsCritlty,
  _ChmlCmplncAssocAddlPrpty.ChmlCmplncAddlPrptyStatus AS ChmlCmplncAddlPrptyStatus,
  _ChmlCmplncAssocAddlPrpty.ChmlCmplncAddlPrptyStatusDesc AS ChmlCmplncAddlPrptyStatusDesc,
  _ChmlCmplncAssocAddlPrpty.ChmlCmplncAddlPrptyCriticality AS ChmlCmplncAddlPrptyCriticality,
  '' AS ProductComplianceIsActivated,
  '' AS ProductComplianceIsDeactivated,
  _AssocdWasteCode._WasteCodeStatus AS _WasteCodeStatus
FROM I_ChmlCmplncInfoTP
LEFT OUTER JOIN C_CmbndChmlCmplncMatlAssgmtTP AS _MaterialAssignment ON _MaterialAssignment.ChmlCmplncInfoUUID = ChmlCmplncInfoUUID  -- association [0..*]
LEFT OUTER JOIN C_CmbndChmlCmplncProdAssgmt AS _ActiveProductAssignment ON _ActiveProductAssignment.ChmlCmplncProdUUID = ActiveChmlCmplncInfoUUID  -- association [0..*]
LEFT OUTER JOIN C_CmbndChmlAnlytlCmpstn AS _AnlytlCmpstn ON _AnlytlCmpstn.ChmlCmplncInfoUUID = ActiveChmlCmplncInfoUUID  -- association [0..*]
LEFT OUTER JOIN P_CmbndChmlAssocdAnlytlCmpstn AS _AnlytlCmpstnStatus ON _AnlytlCmpstnStatus.ChmlCmplncInfoUUID = ActiveChmlCmplncInfoUUID  -- association [0..1]
LEFT OUTER JOIN C_CmbndChmlCmplncWasteCode AS _WasteCode ON _WasteCode.ChmlCmplncInfoUUID = ActiveChmlCmplncInfoUUID  -- association [0..*]
LEFT OUTER JOIN P_CmbndChmlAssocdWasteCode AS _AssocdWasteCode ON _AssocdWasteCode.ChmlCmplncInfoUUID = ActiveChmlCmplncInfoUUID  -- association [0..1]
LEFT OUTER JOIN C_CmbndChmlCmplWasteDataTP AS _WasteData ON _WasteData.ChmlCmplncInfoUUID = ChmlCmplncInfoUUID  -- association [0..1]
LEFT OUTER JOIN C_CmbndChmlCmplncAssgdPCPrpty AS _DefaultPropertyAssignment ON _DefaultPropertyAssignment.ChmlCmplncInfoUUID = ActiveChmlCmplncInfoUUID  -- association [0..*]
LEFT OUTER JOIN P_CmbndChmlAssocdPCPrpty AS _AssocdPCPrpty ON _AssocdPCPrpty.ChmlCmplncInfoUUID = ActiveChmlCmplncInfoUUID  -- association [0..1]
LEFT OUTER JOIN C_CmbndChmlCmplncAddlPrpty AS _CmbndChmlCmplncAddlPrpty ON _CmbndChmlCmplncAddlPrpty.ChmlCmplncInfoUUID = ActiveChmlCmplncInfoUUID  -- association [0..*]
LEFT OUTER JOIN P_ChmlCmplncAssocAddlPrpty AS _ChmlCmplncAssocAddlPrpty ON _ChmlCmplncAssocAddlPrpty.ChmlCmplncInfoUUID = ActiveChmlCmplncInfoUUID  -- association [0..1]
LEFT OUTER JOIN C_CmbndChmlCmplncPrpsAssgmtTP AS _PurposeAssignment ON _PurposeAssignment.ChmlCmplncInfoUUID = ChmlCmplncInfoUUID  -- association [0..*]
LEFT OUTER JOIN C_CmbndChmlCmplncDngrsGdsAssmt AS _UnpckgdDngrsGdsAssmt ON _UnpckgdDngrsGdsAssmt.ChmlCmplncInfoUUID = ActiveChmlCmplncInfoUUID  -- association [0..*]
LEFT OUTER JOIN C_CmbndChmlPckgdDngrsGdsAssmt AS _PckgdDngrsGdsAssmt ON _PckgdDngrsGdsAssmt.ChmlCmplncProdUUID = ActiveChmlCmplncInfoUUID  -- association [0..*]
LEFT OUTER JOIN C_CmbndChmlCmplncUnpckgdProd AS _UnpckgdManualDngrsGds ON _UnpckgdManualDngrsGds.ChmlCmplncInfoUUID = ActiveChmlCmplncInfoUUID  -- association [0..*]
LEFT OUTER JOIN C_CmbndChmlCmplncPckgdProd AS _PckgdManualDngrsGds ON _PckgdManualDngrsGds.ChmlCmplncInfoUUID = ActiveChmlCmplncInfoUUID  -- association [0..*]
LEFT OUTER JOIN C_ChmlCmplncPrimMatl AS _MaterialDataPrimary ON _MaterialDataPrimary.ChmlCmplncInfoUUID = ActiveChmlCmplncInfoUUID  -- association [0..1]
LEFT OUTER JOIN C_ChmlCmplncRespUnitDngrsGdsVH AS _RespDangerousGoodsVH ON _RespDangerousGoodsVH.ResponsibleUnit = DngrsGdsRespUnit  -- association [0..1]
;