Show TOC

General Ledger Accounting: Transaction Figures Locate this document in the navigation structure

DataSource Transactional Data DataSource Transactional Data: 0FI_GL_20

 

This DataSource returns general ledger transaction figures from the totals table (with the default setting FAGLFLEXT) or from the archive.

Note Note

It is only possible for totals records to be read from the archive once you have implemented SAP Enhancement Package 5 for SAP ERP 6.0 and have activated the business function New General Ledger Accounting 3 (FIN_GL_CI_3).

End of the note.

Technical Data

Application Component

Financial Accounting: General Ledger Accounting (FI-GL)

Available as of Release

SAP enhancement package 5 for SAP ERP 6.0, business function New General Ledger Accounting 3

Shipment

SAP NetWeaver 7.0 BI Content Add-On 5 Support Package 01

Content Versions

603

RemoteCube-Capable

Yes

Delta-Capable

Yes

Extraction from Archives

Yes

Verifiable

No

Prerequisites

  • To improve performance, you have restricted the characteristic Ledgers in General Ledger Accounting (RLDNR).

  • If you have specified in the InfoPackage that the system reads the data from the totals table as well as from the archive, you need to have deleted the archived data from the totals table. If the archived data is not first deleted, the DataSource would return the archived data in duplicate.

Data Modeling

Delta Update

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

Note Note

The DataSource only supports the delta procedure when the data is read from the totals table.

If you use delta updates to extract data to SAP Business Information Warehouse, you first need to transfer the data into a DataStore object and then write it to an InfoCube. If you also extract data from the archive, you have to apply a DataStore object that first totals the data because the archive can contain multiple datasets with the same logical key.

End of the note.
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

RYEAR

Fiscal year

FAGLFLEXT

ACTIV

Business transaction FI-SL

FAGLFLEXT

RMVCT

Flow type

FAGLFLEXT

RTCUR

Currency key

FAGLFLEXT

AWTYP

Reference transaction

FAGLFLEXT

RLDNR

Ledgers in General Ledger Accounting

FAGLFLEXT

RRCTY

Record type

FAGLFLEXT

RVERS

Version

FAGLFLEXT

LOGSYS

Logical system

FAGLFLEXT

RACCT

Account number

FAGLFLEXT

COST_ELEM

Cost element

FAGLFLEXT

RBUKRS

Company code

FAGLFLEXT

RCNTR

Cost center

FAGLFLEXT

PRCTR

Profit center

FAGLFLEXT

RFAREA

Functional area

FAGLFLEXT

RBUSA

Business area

FAGLFLEXT

KOKRS

Controlling area

FAGLFLEXT

SEGMENT

Segment for segment reporting

FAGLFLEXT

SCNTR

Sender cost center

FAGLFLEXT

PPRCTR

Partner profit center

FAGLFLEXT

SFAREA

Functional area of partner

FAGLFLEXT

SBUSA

Business area of the business partner

FAGLFLEXT

RASSC

Company ID of trading partner

FAGLFLEXT

PSEGMENT

Partner segment for segment reporting

FAGLFLEXT

VALUETYPE

Value type for Reporting

FAGLFLEXT

CURTYPE

Currency type

FAGLFLEXT

FISCPER

Fiscal year/period

FAGLFLEXT

FISCVAR

Fiscal year variant

CHARTACCTS

Chart of accounts

UPMOD

BW delta procedure: Record mode

VALUTYP

Valuation view

CURRUNIT

Currency key

FAGLFLEXT

BALANCE

Cumulated balance

FAGLFLEXT

DEBIT

Total debit postings

FAGLFLEXT

CREDIT

Total credit postings

FAGLFLEXT

TURNOVER

Sales of the period

FAGLFLEXT

POPER

Posting period

FAGLFLEXT

Extractor Logic

The DataSource first produces a list of all ledgers in new General Ledger Accounting that fall within the ledger selection. The request for each ledger is then processed individually.

If your totals record table contains customer fields, these fields are also available in the DataSource.