R_WasteTranspDocPurOrdTP

DDL: R_WASTETRANSPDOCPURORDTP Type: view_entity TRANSACTIONAL
9 Fields 1 Data Sources 1 Associations

Waste Transportation Document Purchase Order - TP

R_WasteTranspDocPurOrdTP is a Transactional CDS View that provides data about "Waste Transportation Document Purchase Order - TP" in SAP S/4HANA. It reads from 1 data source (I_WasteTranspDocPurOrd) and exposes 9 fields with key field WasteTranspDocPurOrderUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_WasteTranspDocPurOrd I_WasteTranspDocPurOrd from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_PurchaseOrderAPI01 _PurchaseOrder $projection.PurchaseOrder = _PurchaseOrder.PurchaseOrder

Annotations (9)

NameValueLevelField
EndUserText.label Waste Transportation Document Purchase Order - TP view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.representativeKey WasteTranspDocPurOrderUUID view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY WasteTranspDocPurOrderUUID WasteTranspDocPurOrderUUID
EnvrmtWasteTranspDocUUID EnvrmtWasteTranspDocUUID WTR UUID
PurchaseOrder PurchaseOrder Purchasing Document
CreationDateTime CreationDateTime Timestamp
CreatedByUser CreatedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
_TranspDoc _TranspDoc
_PurchaseOrder _PurchaseOrder

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_WasteTranspDocPurOrdTP.
-- 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_WasteTranspDocPurOrdTP AS
SELECT
  WasteTranspDocPurOrderUUID,
  EnvrmtWasteTranspDocUUID,
  PurchaseOrder,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser
FROM I_WasteTranspDocPurOrd
LEFT OUTER JOIN I_PurchaseOrderAPI01 AS _PurchaseOrder ON PurchaseOrder = _PurchaseOrder.PurchaseOrder  -- association [1..1]
;

Learn More