Table maintenance

[Former Member]

Dear Friends,

i have to link following tables to the maintenance view.

my problem is i have to link one table for two fields like Cost center from and cost center to

so please guide me how can i achieve this?

Id	Label	                        Table	                Field	
1	Business Site   	        ZBC_APPRVRS_LIST	Z_BUSINESS_SITE
2	Description	                ZBC_BUSNS_SITES	        Z_BUS_SITE_DESC
3	Controlling Area	        ZBC_APPRVRS_LIST	KOKRS
4	Cost Center From	        ZBC_APPRVRS_LIST	Z_KOSTL_FROM
5	Description	                CSKS	                LTEXT
6	Cost Center To	                ZBC_APPRVRS_LIST	Z_KOSTL_TO
7	Description	                CSKS	                LTEXT
8	Second Level Approver	        ZBC_APPRVRS_LIST	Z_SECOND_APPROVER
9	Complete name	                ADRP	                NAME_TEXT
10	Third Level Approver	        ZBC_APPRVRS_LIST	Z_THIRD_APPROVER
11	Complete name	                ADRP	                NAME_TEXT

thanks in advance

[lijisusan_mathews]

if you have linked the tables using the keys, then you simply need to add the fields from the different tables? Whats the problem with having to get Cost center from and to ?

[Former Member]

Suzie,

i have linked 1st table with CSKS

but how can i select relevant description field.

[lijisusan_mathews]

Along with this you can again link the 1 st table to the description too. Did you try doing it ?

[Former Member]

yes friend,

but for the join conditions it takes only one field (from)

other field (to) is display as Relationships with unsuitable cardinality in relationship side.

[lijisusan_mathews]

Which is the case table you have used to link these tables?

And ZBC_APPRVRS_LIST contains both the from and to fields.. right ? and are they the fields to link it with the other tables?

Can you give me the keys of all these tables and the fields you are using to link these table respectively.

[Former Member]

Hi

assume we can user select statement like this

Select b_{Description c}Description

into (desc1,desc2)

from tbID as a on id1 =

inner join des1 as b on a_{id1 = b}id

inner join des1 as c on a_{id1 = c}id

is it possible to to do in maintenance view?

[lijisusan_mathews]

Hi.. first of all, i believe maintenance views create outer joins. Only database views create inner joins..

Second, if you are writing this to finally use it in select statements, you can perform select statements on database n projection views..

[Former Member]

Hi

no i wrote this to you for understand the situation.

[lijisusan_mathews]

ok.. did you try this way..

In se11 on creation of maintenance view.. first enter table A..

Then click relation ships and give table B.

Then select A and again give relationships and select C

Is this what you tried to do in Se11?

[Former Member]

Hi

table B and C are same table not deferent

[lijisusan_mathews]

if the table is same, and field is the same, y do you want different join conditions?

[koolspy_ultimate]

then use and to join .

Edited by: koolspy on Jul 25, 2011 1:11 PM

[Former Member]

Dear try to understand the situation

base table have two fields ID1 and ID2

text table(Description) have Fields ID & Description

i want to get descriptions for two IDs (ID1 & ID2)

so for ID1 description pass ID1 to text table ID and get description

for ID2 description pass ID2 to text table ID and get there description

i wanna know how can i do in maintenance view,

[kiran_k8]

Why don't you use EVENTS( 01 or 05 ) in Table maintenance generator and get the descriptions using select query

Thanks,

K.Kiran

[lijisusan_mathews]

Do you want to use maintenance view itself. Because what you are looking for can be achieved if you use a Database View. Do you want to be able to maintain the records? If not try database view.

[koolspy_ultimate]

HI,

please visit this link, it might be usefull to you [click here|http://www.youtube.com/watch?v=4Je5EsM-vAY]

[Former Member]

hi koolspy

this is youtube link

[koolspy_ultimate]

yes this shows you about maintenance view