topic Re: BAPI/RFC - Function module code explanation-VERY URGENT!!!!! in Application Development and Automation Discussions

BAPI/RFC - Function module code explanation-VERY URGENT!!!!!

Former Member — Mon, 25 Jul 2005 14:49:01 GMT

Hi folks,

I need to generate the report 'Order Status' on Java application from BW. I have the following fields in BW 0DOC_NUMBER, 0MATERIAL, 0REQ_DATE, ORDER_QUAN,0SHIP-TO and the report on Java portal has the fields like Order No, Product, Delivery Date, Ordered Quantity, Ship to location. So how do I proceed with the BAPI/RFC.

The steps to be followed are first create and function group and then name a function module and under attribute tab chose 'remote selection or so' and then in import parameters and export parameters, what do I need to chose and how to create a BAPI or function module. Can u just create one for the above example quoted? Any help would be great.

Thanks,

Nikki

Re: BAPI/RFC - Function module code explanation-VERY URGENT!!!!!

RichHeilman — Mon, 25 Jul 2005 15:02:04 GMT

Import paramters:

OrderNumber

Export paramters:

Create a structure of the fields that you required.

ZORDER-VBELN

ZORDER-MATNR

ZORDER-EDATU

ZORDER-KWMENG

ZORDER-KUNNR

Use this new structure for your exporting parameters:

In the source code, use select statements against the sales document tables to get your data, filling the ZORDER structure.

Regards,

Rich HEilman

Re: BAPI/RFC - Function module code explanation-VERY URGENT!!!!!

athavanraja — Mon, 25 Jul 2005 18:03:32 GMT

are these fields are from ODS or cube? check out my weblog where i have explained how you could execute BW query using RFC. you could simply create a query with the required fields and use the explained procedure in my weblog to execute the query and get the results.

/people/durairaj.athavanraja/blog/2005/04/03/execute-bw-query-using-abap-part-i

/people/durairaj.athavanraja/blog/2005/04/03/execute-bw-query-using-abap-part-ii

if you dont like this approach, you can try MDX . check out the following weblog for the same.

/people/prakash.singh4/blog/2005/03/12/get-bw-data-in-portal-via-jca-using-mdx-statement

(this is a java iview code)

just for clarification. why dont you simply use bw query iview?

Regards

Raja

Re: BAPI/RFC - Function module code explanation-VERY URGENT!!!!!

Former Member — Mon, 25 Jul 2005 19:01:54 GMT

Hello Raja,

Thanks for the reply. I created a query and tried to copy the same as in your weblog but couldn't understand how to define the structure ZBW_QUERY_OUTPUT_METADATA. After creating this RFC whatelse has to be done from SAP side and is there no necessity to create BAPIs and how should the Java programmer approach from here to apply this on the websphere portal.

Please this might look quite simple to you but its a bit complicated to me as I have very little knowledge in ABAP.

Nikki

Re: BAPI/RFC - Function module code explanation-VERY URGENT!!!!!

Former Member — Mon, 25 Jul 2005 19:41:10 GMT

Raja,

Regarding the iview code, from BW side, I need to create the MDX statement and then define all the BAPI's listed and where does that code apply? I mean JAVA programmer is supposed to create where? on his application?

Let me know,

Thanks,

Nikki

Re: BAPI/RFC - Function module code explanation-VERY URGENT!!!!!

athavanraja — Tue, 26 Jul 2005 05:48:02 GMT

the sturcture ZBW_QUERY_OUTPUT_METADATA can be created from transaction SE11.

once you create the FM speicifed (with RFC enabled in the attributes tab of the FM). you dont need to do anything other than just creating queries. the java programmer either in his bean or in pageprocessor class will call this function module pass the required parameters and get the results.

MDX

in this case you dont need to do anything . this way you either directly query a cube using MDX or execute a query using MDX. constructing the MDX query statement can be done as a BW person by you from transaction MDXTEST.

and just pass it on to the java person. he will have to call BAPI_MDDATASET* FMs to pass this mdx and get the results.

Hope this is clear.

Regards

Raja

Re: BAPI/RFC - Function module code explanation-VERY URGENT!!!!!

Former Member — Tue, 26 Jul 2005 12:47:14 GMT

Hi Raja,

Thanks again. I did the same as mentioned by you, created a query and copied the exact code as in the web log but just changed the query name and I need to do the same for 2 or 3 other queries. Am I going in the right direction? Do I need to add or change any fields from my query into the code you have written or is all that taken care of in the code itself.

Please let me know.

Nikki

Re: BAPI/RFC - Function module code explanation-VERY URGENT!!!!!

athavanraja — Tue, 26 Jul 2005 12:54:46 GMT

that one FM can run any query, thats the whole purpose of it. just pass the query name and its parameter to the FM. thats all you need to do.

Regards

Raja

Re: BAPI/RFC - Function module code explanation-VERY URGENT!!!!!

Former Member — Tue, 26 Jul 2005 13:06:01 GMT

Hi again,

Sorry but can you tell me what this parameter is about? Do I have to give my own query variables if I have any for my query and if so what is this low and high becoz I do not see this options. I just see short and long text in the 'tables' tab.

Hoping to see an answer which would help me figure out if I am going in the right track.

Thanks,

Nikki

Re: BAPI/RFC - Function module code explanation-VERY URGENT!!!!!

athavanraja — Tue, 26 Jul 2005 13:18:33 GMT

example.

you have a query from cube "XYZ" called "MYQUERY"

and when you run it from BEX you pass a variable period (001.2005)(0P_FPER) to this query .

to execute this using FM

pass "XYZ/MYQUERY" to the parameter query_name.

pass "0P_FPER" to query_variables-vnam ,

"I" to query_variables-sign,

"EQ" to query_variables--opt,

"2005001" to query_variables-low .

Now you are ready to execute the FM to run the query "XYZ/MYQUERY" and get the results in XML format. (xml_out) and meta (tables parameter) would give you details about the result set , like column names, data type , etc.

Hope this is clear.

Regards

Raja

Re: BAPI/RFC - Function module code explanation-VERY URGENT!!!!!

Former Member — Tue, 26 Jul 2005 13:41:29 GMT

Raja,

Firstly it doesn't accept '/' between the cube and query name, secondly I have a variable 0calday which is optional and in the 'tables' tab for defining the variables I have options like

Parameter name/Type spec/Associated type/Optional/Short text/Long text.

So I am defining it as

0CALDAY/LIKE/RRX_VAR/OPTIONAL/

Let me know please.

Thanks,

Nikki

Hi Raja,

Any updates for me please, can you please explain the table parameters again.???

Re: BAPI/RFC - Function module code explanation-VERY URGENT!!!!!

athavanraja — Tue, 26 Jul 2005 20:03:09 GMT

sorry for the delay, i wasn't at work. can you tell me which function module are you using. It looks to me that you are not using the FM from my weblog.

Regards

Raja

Re: BAPI/RFC - Function module code explanation-VERY URGENT!!!!!

Former Member — Tue, 26 Jul 2005 21:39:49 GMT

Hi Raja,

I am using the same code (literally copy, pasted your code) you explained in the weblog but just changed the query name but here it accepts just the query name but not as you mentioned cube/query and I have a question regarding the table parameters as I have '0calday' and 'ship-to-location' as my variable option. This query I am building on a Multicube Y_SCM_MP1. Hope I am not wrong, let me know.

Thanks for your patience.

Nikki

Only change is I have given the function module name as Z_SD_ORDERSTATUS

Can you please explain what this is??

"CHAR50" must be a flat structure. You cannot use internal tables, strings, references, or structures as components.

Re: BAPI/RFC - Function module code explanation-VERY URGENT!!!!!

athavanraja — Wed, 27 Jul 2005 06:19:21 GMT

Can you please explain what this is??

"CHAR50" must be a flat structure. You cannot use internal tables, strings, references, or structures as components.

in the import parameter tab for parameter QUERY_NAME you would have specified the type spec as LIKE instead of type . please change it to type.

just changed the query name but here it accepts just the query name but not as you mentioned cube/query

i dont understand, when you call this FM (Z_SD_ORDERSTATUS) you need to pass "cube/queryname" to the QUERY_NAME parameter .

this example will work for multicube also, we have tested it.

Let me explain what you have to do

1. create the FM as explained in Execute BW query using ABAP Part I. you dont have to change anything, just copy paste it.

2. copy BAPI_IOBJ_GETDETAIL to Z_BAPI_IOBJ_GETDETAIL and comment the following code in the copied BAPI.

*  CALL METHOD cl_rsd_iobj=>authority_check
*    EXPORTING
*      i_iobjnm            = infoobject
*      i_activity          = rssb_c_auth_actvt-display
*    EXCEPTIONS
*      user_not_authorized = 1.
*  IF sy-subrc <> 0.
*    bapi_syserror.
*    EXIT.
*  ENDIF.

3. Now create the XSLT program as explained in Execute BW query using ABAP Part II (just copy paste it).

4. Now create a program from SE38 (type1) and copy paste the code given at the end of the blog. change the following code in this program to point to the XSLT program you have created in the previous step.

 TRY .
        CALL TRANSFORMATION (`<<b>this is your xslt program name</b>`)
        SOURCE XML  xml_out
        RESULT     outtab = <outtab>.
      CATCH cx_xslt_exception INTO xslt_error.
        xslt_message = xslt_error->get_text( ).
    ENDTRY.

5. fill the variables, in the following section of the code in the report program.

move: <cube/query name> to rpt_tech_id .
MOVE: '0CALDAY'  TO wa_var-vnam ,
  'I' TO wa_var-sign,
  'EQ' TO wa_var-opt, 
  <variable value> TO wa_var-low .
APPEND wa_var TO var .

Hope this is clear now.

Regards

Raja

Re: BAPI/RFC - Function module code explanation-VERY URGENT!!!!!

Former Member — Wed, 27 Jul 2005 13:20:04 GMT

Hello Raja,

I gave the type spec as TYPE but when I define the cube name with the query name it gives the following error-"only use '/' as a namespace delimiter", example the one I named is Y_SCM_MP1/ZSD_MP02_ORDSTS.

Secondly when I go to transaction SE38 what are the steps involved in writing a source code. I defined my program name as ZCWS but what do I need to enter into the next page with type, status, application, authorization group. Once I enter this I can copy and insert the code you mentioned with the changed given.

Please let me know asap and at your convenience

Thanks,

Nikki

Re: BAPI/RFC - Function module code explanation-VERY URGENT!!!!!

athavanraja — Thu, 28 Jul 2005 10:47:38 GMT

I gave the type spec as TYPE but when I define the cube name with the query name it gives the following error-"only use '/' as a namespace delimiter", example the one I named is Y_SCM_MP1/ZSD_MP02_ORDSTS.

Do you meanto say that you typed in "Y_SCM_MP1/ZSD_MP02_ORDSTS" when you were creating a query in the BW query designer? there you will just give ZSD_MP02_ORDSTS . only when passing this value to the FM you will give it in cbe/query format.

SE38

type - executable program (1)

and give a description in the description field and hit save. thats all you need.

now in the next screen paste the code and modify the same as explained in the previous post.

Regards

Raja

Re: BAPI/RFC - Function module code explanation-VERY URGENT!!!!!

Former Member — Thu, 28 Jul 2005 14:35:54 GMT

Hello Raja,

I named cube/query i.e. Y_SCM_MP1/ZSD_MP02_ORDSTS not in the query designer but while defining it in the import tab in the function module as follows:

Y_SCM_MP1/ZSD_MP02_ORDSTS TYPE CHAR50 PASS VALUE

I have an other question, do I need to create 3 other function modules under the same function group as I have 3 to 4 reports built on a third party tool.

Note: these 4 queries I am building on BW is from the same multicube. So am I supposed to define 4 queries in the same import tab or create 4 different function modules under same function group or different again??

Let me know.

Thanks,

Sree

Re: BAPI/RFC - Function module code explanation-VERY URGENT!!!!!

athavanraja — Fri, 29 Jul 2005 06:24:39 GMT

it has to be query_name and during runtime you will pass the cube/queryname to this parameter. thats where you are making a mistake. and you just have to create one FM, everytime you call this FM pass a different query name to this function. thats the whole purpose of this FM.

Regards

Raja

Re: BAPI/RFC - Function module code explanation-VERY URGENT!!!!!

Former Member — Tue, 02 Aug 2005 16:22:24 GMT

Hello Raja,

I created the same way as you described in your weblog except that I changed the name of the function module. Now I have 4 to 5 queries on the same multicube which are generated in Websphere portal. So the Java programmers can call the same function module but giving 5 different query names as their import parameters and since the table parameter (0CALDAY) is already taken care of on the BW code, they can build 5 different java codes and run the portal.

Am I right??

Nikki

Re: BAPI/RFC - Function module code explanation-VERY URGENT!!!!!

athavanraja — Tue, 02 Aug 2005 19:45:00 GMT

you are right. use the same function module.

for query 1.

call the fm and pass query1 name and variables

for query 2

call the same fm and pass query2 name and variables

and so on.

since the table parameter (0CALDAY) is already taken care of on the BW code

is it same for allthe queries, table parameter has to be filled each time with that particular query's variables.

Regards

Raja