C_WasteStreamPointOfGnrtnVH

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 C_WasteStreamPointOfGnrtnVH.
-- 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 C_WasteStreamPointOfGnrtnVH AS
SELECT
  WasteStreamPtOfGnrtnUUID,
  WasteStreamPtOfGnrtnLocUUID,
  WasteStreamUUID,
  EnvrmtWasteGnrtrUUID,
  ChmlCmplncMatlAssgmtUUID,
  ChmlCmplncInfoUUID,
  _WasteStream._WasteGenerator.EHSLocationID AS WasteStreamStorageLocID,
  _WasteStream._HandlingType.WasteStreamStorageLocIsRqd AS WasteStreamStorageLocIsRqd,
  _EnvrmtWasteGnrtrText.EnvrmtWasteGnrtrName AS EnvrmtWasteGnrtrName,
  coalesce( _LocText[1:Language = $session.system_language].EHSLocationName, _LocText[1:Language = 'E'].EHSLocationName ) AS EHSLocationName,
  _LocText[1:Language = $session.system_language].EHSLocationName AS WasteStreamPtOfGnrtnLocName,
  _LocText[1:Language = 'E'].EHSLocationName AS WasteStreamPtOfGnrtnOldLocName,
  _WastePtOfGnrtn.EHSLocationID AS WasteStreamPtOfGnrtnLocID,
  Material,
  coalesce( _WasteStream._ProductText[1: Language = $session.system_language].ProductDescription, _WasteStream._ProductText[1: Language = 'E'].ProductDescription ) as ProductDescription AS ProductDescriptionasProductDescription,
  _WasteStream._ProductText[1: Language = $session.system_language].ProductDescription AS ProductName,
  _WasteStream._ProductText[1: Language = 'E'].ProductDescription AS MaterialName,
  _WasteStream.WasteStreamName AS WasteStreamName,
  cast( '00000000' as ehewa_wst_trf_req_date ) AS WasteTransfReqDate,
  cast( 0 as abap.quan( 13, 3 ) ) AS EnvrmtWasteOutgoingQuantity,
  WasteStorageUnitOfMeasure,
  _UnitOfMeasureText[1:Language = $session.system_language].UnitOfMeasureLongName AS UnitOfMeasureLongName,
  _DisposalChannelDefault.WasteDisposalChannelUUID AS WasteDisposalChannelUUID,
  _DisposalChannelDefault._WasteDisposalChannel._DisposalChannelStatus.WasteDisposalChannelStatusName AS WasteDisposalChannelStatusName,
  _DisposalChnlWasteStream._WasteStreamStatus.WasteDisposalChannelStatusName AS WasteDsplChnlWstStmStsTxt,
  _DisposalChannelDefault._WasteDisposalChannel.WasteDisposalChannelName AS WasteDisposalChannelName,
  _WasteStream._WasteStorage.EHSLocationName AS StorageLocationName,
  _WasteStream._WasteGenerator.Country AS Country,
  _WasteStream._WasteGenerator.Region AS Region,
  _WasteStream._WasteGenerator._Region AS _Region
LEFT OUTER JOIN I_Country AS _Country ON country = _Country.Country  -- association [1..1]
LEFT OUTER JOIN I_WasteStreamLocationText AS _LocText ON WasteStreamPtOfGnrtnLocUUID = _LocText.EHSLocationUUID  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasureText AS _UnitOfMeasureText ON WasteStorageUnitOfMeasure = _UnitOfMeasureText.UnitOfMeasure  -- association [0..*]
;