Dynamically select with inner table

Former Member — Mon, 28 Jul 2014 07:22:37 GMT

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).

Re: Dynamically select with inner table

Former Member — Mon, 28 Jul 2014 07:41:11 GMT

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.

topic Dynamically select with inner table in Application Development and Automation Discussions

Dynamically select with inner table

Re: Dynamically select with inner table