I_PPS_SupplierInvcProcessFlow

DDL: I_PPS_SUPPLIERINVCPROCESSFLOW SQL: IPPSXPOSIPF Type: view BASIC

Invoice Information For Xpo History

I_PPS_SupplierInvcProcessFlow is a Basic CDS View that provides data about "Invoice Information For Xpo History" in SAP S/4HANA. It reads from 2 data sources (rbkp, rseg) and exposes 9 fields with key fields SupplierInvoice, PPSSupplierInvoiceItem, FiscalYear.

2 data source(s) 9 fields

Data Sources (2)

SourceAliasJoin Type
rbkp SupplierInvoice from
rseg SupplierInvoiceItem inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IPPSXPOSIPF view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Invoice Information For Xpo History view
VDM.viewType #BASIC view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY SupplierInvoice rbkp belnr
KEY PPSSupplierInvoiceItem
KEY FiscalYear rbkp gjahr
CompanyCode rbkp bukrs
SupplierInvoiceStatus rbkp rbstat
PPSAmtWthCrcyAsText
DocumentCurrency rbkp waers
PPSQuantityWithUnitAsText
IsEndOfPurposeBlocked rbkp iseopblocked 
@AbapCatalog.sqlViewName: 'IPPSXPOSIPF'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #XXL,
  dataClass: #TRANSACTIONAL
}
@EndUserText.label: 'Invoice Information For Xpo History'
@VDM.viewType: #BASIC
define view I_PPS_SupplierInvcProcessFlow
  as select from rbkp as SupplierInvoice
    inner join   rseg as SupplierInvoiceItem on  SupplierInvoiceItem.belnr = SupplierInvoice.belnr
                                             and SupplierInvoiceItem.bukrs = SupplierInvoice.bukrs
                                             and SupplierInvoiceItem.gjahr = SupplierInvoice.gjahr
{

  key    SupplierInvoice.belnr                                                                                                    as SupplierInvoice,
  key    cast( right( SupplierInvoiceItem.buzei,5) as ebelp )                                                                     as PPSSupplierInvoiceItem,
  key    SupplierInvoice.gjahr                                                                                                    as FiscalYear,
         SupplierInvoice.bukrs                                                                                                    as CompanyCode,
         SupplierInvoice.rbstat                                                                                                   as SupplierInvoiceStatus,
         cast(concat_with_space(cast(SupplierInvoiceItem.wrbtr as abap.char(20)), SupplierInvoice.waers, 1) as abap.char(40))     as PPSAmtWthCrcyAsText,
         SupplierInvoice.waers                                                                                                    as DocumentCurrency,
         cast(concat_with_space(cast(SupplierInvoiceItem.menge as abap.char(20)), SupplierInvoiceItem.bstme, 1) as abap.char(30)) as PPSQuantityWithUnitAsText,
         SupplierInvoice.iseopblocked                                                                                             as IsEndOfPurposeBlocked

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"RBKP",
"RSEG"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More