I_WasteTransferRequest

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_WasteTransferRequest.
-- 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 I_WasteTransferRequest AS
SELECT
  WasteTransfReqUUID,
  WasteTransferRequestNumber,
  WasteTransfReqDate,
  WasteTransfReqStatus,
  WasteStreamPtOfGnrtnLocUUID,
  EHSOutgoingAmountUUID,
  WasteStreamUUID,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser,
  Country,
  Region,
  WasteTransfReqPostDate,
  wastestreamdsplchnluuid AS WasteDisposalChannelUUID,
  EnvrmtWasteUnitOfMeasure,
  EnvrmtWasteOutgoingQuantity,
  EnvWstTransfReqRemarkTxt,
  has_im_error AS WasteTransfReqHasInvtryMgmtErr
FROM ehewad_wa_trrq
LEFT OUTER JOIN I_WasteStreamRelevantLocation AS _WasteStorage ON WasteStreamPtOfGnrtnLocUUID = _WasteStorage.EHSLocationUUID  -- association [1..1]
LEFT OUTER JOIN I_EHSAmountRoot AS _Amount ON EHSOutgoingAmountUUID = _Amount.EHSAmountUUID  -- association [0..1]
LEFT OUTER JOIN I_WasteStream AS _WasteStream ON WasteStreamUUID = _WasteStream.WasteStreamUUID  -- association [1..1]
LEFT OUTER JOIN I_WasteTransferRequestStatus AS _WasteStatus ON WasteTransfReqStatus = _WasteStatus.WasteTransfReqStatus  -- association [0..1]
LEFT OUTER JOIN I_EnvrmtWasteGnrtrByMgrRole AS _WasteGeneratorManagerByRole ON WasteStreamPtOfGnrtnLocUUID = _WasteGeneratorManagerByRole.EHSLocationUUID  -- association [0..1]
LEFT OUTER JOIN I_EnvrmtWasteGnrtrByOptrRole AS _WasteGeneratorOperatorByRole ON WasteStreamPtOfGnrtnLocUUID = _WasteGeneratorOperatorByRole.EHSLocationUUID  -- association [0..1]
LEFT OUTER JOIN I_WasteDisposalChannel AS _DisposalChannel ON WasteDisposalChannelUUID = _DisposalChannel.WasteDisposalChannelUUID  -- association [0..1]
LEFT OUTER JOIN I_EnvrmtWasteTranspDocMatl AS _WasteTransportDocMatl ON WasteTransfReqUUID = _WasteTransportDocMatl.WasteTransfReqUUID AND _WasteTransportDocMatl.EnvrmtWasteTranspDocStatus <> 'S08'  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasureText AS _UnitOfMeasureText ON EnvrmtWasteUnitOfMeasure = _UnitOfMeasureText.UnitOfMeasure  -- association [0..*]
;