I_EnvrmtWasteTranspDocPart

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_EnvrmtWasteTranspDocPart.
-- 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: ITRADOCPART

CREATE VIEW I_EnvrmtWasteTranspDocPart AS
SELECT
  EnvWstTranspDocPartAssgdUUID,
  EnvrmtWastePartnerUUID,
  EnvrmtWastePartnerType,
  EnvrmtWastePartDsplFcltyUUID,
  EnvWstTranspDocTakeAcceptDate,
  EnvrmtWasteTranspDocUUID,
  EnvrmtWasteTrailerPlateTxt,
  EnvrmtWasteLicensePlateTxt,
  EnvWstTranspPrtnSequenceValue,
  EnvrmtWastePartSgntrDate,
  EnvrmtWastePartCntctPersnName,
  _DisposalFacility.EnvrmtWastePartFcltyName AS EnvrmtWastePartFcltyName,
  _WastePartner.EnvrmtWastePartnerNmbr AS BusinessPartner,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser
FROM ehewad_wa_trapar
LEFT OUTER JOIN I_EnvrmtWasteTranspDoc AS _TranspDoc ON EnvrmtWasteTranspDocUUID = _TranspDoc.EnvrmtWasteTranspDocUUID  -- association [1..1]
LEFT OUTER JOIN I_EnvrmtWastePartnerTypeText AS _TypeText ON EnvrmtWastePartnerType = _TypeText.EnvrmtWastePartnerType AND _TypeText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_EnvrmtWastePartner AS _WastePartner ON EnvrmtWastePartnerUUID = _WastePartner.EnvrmtWastePartnerUUID  -- association [1..1]
LEFT OUTER JOIN I_EnvrmtWastePartDsplFclty AS _DisposalFacility ON EnvrmtWastePartDsplFcltyUUID = _DisposalFacility.EnvrmtWastePartDsplFcltyUUID AND EnvrmtWastePartnerUUID = _DisposalFacility.EnvrmtWastePartnerUUID  -- association [1..1]
LEFT OUTER JOIN I_BPCurrentDefaultAddress AS _BPCurrentDefaultAddress ON BusinessPartner = _BPCurrentDefaultAddress.BusinessPartner  -- association [1..1]
;