topic Re: Code for - 1 Record in Application Development and Automation Discussions

Code for - 1 Record

adeel_sarwar — Thu, 17 Jul 2008 17:03:34 GMT

Hi,

How can i achive the following please see example below.

select * from MARA

where MATNR = 'MATERIALB'

Write: MATNR.

So in the above statement i want the record to find Material B and show me the previous record if that makes sense.

Suppose the table MARA has 2 records

Record1: MATERIALA

Record2: MATERIALB

so i want to use the same selection statement and it should bring me MATERIALA in the result not MATERIALB as i want the previous record.

Please note i have created the above scenario to explain.

Re: Code for - 1 Record

Former Member — Thu, 17 Jul 2008 17:11:53 GMT

Hi Adeel,

In the database it may not be stored in the order of what we see.It can be stored in any order other than what we see in T-codes SE11 or SE16. It is practically not possible to fetch the record X by giving keys for record Y.

May i know the exact business reason to bring in the so called previous material number? If that is known then there can be a way

//Kothand

Re: Code for - 1 Record

Former Member — Thu, 17 Jul 2008 17:19:28 GMT

Performance will be bad, but so long as you are sure that MATERIALB is in the database, you can use:

DATA: mara_int TYPE TABLE OF mara.

SELECT * FROM mara
  INTO TABLE mara_int
  UP TO 2 ROWS
  WHERE matnr <= 'MATERIALB'
  ORDER BY matnr DESCENDING.

Rob

Re: Code for - 1 Record

Former Member — Thu, 17 Jul 2008 17:20:13 GMT

You may want to decrement sy-tabix resulting from select for materialB by 1 and then go to select again from the database with the new index value.

Re: Code for - 1 Record

adeel_sarwar — Thu, 17 Jul 2008 20:19:38 GMT

Hi,

I used the above scenario as an example to explain what i am trying to get at. the tables are in the correct order everything else is fine all i want to know is how to get the previous record for what i have searched for as described above.

thanks

Re: Code for - 1 Record

Former Member — Thu, 17 Jul 2008 20:22:47 GMT

Well, I tested my code before posting it. It did what I understood you to want. Did you try it?

Rob

Re: Code for - 1 Record

adeel_sarwar — Wed, 27 Aug 2008 22:20:07 GMT

Got an ABAPER to do this. thanks