I_PPS_JournalEntryProcessFlow

DDL: I_PPS_JOURNALENTRYPROCESSFLOW SQL: IPPSXPOJEPF Type: view BASIC

Journal Entry Documents

I_PPS_JournalEntryProcessFlow is a Basic CDS View that provides data about "Journal Entry Documents" in SAP S/4HANA. It reads from 1 data source (bkpf) and exposes 7 fields with key fields AccountingDocument, PPSSupplierInvoiceItem, CompanyCode, FiscalYear.

Data Sources (1)

SourceAliasJoin Type
bkpf JournalEntry from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IPPSXPOJEPF view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Journal Entry Documents view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY AccountingDocument bkpf belnr
KEY PPSSupplierInvoiceItem
KEY CompanyCode bkpf bukrs
KEY FiscalYear bkpf gjahr
AccountingDocumentType bkpf blart
PPSAmtWthCrcyAsText
CompanyCodeCurrency JournalEntryItem rfccur
@AbapCatalog.sqlViewName: 'IPPSXPOJEPF'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Journal Entry Documents'
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #XXL,
  dataClass: #TRANSACTIONAL
}
@VDM.viewType: #BASIC
define view I_PPS_JournalEntryProcessFlow
  as select from            bkpf as JournalEntry
    left outer to many join bseg as JournalEntryItem on  JournalEntryItem.belnr = JournalEntry.belnr
                                                     and JournalEntryItem.bukrs = JournalEntry.bukrs
{
  key  JournalEntry.belnr                                                                                                      as AccountingDocument,
  key  cast( concat ( '00' ,JournalEntryItem.buzei  )as  numc05)                                                               as PPSSupplierInvoiceItem,
  key  JournalEntry.bukrs                                                                                                      as CompanyCode,
  key  JournalEntry.gjahr                                                                                                      as FiscalYear,
       JournalEntry.blart                                                                                                      as AccountingDocumentType,
       cast(concat_with_space(cast(JournalEntryItem.wrbtr  as abap.char(30)), JournalEntryItem.rfccur, 1) as abap.char( 40 ) ) as PPSAmtWthCrcyAsText,
       JournalEntryItem.rfccur                                                                                                 as CompanyCodeCurrency

}