Customer Balances

DataSource Transactional Data: 0FI_AR_20

This DataSource provides customer balances (table KNC1).

Application Component	Financial Accounting: Customers (FI-AR)
Available as of Release	SAP enhancement package 3 for SAP ERP 6.0, business function Reporting Financials (FIN_REP_SIMPL_1)
Shipment	SAP NetWeaver 7.0 BI Content Add-On 3 Support Package 08
Content Versions	603
RemoteCube-Capable	Yes
Delta-Capable	Yes
Extraction from Archives	No
Verifiable	No

After images via extractor (FI-GL/AP/AR)

Fields of Origin for the Extract Structure
Fields in the Extract Structure	Description of the Field in the Extract Structure	Table of Origin	Field in the Table of Origin
`KUNNR`	Customer number 1	`KNC1`	`KUNNR`
`BUKRS`	Company code	`KNC1`	`BUKRS`
`AKONT`	Reconciliation account in general ledger accounting	`KNB1`	`AKONT`
`FISCPER`	Period/year	`KNC1`	`*1`
`GJAHR`	Fiscal year	`KNC1`	`GJAHR`
`PERIO`	Periods	`KNC1`	`*2`
`KTOPL`	Chart of accounts	`T001`	`KTOP`
`FISCVAR`	Fiscal year variant	`T001`	`PERIV`
`CURTYPE`	Currency type
`CURRENCY`	Currency key	`T001`	`WAERS`
`UM01S`	Total debit postings	`KNC1`	`UM01S`
`UM01H`	Total credit postings	`KNC1`	`UM01H`
`UM01K`	Cumulated balance		`*3`
`UM01U`	Sales of the period	`KNC1`	`UM01U`
`UPDMOD`	BW delta procedure: Record mode	`-`	`-`

Information on the “Field in the Table of Origin”:

*1: Calculated from period blocking

*2: Calculated from period blocking and the field GJAHR

*3: Calculated from the balances of the previous periods