Select problem in BKPF

[Former Member]

Hi,

I have written the following Select Query .I got one record in IT_BKPF1 but the awkey field in Internal Table IT_BKPF1 is Blank. can u help me.

SELECT bukrs

belnr

gjahr

blart

bldat

budat

cpudt

usnam

bvorg

xblnr

bstat

awtyp

awkey

INTO TABLE it_bkpf1

FROM bkpf

WHERE awkey = '51056012492007 '.

Regards,

Deepthi.

[Former Member]

make sure that Internal Table BKPF has the same structure.

bukrs

belnr

gjahr

blart

bldat

budat

cpudt

usnam

bvorg

xblnr

bstat

awtyp

awkey

the way you are selecting.

[Former Member]

Yes, it has got the same structure...

[Former Member]

check the declaration for that internal table. it should match with ur select query field order

[Former Member]

use INTO CORRESPONDING FIELDS OF TABLE it_bkpf1

[Former Member]

The field in the internal table should be in the same ORDER and of same TYPE.

Please verify.

Thanks,

Amol

[Former Member]

I have commented bstat field from selection as it has got some deep strcture.

SELECT bukrs

belnr

gjahr

blart

bldat

budat

cpudt

usnam

bvorg

xblnr

• bstat

awtyp

awkey

INTO TABLE it_bkpf1

FROM bkpf

FOR ALL ENTRIES IN it_ekbe

WHERE

awkey = it_ekbe-awkey.

[ThomasZloch]

BSTAT a deep structure?

Better include AWTYP in the where-condition, or we will see you in the performance forum soon.

Thomas