I_WasteTransferRequestManageTP

DDL: I_WASTETRANSFERREQUESTMANAGETP Type: view_entity TRANSACTIONAL

Waste Transfer Request Manage - TP

I_WasteTransferRequestManageTP is a Transactional CDS View that provides data about "Waste Transfer Request Manage - TP" in SAP S/4HANA. It reads from 1 data source (R_WasteTransferRequestManageTP) and exposes 39 fields with key field WasteTransfReqUUID.

Data Sources (1)

SourceAliasJoin Type
R_WasteTransferRequestManageTP R_WasteTransferRequestManageTP projection

Annotations (15)

NameValueLevelField
EndUserText.label Waste Transfer Request Manage - TP view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.sapObjectNodeType.name WasteTransferRequest view
ObjectModel.modelingPattern #TRANSACTIONAL_INTERFACE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #TRANSACTIONAL view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.elementSuffix WTR view
AbapCatalog.extensibility.allowNewDatasources true view
AbapCatalog.extensibility.quota.maximumFields 1000 view
AbapCatalog.extensibility.quota.maximumBytes 100000 view
Metadata.ignorePropagatedAnnotations true view

Fields (39)

KeyFieldSource TableSource FieldDescription
KEY WasteTransfReqUUID WasteTransfReqUUID WTR UUID
WasteTransferRequestNumber WasteTransferRequestNumber Document Number ID
WasteTransfReqDate WasteTransfReqDate Date of WTR
WasteTransfReqStatus WasteTransfReqStatus Status
WasteStreamPtOfGnrtnLocUUID WasteStreamPtOfGnrtnLocUUID Pnt of Gnrtn UUID
EHSOutgoingAmountUUID EHSOutgoingAmountUUID Key
EnvrmtWasteOutgoingQuantity EnvrmtWasteOutgoingQuantity Quantity
EnvrmtWasteUnitOfMeasure EnvrmtWasteUnitOfMeasure Base Unit
EnvrmtWasteConfirmedQuantity EnvrmtWasteConfirmedQuantity
EnvrmtWasteConfirmedQtyCode EnvrmtWasteConfirmedQtyCode Base Unit
WasteStreamStorageLocIsHidden WasteStreamStorageLocIsHidden
EnvrmtWasteTotConfdQtyIsHidden EnvrmtWasteTotConfdQtyIsHidden
WasteStreamUUID WasteStreamUUID Waste Stream UUID
Country Country Venue: Ctry/Reg
Region Region Venue Region
WasteTransfReqPostDate WasteTransfReqPostDate Date of WTR
WasteStorageTimeLimitValue WasteStorageTimeLimitValue
WastePtOfGnrtnTimeLimitValue WastePtOfGnrtnTimeLimitValue
WasteStorageRemainingDaysValue WasteStorageRemainingDaysValue
WastePtOfGnrtnRemainingDaysVal WastePtOfGnrtnRemainingDaysVal
WasteTimeLimitEnablementSwitch WasteTimeLimitEnablementSwitch
WasteStorageDefaultWrngPerdVal WasteStorageDefaultWrngPerdVal
WastePtOfGnrtnDfltWrngPerdVal WastePtOfGnrtnDfltWrngPerdVal
WasteTransferRequestCritlty WasteTransferRequestCritlty
EnvrmtWasteGnrtrUUID EnvrmtWasteGnrtrUUID Waste Generator UUID
EnvrmtWasteTotConfirmedQty EnvrmtWasteTotConfirmedQty Confirmed Qty
EnvrmtWasteTotConfirmedQtyCode EnvrmtWasteTotConfirmedQtyCode Unit of Measurement
ChmlCmplncInfoUUID ChmlCmplncInfoUUID Chemical Compliance Information PP
WasteStreamMaterial WasteStreamMaterial Vehicle Model
WasteDisposalChannelUUID WasteDisposalChannelUUID UUID
EnvrmtWasteIsPermitHidden EnvrmtWasteIsPermitHidden
WasteDisposalChannelNumber WasteDisposalChannelNumber Number
WasteDisposalChannelName WasteDisposalChannelName Dispsl Channel Name
CreationDateTime CreationDateTime Timestamp
CreatedByUser CreatedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
_WasteGeneratorManagerByRole _WasteGeneratorManagerByRole
_WasteGeneratorOperatorByRole _WasteGeneratorOperatorByRole

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 I_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 I_WasteTransferRequestManageTP AS
SELECT
  WasteTransfReqUUID,
  WasteTransferRequestNumber,
  WasteTransfReqDate,
  WasteTransfReqStatus,
  WasteStreamPtOfGnrtnLocUUID,
  EHSOutgoingAmountUUID,
  EnvrmtWasteOutgoingQuantity,
  EnvrmtWasteUnitOfMeasure,
  EnvrmtWasteConfirmedQuantity,
  EnvrmtWasteConfirmedQtyCode,
  WasteStreamStorageLocIsHidden,
  EnvrmtWasteTotConfdQtyIsHidden,
  WasteStreamUUID,
  Country,
  Region,
  WasteTransfReqPostDate,
  WasteStorageTimeLimitValue,
  WastePtOfGnrtnTimeLimitValue,
  WasteStorageRemainingDaysValue,
  WastePtOfGnrtnRemainingDaysVal,
  WasteTimeLimitEnablementSwitch,
  WasteStorageDefaultWrngPerdVal,
  WastePtOfGnrtnDfltWrngPerdVal,
  WasteTransferRequestCritlty,
  EnvrmtWasteGnrtrUUID,
  EnvrmtWasteTotConfirmedQty,
  EnvrmtWasteTotConfirmedQtyCode,
  ChmlCmplncInfoUUID,
  WasteStreamMaterial,
  WasteDisposalChannelUUID,
  EnvrmtWasteIsPermitHidden,
  WasteDisposalChannelNumber,
  WasteDisposalChannelName,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser
FROM R_WasteTransferRequestManageTP
;