C_WasteTransferRequestTP

DDL: C_WASTETRANSFERREQUESTTP Type: view_entity CONSUMPTION
44 Fields 1 Data Sources

Waste Transfer Request Header Info

C_WasteTransferRequestTP is a Consumption CDS View that provides data about "Waste Transfer Request Header Info" in SAP S/4HANA. It reads from 1 data source (R_WasteTransferRequestManageTP) and exposes 44 fields with key field WasteTransfReqUUID.

Data Sources (1)

SourceAliasJoin Type
R_WasteTransferRequestManageTP R_WasteTransferRequestManageTP projection

Annotations (9)

NameValueLevelField
EndUserText.label Waste Transfer Request Header Info view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.representativeKey WasteTransfReqUUID view
Metadata.allowExtensions true view
Search.searchable true view

Fields (44)

KeyFieldSource TableSource FieldDescription
KEY WasteTransfReqUUID WasteTransfReqUUID WTR UUID
WasteTransferRequestNumber WasteTransferRequestNumber Document Number ID
WasteTransfReqDate WasteTransfReqDate Date of WTR
WasteTransfReqStatus WasteTransfReqStatus Status
WasteTransfReqStatusName _WasteStatus WasteTransfReqStatusName
WasteStreamPtOfGnrtnLocName
WstStmPtOfGnrtnLocEnglishName
WasteStreamPtOfGnrtnLocID _WasteStorage EHSLocationID
WasteStreamPtOfGnrtnLocUUID WasteStreamPtOfGnrtnLocUUID Pnt of Gnrtn UUID
ProductName
ProductEnglishName
WasteStreamMaterial WasteStreamMaterial Vehicle Model
EHSOutgoingAmountUUID EHSOutgoingAmountUUID Key
EnvrmtWasteUnitOfMeasure EnvrmtWasteUnitOfMeasure Base Unit
virtualWasteStorageUnitOfMeasuremeins
EnvrmtWasteUnitOfMeasureText
WasteStreamUUID WasteStreamUUID Waste Stream UUID
char1
virtualEHSFileMIMETypew3conttype
WasteStreamName _WasteStream WasteStreamName Waste Stream Name
EnvrmtWasteTotConfirmedQty EnvrmtWasteTotConfirmedQty Confirmed Qty
EnvrmtWasteTotConfirmedQtyCode EnvrmtWasteTotConfirmedQtyCode Unit of Measurement
EnvrmtWasteTotConfirmedQtyName
ChmlCmplncInfoUUID ChmlCmplncInfoUUID Chemical Compliance Information PP
ChmlCmplncMatlAssgmtUUID _WasteStream ChmlCmplncMatlAssgmtUUID Product Assignment
EnvrmtWasteGnrtrUUID EnvrmtWasteGnrtrUUID Waste Generator UUID
Country Country Venue: Ctry/Reg
Region Region Venue Region
WasteDisposalChannelUUID WasteDisposalChannelUUID UUID
CreationDateTime CreationDateTime Timestamp
CreatedByUserDescription _CreatedByUserText UserDescription Full Name
createdBytrueCreatedByUser
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUserDescription _LastChangedByUserText UserDescription Full Name
LastChangedByUser LastChangedByUser User Name
Associations_Amount
_WasteStorage _WasteStorage
_WasteStream _WasteStream
_CreatedByUserText _CreatedByUserText
_LastChangedByUserText _LastChangedByUserText
_WasteStatus _WasteStatus
_UnitOfMeasureText _UnitOfMeasureText
_WasteGeneratorOperatorByRole _WasteGeneratorOperatorByRole
_WasteGeneratorManagerByRole _WasteGeneratorManagerByRole

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_WasteTransferRequestTP.
-- 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_WasteTransferRequestTP AS
SELECT
  WasteTransfReqUUID,
  WasteTransferRequestNumber,
  WasteTransfReqDate,
  WasteTransfReqStatus,
  _WasteStatus.WasteTransfReqStatusName AS WasteTransfReqStatusName,
  _LocText[1: Language = $session.system_language].EHSLocationName AS WasteStreamPtOfGnrtnLocName,
  _LocText[1: Language = 'E'].EHSLocationName AS WstStmPtOfGnrtnLocEnglishName,
  _WasteStorage.EHSLocationID AS WasteStreamPtOfGnrtnLocID,
  WasteStreamPtOfGnrtnLocUUID,
  _ProductText[1: Language = $session.system_language].ProductDescription AS ProductName,
  _ProductText[1: Language = 'E'].ProductDescription AS ProductEnglishName,
  WasteStreamMaterial,
  EHSOutgoingAmountUUID,
  EnvrmtWasteUnitOfMeasure,
  virtual WasteStorageUnitOfMeasure : meins AS virtualWasteStorageUnitOfMeasuremeins,
  _UnitOfMeasureText[1: Language = $session.system_language].UnitOfMeasureLongName AS EnvrmtWasteUnitOfMeasureText,
  WasteStreamUUID,
  virtual UICT_MyWasteTransferRqstFilter : abap.char( 1 ) AS char1,
  virtual EHSFileMIMEType : w3conttype AS virtualEHSFileMIMETypew3conttype,
  _WasteStream.WasteStreamName AS WasteStreamName,
  EnvrmtWasteTotConfirmedQty,
  EnvrmtWasteTotConfirmedQtyCode,
  _ConfUnitOfMeasureText[1: Language = $session.system_language].UnitOfMeasureLongName AS EnvrmtWasteTotConfirmedQtyName,
  ChmlCmplncInfoUUID,
  _WasteStream.ChmlCmplncMatlAssgmtUUID AS ChmlCmplncMatlAssgmtUUID,
  EnvrmtWasteGnrtrUUID,
  Country,
  Region,
  WasteDisposalChannelUUID,
  CreationDateTime,
  _CreatedByUserText.UserDescription AS CreatedByUserDescription,
  user.createdBy: true CreatedByUser AS createdBytrueCreatedByUser,
  LastChangeDateTime,
  _LastChangedByUserText.UserDescription AS LastChangedByUserDescription,
  LastChangedByUser
FROM R_WasteTransferRequestManageTP
;

Learn More