P_SlsOrdProcFlow10

DDL: P_SLSORDPROCFLOW10 SQL: PSLSORDPROCF10 Type: view CONSUMPTION
19 Fields 2 Data Sources

P_SlsOrdProcFlow10 is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (P_SlsOrdProcFlow0, I_SDDocumentProcessFlow) and exposes 19 fields with key fields Level1Document, Level1DocumentItem, Level1DocumentItem, Level1DocumentCategory.

Data Sources (2)

SourceAliasJoin Type
P_SlsOrdProcFlow0 Level0 from
I_SDDocumentProcessFlow Level1 inner

Annotations (9)

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 PSLSORDPROCF10 view
AbapCatalog.preserveKey true view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY Level1Document I_SDDocumentProcessFlow SubsequentDocument
KEY Level1DocumentItem I_SDDocumentProcessFlow SubsequentDocumentItem
SalesOrder SalesOrder SD Document
SalesOrderType SalesOrderType Sales Order Type
SalesOrderCategory SalesOrderCategory
SalesOrderIsProjectBased SalesOrderIsProjectBased
SalesOrganization P_SlsOrdProcFlow0 SalesOrganization Sales Organization
DistributionChannel P_SlsOrdProcFlow0 DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision P_SlsOrdProcFlow0 OrganizationDivision Org. Division
KEY Level1DocumentItem
KEY Level1DocumentCategory
SalesOrder SalesOrder SD Document
SalesOrderType SalesOrderType Sales Order Type
SalesOrderCategory SalesOrderCategory
SalesOrderIsProjectBased
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision OrganizationDivision Org. Division
BillingDocumentIsRequired

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_SlsOrdProcFlow10.
-- 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: PSLSORDPROCF10

CREATE VIEW P_SlsOrdProcFlow10 AS
SELECT
  Level1.SubsequentDocument AS Level1Document,
  Level1.SubsequentDocumentItem AS Level1DocumentItem,
  SalesOrder,
  SalesOrderType,
  SalesOrderCategory,
  SalesOrderIsProjectBased,
  Level0.SalesOrganization AS SalesOrganization,
  Level0.DistributionChannel AS DistributionChannel,
  Level0.OrganizationDivision AS OrganizationDivision,
  'V' AS Level1DocumentCategory,
  '' AS BillingDocumentIsRequired
FROM P_SlsOrdProcFlow0 AS Level0
INNER JOIN I_SDDocumentProcessFlow AS Level1 ON /* join condition not captured in parsed metadata */
;

Learn More