C_RFDYStockTransportOrderItem

DDL: C_RFDYSTOCKTRANSPORTORDERITEM Type: view_entity CONSUMPTION Package: ODATA_ATP_RELFORDEL
11 Fields 1 Data Sources 3 Associations 1 OData Services

Release for Delivery Stock Transport Order Item

C_RFDYStockTransportOrderItem is a Consumption CDS View that provides data about "Release for Delivery Stock Transport Order Item" in SAP S/4HANA. It reads from 1 data source (I_StockTransportOrderItem) and exposes 11 fields with key fields StockTransportOrder, StockTransportOrderItem. It has 3 associations to related views. It is exposed through 1 OData service (ASQL_F1786). Part of development package ODATA_ATP_RELFORDEL.

Data Sources (1)

SourceAliasJoin Type
I_StockTransportOrderItem I_StockTransportOrderItem from

Associations (3)

CardinalityTargetAliasCondition
[1..*] P_RFDYPurgSchedLineWthATPQts _PurchasingScheduleLine $projection.StockTransportOrder = _PurchasingScheduleLine.PurchasingDocument and $projection.StockTransportOrderItem = _PurchasingScheduleLine.PurchasingDocumentItem
[1..1] C_RFDYStockTransportOrder _RFDYStockTransportOrder $projection.StockTransportOrder = _RFDYStockTransportOrder.StockTransportOrder
[0..*] I_MaterialText _MaterialText $projection.Material = _MaterialText.Material

Annotations (7)

NameValueLevelField
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Release for Delivery Stock Transport Order Item view

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F1786 ASQL_F1786 C2 NOT_RELEASED

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY StockTransportOrder PurchaseOrder Purchasing Document
KEY StockTransportOrderItem PurchaseOrderItem Purchasing Document Item
Material Material Vehicle Model
ReceivingPlant ReceivingPlant Receiving Plant
TotalRequestedQuantity
TotalConfirmedQuantity
BaseUnit BaseUnit Unit of Measure
_StockTransportOrder _StockTransportOrder
_RFDYStockTransportOrder _RFDYStockTransportOrder
_MaterialText _MaterialText
_Plant _Plant

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_RFDYStockTransportOrderItem.
-- 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_RFDYStockTransportOrderItem AS
SELECT
  PurchaseOrder AS StockTransportOrder,
  PurchaseOrderItem AS StockTransportOrderItem,
  Material,
  ReceivingPlant,
  sum(_PurchasingScheduleLine.RequestedQuantity) AS TotalRequestedQuantity,
  sum(_PurchasingScheduleLine.ConfirmedQuantity) AS TotalConfirmedQuantity,
  BaseUnit
FROM I_StockTransportOrderItem
LEFT OUTER JOIN P_RFDYPurgSchedLineWthATPQts AS _PurchasingScheduleLine ON StockTransportOrder = _PurchasingScheduleLine.PurchasingDocument AND StockTransportOrderItem = _PurchasingScheduleLine.PurchasingDocumentItem  -- association [1..*]
LEFT OUTER JOIN C_RFDYStockTransportOrder AS _RFDYStockTransportOrder ON StockTransportOrder = _RFDYStockTransportOrder.StockTransportOrder  -- association [1..1]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material  -- association [0..*]
;

Learn More