Data Services functional call to extract data from SAP

[Former Member]

Hi everybody,

I want to extract data from SAP to Data Services through a functional call. First I created a RFC-enabled ABAP-function and a batch job that has the structure: Row_generation  --> Query (incl. RFC) --> Query (unnest table) --> Table.

I already succeeded in extracting all the data avaialable through my custom function. So far, so good!

Now I want to restrict the output result by defining an input table (function is similar to this http://wiki.sdn.sap.com/wiki/display/EIM/Calling+RFCs-BAPIs).

Unfurtunately that did not work.

Can you help with that problem? Which steps do I have to follow?  

Many Thanks,

Thomas

[Former Member]

Hi Thomas,

The link guides you to call RFC funcitons. That, I believe, you've already done. Can you be more clear on your requirement. Didn't get what you are trying to say in... "restrict the output result by defining an input table".

Thanks, Arun J.

[Former Member]

Sorry...

What I wanted to say is: currently I get a table with 100,000 rows as a result. To avoid too much traffic I want the function to return only certain column entries.  E.g. Select from colum 'ID' the entries '100' to '200'. The Input 'SEARCH_ATTRIBUTE'  should be used for this.

The problem is  I have no idea how this works. How can I use the table as an input parameter? 

[tomas_jahn]

1. Add another query after row generation

2. Generate a table structure in output schema of that qry as expected from RFC

3. Define mapping values

If that doesn't work

     a) check if fieldnames are the same

     b) check if schema matches the RFC