Service order lookup in BSEG

[former_member1207446]

Hello

I am trying to look up postings for a service order in table BSEG. Using service order (BSEG-AUFNR) is however very bad from performance perspective, it takes several minutes to look up the service order.

Is there any way to reduce the response time of this query? I have tried to look for links between the service order and entries in table BKPF, but without success.

BR,

OT

[jogeswararao_kavala]

What query . Tcode you are talking about?

[former_member1207446]

Im doing the lookup in SE16. But also in SQVI/SQ01 query, the response time is extremely slow for the table BSEG.

[jogeswararao_kavala]

Please try by providing some of the values for these key fields (in addition to AUFNR):

BUKRS

BELNR

GJAHR

BUZEI

[former_member1207446]

Ok thanks but the problem is that we will only have the service order number and the company code when doing the lookup

[jogeswararao_kavala]

I meant one or more from those fields alongwith AUFNR.

BUKRS alongwith AUFNR should have improved the Response time.

...and I'm afraid there will not be other ways to quicken that, if other fields can not be filled. Not only these fields any other field which you can fill in the Selection screen will quicken the processing.

[jogeswararao_kavala]

Because BSEG can not be used in joins (in SQVI or SQ02) the idea of quickening the report by joining another table like AUFK also becomes invalid.