P_SDDOCUMENTPURCHORDPROCFLOW

CDS View

Process FLow for Sales Order and Purchase Order Relationship

P_SDDOCUMENTPURCHORDPROCFLOW is a CDS View in S/4HANA. Process FLow for Sales Order and Purchase Order Relationship. It contains 1 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 1 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
P_SlsDocFlfmtProcHierarchyD31 view union_all CONSUMPTION SOF Hierarchy: Purchase Order
P_SlsOrderInSupplyPurgIssue3 view inner COMPOSITE SOFM Purchasing Issue 3 V2
P_SOFAProcFlow12 view inner COMPOSITE SOFA Process Flow:: Level +1 Purchase Order

Fields (1)

KeyField CDS FieldsUsed in Views
KEY SubsequentDocument PurchaseOrder 1 
@AbapCatalog.sqlViewName: 'PSDPOPROCFLW'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK

@ClientHandling.algorithm: #SESSION_VARIABLE 
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@VDM.viewType: #COMPOSITE
@VDM.private: true


define view P_SDDocumentPurchOrdProcFlow 

as select from  I_SDDocumentMultiLevelProcFlow

{

key DocRelationshipUUID,

 

      //Preceding

      PrecedingDocument,
      PrecedingDocumentItem,
      PrecedingDocumentCategory,

 

      //Subsequent

      SubsequentDocument,
      cast(substring(SubsequentDocumentItem,2,5) as ebelp) as SubsequentDocumentItem  ,
      SubsequentDocumentItem as Original,
      SubsequentDocumentCategory,

 

      //Process Flow Level

      ProcessFlowLevel

}
where SubsequentDocumentCategory = 'V' --and ( PrecedingDocumentCategory = 'C' or  PrecedingDocumentCategory = 'I' or PrecedingDocumentCategory = 'L' )
and ( PrecedingDocumentCategory = 'C'
      or PrecedingDocumentCategory = 'I'
      or PrecedingDocumentCategory = 'L')

Learn More