This DataSource returns general ledger transaction figures from the totals table (with the default setting FAGLFLEXT) or from the archive.
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).
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 |
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.
After Images Marked for Deletion via Extractor (FI-GL/AP/AR)
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.
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 |
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.