Skip to Content
0
Former Member
Oct 19, 2007 at 01:57 PM

Select Statement

30 Views

Hello Friends,

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)%.

ANy Suggestions,

Ster