2007 Jan 05 4:58 AM
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
2007 Jan 05 10:53 AM
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
2007 Jan 05 9:42 AM
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
2007 Jan 05 10:53 AM
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
| User | Count |
|---|---|
| 3 | |
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |