JCO - Netweaver, uh dynweb?!?

[Former Member]

Hi all,

I've been programming for many years. I enjoy programming in Java. I am new to SAP (started a new job 2 months ago).

My new company has a large SAP implementation. What I would like to do is to query SAP with Java. I found the com.sap.mw.jco.* package and have been able to query a table that I found on a forum. BAPI_MATERIAL_GETLIST

This table returns a very simple list of top level parts. What I need are details. I have a list of tables that have the details but no way to get to them. Every time I look for help on the web, I am flooded with RFC_READ_TABLE, NetWeaver and Dynweb. From my limited jco program, I am not able to query RFC_READ_TABLE. What are netweaver and dynweb?

I suppose those questions are far off base but as I say, I'm new to the SAP community. All I'm looking to do is to get a resultset type object (even if I have to write it) off of a call to SAP. Is this possible?

How do I get results from any table I want without netweaving or dynawebbing?

Thank you very much for your patience with my SAP ignorant self,

w^2

p.s. I forgot to ask about htmlb as well. I've seen that but can't seem to download it anywhere without the 1.2Gb netweaver download. Can someone point me at that package as well (or send it to me?)? Thanks again!

Message was edited by:

William Wallace

[Former Member · Accepted solution]

Hi William

Read documentation of Function moduel RFC_READ_TABLE, it is well documented.

See the Below Link, This is explained about the function Module RFC_READ_TABLE with screen shots and also with an

example..

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/technologies/minin...

http://searchsap.techtarget.com/tip/1,289483,sid21_gci997032,00.html

Regards

Pratyush

[Former Member · Accepted solution]

Here's the exact error I'm getting:

com.sap.mw.jco.JCO$AbapException: (126) TABLE_NOT_AVAILABLE: QUERY_TABLE not active in Dictionary

at com.sap.mw.jco.JCO$Function.getException(JCO.java:18207)

at com.sap.mw.jco.JCO$Client.execute(JCO.java:3298)

at sap.Test3.<init>(Test3.java:52)

at sap.Test3.main(Test3.java:89)

It doesn't seem to matter what I put in for the table name.. Here's the lines that are associated..

ftemplate = mRepository.getFunctionTemplate("RFC_READ_TABLE");

JCO.Function function = ftemplate.getFunction();

JCO.ParameterList importParamList = function.getImportParameterList();

importParamList.setValue("MAST", "QUERY_TABLE");

importParamList.setValue("$", "DELIMITER");

importParamList.setValue("x", "NO_DATA");

[Former Member · Accepted solution]

From what I read yesterday, a RFC_READ_TABLE is for SAP to call a table in NetWeaver. Is this true?

Where do I get a list of interfaces in SAP? In the tutorial it says:

-=- begin cut -=-

If you do not have access to an SAP system, or you want to look up

interfaces in a different release, use the SAP Interface Repository

(http://ifr.sap.com).

-=- end cut -=-

I don't have full access to SAP (limited role). That website no longer exists. Anyone have a clue?

Thanks! Again I apologize for my ignorance.

w^2

[former_member182294 · Accepted solution]

Hi William,

RFC_READ_TABLE is to read the table data from SAP. But that is not the right approach for accessing SAP data. There will be approriate function modules available to create, update and read table data. When standard function modules are not available or if not supporting your requirement ABAP programmers creates customized function modules. You should call Remote Enabled function modules from Java to access this data.

If you need to know the Function modules available to access data you should first decide which SAP module you are working on. Better way is to contact your ABAP team and get the appropriate RFC names.

Regards

Abhilash

[Former Member · Accepted solution]

Abhilash,

That's exactly what I'm looking for. Is there a standard list somewhere? As I said in my last post, the tutorial has a reference to a standard list that doesn't exist on the website any longer. Do you have a list or know where there is one?

Thanks!

w^2

[former_member182294 · Accepted solution]

I dont know any site, but here you can find some list:

1) Go to transaction SE37

2) Select value help button or F4

3) In the popup menu select SAP Applications button in the bottom.

4) Gives you list of Function modules grouped by different SAP modules.

Regards

Abhilash

[Former Member · Accepted solution]

I don't have access to SE37 ;(

Do you know if it's listed anywhere on the internet?

w^2

[former_member182294 · Accepted solution]

You can find some FMs here.

http://www.sapdevelopment.co.uk/fmodules/fmssap.htm

But remember one thing if you want to execute these function modules then you definetly need SE37 access.

Regards

Abhilash

[Former Member · Accepted solution]

Beautiful!

Thanx Abhilash!

[Former Member]

Hi,

WebDynPro is GUI implementation tool for netweaver/portal, which uses java as backend programming. if you want to retrive the data from SAP-BAPI, it is only possible with JCO's from netweaver/portal. To access JCO's in SAP, you need to

http://<servername>:<port number>/index.html

here you have to go

Content Administator

here you see.....

Mantain JCO's, Create JCO's...etc..

If you are creating new...use create jco's. give all require fields i.e..User name/password/client etc..

i hope this will help u, how to use jco's in SAP.

you can download from...

http://services.sap.com/

Regards

RG

[Former Member]

Hi William

Welcome to SDN

First understant Netweaver

SAP NetWeaver is a web-based, open integration and application platform that serves as the foundation for enterprise service-oriented architecture (enterprise SOA) and allows the integration and alignment of people, information, and business processes across business and technology boundaries. It utilizes open standards to enable integration with information and applications from almost any source or technology. SAP NetWeaver is the foundation of SAP xApps and mySAP Business Suite solutions, and also powers partner solutions and customer custom-built applications

http://searchSAP.com/r/0,,41186,00.htm

http://help.sap.com/saphelp_nw2004s/helpdata/en/index.htm

http://www.thespot4sap.com/Articles/SAP_Netweaver_Introduction.asp

http://www.sapgenie.com/netweaver/

Go through the abive links

Not very sure, what you mean by Dynweb.

You can get result from any table through RFC's.

Query will be in RFC.

Webdynpro can be used to create front end.

Hope it helps

Regards

Pratyush

[Former Member]

Thanks for your response Pratyush.

Actually, I'm looking for a way around NetWeaver and Webdynpro. I have gotten results from SAP with something like :

http://searchsap.techtarget.com/tip/0,289483,sid21_gci886901,00.html

but for some reason, I can not use RFC_READ_TABLE . If I take that exact copy and change the names to tables that are on my list, I get an error about a dictionary.

Is there documentation somewhere on what RFC_READ_TABLE is? What other calls (libraries?) are available? I only found these by people posting them. Where's the documentation?

I just want a very simple program. I don't want netWeaver and the dynosap. I've written many, many database applications. Is there any way to write one with SAP as the database?

Thanks again!

w^2

[Former Member]

Hello William,

SAP is not actually a database rather an ERP system. What I understand if you want to bring the data from SAP system and want to utilize in Java application right ?

So what you need is to use the SAP Jco lib to connect the Java with SAP system and then call the so called BAPI. BAPI is a remote enabled function moduels ( RFC ).

But in order to call the BAPI you should know which bapi is avaiable in your sap system which you wana consume.

Hope it helps, else come back with your query

Regards,

null