C_WasteStreamTP

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_WasteStreamTP.
-- 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_WasteStreamTP AS
SELECT
  WasteStreamUUID,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser,
  ChmlCmplncInfoUUID,
  ChmlCmplncMatlAssgmtUUID,
  Material,
  EnvrmtWasteGnrtrUUID,
  _MaterialGenerator.ProductIsPackaged AS ProductIsPackaged,
  WasteStreamHandlingType,
  WasteStreamStorageLocUUID,
  _MaterialGenerator.WasteStorageTimeLimitValue AS WasteStorageTimeLimitValue,
  _MaterialGenerator.WasteStorageDefaultWrngPerdVal AS WasteStorageDefaultWrngPerdVal,
  _MaterialGenerator.WastePtOfGnrtnTimeLimitValue AS WastePtOfGnrtnTimeLimitValue,
  _MaterialGenerator.WastePtOfGnrtnDfltWrngPerdVal AS WastePtOfGnrtnDfltWrngPerdVal,
  virtual UICT_IsPoGTimeLimit : abap_boolean AS virtualUICT_IsPoGTimeLimitabap_boolean,
  _MaterialGenerator.WasteTimeLimitEnablementSwitch AS WasteTimeLimitEnablementSwitch,
  WasteStreamContainerType,
  _MaterialGenerator._MaterialText.ProductDescription AS ProductDescription,
  _MaterialGenerator._EnvrmtWasteGnrtrByMgrRole.EnvrmtWasteGnrtrHasCurUsrAssgd AS EnvrmtWasteGnrtrHasCurUsrAssgd,
  _MaterialGenerator.EnvrmtWasteGnrtrValdtyAreaTxt AS EnvrmtWasteGnrtrValdtyAreaTxt,
  _MaterialGenerator.Country AS Country,
  virtual AddressCountry : land1 AS virtualAddressCountryland1,
  cast( _MaterialGenerator.EnvrmtWasteGnrtrID as ehfnd_loc_id preserving type ) AS EnvrmtWasteGnrtrID,
  virtual EHSLocationURL : abap.char( 1024 ) AS char1024,
  _MaterialGenerator.Material AS WasteStreamMaterial,
  WasteStreamStorageTimeLimit,
  _WasteStorage.EHSLocationName AS WasteStreamStorageLocName,
  _WasteStorage.EHSLocationID AS WasteStreamStorageLocID,
  virtual EnvrmtWasteCodeString : abap.sstring(1000) AS sstring1000,
  _HandlingType.WasteStreamHandlingTypeText AS WasteStreamHandlingTypeText,
  _ContainerType._Text[1: Language = $session.system_language].WasteStreamContainerTypeText AS WasteStreamContainerTypeText
FROM R_WasteStreamTP
;