topic Re: Joining table in Application Development and Automation Discussions

Joining table

Former Member — Thu, 21 May 2009 05:08:52 GMT

I needed to make a join with CATSDB- AWART TABLE field with T554T-AWART and SPRSL = SY-LANGU and MOABW = ?

There is another primary key in T554T table called MOABW how to join these table filed with catsdb

Regards

Sebastian John

Re: Joining table

Sandeep_Panghal — Thu, 21 May 2009 05:14:57 GMT

Select <fields>

into table <itab>

from catsdb as a inner join T554T as b

on a_{awart = b}awart

a_{MOABW = b}MOABW

where sprsl = sy-langu and

MOABW = ?

Re: Joining table

Former Member — Thu, 21 May 2009 05:27:36 GMT

Hi Sandeep,

There is no filed like MOABW in catsdb.

That is the problem ?

Regards

Sebastian

Re: Joining table

Sandeep_Panghal — Thu, 21 May 2009 05:31:46 GMT

Then you can put another join condition for T554S-MOABW and t554T-MOABW.

Re: Joining table

Former Member — Thu, 21 May 2009 05:33:13 GMT

Hi Sebastian,

When multiple SAP tables are logically joined, it is always advisable to use inner join to read the data from them. This certainly reduces the load on the network.

Hence we have

"catsdb as a inner join T554T as b "

since AWART exists in both the tables innerjoin would be perfect.

the syntax goes like this

Select <field1> <field1> <field1> <field1> ====> the fields u want to select

into table <itab> ====>name of the internal table

from catsdb as t1 inner join T554T as t2

on t1_{awart = t2}awart ~ indent denotes the mapping

t1_{MOABW = t2}MOABW

where sprsl = sy-langu and |

MOABW = ? | your select condition goes here

Hope this helps you,

Thanks and regards

Srikanth.P

Re: Joining table

Former Member — Mon, 25 May 2009 08:45:55 GMT

Thanks

Re: Joining table

Former Member — Wed, 29 Apr 2015 10:54:24 GMT

Hi Sebastian.

Did you find the solution for the above requirement.

If yes then pls provide me the solution.

I have got the same requirement.

thanks in advance.

Regards,

Obaid.