Dynamically select with inner table

[Former Member]

Hi experts,

I would like to select dynamically data from 9 tables and I tried to do it like below.

But there is problem with lv_from_group because there is more then 255 characters. Can you tell me any other option and say if it is correctly written?

   DATA: lv_sel_list(1000)    TYPE          c,

         lv_from_group(1000)  TYPE          c,

         lv_where_group(1000) TYPE          c.

   lv_from_group  = '/dbm/vbak_db     AS a ' &

    'INNER JOIN   /dbm/vbpa        AS b ON a~vbeln EQ b~vbeln' & "1

    'INNER JOIN   /dbm/vbap        AS c ON a~vbeln EQ c~vbeln' & "2

   'INNER JOIN   kna1             AS d ON a~kunnr EQ d~kunnr' & "3

   'INNER JOIN   vlcvehicle       AS e ON a~vguid EQ e~vguid' & "4

   'INNER JOIN   /dbm/splhdr_db   AS f ON a~vbeln EQ f~vbeln '& "5

   'INNER JOIN   MAKT             AS g ON c~MATNR EQ g~MATNR' & "6

   'INNER JOIN   /dbm/v_model     AS h ON e~vguid EQ h~MODEL_GUID'   & "7  KLUCZ DO SPRAWDZENIA

   'INNER JOIN   zaida_model      AS i ON e~vguid EQ i~product_guid' & "8  KLUCZ DO SPRAWDZENIA

    'INNER JOIN   dbm_v_imodel     AS j On i~product_guid eq j~product_guid' . "9

   lv_sel_list    = 'a~vbeln a~vguid a~audat a~werks b~kunnr c~itcat c~matnr d~kukla d~pstlz d~ort01' &

   'e~vhvin e~immatdate f~aufart g~maktx h~mcatalog h~mcodesd i~zz0017 j~cubic_cap j~bodtype '.

*  lv_where_group = ''.

   SELECT (lv_sel_list)

     FROM (lv_from_group)

     INTO CORRESPONDING FIELDS OF TABLE ct_all_data.

*    WHERE (lv_where_group).

[Former Member]

Hello Krzysztof,

sustitute for this:

CONCATENATE '/dbm/vbak_db     AS a '

   'INNER JOIN   /dbm/vbpa        AS b ON a~vbeln EQ b~vbeln'
   'INNER JOIN   /dbm/vbap        AS c ON a~vbeln EQ c~vbeln'
   'INNER JOIN   kna1             AS d ON a~kunnr EQ d~kunnr'
   'INNER JOIN   vlcvehicle       AS e ON a~vguid EQ e~vguid'
   'INNER JOIN   /dbm/splhdr_db   AS f ON a~vbeln EQ f~vbeln '
   'INNER JOIN   MAKT             AS g ON c~MATNR EQ g~MATNR'
   'INNER JOIN   /dbm/v_model     AS h ON e~vguid EQ h~MODEL_GUID'  
   'INNER JOIN   zaida_model      AS i ON e~vguid EQ i~product_guid'
   'INNER JOIN   dbm_v_imodel     AS j On i~product_guid eq j~product_guid' 

INTO LV_FROM_GROUP SEPARATED BY SPACE.

I hope you help.