I_EnvrmtWasteTranspDoc

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_EnvrmtWasteTranspDoc.
-- 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: ITRADOC

CREATE VIEW I_EnvrmtWasteTranspDoc AS
SELECT
  EnvrmtWasteTranspDocUUID,
  envrmtwastetranspdocid AS WasteTranspDocID,
  EnvrmtWasteTranspDocNumber,
  EnvrmtWasteTranspDocType,
  CmplRqVersUUID,
  CmplRqVersPermitNumber,
  EnvrmtWasteGnrtrUUID,
  generator_id AS EnvrmtWasteGnrtrID,
  partner_number AS EnvrmtWastePartnerNmbr,
  EnvWstTranspDocReturnByDate,
  EnvrmtWasteTranspDocStatus,
  EnvWstTranspDocPrintedDate,
  EnvWstTranspDocHandoverDate,
  EnvWstTranspDocDescription,
  ChmlCmplncWasteCodeUUID,
  WasteStreamDsplChnlUUID,
  EnvrmtWasteTotConfirmedQty,
  EnvrmtWasteDcmlTotConfirmedQty,
  cast( ehsunitofmeasure as ehfnd_unit_code_meins preserving type ) AS EnvrmtWasteTotConfirmedQtyCode,
  EnvrmtWasteTotOutgoingQty,
  cast(envrmtwastetotoutgoingqtycode as ehfnd_unit_code_meins preserving type ) AS EnvrmtWasteTotOutgoingQtyCode,
  EnvWstTranspDocRemarkTxt,
  WasteTranspDocMatlIsTransfReq,
  DngrsGoodsModeOfTransport,
  WasteIsTransportedAbroad,
  ehswastetranspdocrecyclable AS EHSWasteTranspDocIsRecyclable,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser
FROM ehewad_wa_tradoc
LEFT OUTER JOIN I_EHSCmplRqPermit AS _Permit ON CmplRqVersUUID = _Permit.CmplRqVersUUID  -- association [0..1]
LEFT OUTER JOIN I_EHSCmplRqPmtWasteData AS _WasteData ON CmplRqVersUUID = _WasteData.CmplRqVersUUID  -- association [0..1]
LEFT OUTER JOIN I_CmplRqVersEnvrnmtlLimit AS _PermitLimit ON CmplRqVersUUID = _PermitLimit.CmplRqVersUUID AND _PermitLimit.CmplRqEnvrnmtlLimitType = '00'  -- association [1..1]
LEFT OUTER JOIN I_EnvWstTranspDocWasteLocation AS _Location ON _Location.EnvrmtWasteGnrtrUUID = EnvrmtWasteGnrtrUUID  -- association [1..1]
LEFT OUTER JOIN I_EnvWstTranspDocTextStatus AS _StatusText ON EnvrmtWasteTranspDocStatus = _StatusText.EnvrmtWasteTranspDocStatus  -- association [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_WasteDisposalChannel AS _DisposalChannel ON _DisposalChannel.WasteDisposalChannelUUID = WasteStreamDsplChnlUUID  -- association [0..1]
;