P_PH_PaytClrdReceivablePyblItm

Payment Cleared Receivable Payable Item | view: PPHPAYTCLRPITM | Extraction: Not supported | Component: Financials Philippines
Tables used: BKPFBSEGT001T014
Column Name Description
CompanyCode FK Company Code
AccountingDocument Journal Entry
FiscalYear Fiscal Year
AccountingDocumentItem Journal Entry Posting View Item
InvoiceReference Journal Entry
InvoiceReferenceFiscalYear Fiscal Year
InvoiceItemReference Journal Entry Posting View Item
Column Name Description
InvoiceAmtInTransactionCrcy null
PaymentAmtInTransactionCrcy null
InvoiceAmtInCompanyCodeCrcy null
PaymentAmtInCompanyCodeCrcy null
InvoiceAmtInAdditionalCrcy1 null
PaytAmtInAdditionalCrcy1 null
InvoiceAmtInAdditionalCrcy2 null
PaytAmtInAdditionalCrcy2 null
Column Name Description
Column Name Description
PostingDate Posting Date
ClearingDate Clearing Date
Column Name Description
FinancialAccountType Account Type Show values
IsUsedInPaymentTransaction Is Used In Payment Transaction Show values
DebitCreditCode Debit/Credit Code Show values
InvoiceDebitCreditCode Debit/Credit Code Show values
Column Name Description Domain name
ClearedInvoiceNumber Journal Entry BELNR
BusinessPlace null
ClearingAccountingDocument Clearing Journal Entry BELNR
ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry GJAHR
DocumentReferenceID Reference Document Number XBLNR1
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • P_PH_PAYTCLRDRECEIVABLEPYBLITM.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • P_PH_PAYTCLRDRECEIVABLEPYBLITM.MANDT == T003.MANDT
Company Code
  • Company Code
  • Company Code
  • Client
  • P_PH_PAYTCLRDRECEIVABLEPYBLITM.INVOICECOMPANYCODE == T001.BUKRS
  • P_PH_PAYTCLRDRECEIVABLEPYBLITM.COMPANYCODE == T001.BUKRS
  • P_PH_PAYTCLRDRECEIVABLEPYBLITM.MANDT == T001.MANDT
Customer Number
  • Customer Number
  • Client
  • P_PH_PAYTCLRDRECEIVABLEPYBLITM.CUSTOMER == KNA1.KUNNR
  • P_PH_PAYTCLRDRECEIVABLEPYBLITM.MANDT == KNA1.MANDT
G/L Account
  • Company Code
  • Company Code
  • G/L Account
  • Client
  • P_PH_PAYTCLRDRECEIVABLEPYBLITM.INVOICECOMPANYCODE == SKB1.BUKRS
  • P_PH_PAYTCLRDRECEIVABLEPYBLITM.COMPANYCODE == SKB1.BUKRS
  • P_PH_PAYTCLRDRECEIVABLEPYBLITM.GLACCOUNT == SKB1.SAKNR
  • P_PH_PAYTCLRDRECEIVABLEPYBLITM.MANDT == SKB1.MANDT
Company Code
  • Company Code
  • Company Code
  • Client
  • P_PH_PAYTCLRDRECEIVABLEPYBLITM.INVOICECOMPANYCODE == T001.BUKRS
  • P_PH_PAYTCLRDRECEIVABLEPYBLITM.COMPANYCODE == T001.BUKRS
  • P_PH_PAYTCLRDRECEIVABLEPYBLITM.MANDT == T001.MANDT
Supplier
  • Supplier
  • Client
  • P_PH_PAYTCLRDRECEIVABLEPYBLITM.SUPPLIER == LFA1.LIFNR
  • P_PH_PAYTCLRDRECEIVABLEPYBLITM.MANDT == LFA1.MANDT
Transaction Currency
  • Transaction Currency
  • Client
  • P_PH_PAYTCLRDRECEIVABLEPYBLITM.TRANSACTIONCURRENCY == TCURC.WAERS
  • P_PH_PAYTCLRDRECEIVABLEPYBLITM.MANDT == TCURC.MANDT