2009 Dec 21 10:51 AM
Hello,
How can I make view of following tables?
tnro table
tnrot table
cus_actobj
tnro-object = tnrot-object
and tnro-code = cus_actobj-tcode
I am able to join 2 table tnro and tnrot. But how can i join tnro-code with cus_actobj-tcode???
2009 Dec 21 11:05 AM
Hi
Join tables tnro and tnrot using field named object into internal table ITAB.
For all entries of ITAB fetch the data from cus_actobj where tcode equal to ITAB-code.
Regards
Srilaxmi
2009 Dec 21 11:33 AM
I am not sure how the data is organised in these tables.
But if you are just looking for creating a view with inner join, here is my suggestion.
Integrity of the data has to be checked by yourself
Since you need a inner join, you should create a Database view.
The join conditions should be
TNRO-OBJECT = TNROT-OBJECT
TNRO-CODE = CUS_ACTOBJ-TCODE
TNRO-OBJECT = CUS_ACTOBJ-SUBOBJNAME
Best Regards,
Manjunadh.
2009 Dec 21 11:36 AM
Hi,
In SE11 under create database view, Table/Join Conditions tab mention all the 3 tables TNRO, TNROT and CUS_ACTOBJ in TABLEs column.
And in Join Condtion area, mention like below.
table field table field
TNRO OBJECT = TNROT OBJECT
TNRO CODE = CUS_ACTOBJ TCODE
And in View Fields mention the required fields as per you requirement. and activate the view.
2009 Dec 28 5:22 AM
Hi Ravendra,
But I am not able to join the cus_actobj table
2009 Dec 28 11:17 AM
Hi sgrshah,
would you kindly explain what you want?
CUS_ACTOBJ Customizing Activity - Object List TNRO Definition of number range objects TNROT Text for number range object
I do not know what the tables shall have in common.
Regards,
Clemens
2009 Dec 28 11:28 AM
tcode are common in all three tables.
2009 Dec 28 7:24 PM
common is not the same.
Bluesky
