Accounts Receivable: Payment History with
Delta Extraction 
Technical name: 0FI_AR_10
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 extracts the payment history from table KNB4 in the R/3 source system. The extractor converts a record from table KNB4 with 12 periodic values or quantity fields into 12 records in the extraction structure, one for each calendar month.
This DataSource replaces 0FI_AR_5.
Delta Update
This DataSource is delta-compatible (in contrast to 0FI_AR_5).
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 |
|
KUNNR |
Accounts receivable number 1 |
KNB4 |
KNB4-KUNNR |
|
BUKRS |
Company Code |
KNB4 |
KNB4-BUKRS |
|
CALMONTH |
Cal. year / month |
|
|
|
CURTYPE |
Currency Type |
KNB4 |
= 10 |
|
CURRENCY |
Currency key |
KNB4 |
T001-WAERS |
|
AGSXX |
Gross sum of cleared items without lost cash discount |
KNB4 |
KNB4-AGSxx |
|
VZSXX |
Average delay for payments with cash discount |
KNB4 |
KNB4-VZSxx |
|
AGNXX |
Gross sum of cleared items with lost cash discount |
KNB4 |
KNB4-AGNxx |
|
VZNXX |
Average delay for payments without cash discount |
KNB4 |
KNB4-VZNxx |
|
ANZXX |
Number of Incoming Payments in the Period |
KNB4 |
KNB4-ANZxx |
|
UPDMOD |
BW delta process: update mode |
|
|
Features of Extractor
Extraction method: F1
Extractor: BWFI3D_GET_FIAR_CM_PH
Extraction structure: DTFIAR_10