Skip to Content
0
Former Member
May 18, 2009 at 09:50 AM

Function module for BSEG table

1417 Views

Hi Guru's,

SELECT bukrs

belnr

gjahr

budat

monat

waers

awkey

FROM bkpf

INTO TABLE i_bkpf_data

WHERE bukrs EQ pa_bukrs AND

budat IN so_budat.

SORT i_bkpf_data BY bukrs belnr gjahr.

IF i_bkpf_data[] IS NOT INITIAL.

SELECT bukrs belnr gjahr koart dmbtr wrbtr pswsl

kokrs kostl hkont aufnr lifnr ebeln buzei shkzg

FROM bseg

INTO TABLE i_bseg_data

FOR ALL ENTRIES IN i_bkpf_data

WHERE

bukrs EQ pa_bukrs AND

belnr EQ i_bkpf_data-belnr AND

gjahr EQ i_bkpf_data-gjahr AND

kostl IN so_kostl AND

lifnr IN so_lifnr AND

hkont IN so_hkont.

ENDIF.

I got performance issue on this Query..while accessing the data from BSEG table,its makes performance issue in my program so i want to improve performance of the program.i was analysed that BSEG table makes performance issue..

Hi..Anybody give the solution imporving this Query or give some function module for accessing BSEG table..

Note..I want to pass my selection inputs also into function module..i was seen some function module for BSEG,those are not satisfying the my inputs so those also making performance issue..

Regards

P.Senthil Kumar