2006 Jun 09 3:46 PM
I have ran in to a strange problem.
I have function group which has been used for 90 tables in table maitenance.
Now all the 90 tables are in dev and its working fine i.e table maintenance.
when i moved few tables out of 90 into QAS and tried to do table maintenance for those tables ,it throws an error message saying that.
The dictionary structure or table zid is either not active or does not exist.
this table does not exist in qas as we have decided not to move as we don't need that table.
I always create new function group for each table maintenance but i am appointed as a replacement in here,the guy who used to work before me used same function for all tables.
I never faced this kind of problem
is there a way to fix this problem. please let me know its very important for me.
Thanks in advance
Swathi
2006 Jun 09 3:54 PM
>>>is there a way to fix this problem
One option is to change the function group in DEV ie remove the table maintenance dialogs that are not in QAS & re-transport the function group.
Regards,
Suresh Datti
2006 Jun 09 3:59 PM
can you little bit more clear please
You said re transport the function group what do you mean by that . can you be little bit clear on this.
Thanks in advance
2006 Jun 09 3:57 PM
Swathi
Why dont you transport the existing Function group to QA, as its using in all table already . So I dont think you need to re-invent the wheel. Create new function group for every table and send it over QA. Transport the existing one to QA. It should work.
Hope thisll give you idea!!
<b>P.S award the points.</b>
Good luck
Thanks
Saquib Khan
"Some are wise and some are otherwise"
2006 Jun 09 4:08 PM
Hi saquib Khan,
I think u misunderstood my problem . i have tables say z1, z2 ,z3 --
for all these tables i have used function group zfunc in table maintenace.
Now i require only say z1 table and i moving z1 table into qas. In qas when i goto sm30 and give z1 and click maintain it says z2 znd z3 doesnot exist.
Hope i am clear this time.
Thanks in advance
2006 Jun 09 4:12 PM
If you are using the same function group for all table maintenance generations, and you want to move the tables at different points in time, you will end up in the situation that you are currently in. If you combine them, then you have to move them all at the same time.
2006 Jun 09 3:59 PM
Hi,
in this case you have delte the old one and regenerate the table maintenance and then transport them again.
Regards
vijay
2006 Jun 09 4:01 PM
Go to DEV, delete the table maintenance for ZID and if ok, delete the table itself and then regenerate the function group. Then you should be good to go. But, typically, you should use seperate function groups for different tables unless they can grouped based on some criteria(all of them are needed for the same requirement for instance).
2006 Jun 09 4:02 PM
When you delete the table maintenance for ZID you will have to assign a transport to it anyway. That is the transport that you need to move to QA.
2006 Jun 09 4:16 PM
Hi srinivas ,
i did tried your method .
The problem is that there are already some tables withsame function group in qas . which we working fine because at that point all the tables which are using this function group are in qas. now when i moved the tables which are only required the entire thing went wayward. The table which were working fine are now giving error saying that the new tables which are created in dev and
having same function group doesn't exist in qas.
Let me be more clear.
I have z1, z2 tables with function zf in qas and they are working fine.
now i created new tables z3 and z4 in dev with same function group zf.
Now i moved only z3 into qas.after moving z3 into qas everything got messed i.e z1,z2,z3.
when i go go sm30 and give any of these tables z1,z2,z3 it says z4 doesn't exist.
Hope iam clear now.
2006 Jun 09 4:22 PM
Can it possible for you to assign to different function groups to different table and try out?
Or can you try to activate FG in QAS?
Regds
Manohar
2006 Jun 09 4:27 PM
1. Transfer Z4 to QAS
or
2. Delete table maintainance for Z4 in Dev and transfer the transport req to QAS.
2006 Jun 09 4:28 PM
I understand your situation completely Swathi. Here is what happens when you create table maintenance.
Let us say you are creating table maintenance for table z2. You give it a function group 'zf'. System will then automatically creates the function modules necessary to maintain your z2 and also includes your z2 table name in the top include of the function group. Not only that, it also defines some internal tables and structures of the z2 table type.
Now when you move your table and table maintenance to QA, it will work because, the table is there in QA and so the references to it will work.
But now, you add the table maintenance of z3 and z4 to it in dev but move only z3 table definition to QA. Here your function group's top include is referring to z4 in its code because you created the table maintenance for it in DEV, but in qa that table doesn't exist. That is why you get this error.
To remedy it, you need to go to DEV, delete the table maintenance of z4(not the table itself). That will prompt you for another transport. Move this transport to qa. You may need to reactivate manuall the table z3 that might be in inactive state due to the error in the previous transport.
Hope this clears the confusion.
2006 Jun 09 4:30 PM
Hi Swati,
Why did you create Z4 table for the same function group and not moved to test system. If you dont want now please remove that in dev and activate and move CTS to Test box. If you you want later Z4 table you can do the same . As you create the two Z table same time and assign to the same function group there is some Dictionary level dependency happens....thats why you getting the problem.
Hope it will help for you.
Thanks,
Bt
2006 Jun 09 4:59 PM
Hi SRINIVAS,
NOW WE BOTH ARE IN SAME PAGE.
i deleted the tablemaintenance and when i checked the function module or include which system generates i.e
saplzxyz where xyz is my function group .
I doesn't delete the data what ever it has created for this table when i first assigned the zxyz function group
i.e its not deleting the already generated function modules necessary to maintain z2 and also includes your z2 table name in the top include of the function group. Not only that, it also defines some internal tables and structures of the z2 table type.
Its not deleting none of those things which were created when we first assigned it.
hope u understand my problem.
thanks in advance.
2006 Jun 09 5:16 PM
When you delete the table maintenance, it does not delete the data. It will not delete the function modules related to other table maintenances and it will not delete their definition from the TOP include.
Let us say created Z1 and Z2 table maintenances in function group XYZ. You moved them(table and the maintenance) to QA.
Now you add Z3 table maintenance to it in the same function group. Move it QA without moving the table definition. It errors out in QA. You come to DEV and delete the table maintenance for Z3. Your function group will still hold the data declarations for Z1 and Z2 as well as the processing function modules for the same. It will only remove the related references to Z3. Now if move this transport to QA, you should be able to maintain the the tables Z1 and Z2 without any problem.
Is this not what you are seeing?
2006 Jun 09 6:17 PM
Hi srinivas , thxs for your time.
let me tell the entire scenario right from starting.
They have let say 10 z tables z1,z2,z3----z10 in prd with function group zf and these tables belongs to different projects but with same function group.
Now they have additional 10 tables z11,z12-z20 in dev with same function group zf .They moved these tables i.e z11,z12z20 in to qas,these tables also belongs to different projects.
Now 1 one project uses tables z11,z12,z13 and the other z14,z15--z20.
The first project which uses z11,z12,z13 is ready and they are planning to move to prd.
Mind you z1,z2 z10 tables are working fine in prd,but when z11,z12,z13 tables are moved to prd everything messed up and it says tables z14,z15-z20 does not exist in function group zf. Now the people incharge of tables z14,z15--z20 are not yet ready to move then into PRD.
All the tablles in PRD ARE MESSED UP.
what IS YOUR SUGGESTION TO OVER COME THIS . THIS IS A SMALL PICTURE THERE ARE LOT MORE TABLES ATTACHED TO ZF. I DON'T KNOW IAM NEW IN HERE ,IAM REPLACEMENT .
2006 Jun 09 6:23 PM
If you really want PRD to work properly, you have delete the table maintenances of z14-z20 from the function group zf. Send that transport over to PRD. Then recreate the table maintenance for z14-z20 in zf assigning a new transport or the same transport that is used for the project that uses these tables.
Option 2 is, create a transport in dev that contains the table definitions of z14-z20 and move it prd. Since you are not moving anything else except the table definitions, you should be ok.