C_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 C_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 C_WasteTransferRequestManageTP AS
SELECT
  WasteTransfReqUUID,
  WasteTransferRequestNumber,
  WasteTransfReqDate,
  WasteTransfReqStatus,
  WasteTransfReqPostDate,
  virtual UICT_IsHiddenPostDate : abap_boolean AS virtualUICT_IsHiddenPostDateabap_boolean,
  _WasteStatus.WasteTransfReqStatusName AS WasteTransfReqStatusName,
  _LocText[1: Language = $session.system_language].EHSLocationName AS WasteStreamPtOfGnrtnLocName,
  _LocText[1: Language = 'E'].EHSLocationName AS WstStmPtOfGnrtnLocEnglishName,
  WasteStreamPtOfGnrtnLocUUID,
  WasteDisposalChannelNumber,
  _WasteDisposalChannel.WasteDisposalChannelName AS WasteDisposalChannelName,
  WasteDisposalChannelUUID,
  _ProductText[1: Language = $session.system_language].ProductDescription AS ProductName,
  _ProductText[1: Language = 'E'].ProductDescription AS ProductEnglishName,
  WasteStreamMaterial,
  _WasteStream.ChmlCmplncInfoUUID AS ChmlCmplncInfoUUID,
  _WasteStream.ChmlCmplncMatlAssgmtUUID AS ChmlCmplncMatlAssgmtUUID,
  EHSOutgoingAmountUUID,
  EnvrmtWasteOutgoingQuantity,
  EnvrmtWasteUnitOfMeasure,
  _UnitOfMeasureText[1: Language = $session.system_language].UnitOfMeasureLongName AS EnvrmtWasteUnitOfMeasureText,
  EnvrmtWasteConfirmedQuantity,
  EnvrmtWasteConfirmedQtyCode,
  _ConfUnitOfMeasureText[1: Language = $session.system_language].UnitOfMeasureLongName AS UnitOfMeasureLongName,
  _WasteStream.WasteStreamName AS WasteStreamName,
  WasteStreamUUID,
  _WasteStream.WasteStreamHandlingType AS WasteStreamHandlingType,
  EnvrmtWasteGnrtrUUID,
  _WasteGnrtrText[1: Language = $session.system_language].EnvrmtWasteGnrtrName AS EnvrmtWasteGnrtrName,
  _WasteStream._HandlingType.WasteStreamHandlingTypeText AS WasteStreamHandlingTypeText,
  virtual WasteStorageUnitOfMeasure : meins AS virtualWasteStorageUnitOfMeasuremeins,
  _CreatedByUserText.UserDescription AS CreatedByUserDescription,
  _LastChangedByUserText.UserDescription AS LastChangedByUserDescription,
  WasteStorageTimeLimitValue,
  WasteStorageRemainingDaysValue,
  WastePtOfGnrtnTimeLimitValue,
  WastePtOfGnrtnRemainingDaysVal,
  WasteStorageDefaultWrngPerdVal,
  WastePtOfGnrtnDfltWrngPerdVal,
  WasteTimeLimitEnablementSwitch,
  _WasteStream._WasteStorage.EHSLocationID AS EHSLocationID,
  _WasteStream._WasteStorage.EHSLocationName AS StorageLocationName,
  _WasteStream.WasteStreamStorageLocUUID AS WasteStreamStorageLocUUID,
  Country,
  Region,
  WasteTransferRequestCritlty,
  _Criticality.WasteTransfReqStatusName AS WasteTransfRequestCritltyName,
  _WasteDisposalChannel.WasteDsplChnlFacilityUUID AS WasteDsplChnlFacilityUUID,
  _WasteDisposalChannel._DisposalFacility.EnvrmtWastePartFcltyName AS EnvrmtWastePartFcltyName,
  _WasteDisposalChannel.WasteDsplChnlDisposerUUID AS WasteDsplChnlDisposerUUID,
  _WasteDisposalChannel.EnvrmtWasteTranspDocType AS EnvrmtWasteTranspDocType,
  EnvrmtWasteIsPermitHidden,
  EnvrmtWasteTotConfirmedQty,
  EnvrmtWasteTotConfirmedQtyCode,
  _TotConfUnitOfMeasureText[1: Language = $session.system_language].UnitOfMeasureLongName AS EnvrmtWasteTotConfirmedQtyName,
  WasteStreamStorageLocIsHidden,
  EnvrmtWasteTotConfdQtyIsHidden,
  virtual UICT_IsPoGTimeLimit : abap_boolean AS virtualUICT_IsPoGTimeLimitabap_boolean,
  virtual UICT_IsHiddenFld : abap_boolean AS virtualUICT_IsHiddenFldabap_boolean,
  virtual EHSFileMIMEType : w3conttype AS virtualEHSFileMIMETypew3conttype,
  EnvWstTransfReqRemarkTxt,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser
FROM R_WasteTransferRequestManageTP
LEFT OUTER JOIN E_WasteTransferRequest AS _Extension ON WasteTransfReqUUID = _Extension.WasteTransfReqUUID  -- association [0..1]
;