SAP for Public Sector Discussions
Foster conversations about citizen engagement, resource optimization, and service delivery improvements in the public sector using SAP.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Standard BI Data Source for FMGLFLEXT

vikram_bagade5
Explorer

‎06-02-2009 1:05 PM

0 Kudos

Hello Friends,

The standard data source for the Financials New Legder is 0FI_GL_10 General Ledger: Leading Ledger Balances, which fetches the data from the FAGLFLEXT Table using the Extract Structure FAGL_EXTSTRUCT_LEAD. However there has been a migration of the FAGL table to FMGL table. And now the FAGLFLEXT is no longer populated with any FI postings data. And the new table which is getting the update is the FMGLFLEXT Table. GL Migration from FAGL to FMGL is a standard procedure. However I am not finding any Standard Data Source to fetch the data from the FMGLFLEXT Table.

Can anybody let me know if there is any standard datasource for this or should we create a custom data source to fetch the data from FMGLFLEXT using the FMGL_EXTSTRUCT_LEAD Extract Structure.

Appreciate help in this regard.

VB

1 REPLY 1

vikram_bagade5
Explorer

‎06-08-2009 11:52 AM

0 Kudos

Hello,

The requirement is resolved by the following:

If you want to use your own totals table (in this scenario FMGLFLEXT) 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. Further In the OLTP system, call up transaction FAGLBW03 and Configure the DataSource and save your settings.

http://help.sap.com/saphelp_nw70/helpdata/en/be/928f40f5767d17e10000000a1550b0/frameset.htm

Regards,

VB