General Ledger: Transaction Figures (SAP Library

General Ledger: Transaction Figures

Technical name: 0FI_GL_1

Note

The OLTP database of the source system contains annual records with field groups for up to three different currency types. The balance carryforward and 16 period values are specified for debits or credits.

The extraction program, however, determines data records for each period per required currency type, and generates the accumulated balance including the balance carryforward per period. The balance carryforward no longer exists as a separate value in the BW System, however.

In addition, data records in which all key figures (debits, credits, accumulated balance) would be equal to zero are not transferred to the BW System by the extraction program. These zero data records cannot then be displayed in a query.

Characteristics

InfoObject	Description	Data Element	Field in Transfer Structure	Source
0CHRT_ACCTS	Chart of accounts	KTOPL	KTOPL	T001-KTOPL
0CURTYPE	Currency type	RSCURTYPE	CURTYPE	sel. parameter
0BUS_AREA	Business area	GSBER	GSBER	GLT0 - RBUSA
0VTYPE	Reporting value type	RSVTYPE	WRTTP	GLT0 - RRCTY
0VERSION	Version	VERSN	VERSN	GLT0 - RVERS
0COMP_CODE	Company code	BUKRS	BUKRS	GLT0 - BUKRS
0GL_ACCOUNT	Account number	SAKNR	SAKNR	GLT0 - RACCT

Time Characteristics

InfoObject	Description	Data Element	Field in Transfer Structure	Source
0FISCVARNT	Fiscal year variant	RSFISCVAR	FISCVAR	T001-PERIV
0FISCPER	Fiscal year/period	RSFISCPER	FISCPER	calculated

Units

InfoObject	Description	Data Element	Field in Transfer Structure	Source
0CURRENCY	Currency	RSCURRENCY	CURRENCY	according to 0CURTYPE

Key Figures

InfoObject	Description	Data Element	Field in Transfer Structure	Source
0DEBIT	Total debit postings	RR_UMSOL	UMSOL	GLT0 - HSLxx, KSLxx
0CREDIT	Total credit postings	RR_UMHAB	UMHAB	GLT0 - HSLxx, KSLxx
0BALANCE	Accumulated balance	RR_KUMSL	KUMSL	calculated