P_PAYMENTRECEIPTRELATEDDOC1

CDS View

P_PAYMENTRECEIPTRELATEDDOC1 is a CDS View in S/4HANA. It contains 4 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 4 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_PaymentReceiptRelatedDoc view from COMPOSITE

Fields (4)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 1
KEY FiscalYear FiscalYear 1
KEY JournalEntry JournalEntry 1
KEY LedgerGLLineItem LedgerGLLineItem 1 
@AbapCatalog.sqlViewName: 'PPAYTRCPTADOC1'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private: true
@VDM.viewType: #COMPOSITE
@AbapCatalog.preserveKey:true 
@AbapCatalog.compiler.compareFilter:true 
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_PaymentReceiptRelatedDoc1 
  as select from I_PaymentReceiptRelatedDoc as PaymentReceiptRelatedDoc
{
    key   PaymentReceiptRelatedDoc.AccountingDocument as JournalEntry,
    key   PaymentReceiptRelatedDoc.LedgerGLLineItem,
    key   PaymentReceiptRelatedDoc.CompanyCode,
    key   PaymentReceiptRelatedDoc.FiscalYear
}where PaymentReceiptRelatedDoc.PaymentReceiptStatus <> '03'
union select from I_PaymentReceiptLog as PaymentReceiptLog{
    key PaymentReceiptLog.AccountingDocument as JournalEntry,
    key PaymentReceiptLog.AccountingDocumentItem as LedgerGLLineItem,
    key PaymentReceiptLog.CompanyCode,
    key PaymentReceiptLog.FiscalYear
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PAYMENTRECEIPTLOG",
"I_PAYMENTRECEIPTRELATEDDOC"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More