cancel
Showing results for 
Search instead for 
Did you mean: 

DataSources Finance

Former Member
0 Kudos

Hi SDN Guru's,

I am working SAP BI Reporting Area.. I want to list FI Datasource and Tables.

Can you please any friends share with me list of FI Datasource and Tables in R/3.

Kindly help me ASAP....

Thanks in Advance........ SDN Guru's.

Regards,

Kumar.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Kumar,

In FI We have different Leadgers is there like GL,AR,AP,SL,AA etc.

If you want find any data sources in GO RSA5 search for 0FI it will give you the all data sources for fi related data source.

like some data sources :0FI_GL_3,4,0FI_AR_4,0FI_AP_4 Etc.

Thanks and Regards,

Venkat.

Former Member
0 Kudos

Hi Venkat,

Thanks a lot for ur value inputs...

Can you please give Tables following below datasource, I want list of Tables following below which datasource and which tables.

FI-AR:-

0FI_AR_9 Customer Credit Managmt. Cntrl Area Data via Delta Extra

0FI_AR_5 Customers: Payment History

0FI_AR_6 Customer Sales Figures via Delta Extraction

0FI_AR_7 Customer SGL Sales Figures via Delta Extraction

0FI_AR_8 Customer Credit Managemt. Central Data via Delta Extract

0FI_AR_4 Customers: Line Items with Delta Extraction

0FI_AR_3 Customers: Line Items

0FI_AR_10 Customer Payment Behavior via Delta Extraction

0FI_AR_1 Customers: Transaction figures

FI-AP:-

0FI_AP_7 Vendor SGL Sales Figures using Delt

0FI_AP_6 Vendor Sales Figures via Delta Extr

0FI_AP_4 Vendors: Line Items with Delta Extr

0FI_AP_3 Vendors: Line Items

0FI_AP_1 Vendors: Transaction figures

FI-GL:-

0FI_GL_7 General Ledger Cost of Sales Ledger via Delta Extraction

0FI_GL_6 General Ledger Sales Figures via Delta Extraction

0FI_GL_4 General Ledger: Line Items with Delta Extraction

0ACAC_CALC Manual Accruals: Calculated Accrual Values

0FI_GL_2 General ledger: Transaction figures - Cost of sales ledger

0FI_GL_10 General Ledger: Leading Ledger Balances

0FI_GL_1 General ledger: Transaction figures

Thanks in Advance.... Guru.

Regards,

Kumar.

Former Member
0 Kudos

Hi,

You can get the table related information from Data source itself, simply go to transaction RSA2, check the extraction method, if it is table or view based extraciton then you will directly get the table inforamtion, but if the DS is FM based then go through code and you will get the table names.

Regards,

Durgesh.

Former Member
0 Kudos

Hi Kumar,

Check the below links for the infomation on the tables related to various data sources. Some of them have been replaced by a new data source, The information has been given accordingly:

FI-AR:-

0FI_AR_9 Customer Credit Managmt. Cntrl Area Data via Delta Extra

http://help.sap.com/saphelp_sm32/helpdata/en/c4/8524918a65004badb6885624d43c45/content.htm

0FI_AR_6 Customer Sales Figures via Delta Extraction

http://help.sap.com/saphelp_nw70/helpdata/en/55/02142e7bcffa43afa904f62d3e62ca/content.htm

0FI_AR_7 Customer SGL Sales Figures via Delta Extraction

http://help.sap.com/saphelp_nw04/helpdata/en/41/4b73415fb9157de10000000a155106/content.htm

0FI_AR_8 Customer Credit Managemt. Central Data via Delta Extract

http://help.sap.com/saphelp_em70/helpdata/en/b9/77f59669f2b44998ceabb12d6763b4/content.htm

0FI_AR_4 Customers: Line Items with Delta Extraction

http://help.sap.com/saphelp_dm40/helpdata/en/bc/02f93abb013b0de10000000a114084/content.htm

0FI_AR_10 Customer Payment Behavior via Delta Extraction : KNB4 - This replaces 0FI_AR_5

http://help.sap.com/saphelp_nw04/helpdata/en/d0/2e3cd210b273419b9179b668969255/content.htm

0FI_AR_1 Customers: Transaction figures : Replaced by 0FI_AR_6

0FI_AR_5 Customers: Payment History : Replaced by 0FI_AR_10

0FI_AR_3 Customers: Line Items : Replaced by 0FI_AR_4

FI-AP:-

0FI_AP_7 Vendor SGL Sales Figures using Delta

http://help.sap.com/saphelp_sm32/helpdata/en/b0/9e1bdb259fa341a0a979ee5377cd23/content.htm

0FI_AP_6 Vendor Sales Figures via Delta Extr

http://help.sap.com/saphelp_nw04/helpdata/en/41/64ddc01cb16e3ee10000000a114b54/content.htm

0FI_AP_4 Vendors: Line Items with Delta Extr

http://help.sap.com/saphelp_dm40/helpdata/en/90/10e73a86e99c77e10000000a114084/content.htm

0FI_AP_3 Vendors: Line Items : Replaced by 0FI_AP_4

0FI_AP_1 Vendors: Transaction figures : Replaced by 0FI_AP_6

FI-GL:-

0FI_GL_7 General Ledger Cost of Sales Ledger via Delta Extraction

http://help.sap.com/saphelp_nw04/helpdata/en/78/fc168f3955754c8bf1474870138a53/frameset.htm

0FI_GL_6 General Ledger Sales Figures via Delta Extraction

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

0FI_GL_4 General Ledger: Line Items with Delta Extraction

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

0ACAC_CALC Manual Accruals: Calculated Accrual Values

http://jayaprakashsapbwbibo.blogspot.com/2011_01_01_archive.html

0FI_GL_10 General Ledger: Leading Ledger Balances

http://help.sap.com/saphelp_sm32/helpdata/en/45/757140723d990ae10000000a155106/content.htm

0FI_GL_1 General ledger: Transaction figures

http://help.sap.com/saphelp_NW04/helpdata/en/28/5ccfbb45b01140a3b59298c267604f/content.htm

0FI_GL_2 General ledger: Transaction figures - Cost of sales ledger: Replaced by 0FI_GL_7

This all information can also be easily attained from the transaction RSA2.

Thanks

Pawan

Former Member
0 Kudos

Thanks a lot Guru's.........Issue was resolved.

Regards,

Kumar.

Answers (0)