Start of Content Area

Dummy text General Ledger (New): Balances from Any Ledgers (Generated)  Locate the document in its SAP Library structure

Technical name: 3FI_GL_xx_TT (xx = abbreviation for ledger; TT = totals table)

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.

If table FAGLFLEXT is the totals table taken as the basis, then the extraction structure (FAGLFLEXB) must already exist. If you want to use your own totals table as your basis, you first have to create the corresponding extraction structure using transaction FAGLBW01. In this way, all fields of the totals table are transferred into the extraction structure. If you change your own totals table, you then have to regenerate the extraction structure and the DataSource. You also have to regenerate the DataSource if you use table FAGLFLECT and have changed it. 

Activities

...

       1.      In the OLTP system, call up transaction FAGLBW03.

All ledgers are listed.

       2.      In the row with the ledger for which you want to generate the DataSource, double-click the Assigned DataSource field.

The DataSource dialog box appears. You can change the name in the DataSource field. However, we recommend that you do not make any changes because the name corresponds to the convention cited above. You may not change the character "3" at the start of the name.

       3.      Choose Continue.

The DataSource: Edit Customer Version screen appears. In this screen, you can exclude individual fields of the underlying extraction structure from the selection or from the data transfer into BW.

       4.      Configure the DataSource and save your settings.

Result: You have generated for your ledger a DataSource with which to extract data into BW and you can now use this DataSource.

Use

This DataSource extracts the totals records from a specified ledger in new General Ledger Accounting. This ledger may be the leading ledger or any other ledger.

No Content is delivered in BW for the generic DataSources.

Delta Update

See the section "Delta Update" in General Ledger: Balances, Leading Ledger.

Fields of Origin in the Extraction Structure

See the section "Fields of Origin in the Extraction Structure" in General Ledger: Balances, Leading Ledger. However, the origin table can be the totals table of any ledger.

Features of the Extractor

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

Extractor: FAGL_GET_TT_DATA

Extraction structure: FAGLFLEXB, or your own extraction structure

If you use transaction FAGL_GINS to include your own fields in the totals table of the new General Ledger, then extraction structure FAGLFLEXB automatically includes these new fields if the totals table is table FAGLFLEXT. If a different totals table in used, the fields are automatically transferred to table FAGLFLEXT when the extraction structure is generated.

 

 

 

 

End of Content Area