Skip to Content
0
Former Member
Nov 08, 2005 at 02:57 AM

selection from bseg with year

40 Views

Hi,

Iam trying to use bsak-budat with bseg-gjahr.But lengths are not same. I had offsetting with budat.But values are not matching...could any one tell me how to do that?

points guaranteed

cheers

kaki

select BUKRS LIFNR AUGDT AUGBL GJAHR BELNR BUZEI BUDAT BLDAT

CPUDT WAERS BLART BSCHL SHKZG DMBTR WRBTR SGTXT HKONT SKFBT

from bsak

into corresponding fields of table t_bsak

where

lifnr in s_lifnr and

BUKRS in s_bukrs and

budat le s_budat and augdt in s_augdt.

loop at t_bsak.

l_year = t_bsak-budat(4).

endloop.

CHECK NOT t_bsak[] IS INITIAL.

select BUKRS LIFNR AUGDT AUGBL GJAHR BELNR

SHKZG DMBTR WRBTR SGTXT SKFBT KOSTL BSCHL HKONT BUZEI

into corresponding fields of table t_bseg from bseg

FOR ALL ENTRIES IN t_bsak

where belnr = t_bsak-belnr and

gjahr = l_year and " xxxxxx

bukrs = t_bsak-bukrs.