Skip to Content
avatar image
Former Member

get the latest record of p2001 .

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 02, 2008 at 07:45 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 02, 2008 at 07:36 AM

    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

    Add comment
    10|10000 characters needed characters exceeded