Joining table

[Former Member]

Hi

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

[Sandeep_Panghal]

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 = ?

[Former Member]

Hi Sandeep,

There is no filed like MOABW in catsdb.

That is the problem ?

Regards

Sebastian

[Sandeep_Panghal]

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

[Former Member]

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

[Former Member]

Thanks

[Former Member]

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.