RFC - Obtain SO from another SAP system

[Former Member]

Hi Experts,

I need to develop an RFC Func Mod that obtains the list of Sales orders from (Say table VBAK) from a BW system.

Could any one tell me how to do this?

Thanks

Dan

[former_member181962]

Why develop?

There are standard bapis which would do it for you. Use BAPI_SALESORDER_GETLIST instead.

REgards,

Ravi

[Former Member]

Hi,

Go to SE37..

Create a function module..

In the attributes tab..Set the radio button which says "Remote enabled"...

Then that function module becomes RFC..

Then do the following statement..

SELECT VBELN INTO TABLE PT_ORDERS

FROM VBAK.

Thanks,

Naren

[Former Member]

Hi Ravi,

Thank you..

But if i need to get a data for some customized field from a Z table then how can i do that?

thanks

[former_member181962]

HI Dan,

Its very simple.

You should go to se37 transaction.

Then Create a remote enabled function module just as you would develop a normal one, but for the radio-button in the attributes section of the fm to be set to Remote-enabled.

Then write your selects inside the code section. Fill the RFC FM's interface tables.

REgards,

Ravi

[Former Member]

Hi,

You can use the FM RFC_READ_TABLE to read custom tables..

Thanks,

Naren

[Former Member]

Hi Ravikanth & Narendra ,

Can i write a select query to hit BW tables starting with names /BIC/.....in the ord ABAP system as such tables are not available?

RFC_READ_TABLE is throwing some other exceptions '7'.

I should develop a cust FM for RFC and should not use the standard ones.

Could you please elaborate you explanation :

- like after using select stmt into relevant FM interface internal tables, how do i make use of them back in my calling system to generate reports?

thanks

Dan