geht das auch performanter:
- Code: [Select all] [Expand/Collapse] [Download] (Untitled.txt)
- SELECT mara~mandt mara~matnr mara~matkl marc~werks marc~bvkz marc~plkz mard~lgort mard~labst makt~maktx mbew~verpr mbew~salk3
- FROM mara
- INNER JOIN marc
- ON ( marc~mandt = mara~mandt
- AND marc~matnr = mara~matnr )
- INNER JOIN mard
- ON ( mard~mandt = mara~mandt
- AND mard~matnr = mara~matnr
- AND marc~werks = mard~werks )
- INNER JOIN makt
- ON ( makt~mandt = mara~mandt
- AND makt~matnr = mara~matnr
- AND makt~spras = sy-langu )
- INNER JOIN mbew
- ON ( mbew~mandt = mara~mandt
- AND mbew~matnr = mara~matnr
- AND mbew~bwkey = marc~werks )
- CLIENT SPECIFIED
- WHERE mara~mandt = iv_mandt
- AND mara~mtart EQ zweg_mtart-man
- AND mara~matnr IN ir_matnr
- AND mara~matkl IN ir_matkl
- AND mara~prdha IN ir_prdha
- AND marc~werks IN ir_werks.
- GeSHi ©
Vielen Dank für Tips
Mario