I_CollectionsInvoiceMemory

Invoice Memory | view: ICOLLSINVMEM | Extraction: Not supported | Component: Fiori-UI for Collections and Dispute Management
Tables used: FDM_INVOICE_MEMBKPFBSEGKNA1T001T014
Column Name Description
CompanyCode Company Code
AccountingDocument Document Number of an Accounting Document
FiscalYear Fiscal Year
AccountingDocumentItem Number of Line Item Within Accounting Document
Column Name Description
💲 Currency Key (TransactionCurrency):
AmountInTransactionCurrency Original Amount of Invoice or Credit
PaidAmount Amount Paid
OpenAmountInDocumentCurrency Open Amount
CreditedAmount Total of All Credits for Selected Invoice
DunnedAmount Dunned Amount
ArrangedAmount Amount Arranged for Payment
CashDiscountAmtInTransacCrcy Cash Discount Amount in Document Currency
Column Name Description
Column Name Description
PostingDate Posting Date in the Document
NetDueDate Net Due Date
DueDate Net Due Date
CashDiscount1DueDate Due Date for Cash Discount 1
PaymentDate Date of Last Incoming Payment for Invoice
LastDunningDate Date of Last Dunning Notice for Invoice
Column Name Description
Column Name Description Domain name
Customer Customer Number KUNNR
BillingDocument Billing Document VBELN
BranchAccount Customer Number KUNNR
ObjectKey FDM_INVOICE_KEY CHAR21
OverdueDays null
LastDunningDurationInDays null
ReferenceDocumentLogicalSystem Logical System of Reference Document LOGSYS
CollectionsInvoiceUniqueID Situation Anchor Object Type SIT_DO_DEF_ANCOBJ
Master Data Relations Join Conditions
Country/Region Key
  • Country/Region Key
  • Client
  • I_COLLECTIONSINVOICEMEMORY.COUNTRY == T005.LAND1
  • I_COLLECTIONSINVOICEMEMORY.MANDT == T005.MANDT
Dunning Blocking Reason
  • Dunning Blocking Reason
  • Client
  • I_COLLECTIONSINVOICEMEMORY.DUNNINGBLOCKINGREASON == T040S.MANSP
  • I_COLLECTIONSINVOICEMEMORY.MANDT == T040S.MANDT
Payment Method
  • Country/Region Key
  • Payment Method
  • Client
  • I_COLLECTIONSINVOICEMEMORY.COUNTRY == T042Z.LAND1
  • I_COLLECTIONSINVOICEMEMORY.PAYMENTMETHOD == T042Z.ZLSCH
  • I_COLLECTIONSINVOICEMEMORY.MANDT == T042Z.MANDT