Skip to Content

Hierarchical report

Hi

While downloading into excell it is not able o convert into proper cells

suppose

Jan feb march

100 200 this is SAP report but when I download into excell it is comming as below

Jan feb march

100 200

so on

please help me resolve this issue

Thanks in advance

Joseph

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Nov 09, 2007 at 10:03 AM

    Hello,

    you can do like this.

    CONSTANTS: CON_TAB TYPE X VALUE '09'.
      LOOP AT G_T_OUTTAB.
        CLEAR: L_F_NETPR_VE,L_F_NETPR_UM, L_F_ERDAT_VE, L_F_ERDAT_UM,
               L_F_PLAN,L_F_IST,L_F_OBLIGO.
        WRITE: G_T_OUTTAB-NETPR_VE TO L_F_NETPR_VE,
               G_T_OUTTAB-NETPR_UM TO L_F_NETPR_UM,
               G_T_OUTTAB-ERDAT_VE TO L_F_ERDAT_VE,
               G_T_OUTTAB-ERDAT_UM TO L_F_ERDAT_UM,
               G_T_OUTTAB-PLAN TO L_F_PLAN,
               G_T_OUTTAB-IST TO L_F_IST,
               G_T_OUTTAB-OBLIGO TO L_F_OBLIGO,
               G_T_OUTTAB-WIP TO L_F_WIP,
               SY-DATUM TO L_F_DATUM.
        CONCATENATE G_T_OUTTAB-PRATX G_T_OUTTAB-POSID G_T_OUTTAB-POST1
                    G_T_OUTTAB-WWGBE G_T_OUTTAB-WWGFE G_T_OUTTAB-VERNA
                    G_T_OUTTAB-STTXT_INT G_T_OUTTAB-STTXT_EXT
                    L_F_NETPR_VE L_F_ERDAT_VE L_F_NETPR_UM L_F_ERDAT_UM
                    L_F_PLAN L_F_IST L_F_OBLIGO L_F_WIP G_T_OUTTAB-VBELN_VE
                    G_T_OUTTAB-VBELN_UM L_F_DATUM
                    INTO LR_TAB SEPARATED BY CON_TAB.
        APPEND LR_TAB TO LT_TAB.
      ENDLOOP.
    

    Regards,

    Vasanth

    Add comment
    10|10000 characters needed characters exceeded