topic Re: output change due to code change in Application Development and Automation Discussions

output change due to code change

Former Member — Wed, 25 Jun 2008 06:41:13 GMT

Hi,

I tried to change some code for performance imp. But the o/p is getting wrong. Kindly suggest where i made mistake

Code before change:

SELECT * FROM pb4001 WHERE

begda EQ yesterday

ORDER BY pernr DESCENDING.

wa_appl-applnr = pb4001-pernr. " application nr

wa_appl-matnr = pb4001-pernr. " match nr = application nr

wa_appl-appl_begda = pb4001-begda. " date of applicataion

wa_appl-mat_begda = pb4001-begda. " date of application

wa_appl-mark = 'A'. " A = applicant

Code after change:

Select pernr begda from pb4001 into table it_pb4001

where begda EQ yesterday.

Sort it_pb4001 descending by pernr.

wa_appl-applnr = it_pb4001-pernr. " application nr

wa_appl-matnr = it_pb4001-pernr. " match nr = application nr

wa_appl-appl_begda = it_pb4001-begda. " date of applicataion

wa_appl-mat_begda = it_pb4001-begda. " date of application

wa_appl-mark = 'A'. " A = applicant

Former Member — Wed, 25 Jun 2008 06:43:26 GMT

Could you please tell me what output do u exactly want?

Former Member — Wed, 25 Jun 2008 06:43:44 GMT

Oooooooops Sorry, i am wrong.

Edited by: Eswar Rao Boddeti on Jun 25, 2008 2:44 PM

Former Member — Wed, 25 Jun 2008 06:44:26 GMT

Select pernr begda from pb4001 into table it_pb4001

where begda EQ yesterday.

Sort it_pb4001 descending by pernr.

Use Loop at it_pb4001.

wa_appl-applnr = it_pb4001-pernr. " application nr

wa_appl-matnr = it_pb4001-pernr. " match nr = application nr

wa_appl-appl_begda = it_pb4001-begda. " date of applicataion

wa_appl-mat_begda = it_pb4001-begda. " date of application

wa_appl-mark = 'A'. " A = applicant

endloop

Former Member — Wed, 25 Jun 2008 06:54:06 GMT

hi,

do this:

Sort it_pb4001 by pernr descending.

descending only after the field u want to sort.

regards,

madhu