topic Re: Table maintenance in Application Development and Automation Discussions

Table maintenance

Former Member — Mon, 25 Jul 2011 03:09:28 GMT

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

Re: Table maintenance

lijisusan_mathews — Mon, 25 Jul 2011 04:07:03 GMT

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 ?

Re: Table maintenance

Former Member — Mon, 25 Jul 2011 04:21:53 GMT

Suzie,

i have linked 1st table with CSKS

but how can i select relevant description field.

Re: Table maintenance

lijisusan_mathews — Mon, 25 Jul 2011 04:33:32 GMT

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

Re: Table maintenance

Former Member — Mon, 25 Jul 2011 04:58:21 GMT

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.

Re: Table maintenance

lijisusan_mathews — Mon, 25 Jul 2011 05:20:49 GMT

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.

Re: Table maintenance

koolspy_ultimate — Mon, 25 Jul 2011 05:39:09 GMT

HI,

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

Re: Table maintenance

Former Member — Mon, 25 Jul 2011 05:45:41 GMT

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?

Re: Table maintenance

Former Member — Mon, 25 Jul 2011 06:00:56 GMT

hi koolspy

this is youtube link

Re: Table maintenance

koolspy_ultimate — Mon, 25 Jul 2011 06:13:56 GMT

yes this shows you about maintenance view

Re: Table maintenance

lijisusan_mathews — Mon, 25 Jul 2011 06:15:25 GMT

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..

Re: Table maintenance

Former Member — Mon, 25 Jul 2011 06:20:11 GMT

no i wrote this to you for understand the situation.

Re: Table maintenance

lijisusan_mathews — Mon, 25 Jul 2011 06:43:48 GMT

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?

Re: Table maintenance

Former Member — Mon, 25 Jul 2011 07:05:50 GMT

table B and C are same table not deferent

Re: Table maintenance

lijisusan_mathews — Mon, 25 Jul 2011 07:30:46 GMT

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

Re: Table maintenance

koolspy_ultimate — Mon, 25 Jul 2011 07:41:25 GMT

then use and to join .

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

Re: Table maintenance

Former Member — Mon, 25 Jul 2011 08:26:56 GMT

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,

Re: Table maintenance

kiran_k8 — Mon, 25 Jul 2011 12:54:24 GMT

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

Thanks,

K.Kiran

Re: Table maintenance

lijisusan_mathews — Tue, 26 Jul 2011 04:42:12 GMT

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.