Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Performace of resb table

Dear All,

I have one Performance issue , my problem is the query given below

Takes much more time than Expected were i retreive data from resb table only by passing EBELN and WERKS .I am using key fields also still my performance is not increased so tell me how to increase performance .

SELECT rsnum

rspos

rsart

werks

baugr

ebeln

matnr

bdmng

enmng

lifnr

ebelp

ebele

INTO CORRESPONDING FIELDS OF TABLE it_disp

FROM resb

WHERE rsnum NE 0

AND rspos NE ''

  • AND rsart = rsart

AND werks = p_werks

AND ebeln = p_ebeln .

Thanks And Regards .

Deepak Dhamat .

Not what you were looking for? View more on this topic or Ask a question