Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
... You can see as example solution provided in Your system by SAP
include RM07MLBD_FORM_02...
Regards,
Alexey
| | | ---------------Original Message---------------
From: Ruediger Landig
Sent: Tuesday, August 30, 2011 4:03 AM
Subject: Performance problem (for all entries)
Dear friends
we have two productive systems using the same program for reading MSEG
with inner join and for all entries.
one is ok --> good performance
other -> run time double as before without (for all entries)
can it be that two many entries in internal table (>= 20.000)
internal table -> only material number
see coding
thank you
SELECT ms~mblnr ms~zeile ms~matnr mk~budat ms~menge ms~shkzg ms~meins
ms~bwart ms~werks ms~lgort ms~wempf ms~kunnr ms~kzvbr
*** Begin of Insertion O4008-151106-VC ***
ms~sobkz
*** End of Insertion O4008-151106-VC ***
ms~ebeln ms~ebelp mk~xblnr
INTO CORRESPONDING FIELDS OF TABLE l_salestab
FROM mseg AS ms INNER JOIN mkpf AS mk
ON ms~mblnr = mk~mblnr
AND ms~mjahr = mk~mjahr
FOR ALL ENTRIES IN iysop1
WHERE matnr = iysop1-matnr
AND ms~bwart IN so_bwart
AND ms~werks IN so_werks
AND mk~mjahr IN r_mjahr
AND ms~kunnr IN so_kunr3
AND mk~budat IN r_budat. |
| __.____._ Copyright © 2011 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
| | Popular White Papers
In the Spotlight View the "Managing the Application Life Cycle" webinar and learn how organizations optimize their SAP applications.  _.____.__ |
