P_SlsOrdProcFlowM2

DDL: P_SLSORDPROCFLOWM2 SQL: PSLSORDPROCFM2 Type: view CONSUMPTION

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.

2 data source(s) 10 fields

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
KEY LevelM2DocumentCategory I_SDDocumentProcessFlow PrecedingDocumentCategory
KEY LevelM1Document P_SlsOrdProcFlowM12 LevelM1Document
KEY LevelM1DocumentCategory P_SlsOrdProcFlowM12 LevelM1DocumentCategory
KEY SalesOrder P_SlsOrdProcFlowM12 SalesOrder
SalesOrderType P_SlsOrdProcFlowM12 SalesOrderType
SalesOrderCategory P_SlsOrdProcFlowM12 SalesOrderCategory
SalesOrganization P_SlsOrdProcFlowM12 SalesOrganization
DistributionChannel P_SlsOrdProcFlowM12 DistributionChannel
OrganizationDivision P_SlsOrdProcFlowM12 OrganizationDivision 
@ClientHandling.algorithm: #SESSION_VARIABLE 
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL

@VDM.private: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #CONSUMPTION
@AbapCatalog.sqlViewName: 'PSLSORDPROCFM2'
@AbapCatalog.preserveKey:true 
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Sales Order Process Flow: Level -2 Intercompany Sales Order'
define view P_SlsOrdProcFlowM2 
  as select from P_SlsOrdProcFlowM12 as LevelM1
    inner join I_SDDocumentProcessFlow as LevelM2
      on LevelM1.LevelM1Document = LevelM2.SubsequentDocument

{
  key LevelM2.PrecedingDocument as LevelM2Document,
  key LevelM2.PrecedingDocumentCategory as LevelM2DocumentCategory,
  
  key LevelM1.LevelM1Document,
  key LevelM1.LevelM1DocumentCategory,
  
  key LevelM1.SalesOrder,
  
  LevelM1.SalesOrderType,
  LevelM1.SalesOrderCategory,
  LevelM1.SalesOrganization,
  LevelM1.DistributionChannel,
  LevelM1.OrganizationDivision
  
}
where LevelM1.LevelM1DocumentCategory = 'V'

Learn More