R_WasteTransferRequestManageTP

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 R_WasteTransferRequestManageTP.
-- 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 R_WasteTransferRequestManageTP AS
SELECT
  WasteTransfReqUUID,
  WasteTransferRequestNumber,
  WasteTransfReqDate,
  WasteTransfReqStatus,
  WasteStreamPtOfGnrtnLocUUID,
  EHSOutgoingAmountUUID,
  EnvrmtWasteUnitOfMeasure,
  cast(cast(_WasteTransportDocMatl._ConfirmedAmount.EHSAmountValue as abap.decfloat16) as abap.dec(10,3)) AS EnvrmtWasteConfirmedQuantity,
  cast(_WasteTransportDocMatl._ConfirmedAmount.UnitOfMeasure as meins preserving type ) AS EnvrmtWasteConfirmedQtyCode,
  WasteStreamUUID,
  Country,
  Region,
  WasteTransfReqPostDate,
  _WasteStream.EnvrmtWasteGnrtrUUID AS EnvrmtWasteGnrtrUUID,
  _WasteTransportDocMatl._TranspDoc.EnvrmtWasteTotConfirmedQty AS EnvrmtWasteTotConfirmedQty,
  _WasteTransportDocMatl._TranspDoc.EnvrmtWasteTotConfirmedQtyCode AS EnvrmtWasteTotConfirmedQtyCode,
  _WasteStream.ChmlCmplncInfoUUID AS ChmlCmplncInfoUUID,
  _WasteStream.Material AS WasteStreamMaterial,
  WasteDisposalChannelUUID,
  _WasteDisposalChannel._TransportDocTypeDesc.EnvrmtWasteIsPermitHidden AS EnvrmtWasteIsPermitHidden,
  _WasteDisposalChannel.WasteDisposalChannelNumber AS WasteDisposalChannelNumber,
  _WasteDisposalChannel.WasteDisposalChannelName AS WasteDisposalChannelName,
  EnvWstTransfReqRemarkTxt,
  WasteTransfReqHasInvtryMgmtErr,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser
FROM I_WasteTransferRequest
LEFT OUTER JOIN I_UnitOfMeasureText AS _TotConfUnitOfMeasureText ON envrmtwastetotconfirmedqtycode = _TotConfUnitOfMeasureText.UnitOfMeasure  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasureText AS _ConfUnitOfMeasureText ON EnvrmtWasteConfirmedQtyCode = _ConfUnitOfMeasureText.UnitOfMeasure  -- association [0..*]
LEFT OUTER JOIN I_User AS _CreatedByUserText ON CreatedByUser = _CreatedByUserText.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUserText ON LastChangedByUser = _LastChangedByUserText.UserID  -- association [0..1]
LEFT OUTER JOIN I_WasteTransferReqTmeLimits AS _TimeLimit ON Country = _TimeLimit.Country AND _TimeLimit.Region is initial  -- association [0..1]
LEFT OUTER JOIN I_WasteTransferReqTmeLimits AS _TimeLimitRegion ON Country = _TimeLimitRegion.Country AND Region = _TimeLimitRegion.Region  -- association [0..1]
LEFT OUTER JOIN I_WasteTransferRequestCritlty AS _Criticality ON WasteTransferRequestCritlty = _Criticality.WasteTransferRequestCritlty  -- association [0..1]
LEFT OUTER JOIN R_WasteStreamTP AS _WasteStream ON WasteStreamUUID = _WasteStream.WasteStreamUUID  -- association [0..1]
LEFT OUTER JOIN R_WasteDisposalChannelTP AS _WasteDisposalChannel ON WasteDisposalChannelUUID = _WasteDisposalChannel.WasteDisposalChannelUUID  -- association [0..1]
LEFT OUTER JOIN I_ProductDescription AS _ProductText ON WasteStreamMaterial = _ProductText.Product  -- association [0..*]
LEFT OUTER JOIN I_EnvrmtWasteGnrtrText AS _WasteGnrtrText ON EnvrmtWasteGnrtrUUID = _WasteGnrtrText.EnvrmtWasteGnrtrUUID  -- association [0..*]
LEFT OUTER JOIN I_WasteStreamLocationText AS _LocText ON WasteStreamPtOfGnrtnLocUUID = _LocText.EHSLocationUUID  -- association [0..*]
LEFT OUTER JOIN E_WasteTransferRequest AS _Extension ON WasteTransfReqUUID = _Extension.WasteTransfReqUUID  -- association [0..1]
LEFT OUTER JOIN R_WasteTransferReqFllwOnDocTP AS _WasteTransferReqFllwOnDoc ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_WasteTransferRequestHistTP AS _WasteTransferRequestHistory ON /* condition not available in parsed metadata */  -- association [0..*]
;