P_PH_PRDocumentInfo

DDL: P_PH_PRDOCUMENTINFO SQL: PPHDOCINFO Type: view COMPOSITE Package: GLO_FIN_PAYMENT_RECEIPT

Payment Receipt Doc Information

P_PH_PRDocumentInfo is a Composite CDS View that provides data about "Payment Receipt Doc Information" in SAP S/4HANA. It reads from 3 data sources (I_AccountingDocument, I_PaymentReceiptRelatedDoc, I_OperationalAcctgDocItem) and exposes 18 fields with key fields WorkItemUUID, PaymentReceiptUUID. Part of development package GLO_FIN_PAYMENT_RECEIPT.

3 data source(s) 18 fields

Data Sources (3)

SourceAliasJoin Type
I_AccountingDocument AccountingDocument left_outer
I_PaymentReceiptRelatedDoc docItem from
I_OperationalAcctgDocItem GLAccountLineItem left_outer

Annotations (7)

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

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY WorkItemUUID I_PaymentReceiptRelatedDoc WorkItemUUID
KEY PaymentReceiptUUID I_PaymentReceiptRelatedDoc PaymentReceiptUUID
Ledger I_PaymentReceiptRelatedDoc Ledger
AccountingDocument I_PaymentReceiptRelatedDoc AccountingDocument
LedgerGLLineItem I_PaymentReceiptRelatedDoc LedgerGLLineItem
DocumentDate I_OperationalAcctgDocItem DocumentDate
AmountInTransactionCurrency I_OperationalAcctgDocItem AmountInTransactionCurrency
Currency I_OperationalAcctgDocItem TransactionCurrency
ClearingAccountingDocument
DocumentReferenceID I_AccountingDocument DocumentReferenceID
OriginalReferenceDocument I_AccountingDocument OriginalReferenceDocument
TaxCode I_OperationalAcctgDocItem TaxCode
Supplier I_OperationalAcctgDocItem Supplier
Customer I_OperationalAcctgDocItem Customer
DocumentItemText I_OperationalAcctgDocItem DocumentItemText
CompanyCode I_PaymentReceiptRelatedDoc CompanyCode
FiscalYear I_PaymentReceiptRelatedDoc FiscalYear
WhldgTaxAmtInTransacCrcy 
@AbapCatalog.sqlViewName: 'PPHDOCINFO'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@VDM.private: true
define view P_PH_PRDocumentInfo
  as select from    I_PaymentReceiptRelatedDoc as docItem
    left outer join I_OperationalAcctgDocItem  as GLAccountLineItem  on  docItem.AccountingDocument    = GLAccountLineItem.AccountingDocument
                                                                     and docItem.LedgerGLLineItem      = GLAccountLineItem.AccountingDocumentItem
                                                                     and GLAccountLineItem.CompanyCode = docItem.CompanyCode
                                                                     and GLAccountLineItem.FiscalYear  = docItem.FiscalYear
    left outer join I_AccountingDocument       as AccountingDocument on  AccountingDocument.CompanyCode        = GLAccountLineItem.CompanyCode
                                                                     and AccountingDocument.AccountingDocument = GLAccountLineItem.AccountingDocument
                                                                     and AccountingDocument.FiscalYear         = GLAccountLineItem.FiscalYear
{
  key docItem.WorkItemUUID,
  key docItem.PaymentReceiptUUID,
      docItem.Ledger,
      docItem.AccountingDocument,
      docItem.LedgerGLLineItem     as LedgerGLLineItem,
      GLAccountLineItem.DocumentDate,
      GLAccountLineItem.AmountInTransactionCurrency                                                                                                                                                                                                                                                                                                                                                                                                as     AmountInTransactionCurrency,
      GLAccountLineItem.TransactionCurrency                                                                                                                                                                                                                                                                                                                                                                                                              as     Currency,
      //to be fixed

      cast( '' as augbl)  as ClearingAccountingDocument,
      AccountingDocument.DocumentReferenceID,  
      AccountingDocument.OriginalReferenceDocument,                                                                                                                                                                                                       
      GLAccountLineItem.TaxCode,
      GLAccountLineItem.Supplier,
      GLAccountLineItem.Customer,
      GLAccountLineItem.DocumentItemText,
      docItem.CompanyCode,
      docItem.FiscalYear,
      cast(0 as hwbas)                                                                                                                                                                                                                                                                                                                                                                                                    as     WhldgTaxAmtInTransacCrcy
}

Learn More