A_ReturnsDeliveryDocFlow

DDL: A_RETURNSDELIVERYDOCFLOW SQL: ARETSDELIVERYDF Type: view BASIC

Returns Delivery Document Flow

A_ReturnsDeliveryDocFlow is a Basic CDS View that provides data about "Returns Delivery Document Flow" in SAP S/4HANA. It reads from 1 data source (I_SDDocumentProcessFlow) and exposes 12 fields with key fields PrecedingDocument, PrecedingDocumentItem, PrecedingDocumentCategory, SubsequentDocument, SubsequentDocumentItem. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_SDDocumentProcessFlow I_SDDocumentProcessFlow from

Associations (2)

CardinalityTargetAliasCondition
[1..1] A_ReturnsDeliveryItem _Item _Item.DeliveryDocument = $projection.PrecedingDocument and _Item.DeliveryDocumentItem = $projection.PrecedingDocumentItem
[1..1] A_ReturnsDeliveryHeader _DeliveryDocumentHeader $projection.PrecedingDocument = _DeliveryDocumentHeader.DeliveryDocument

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ARETSDELIVERYDF view
AbapCatalog.compiler.compareFilter true view
Metadata.ignorePropagatedAnnotations true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Returns Delivery Document Flow view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY PrecedingDocument I_SDDocumentProcessFlow PrecedingDocument SD Document
KEY PrecedingDocumentItem I_SDDocumentProcessFlow PrecedingDocumentItem Item
KEY PrecedingDocumentCategory I_SDDocumentProcessFlow PrecedingDocumentCategory
KEY SubsequentDocument I_SDDocumentProcessFlow SubsequentDocument
KEY SubsequentDocumentItem I_SDDocumentProcessFlow SubsequentDocumentItem
KEY SubsequentDocumentCategory I_SDDocumentProcessFlow SubsequentDocumentCategory
SDFulfillmentCalculationRule I_SDDocumentProcessFlow SDFulfillmentCalculationRule
BaseUnit I_SDDocumentProcessFlow BaseUnit Unit of Measure
QuantityInBaseUnit I_SDDocumentProcessFlow QuantityInBaseUnit Quantity
TransferOrderInWrhsMgmtIsConfd I_SDDocumentProcessFlow TransferOrderInWrhsMgmtIsConfd
_Item _Item
_DeliveryDocumentHeader _DeliveryDocumentHeader

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 A_ReturnsDeliveryDocFlow.
-- 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: ARETSDELIVERYDF

CREATE VIEW A_ReturnsDeliveryDocFlow AS
SELECT
  I_SDDocumentProcessFlow.PrecedingDocument AS PrecedingDocument,
  I_SDDocumentProcessFlow.PrecedingDocumentItem AS PrecedingDocumentItem,
  I_SDDocumentProcessFlow.PrecedingDocumentCategory AS PrecedingDocumentCategory,
  I_SDDocumentProcessFlow.SubsequentDocument AS SubsequentDocument,
  I_SDDocumentProcessFlow.SubsequentDocumentItem AS SubsequentDocumentItem,
  I_SDDocumentProcessFlow.SubsequentDocumentCategory AS SubsequentDocumentCategory,
  I_SDDocumentProcessFlow.SDFulfillmentCalculationRule AS SDFulfillmentCalculationRule,
  I_SDDocumentProcessFlow.BaseUnit AS BaseUnit,
  I_SDDocumentProcessFlow.QuantityInBaseUnit AS QuantityInBaseUnit,
  I_SDDocumentProcessFlow.TransferOrderInWrhsMgmtIsConfd AS TransferOrderInWrhsMgmtIsConfd
FROM I_SDDocumentProcessFlow
LEFT OUTER JOIN A_ReturnsDeliveryItem AS _Item ON _Item.DeliveryDocument = PrecedingDocument AND _Item.DeliveryDocumentItem = PrecedingDocumentItem  -- association [1..1]
LEFT OUTER JOIN A_ReturnsDeliveryHeader AS _DeliveryDocumentHeader ON PrecedingDocument = _DeliveryDocumentHeader.DeliveryDocument  -- association [1..1]
;