Skip to Content
0
Former Member
Jun 05, 2009 at 09:53 AM

offset

41 Views

hi all,

i need to fetch the data from database table using offset.

the select query is below.but the offset is not working.

please suggest do i need to change anything.

select SAP_OBJECT

OBJECT_ID

ARCHIV_ID

ARC_DOC_ID

AR_DATE

RESERVE

from toa

into table gt_toa

for all entries in gt_bkpf

where SAP_OBJECT eq 'BKPF'

AND OBJECT_ID+0(4) EQ gt_bkpf-bukrs

AND OBJECT_ID+4(14) EQ gt_bkpf-belnr

AND OBJECT_ID+14(8) EQ gt_bkpf-gjahr.

thanks in advance