I_WasteAnalyticsCube

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_WasteAnalyticsCube.
-- 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.
-- Parameters: P_Date : sydatum, P_Language : sylangu

CREATE VIEW I_WasteAnalyticsCube AS
SELECT
  EnvrmtWasteTranspDocUUID,
  EnvWstTranspDocMatlAssgdUUID,
  _ProductWasteCode.EnvrmtWasteCodeUUID AS EnvrmtWasteCodeUUID,
  _RgtyCode.WasteStreamRgtyCode AS WasteStreamRgtyCode,
  _RgtyCode.WasteStreamRgtyCodeValue AS WasteStreamRgtyCodeValue,
  _EnvrmtWasteTransporter.EnvrmtWastePartnerNmbr AS EnvrmtWastePartnerNmbr,
  _EHSLocationForFiltering(P_Date: $parameters.P_Date).EHSParentLocationID AS EHSMainLocationID,
  _EHSLocationForFiltering(P_Date: $parameters.P_Date)._EHSLocationRevisionNameT[1: Language = $parameters.P_Language and RevisionStartDate <= $parameters.P_Date and RevisionEndDate >= $parameters.P_Date ].EHSLocationName AS EHSMainLocationName,
  _DangerousGoods.CmplRqVersUUID AS CmplRqVersUUID,
  _DangerousGoods.ClassifiedAsDangerousGood AS ClassifiedAsDangerousGood,
  WasteTranspDocID,
  EnvrmtWasteTranspDocType,
  EnvrmtWasteTranspDocStatus,
  CmplRqVersPermitNumber,
  EnvWstTranspDocPrintedDate,
  EnvWstTranspDocHandoverDate,
  _EnvrmtWasteTransporter.EnvWstTranspDocTakeAcceptDate AS EnvWstTranspDocTakeAcceptDate,
  _EnvrmtWasteTransporter.EnvrmtWasteTransptrRegnID AS EnvrmtWasteTransptrRegnID,
  EnvrmtWasteGnrtrUUID,
  EnvrmtWasteGnrtrID,
  WasteRegistrationNumber,
  WasteTransferRequestNumber,
  _WasteTransferRequest.WasteStreamPtOfGnrtnLocUUID AS WasteStreamPtOfGnrtnLocUUID,
  _WasteTransferRequest.EHSLocationID AS EHSLocationID,
  _WasteTransferRequest.WasteTransfReqStatus AS WasteTransfReqStatus,
  _WasteTransferRequest.CostCenter AS CostCenter,
  WasteStreamUUID,
  WasteStreamDsplChnlUUID,
  WasteDisposalChannelNumber,
  WasteDisposalChannelName,
  EnvrmtWasteFcltyRegistrationID,
  EnvrmtWastePartFcltyName,
  BusinessPartner,
  EnvWstTranspDocDisposerDate,
  Material,
  WasteStreamContainerType,
  _MethCode.EnvrmtWasteMgmtMethCode AS EnvrmtWasteMgmtMethCode,
  EnvrmtWasteHazardCharcID,
  _ProductWasteCode.EnvrmtWasteCode AS EnvrmtWasteCode,
  _ProductWasteCode.EnvrmtWasteCodeShortDesc AS EnvrmtWasteCodeShortDesc,
  _RgtyCode._RegCodeValue.WasteStreamRgtyCodeValueText AS WasteStreamRgtyCodeValueText,
  _DangerousGoods.CmplRqVers AS CmplRqVers,
  _DangerousGoods.CmplRqVersName AS CmplRqVersName,
  ComplianceRequirement,
  DngrsGoodsModeOfTransport,
  EnvrmtWasteOutgoingQuantity,
  EnvrmtWasteConfirmedQuantity,
  EnvrmtWasteOutgoingQtyCode,
  EnvrmtWasteConfirmedQtyCode,
  EnvrmtWastePartDsplFcltyUUID,
  EnvrmtWastePartnerUUID,
  ChmlCmplncInfoUUID,
  _WasteTransferRequest._WasteStatus AS _WasteStatus,
  _WasteTransferRequest._WastePtOfGnrtn AS _WastePtOfGnrtn,
  _RgtyCode._RegCode AS _RegCode,
  _RgtyCode._RgtyCodeValDimn AS _RgtyCodeValDimn
FROM I_WasteAnalyticsDimension
LEFT OUTER JOIN I_EnvrmtWastePartMatlAssgmt AS _MethCode ON EnvrmtWastePartDsplFcltyUUID = _MethCode.EnvrmtWastePartDsplFcltyUUID AND EnvrmtWastePartnerUUID = _MethCode.EnvrmtWastePartnerUUID AND ChmlCmplncInfoUUID = _MethCode.ChmlCmplncInfoUUID  -- association [0..1]
LEFT OUTER JOIN I_WasteMgmtMethCodeDimension AS _MethCodeDimn ON envrmtwastemgmtmethcode = _MethCodeDimn.EnvrmtWasteMgmtMethCode  -- association [0..1]
LEFT OUTER JOIN I_WasteTransporterDimension AS _PartnerTransporterDimn ON envrmtwastepartnernmbr = _PartnerTransporterDimn.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_WstStmRgtyCodeDstct AS _RgtyCode ON WasteStreamUUID = _RgtyCode.WasteStreamUUID  -- association [0..*]
LEFT OUTER JOIN I_EnvrmtWasteDngrsGdsCmbnd AS _DangerousGoods ON ChmlCmplncInfoUUID = _DangerousGoods.ChmlCmplncInfoUUID AND ComplianceRequirement = _DangerousGoods.ComplianceRequirement AND ( DngrsGoodsModeOfTransport = _DangerousGoods.DngrsGoodsModeOfTransport OR DngrsGoodsModeOfTransport is initial )  -- association [0..*]
LEFT OUTER JOIN I_WasteDangerousGoodDimension AS _ClassifiedAs ON classifiedasdangerousgood = _ClassifiedAs.ClassifiedAsDangerousGood  -- association [0..1]
LEFT OUTER JOIN I_EnvrmtProductWasteCode AS _ProductWasteCode ON ChmlCmplncInfoUUID = _ProductWasteCode.ChmlCmplncInfoUUID  -- association [0..*]
LEFT OUTER JOIN I_EnvrmtWasteCodeDimension AS _WasteCodeDimn ON envrmtwastecode = _WasteCodeDimn.EnvrmtWasteCode  -- association [0..1]
LEFT OUTER JOIN I_WasteCmplRqVersDimn AS _CmplRqVers ON cmplrqvers = _CmplRqVers.CmplRqVers  -- association [0..1]
LEFT OUTER JOIN I_EHSLocationForFiltering AS _EHSLocationForFiltering ON EnvrmtWasteGnrtrUUID = _EHSLocationForFiltering.EHSLocationUUID  -- association [1..*]
;