topic Re: Can we loop an internal table inside AMDP method in Application Development and Automation Discussions

Can we loop an internal table inside AMDP method

Former Member — Thu, 19 May 2016 07:44:34 GMT

Hello Expert,

Please help me for the below points:

1. Can we loop an internal table inside AMDP method.

2. Can we write delete adjacent duplicate.... inside AMDP method.

3. What all operation we can do inside the AMDP method.

If yes please help me with an example.

Thanks & Best Regards,

Kailash

Re: Can we loop an internal table inside AMDP method

thomasgauweiler — Thu, 19 May 2016 11:31:52 GMT

1. Can we loop an internal table inside AMDP method.

Better don't do it. Your performance will go down.

2. Can we write delete adjacent duplicate.... inside AMDP method.

itab = select distinct * from :itab;

3. What all operation we can do inside the AMDP method.

Have a look at the SQL Script Reference in http://help.sap.com/hana/SAP_HANA_SQL_Script_Reference_en.pdf

Best Regards, Thomas

Re: Can we loop an internal table inside AMDP method

Former Member — Thu, 19 May 2016 11:57:00 GMT

Thank you Thomas.

Re: Can we loop an internal table inside AMDP method

Former Member — Thu, 19 May 2016 12:38:35 GMT

Hello Thomas,

My requirement is first i wiil fetch data from table VBRK and VBRP by doing the join operation, then I will keep that data into another table for further use. From the second internal table I will delete the duplicate entry and I will use that internal table to fetch data from other table.

I want to write this type of logic inside the AMDP method.

Thanks & Best Regards,

Kailash

Re: Can we loop an internal table inside AMDP method

thomasgauweiler — Thu, 19 May 2016 14:04:45 GMT

Try it like this:

first_itab = SELECT .. FROM VBRK JOIN VBRP ... ;

second_itab = SELECT DISTINCT ... FROM :first_itab;

third_itab = SELECT ... FROM OTHERTABLE JOIN :second_itab;

Why do you want to write that logic in AMDP ?

Best Regards, Thomas

Re: Can we loop an internal table inside AMDP method

amol_samte — Thu, 19 May 2016 14:56:57 GMT

Hello Binod,

If you have concern about performance then you should have to choose AMDP....

But now advanced open SQL also pretty much faster and has compatibility with HDB.

For your case you can go with advanced open SQL over AMDP , since it does not have performance impact is my assumptions...

I guess Thomas has given you best possible answer...

Regards,

-Amol S

Re: Can we loop an internal table inside AMDP method

Former Member — Fri, 20 May 2016 06:06:32 GMT

Thank you Thomas.

Re: Can we loop an internal table inside AMDP method

selva123 — Mon, 12 Oct 2020 03:26:07 GMT

There is a scenario where as I can't avoid loop. I have 2 ways to achieve it. 1st way is writing loop in AMDP. And 2nd way is writing loop in Report. Please let me know which way is better.

Re: Can we loop an internal table inside AMDP method

matt — Mon, 12 Oct 2020 10:24:50 GMT

selva123

It's probably better to raise your own question rather than hijacking an old one.