P_SlsOrdFlfmtProcessFlow12

DDL: P_SLSORDFLFMTPROCESSFLOW12 SQL: PSOFProcFlow12 Type: view COMPOSITE

P_SlsOrdFlfmtProcessFlow12 is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_PurOrdAccountAssignment) and exposes 10 fields with key fields SalesDocument, PurchaseOrder, SalesOrder.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
I_PurOrdAccountAssignment POAccountAss 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 PSOFProcFlow12 view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY SalesDocument SalesDocument
KEY PurchaseOrder I_PurOrdAccountAssignment PurchaseOrder
KEY SalesOrder
SalesOrderType SalesDocumentType
SalesOrderCategory SalesDocument SDDocumentCategory
SalesOrganization SalesOrganization
DistributionChannel DistributionChannel
OrganizationDivision OrganizationDivision
SoldToParty SalesDocument SoldToParty
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: 'PSOFProcFlow12'

define view P_SlsOrdFlfmtProcessFlow12
as select distinct from
I_SalesDocument as SalesDocument
inner join
I_PurOrdAccountAssignment as POAccountAss
on 
   SalesDocument.SalesDocument = POAccountAss.SalesOrder
{
   //Key

   key SalesDocument,
   key POAccountAss.PurchaseOrder,
   
   //SalesOrder

   key  cast(SalesDocument as vdm_sales_order) as SalesOrder,
   SalesDocumentType as SalesOrderType,
       
   //Category

   SalesDocument.SDDocumentCategory as SalesOrderCategory,
 
   //Organization

   SalesOrganization,
   DistributionChannel,
   OrganizationDivision,
   
   //Partner 

   SalesDocument.SoldToParty,
   cast (SalesDocument._SoldToParty.CustomerName as vdm_sold_to_name) as SoldToPartyName   
}
where ( POAccountAss.SalesOrderItem != '000000')
  and ( SalesDocument.SDDocumentCategory = 'C' or   --> Order
        SalesDocument.SDDocumentCategory = 'I' or   --> Order w/o charge
        SalesDocument.SDDocumentCategory = 'L' )    --> Debit Memo Request   

                                                                                               
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CUSTOMER",
"I_PURORDACCOUNTASSIGNMENT",
"I_SALESDOCUMENT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More