get the latest record of p2001 .

[Former Member]

Hi,

My requirement is to get the latest record of p2001 and the condition awart eq '0620'. and i am using the macro rp_provide_from_last p2001 space p_begda p_endda.here i am getting the latest record but not for the condition awart eq '0620'.so how to get the latest records from p2001 of condition awart = '0620'.Cany anyone help me to solve this issue.

Thanks,

Deesanth

[Former Member]

Hi Deesanth,

You can get in another way write a select statement as per your requirement. Then sort the internal table and read the first record.

Correct me if I am wrong.

Thanks & Regards,

M.Ramana Murthy

[Former Member]

Hi Deesanth,

Before you use the Macro (rp_provide_from_last p2001 space p_begda p_endda) use the below code it may work for your condition.

DELETE P2001 WHERE awart NE '0620'. then use the above macro.

Please let me know if you need more information.

Regards,

Ramakrishna kotha.

+91 9848468817.