Invoice Status

DataStore object: 0CLM_DS05

This DataStore Object contains the transaction data of the invoice that was optimized for SAP Collections Management. This optimized invoice considers all line items in Accounts Receivable Accounting that are assigned to an invoice item. In addition to the invoice item itself, this includes the following assigned transactions:

Credit memos
Incoming payments
Clearing transactions

Structure

Delta Update

The following delta update is supported for this DataStore object:

Delta update: Generisches Delta
DataSource: 0CLM_INVOICE

Data Modeling

Key Fields
Object Type	Name	Technical Name
Characteristic	Company code	`0COMP_CODE`
Time characteristic	Fiscal year variant	`0FISCVARNT`
Time characteristic	Fiscal year	`0FISCYEAR`
Characteristic	Invoice Number	`0INV_DOC_NO`
Characteristic	Number of line item within accounting document	`0ITEM_NUM`

Data Fields
Object Type	Name	Technical Name
Time characteristic	Calendar Day	`0CALDAY`
Time characteristic	Calendar Year/Month	`0CALMONTH`
Time characteristic	Calendar Year/Week	`0CALWEEK`
Time characteristic	Calendar Year	`0CALYEAR`
Characteristic	Customer Number in SAP Collections Management	`0CLM_DEBITR`
Characteristic	Fin Invoice Key	`0CLM_FKY`
Key figure	Invoice Amount	`0CLM_IA`
Key figure	Amount Credited	`0CLM_ICRA`
Key figure	Counter: Invoices	`0CLM_ICT`
Key figure	Dunning Amount	`0CLM_IDA`
Key figure	Open Amount	`0CLM_IOA`
Key figure	Amount Paid	`0CLM_IPA`
Key figure	Amount Arranged for Payment	`0CLM_IPAA`
Key figure	Counter: Promises to Pay Assigned to Invoice	`0CLM_IPCT`
Characteristic	Last Payment Date for Invoice	`0CLM_IPD`
Characteristic	Invoice Status	`0CLM_IST`
Unit of measurement	Currency Key	`0CURRENCY`
Characteristic	Customer Number	`0DEBITOR`
Characteristic	Document Date	`0DOC_DATE`
Characteristic	Source System	`0LOGSYS`
Characteristic	Due date for net payment	`0NETDUEDATE`
Characteristic	Posting Date in the Document	`0PSTNG_DATE`
Data packet characteristic	BW Delta Process: Update Mode	`0RECORDMODE`