Classical report

[Former Member]

Dear all,

input matnr & vkorg & kunnr .

i have an internal table content

matnr maktx kunnr value

1 a 10 20

1 a 20 30

1 a 30 40

1 a 40 50

2 b 10 15

at the maximum kunnr have 5 values only

i want to know how to design the output like below

matnr maktx kunnr1 value kunnr2 value kunnr3 value

10 20 30

1 a 20 30 40

2 b 10 15

<b>note : is it possible in alv also if so how.</b>

[Former Member]

Hi Balaji ,

If this is the format in which you want the output , then you will have to create an internal table with the structure same as the output you want and then pass this to the ALV or print it in the classical report.

Do revert back in case of any further queries.

Regards

Arun

[Former Member]

hi,

tell me exactly in which format u want the output..so that i can try ..

[Former Member]

Balaji,

Take one more final internal table which is having records like your structure.

at last move all the records to final internal table.

Pl.s mark if useful

[Former Member]

ITAB1[] = ITAB[].

SUPPOSE ITEMP CONTAINS THE FINAL DATA.

LOOP AT ITAB.

LOOP AT ITAB1 WHERE MATNR = ITAB-MATNR.

IF SY-TABIX = 1.

ITABTEMP-KUNNR1 = ITAB1-KUNNR.

ITABTEMP-VALUE1 = ITAB1-VALUE.

ELSEIF SY-TABIX = 2.

ITABTEMP-KUNNR1 = ITAB1-KUNNR.

ITABTEMP-VALUE1 = ITAB1-VALUE.

ELSEIF <UPTO SY-TABIX = 5>

ENDIF.

AT LAST.

APPEND ITABTEMP.

ENDAT.

ENDLOOP.

ENDLOOP.

REGARDS

SHIBA DUTTA