topic Re: itab data display in Application Development and Automation Discussions

itab data display

Former Member — Wed, 07 Dec 2005 06:48:10 GMT

Hi,

I have itab1 data like this.

fld1-fld2

alfa 200000045

alfa 200000046

alfa 200000047

alfa 200000048

beta 200000051

beta 200000052

beta 200000053

beta 200000054

In the itab2 i want to display like this

alfa 200000045

200000046

200000047

200000048

beta 200000051

200000052

200000053

200000054

How to do this? My objective is display fld1 value only one time for all the values of fld2.

points guaranteed

cheers

kaki

Re: itab data display

Former Member — Wed, 07 Dec 2005 06:51:32 GMT

Hi,

loop at itab.

on change of itab-fld1.

write:/ itab-fld1,

itab-fld2.

endon.

write:/ itab-fld2.

endloop.

Try with this.....

_Thanks

If this helps u reward points and close the thread.

Message was edited by: Deepak333 k

Re: itab data display

athavanraja — Wed, 07 Dec 2005 06:51:38 GMT

you can use at new for this.

loop at itab1 .

at new fld1 .

move: itab1-fld1 to itab2-fld1 .

endat .

move itab1-fld2 to itab2-fld2 .

append itab2.

endloop .

Regards

Raja

Re: itab data display

Former Member — Wed, 07 Dec 2005 06:52:58 GMT

hi Check the program out put there they are getting they are combining the airlines and showing it..

BALVST02_GRID.

Re: itab data display

Former Member — Wed, 07 Dec 2005 06:54:18 GMT

Hi,

Use control break statements:

Note that first you need to sort your internal table.

SORT ITAB.

LOOP AT ITAB.

AT NEW FLD1.

WRITE: ITAB-FLD1, ITAB-FLD2.

ENDAT.

WRITE: ITAB-FLD2.

ENDLOOP.

Regards,

Sudhakar.

Re: itab data display

kanthimathikris — Wed, 07 Dec 2005 06:54:38 GMT

sort itab1 by fld1.

loop at itab1.

at new fld1.

write itab1-fld1.

endat.

write itab1-fld2.

endloop.

Message was edited by: Kanthimathi Krishnan

Re: itab data display

Former Member — Wed, 07 Dec 2005 06:54:41 GMT

hi kaki,

I think you are asking this doubt for ALV display..

I guess...Using alv you can group....

try to see the out put of the above program...

Re: itab data display

abdul_hakim — Wed, 07 Dec 2005 06:55:57 GMT

use the below code.

LOOP AT itab1.

AT NEW fld1.

MOVE itab1-fld1 TO itab2-fld1.

ENDAT.

MOVE itab1-fld2 TO itab2-fld2.

APPEND itab2.

CLEAR itab2.

ENDLOOP.

Regards,

Abdul

Re: itab data display

Former Member — Wed, 07 Dec 2005 07:02:53 GMT

Hi Kaki,

1. This is one of the way.

2. First & Foremost is use

GRID - REUSE_ALV_GRID_DISPLAY

(and not alv list)

( bcos in alv list it is not showing what is required)

3. Then, declare these : (if not declared)

DATA : SRT TYPE SLIS_T_SORTINFO_ALV.

DATA : SRTWA TYPE SLIS_SORTINFO_ALV.

(The second one SRTWA is for word area)

4. Then write :

SRTWA-FIELDNAME = 'BUKRS'. "<---- your field name

APPEND SRTWA TO SRT.

5. Then Call ur Display function module.

6. Make sure you pass this parameter.

IT_SORT = SRT

7 I tried at my end. Its working fine.

Hope it helps.

Regards,

Amit M.

Re: itab data display

Former Member — Wed, 07 Dec 2005 07:03:11 GMT

Yes vijay,

Iam working on ALV.Thing is i have ALV with 5 fields.One them having very long text and occupying 4 lines for one document number.If i group document numbers, this long text lines are shuffling.

So iam trying to group at ITAB level.

kaki

Re: itab data display

athavanraja — Wed, 07 Dec 2005 07:08:22 GMT

Hi Kaki .,

When you post a question in the forum, provide all related info. in your original question you didnt mention about ALV at all.

Regards

Raja

Re: itab data display

Former Member — Wed, 07 Dec 2005 07:16:53 GMT

Move the itab1 fld1 one into itab1 fld1.

and use the following code

loop at itab1.

itab2-f1 = itab1-f1.

collect itab2." omits redundancy

endloop.

Regs

vijay

Re: itab data display

Former Member — Wed, 07 Dec 2005 07:45:18 GMT

Hi all

This is my logic.I want to get STEXT value only once into T_FINAL.

"at new" is not working here.

LOOP AT T_DET.

SNO = SNO + 1.

T_FINAL-SNO = SNO.

T_FINAL-QMNUM = T_DET-QMNUM.

T_FINAL-QMTXT = T_DET-QMTXT.

T_FINAL-COST = T_DET-COST.

AT NEW STEXT.

T_FINAL-STEXT = T_DET-STEXT.

ENDAT.

LOOP AT ITAB WHERE QMNUM = T_DET-QMNUM.

T_FINAL-DESC = ITAB-DESC.

APPEND T_FINAL.

CLEAR T_FINAL.

IF T_FINAL-SNO = '0'.

T_FINAL-SNO = ''.

ENDIF.

ENDLOOP.

kaki

Re: itab data display

Former Member — Wed, 07 Dec 2005 07:54:50 GMT

Hi,

It seems there are some type C fields before STEXT in your internal table that is why your AT NEW is not working.

You can also follow an alternate method as follows,

DATA: lv_stext LIKE t_det-stext.

and then in your logic, instead of AT NEW

use the following,

IF lv_stext NE t_det-stext.

lv_stext = t_det-stext.

t_final-stext = t_det-stext.

ENDIF.

so your revised logic will look as follows,

DATA: lv_stext LIKE t_det-stext.

LOOP AT T_DET.

SNO = SNO + 1.

T_FINAL-SNO = SNO.

T_FINAL-QMNUM = T_DET-QMNUM.

T_FINAL-QMTXT = T_DET-QMTXT.

T_FINAL-COST = T_DET-COST.

*AT NEW STEXT.

*T_FINAL-STEXT = T_DET-STEXT.

*ENDAT.

IF lv_stext NE t_det-stext.

lv_stext = t_det-stext.

t_final-stext = t_det-stext.

ENDIF.

LOOP AT ITAB WHERE QMNUM = T_DET-QMNUM.

T_FINAL-DESC = ITAB-DESC.

APPEND T_FINAL.

CLEAR T_FINAL.

IF T_FINAL-SNO = '0'.

T_FINAL-SNO = ''.

ENDIF.

ENDLOOP.

Hope this helps..

Sri

Message was edited by: Srikanth Pinnamaneni

Re: itab data display

Former Member — Wed, 07 Dec 2005 07:56:58 GMT

Kaki,

I am surprise why you have abandoned the previous thread posted for the same question and also the solutions were provided.

Regards,

Ravi

Re: itab data display

Former Member — Wed, 07 Dec 2005 08:07:20 GMT

Hi Ravi,

Thing is iam getting sorted data in the first column.But my long text column( which is having 4 lines for each doc.no) not getting sorted accordingly. It is shuffling.

Any way thanks for all the members..

Points allowted

cheers

kaki

Re: itab data display

Former Member — Wed, 07 Dec 2005 08:10:46 GMT

Kaki,

If you have 4 lines for each document, where each line is showing some text, then yes when the user sorts the the text will be jumbled. We don't have a choice here.

If its not important then SORT it using a pre-defined criteria and do NOT give the option of sorting to the user.

Or you can provide options in the SELECTION screen and program it so that sorting happens in that fashion. However we cannot give the user to sort after the report is displayed.

Regards,

Ravi

Re: itab data display

Former Member — Wed, 07 Dec 2005 08:24:44 GMT

Hi Ravi,

How to stop giving SORTING options in the ALV?I mean not to display on the tool bar.

kaki

Re: itab data display

Former Member — Wed, 07 Dec 2005 08:26:52 GMT

Hi Kaki,

Use EXCLUDE option ..

set-pf status 'STAT' excluding ex_tab.

pass the pf-status to the FM.

Re: itab data display

Former Member — Wed, 07 Dec 2005 08:29:43 GMT

Use

CALL FUNCTION 'REUSE_ALV_LIST_DISPLAY'
    EXPORTING
      I_CALLBACK_PROGRAM       = SY-REPID
<b>      I_CALLBACK_PF_STATUS_SET = 'PF_STATUS_SET'</b>
      I_CALLBACK_USER_COMMAND  = 'USER_COMMAND'
      IS_LAYOUT                = X_LAYOUT
      IT_FIELDCAT              = IT_FIELDCAT
      IT_EVENTS                = IT_EVENTS
    TABLES
      T_OUTTAB                 = IT_FINAL
    EXCEPTIONS
      PROGRAM_ERROR            = 1
      OTHERS                   = 2.
  IF SY-SUBRC <> 0.
    MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
            WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
  ENDIF.

FORM PF_STATUS_SET USING    P_EXTAB TYPE SLIS_T_EXTAB.
***append the sort fcodes and exclude them...
  SET PF-STATUS 'STANDARD' EXCLUDING P_EXTAB.
ENDFORM.                    "PF_STATUS_SET