Credit Management: Control Area Data with
Delta Extraction 
Technical name: 0FI_AR_9
Technical Data
|
Type of DataSource |
Transaction data |
|
Application Component |
Financial Accounting: Accounts Receivable Accounting (FI-AR) |
|
Available from OLTP Release: |
4.0B |
|
Available from Plug-In Release |
2003.1 |
|
RemoteCube Compatibility |
|
Use
This DataSource is used to load Credit Management control area data (table KNKK) from the R/3 source system to the Business Information Warehouse.
Delta Update
This DataSource is delta-compatible.
Fields of Origin in the Extract Structure
|
Field in Extract Structure |
Description of Field in the Extract Structure |
Table of Origin |
Field in Table of Origin |
|
MANDT |
Client |
KNKK |
|
|
KUNNR |
Accounts receivable number 1 |
KNKK |
|
|
KKBER |
Credit Control Area |
KNKK |
|
|
KLIMK |
Customer’s credit limit |
KNKK |
|
|
KNKLI |
Account number of the customer with the proposed credit limit |
KNKK |
|
|
SKFOR |
Total receivables (for credit limit check) |
KNKK |
|
|
SSOBL |
Relevant special liability for credit limit check |
KNKK |
|
|
UEDAT |
Date on which the credit limit was exceeded |
KNKK |
|
|
CTLPC |
Credit management risk class |
KNKK |
|
|
DTREV |
Last check (internal) |
KNKK |
|
|
CRBLB |
Flag: Locked by Credit Management ? |
KNKK |
|
|
SBGRP |
Editor group for Credit Management |
KNKK |
|
|
NXTRV |
Next check |
KNKK |
|
|
KRAUS |
Credit information number |
KNKK |
|
|
REVDB |
Last check (external) |
KNKK |
|
|
GRUPP |
Customer credit group |
KNKK |
|
|
SBDAT |
Submission date |
KNKK |
|
|
KDGRP |
Customer group |
KNKK |
|
|
CASHD |
Date of last payment |
KNKK |
|
|
CASHA |
Amount of last payment |
KNKK |
|
|
CASHC |
Currency of last payment |
KNKK |
|
|
DBPAY |
Payment index |
KNKK |
|
|
DBRTG |
Rating |
KNKK |
|
|
DBEKR |
Recommended credit limit |
KNKK |
|
|
DBWAE |
Currency of the recommended credit limit |
KNKK |
|
|
DBMON |
Monitoring date |
KNKK |
|
|
ABSBT |
Total of secured receivables |
KNKK |
|
|
WAERS |
Currency key |
KNKK |
|
|
UPDMOD |
BW delta process: update mode |
KNKK |
|
Features of Extractor
Extraction method: F1
Extractor: BWFI3D_GET_FIAR_CM_CAD
Extraction structure: DTFIAR_9