RESB table - reduce returned data

[#1]

Hi

I just want a simple query to show me a network number if a WBS is entered and vice versa.

The table I am using is RESB

Fields that return the correct data are:

PEPEL - WBS

AUFNR - order

I have included also the plant and storage location as we have 5 plants and 5 storage locations in our system.

When i run the query, I get multiple lines returned.

How can i speed up the results returned?

I am not interested in any other data, just the network and WBS

Please help

Thanks

[Former Member · Accepted solution]

Try to use the secondary Index Table first(for missing parts FTIND) and then RESB.

add these in where Condition

XLOEK EQ ' '

KZEAR EQ 'X'

Edited by: Sunil Reddy on Sep 2, 2008 5:38 PM

[former_member198492]

.

[former_member198492]

I managed to find the right table

AUFK

Both WBS and Network are in this table.

Many thanks for all of your help

Darren

[Former Member]

to speed up the data set the index based on your requirements

to do that go to SE11 and eneter the table RESB

check the index from menu

I think the SAP defualt index is on

MATNR

WERKS

XLOEK

KZEAR

BDTER

If you want for WBS you have to ask Basis to create the index for your req.

To avoid the duplicate record- if table join is there than do outer join otherwise you have find certain field which restrict your output list based on the requirements