for all entries in AMDP

[karthik_sub]

Hi Experts,

I have the below scenario and request to guide me on the same .

1. Have a custom Report via se38

2. where the user will upload some 2000 records or more than 2000

3. In the existing solution, open sql statements where used inside the loop statement

- Im planning to just pass the complete 2000 records(internal table) to amdp importing option and make the fuzzy search

- I feel no need for the loop statement and then pass each field for amdp select query

4. Frame the select as below with some example...

Hope this approach will be a proper way of achieivng it . Right ?

Kindly suggest me the same.

[Sandra_Rossi]

Your question is about "fuzzy search", but I see nothing in your question about fuzzy search (except "I'm planning to [...] make the fuzzy search"). What is your question?

[karthik_sub]

Hi Sandra,

I will reframe it. I just want to know whether my approach is correct for using 'for all entries' inside the AMDP...

so that i can pass bunch of records directly to AMDP class and methods.

Regards,

KArthik S

[Sandra_Rossi]

Waiting for your "reframe"...

[karthik_sub]

hi Sandra,

My query is to pass the internal table to amdp method. Sample code provided above is correct or is there a better way to achieve it

Regards

Karthik s

[Sandra_Rossi]

Still wondering why it's about fuzzy search.

Menu Actions > Edit. So simple.

[karthik_sub]

HI Sandra,

Subject been edited on the path provided.

Regards,

Karthik S

[Sandra_Rossi]

SELECT inside loops must be absolutely avoided (as far as possible).

FOR ALL ENTRIES must be avoided as far as possible.

Joins are to be privileged as far as possible.

Any of 3 solutions WITH, GTT and AMDP can be used to replace FOR ALL ENTRIES if a join cannot be used.

[karthik_sub]

Hi Sandra,

Thanks for the suggestion.

Regards,

KArthik S

[ThorstenHoefer]

Hi,

you can replace a for all entries with this join:

select a.*
from sflight as a
inner join :it_flights as b
on b.carrid = a.carrid
and b.connid = a.connid
and .....

[karthik_sub]

Hi Thorsten,

Thanks for the suggestion.

Regards,

Karthik S