RESB Performance

Former Member — Wed, 02 May 2007 09:55:00 GMT

hi.

i hv retrive the fields stlnr, rsnum, posnr, rsnum, rspos , matnr, werks , stlnr ,

from resb table by passing wempf and aufnr . but this makes report performance very slow.

pl. tel me any alternative table for this

Re: RESB Performance

Former Member — Wed, 02 May 2007 09:59:09 GMT

you need to pass all the key fields in the where condition

wempf and aufnr are non key fields

Message was edited by:

Chandrasekhar Jagarlamudi

Re: RESB Performance

Former Member — Wed, 02 May 2007 10:03:46 GMT

Hi,

Try Hit the RESB table with the primary keys or the secondary indexes/ try to get the secondary field values by some other table

try to use FM " MD_STOCK_REQUIREMENTS_LIST_API"

Hope this may help you

reward if useful

regards,

nazeer

Re: RESB Performance

former_member223446 — Wed, 02 May 2007 10:08:39 GMT

you need to pass the all key fields in where condition .when u write the select statement better to use INTO CORRESPONDING FIELDS OF TABLE ITB.the itab should contains all the field what ever you want retrieve.better use se30 or st05 for performance issue.And also check what are the fields u have to pass ,those are key fields or not.

if helpful rewards the points.

kiran

Re: RESB Performance

Former Member — Sat, 08 Dec 2007 04:25:38 GMT

hi shuba rao

I have found below metione note hope u find helpful

reward point if found the answer

RSXADR01 runs for a long time if RESB has many entries

SAP Note Number: 340066

Symptom

The RSXADR01 or RSXADR05 or RSXADR02 XPRA report runs for a very long time if the RESB table contains many entries.

Other terms

RSXADR01

BAS_XPRA

Reason and Prerequisites

It has been known for installations to have more than 10 million entries in the RESB table.

If the RSXADR05 report was already ran as a preliminary step prior to the upgrade, selection on the RESB will then run completely as records in the RESB cannot be marked as already processed by the preliminary step report.

The RSXADR01 XPRA is always listed in the upgrade logs.

The RSXADR01 report calls the RSXADR02, RSXADR03 and RSXADR05 reports internally (using SUBMIT ... AND RETURN).

Solution

If expert analysis shows that there are no records in the RESB with address number RESB-ADRNR <> SPACE, you can skip selection on the RESB table by modifying the XPRA report and thus, in extreme cases, save several hours of runtime.

As this analysis can only occur for a runtime-intensive selection which may ultimately produce an opposite result, you cannot execute this analysis automatically.

The place where this modification occurs depends on the release available as well as the notes already implemented.

As of 4.6C Service Release 1, the modification specified in the attached correction instructions 332828 apply.

For a target release lower than 4.6C SR1, there are additional dependencies which require further modifications.

To prevent errors, the modifications required for releases dlower that 4.6C SR1 are not expressly listed here, but can be provided after analysis by SAP support.

The ZZ_RESB_COUNT analysis report, which you use (irrespective of the target release) to detect whether there are conversion-relevant addresses in the RESB table, is attached to this note.

The procedure for modifying the RSXADR05 report at the correct time (directly before the XPRA phase) is described in note 421233.

Header Data

Release Status Released for Customer

Released on 27.07.2004

Priority Correction with medium priority

Category Upgrade information

Primary Component BC-SRV-ADR Address Management / Business Address Services

Release

Soft. Component Release Track From Release To Release And Successors

SAP_APPL 30 300 31I

SAP_APPL 40 40A 40B

SAP_APPL 45 45A 45B

SAP_APPL 46 46A 46B

SAP_APPL 46C 46C 46C

SAP_APPL 470 470 470

Correction Instructions

Correction Instruction Valid from Valid to Installation Soft. Component ID

Ref. Correction Modification Status Last Changed on

0000211426 300 470 0120061532 SAP_APPL 1

X Released 31.10.2002 10:06:56

0000332828 46C 470 0120061532 SAP_APPL 1

X Released 31.10.2002 10:07:56

Support Packages

No Support Packages available

Related notes

Number Short Text

0000421233 Most current version of the report RSXADR05

0000390062 Additional information about upgrading to 4.6C SR2

0000327285 Additions to upgrade to 4.6C SR1

0000313589 RSXADR05 takes long time selecting MPOS, QMIH, EQUZ or AFIH

Attributes

No attributes available

Attachments

No attachments available

Reason - Side Effects

SAP Notes / Patches corrected by this Note

reward point if found the answer

topic Re: RESB Performance in Application Development and Automation Discussions

RESB Performance

Re: RESB Performance

Re: RESB Performance

Re: RESB Performance

Re: RESB Performance