topic Re: taking only last record in Application Development and Automation Discussions

taking only last record

Former Member — Tue, 19 Jun 2007 13:45:08 GMT

hi all,

i have a flat file and in that there r multiple records of type '3' and in that i want to move some text which is at t_data-fld+359(80) to w_data-zmardesc.

the below code is working fine but it is moving the last record text only. but i want for the first record.

plz suggest what to do.

IF T_DATA-FLD+1(1) = '3'.

W_DATA-ZMARDESC = T_DATA-FLD+359(80).

ENDIF.

regards,

siri.

Message was edited by:

sireesha yalamanchili

Re: taking only last record

Former Member — Tue, 19 Jun 2007 13:48:41 GMT

try this..

data : flag(1).

IF T_DATA-FLD+1(1) = '3'.

if flag ne 'X'.

W_DATA-ZMARDESC = T_DATA-FLD+359(80).

flag = 'X'.

ENDIF.

endif.

Message was edited by:

Chandrasekhar Jagarlamudi

Message was edited by:

Chandrasekhar Jagarlamudi

Re: taking only last record

former_member187255 — Tue, 19 Jun 2007 13:50:11 GMT

If ur using loop then Check something like this.....

IF SY-TABIX EQ 1.
IF T_DATA-FLD+1(1) = '3'.
W_DATA-ZMARDESC = T_DATA-FLD+359(80).
ELSE.
EXIT.
ENDIF.

Hope this helps...

Re: taking only last record

Former Member — Tue, 19 Jun 2007 13:55:45 GMT

Hi chandras thank you,

i am not using loop.

regards,

siri.

Re: taking only last record

Former Member — Tue, 19 Jun 2007 13:56:33 GMT

try this

data : flag(1).

IF T_DATA-FLD+1(1) = '3'.

if flag ne 'X'.

W_DATA-ZMARDESC = T_DATA-FLD+359(80).

flag = 'X'.

ENDIF.

endif.

Re: taking only last record

Former Member — Tue, 19 Jun 2007 13:59:07 GMT

hi,

what is this flag concept could you plz explain.

regards,

siri.

Re: taking only last record

rodrigo_paisante3 — Tue, 19 Jun 2007 13:59:23 GMT

Helo, you can do like this:

READ TABLE T_DATA INDEX 1

IF T_DATA-FLD+1(1) = '3'.

W_DATA-ZMARDESC = T_DATA-FLD+359(80).

ENDIF.

Or if you need, use the sort command before the read.

Regards

Message was edited by:

Rodrigo Paisante

Message was edited by:

Rodrigo Paisante

Re: taking only last record

Former Member — Tue, 19 Jun 2007 14:06:31 GMT

first time the FLAG will be space ,

IF T_DATA-FLD+1(1) = '3'.   " enters IF condition when condition met
if flag ne 'X'.                        " as flag is SPACE for first time it will continue,
                                         "second time when it comes flag will be X , so it will
                                         "not enter and you will have the first record data 
W_DATA-ZMARDESC = T_DATA-FLD+359(80).
flag = 'X'.
ENDIF.
endif.