P_PaymentReceiptRelatedDoc

DDL: P_PAYMENTRECEIPTRELATEDDOC SQL: PPAYTRCPTADOC Type: view COMPOSITE

P_PaymentReceiptRelatedDoc is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_OperationalAcctgDocItem, P_PaymentReceiptRelatedDoc1) and exposes 5 fields with key fields JournalEntry, LedgerGLLineItem, CompanyCode, FiscalYear.

2 data source(s) 5 fields

Data Sources (2)

SourceAliasJoin Type
I_OperationalAcctgDocItem AcctgDocItem left_outer
P_PaymentReceiptRelatedDoc1 relatedDoc from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PPAYTRCPTADOC 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 (5)

KeyFieldSource TableSource FieldDescription
KEY JournalEntry P_PaymentReceiptRelatedDoc1 JournalEntry
KEY LedgerGLLineItem P_PaymentReceiptRelatedDoc1 LedgerGLLineItem
KEY CompanyCode P_PaymentReceiptRelatedDoc1 CompanyCode
KEY FiscalYear P_PaymentReceiptRelatedDoc1 FiscalYear
ClearingAccountingDocument I_OperationalAcctgDocItem ClearingJournalEntry 
@AbapCatalog.sqlViewName: 'PPAYTRCPTADOC'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private: true
@VDM.viewType: #COMPOSITE
@AbapCatalog.preserveKey:true 
@AbapCatalog.compiler.compareFilter:true 
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_PaymentReceiptRelatedDoc 
  as select from P_PaymentReceiptRelatedDoc1 as relatedDoc
  left outer join I_OperationalAcctgDocItem as AcctgDocItem on relatedDoc.CompanyCode = AcctgDocItem.CompanyCode
                                                           and relatedDoc.LedgerGLLineItem = AcctgDocItem.AccountingDocumentItem
                                                           and relatedDoc.JournalEntry = AcctgDocItem.AccountingDocument
                                                           and relatedDoc.FiscalYear = AcctgDocItem.FiscalYear{
    key   relatedDoc.JournalEntry,
    key   relatedDoc.LedgerGLLineItem,
    key   relatedDoc.CompanyCode,
    key   relatedDoc.FiscalYear,
    AcctgDocItem.ClearingJournalEntry as ClearingAccountingDocument
}

Learn More