Skip to Content
0
Former Member
Mar 11, 2009 at 09:47 AM

Select condition of 9 last character

19 Views

I have 2 database table ITAB1 and ITAB2 who both have GL account value SAKNR

ITAB1         ITAB2
0123456789    0123456789 
0111111111    A123456789
	      B111111111	

i must be able to retreive all data from ITAB2 (even the one which begin with A)

i have a select condtion as follows

SELECT SAKNR from ITAB1
into GT_ITAB1
condition xxxxx.

SELECT SAKNR FROM ITAB2
INTO GT_ITAB2
FOR ALL ENTRIES ITAB1
WHERE SAKNR EQ GT_ITAB1+1(9)
*   I must also all the functionality internal table T001-BUKRS