Skip to Content
0
Former Member
Oct 24, 2011 at 06:57 AM

BSAD performance issue

91 Views

Hi,

I am using the below query to fetch data from bsad.

SELECT bukrs "Company code

kunnr "Customer

augbl "Clearing document

gjahr "Year

belnr "Accounting Document Number

monat " period

vbeln "Billing document no

prctr "Profit center

FROM bsad INTO TABLE git_bsad

FOR ALL ENTRIES IN git_fagl_val

WHERE bukrs EQ git_fagl_val-rbukrs AND

augbl EQ git_fagl_val-docnr.

'But this is too slow and takes more than 2 days to fetch data from basd.

Please suggest.

Regards,

Sudha