topic Re: Dynamic ALV Internal table Problem in Application Development and Automation Discussions

Dynamic ALV Internal table Problem

Former Member — Fri, 06 Jun 2008 11:33:05 GMT

Hi all,I have successfully built an IT using method 'create_dynamic_table'.But my problems are :

1)When Iam trying to select the data with multiple tables then it is short dumping.

2)I tried to oselect the data using one table,after selecting the data if I use FM REUSE_ALV_Grid_Display then it is showing short dump with error 'type conflict when calling FM'.

I never used field symbols before.PLZ complete my program or give me suffecient feedback.Here is my program :


DATA : g_tdref TYPE REF TO data,
       g_wdref TYPE REF TO data.

DATA : dats LIKE vbbe-mbdat,
       t_fieldcat TYPE lvc_t_fcat,
       wa_fieldcat TYPE lvc_s_fcat.

FIELD-SYMBOLS : <it_dyn> TYPE STANDARD TABLE,
                <wa_dyn>,
                <dyn_field>.

SELECTION-SCREEN BEGIN OF BLOCK blk1 WITH FRAME TITLE text-001.
SELECT-OPTIONS : s_mbdat FOR dats.
SELECTION-SCREEN END OF BLOCK blk1.

wa_fieldcat-tabname = 'MSKA'.
wa_fieldcat-fieldname = 'WERKS'.
wa_fieldcat-datatype = 'CHAR'.
wa_fieldcat-intlen = '10'.

APPEND wa_fieldcat TO t_fieldcat.
CLEAR : wa_fieldcat.

wa_fieldcat-tabname = 'MSKA'.
wa_fieldcat-fieldname = 'MATNR'.
wa_fieldcat-datatype = 'CHAR'.
wa_fieldcat-seltext = 'Material Number'.
wa_fieldcat-intlen = '18'.

APPEND wa_fieldcat TO t_fieldcat.
CLEAR : wa_fieldcat.

wa_fieldcat-tabname = 'MAKT'.
wa_fieldcat-fieldname = 'MAKTX'.
wa_fieldcat-datatype = 'CHAR'.
wa_fieldcat-intlen = '10'.

APPEND wa_fieldcat TO t_fieldcat.
CLEAR : wa_fieldcat.

wa_fieldcat-tabname = 'VBBE'.
wa_fieldcat-fieldname = 'MBDAT'.
wa_fieldcat-datatype = 'CHAR'.
wa_fieldcat-intlen = '10'.

APPEND wa_fieldcat TO t_fieldcat.
CLEAR : wa_fieldcat.

wa_fieldcat-tabname = 'VBBE'.
wa_fieldcat-fieldname = 'OMENG'.
wa_fieldcat-datatype = 'QUAN'.
wa_fieldcat-intlen = '10'.

APPEND wa_fieldcat TO t_fieldcat.
CLEAR : wa_fieldcat.


DATA : d TYPE i,
       v(02) TYPE n VALUE '0',
       day(8) TYPE c.

d = s_mbdat-high - s_mbdat-low + 1.

DO d TIMES.

  v = v + 1.

  CONCATENATE 'Day' v INTO day.

  wa_fieldcat-tabname = 'VBBE'.
  wa_fieldcat-fieldname = day.
  wa_fieldcat-datatype = 'DATS'.
  wa_fieldcat-seltext = day.
  wa_fieldcat-intlen = '8'.

  APPEND wa_fieldcat TO t_fieldcat.
  CLEAR : wa_fieldcat.

ENDDO.
*-----Building Dynamic internal table.

CALL METHOD cl_alv_table_create=>create_dynamic_table
  EXPORTING
    it_fieldcatalog = t_fieldcat
  IMPORTING
    ep_table        = g_tdref.

ASSIGN g_tdref->* TO <it_dyn>.
CREATE DATA g_wdref LIKE LINE OF <it_dyn>.
ASSIGN g_wdref->* TO <wa_dyn>.

SELECT m~werks m~matnr v~omeng v~mbdat INTO CORRESPONDING FIELDS
OF TABLE <it_dyn> FROM mska AS m INNER JOIN vbbe AS v
ON m~posnr = v~posnr WHERE v~mbdat IN s_mbdat.

Re: Dynamic ALV Internal table Problem

raja_narayanan2 — Fri, 06 Jun 2008 12:25:56 GMT

*DATA : d TYPE i,

v(02) TYPE n VALUE '0',
day(8) TYPE c.

*d = s_mbdat-high - s_mbdat-low + 1.

*DO d TIMES.

v = v + 1.

CONCATENATE 'Day' v INTO day.

wa_fieldcat-tabname = 'VBBE'.
wa_fieldcat-fieldname = day.
wa_fieldcat-datatype = 'DATS'.
wa_fieldcat-seltext = day.
wa_fieldcat-intlen = '8'.

APPEND wa_fieldcat TO t_fieldcat.
CLEAR : wa_fieldcat.

*ENDDO.

*-----Building Dynamic internal table.

CALL METHOD cl_alv_table_create=>create_dynamic_table

EXPORTING

it_fieldcatalog = t_fieldcat

IMPORTING

ep_table = g_tdref.

ASSIGN g_tdref->* TO <it_dyn>.

CREATE DATA g_wdref LIKE LINE OF <it_dyn>.

ASSIGN g_wdref->* TO <wa_dyn>.

SELECT OMENG FROM VBBE INTO CORRESPONDING FIELDS OF TABLE <IT_DYN> WHERE MBDAT IN S_MBDAT.

BREAK-POINT.

YOU WILL GET VALUES IN INTERNAL TABLE.

TO SOLVE YOUR ISSUE YOU SHOULD USE NUM INSTEAD OF DATS.

Re: Dynamic ALV Internal table Problem

Former Member — Sun, 08 Jun 2008 05:29:17 GMT

Thanks for u r reply,I will try and let u know that worked or not.

As Iam new to this Dynamic ALV what should I do now to complete the code?

I never used field symbols b4 and searched SDN but I got all examples with field symbols.Can anyone PLZ complete the code or give me a CLEAR example to complete it.

Thanks.

Re: Dynamic ALV Internal table Problem

uwe_schieferstein — Sun, 08 Jun 2008 21:04:37 GMT

Hello

Class cl_alv_table_create is out-dated and you should use the RTTI instead (if already available on your system).

For a sample report have a look at [Creating Flat and Complex Internal Tables Dynamically using RTTI|https://wiki.sdn.sap.com/wiki/display/Snippets/CreatingFlatandComplexInternalTablesDynamicallyusingRTTI]

Final remark: if you are using dynamic itabs for selection you should use a dynamic WHERE clause as well.

Regards

Uwe