P_CustRetProcFlow10

DDL: P_CUSTRETPROCFLOW10 SQL: PCUSTRETPROCF10 Type: view CONSUMPTION
21 Fields 3 Data Sources

P_CustRetProcFlow10 is a Consumption CDS View in SAP S/4HANA. It reads from 3 data sources (P_CustRetProcFlow0, P_CustRetProcFlow0, I_SDDocumentProcessFlow) and exposes 21 fields with key fields Level0Document, Level0DocumentCategory, Level1Document, Level1DocumentItem, Level0DocumentCategory.

Data Sources (3)

SourceAliasJoin Type
P_CustRetProcFlow0 Level0 from
P_CustRetProcFlow0 Level0 union_all
I_SDDocumentProcessFlow Level1 inner

Annotations (8)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName PCUSTRETPROCF10 view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY Level0Document P_CustRetProcFlow0 CustomerReturn SD Document
KEY Level0DocumentCategory P_CustRetProcFlow0 SDDocumentCategory Document Cat.
KEY Level1Document I_SDDocumentProcessFlow SubsequentDocument
KEY Level1DocumentItem I_SDDocumentProcessFlow SubsequentDocumentItem
CustomerReturn P_CustRetProcFlow0 CustomerReturn SD Document
CustomerReturnType P_CustRetProcFlow0 CustomerReturnType Sales Doc. Type
SalesOrganization P_CustRetProcFlow0 SalesOrganization Sales Organization
DistributionChannel P_CustRetProcFlow0 DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision P_CustRetProcFlow0 OrganizationDivision Org. Division
PrecedingDocumentItem I_SDDocumentProcessFlow PrecedingDocumentItem
CustomerReturnasLevel0Document
KEY Level0DocumentCategory P_CustRetProcFlow0 SDDocumentCategory Document Cat.
KEY Level1Document I_SDDocumentProcessFlow ReturnsDocument
KEY Level1DocumentItem I_SDDocumentProcessFlow ReturnsDocumentItem
KEY Level1DocumentCategory SalesDoc SDDocumentCategory Document Cat.
CustomerReturn P_CustRetProcFlow0 CustomerReturn SD Document
CustomerReturnType P_CustRetProcFlow0 CustomerReturnType Sales Doc. Type
SalesOrganization P_CustRetProcFlow0 SalesOrganization Sales Organization
DistributionChannel P_CustRetProcFlow0 DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision P_CustRetProcFlow0 OrganizationDivision Org. Division
PrecedingDocumentItem I_SDDocumentProcessFlow CustomerReturnItem

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 P_CustRetProcFlow10.
-- 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: PCUSTRETPROCF10

CREATE VIEW P_CustRetProcFlow10 AS
SELECT
  Level0.CustomerReturn AS Level0Document,
  Level0.SDDocumentCategory AS Level0DocumentCategory,
  Level1.SubsequentDocument AS Level1Document,
  Level1.SubsequentDocumentItem AS Level1DocumentItem,
  Level0.CustomerReturn AS CustomerReturn,
  Level0.CustomerReturnType AS CustomerReturnType,
  Level0.SalesOrganization AS SalesOrganization,
  Level0.DistributionChannel AS DistributionChannel,
  Level0.OrganizationDivision AS OrganizationDivision,
  Level1.PrecedingDocumentItem AS PrecedingDocumentItem,
  case when ( DeliveryDoc.OverallDelivReltdBillgStatus = 'A' or DeliveryDoc.OverallDelivReltdBillgStatus = 'B' or SalesDoc.OverallOrdReltdBillgStatus = 'A' or SalesDoc.OverallOrdReltdBillgStatus = 'B' ) then 'X' else '' end as BillingDocumentIsRequired AS CustomerReturnasLevel0Document,
  SalesDoc.SDDocumentCategory AS Level1DocumentCategory
FROM P_CustRetProcFlow0 AS Level0
INNER JOIN I_SDDocumentProcessFlow AS Level1 ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): P_CustRetProcFlow0
;

Learn More