topic Re: inner join in Application Development and Automation Discussions

inner join

Former Member — Tue, 19 Sep 2006 20:48:36 GMT

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

Re: inner join

Former Member — Tue, 19 Sep 2006 21:34:15 GMT

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

Re: inner join

Former Member — Tue, 19 Sep 2006 21:38:29 GMT

Hi Nithin,

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

Regards,

Azaz Ali.

Re: inner join

Former Member — Tue, 19 Sep 2006 22:54:37 GMT

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

Re: inner join

Former Member — Wed, 20 Sep 2006 00:23:35 GMT

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

Re: inner join

Former Member — Wed, 20 Sep 2006 14:12:57 GMT

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

Re: inner join

ferry_lianto — Wed, 20 Sep 2006 20:54:25 GMT

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.

Re: inner join

former_member770121 — Mon, 19 Sep 2022 06:25:53 GMT

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 .

Re: inner join

matt — Mon, 19 Sep 2022 09:49:19 GMT

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