I_CollectionsInvoice

Collections Invoices | view: ICOLLSINV | TRAN | Extraction: Not supported | Component: Collections Management
Tables used: BKPFBSEGKNA1T001T014UDM_SGMT_COMP
Column Name Description
CollectionSegment FK Collection Segment
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
PaidAmount Amount Paid
DunnedAmount Dunned Amount
OpenAmountInDocumentCurrency Open Amount
CashDiscountAmtInTransacCrcy Cash Discount Amount in Document Currency
ArrangedAmount Amount Arranged for Payment
PromisedAmount Outstanding Amount Promised
DisputedAmount Disputed Amount
CreditedAmount Total of All Credits for Selected Invoice
Column Name Description
Column Name Description
DocumentDate Journal Entry Date
PostingDate Posting Date
LastDunningDate Date of Last Dunning Notice
NetDueDate Due Date for Net Payment
CashDiscount1Days Due Date for Cash Discount 1
PaymentDate Date of Last Incoming Payment for Invoice
ClearingDate Clearing Date
ResubmissionDueDate Resubmission Date
PromiseToPayDueDate Date for Which Payment Is Promised
Column Name Description
FinancialAccountType Account Type Show values
AccountingDocumentCategory Journal Entry Category Show values
PromiseToPayStatus State of Promise to Pay Show values
Column Name Description Domain name
BranchAccount Branch Account MAXKK
DunningLevel Dunning Level MAHNS
Reference1InDocumentHeader Internal ID of Reference Key 1 in Document Header CHAR20
Reference2InDocumentHeader Internal ID of Reference Key 2 in Document Header CHAR20
OverdueDays Days in Arrears by Net Due Date WRTV3
FiscalPeriod Fiscal Period POPER
BillingDocument Billing Document VBELN
DocumentItemText Item Text TEXT50
DocumentReferenceID Document Reference ID XBLNR1
InvoiceReference Invoice Reference BELNR
InvoiceReferenceFiscalYear Invoice Reference Fiscal Year GJAHR
InvoiceItemReference Invoice Item Reference BUZEI
FollowOnDocumentType Follow-On Document Type REBZT
ReferenceDocumentLogicalSystem Logical System of Reference Document LOGSYS
LastDunningDurationInDays Days Since Dunning Date INTEGER
CaseStatus Case: Status SCMGSTATUSONR
CaseStatusName Case: Status Description SCMGSTAT_DESCR
CaseReason Reason for Case SCMG_REASON_CODE
ReasonCodeName Text Field of Length 60 TEXT60
DisputeCase Case ID FDM_EXT_KEY
PromiseToPay Case ID FDM_EXT_KEY
NumberOfResubmissions Number of Resubmissions INT4
ResubmissionUUID Technical Case Key (Case GUID) SYSUUID_C
ResubmissionReason Reason for Resubmission CHAR4
NumberOfDaysSinceResubmission Days since Resubmission INTEGER
PromiseToPayLevel Level of Promise to Pay INT1
ObjectKey Object key SWO_TYPEID
CaseUniqueID Technical Case Key (Case GUID) SYSUUID_C
Master Data Relations Join Conditions
Collection Segment
  • Client
  • Collection Segment
Company Code
  • Client
  • Company Code
  • I_COLLECTIONSINVOICE.MANDT == T001.MANDT
  • I_COLLECTIONSINVOICE.COMPANYCODE == T001.BUKRS
Country/Region Key
  • Client
  • Country/Region Key
  • I_COLLECTIONSINVOICE.MANDT == T005.MANDT
  • I_COLLECTIONSINVOICE.COUNTRY == T005.LAND1
Customer Number
  • Client
  • Customer Number
  • I_COLLECTIONSINVOICE.MANDT == KNA1.MANDT
  • I_COLLECTIONSINVOICE.CUSTOMER == KNA1.KUNNR
Dunning Blocking Reason
  • Client
  • Dunning Blocking Reason
  • I_COLLECTIONSINVOICE.MANDT == T040S.MANDT
  • I_COLLECTIONSINVOICE.DUNNINGBLOCKINGREASON == T040S.MANSP
Operational General Ledger Account
  • Client
  • Company Code
  • Operational General Ledger Account
  • I_COLLECTIONSINVOICE.MANDT == SKB1.MANDT
  • I_COLLECTIONSINVOICE.COMPANYCODE == SKB1.BUKRS
  • I_COLLECTIONSINVOICE.OPERATIONALGLACCOUNT == SKB1.SAKNR
Payment Method
  • Client
  • Country/Region Key
  • Payment Method
  • I_COLLECTIONSINVOICE.MANDT == T042Z.MANDT
  • I_COLLECTIONSINVOICE.COUNTRY == T042Z.LAND1
  • I_COLLECTIONSINVOICE.PAYMENTMETHOD == T042Z.ZLSCH
Posting Key
  • Posting Key
  • Client
  • I_COLLECTIONSINVOICE.POSTINGKEY == TBSL.BSCHL
  • I_COLLECTIONSINVOICE.MANDT == TBSL.MANDT
Special G/L Indicator
  • Client
  • ?
  • Special G/L Indicator
  • I_COLLECTIONSINVOICE.MANDT == T074U.MANDT
  • I_COLLECTIONSINVOICE.[column in domain "KOART"] == T074U.KOART
  • I_COLLECTIONSINVOICE.SPECIALGLCODE == T074U.UMSKZ
Transaction Currency
  • Transaction Currency
  • Client
  • I_COLLECTIONSINVOICE.TRANSACTIONCURRENCY == TCURC.WAERS
  • I_COLLECTIONSINVOICE.MANDT == TCURC.MANDT