C_RFDYOutboundDeliveryItem

DDL: C_RFDYOUTBOUNDDELIVERYITEM SQL: CRFDYODELIVI Type: view CONSUMPTION
13 Fields 1 Data Sources 1 Associations

Release for Delivery Outbound Delivery Item

C_RFDYOutboundDeliveryItem is a Consumption CDS View that provides data about "Release for Delivery Outbound Delivery Item" in SAP S/4HANA. It reads from 1 data source (I_OutboundDeliveryItem) and exposes 13 fields with key fields OutboundDelivery, OutboundDeliveryItem. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_OutboundDeliveryItem I_OutboundDeliveryItem from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_OverallSDProcessStatusText _OverallSDProcessStatusText $projection.overallsdprocessstatus = _OverallSDProcessStatusText.OverallSDProcessStatus

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CRFDYODELIVI view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Release for Delivery Outbound Delivery Item view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY OutboundDelivery OutboundDelivery LE Delivery
KEY OutboundDeliveryItem OutboundDeliveryItem Logistics Execution Delivery Item
ReferenceSDDocument ReferenceSDDocument Reference Doc.
ReferenceSDDocumentItem ReferenceSDDocumentItem Reference Item
ReferenceSDDocumentCategory ReferenceSDDocumentCategory Prec.Doc.Categ.
ActualDeliveredQtyInBaseUnit ActualDeliveredQtyInBaseUnit
BaseUnit BaseUnit Unit of Measure
OverallSDProcessStatus _OutboundDelivery OverallSDProcessStatus
CreationDate _OutboundDelivery CreationDate Time Stamp
_OverallSDProcessStatus _OutboundDelivery _OverallSDProcessStatus
_OverallSDProcessStatusText _OverallSDProcessStatusText
_BaseUnit _BaseUnit
_OutboundDelivery _OutboundDelivery

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_RFDYOutboundDeliveryItem.
-- 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.
-- SQL view name: CRFDYODELIVI

CREATE VIEW C_RFDYOutboundDeliveryItem AS
SELECT
  OutboundDelivery,
  OutboundDeliveryItem,
  ReferenceSDDocument,
  ReferenceSDDocumentItem,
  ReferenceSDDocumentCategory,
  ActualDeliveredQtyInBaseUnit,
  BaseUnit,
  _OutboundDelivery.OverallSDProcessStatus AS OverallSDProcessStatus,
  _OutboundDelivery.CreationDate AS CreationDate,
  _OutboundDelivery._OverallSDProcessStatus AS _OverallSDProcessStatus
FROM I_OutboundDeliveryItem
LEFT OUTER JOIN I_OverallSDProcessStatusText AS _OverallSDProcessStatusText ON overallsdprocessstatus = _OverallSDProcessStatusText.OverallSDProcessStatus  -- association [0..*]
;

Learn More