topic Re: about offset question in Application Development and Automation Discussions

about offset question

Former Member — Thu, 12 Jul 2007 03:27:09 GMT

in the table NAST there is a field named OBJKY

I want to use it in the table LIPS. but in the table LIPS there are two key fields.

if I want to select one line in the table LIPS, I need to know the two fields.

But in the table NAST, the field OBJKY contains the two fields together.e.g

in the NAST , the data of the field OBJKY :0080000002000010

but in the LIPS , the VBELN is 0080000002, the POSNR is 000010

so how can I slip the OBJKY to two fields?

select single VBELN POSNR

from LIPS

where VBELN = NAST-OBJKY(10)

and POSNR = NAST-OBJKY(11)+6.

I don't know if it is correct. So I need all you help

Thanks in advance

Nick

Re: about offset question

former_member196280 — Thu, 12 Jul 2007 03:30:46 GMT

Do it like this.

Decalre two variables... for example char1 and char2.

char1 = NAST-OBJKY+0(10).

char2 = NAST-OBJKY+10(6).

select single VBELN POSNR

from LIPS

where VBELN = char1

and POSNR = char2.

Reward points!!

Regards,

SaiRam

Re: about offset question

Former Member — Thu, 12 Jul 2007 03:31:00 GMT

Hi Nick,

Check if it works,

select single VBELN POSNR

from LIPS

where VBELN = NAST-OBJKY+0(10)

and POSNR = NAST-OBJKY+10(6).

But the best option is create another Internal table with two fields VBELN and POSNR and move OBJKY to these fields and use that internal table to query LIPS.

Reward points if useful.

Regards,

Atish

Re: about offset question

Former Member — Thu, 12 Jul 2007 03:31:35 GMT

data : v_vbeln like likp-vbeln,

v_posnr like likp-posnr.

v_vbeln = nast-objky+0(9).

v_posnr = nast-objky+10(6).

select single VBELN POSNR

from LIPS

where VBELN = v_vbeln

and POSNR = v_posnr.

Thanks

Seshu

Re: about offset question

Former Member — Thu, 12 Jul 2007 03:33:00 GMT

data : v_vbeln(11),

v_posnr(7).

concatenate NAST-OBJKY(10) '%' into v_vbeln.

concatenate NAST-OBJKY+10(6) '%' into v_posnr.

select single VBELN POSNR

from LIPS

where VBELN like v_vbeln

and POSNR like v_posnr.

regards

shiba dutta

Re: about offset question

gopi_narendra — Thu, 12 Jul 2007 03:33:05 GMT

select single VBELN POSNR
from LIPS
where VBELN = NAST-OBJKY(10)
and POSNR = NAST-OBJKY+10(6).

Regards

Gopi