fi-gl datasouces

[vijay_mehta2]

Hi All,

What are the tables involved in 0fi_gl_4 and 0FI_GL_1 in this data souces and please explain the function of each datasouce.

thanks,

rajeev.

[vijay_mehta2]

Some one is using my id...

and posting all these questions....

I never posted any of these questions.....

Pls don't answer...

I never post questions....

I am in BW for last 8yrs....

Some one is trying cheap tricks ....

[Former Member]

Hi,

The tables from where the data is extracted by DS 0fi_gl_4 are BKPF and BSEG.

and for 0FI_GL_1 it is GLT0

Now you have a delta DS0FI_GL_6 instead of 0FI_GL_1.

However if the new GLPCA is implemented the DS for that id 0FI_GL_10 and the data for this DS is extracted from table FAGLFLEXT

Assign Points if useful

Regards

Venkata Devaraj !!!

[Former Member]

hi,

0fi_gl_4--data source details check the following link

http://help.sap.com/saphelp_nw70/helpdata/en/f2/f7e93a4295ac61e10000000a114084/frameset.htm

0FI_GL_1--data source details check the following link

http://help.sap.com/saphelp_nw70/helpdata/en/77/db5237443f1264e10000009b38f8cf/frameset.htm

hope this help you

regards

harikrishna N

[Former Member]

<b>Old</b>

<u>0FI_GL_4</u> - > BSEG & BKPF - > GL Line Items

<b>Use*</b>

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

This DataSource replaces 0FI_GL_1.

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

<u>0FI_GL_1</u> - > GLT0 - > GL Totals

<b>New</b>

<u>Custom Datasource</u> - > FAGLFLEXA - > GL Line Items

<u>0FI_GL_10</u> - > FAGLFLEXT - > GL Totals

[Former Member]

Hi ,

0FI_GL_1:General Ledger transaction figures (it is not delta compatible)

0fi_gl_4 :General Ledger Accounting line items from tables BKPF and BSEG

is delta-compatible.

and the realted tables for the tables you can chk in ROOSOURCE table

chk this link

http://help.sap.com/saphelp_bw33/helpdata/en/af/16533bbb15b762e10000000a114084/content.htm

cheers,

Swapna.G