P_SlsOrdFlfmtProcessFlow11

DDL: P_SLSORDFLFMTPROCESSFLOW11 SQL: PSOFProcFlow11 Type: view COMPOSITE Package: VDM_SD_SOF_OLD

SOFM Process Flow 1.1

P_SlsOrdFlfmtProcessFlow11 is a Composite CDS View that provides data about "SOFM Process Flow 1.1" in SAP S/4HANA. It reads from 2 data sources (I_MfgOrder, I_SalesDocument) and exposes 11 fields with key fields SalesDocument, ManufacturingOrder, SalesOrder. Part of development package VDM_SD_SOF_OLD.

2 data source(s) 11 fields

Data Sources (2)

SourceAliasJoin Type
I_MfgOrder MfgOrder inner
I_SalesDocument SalesDocument from

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 PSOFProcFlow11 view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY SalesDocument I_SalesDocument SalesDocument
KEY ManufacturingOrder I_MfgOrder ManufacturingOrder
KEY SalesOrder
SalesOrderType SalesDocumentType
SalesOrderCategory I_SalesDocument SDDocumentCategory
ManufacturingOrderCategory I_MfgOrder ManufacturingOrderCategory
SalesOrganization SalesOrganization
DistributionChannel DistributionChannel
OrganizationDivision OrganizationDivision
SoldToParty I_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: 'PSOFProcFlow11'

define view P_SlsOrdFlfmtProcessFlow11
as select from
I_SalesDocument as SalesDocument
inner join
I_MfgOrder as MfgOrder
on 
   SalesDocument.SalesDocument = MfgOrder.SalesOrder
{
   //Key

   key SalesDocument.SalesDocument,
   key MfgOrder.ManufacturingOrder,
  
   //SalesOrder

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

   SalesDocument.SDDocumentCategory as SalesOrderCategory,
   MfgOrder.ManufacturingOrderCategory,
     
   //Organization

   SalesOrganization,
   DistributionChannel,
   OrganizationDivision,
   
   //Partner 

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

Learn More