Skip to Content
0
Former Member
May 30, 2008 at 08:16 AM

alv report

18 Views

hi gurus,

i am create a report using alv by bseg and bkpf but the programm gives dump on used this query

SELECT bukrs

belnr

gjahr

buzei

augdt

shkzg

dmbtr

kostl

hkont

matnr

werks

erfmg

INTO TABLE lt_output

FROM bseg

WHERE bukrs IN s_bukrs.

IF sy-subrc = 0.

SORT lt_output BY belnr.

DELETE ADJACENT DUPLICATES FROM lt_output COMPARING ALL FIELDS.

ENDIF.

IF NOT lt_output[] IS INITIAL.

SELECT bukrs

belnr

gjahr

blart

bldat

budat

monat

cpudt

usnam

tcode

bktxt

waers

awtyp

awkey

INTO TABLE lt_bkpf FROM bkpf

FOR ALL ENTRIES IN lt_output

WHERE bukrs = lt_output-bukrs AND

belnr = lt_output-belnr AND

gjahr = lt_output-gjahr AND

blart IN s_blart AND

budat IN s_budat ."AND

  • blart = 'SA' OR

  • blart = 'SB' OR

  • blart = 'AB' OR

  • blart = 'ZC'.

it gives dump me after using the blart = 'SB' OR

blart = 'AB' OR

blart = 'ZC .

IF I USE blart = 'SA'.

it is work fine but not work if i use both 'SA" or 'SB'.

plz help me its urgent

thanks