R_WasteDeliveryNoteDataTP

DDL: R_WASTEDELIVERYNOTEDATATP Type: view_entity TRANSACTIONAL
11 Fields 1 Data Sources 2 Associations

Waste Delivery Note Data - TP

R_WasteDeliveryNoteDataTP is a Transactional CDS View that provides data about "Waste Delivery Note Data - TP" in SAP S/4HANA. It reads from 1 data source (I_WasteDeliveryNoteData) and exposes 11 fields with key field WasteDeliveryNoteDataUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_WasteDeliveryNoteData I_WasteDeliveryNoteData from

Associations (2)

CardinalityTargetAliasCondition
[1..1] R_EnvrmtWasteTranspDocTP _EnvrmtWasteTranspDoc $projection.EnvrmtWasteTranspDocUUID = _EnvrmtWasteTranspDoc.EnvrmtWasteTranspDocUUID
[1..1] R_WasteTransferRequestManageTP _WasteTransferRequest $projection.WasteTransfReqUUID = _WasteTransferRequest.WasteTransfReqUUID

Annotations (10)

NameValueLevelField
EndUserText.label Waste Delivery Note Data - 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 WasteDeliveryNoteDataUUID view
ObjectModel.sapObjectNodeType.name WasteDeliveryNoteData view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY WasteDeliveryNoteDataUUID WasteDeliveryNoteDataUUID Note Data UUID
WasteDeliveryNoteUUID WasteDeliveryNoteUUID Delivery Note UUID
EnvrmtWasteTranspDocUUID EnvrmtWasteTranspDocUUID WTR UUID
WasteTransfReqUUID WasteTransfReqUUID WTR UUID
AdminDataCreationDateTime
CreatedByUser CreatedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
_DeliveryNote _DeliveryNote
_EnvrmtWasteTranspDoc _EnvrmtWasteTranspDoc
_WasteTransferRequest _WasteTransferRequest

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_WasteDeliveryNoteDataTP.
-- 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_WasteDeliveryNoteDataTP AS
SELECT
  WasteDeliveryNoteDataUUID,
  WasteDeliveryNoteUUID,
  EnvrmtWasteTranspDocUUID,
  WasteTransfReqUUID,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser
FROM I_WasteDeliveryNoteData
LEFT OUTER JOIN R_EnvrmtWasteTranspDocTP AS _EnvrmtWasteTranspDoc ON EnvrmtWasteTranspDocUUID = _EnvrmtWasteTranspDoc.EnvrmtWasteTranspDocUUID  -- association [1..1]
LEFT OUTER JOIN R_WasteTransferRequestManageTP AS _WasteTransferRequest ON WasteTransfReqUUID = _WasteTransferRequest.WasteTransfReqUUID  -- association [1..1]
;

Learn More