select statement

[Former Member]

can anyone please help me

In the select statement i have to fetch zuonr field from the table RBKP.

Where this needs to be compared with bkpf-awkey value with rbkp-belnr and fetch zuonr field. but bkpf-awkey field length is 14 digits and rbkp-belnr field length is 10 digits.

so i have to use offset in select statement,

can anyone help me how to use offset in select statement.

please urgent.

thanks in advance.

[Former Member]

Hi Hema,

small doubt..

when BELNR is available in BKPF why do you want to compare with awkey?

Satish

[andreas_mann3]

hi,

try this:

bkpf-awkey =

01-10 = belnr

11-14 = Bukrs

15-18 = Gjahr

A.

[Former Member]

SELECT *

FROM BKPF

into TABLE tb_bkpf

where <some condition>.

Select *

from RBKP

INTO TABLE tb_RBKp

FOR ALL ENTRIES in tb_bkpf

where belnr = tb_bkpf-awkey+0(10).

Regards

Nishant

[Former Member]

Hi Hema,

small doubt..

when BELNR is available in BKPF why do you want to compare with awkey?

Satish