C_WasteTransferRequestTP

DDL: C_WASTETRANSFERREQUESTTP Type: view_entity CONSUMPTION
37 Fields 1 Data Sources 1 OData Services 1 Fiori Apps

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 37 fields with key field WasteTransfReqUUID. It is exposed through 1 OData service (UI_WASTETRANSFERREQUEST). It is used in 1 Fiori application: My Waste Transfer Requests.

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

OData Services (1)

ServiceBindingVersionContractRelease
UI_WASTETRANSFERREQUEST UI_WASTETRANSFERREQUEST V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F6083 My Waste Transfer Requests Transactional The app will allow the production operator to create Internal Waste Transfer Requests when the waste container is full. A notification will be sent to the Environment Manager to process the request, which will be done in the “Manage Waste Transfer Request” app.

My Waste Transfer Requests

Business Role: Production Operator - EHS Info

With this app, an Environmental Manager can manage and create waste transfer requests. Waste transfer requests are the starting point for disposal processing. In the waste transfer request, you document the point of generation of the waste product, the related waste stream and disposal channel, the date of the transfer request, and the quantity of waste that was produced and the unit of measure. The waste transfer request also contains the data required for disposal processing. Waste transfer requests serve as a notification that waste can be moved from the point of generation. If a storage location has been specified, the waste product will be moved from the point of generation to a central collection point or to a local collection point. It will later be moved from the collection point to a disposal facility by the transporter. If no storage location has been specified, the waste product will be moved directly from the point of generation to the disposal facility by the transporter. Only a user with the role Environmental Manager (SAP_BR_EHS_ENV_MGMT) associated to a location, classified as waste generator, can manage waste transfer requests using this app. The location is called "waste generator" in the waste management context.

Fields (37)

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 _WasteStorage EHSLocationName
WasteStreamPtOfGnrtnLocID _WasteStorage EHSLocationID
WasteStreamPtOfGnrtnLocUUID WasteStreamPtOfGnrtnLocUUID Pnt of Gnrtn UUID
ProductDescription
WasteStreamMaterial WasteStreamMaterial Vehicle Model
EHSOutgoingAmountUUID EHSOutgoingAmountUUID Key
EnvrmtWasteUnitOfMeasure EnvrmtWasteUnitOfMeasure Base Unit
virtualWasteStorageUnitOfMeasuremeins
EnvrmtWasteUnitOfMeasureText
WasteStreamUUID WasteStreamUUID Waste Stream UUID
char1
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
createdBytrueCreatedByUser
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
Associations_Amount
_WasteStorage _WasteStorage
_WasteStream _WasteStream
_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,
  _WasteStorage.EHSLocationName AS WasteStreamPtOfGnrtnLocName,
  _WasteStorage.EHSLocationID AS WasteStreamPtOfGnrtnLocID,
  WasteStreamPtOfGnrtnLocUUID,
  _ProductText[1: Language = $session.system_language].ProductDescription AS ProductDescription,
  WasteStreamMaterial,
  EHSOutgoingAmountUUID,
  EnvrmtWasteUnitOfMeasure,
  virtual WasteStorageUnitOfMeasure : meins AS virtualWasteStorageUnitOfMeasuremeins,
  _UnitOfMeasureText[1: Language = $session.system_language].UnitOfMeasureName AS EnvrmtWasteUnitOfMeasureText,
  WasteStreamUUID,
  virtual UICT_MyWasteTransferRqstFilter : abap.char( 1 ) AS char1,
  _WasteStream.WasteStreamName AS WasteStreamName,
  EnvrmtWasteTotConfirmedQty,
  EnvrmtWasteTotConfirmedQtyCode,
  _ConfUnitOfMeasureText[1: Language = $session.system_language].UnitOfMeasureName AS EnvrmtWasteTotConfirmedQtyName,
  ChmlCmplncInfoUUID,
  _WasteStream.ChmlCmplncMatlAssgmtUUID AS ChmlCmplncMatlAssgmtUUID,
  EnvrmtWasteGnrtrUUID,
  Country,
  Region,
  WasteDisposalChannelUUID,
  CreationDateTime,
  user.createdBy: true CreatedByUser AS createdBytrueCreatedByUser,
  LastChangeDateTime,
  LastChangedByUser
FROM R_WasteTransferRequestManageTP
;

Learn More