P_SDDocumentPurchOrdProcFlow

DDL: P_SDDOCUMENTPURCHORDPROCFLOW SQL: PSDPOPROCFLW Type: view COMPOSITE

P_SDDocumentPurchOrdProcFlow is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_SDDocumentMultiLevelProcFlow) and exposes 9 fields with key field DocRelationshipUUID.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
I_SDDocumentMultiLevelProcFlow I_SDDocumentMultiLevelProcFlow from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PSDPOPROCFLW view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY DocRelationshipUUID DocRelationshipUUID
PrecedingDocument PrecedingDocument
PrecedingDocumentItem PrecedingDocumentItem
PrecedingDocumentCategory PrecedingDocumentCategory
SubsequentDocument SubsequentDocument
SubsequentDocumentItem
Original SubsequentDocumentItem
SubsequentDocumentCategory SubsequentDocumentCategory
ProcessFlowLevel ProcessFlowLevel 
@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