Access proxy structure

[Former Member]

Hi-

I am trying to retrieve the values that i get in my proxy and insert the values to a table.

The screen shot of the structure that i have in proxy is <a href="http://venkat.healthyplace2.com/">Structure Screen Shot</a>.

The code i have written is..

method ZII_MI_VENDOR_TO_BW~EXECUTE_ASYNCHRONOUS.

• **** INSERT IMPLEMENTATION HERE **** ***

*tables zmdm_vendor.<b>I am getting an error here that i cannot use tables statement in a method.</b>

data: itab_venkat type ZMI_VENDOR_TO_BW_GENERIC_V_TAB.

data: wa_venkat like line of itab_venkat.

itab_venkat = Input-Generic_Vendor-Generic_Vendor_Record1.

• Delete all existing records in the table.

delete zmdm_vendor.<b>I am getting an error that i cannot delete,what is the correct way to do?</b>

• Now loop thru all the records of the inbound record and insert into *

• the table.

LOOP AT itab_venkat into wa_venkat.

zmdm_vendor-vendorid = wa_venkat-generic_vendor_id1.

zmdm_vendor_groupid = wa_venkat-group_id1.

zmdm_vendor_country = wa_venkat-country1.

modify zmdm_vendor.

endloop.

endmethod

Can someone correct my code and help me.

Thanks in advance.

Venkat

[Former Member · Accepted solution]

Hi Venkat,

Don't try to update the table from the Execute-Asynchronous method directly. Instead write a RFC that does the updation and call the RFC from the proxy implementation class.

Get the input from the proxy. set it as input parameters to the RFC. get the job done.

Hope this helps.

Regards,

P.Venkat

[Former Member · Accepted solution]

does it mean i get my values from the proxy into a internal table,and loop thru the internal table and pass the values from the internal table to another function module and call the database table there?

Some body please help.I am stuck.

Thanks

Venkat

[Former Member · Accepted solution]

Hi,

The 0...unbounded details are converted to table. So yes you have to.

If you drill down your strucure you will undestand whats the table and whats the structre.

First pick data from the Header data if you have any and then go to the loop so that you can understand how the MT is converted to structures.

Please look at this weblog Report for guidance:

/people/siva.maranani/blog/2005/04/03/abap-server-proxies

Regards

Vijaya

Message was edited by: vijaya kumari

[Former Member · Accepted solution]

Hi Venkat,

Yes, u r absolutely right. Loop through the internal table, pass the parameters to the RFC and insert in to the table within that RFC.

Hope this helps.

Regards,

P.Venkat

[Former Member]

Venkat,

The proxies will have nested internal tables, so you will have to drill down to each level and then process the table at that level. You can go to the next level by clicking on it and seeing in which column the data will be present.

For deleting use

DELETE FROM ZMDM_VENDOR.

Regards,

Ravi