Skip to Content
0
Former Member
Jul 12, 2007 at 03:27 AM

about offset question

162 Views

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