P_SlsOrdFlfmtProcessFlow1

DDL: P_SLSORDFLFMTPROCESSFLOW1 SQL: PSOFProcFlow1 Type: view COMPOSITE Package: VDM_SD_SOF_OLD

SOFM Process Flow 1

P_SlsOrdFlfmtProcessFlow1 is a Composite CDS View that provides data about "SOFM Process Flow 1" in SAP S/4HANA. It reads from 1 data source (I_SalesDocument) and exposes 11 fields with key fields Level1Document, Level1DocumentItem, SalesOrder. Part of development package VDM_SD_SOF_OLD.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
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 PSOFProcFlow1 view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY Level1Document SubsequentDocument
KEY Level1DocumentItem SubsequentDocumentItem
KEY SalesOrder
SalesOrderType SalesDocumentType
Level1DocumentCategory SubsequentDocumentCategory
SalesOrderCategory I_SalesDocument SDDocumentCategory
SalesOrganization I_SalesDocument SalesOrganization
DistributionChannel I_SalesDocument DistributionChannel
OrganizationDivision I_SalesDocument 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: 'PSOFProcFlow1'

define view P_SlsOrdFlfmtProcessFlow1
as select from
I_SalesDocument as SalesDocument
left outer to many join
I_SDDocumentProcessFlow as ProcFlow
on 
    SalesDocument.SalesDocument = ProcFlow.PrecedingDocument
     
  and (PrecedingDocumentCategory = 'C' or   --> Order
       PrecedingDocumentCategory = 'I' or   --> Order w/o charge
       PrecedingDocumentCategory = 'L'      --> Debit Memo Request)
       )
  and (
       SubsequentDocumentCategory = 'M' or   --> Invoice
       SubsequentDocumentCategory = 'J' or   --> Delivery
       SubsequentDocumentCategory = 'O' or   --> Credit Memo
       SubsequentDocumentCategory = 'P' or   --> Debit Memo
       SubsequentDocumentCategory = 'I' or   --> Order w/o charge
       SubsequentDocumentCategory = 'L'      --> Debit Memo Request     
      )
left outer to one join
I_DeliveryDocument as DeliveryDocument
on 
      SubsequentDocument = DeliveryDocument.DeliveryDocument
  and SubsequentDocumentCategory = DeliveryDocument.SDDocumentCategory
        
{
   //Key

   key SubsequentDocument as Level1Document,
   key SubsequentDocumentItem as Level1DocumentItem,
   
   //SalesOrder

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

   SubsequentDocumentCategory as Level1DocumentCategory,
   SalesDocument.SDDocumentCategory as SalesOrderCategory,
   
    //Organization

   SalesDocument.SalesOrganization,
   SalesDocument.DistributionChannel,
   SalesDocument.OrganizationDivision,  
   
   //Partner 

   SalesDocument.SoldToParty,
   cast (SalesDocument._SoldToParty.CustomerName as vdm_sold_to_name) as SoldToPartyName,  
        
    //Status

   case when
    (
     OverallTotalDeliveryStatus = 'A' or
     OverallTotalDeliveryStatus = 'B'
      )
    then
    'X'
    else
    ''
    end as DeliveryDocumentIsRequired,
  
    case when
    (
      OverallOrdReltdBillgStatus = 'A' or
      OverallOrdReltdBillgStatus = 'B' or
      OverallDelivReltdBillgStatus = 'A' or
      OverallDelivReltdBillgStatus = 'B'
      )
    then
    'X'
    else
    ''
    end as BillingDocumentIsRequired 
 }
 where ( SalesDocument.SDDocumentCategory = 'C' or   --> Order
         SalesDocument.SDDocumentCategory = 'I' or   --> Order w/o charge
         SalesDocument.SDDocumentCategory = 'L' )    --> Debit Memo Request

Learn More