P_PaymentReceiptException

DDL: P_PAYMENTRECEIPTEXCEPTION SQL: PPAYTRCPTEX Type: view BASIC

P_PaymentReceiptException is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (I_OperationalAcctgDocItem, paytrcpt_excpt) and exposes 25 fields with key fields rbukrs, gjahr, belnr, docln.

2 data source(s) 25 fields

Data Sources (2)

SourceAliasJoin Type
I_OperationalAcctgDocItem AccountingDocumentItem left_outer
paytrcpt_excpt exception from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PPAYTRCPTEX view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
VDM.private true view
VDM.viewType #BASIC view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY rbukrs rbukrs
KEY gjahr gjahr
KEY belnr belnr
KEY docln docln
rldnr rldnr
msgty msgty
msgid msgid
msgno msgno
msgv1 msgv1
msgv2 msgv2
msgv3 msgv3
msgv4 msgv4
createdate createdate
createby createby
blart I_OperationalAcctgDocItem AccountingDocumentType
kunnr I_OperationalAcctgDocItem Customer
lifnr I_OperationalAcctgDocItem Supplier
CustomerFullName
SupplierFullName
budat I_OperationalAcctgDocItem PostingDate
bupla I_OperationalAcctgDocItem BusinessPlace
xblnr
rwcur I_OperationalAcctgDocItem TransactionCurrency
wsl
PaymentMethod I_OperationalAcctgDocItem PaymentMethod 
@AbapCatalog.sqlViewName: 'PPAYTRCPTEX'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #S
@VDM.private: true
@VDM.viewType: #BASIC
define view P_PaymentReceiptException as select from paytrcpt_excpt as exception
  left outer join I_OperationalAcctgDocItem as AccountingDocumentItem on AccountingDocumentItem.CompanyCode = exception.rbukrs
                                                                      and AccountingDocumentItem.FiscalYear = exception.gjahr
                                                                      and AccountingDocumentItem.AccountingDocument = exception.belnr
                                                                      and AccountingDocumentItem.AccountingDocumentItem = exception.docln
{
  key rbukrs,
  key gjahr,
  key belnr,
  key docln,  
  rldnr,
  paytrcpt_uuid,
  msgty,
  msgid,
  msgno,
  msgv1,
  msgv2,
  msgv3,
  msgv4,
  createdate,
  createby,
  exception_type,
  AccountingDocumentItem.AccountingDocumentType as blart,
  AccountingDocumentItem.Customer as kunnr,
  AccountingDocumentItem.Supplier as lifnr,
  AccountingDocumentItem._Customer.CustomerFullName,
  AccountingDocumentItem._Supplier.SupplierFullName,
  AccountingDocumentItem.PostingDate as budat,
  AccountingDocumentItem.BusinessPlace as bupla,
  AccountingDocumentItem._JournalEntry.DocumentReferenceID as xblnr,
  
  @Semantics.currencyCode: true
  AccountingDocumentItem.TransactionCurrency as rwcur,
  
  @Semantics.amount.currencyCode: 'rwcur'
  abs( AccountingDocumentItem.AmountInTransactionCurrency ) as wsl,
  
  AccountingDocumentItem.PaymentMethod
  
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CUSTOMER",
"I_JOURNALENTRY",
"I_OPERATIONALACCTGDOCITEM",
"I_SUPPLIER",
"PAYTRCPT_EXCPT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More