topic Re: table record query in Application Development and Automation Discussions

table record query

former_member630092 — Sat, 13 Feb 2010 04:37:53 GMT

Hi,

A data base Table contains 10 reords that match my selcet query. But the report is picking the first matched record.

Can i pick the last matched recodr. (10th record ). If possible how ?

Re: table record query

venkat_o — Sat, 13 Feb 2010 04:47:34 GMT

<li>Use SELECT-ENDSELECT query with the same WHERE condition. Thanks Venkat.O

Re: table record query

Former Member — Sat, 13 Feb 2010 05:03:51 GMT

Hi,

You can also use this with select statement

ORDER BY PRIMARY KEY DESCENDING

Regards

Ahsan

Re: table record query

former_member630092 — Sat, 13 Feb 2010 05:31:48 GMT

Hi,

i have to pick the last record updated in table ,

select kbetr kpein knumh kopos from konp into CORRESPONDING FIELDS OF table itab_konp

for all entries in itab_a515

where

KNUMH = itab_a515-knumh and

kschl = itab_a515-kschl.

where m i wrong ?

Thanks

Re: table record query

Former Member — Sat, 13 Feb 2010 06:22:53 GMT

hi Ravi,

Try this

Hi,


select kbetr kpein knumh kopos from konp into CORRESPONDING FIELDS OF table itab_konp
for all entries in itab_a515
where
KNUMH = itab_a515-knumh and
kschl = itab_a515-kschl
order by knumh kschl descending.


Delete adjacent Duplicates from itab_konp
comparing knumh kschl.

Regards,

Komal

Edited by: Komal Lakhwani on Feb 13, 2010 11:53 AM

Re: table record query

kesavadas_thekkillath — Sat, 13 Feb 2010 07:37:48 GMT

YOu can try

select * from mara up to 10 rows where mtart = 'HALB' order by matnr descending.

if sy-tabix > 2.

exit.

endif.

write mara.

endselect.

also read the documentation of 'up to' statement.

or pick it into internal table sort it descending and read index 1

Re: table record query

vinod_vemuru2 — Sat, 13 Feb 2010 12:13:53 GMT

Hi,

We don't have the change log details in KONP.

So what you need to do is, after getting the data from KONP, you need to read the change documents from tables CDHDR and CDPOS. Sort this data set in DESCENDING ORDER by change date and time. Now read the first entry (INDEX 1). This is the only way you can get the last changed record.

But in your case what do you mean by last updated record? Hope you mean to say, for a given document and condition type, which item has been changed recently. If so, above logic will work.

Thanks,

Vinod.

Re: table record query

Former Member — Sat, 13 Feb 2010 14:16:44 GMT

hello Ravi

if you have time field in your table

you can make use of aggregate statements to achieve your requirements

like select max..

try putting

F1 help on this

and hope it will be usefull

cheers

S.Janagar

Re: table record query

former_member630092 — Sat, 20 Feb 2010 08:58:47 GMT

SOLVED