Performanter Material-Select

[Thilo2934]

Hallo,
geht das auch performanter:

Code: [Select all] [Expand/Collapse] [Download] (Untitled.txt)

1. SELECT mara~mandt mara~matnr mara~matkl marc~werks marc~bvkz marc~plkz mard~lgort mard~labst makt~maktx mbew~verpr mbew~salk3
2.     FROM mara
3.     INNER JOIN marc
4.       ON ( marc~mandt = mara~mandt
5.      AND   marc~matnr = mara~matnr )
6.     INNER JOIN mard
7.       ON ( mard~mandt = mara~mandt
8.      AND   mard~matnr = mara~matnr
9.      AND   marc~werks = mard~werks )
10.     INNER JOIN makt
11.       ON ( makt~mandt = mara~mandt
12.      AND   makt~matnr = mara~matnr
13.      AND   makt~spras = sy-langu )
14.     INNER JOIN mbew
15.       ON ( mbew~mandt = mara~mandt
16.      AND   mbew~matnr = mara~matnr
17.      AND   mbew~bwkey = marc~werks )
18.     CLIENT SPECIFIED
19.     INTO CORRESPONDING FIELDS OF TABLE <fs_current_state_tab>
20.     WHERE mara~mandt = iv_mandt
21.       AND mara~mtart EQ zweg_mtart-man
22.       AND mara~matnr IN ir_matnr
23.       AND mara~matkl IN ir_matkl
24.       AND mara~prdha IN ir_prdha
25.       AND marc~werks IN ir_werks.
26.  

GeSHi ©

Vielen Dank für Tips
Mario