P_SlsOrdFlfmtProcessFlow3

DDL: P_SLSORDFLFMTPROCESSFLOW3 SQL: PSOFProcFlow3 Type: view COMPOSITE

P_SlsOrdFlfmtProcessFlow3 is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (P_SlsOrdFlfmtProcessFlow2, I_SDDocumentProcessFlow) and exposes 13 fields with key fields Level3Document, Level3DocumentItem, Level2Document, Level2DocumentItem, SalesOrder.

2 data source(s) 13 fields

Data Sources (2)

SourceAliasJoin Type
P_SlsOrdFlfmtProcessFlow2 Level2 from
I_SDDocumentProcessFlow Level3 inner

Annotations (8)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #S view
VDM.private true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName PSOFProcFlow3 view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY Level3Document I_SDDocumentProcessFlow SubsequentDocument
KEY Level3DocumentItem I_SDDocumentProcessFlow SubsequentDocumentItem
KEY Level2Document Level2Document
KEY Level2DocumentItem Level2DocumentItem
KEY SalesOrder SalesOrder
SalesOrderType SalesOrderType
Level3DocumentCategory I_SDDocumentProcessFlow SubsequentDocumentCategory
Level2DocumentCategory Level2DocumentCategory
SalesOrganization SalesOrganization
DistributionChannel DistributionChannel
OrganizationDivision OrganizationDivision
SoldToParty SoldToParty
SoldToPartyName SoldToPartyName 
@ClientHandling.algorithm: #SESSION_VARIABLE 
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #S
@VDM.private: true
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AbapCatalog.sqlViewName: 'PSOFProcFlow3'

define view P_SlsOrdFlfmtProcessFlow3
as select from
P_SlsOrdFlfmtProcessFlow2 as Level2
inner join
I_SDDocumentProcessFlow  as Level3
on 
     Level2.Level2Document = Level3.PrecedingDocument
and  Level2.Level2DocumentCategory = Level3.PrecedingDocumentCategory
and  Level2.Level2DocumentItem = Level3.PrecedingDocumentItem
and (
       Level3.SubsequentDocumentCategory = 'M' or    --> Invoice
       Level3.SubsequentDocumentCategory = 'O' or    --> Credit Memo
       Level3.SubsequentDocumentCategory = 'P'       --> Debit Memo
      )  
  
{
   //Key

   key Level3.SubsequentDocument as Level3Document,
   key Level3.SubsequentDocumentItem as Level3DocumentItem,
   key Level2Document,
   key Level2DocumentItem,
   
   //SalesOrder

   key SalesOrder,
   SalesOrderType,
   
   //Category

   Level3.SubsequentDocumentCategory as Level3DocumentCategory,
   Level2DocumentCategory,
         
   //Organization

   SalesOrganization,
   DistributionChannel,
   OrganizationDivision,
   
   //Partner 

   SoldToParty,
   SoldToPartyName          
 };

Learn More