topic Re: select statement in Application Development and Automation Discussions

select statement

Former Member — Tue, 30 Oct 2007 12:07:39 GMT

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.

Re: select statement

andreas_mann3 — Tue, 30 Oct 2007 12:12:15 GMT

hi,

try this:

bkpf-awkey =

01-10 = belnr

11-14 = Bukrs

15-18 = Gjahr

Re: select statement

Former Member — Tue, 30 Oct 2007 12:13:39 GMT

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

Re: select statement

Former Member — Tue, 30 Oct 2007 12:14:10 GMT

Hi Hema,

small doubt..

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

Satish