I am trying to use an offset in my select but it says the offset is the same length of the field. Basically what I want to do is remove the 1st 3 characters form the one field and have the last 3 be moved into the field. They are of different length but I thought the offset would take care of that. here is the code
LOOP AT DATA_PACKAGE.
INTO TABLE T_AZFIG
AC_DOC_NO = DATA_PACKAGE-AC_DOC_NO AND
DOC_ITEM = DATA_PACKAGE-ITEM_NUM+3(3).