C_ReturnsDeliveryProcFlow

DDL: C_RETURNSDELIVERYPROCFLOW SQL: CRETSDLVPROCFLOW Type: view CONSUMPTION Package: ODATA_LE_PROCESSFLOW
14 Fields 1 Data Sources

Returns Delivery Process Flow

C_ReturnsDeliveryProcFlow is a Consumption CDS View that provides data about "Returns Delivery Process Flow" in SAP S/4HANA. It reads from 1 data source (I_CustomerReturnDelivery) and exposes 14 fields with key fields ReturnsDelivery, PrecedingDocument, PrecedingDocumentCategory, SubsequentDocument, SubsequentDocumentCategory. Part of development package ODATA_LE_PROCESSFLOW.

Data Sources (1)

SourceAliasJoin Type
I_CustomerReturnDelivery Delivery inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CRETSDLVPROCFLOW view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Returns Delivery Process Flow view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.compositionRoot true view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY ReturnsDelivery I_CustomerReturnDelivery CustomerReturnDelivery
KEY PrecedingDocument Flow PrecedingDocument SD Document
KEY PrecedingDocumentCategory Flow PrecedingDocumentCategory
KEY SubsequentDocument
KEY SubsequentDocumentCategory Flow SubsequentDocumentCategory
ShippingPoint I_CustomerReturnDelivery ShippingPoint Shipping Point
SalesDocument Flow SalesDocument SD Document
PurchaseOrder Flow PurchaseOrder Purchasing Document
WarehouseNumber Flow WarehouseNumber
WrhsMgmtTransferOrder Flow WrhsMgmtTransferOrder
MaterialDocument Flow MaterialDocument Material Doc.
MaterialDocumentYear Flow MaterialDocumentYear Material Document Year
BillingDocument Flow BillingDocument SD Document
FreightOrder Flow FreightOrder Freight Order

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_ReturnsDeliveryProcFlow.
-- 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: CRETSDLVPROCFLOW

CREATE VIEW C_ReturnsDeliveryProcFlow AS
SELECT
  Delivery.CustomerReturnDelivery AS ReturnsDelivery,
  Flow.PrecedingDocument AS PrecedingDocument,
  Flow.PrecedingDocumentCategory AS PrecedingDocumentCategory,
  cast(Flow.SubsequentDocument as subsequ_doc) AS SubsequentDocument,
  Flow.SubsequentDocumentCategory AS SubsequentDocumentCategory,
  Delivery.ShippingPoint AS ShippingPoint,
  Flow.SalesDocument AS SalesDocument,
  Flow.PurchaseOrder AS PurchaseOrder,
  Flow.WarehouseNumber AS WarehouseNumber,
  Flow.WrhsMgmtTransferOrder AS WrhsMgmtTransferOrder,
  Flow.MaterialDocument AS MaterialDocument,
  Flow.MaterialDocumentYear AS MaterialDocumentYear,
  Flow.BillingDocument AS BillingDocument,
  Flow.FreightOrder AS FreightOrder
INNER JOIN I_CustomerReturnDelivery AS Delivery ON /* join condition not captured in parsed metadata */
;

Learn More