on 09-01-2014 8:25 AM
Hi,
I am quite new to SAP.
I have few doubts concerning querying SAP tables such as BKPF, BSAS.
1. if I were to query these tables to fetch data, RFC enabled functions are better or SQL driver based queries?
2. Are there built in RFC enabled functions for all SAP tables?
Hi Palai
You mean that you want to access the database tables directly? In SAP application you can query the table thru SAP application. Could you share your requirement?
Regards
Sriram
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I want to access SAP table data outside SAP. say, using a .Net application, for that perhaps I can use a BAPI. I think there are many Builtin BAPIs which allows to access table data via RFC (please correct me if I am wrong).
There are many function modules, such as READ_BPKF which allows me to read the BKPF table data by passing few table field values. Its not a remote enabled module though (I believe then I cant use this for RFC calls, please correct me if I am wrong).
So, in this context, following are my questions:
1. Is there a built-in remote enabled function module for each SAP table?
2. If I were to query SAP tables outside SAP, not using SAP t codes, is RFC function calls are more effective that using OLEDB/ODBC drivers?
Hi Shashank,
You may create a custom function module which is RFC enabled . The contents of function module should be based on your requirement to select data from respective tables and export the content to a parameter tables which will be transferred to calling application ( .NET in your case).
Within .NET application you may define belowSAP connection parameters to establish the connection :
SAP gteway host
SAP instance
SAP client
User and password
You may call above SAP functional module from your .NET application to pull required data,
Hope this helps.
Regards,
Deepak Kori
Dear Deepak,
Thanks a lot for the details, now I am much more clear on the matter.
Just to trouble you again (to save time on programming may be ), I see a lot of remote enabled module to query SAP tables.
Is it an SAP strategy to provide a remote enabled module to query each SAP tables?
Or its just to facilitate customers that, only for more frequently used tables lets say FICO tables, more remote enabled function modules are provided?
In latter case, I would be more clear in my approach & prepared on the level of customization, since that might involve customizing from scratch for some SAP tables.
Hi Shashank,
Is it an SAP strategy to provide a remote enabled module to query each SAP tables?
Or its just to facilitate customers that, only for more frequently used tables lets say FICO tables, more remote enabled function modules are provided?
SAP has provided some remote enabled functions catering to specific requirements within their design. They are not designed to pull data only from a single table.
If the customer requirement is getting fulfilled with std delivered function modules customer can directly use them or create a copy and customize as per requirement.
Hope this helps.
Regards,
Deepak Kori
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.