P_SDDOCUMENTPURCHORDPROCFLOW

CDS View

P_SDDOCUMENTPURCHORDPROCFLOW is a CDS View in S/4HANA. 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
P_SlsOrderInSupplyPurgIssue3 view inner COMPOSITE
P_SOFAProcFlow12 view inner COMPOSITE

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')
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SDDOCUMENTMULTILEVELPROCFLOW"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More