P_Pl_OverdueInvoicesHlp

Helper view for Overdue Invoices | view: PSROVRDUEINVH | Extraction: Not supported | Component: Financials Poland
Tables used: BKPFBSEGKNA1LFA1T001T014
Column Name Description
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
AccountingDocumentItem Journal Entry Posting View Item
Column Name Description
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
Column Name Description
Column Name Description
DocumentDate Journal Entry Date
PostingDate Posting Date
TaxReportingDate Tax Reporting Date
DueCalculationBaseDate Due Calculation Base Date
NetDueDate Due Date for Net Payment
ClearingDate Clearing Date
Column Name Description
DebitCreditCode Debit/Credit Code Show values
Column Name Description Domain name
DocumentReferenceID Document Reference ID XBLNR1
CustomerName Name of Customer TEXT80
SupplierName Name of Supplier TEXT80
PaymentTerms Terms of Payment Key ZTERM
CashDiscount1Days Cash Discount Days 1 ZBDXT
CashDiscount2Days Cash Discount Days 2 ZBDXT
NetPaymentDays Net Payment Terms Period ZBDXT
CashDiscount1Percent Cash Discount Percentage 1 PRZ23
CashDiscount2Percent Cash Discount Percentage 2 PRZ23
DocumentItemText Item Text TEXT50
IsCleared null
NetDueArrearsDays null
NetDueDays null
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • P_PL_OVERDUEINVOICESHLP.MANDT == T003.MANDT
  • P_PL_OVERDUEINVOICESHLP.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Chart of Accounts
  • Chart of Accounts
  • Client
  • P_PL_OVERDUEINVOICESHLP.CHARTOFACCOUNTS == T004.KTOPL
  • P_PL_OVERDUEINVOICESHLP.MANDT == T004.MANDT
Company Code
  • Client
  • Company Code
  • P_PL_OVERDUEINVOICESHLP.MANDT == T001.MANDT
  • P_PL_OVERDUEINVOICESHLP.COMPANYCODE == T001.BUKRS
Customer Number
  • Client
  • Customer Number
  • P_PL_OVERDUEINVOICESHLP.MANDT == KNA1.MANDT
  • P_PL_OVERDUEINVOICESHLP.CUSTOMER == KNA1.KUNNR
G/L Account
  • Client
  • Company Code
  • G/L Account
  • P_PL_OVERDUEINVOICESHLP.MANDT == SKB1.MANDT
  • P_PL_OVERDUEINVOICESHLP.COMPANYCODE == SKB1.BUKRS
  • P_PL_OVERDUEINVOICESHLP.GLACCOUNT == SKB1.SAKNR
Supplier
  • Supplier
  • Client
  • P_PL_OVERDUEINVOICESHLP.SUPPLIER == LFA1.LIFNR
  • P_PL_OVERDUEINVOICESHLP.MANDT == LFA1.MANDT
Tax on Sales/Purchases Code
  • Client
  • ?
  • Tax on Sales/Purchases Code
  • P_PL_OVERDUEINVOICESHLP.MANDT == T007A.MANDT
  • P_PL_OVERDUEINVOICESHLP.[column in domain "KALSM_D"] == T007A.KALSM
  • P_PL_OVERDUEINVOICESHLP.TAXCODE == T007A.MWSKZ
Transaction Currency
  • Transaction Currency
  • Client
  • P_PL_OVERDUEINVOICESHLP.TRANSACTIONCURRENCY == TCURC.WAERS
  • P_PL_OVERDUEINVOICESHLP.MANDT == TCURC.MANDT