Skip to Content
author's profile photo Former Member
Former Member

What badi is used when I call "FromSAP" pass with "ENTRYTYPE=TABLE"?

Hello,

I need to get information from table HRP1000 which contains >500 000 entries.

When I run pass fromCustom with pass type "FromSAP" to select all lines from this table, I get error about memory lack:

"Unhandled Error in DSERuntime - Exception:java.lang.OutOfMemoryError: Java heap space (failed to allocate 32 bytes)"

My fromSAP pass:

I checked the post "How to filter and read large data in SAP table using IDM Job ?", but recommendation to filter entries with "FILTER SELECTION_EXP:0....." doesn't work for me too (as same as for post's author).

I read this post "Technical Overview of BAPIs used to connect to ABAP Application Servers" and it says that "When reading ABAP Table information - the RFC_READ_TABLE used".

Do I understand correctly that when I set parameters "ENTRYTYPE=TABLE" pass fromSAP will use badi RFC_READ_TABLE?

1. Where can I check it?

I would grateful if anybody can provide me link to documentation or real samples where I can see what BADI is used by toSAP or FromSAP passes.

I read Note 1398976 - SAP IdM: Filter definition for initial load of ABAP entities,

it very nice describes how to filter Roles,Profiles and Users, but no word about how to filer Tables data.

2. If RFC_READ_TABLE is used , how could I pass parameters: OPTIONS and FIELDS to badi?

Thanks in advance!

fromSAP.jpg (59.6 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 06, 2013 at 11:52 AM

    Hi all,

    I added parameter -Xmx51200M to dispatcher script and problem with OutOfMemoryError is solved.

    But I need to filter data from table in any way, becuase I don't want to upload 500.000 entries when I need just 10.000 from it.

    Please help me to filter data from table.

    Best regards,

    Natalia.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 19, 2016 at 07:03 PM

    Hi Natalia,

    maybe you have already saved your problem?!

    We were just facing the same one and found a very simple solution. Instead of populating data to a Z-Table we just defined a view in the ABAP dictionary of the ERP system which includes the filtering for the relevant rows and columns of the source table (in our case HRP1001 which is even bigger).

    Instead of entering HRP1001 as value to parameter TABLE we added the name of the view then (e. g. ZHRP1001).

    This does not involve any BAdI or triggers to populate data into other tables and is completely transparent to the IDM.

    We had just to add some authorizations to the RFC user (S_TABU_NAM and S_TABU_DIS), which were very restrictive before, and reduced our load time from about 2,5 hours to less than 10 seconds (memory usage has been reduced also dramatically).

    Maybe this hint is helpful for others or even for you if you did not yet find a good solution for your problem.

    Regards,

    Dirk

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.