Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

ALV GRID

Former Member
0 Likes
473

HI

Please let me know how to group few coloumns under one coloumn in alv grid.

Note : It is not a hierarical report.

thanx

arun

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
445

hi

i think ur requiremnet is as foloows

sales order no | creation date | nationality

-


indian | muslim

if this is ur requirement use my following code and one thing if u use alv grid u cant get above heading use alv_llist_method.

REPORT ZMAHI_HEADING LINE-SIZE 50..

TYPE-POOLS: SLIS.

DATA: X_FIELDCAT TYPE SLIS_FIELDCAT_ALV,

IT_FIELDCAT TYPE SLIS_T_FIELDCAT_ALV,

L_LAYOUT TYPE SLIS_LAYOUT_ALV,

IT_EVENTS TYPE SLIS_T_EVENT WITH HEADER LINE.

DATA: BEGIN OF ITAB OCCURS 0,

VBELN LIKE VBAK-VBELN,

POSNR LIKE VBAP-POSNR,

MALE TYPE I,

FEMALE TYPE I,

END OF ITAB.

SELECT VBELN POSNR FROM VBAP UP TO 10 ROWS INTO TABLE ITAB.

X_FIELDCAT-FIELDNAME = 'VBELN'.

X_FIELDCAT-TABNAME = 'ITAB'.

X_FIELDCAT-COL_POS = 1.

X_FIELDCAT-HOTSPOT = 'X'.

X_FIELDCAT-OUTPUTLEN = 10 .

APPEND X_FIELDCAT TO IT_FIELDCAT.

CLEAR X_FIELDCAT.

X_FIELDCAT-FIELDNAME = 'POSNR'.

X_FIELDCAT-TABNAME = 'ITAB'.

X_FIELDCAT-COL_POS = 2."1.

APPEND X_FIELDCAT TO IT_FIELDCAT.

CLEAR X_FIELDCAT.

X_FIELDCAT-FIELDNAME = 'MALE'.

X_FIELDCAT-OUTPUTLEN = 14 .

X_FIELDCAT-TABNAME = 'ITAB'.

X_FIELDCAT-COL_POS = 3.

APPEND X_FIELDCAT TO IT_FIELDCAT.

CLEAR X_FIELDCAT.

X_FIELDCAT-FIELDNAME = 'FEMALE'.

X_FIELDCAT-OUTPUTLEN = 15 .

X_FIELDCAT-TABNAME = 'ITAB'.

X_FIELDCAT-COL_POS = 3.

APPEND X_FIELDCAT TO IT_FIELDCAT.

CLEAR X_FIELDCAT.

IT_EVENTS-NAME = 'TOP_OF_PAGE'."SLIS_EV_TOP_OF_PAGE.

IT_EVENTS-FORM = 'TOP_OF_PAGE'.

APPEND IT_EVENTS.

CLEAR IT_EVENTS .

L_LAYOUT-NO_COLHEAD = 'X'.

CALL FUNCTION 'REUSE_ALV_LIST_DISPLAY'

EXPORTING

I_CALLBACK_PROGRAM = SY-REPID

IS_LAYOUT = L_LAYOUT

IT_FIELDCAT = IT_FIELDCAT

IT_EVENTS = IT_EVENTS[]

TABLES

T_OUTTAB = ITAB

EXCEPTIONS

PROGRAM_ERROR = 1

OTHERS = 2.

&----


*& Form TOP_OF_PAGE

&----


FORM TOP_OF_PAGE.

*-To display the headers for main list

FORMAT COLOR COL_HEADING.

WRITE: / SY-ULINE(54).

WRITE: / SY-VLINE,

(8) 'SALES',

SY-VLINE,

(8) 'LINE'(021),

SY-VLINE,

(28) 'NATIONALITY' CENTERED,

SY-VLINE.

WRITE: / SY-VLINE,

(8) 'ORDER', "'PLANE'(053) ,

SY-VLINE,

(8) 'ITEM'(056) ,

SY-VLINE,

(12) 'INDIAN'(070) ,

SY-VLINE,

(13) 'MUSLIM'(077) ,

SY-VLINE.

FORMAT COLOR OFF.

ENDFORM. "TOP_OF_PAGE

thanks,

maheedhar.t

HI

Please let me know how to group few coloumns under one coloumn in alv grid.

Note : It is not a hierarical report.

thanx

arun

2 REPLIES 2
Read only

Former Member
0 Likes
445

Hi Arun,

Check this pdf. you got details about multiple columns & rows.

<b>http://www.abap4.it/download/ALV.pdf</b>

Maybe it will be useful to you.

Reward points if it is useful.

All the best!

Gokul

Read only

Former Member
0 Likes
446

hi

i think ur requiremnet is as foloows

sales order no | creation date | nationality

-


indian | muslim

if this is ur requirement use my following code and one thing if u use alv grid u cant get above heading use alv_llist_method.

REPORT ZMAHI_HEADING LINE-SIZE 50..

TYPE-POOLS: SLIS.

DATA: X_FIELDCAT TYPE SLIS_FIELDCAT_ALV,

IT_FIELDCAT TYPE SLIS_T_FIELDCAT_ALV,

L_LAYOUT TYPE SLIS_LAYOUT_ALV,

IT_EVENTS TYPE SLIS_T_EVENT WITH HEADER LINE.

DATA: BEGIN OF ITAB OCCURS 0,

VBELN LIKE VBAK-VBELN,

POSNR LIKE VBAP-POSNR,

MALE TYPE I,

FEMALE TYPE I,

END OF ITAB.

SELECT VBELN POSNR FROM VBAP UP TO 10 ROWS INTO TABLE ITAB.

X_FIELDCAT-FIELDNAME = 'VBELN'.

X_FIELDCAT-TABNAME = 'ITAB'.

X_FIELDCAT-COL_POS = 1.

X_FIELDCAT-HOTSPOT = 'X'.

X_FIELDCAT-OUTPUTLEN = 10 .

APPEND X_FIELDCAT TO IT_FIELDCAT.

CLEAR X_FIELDCAT.

X_FIELDCAT-FIELDNAME = 'POSNR'.

X_FIELDCAT-TABNAME = 'ITAB'.

X_FIELDCAT-COL_POS = 2."1.

APPEND X_FIELDCAT TO IT_FIELDCAT.

CLEAR X_FIELDCAT.

X_FIELDCAT-FIELDNAME = 'MALE'.

X_FIELDCAT-OUTPUTLEN = 14 .

X_FIELDCAT-TABNAME = 'ITAB'.

X_FIELDCAT-COL_POS = 3.

APPEND X_FIELDCAT TO IT_FIELDCAT.

CLEAR X_FIELDCAT.

X_FIELDCAT-FIELDNAME = 'FEMALE'.

X_FIELDCAT-OUTPUTLEN = 15 .

X_FIELDCAT-TABNAME = 'ITAB'.

X_FIELDCAT-COL_POS = 3.

APPEND X_FIELDCAT TO IT_FIELDCAT.

CLEAR X_FIELDCAT.

IT_EVENTS-NAME = 'TOP_OF_PAGE'."SLIS_EV_TOP_OF_PAGE.

IT_EVENTS-FORM = 'TOP_OF_PAGE'.

APPEND IT_EVENTS.

CLEAR IT_EVENTS .

L_LAYOUT-NO_COLHEAD = 'X'.

CALL FUNCTION 'REUSE_ALV_LIST_DISPLAY'

EXPORTING

I_CALLBACK_PROGRAM = SY-REPID

IS_LAYOUT = L_LAYOUT

IT_FIELDCAT = IT_FIELDCAT

IT_EVENTS = IT_EVENTS[]

TABLES

T_OUTTAB = ITAB

EXCEPTIONS

PROGRAM_ERROR = 1

OTHERS = 2.

&----


*& Form TOP_OF_PAGE

&----


FORM TOP_OF_PAGE.

*-To display the headers for main list

FORMAT COLOR COL_HEADING.

WRITE: / SY-ULINE(54).

WRITE: / SY-VLINE,

(8) 'SALES',

SY-VLINE,

(8) 'LINE'(021),

SY-VLINE,

(28) 'NATIONALITY' CENTERED,

SY-VLINE.

WRITE: / SY-VLINE,

(8) 'ORDER', "'PLANE'(053) ,

SY-VLINE,

(8) 'ITEM'(056) ,

SY-VLINE,

(12) 'INDIAN'(070) ,

SY-VLINE,

(13) 'MUSLIM'(077) ,

SY-VLINE.

FORMAT COLOR OFF.

ENDFORM. "TOP_OF_PAGE

thanks,

maheedhar.t