C_ChmlCmplncInfoTP

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_ChmlCmplncInfoTP.
-- 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.

CREATE VIEW C_ChmlCmplncInfoTP AS
SELECT
  MaterialIsSold,
  MaterialIsProduced,
  MaterialIsSourced,
  MaterialIsDisposed,
  MaterialIsEmissionRelevant,
  _ActiveDraftCCI.ChmlCmplncInfoIsActiveEntity AS ChmlCmplncInfoIsActiveEntity,
  I_ChmlCmplncInfoTP.ActiveChmlCmplncInfoUUID AS CmplRqRsltNavgnLink,
  Specification AS SpecificationNavgnLink,
  LastChangeUTCDateTime,
  LastChangedByUser,
  cast( _LastChangedByUser.UserDescription as ehfnd_bo_lchg_uname_enhanced preserving type ) AS LastChangedByUserName,
  cast( '' as ehfnd_sub_polymer_oecd ) AS PolymerIsBsdOnOECDDef,
  cast('' as ehfnd_phrs_text ) AS ChmlCmplncProdCatztnPhrs1Text,
  ChmlCmplncProdCatztnPhrsUUID,
  cast('' as ehfnd_boolean ) AS ChmlCmplncProdCatztnIsArticle
FROM I_ChmlCmplncInfoTP
LEFT OUTER JOIN C_ChmlCmplncMatlAssgmtTP AS _MaterialAssignment ON _MaterialAssignment.ChmlCmplncInfoUUID = ChmlCmplncInfoUUID  -- association [0..*]
LEFT OUTER JOIN C_ChmlCmplncProdAssgmt AS _ActiveProductAssignment ON _ActiveProductAssignment.ChmlCmplncProdUUID = ActiveChmlCmplncInfoUUID  -- association [0..*]
LEFT OUTER JOIN C_ChmlCmplncMktReqTP AS _MarketRequest ON _MarketRequest.ChmlCmplncInfoUUID = ChmlCmplncInfoUUID  -- association [0..*]
LEFT OUTER JOIN C_ChmlCmplncPrpsAssgmtTP AS _PurposeAssignment ON _PurposeAssignment.ChmlCmplncInfoUUID = ChmlCmplncInfoUUID  -- association [0..*]
LEFT OUTER JOIN C_ChmlCmplncApplAssgmtTP AS _Application ON _Application.ChmlCmplncInfoUUID = ChmlCmplncInfoUUID  -- association [0..*]
LEFT OUTER JOIN C_ChmlCmplncUse AS _Uses ON _Uses.ChmlCmplncInfoUUID = ChmlCmplncInfoUUID  -- association [0..*]
LEFT OUTER JOIN C_AssociatedProductComposition AS _Composition ON _Composition.ChmlCmplncInfoUUID = ChmlCmplncInfoUUID  -- association [0..*]
LEFT OUTER JOIN C_ChmlCmplncInfoAssgdPCPrpty AS _Properties ON _Properties.ChmlCmplncInfoUUID = ChmlCmplncInfoUUID  -- association [0..*]
LEFT OUTER JOIN C_ChmlCmplncPrimMatl AS _MaterialDataPrimary ON _MaterialDataPrimary.ChmlCmplncInfoUUID = ActiveChmlCmplncInfoUUID  -- association [0..1]
LEFT OUTER JOIN I_ChmlCmplncInfoActiveDraft AS _ActiveDraftCCI ON ActiveChmlCmplncInfoUUID = _ActiveDraftCCI.ActiveChmlCmplncInfoUUID  -- association [1..1]
LEFT OUTER JOIN C_ChmlCmplncRespUnitDngrsGdsVH AS _RespDangerousGoodsVH ON _RespDangerousGoodsVH.ResponsibleUnit = DngrsGdsRespUnit  -- association [0..1]
LEFT OUTER JOIN C_ChmlCmplncRespUnitProductVH AS _RespProductStewardshipVH ON _RespProductStewardshipVH.ResponsibleUnit = ProdStewardshipRespUnit  -- association [0..1]
LEFT OUTER JOIN P_CChmlCmplConstants AS _CChmlCmplConstants ON _CChmlCmplConstants.Constant0 = _CChmlCmplConstants.Constant0  -- association [0..1]
;