P_CustRetProcFlow20

DDL: P_CUSTRETPROCFLOW20 SQL: PCUSTRETPROCF20 Type: view CONSUMPTION
11 Fields 2 Data Sources

P_CustRetProcFlow20 is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (P_CustRetProcFlow10, I_SDDocumentProcessFlow) and exposes 11 fields with key fields Level2Document, Level2DocumentItem, Level1Document, Level1DocumentItem.

Data Sources (2)

SourceAliasJoin Type
P_CustRetProcFlow10 Level1 from
I_SDDocumentProcessFlow Level2 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
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName PCUSTRETPROCF20 view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY Level2Document
KEY Level2DocumentItem I_SDDocumentProcessFlow SubsequentDocumentItem
KEY Level1Document P_CustRetProcFlow10 Level1Document
KEY Level1DocumentItem P_CustRetProcFlow10 Level1DocumentItem
CustomerReturn P_CustRetProcFlow10 CustomerReturn
CustomerReturnType P_CustRetProcFlow10 CustomerReturnType
Level2DocumentCategory I_SDDocumentProcessFlow SubsequentDocumentCategory
Level1DocumentCategory P_CustRetProcFlow10 Level1DocumentCategory Document Cat.
SalesOrganization P_CustRetProcFlow10 SalesOrganization Sales Organization
DistributionChannel P_CustRetProcFlow10 DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision P_CustRetProcFlow10 OrganizationDivision Org. Division

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_CustRetProcFlow20.
-- 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: PCUSTRETPROCF20

CREATE VIEW P_CustRetProcFlow20 AS
SELECT
  cast(Level2.SubsequentDocument as preced_doc) AS Level2Document,
  Level2.SubsequentDocumentItem AS Level2DocumentItem,
  Level1.Level1Document AS Level1Document,
  Level1.Level1DocumentItem AS Level1DocumentItem,
  Level1.CustomerReturn AS CustomerReturn,
  Level1.CustomerReturnType AS CustomerReturnType,
  Level2.SubsequentDocumentCategory AS Level2DocumentCategory,
  Level1.Level1DocumentCategory AS Level1DocumentCategory,
  Level1.SalesOrganization AS SalesOrganization,
  Level1.DistributionChannel AS DistributionChannel,
  Level1.OrganizationDivision AS OrganizationDivision
FROM P_CustRetProcFlow10 AS Level1
INNER JOIN I_SDDocumentProcessFlow AS Level2 ON /* join condition not captured in parsed metadata */
;

Learn More