P_FR_OverduePaymentItem

Payment Data for French Overdue Invoices | view: PFROVRDINVCPAYTI | TRAN | Extraction: Not supported | Component: Financials France
Tables used: BSEGBUT000KNA1CVI_CUST_LINKT001T014
Column Name Description
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
AccountingDocumentItem Journal Entry Posting View Item
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
ByKDtEvaldInvcAmtInCoCodeCrc Invoice Amount Evaluated on Key Date (Company Code Currency)
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
Column Name Description
Column Name Description
PostingDate Posting Date
DocumentDate Journal Entry Date
ClearingDate Clearing Date
Column Name Description
IsUsedInPaymentTransaction Is Used In Payment Transaction Show values
FinancialAccountType Account Type Show values
Column Name Description Domain name
InvoiceReference Invoice Reference BELNR
InvoiceReferenceFiscalYear Invoice Reference Fiscal Year GJAHR
InvoiceItemReference Invoice Item Reference BUZEI
BusinessPartner Business Partner Number BU_PARTNER
FiscalPeriod Fiscal Period POPER
SpecialGLTransactionType Special G/L Transaction Type UMSKS
ClearingAccountingDocument Clearing Journal Entry BELNR
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • P_FR_OVERDUEPAYMENTITEM.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • P_FR_OVERDUEPAYMENTITEM.MANDT == T003.MANDT
Company Code
  • Company Code
  • Client
  • P_FR_OVERDUEPAYMENTITEM.COMPANYCODE == T001.BUKRS
  • P_FR_OVERDUEPAYMENTITEM.MANDT == T001.MANDT
G/L Account
  • Company Code
  • Client
  • G/L Account
  • P_FR_OVERDUEPAYMENTITEM.COMPANYCODE == SKB1.BUKRS
  • P_FR_OVERDUEPAYMENTITEM.MANDT == SKB1.MANDT
  • P_FR_OVERDUEPAYMENTITEM.GLACCOUNT == SKB1.SAKNR
Special G/L Indicator
  • Special G/L Indicator
  • Client
  • ?
  • P_FR_OVERDUEPAYMENTITEM.SPECIALGLCODE == T074U.UMSKZ
  • P_FR_OVERDUEPAYMENTITEM.MANDT == T074U.MANDT
  • P_FR_OVERDUEPAYMENTITEM.[column in domain "KOART"] == T074U.KOART
Transaction Currency
  • Client
  • Transaction Currency
  • P_FR_OVERDUEPAYMENTITEM.MANDT == TCURC.MANDT
  • P_FR_OVERDUEPAYMENTITEM.TRANSACTIONCURRENCY == TCURC.WAERS