on 09-05-2011 6:16 AM
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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.
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
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.