Can we design an ALV report in this format?

[Former Member]

Hi All,

Is it possible to design an ALV report in this format?

_________________

Amount (INR)

|----

---

Debit

Credit

-

---

If u oberve here, therez one column which has got two sub columns........while the most of the other columns dont have sub columns......

Message was edited by: Sushma Anuprava

Message was edited by: Sushma Anuprava

[Former Member]

i don't think it is possible...

it becomes a hierachical list,

u can get only using fn module

reuse_alv_hier_seq_display,

[dani_mn]

Hi,

use this.

<b>'REUSE_ALV_HIERSEQ_LIST_DISPLAY'</b>

Regards,

Wasim Ahmed

[Former Member]

Hi Wasim......Thank you for the answer but can u give me an excerpt of the code which includes this function module.....?

[Former Member]

Here is a example <b>BALVHD01</b>.

Regards,

Ravi

Note : Please mark all the helpful answers

[former_member188685]

Hi,

yes But with lot of formattings you have to do to get the output like that ...

Check the Following code.

REPORT  ZTEST_ALV_CHECK     message-id zz  .


TYPE-POOLS: SLIS.
DATA: X_FIELDCAT TYPE SLIS_FIELDCAT_ALV,
      IT_FIELDCAT TYPE SLIS_T_FIELDCAT_ALV,
      L_LAYOUT type slis_layout_alv,
      x_events type slis_alv_event,
      it_events type SLIS_T_EVENT.

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 20 ROWS
       INTO TABLE ITAB.


X_FIELDCAT-FIELDNAME = 'VBELN'.
X_FIELDCAT-SELTEXT_L = 'VBELN'.
X_FIELDCAT-TABNAME = 'ITAB'.
X_FIELDCAT-COL_POS = 1.
APPEND X_FIELDCAT TO IT_FIELDCAT.
CLEAR X_FIELDCAT.

X_FIELDCAT-FIELDNAME = 'POSNR'.
X_FIELDCAT-SELTEXT_L = 'POSNR'.
X_FIELDCAT-TABNAME = 'ITAB'.
X_FIELDCAT-COL_POS = 2.
APPEND X_FIELDCAT TO IT_FIELDCAT.
CLEAR X_FIELDCAT.
X_FIELDCAT-FIELDNAME = 'MALE'.
X_FIELDCAT-SELTEXT_L = 'MALE'.
X_FIELDCAT-TABNAME = 'ITAB'.
X_FIELDCAT-COL_POS = 3.
APPEND X_FIELDCAT TO IT_FIELDCAT.
CLEAR X_FIELDCAT.
X_FIELDCAT-FIELDNAME = 'FEMALE'.
X_FIELDCAT-SELTEXT_L = 'FEMALE'.
X_FIELDCAT-TABNAME = 'ITAB'.
X_FIELDCAT-COL_POS = 3.
APPEND X_FIELDCAT TO IT_FIELDCAT.
CLEAR X_FIELDCAT.
  x_events-NAME = SLIS_EV_TOP_OF_PAGE.
  x_events-FORM = 'TOP_OF_PAGE'.
  APPEND x_events  TO iT_EVENTS.
  CLEAR x_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.
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 TOP_OF_PAGE.

*-To display the headers for main list
    FORMAT COLOR COL_HEADING.
        WRITE: / SY-ULINE(103).
    WRITE: /   SY-VLINE,
          (8) ' ' ,
               SY-VLINE,
          (8)  ' ' ,
               SY-VLINE,
          (19) 'SEX'(015) centered,
               sy-vline.

    WRITE: /   SY-VLINE,
          (8) 'VBELN'(013) ,
               SY-VLINE,
          (8) 'POSNR'(014) ,
               SY-VLINE,
          (8) 'MALE'(016) ,
               sy-vline,
           (8)  'FMALE'(017) ,
               sy-vline.

    FORMAT COLOR OFF.

ENDFORM.

look at SNAP shot also..

http://img100.imageshack.us/img100/3846/output6ef.th.gif

Regards

vijay

[McF]

Don't think so.

But maybe you should consider using an ALV Tree or Column Tree to cluster Information.

Regards,

Michael