工作生活与爱好

 These FORMs are for people accustomed to
 REUSE_ALV_FIELDCATALOG_MERGE (despite the 72 ch source line limit)
 but not happy with  LVC_FIELDCATALOG_MERGE which has NO Internal
table option

We do not want to crowd DDIC with too many structures!

The routines handle any internal table using field name as title
if not a DDIC data element.

Create a Include ZJNCINCLUDE with the 2 FORMs

There are two FORMs:  ZJNC_DUMP_LIST will be very useful as it is
simple and needs no screen and can be called any number of times.

Should be very useful also for debugging esp. where Excel is not
available as you can dump any internal table anytime and inspect contents.

I wrote these routine mainly for debugging and the problem created by
half-line long comments in internal tables. With RTTI there is no source
code dependency.

ZJNC_DUMP_GRID is for OO-GRID loving people who can adapt that routine
for one off reports.
You can call this ONLY ONCE as it is best used using a dummy selection
screen - tip from SDN ABAP FAQ.

As FORMs use RTTI there is no special case for Structures!

-----------------------------------------------------------------------------------
*&---------------------------------------------------------------------*
*&  Include           ZJNCINCLUDE                                    
*
*&---------------------------------------------------------------------*

*&---------------------------------------------------------------------*
*&  Reincarnations of REUSE_ALV_FIELDCATALOG_MERGE
*&---------------------------------------------------------------------*

* Author Jayanta Narayan Choudhuri
*         Flat 302
*         395 Jodhpur Park
*         Kolkata 700 068
*       Email sss@cal.vsnl.net.in
*       URL:  http://www.geocities.com/ojnc

*-----------------------------------------------------------------------
* These FORMs are for people accustomed to
*   REUSE_ALV_FIELDCATALOG_MERGE (despite the 72 ch source line limit)
*   but not happy with  LVC_FIELDCATALOG_MERGE
* We do not want to crowd DDIC with too many structures!
*-----------------------------------------------------------------------

*&--------------------------------------------------------------------*
*&      Form  ZJNC_DUMP_LIST  Our Good Old ALV list -  RECOMMENDED!
*&--------------------------------------------------------------------*
FORM zjnc_dump_list  USING value(p_it_name) TYPE c
                          value(p_wa_name) TYPE c
                          value(p_heading) TYPE c.

 TYPE-POOLS: slis.

 DATA:
   stru_ref    TYPE REF TO cl_abap_structdescr,
   comp_tab    TYPE abap_compdescr_tab,
   one_comp    TYPE abap_compdescr,
   one_name    TYPE string,
   type_ref    TYPE REF TO cl_abap_typedescr,
   is_ddic     TYPE abap_bool,
   lt_ddic     TYPE dd_x031l_table,
   wa_ddic     TYPE x031l,
   lt_fcat     TYPE slis_t_fieldcat_alv,
   wa_fcat     TYPE slis_fieldcat_alv,
   ls_layo     TYPE slis_layout_alv,
   l_alv       TYPE REF TO cl_gui_alv_grid.

 FIELD-SYMBOLS:   TYPE ANY,
                 TYPE STANDARD TABLE,
                  TYPE ANY.

 ASSIGN (p_it_name) TO .

 ASSIGN (p_wa_name) TO .

 ls_layo-colwidth_optimize = 'X'.
 ls_layo-zebra = 'X'.
 ls_layo-window_titlebar = p_heading.
 ls_layo-box_tabname   = p_it_name.

 stru_ref ?= cl_abap_structdescr=>describe_by_data(  ).

 comp_tab = stru_ref->components.

 LOOP AT comp_tab INTO one_comp.
   CLEAR wa_fcat.
   wa_fcat-tabname   = p_it_name.
   wa_fcat-fieldname = one_comp-name.

   CONCATENATE p_wa_name '-' one_comp-name INTO one_name.

   ASSIGN (one_name) TO .

   type_ref ?= cl_abap_typedescr=>describe_by_data(  ).

   is_ddic = type_ref->is_ddic_type( ).

   IF is_ddic = abap_true.
     lt_ddic = type_ref->get_ddic_object( ).

     LOOP AT lt_ddic INTO wa_ddic.
       CLEAR wa_ddic-tabname.
       SELECT SINGLE
              dd03l~tabname
         INTO wa_ddic-tabname
         FROM dd03l
        WHERE dd03l~fieldname = wa_ddic-fieldname
          AND dd03l~tabname NOT LIKE '/%'.          " I live in normal
namespace


       wa_fcat-ref_tabname    = wa_ddic-tabname.
       wa_fcat-ref_fieldname = wa_ddic-fieldname.

       SELECT SINGLE
              dd04t~scrtext_s
              dd04t~scrtext_m
              dd04t~scrtext_l
         INTO (wa_fcat-seltext_s, wa_fcat-seltext_m,
wa_fcat-seltext_l)
         FROM dd04t
        WHERE dd04t~rollname   = wa_ddic-fieldname
          AND dd04t~ddlanguage = sy-langu.

     ENDLOOP.
   ELSE.
     MOVE one_comp-name TO: wa_fcat-seltext_s, wa_fcat-seltext_m,
wa_fcat-seltext_l.
   ENDIF.

   APPEND wa_fcat TO lt_fcat.

 ENDLOOP.

 CALL FUNCTION 'REUSE_ALV_LIST_DISPLAY'
   EXPORTING
     is_layout   = ls_layo
     it_fieldcat = lt_fcat
   TABLES
     t_outtab    = .

ENDFORM.                    "ZJNC_DUMP_LIST

*&--------------------------------------------------------------------*
*&      Form  ZJNC_DUMP_GRID  Object Oriented
*&--------------------------------------------------------------------*
FORM zjnc_dump_grid  USING value(p_it_name) TYPE c
                          value(p_wa_name) TYPE c
                          value(p_screen)  TYPE n
                          value(p_heading) TYPE c.

 DATA:
   stru_ref    TYPE REF TO cl_abap_structdescr,
   comp_tab    TYPE abap_compdescr_tab,
   one_comp    TYPE abap_compdescr,
   one_name    TYPE string,
   type_ref    TYPE REF TO cl_abap_typedescr,
   is_ddic     TYPE abap_bool,
   lt_ddic     TYPE dd_x031l_table,
   wa_ddic     TYPE x031l,
   lt_fcat     TYPE lvc_t_fcat,
   wa_fcat     TYPE lvc_s_fcat,
   ls_layo     TYPE lvc_s_layo,
   l_alv       TYPE REF TO cl_gui_alv_grid.

 FIELD-SYMBOLS:   TYPE ANY,
                 TYPE ANY TABLE,
                  TYPE ANY.

 ASSIGN (p_it_name) TO .

 ASSIGN (p_wa_name) TO .

 ls_layo-cwidth_opt = 'X'.
 ls_layo-zebra = 'X'.
 ls_layo-grid_title = p_heading.
 ls_layo-box_fname = p_it_name.

 stru_ref ?= cl_abap_structdescr=>describe_by_data(  ).

 comp_tab = stru_ref->components.

 LOOP AT comp_tab INTO one_comp.
   CLEAR wa_fcat.
   wa_fcat-tabname   = p_it_name.
   wa_fcat-fieldname = one_comp-name.

   CONCATENATE p_wa_name '-' one_comp-name INTO one_name.

   ASSIGN (one_name) TO .

   type_ref ?= cl_abap_typedescr=>describe_by_data(  ).

   is_ddic = type_ref->is_ddic_type( ).

   IF is_ddic = abap_true.
     lt_ddic = type_ref->get_ddic_object( ).

     LOOP AT lt_ddic INTO wa_ddic.
       CLEAR wa_ddic-tabname.
       SELECT SINGLE
              dd03l~tabname
         INTO wa_ddic-tabname
         FROM dd03l
        WHERE dd03l~fieldname = wa_ddic-fieldname
          AND dd03l~tabname NOT LIKE '/%'.          " I live in normal
namespace


       wa_fcat-ref_table = wa_ddic-tabname.
       wa_fcat-ref_field = wa_ddic-fieldname.

       SELECT SINGLE
              dd04t~scrtext_s
              dd04t~scrtext_m
              dd04t~scrtext_l
         INTO (wa_fcat-scrtext_s, wa_fcat-scrtext_m,
wa_fcat-scrtext_l)
         FROM dd04t
        WHERE dd04t~rollname   = wa_ddic-fieldname
          AND dd04t~ddlanguage = sy-langu.

     ENDLOOP.

   ELSE.
     MOVE one_comp-name TO: wa_fcat-scrtext_s, wa_fcat-scrtext_m,
wa_fcat-scrtext_l.
   ENDIF.

   APPEND wa_fcat TO lt_fcat.

 ENDLOOP.

 CREATE OBJECT l_alv EXPORTING i_parent = cl_gui_container=>screen0.

 CALL METHOD l_alv->set_table_for_first_display
   EXPORTING
     is_layout       = ls_layo
   CHANGING
     it_outtab       = 
     it_fieldcatalog = lt_fcat.

 CALL SELECTION-SCREEN p_screen.

ENDFORM.                    "ZJNC_DUMP_GRID

-----------------------------------------------------------------------------------
* SAMPLE TEST PROGRAM

REPORT yjnc1.

INCLUDE zjncinclude.

TYPES : BEGIN OF ty_pur,
         ebeln1  TYPE ekko-ebeln,
         aedat   TYPE ekko-aedat,
         ebelp   TYPE ekpo-ebelp,
         matnr   TYPE ekpo-matnr,
         txz01   TYPE ekpo-txz01,
         menge1  TYPE ekpo-menge,
         belnr1  TYPE ekbe-belnr,
         budat1  TYPE ekbe-budat,
         bwart   TYPE ekbe-bwart,
         menge2  TYPE ekbe-menge,
         belnr2  TYPE ekbz-belnr,
         budat2  TYPE ekbz-budat,
         menge3  TYPE ekbz-menge,
         dmbtr   TYPE ekbz-dmbtr,
         buzei   TYPE ekbz-buzei,
         jnc1    TYPE sy-datum,
         jnc2    TYPE i,
         jnc3(4) TYPE c,
       END OF ty_pur.

DATA: it_pur TYPE STANDARD TABLE OF ty_pur,
     wa_pur TYPE ty_pur,
     rows   TYPE i.

* Not Recommended Style but still used!
DATA: BEGIN OF it_mat OCCURS 0,
       jnc1    TYPE sy-datum,
       matnr   LIKE makt-matnr,
       jnc2    TYPE i,
       maktx   LIKE makt-maktx,
       mtart   TYPE mara-mtart,
       jnc3(4) TYPE c,
    END OF it_mat.

DATA: BEGIN OF it_str OCCURS 0.
       INCLUDE STRUCTURE makt.
DATA: END OF it_str.

SELECTION-SCREEN BEGIN OF SCREEN 1001.
SELECTION-SCREEN END   OF SCREEN 1001.

START-OF-SELECTION.

 MOVE     100 TO rows.

 SELECT ekko~ebeln
        ekko~aedat
        ekpo~ebelp
        ekpo~matnr
        ekpo~txz01
        ekpo~menge
        ekbe~belnr
        ekbe~budat
        ekbe~bwart
        ekbe~menge
        ekbz~belnr
        ekbz~budat
        ekbz~menge
        ekbz~dmbtr
        ekbz~buzei
   INTO TABLE it_pur
   UP TO rows ROWS
   FROM ekko
        INNER JOIN ekpo
        ON  ekko~ebeln = ekpo~ebeln
        AND ekpo~loekz = ' '
           INNER JOIN ekbe
           ON  ekpo~ebeln = ekbe~ebeln
           AND ekpo~ebelp = ekbe~ebelp
           AND ekbe~bewtp = 'E'
        LEFT OUTER JOIN ekbz
        ON  ekpo~ebeln = ekbz~ebeln
        AND ekpo~ebelp = ekbz~ebelp
        AND ekbz~bewtp = 'M'
  WHERE ekko~bstyp = 'F'
    AND ekko~loekz = ' '
  ORDER BY ekko~ebeln
           ekpo~ebelp.

 LOOP AT it_pur INTO wa_pur.
   COMPUTE wa_pur-jnc1 =  sy-datum - sy-tabix.
   MOVE sy-tabix TO wa_pur-jnc2.
   MOVE 'Helo'   TO wa_pur-jnc3.
   MODIFY it_pur FROM wa_pur.
 ENDLOOP.

* PERFORM zjnc_dump_grid  USING 'IT_PUR' 'WA_PUR' 1001 'Purchase
Report'.

* IT_PUR is as per recommended OO style
 PERFORM zjnc_dump_list  USING 'IT_PUR' 'WA_PUR' 'Purchase Dump'.

 SELECT makt~matnr
        makt~maktx
        mara~mtart
   INTO CORRESPONDING FIELDS OF TABLE it_mat
   UP TO rows ROWS
   FROM mara INNER JOIN makt
        ON makt~matnr = mara~matnr
        AND makt~spras = sy-langu.

 LOOP AT it_mat.
   COMPUTE it_mat-jnc1 =  sy-datum - sy-tabix.
   MOVE sy-tabix TO it_mat-jnc2.
   MOVE 'Helo'   TO it_mat-jnc3.
   MODIFY it_mat.
 ENDLOOP.


* PERFORM zjnc_dump_grid  USING 'IT_MAT[]' 'IT_MAT' 1001 'Material
Dump'.

* Note that IT_MAT with Header line is 2 in 1
* IT_MAT[] is the table object and IT_MAT is the header work area

 PERFORM zjnc_dump_list  USING 'IT_MAT[]' 'IT_MAT' 'Material Dump'.

 SELECT *
   INTO TABLE it_str
   UP TO rows ROWS
   FROM makt
  WHERE makt~spras = sy-langu.

* Note that IT_STR with Header line is 2 in 1
* IT_STR[] is the table object and IT_STR is the header work area
* As FORM zjnc_dump_list uses RTTI there is no special case for
Structures

 PERFORM zjnc_dump_list  USING 'IT_STR[]' 'IT_STR' 'Structure Dump'.

posted by lxy  # 08:53