inner join

[Former Member]

Hello experts,

I am trying to join ausp, likp and lips.I have common field lips and likp as vbeln.How can i join ausp lips or likp.

I have selection field and ouput field with characteristic value.

Please advice me.

Thanks

[Former Member]

HI Nithin,

i am not sure that u can use innerjoin to relate Ausp and lips..

with select statements we can do by using another table in between.

like select objek from ausp into xxx where atinn = 'UR CHARACTERISTIC'.

loop at xxx.

select objek from INOB into yyy where cuobj = xxx-atinn.

endloop.

yyy-objek is a combination of matnr + charg ( batch)

so yyy-objek+0(18) gives u matnr.

u have a field in lips matnr... so u can do rest of the things with lips and likp where lips-vbeln = likp-vbeln.

hope it helps...

if it is not ur requirement then let me knwo with some more details...

Regards

[Former Member]

Hi srinu,

Thanks for ur reply.i tried but I am getting errors.Can you please explain me clearly.Is there any other alternative.

Thanks

[Former Member]

Hi Nithin,

We can not join the ausp,lips and likp tables.

Regards,

Azaz Ali.

[Former Member]

Nitin,

Please give some more details as to why are you going to AUSP. Do you know which value from LIKP/LIPS ties to AUSP?

Murali

[Former Member]

Hi Murali,

I have Selection screen with ausp-atwrt,lips-werks,likp-vstel,etc.

Output fields are lips-matnr,lips-lfimg,

ausp-atwrt,likp-lgort,likp-wadat_ist.

I need to get output I am trying to join lips likp ausp

Please suggest me.

Thanks

[ferry_lianto]

Hi Nithin,

Please try to link table LIPS with MCHA in order to go to table AUSP.

  select cuobj_bm into (mcha-cuobj_bm)
  from mcha
  where matnr = lips-matnr
    and werks = lips-werks
    and charg = lips-charg.
  endselect.

  if sy-subrc = 0.
    select atinn atwrt into table i_ausp
    from ausp
    where objek = mcha-cuobj_bm.
  endif.

Hope this will give you an idea.

Regards,

Ferry Lianto

Please reward points if helpful.

[former_member770121]

Is there any possibility except join of any type ???

we just want to add the field of AUSP table on selection screen it is my requirement but with LIPS and LIKP table join is not possible ??

is there will be any way /logic to add on selection screen of AUSP table field on selection screen???

kindly recommend any solution this is urgent

thank u in advance .

[matt]

You should post your own question. Also, what is urgent for you is urgent for absolutely no one else.