P_CustRetProcFlow32

DDL: P_CUSTRETPROCFLOW32 SQL: PCUSTRETPROCF32 Type: view CONSUMPTION
14 Fields 1 Data Sources

P_CustRetProcFlow32 is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (P_CustRetProcFlow05) and exposes 14 fields with key fields Level0Document, Level0DocumentItem.

Data Sources (1)

SourceAliasJoin Type
P_CustRetProcFlow05 Level0 from

Annotations (7)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName PCUSTRETPROCF32 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY Level0Document P_CustRetProcFlow05 Level1Document
KEY Level0DocumentItem P_CustRetProcFlow05 Level1DocumentItem Reference item
Level0DocumentCategory P_CustRetProcFlow05 Level1DocumentCategory
RetsMgmtProcItmQtySplit Level1 RetsMgmtProcItmQtySplit
Level1Document Level1 Level1Document
Level1DocumentItem Level1 Level1DocumentItem Reference item
Level1DocumentCategory Level1 Level1DocumentCategory
CustomerReturn P_CustRetProcFlow05 CustomerReturn
CustomerReturnType P_CustRetProcFlow05 CustomerReturnType
CustomerReturnItem Level1 CustomerReturnItem
SalesOrganization P_CustRetProcFlow05 SalesOrganization Sales Organization
DistributionChannel P_CustRetProcFlow05 DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision P_CustRetProcFlow05 OrganizationDivision Org. Division
CustRetItmFollowUpActivity P_CustRetProcFlow05 CustRetItmFollowUpActivity Follow-Up Act.

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_CustRetProcFlow32.
-- 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: PCUSTRETPROCF32

CREATE VIEW P_CustRetProcFlow32 AS
SELECT
  Level0.Level1Document AS Level0Document,
  Level0.Level1DocumentItem AS Level0DocumentItem,
  Level0.Level1DocumentCategory AS Level0DocumentCategory,
  Level1.RetsMgmtProcItmQtySplit AS RetsMgmtProcItmQtySplit,
  Level1.Level1Document AS Level1Document,
  Level1.Level1DocumentItem AS Level1DocumentItem,
  Level1.Level1DocumentCategory AS Level1DocumentCategory,
  Level0.CustomerReturn AS CustomerReturn,
  Level0.CustomerReturnType AS CustomerReturnType,
  Level1.CustomerReturnItem AS CustomerReturnItem,
  Level0.SalesOrganization AS SalesOrganization,
  Level0.DistributionChannel AS DistributionChannel,
  Level0.OrganizationDivision AS OrganizationDivision,
  Level0.CustRetItmFollowUpActivity AS CustRetItmFollowUpActivity
FROM P_CustRetProcFlow05 AS Level0
;

Learn More