I_WasteAnalyticsDimension

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_WasteAnalyticsDimension.
-- 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_WasteAnalyticsDimension AS
SELECT
  TranspDoc.EnvrmtWasteTranspDocUUID AS EnvrmtWasteTranspDocUUID,
  TranspDocMat.EnvWstTranspDocMatlAssgdUUID AS EnvWstTranspDocMatlAssgdUUID,
  TranspDoc.WasteTranspDocID AS WasteTranspDocID,
  TranspDoc.EnvrmtWasteTranspDocType AS EnvrmtWasteTranspDocType,
  TranspDoc.EnvrmtWasteTranspDocStatus AS EnvrmtWasteTranspDocStatus,
  TranspDoc.CmplRqVersPermitNumber AS CmplRqVersPermitNumber,
  TranspDoc.CmplRqVersUUID AS CmplRqVersUUID,
  TranspDoc.EnvrmtWasteGnrtrUUID AS EnvrmtWasteGnrtrUUID,
  cast( _Location.EHSLocationID as ehewa_waste_generator_id preserving type ) AS EnvrmtWasteGnrtrID,
  TranspDoc._Location._EHSLocationRoot.WasteRegistrationNumber AS WasteRegistrationNumber,
  TranspDoc.WasteStreamDsplChnlUUID AS WasteStreamDsplChnlUUID,
  TranspDoc._DisposalChannel.WasteDisposalChannelNumber AS WasteDisposalChannelNumber,
  TranspDoc._DisposalChannel.WasteDisposalChannelName AS WasteDisposalChannelName,
  TranspDoc._DisposalChannel._DisposalFacility.EnvrmtWasteFcltyRegistrationID AS EnvrmtWasteFcltyRegistrationID,
  TranspDoc._DisposalChannel._DisposalFacility.EnvrmtWastePartFcltyName AS EnvrmtWastePartFcltyName,
  TranspDoc.EnvWstTranspDocHandoverDate AS EnvWstTranspDocHandoverDate,
  TranspDoc.EnvWstTranspDocPrintedDate AS EnvWstTranspDocPrintedDate,
  TranspDocMat.Material AS Material,
  TranspDocMat.WasteTransferRequestNumber AS WasteTransferRequestNumber,
  TranspDocMat.WasteStreamContainerType AS WasteStreamContainerType,
  TranspDocMat.ChmlCmplncInfoUUID AS ChmlCmplncInfoUUID,
  _ChmlCmplncWasteData.EnvrmtWasteHazardCharcID AS EnvrmtWasteHazardCharcID,
  _Disposer.EnvrmtWastePartDsplFcltyUUID AS EnvrmtWastePartDsplFcltyUUID,
  _Disposer.EnvrmtWastePartnerUUID AS EnvrmtWastePartnerUUID,
  _Disposer.BusinessPartner AS BusinessPartner,
  _Disposer.EnvWstTranspDocTakeAcceptDate AS EnvWstTranspDocDisposerDate,
  _WasteTransferRequest.WasteStreamUUID AS WasteStreamUUID,
  TranspDoc.DngrsGoodsModeOfTransport AS DngrsGoodsModeOfTransport,
  FLTP_TO_DEC( TranspDocMat._OutAmount.EHSAmountValue as abap.dec( 10, 3 )) AS EnvrmtWasteOutgoingQuantity,
  FLTP_TO_DEC( TranspDocMat._ConfirmedAmount.EHSAmountValue as abap.dec( 10, 3 )) AS EnvrmtWasteConfirmedQuantity,
  cast(TranspDocMat._OutAmount.UnitOfMeasure as meins preserving type ) AS EnvrmtWasteOutgoingQtyCode,
  cast( TranspDocMat._ConfirmedAmount.UnitOfMeasure as meins preserving type ) AS EnvrmtWasteConfirmedQtyCode
FROM I_EnvrmtWasteTranspDoc AS TranspDoc
INNER JOIN I_EnvrmtWasteTranspDocMatl AS TranspDocMat ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_WasteTranspDocDisposerDimn AS _Disposer ON EnvrmtWasteTranspDocUUID = _Disposer.EnvrmtWasteTranspDocUUID  -- association [0..1]
LEFT OUTER JOIN I_EnvWstTranspDocWasteLocation AS _Location ON EnvrmtWasteGnrtrUUID = _Location.EnvrmtWasteGnrtrUUID  -- association [0..1]
LEFT OUTER JOIN I_LocationDescFallbackLang AS _LocTextDesc ON EnvrmtWasteGnrtrUUID = _LocTextDesc.EHSLocationUUID  -- association [0..1]
LEFT OUTER JOIN I_WasteTransportDocTransporter AS _EnvrmtWasteTransporter ON _EnvrmtWasteTransporter.EnvrmtWasteTranspDocUUID = EnvrmtWasteTranspDocUUID  -- association [0..*]
LEFT OUTER JOIN I_WasteTransfReqDimension AS _WasteTransferRequest ON WasteTransferRequestNumber = _WasteTransferRequest.WasteTransferRequestNumber  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Product ON Material = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _CalendarHandover ON EnvWstTranspDocHandoverDate = _CalendarHandover.CalendarDate  -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _CalendarPrinted ON EnvWstTranspDocPrintedDate = _CalendarPrinted.CalendarDate  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasureOutgoingQty ON EnvrmtWasteOutgoingQtyCode = _UnitOfMeasureOutgoingQty.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasureConfirmedQty ON EnvrmtWasteConfirmedQtyCode = _UnitOfMeasureConfirmedQty.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_WastePermitDimension AS _Permit ON CmplRqVersPermitNumber = _Permit.CmplRqVersPermitNumber  -- association [0..1]
LEFT OUTER JOIN I_WasteContainerTypeDimension AS _ContainerTypeDimn ON WasteStreamContainerType = _ContainerTypeDimn.WasteStreamContainerType  -- association [0..1]
LEFT OUTER JOIN I_WasteTranspDocStsDimension AS _TranspDocSts ON EnvrmtWasteTranspDocStatus = _TranspDocSts.EnvrmtWasteTranspDocStatus  -- association [0..1]
LEFT OUTER JOIN I_WasteTranspDocGnrtrDimension AS _TranspDocGnrtr ON EnvrmtWasteGnrtrID = _TranspDocGnrtr.EnvrmtWasteGnrtrID  -- association [0..1]
LEFT OUTER JOIN I_WasteTranspDocTypeDimension AS _TranspDocType ON EnvrmtWasteTranspDocType = _TranspDocType.EnvrmtWasteTranspDocType  -- association [0..1]
LEFT OUTER JOIN I_WasteDisposalChnlDimension AS _DisposalChnlDimn ON wastedisposalchannelnumber = _DisposalChnlDimn.WasteDisposalChannelNumber  -- association [0..1]
LEFT OUTER JOIN I_WasteDisposerDimension AS _PartnerDisposerDimn ON businesspartner = _PartnerDisposerDimn.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_EnvrmtProductWasteData AS _ChmlCmplncWasteData ON _ChmlCmplncWasteData.ChmlCmplncInfoUUID = ChmlCmplncInfoUUID  -- association [0..1]
LEFT OUTER JOIN I_WasteHzdCharcDimn AS _HazardCharacteristic ON _HazardCharacteristic.EnvrmtWasteHazardCharcID = envrmtwastehazardcharcid  -- association [0..1]
LEFT OUTER JOIN I_WasteHazardTypeDimension AS _HazardCharacteristicIMG ON _HazardCharacteristicIMG.EnvrmtWasteHazardCharcID = envrmtwastehazardcharcid  -- association [0..1]
LEFT OUTER JOIN I_EnvrmtWasteTranspDocMatlDimn AS _TranspDocMat ON _TranspDocMat.EnvWstTranspDocMatlAssgdUUID = EnvWstTranspDocMatlAssgdUUID  -- association [0..1]
;