General Ledger: Balances, Leading Ledger (SAP Library

General Ledger: Balances, Leading Ledger

Technical name: 0FI_GL_10

Technical Data

Type of DataSource	Transaction data
Application Component	General Ledger Accounting (FI-GL)
Available from OLTP Release	ECC 5.00
Available from Plug-In Release	2004.1
RemoteCube Compatibility	Yes

Prerequisites

In the OLTP system, you have activated new General Ledger Accounting in Customizing for Financial Accounting under Financial Accounting Global Settings.

Use

This DataSource extracts the totals records from the leading ledger in the new General Ledger. For all other ledgers, you need to create corresponding DataSources.

Delta Update

After Images Marked for Deletion via Extractor (FI-GL/AP/AR)

In the delta process, the DataSource transfers the record data with the new status in each case. For this reason, the data cannot be updated directly to the InfoCube. The update is only possible using the ODS object (update with MOVE).

For safety, the delta process uses a lower interval setting of one hour (this is the default setting). In this way, the system always transfers all postings made between one hour before the last delta upload and the current time. The overlap of the first hour of a delta upload causes any records that are extracted twice to be overwritten by the after image process in the ODS object with the MOVE update. This ensures 100% data consistency in BW.

Fields of Origin in the Extraction Structure

Field in Extraction Structure	Description of Field in the Extraction Structure	Table of Origin	Field in Table of Origin
RYEAR	Fiscal year	FAGLFLEXT (or other General Ledger totals table for leading ledger)	Same name as the field in the extraction structure. If you use your own totals table, these fields are only available on the DataSource if your table contains them. If your table contains your own fields (Y* or Z*) as well, such fields are also available in the DataSource (see the section "Features of the Extractor").
ACTIV	General Ledger: Transaction Attributes
RMVCT	Transaction type
RTCUR	Currency key
RUNIT	Base unit of measurement
RLDNR	Ledgers in General Ledger Accounting
RRCTY	Record type
RVERS	Version
LOGSYS	Logical system
RACCT	Account number
RBUKRS	Company code
RCNTR	Cost center
PRCTR	Profit center
RFAREA	Functional area
RBUSA	Business area
KOKRS	Controlling area
SEGMENT	Segment for segment reporting
SCNTR	Sender cost center
PPRCTR	Partner profit center
SFAREA	Partner functional area
SBUSA	Business area of the business partner
RASSC	Company ID of trading partner
PSEGMENT	Partner segment for segment reporting
QUANUNIT	Unit of measure		RUNIT
VALUETYPE	Reporting value type		From RRCTY: The characteristic Record Type in FI-SL is displayed on the InfoObject Value Type: The record types 0 and 2 are converted to value type 10: Record type 0 = Actual Record type 2 = Actual assessment The record types 1 and 3 are converted to value type 20: Record type 1 = Plan Record type 3 = Plan assessment
CURTYPE	Currency type		Ledger master data
FISCPER	Fiscal year/period		RYEAR and RPMAX
FISCVAR	Fiscal year variant		Master data of the ledger and organizational unit
CHARTACCTS	Chart of accounts		Master data of the ledger and organizational unit
UPMOD	BW delta procedure: Update session		Always empty (SPACE) due to after image delta process.
VALUTYP	Valuation view		Ledger master data
CURRUNIT	Currency key		RTCUR or master data of the ledger and organizational unit
BALANCE	Cumulated balance		xSLnn and xSLVT The field from which the data is taken depends on the ledger master data, the characteristics of the InfoObject OCURTYPE, and the posting period. Here, x stands for T, H, K or O. The suffix nn portrays a two-digit offset, which, together with the key field RPMAX, describes the posting period (generally, the posting period = RPMAX + nn -16). The field xSLVT contains the balance carryforward.
DEBIT	Total debit postings		xSLnn
CREDIT	Total credit postings		xSLnn
TURNOVER	Sales of the period		xSLnn
QUANTITY	Consumption quantity		MSLnn

Features of the Extractor

Extraction method: F1 (function module (complete interface))

Extractor: FAGL_GET_TT_DATA_LEAD

Extraction structure: FAGL_EXTSTRUCT_LEAD

If you include your own fields in the totals table of the new General Ledger using transaction FAGL_GINS, these fields are not included in the extraction automatically. You first have to include them under the same name in an APPEND to extraction structure FAGL_EXTSTRUCT_LEAD. The fields of the APPEND structure are then filled automatically.