topic Re: Selection from different tables in Application Development and Automation Discussions

Selection from different tables

Former Member — Thu, 08 May 2014 03:35:58 GMT

Hello Everyone,

I have a situation where I have 15 fields in the selection screen.

The selection is dependent on three or more tables.

First I have selected from two tables but if the user enters values in the selection screen then how to make the selection.

Tables dont have common fields between them. LIKP, LIPS, VTTK, VBUK and VEKP are the tables.

Can you guys guide me.

Thank you.

Re: Selection from different tables

Former Member — Thu, 08 May 2014 03:38:36 GMT

Hi,

if those fields having primary key we can you use inner join or for all entries.

Regards,

Raman

Re: Selection from different tables

VijayaKrishnaG — Thu, 08 May 2014 03:49:57 GMT

Hi Vinod,


 First I have selected from two tables but if the user enters values in the selection screen then how to make the selection.

Your query is not so clear. When are you fetching the data from two table whether before selection screen input (Initialization event) or after selection screen?

Can you please elaborate your query and better if you post your Selection Screen screen-shot.

Regards,

VIjay

Re: Selection from different tables

Former Member — Thu, 08 May 2014 03:52:26 GMT

Hi Vinod,

LIKP and LIPS are Delivery Header and item table and common field is VBELN.

VTTK is shipment header table and its key field is TKNUM; you will find "Z_TRANSPORTNO" in LIKP.

VBUK: VBELN can link with LIKP.

VEKP: Key field is VENUM, but not able to get link with any of the 4 table; please ask functional fellow for this; how to link this table.

Thanks,

Dharmishta

Re: Selection from different tables

Former Member — Thu, 08 May 2014 04:03:00 GMT

Hello Dharmishta,

Thanks for the reply.

But I don't find a field 'Z_TRANSPOTRNO' in LIKP.

Can you please let me know the correct field.

Thank you.

Re: Selection from different tables

Former Member — Thu, 08 May 2014 04:05:41 GMT

Hello Vijaykrishna,

I need to link LIKP, LIPS, VTTK, VTTP, VBUK and VEKP table for getting the values based on the selection screen.

I have linked LIKP, LIPS and VBUK using vbeln as the field using Inner Join.

I would like to know how to link VTTK,VTTP and VEKP with LIKP table to get the values.

Thank you for your reply.

Re: Selection from different tables

Former Member — Thu, 08 May 2014 04:20:34 GMT

Also if the user doesn't enter any value in the selection screen for shipment number it should select only from LIKP and shouldn't say "No inputs available".

Re: Selection from different tables

Former Member — Thu, 08 May 2014 04:41:36 GMT

Hi,

TERNR[ Order numebr] is in LIKP and VTTK, please check, if you can use this field to join these two tables.

Thanks,

Dharmishta

Re: Selection from different tables

Former Member — Thu, 08 May 2014 04:58:55 GMT

Hello Dharmishta,

TERNR cannot be used for linking both table.

Re: Selection from different tables

Former Member — Thu, 08 May 2014 05:09:51 GMT

Everyone,

Also i'm having a problem when using Inner Joins between LIKP and VTTP.

If 8 records are selected in LIKP and if only two records has shipment then only two records are being selected even though the user has not entered any shipment numbers in the selection-screen.

Re: Selection from different tables

Former Member — Thu, 08 May 2014 05:51:00 GMT

Hi,

what are common field for likp and VVTP???

Regards,

raman

Re: Selection from different tables

Former Member — Thu, 08 May 2014 07:02:21 GMT

LIKP-VBELN = VTTP-VBELN,

also check the table VTFA-Shipment Document Flow

Re: Selection from different tables

Former Member — Thu, 08 May 2014 08:27:27 GMT

Hi,

I hope that this is a good example

SELECT k~tknum h~vbeln .........

    FROM vttk AS k
    JOIN vttp AS p
      ON k~tknum = p~tknum
    JOIN likp AS h
      ON h~vbeln = p~vbeln

..............

Re: Selection from different tables

Former Member — Fri, 23 May 2014 07:03:55 GMT

I have resolved the problem by myself.

Thank you so much guys for the feedback.

Re: Selection from different tables

VijayaKrishnaG — Fri, 23 May 2014 07:10:26 GMT

Hi Vinod,

Please share the solution or procedure how the issue got resolved by yourself. It can help others.

Regards,

Vijay

Re: Selection from different tables

Former Member — Thu, 29 May 2014 06:49:53 GMT

Hello Everyone,

Since I had to get entries from different tables.

First I did the inner join on LIKP, LIPS and VBUK.

Then I took each entry and check in other tables.

If the entry doesnt exist in the other table, then I deleted it from the main table.

By this I was able to get the entries based on different tables.