topic Re: Issue while creating Maintenance view joining 2 tables in Application Development and Automation Discussions

Issue while creating Maintenance view joining 2 tables

Former Member — Tue, 16 Dec 2014 15:08:00 GMT

Hello ABAP Gurus ,

I have a requirement wherein I need to Update two tables using a single maintenance view.

Now the Tables :

1. TE530

2. ZTJPY

Now in order to connect two while creating Maintenance View I have established a Foreign Key relation between them , please refer the below screen.

So I have used same key to connect them i.e LINESORT and in table ZTJPY connected to TE530 using FK relationship.

Now I created a view using both ,

Now here comes the issue , in SM30 I am able to change the value for fields belonging to ZTJPY only and not the values of fields belonging to TE530 though all fields are showing editable.

Please share your views ...

Re: Issue while creating Maintenance view joining 2 tables

Former Member — Tue, 16 Dec 2014 16:08:28 GMT

hi sijin

I don't think it is possible to change values of standard tables. you have to use transaction or coding only to update or insert or delete it.

Re: Issue while creating Maintenance view joining 2 tables

Former Member — Tue, 16 Dec 2014 16:13:28 GMT

I'm not sure, but I think you can only modify one table in a maintenance view - the primary table.

Rob

Re: Issue while creating Maintenance view joining 2 tables

Former Member — Wed, 17 Dec 2014 02:34:00 GMT

Hi Sijin

The TMG will generate a screen, right? So go to SE51 to change that screen, make those fields 'INPUT' able. Just try, i`m not sure.

regards,

Archer

Re: Issue while creating Maintenance view joining 2 tables

Former Member — Wed, 17 Dec 2014 04:18:54 GMT

Yeah this is the way system is behaving.

I am just finding a standard document on this so that I can present it to my team and justify this.

Re: Issue while creating Maintenance view joining 2 tables

Former Member — Wed, 17 Dec 2014 04:20:47 GMT

All fields are input able that is the main issue , I mean even the fields ( fields belonging to TE530 table ) for which change is not allowed is also appearing as editable.

Re: Issue while creating Maintenance view joining 2 tables

Former Member — Wed, 17 Dec 2014 04:22:22 GMT

 transaction or coding only to update or insert or delete it.

Cannot be considered as options reason being I need to provide this as a node in SPRO path as a customization node and for that View can be used only.

Re: Issue while creating Maintenance view joining 2 tables

Former Member — Wed, 17 Dec 2014 04:51:59 GMT

Okay ,

I got the SAP Link supporting this ,

Now the second option left is View Cluster , I haven't used it yet.

And in my scenario there is nothing like a Header table or Item table ,

Both table are in same level / hierarchy .

Any clues on using View Cluster for this scenario

Re: Issue while creating Maintenance view joining 2 tables

Former Member — Wed, 17 Dec 2014 05:40:01 GMT

View Cluster certainly can use two views with out hierarchy relationship, then it will no link between this two table, only the foreign key check.

I`m curious about why you create a individual Z table(this Ztable is not text table), not enhance TE530, append a structure to it.

Then you only need create a maintenance view.

regards,

Archer

Re: Issue while creating Maintenance view joining 2 tables

Former Member — Wed, 17 Dec 2014 05:48:11 GMT

Yeah you are correct on this note ,

is Ztable is not text table), not enhance TE530, append a structure to it

Appending structure to it , is the solution which was earlier provided but later it was scraped.

TE530 is a config table for Sorting Billing Line items and the additional 2 columns which I need to add to this table provide completely different functionality yet both are linked also.

So my Team lead doesn't want to hinder the standard TE530 and they want a Single view also which will update both simultaneously.

I guess Cluster View is the only work around , so gonna study it.

Re: Issue while creating Maintenance view joining 2 tables

Former Member — Wed, 17 Dec 2014 07:09:53 GMT

Got it solved with the help of my senior

The issue was of Cardinality earlier it was blank,

After maintaining it , its updating both table,

I have seen 2 - 3 threads regarding this in SCN ( unanswered ) and the above Standard document of SAP made me strongly conclude that this is not possible . But my senior made me

Its working like a Charm.

Re: Issue while creating Maintenance view joining 2 tables

Former Member — Wed, 17 Dec 2014 09:07:50 GMT

Thanks for sharing the solution. hats off.