Invoice Status 
DataSource Transactional Data: 0CLM_INVOICE
This DataSource is used to extract the transaction data of an invoice from Accounts Receivable Accounting (FI-AR). The system determines the key figures from the amounts of the line items belonging to the invoice. The date fields each contain the respective date of an action that refers to a line item. The extractor provides the data in optimized form for SAP Collections Management.
Note the following feature with field Customer Number 1 (COLL_DEBITOR): If you take into consideration the head office - branch office relationships of your customers, then the system determines the content of the field using Business Add-In (BAdI) Define Customer for Collections Management (FDM_COLL_DETERMINE_BRANCH). The standard delivery has the following default implementation:
If there is a head office - branch office relationship in the document, the system accesses field BSEG-FILKD.
If there is no head office - branch office relationship in the document, the system accesses field BSEG-KUNNR.
Technical Data
Application Component | Collections Management (0FSCM-CLM) |
|---|---|
Available as of Release | mySAP ERP Enhancement Package 2005.1 |
Shipment | SAP NetWeaver 2004s BI Content Add-On 3 SP02 |
Content Versions | There are no content versions. |
RemoteCube-Capable | No |
Delta-Capable | Yes |
Extraction from Archives | No |
Verifiable | Yes |
Data Modeling
Delta Update
The DataSource permits delta update with generic delta processing using the time stamp. The system determines the invoice reference for a document in Business Transaction Event (BTE) 5010 and saves it with a time stamp. In the case of a delta upload, it determines the amounts of the line items based on these document numbers.
Fields in the Extract Structure | Description of the Field in the Extract Structure | Table of Origin | Field in the Table of Origin |
|---|---|---|---|
INVOICE_NO |
Accounting Document Number |
BSEG |
BELNR |
DOC_ITEM |
Number of Posting Item within Accounting Document |
BSEG |
BUZEI |
COMP_CODE |
Company Code |
BSEG |
BUKRS |
FISCAL_YEAR |
Fiscal Year |
BSEG |
GJAHR |
CUSTOMER |
Customer Number 1 |
BSEG |
KUNNR |
LOGSYS |
Logical System |
||
FISCAL_VAR |
Fiscal Year Variant |
||
BILLING_DOC |
Billling Document |
BSEG |
VBELN |
INVOICE_STATUS |
Invoice Status |
||
POSTING_DATE |
Posting Date in Document |
BSEG |
BUDAT |
INV_DATE |
Document Date in Document |
BSEG |
BLDAT |
DUE_DATE |
Net Due Date |
||
DUNNING_DATE |
Date of Last Dunning Notice for Invoice |
||
CURRENCY |
Currency Key |
BSEG |
WAERS |
INVOICE_AMOUNT |
Original Amount of Invoice or Credit Memo |
BSEG |
WRBTR |
PAID_AMOUNT |
Amount Paid |
||
OPEN_AMOUNT |
Open Amount |
||
CREDITED_AMOUNT |
Total of All Credit Memos for Selected Invoice |
||
DUNNING_AMOUNT |
Amount Dunned |
||
PAYMENT_ARRANGED |
Amount Arranged for Payment |
||
PAYMENT_DATE |
Date of Last Incoming Payment for Invoice |
||
COLL_DEBITOR |
Customer Number 1 |
BSEG |
KUNNR/FILKD |
Extractor Logic
Verification of Key Figures
If necessary, you can check the key figures of the individual customers as follows:
In the source system, from the SAP Easy Access screen, choose the following function:
Accounting 
Financial Supply Chain Management Collections Management Integration with Accounts Receivable Accounting Process Receivables (Old) 
.Enter the required customer.
The Customer Account - Process Receivables screen appears. Here you see a list of all invoices for which there are open receivables.
Using this list, you can compare the following key figures:
Original Amount of Invoice or Credit Memo (INVOICE_AMOUNT)
Amount Paid (PAID_AMOUNT)
Open Amount (OPEN_AMOUNT)
Total of All Credit Memos for Selected Invoice (CREDITED_AMOUNT)
Amount Arranged for Payment (PAYMENT_ARRANGED)
Unsychronized Backup Recovery in BI System
If you import backup copies asynchronously, you have to initialize the delta procedure for the DataSource again.