data services - function table structure not correct

[former_member334621]

Hello Everyone!

I am using Data Services to read a RFC from my BW system, which is defined as a "Source BW" datastore in DS.

After importing the function, i realize that the structure of the function is not imported correctly.

When i look at se37 in BW, i can see the correct structure of import table parameter:

and then looking at table E_T_GRID_DATA:

While in DS, E_T_GRID_DATA has only this "Line" component:

has anyone faced this and now how to import the correct structure ?

Thanks in advance,

Liron.

[werner_daehn]

That does not make sense. There has to be something wrong, an element called LINE does not even exist. Your structure as seen in SAPGUI is active, so it can't be that. Datatypes are all fine and the problem is not a missing column but different columns. I would check if you are really connected to the same system.

If nothing else helps, look in the se37 transaction for all functions called /BODS/.... One of these is called something like "function import" (can't recall the exact name) and run this function from SAPGUI. The return of this RFC is what DS Designer does show as imported structure.

[former_member334621]

Hi Werner,

thank you for the reply.

I found FM /BODS/FUNCTION_GET, which when ran, does in fact return the structure E_T_GRID_DATA with element "Line".

So i guess the problem lies in this FM ?

Regards,

Liron Ezra.

[werner_daehn]

I guess best would be to go to an ABAP developer and ask him for an explanation why this function module returns a LINE but not the structure you see in se37.

Either you together come to the conclusion that there is something wrong in the system and you can fix it. Or it is with the function module and you can point us into the direction of where.

Would that work for you?