Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Hello all!
You can see many sap-notes about "Join MSEG MKPF performance".
In our production system (on Oracle RDBMS) we use hint "SUBSTITUTE_VALUES" for performance reason. In this case You can reduce impact of SAP WEB AS (anonymouse blocks without data). When You use this hint Oracle can user Optimizer Statistics Histograms.
But in other RDBMS may be other hints for this join.
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  _.____.__ |
