cancel
Showing results for 
Search instead for 
Did you mean: 

0fi_gl_1 & 0fi_gl_6 with zero records in rsa3

Former Member
0 Kudos

Hello Experts,

the datasources 0fi_gl_1 & 0fi_gl_6 show 0 records in rsa3(in r/3), though there are gl related transactions.

what may be the reason?

also what are the tables on r/3 from which these datasources pick data?

thanks,

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

hi

to find outh the table relevant to the datasource you can do the following

in table ROOSOURCE insert your datasource. If the extraction method (EXMETHOD) is equal to 'V', it's enough to see EXTRACTOR field: this is the table/view from which your datasource take data...in other case (function module,...) I suggest to you debug it in RSA3 or to run it with the SQL trace activated...

Former Member
0 Kudos

Hello,

the datasources are active.

also can you please let me know with the exact table names in R/3 for these...

regards,

Former Member
0 Kudos

Hi Aby,

Pls have a look here on the links below to find out the related database tables for your datasources.

http://help.sap.com/saphelp_erp2005/helpdata/en/28/5ccfbb45b01140a3b59298c267604f/frameset.htm

http://help.sap.com/saphelp_erp2005/helpdata/en/0a/558cabb2e19a4db3097b81bba4fd0e/frameset.htm

Hope it helps!!!!

Do not forget to assign points, if helpful.

Amit

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

Are the datasources active? Go to Rsa5> sap r/3> FI-->Fi-gl --> select datasource . press transfer.

then check in rsa3.

0fi_gl_1:

Ths DataSource is used to load General Ledger transaction figures (<b>table GLTO</b>, G/L account master record transaction figures)

from the R/3 source system to the bw.

0fi_gl_6:

This DataSource is used to load General Ledger transaction figures (table GLTO) from the R/3 source system to the bw.

shylaja.