Skip to Content
0
Former Member
Oct 13, 2006 at 05:34 AM

select for all entries

31 Views

hi all,

in the following code select for all entries

why we r checking that

if not ITAB_BSIS[] is initial.

what does it mean? what is its necessicity

plz give me solution

SELECT

bukrs

hkont

augdt

augbl

zuonr

gjahr

belnr

buzei

budat

bldat

WAERS

xblnr

blart

shkzg

dmbtr

wrbtr

sgtxt

aufnr

kostl

dmbe2

prctr

zztitle

zzterr

FROM bsis

into table ITAB_BSIS "Declare an Internal table with

"all above selected fields

WHERE bukrs IN so_bukrs

AND hkont = so_hkont

AND augdt = so_augdt

AND gjahr = so_gjahr

AND belnr = so_belnr

AND budat = so_budat

AND blart = so_blart

AND xblnr = so_xblnr

AND bldat = so_bldat

AND zztitle = so_title

AND zzterr = so_terr

AND kostl = so_kostl

AND prctr = so_prctr

AND aufnr = so_aufnr.

if not ITAB_BSIS[] is initial.

select BUKRS BELNR GJAHR bvorg bstat waers hwaer hwae2 cpudt

from bkpf

into table ITAB_BKPF "Declare an Internal table with

"all above selected fields

for all entries in ITAB_BSIS

where bukrs = ITAB_BSIS-bukrs

and belnr = ITAB_BSIS-belnr

and gjahr = ITAB_BSIS-gjahr

AND cpudt = so_cpudt

AND bvorg = so_bvorg.

endif.

thanks & regards

sanjeev