P_SlsOrdProcFlowM2

DDL: P_SLSORDPROCFLOWM2 SQL: PSLSORDPROCFM2 Type: view CONSUMPTION
10 Fields 2 Data Sources

Sales Order Process Flow: Level -2 Intercompany Sales Order

P_SlsOrdProcFlowM2 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_SlsOrdProcFlowM12, I_SDDocumentProcessFlow) and exposes 10 fields with key fields LevelM2Document, LevelM2DocumentCategory, LevelM1Document, LevelM1DocumentCategory, SalesOrder.

Data Sources (2)

SourceAliasJoin Type
P_SlsOrdProcFlowM12 LevelM1 from
I_SDDocumentProcessFlow LevelM2 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
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName PSLSORDPROCFM2 view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Sales Order Process Flow: Level -2 Intercompany Sales Order view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY LevelM2Document I_SDDocumentProcessFlow PrecedingDocument SD Document
KEY LevelM2DocumentCategory I_SDDocumentProcessFlow PrecedingDocumentCategory
KEY LevelM1Document P_SlsOrdProcFlowM12 LevelM1Document Purchasing Document
KEY LevelM1DocumentCategory P_SlsOrdProcFlowM12 LevelM1DocumentCategory
KEY SalesOrder P_SlsOrdProcFlowM12 SalesOrder SD Document
SalesOrderType P_SlsOrdProcFlowM12 SalesOrderType Sales Order Type
SalesOrderCategory P_SlsOrdProcFlowM12 SalesOrderCategory
SalesOrganization P_SlsOrdProcFlowM12 SalesOrganization Sales Organization
DistributionChannel P_SlsOrdProcFlowM12 DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision P_SlsOrdProcFlowM12 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_SlsOrdProcFlowM2.
-- 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: PSLSORDPROCFM2

CREATE VIEW P_SlsOrdProcFlowM2 AS
SELECT
  LevelM2.PrecedingDocument AS LevelM2Document,
  LevelM2.PrecedingDocumentCategory AS LevelM2DocumentCategory,
  LevelM1.LevelM1Document AS LevelM1Document,
  LevelM1.LevelM1DocumentCategory AS LevelM1DocumentCategory,
  LevelM1.SalesOrder AS SalesOrder,
  LevelM1.SalesOrderType AS SalesOrderType,
  LevelM1.SalesOrderCategory AS SalesOrderCategory,
  LevelM1.SalesOrganization AS SalesOrganization,
  LevelM1.DistributionChannel AS DistributionChannel,
  LevelM1.OrganizationDivision AS OrganizationDivision
FROM P_SlsOrdProcFlowM12 AS LevelM1
INNER JOIN I_SDDocumentProcessFlow AS LevelM2 ON /* join condition not captured in parsed metadata */
;

Learn More