topic Re: How can I read multiple table using RFC_READ_TABLE? in Application Development and Automation Discussions

How can I read multiple table using RFC_READ_TABLE?

Former Member — Wed, 16 Sep 2009 03:13:55 GMT

My requirement is to retrieve the DDTEXT for a FIELDNAME.

DDTEXT is available in DD04T while FIELDNAME is available in DD03L.

How can I join th tables using RFC_READ_TABLE.If not can you suggest an alternative RFC.

Please note that I need to invoke RFC from java layer. Hence need to use some standard RFC as writing my own RFC is not an option available to me.

Edited by: MNGhosh on Sep 16, 2009 5:14 AM

Re: How can I read multiple table using RFC_READ_TABLE?

Former Member — Wed, 16 Sep 2009 04:07:57 GMT

Try to find a view on required tables or create a view

and then get data using rfc_read_table

Re: How can I read multiple table using RFC_READ_TABLE?

Former Member — Wed, 16 Sep 2009 05:14:23 GMT

Hi ,

U can create a view and pass the view to the RFC

Re: How can I read multiple table using RFC_READ_TABLE?

Former Member — Wed, 16 Sep 2009 05:18:03 GMT

use table : DD03T

Re: How can I read multiple table using RFC_READ_TABLE?

Former Member — Wed, 16 Sep 2009 05:24:27 GMT

Thanks for the information.

However, when I serach the table DD03T by giving TABNAME as VBAK it gives no entry found.Why is that so?

Does this table contain the details for only certain tables or for all?

Re: How can I read multiple table using RFC_READ_TABLE?

Former Member — Wed, 16 Sep 2009 05:27:55 GMT

Thanks for your reply.

However,the option of creating a view is not available.I need to use standard RFC and standard tables only. Any changes on sap side will not help.

Re: How can I read multiple table using RFC_READ_TABLE?

Former Member — Wed, 16 Sep 2009 05:37:25 GMT

hi,

try DD03VT

Re: How can I read multiple table using RFC_READ_TABLE?

Former Member — Wed, 16 Sep 2009 05:38:35 GMT

For table VBAK entries u have to pass E1FVBAK in table name that gives corresponding vbak field names and desc.

Re: How can I read multiple table using RFC_READ_TABLE?

Former Member — Wed, 16 Sep 2009 05:55:20 GMT

Hi ,

Thanks for the information.

Now I am able to retrieve the data .However, one question here is how do we know that for VBAK we need to pass E1FVBAK.

Is there some table that contains this mapping . As I would need to know this inof noty just for VBAK . In general I need to get this for all sap tables.

Also , One important observation is that DDTEXT is empty.

Even though, DDTEXT for VBELN is available in DD04T.Why is that so.

In that case it wont be helpful in my scenario as I need to fetch teh DDTEXT for a given field of a given table.

It would very helpful if you could throw some light on this as well.

Regards,

MNGhosh

Re: How can I read multiple table using RFC_READ_TABLE?

Former Member — Wed, 16 Sep 2009 05:58:16 GMT

MNGhosh,

in view DD03VT:

pass table name as : VBAK

for vbeln you have

VBAK	VBELN	A	TRANSP		2	X		VBELN_VA	VBELN	VBUK	0	C	20					X	10	CHAR	E			SAP	12.09.2009		E	Sales Document	Sales Doc.	Sales Doc.	Sales Document	Sales Document

and for DD03T

you can pass TABNAME = '%VBAK%' in the options table

Edited by: Soumyaprakash Mishra on Sep 16, 2009 11:31 AM

Re: How can I read multiple table using RFC_READ_TABLE?

Former Member — Wed, 16 Sep 2009 06:13:23 GMT

Thanks a lot for your help!!

This is what I was looking for.