Issue while creating Maintenance view joining 2 tables

[Former Member]

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

[Former Member]

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.

[Former Member]

 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.

[Former Member]

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

Rob

[Former Member]

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.

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

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.

[Former Member]

Thanks for sharing the solution. hats off.