P_SlsOrdProcFlow12

DDL: P_SLSORDPROCFLOW12 SQL: PSLSORDPROCF12 Type: view CONSUMPTION Package: ODATA_SD_SO_PROCESSFLOW

Sales Order Process Flow: Level +1 Purchase Orders

P_SlsOrdProcFlow12 is a Consumption CDS View that provides data about "Sales Order Process Flow: Level +1 Purchase Orders" in SAP S/4HANA. It reads from 2 data sources (I_PurOrdAccountAssignment, R_PurchaseOrderItem) and exposes 11 fields with key fields SalesDocument, SalesDocumentItem, PurchaseOrder, PurchaseOrderItem, SalesOrder. Part of development package ODATA_SD_SO_PROCESSFLOW.

2 data source(s) 11 fields

Data Sources (2)

SourceAliasJoin Type
I_PurOrdAccountAssignment POAccountAss inner
R_PurchaseOrderItem PurchaseOrderItem inner

Annotations (9)

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 PSLSORDPROCF12 view
AbapCatalog.preserveKey true view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY SalesDocument SalesDocument
KEY SalesDocumentItem SalesDocumentItem
KEY PurchaseOrder I_PurOrdAccountAssignment PurchaseOrder
KEY PurchaseOrderItem R_PurchaseOrderItem PurchaseOrderItem
KEY SalesOrder
SalesOrderType SalesDocumentType
PurchasingDocumentItemOrigin R_PurchaseOrderItem PurchasingDocumentItemOrigin
SalesOrderCategory SalesDocumentItem SDDocumentCategory
SalesOrganization SalesOrganization
DistributionChannel DistributionChannel
OrganizationDivision OrganizationDivision 
@ClientHandling.algorithm: #SESSION_VARIABLE 
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL

@VDM.private: true
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AbapCatalog.sqlViewName: 'PSLSORDPROCF12'
@AbapCatalog.preserveKey:true 

define view P_SlsOrdProcFlow12
  as select distinct from I_SalesDocumentItemBasic      as SalesDocumentItem
    inner join            I_PurOrdAccountAssignment as POAccountAss 
                           on SalesDocumentItem.SalesDocument = POAccountAss.SalesOrder
                           and SalesDocumentItem.SalesDocumentItem = POAccountAss.SalesOrderItem
                           
    inner join            R_PurchaseOrderItem as PurchaseOrderItem
                            on POAccountAss.PurchaseOrder = PurchaseOrderItem.PurchaseOrder
                            and POAccountAss.PurchaseOrderItem = PurchaseOrderItem.PurchaseOrderItem
                            and PurchaseOrderItem.PurchasingDocumentItemOrigin != 'V'
{
       //Key

  key  SalesDocument,
  key  SalesDocumentItem,
  key  POAccountAss.PurchaseOrder,
  key  PurchaseOrderItem.PurchaseOrderItem,

       //SalesOrder

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

       //PO Origin

       PurchaseOrderItem.PurchasingDocumentItemOrigin,
       
       //Category

       SalesDocumentItem.SDDocumentCategory                                   as SalesOrderCategory,

       //Organization

       SalesOrganization,
       DistributionChannel,
       OrganizationDivision

}
where
  (
      POAccountAss.SalesOrderItem != '000000'
  )
  and SalesDocumentItem.SDDocumentCategory  = 'C' --> Order    
   or SalesDocumentItem.SDDocumentCategory  = 'I' --> Order w/o charge

Learn More