Skip to Content
0
Former Member
Apr 20, 2010 at 01:07 AM

It's complicated

44 Views

Hello Experts,

I am currently working on something, and I need anyone's help. Here is what I am trying to do:

I am currently looking inside of table BCONT and retrieving all records that have CCLASS = 0015 and ACTIVITY = 0002.

My statement looks like this:

   select partner cclass activity ernam
        into table lit_bcont
        from bcont
        for all entries in tl_fkk_instpln_head
        where cclass = '0015' and activity = '0002' and 
              bcont~partner = tl_fkk_instpln_head-gpart. 

So far so good, now the problem is, that inside of TL_FKK_INSTPLN_HEAD, there is a field called RPNUM. This field does not exists in BCONT, but I really need it inside of LIT_BCONT for future operations.

Can anyone give me a tip or anything, that I can do to resolve this issue. I'm trying not to do any table linkages, but if that's the only way, then so be it.

Thanks.

Edited by: Rob Burbank on Apr 20, 2010 9:21 AM