I am having some problem in this select statement and
I dont want to use Loop..Endloop.
I have to extract from COBRB table based on OBJNR and am using for all entries on T_COSS table.
I want to extract everything from COBRB where the first 12 characters of OBJNR are in same as T_COSS-PAROB.
Here is the select statement I am using and its not working.
SELECT * FROM COBRB APPENDING TABLE T_COBRB FOR ALL ENTRIES IN T_COSS WHERE OBJNR = T_COSS-PAROB+0(12)%.