P_CollectionsInvoiceMemory

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
UICT_BillingDocumentIcon Boolean Variable (X = True, - = False, Space = Unknown) Show values
Column Name Description Domain name
Customer Customer Number KUNNR
BillingDocument Billing Document VBELN
BranchAccount Customer Number KUNNR
ObjectKey FDM_INVOICE_KEY CHAR21
OverdueDays null
ReferenceDocumentLogicalSystem Logical System of Reference Document LOGSYS
LastDunningDurationInDays null
SitnNumberOfInstances Number of Situations INT4
DocumentItemText Item Text TEXT50
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
CaseStatusName Case: Status Description SCMGSTAT_DESCR
ReasonCodeName Text Field of Length 60 TEXT60
PromiseToPay Case ID SCMG_EXT_KEY
PromiseToPayLevel Level of Promise to Pay INT1
PromiseToPayStatusName State of Promise to Pay: Text TEXT60
ResubmissionUUID UUID in character form SYSUUID_C
ResubmissionReason Reason for Resubmission CHAR4
NumberOfDaysSinceResubmission null
PostingKeyName Posting Key Name TEXT20
SpecialGLCodeName Short Text for Special G/L Indicator TEXT7
DunningBlockingReasonDesc Reason for dunning block TEXT50
PaymentMethodDescription Payment Method Name TEXT30
CompanyCodeName Name of Company Code or Company TEXT25
CustomerName Name of Customer TEXT80
BranchAccountName Name of Customer TEXT80
CollectionsInvoiceUniqueID Situation Anchor Object Type SIT_DO_DEF_ANCOBJ
Master Data Relations Join Conditions
Country/Region Key
  • Country/Region Key
  • Client
  • P_COLLECTIONSINVOICEMEMORY.COUNTRY == T005.LAND1
  • P_COLLECTIONSINVOICEMEMORY.MANDT == T005.MANDT
Dunning Blocking Reason
  • Dunning Blocking Reason
  • Client
  • P_COLLECTIONSINVOICEMEMORY.DUNNINGBLOCKINGREASON == T040S.MANSP
  • P_COLLECTIONSINVOICEMEMORY.MANDT == T040S.MANDT
Operational General Ledger Account
  • ?
  • Client
  • Operational General Ledger Account
  • P_COLLECTIONSINVOICEMEMORY.[column in domain "BUKRS"] == SKB1.BUKRS
  • P_COLLECTIONSINVOICEMEMORY.MANDT == SKB1.MANDT
  • P_COLLECTIONSINVOICEMEMORY.OPERATIONALGLACCOUNT == SKB1.SAKNR
Payment Method
  • Country/Region Key
  • Payment Method
  • Client
  • P_COLLECTIONSINVOICEMEMORY.COUNTRY == T042Z.LAND1
  • P_COLLECTIONSINVOICEMEMORY.PAYMENTMETHOD == T042Z.ZLSCH
  • P_COLLECTIONSINVOICEMEMORY.MANDT == T042Z.MANDT
Posting Key
  • Client
  • Posting Key
  • P_COLLECTIONSINVOICEMEMORY.MANDT == TBSL.MANDT
  • P_COLLECTIONSINVOICEMEMORY.POSTINGKEY == TBSL.BSCHL
Special G/L Indicator
  • ?
  • Special G/L Indicator
  • Client
  • P_COLLECTIONSINVOICEMEMORY.[column in domain "KOART"] == T074U.KOART
  • P_COLLECTIONSINVOICEMEMORY.SPECIALGLCODE == T074U.UMSKZ
  • P_COLLECTIONSINVOICEMEMORY.MANDT == T074U.MANDT