C_RFDYSalesOrderItem

DDL: C_RFDYSALESORDERITEM Type: view_entity CONSUMPTION
11 Fields 1 Data Sources 2 Associations

Release for Delivery Sales Order Item

C_RFDYSalesOrderItem is a Consumption CDS View that provides data about "Release for Delivery Sales Order Item" in SAP S/4HANA. It reads from 1 data source (I_SalesOrderItem) and exposes 11 fields with key fields SalesOrder, SalesOrderItem. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_SalesOrderItem I_SalesOrderItem from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_MaterialText _MaterialText $projection.Material = _MaterialText.Material
[0..1] P_RFDYConfFigsBySalesOrderItem _ConfirmationFigures $projection.SalesOrder = _ConfirmationFigures.SalesOrder and $projection.SalesOrderItem = _ConfirmationFigures.SalesOrderItem

Annotations (6)

NameValueLevelField
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Release for Delivery Sales Order Item view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY SalesOrder SalesOrder SD Document
KEY SalesOrderItem SalesOrderItem Sales Order Item
Material Material Vehicle Model
ProductionPlant Plant Valuation Area
TotalConfirmedQuantity _ConfirmationFigures TotalConfirmedQuantity Total to Be Confirmed
TotalRequestedQuantity _ConfirmationFigures TotalRequestedQuantity
BaseUnit _ConfirmationFigures BaseUnit Unit of Measure
_SalesOrder _SalesOrder
_Material _Material
_Plant _Plant
_MaterialText _MaterialText

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_RFDYSalesOrderItem.
-- 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_RFDYSalesOrderItem AS
SELECT
  SalesOrder,
  SalesOrderItem,
  Material,
  Plant AS ProductionPlant,
  _ConfirmationFigures.TotalConfirmedQuantity AS TotalConfirmedQuantity,
  _ConfirmationFigures.TotalRequestedQuantity AS TotalRequestedQuantity,
  _ConfirmationFigures.BaseUnit AS BaseUnit
FROM I_SalesOrderItem
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material  -- association [0..*]
LEFT OUTER JOIN P_RFDYConfFigsBySalesOrderItem AS _ConfirmationFigures ON SalesOrder = _ConfirmationFigures.SalesOrder AND SalesOrderItem = _ConfirmationFigures.SalesOrderItem  -- association [0..1]
;

Learn More