P_SlsOrdProcFlow24

DDL: P_SLSORDPROCFLOW24 SQL: PSLSORDPROCF24 Type: view CONSUMPTION
12 Fields 2 Data Sources

Sales Order Process Flow: Level +2 Intercompany Sales Order

P_SlsOrdProcFlow24 is a Consumption CDS View that provides data about "Sales Order Process Flow: Level +2 Intercompany Sales Order" in SAP S/4HANA. It reads from 2 data sources (P_SlsOrdProcFlow10, I_SalesDocumentItemBasic) and exposes 12 fields with key fields Level2Document, Level2DocumentItem, Level1Document, Level1DocumentItem, SalesOrder.

Data Sources (2)

SourceAliasJoin Type
P_SlsOrdProcFlow10 Level1 from
I_SalesDocumentItemBasic Level2 inner

Annotations (11)

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 PSLSORDPROCF24 view
EndUserText.label Sales Order Process Flow: Level +2 Intercompany Sales Order view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY Level2Document I_SalesDocumentItemBasic SalesDocument SD Document
KEY Level2DocumentItem I_SalesDocumentItemBasic SalesDocumentItem Sales Document Item
KEY Level1Document P_SlsOrdProcFlow10 Level1Document
KEY Level1DocumentItem P_SlsOrdProcFlow10 Level1DocumentItem
KEY SalesOrder P_SlsOrdProcFlow10 SalesOrder SD Document
SalesOrderType P_SlsOrdProcFlow10 SalesOrderType Sales Order Type
Level2DocumentCategory
Level1DocumentCategory P_SlsOrdProcFlow10 Level1DocumentCategory
SalesOrderIsProjectBased P_SlsOrdProcFlow10 SalesOrderIsProjectBased
SalesOrganization P_SlsOrdProcFlow10 SalesOrganization Sales Organization
DistributionChannel P_SlsOrdProcFlow10 DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision P_SlsOrdProcFlow10 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_SlsOrdProcFlow24.
-- 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: PSLSORDPROCF24

CREATE VIEW P_SlsOrdProcFlow24 AS
SELECT
  Level2.SalesDocument AS Level2Document,
  Level2.SalesDocumentItem AS Level2DocumentItem,
  Level1.Level1Document AS Level1Document,
  Level1.Level1DocumentItem AS Level1DocumentItem,
  Level1.SalesOrder AS SalesOrder,
  Level1.SalesOrderType AS SalesOrderType,
  'ICSO' AS Level2DocumentCategory,
  Level1.Level1DocumentCategory AS Level1DocumentCategory,
  Level1.SalesOrderIsProjectBased AS SalesOrderIsProjectBased,
  Level1.SalesOrganization AS SalesOrganization,
  Level1.DistributionChannel AS DistributionChannel,
  Level1.OrganizationDivision AS OrganizationDivision
FROM P_SlsOrdProcFlow10 AS Level1
INNER JOIN I_SalesDocumentItemBasic AS Level2 ON /* join condition not captured in parsed metadata */
;

Learn More