C_CollsInvcMemorySitnTmpl

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
DisputedAmount Current Disputed Amount
PromisedAmount Promised Amount
Column Name Description
Column Name Description
PostingDate Posting Date in the Document
NetDueDate 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
DocumentDate Journal Entry Date
PromiseToPayDueDate Date for Which Payment Is Promised
ResubmissionDueDate Resubmission Date
Column Name Description
FinancialAccountType Account Type Show values
PromiseToPayStatus State of Promise to Pay Show values
Column Name Description Domain name
Customer Customer Number KUNNR
BillingDocument Billing Document VBELN
BranchAccount Customer Number
ObjectKey FDM_INVOICE_KEY CHAR21
CollectionsInvoiceUniqueID Situation Anchor Object Type SIT_DO_DEF_ANCOBJ
CollectionSegment Collection Segment BDM_COLL_SEGEMENT
OverdueDays null
ReferenceDocumentLogicalSystem Logical System of Reference Document LOGSYS
LastDunningDurationInDays null
DunningLevel Dunning Level MAHNS
FiscalPeriod Fiscal Period POPER
Reference1InDocumentHeader Internal ID of Reference Key 1 in Document Header CHAR20
Reference2InDocumentHeader Internal ID of Reference Key 2 in Document Header CHAR20
DisputeCase Case ID SCMG_EXT_KEY
CaseReason Reason for Case SCMG_REASON_CODE
CaseStatus Case: Status SCMGSTATUSONR
PromiseToPay Case ID SCMG_EXT_KEY
PromiseToPayLevel Level of Promise to Pay INT1
ResubmissionUUID UUID in character form SYSUUID_C
ResubmissionReason Reason for Resubmission CHAR4
Master Data Relations Join Conditions
Country/Region Key
  • Country/Region Key
  • Client
  • C_COLLSINVCMEMORYSITNTMPL.COUNTRY == T005.LAND1
  • C_COLLSINVCMEMORYSITNTMPL.MANDT == T005.MANDT
Dunning Blocking Reason
  • Dunning Blocking Reason
  • Client
  • C_COLLSINVCMEMORYSITNTMPL.DUNNINGBLOCKINGREASON == T040S.MANSP
  • C_COLLSINVCMEMORYSITNTMPL.MANDT == T040S.MANDT
Operational General Ledger Account
  • ?
  • Operational General Ledger Account
  • Client
  • C_COLLSINVCMEMORYSITNTMPL.[column in domain "BUKRS"] == SKB1.BUKRS
  • C_COLLSINVCMEMORYSITNTMPL.OPERATIONALGLACCOUNT == SKB1.SAKNR
  • C_COLLSINVCMEMORYSITNTMPL.MANDT == SKB1.MANDT
Payment Method
  • Country/Region Key
  • Payment Method
  • Client
  • C_COLLSINVCMEMORYSITNTMPL.COUNTRY == T042Z.LAND1
  • C_COLLSINVCMEMORYSITNTMPL.PAYMENTMETHOD == T042Z.ZLSCH
  • C_COLLSINVCMEMORYSITNTMPL.MANDT == T042Z.MANDT
Posting Key
  • Posting Key
  • Client
  • C_COLLSINVCMEMORYSITNTMPL.POSTINGKEY == TBSL.BSCHL
  • C_COLLSINVCMEMORYSITNTMPL.MANDT == TBSL.MANDT
Special G/L Indicator
  • ?
  • Special G/L Indicator
  • Client
  • C_COLLSINVCMEMORYSITNTMPL.[column in domain "KOART"] == T074U.KOART
  • C_COLLSINVCMEMORYSITNTMPL.SPECIALGLCODE == T074U.UMSKZ
  • C_COLLSINVCMEMORYSITNTMPL.MANDT == T074U.MANDT