Vendor Balances

DataSource Transactional Data: 0FI_AP_20

This DataSource provides vendor balances (table LFC1).

Application Component	Financial Accounting: Vendors (FI-AP)
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
`LIFNR`	Account number of vendor	`LFC1`	`LIFNR`
`BUKRS`	Company code	`LFC1`	`BUKRS`
`AKONT`	Reconciliation account in general ledger accounting	`LFB1`	`AKONT`
`KTOPL`	Chart of accounts	`T001`	`KTOPL`
`GJAHR`	Fiscal year	`LFC1`	`GJAHR`
`PERIO`	Periods	`LFC1`	`*1`
`FISCPER`	Period/year	`LFC1`	`*2`
`FISCVAR`	Fiscal year variant	`T001`	`PERIV`
`CURTYPE`	Currency type
`CURRENCY`	Currency key	`T001`	`WAERS`
`UM01S`	Total debit postings	`LFC1`	`UM01S`
`UM01H`	Total credit postings	`LFC1`	`UM01H`
`UM01K`	Cumulated balance		`*3`
`UM01U`	Sales of the period	`LFC1`	`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