P_FR_OverdueInvoiceItem

Invoice Data for French Overdue Invoices | view: PFROVRDINVCINVCI | TRAN | Extraction: Not supported | Component: Financials France
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
ByKDtEvaldInvcAmtInCoCodeCrcy Invoice Amount Evaluated on Key Date (Company Code Currency)
InvoiceAlreadyPaidAmtInCCCrcy Invoice: Sum of Partial Payment Amounts
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
Column Name Description
Column Name Description
PostingDate Posting Date
DocumentDate Journal Entry Date
DueCalculationBaseDate Due Calculation Base Date
NetDueDate Due Date for Net Payment
ClearingDate Clearing Date
Column Name Description
IsUsedInPaymentTransaction Is Used In Payment Transaction Show values
FinancialAccountType Account Type Show values
Column Name Description Domain name
BusinessPartner Business Partner Number BU_PARTNER
FiscalPeriod Fiscal Period POPER
PaymentTerms Terms of Payment Key ZTERM
NetDueArrearsDaysAsInt null
SpecialGLTransactionType Special G/L Transaction Type UMSKS
ClearingAccountingDocument Clearing Journal Entry BELNR
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • P_FR_OVERDUEINVOICEITEM.MANDT == T003.MANDT
  • P_FR_OVERDUEINVOICEITEM.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Company Code
  • Client
  • Company Code
  • P_FR_OVERDUEINVOICEITEM.MANDT == T001.MANDT
  • P_FR_OVERDUEINVOICEITEM.COMPANYCODE == T001.BUKRS
G/L Account
  • Client
  • Company Code
  • G/L Account
  • P_FR_OVERDUEINVOICEITEM.MANDT == SKB1.MANDT
  • P_FR_OVERDUEINVOICEITEM.COMPANYCODE == SKB1.BUKRS
  • P_FR_OVERDUEINVOICEITEM.GLACCOUNT == SKB1.SAKNR
Payment Blocking Reason
  • Client
  • Payment Blocking Reason
  • P_FR_OVERDUEINVOICEITEM.MANDT == T008.MANDT
  • P_FR_OVERDUEINVOICEITEM.PAYMENTBLOCKINGREASON == T008.ZAHLS
Special G/L Indicator
  • ?
  • Client
  • Special G/L Indicator
  • P_FR_OVERDUEINVOICEITEM.[column in domain "KOART"] == T074U.KOART
  • P_FR_OVERDUEINVOICEITEM.MANDT == T074U.MANDT
  • P_FR_OVERDUEINVOICEITEM.SPECIALGLCODE == T074U.UMSKZ
Transaction Currency
  • Client
  • Transaction Currency
  • P_FR_OVERDUEINVOICEITEM.MANDT == TCURC.MANDT
  • P_FR_OVERDUEINVOICEITEM.TRANSACTIONCURRENCY == TCURC.WAERS