P_PaytReceiptJournalEntry

DDL: P_PAYTRECEIPTJOURNALENTRY SQL: PPAYTRECPTJE Type: view COMPOSITE Package: GLO_FIN_PAYMENT_RECEIPT

Payment Receipt Journal Entry

P_PaytReceiptJournalEntry is a Composite CDS View that provides data about "Payment Receipt Journal Entry" in SAP S/4HANA. It reads from 1 data source (I_OperationalAcctgDocItem) and exposes 27 fields with key fields CompanyCode, FiscalYear, AccountingDocument, AccountingDocumentItem. Part of development package GLO_FIN_PAYMENT_RECEIPT.

1 data source(s) 27 fields

Data Sources (1)

SourceAliasJoin Type
I_OperationalAcctgDocItem GLAccountLineItem from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PPAYTRECPTJE view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_OperationalAcctgDocItem CompanyCode
KEY FiscalYear I_OperationalAcctgDocItem FiscalYear
KEY AccountingDocument I_OperationalAcctgDocItem AccountingDocument
KEY AccountingDocumentItem I_OperationalAcctgDocItem AccountingDocumentItem
DocumentReferenceID
CompanyCodeName
Customer I_OperationalAcctgDocItem Customer
Supplier I_OperationalAcctgDocItem Supplier
AlternativeReferenceDocument
BusinessPlace
DocumentDate
PostingDate
AmountInTransactionCurrency I_OperationalAcctgDocItem AmountInTransactionCurrency
TransactionCurrency I_OperationalAcctgDocItem TransactionCurrency
AccountingDocumentType I_OperationalAcctgDocItem AccountingDocumentType
Currency
CompanyCodeCurrency I_OperationalAcctgDocItem CompanyCodeCurrency
AmountInCompanyCodeCurrency I_OperationalAcctgDocItem AmountInCompanyCodeCurrency
ClearingAccountingDocument I_OperationalAcctgDocItem ClearingJournalEntry
CashDiscountAmount I_OperationalAcctgDocItem CashDiscountAmount
NetPaymentAmount I_OperationalAcctgDocItem NetPaymentAmount
IsUsedInPaymentTransaction I_OperationalAcctgDocItem IsUsedInPaymentTransaction
BranchCode I_OperationalAcctgDocItem BranchCode
CustomerBusinessPlace I_OperationalAcctgDocItem BusinessPlace
PaymentMethod I_OperationalAcctgDocItem PaymentMethod
SpecialGLCode I_OperationalAcctgDocItem SpecialGLCode
_CompanyCode I_OperationalAcctgDocItem _CompanyCode 
@AbapCatalog.sqlViewName: 'PPAYTRECPTJE'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private: true
@VDM.viewType: #COMPOSITE
@AbapCatalog.preserveKey:true 
@AbapCatalog.compiler.compareFilter:true 
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_PaytReceiptJournalEntry as select from I_OperationalAcctgDocItem  as GLAccountLineItem {
  key GLAccountLineItem.CompanyCode,
  key GLAccountLineItem.FiscalYear,
  key GLAccountLineItem.AccountingDocument,
  key GLAccountLineItem.AccountingDocumentItem,
  GLAccountLineItem._JournalEntry.DocumentReferenceID,
  GLAccountLineItem._CompanyCode.CompanyCodeName,
  GLAccountLineItem.Customer,
  GLAccountLineItem.Supplier,
  cast(GLAccountLineItem._JournalEntry.AlternativeReferenceDocument as fis_xblnr_alt_alpha preserving type ) as AlternativeReferenceDocument,
  GLAccountLineItem._JournalEntry.Branch as BusinessPlace,
  GLAccountLineItem._JournalEntry.DocumentDate,
  GLAccountLineItem._JournalEntry.PostingDate,
  @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
  GLAccountLineItem.AmountInTransactionCurrency as AmountInTransactionCurrency,  
  GLAccountLineItem.TransactionCurrency,
  GLAccountLineItem.AccountingDocumentType,
  GLAccountLineItem._JournalEntry.TransactionCurrency as Currency,
  GLAccountLineItem.CompanyCodeCurrency,
  @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
  GLAccountLineItem.AmountInCompanyCodeCurrency,
  GLAccountLineItem.ClearingJournalEntry as ClearingAccountingDocument,
  GLAccountLineItem.CashDiscountAmount,
  GLAccountLineItem.NetPaymentAmount,
  GLAccountLineItem.IsUsedInPaymentTransaction,
  GLAccountLineItem.BranchCode,
  GLAccountLineItem.BusinessPlace as CustomerBusinessPlace,
  GLAccountLineItem.PaymentMethod,
  GLAccountLineItem.SpecialGLCode,
  GLAccountLineItem._CompanyCode
}where GLAccountLineItem.AccountingDocument !='' and
 GLAccountLineItem.AccountingDocumentCategory !='V'
and GLAccountLineItem.AccountingDocumentCategory !='W'
and GLAccountLineItem.AccountingDocumentCategory !='Z'
and (GLAccountLineItem.Customer != ''or GLAccountLineItem.Supplier !='')
and GLAccountLineItem._JournalEntry.IsReversal <> 'X' and GLAccountLineItem._JournalEntry.IsReversed <> 'X'
//and GLAccountLineItem.DebitCreditCode = 'S'

and GLAccountLineItem.FinancialAccountType = 'D'
//and GLAccountLineItem.SpecialGLCode is initial

Learn More