R_WasteTransferRequestHistTP

DDL: R_WASTETRANSFERREQUESTHISTTP Type: view_entity TRANSACTIONAL
28 Fields 1 Data Sources 7 Associations

Waste Trasnfer Req Log Of Activity - TP

R_WasteTransferRequestHistTP is a Transactional CDS View that provides data about "Waste Trasnfer Req Log Of Activity - TP" in SAP S/4HANA. It reads from 1 data source (I_WasteTransferRequestHistory) and exposes 28 fields with key field WasteTransfRequestHistoryUUID. It has 7 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_WasteTransferRequestHistory I_WasteTransferRequestHistory from

Associations (7)

CardinalityTargetAliasCondition
[0..1] I_User _CreatedByUserText $projection.CreatedByUser = _CreatedByUserText.UserID
[0..*] I_UnitOfMeasureText _UnitOfMeasureText $projection.UnitOfMeasure = _UnitOfMeasureText.UnitOfMeasure
[0..*] I_UnitOfMeasureText _UnitOfMeasureOldText $projection.WasteTransferRequestOldUoM = _UnitOfMeasureOldText.UnitOfMeasure
[0..1] I_WasteTransferRequestStatus _WasteStatus $projection.WasteTransfReqStatus = _WasteStatus.WasteTransfReqStatus
[0..1] I_WasteTransferRequestStatus _OldWasteStatus $projection.WasteTransfReqStatusOld = _OldWasteStatus.WasteTransfReqStatus
[0..1] E_WasteTransferRequestHistory _Extension $projection.WasteTransfRequestHistoryUUID = _Extension.WasteTransfRequestHistoryUUID
[0..1] E_WasteTransferRequest _ExtensionMain $projection.WasteTransfReqUUID = _ExtensionMain.WasteTransfReqUUID

Annotations (8)

NameValueLevelField
EndUserText.label Waste Trasnfer Req Log Of Activity - TP view
AccessControl.authorizationCheck #MANDATORY view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.representativeKey WasteTransfRequestHistoryUUID view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY WasteTransfRequestHistoryUUID WasteTransfRequestHistoryUUID WTR UUID
WasteTransfReqUUID WasteTransfReqUUID WTR UUID
WasteTransfReqStatus WasteTransfReqStatus Status
WasteTransfReqDate WasteTransfReqDate Date of WTR
WasteStreamUUID WasteStreamUUID Waste Stream UUID
WasteStreamPtOfGnrtnLocUUID WasteStreamPtOfGnrtnLocUUID Pnt of Gnrtn UUID
EHSAmountValue EHSAmountValue Value
UnitOfMeasure UnitOfMeasure Unit Protected Qty
WasteTransfReqStatusOld WasteTransfReqStatusOld Status
WasteTransfOldReqDate WasteTransfOldReqDate Date of WTR
WasteStreamOldUUID WasteStreamOldUUID Waste Stream UUID
WasteStreamOldPtOfGnrtnLocUUID WasteStreamOldPtOfGnrtnLocUUID Pnt of Gnrtn UUID
EHSAmountOldValue EHSAmountOldValue Value
WasteTransferRequestOldUoM WasteTransferRequestOldUoM
CreationDateTime CreationDateTime Timestamp
CreatedByUser CreatedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
_WasteTransferRequest _WasteTransferRequest
_CreatedByUserText _CreatedByUserText
_UnitOfMeasureText _UnitOfMeasureText
_UnitOfMeasureOldText _UnitOfMeasureOldText
_WasteStatus _WasteStatus
_OldWasteStatus _OldWasteStatus
_WasteStream _WasteStream
_WasteStorage _WasteStorage
_OldWasteStream _OldWasteStream
_OldWasteStorage _OldWasteStorage

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 R_WasteTransferRequestHistTP.
-- 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 R_WasteTransferRequestHistTP AS
SELECT
  WasteTransfRequestHistoryUUID,
  WasteTransfReqUUID,
  WasteTransfReqStatus,
  WasteTransfReqDate,
  WasteStreamUUID,
  WasteStreamPtOfGnrtnLocUUID,
  EHSAmountValue,
  UnitOfMeasure,
  WasteTransfReqStatusOld,
  WasteTransfOldReqDate,
  WasteStreamOldUUID,
  WasteStreamOldPtOfGnrtnLocUUID,
  EHSAmountOldValue,
  WasteTransferRequestOldUoM,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser
FROM I_WasteTransferRequestHistory
LEFT OUTER JOIN I_User AS _CreatedByUserText ON CreatedByUser = _CreatedByUserText.UserID  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasureText AS _UnitOfMeasureText ON UnitOfMeasure = _UnitOfMeasureText.UnitOfMeasure  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasureText AS _UnitOfMeasureOldText ON WasteTransferRequestOldUoM = _UnitOfMeasureOldText.UnitOfMeasure  -- association [0..*]
LEFT OUTER JOIN I_WasteTransferRequestStatus AS _WasteStatus ON WasteTransfReqStatus = _WasteStatus.WasteTransfReqStatus  -- association [0..1]
LEFT OUTER JOIN I_WasteTransferRequestStatus AS _OldWasteStatus ON WasteTransfReqStatusOld = _OldWasteStatus.WasteTransfReqStatus  -- association [0..1]
LEFT OUTER JOIN E_WasteTransferRequestHistory AS _Extension ON WasteTransfRequestHistoryUUID = _Extension.WasteTransfRequestHistoryUUID  -- association [0..1]
LEFT OUTER JOIN E_WasteTransferRequest AS _ExtensionMain ON WasteTransfReqUUID = _ExtensionMain.WasteTransfReqUUID  -- association [0..1]
;

Learn More