Regarding Ztable

[Former Member]

Hi Experts,

I am created one ztable and having 4 fields in it. I have transported that ztable in quality and inserted some data in it . So now i need to add some more fields in it and want to transport into quality so if I add some fields to the ztable and transport to quality already existing data should not be effected in the quality.

So my question is so if i add new fields in Ztable in developement and if transported to quality is it effect the data in quality or not???

Suppose if effected so then i need to transport the data from ztable in one client to another client so how can i do this?

<b>points will be rewareded </b>

Regards,

Priyanka Reddy.

[Former Member]

Hi,

After adding the fields in the ur ztable , activate it and after that go to se14

there u can give the ztable name and then click on the activate and adjust database and save it.

it will work.

regards,

Santosh Thorat

[Former Member]

Hi,

Procedure for Transporting ztable with data :

Go to SE09.And press "Create" button and check "Transport of Copies" Radio button and Press Enter.Give Description for the request and press enter .One request no will be generated .Just Double click on that request no,after that press 'Change ' (PENCIL Button) .Then in the table control,Type Program ID as "R3TR" and Object type as "TABU" and Object Name should be your Ztable name.Press ENTER and then Click on the 'Object with KEys' button n the table control and in OBJECT Tab give Table Key as "*". and in "Properties" tab give the target system name(u can use F4 hel to identify the target system to which this content to be transported).and SAVE it.

NOTE :Your Table shoul have Delivery Class as C (Customizing table, maintenance only by cust., not SAP import)

[ThomasZloch]

If you add fields to a table in DEV then transport this to QAS, the data in QAS will not be affected. The table structure will automatically be adjusted during import.

Only if you delete or rename fields then transport the change, you will lose the data in the respective columns.

Cheers

Thomas

[Former Member]

Hi,

Since you are not changing the existing primary key combination and just you are adding some other fields you wont loose data present in quality server.

After adding those fields you goto menu path Utilities Datbase utility>Activate and adjust datbase button.

Activate without log exist before tranporting to quality server.

Regds

Sivaparvathi

Please reward points if helpful...

[Former Member]

Hi Priyanka,

untill unless you change or delete the field names from the ZTABLE, it wont affect in database, so you can add new fields to the Ztable and transport, it only changes the physical structure of the database table.

i hope your doubt is clear.

Thanks,

Murali

[Former Member]

Hi Priyanka,

Once create the Z-table we hav 2 transport it to

RCT n RCB. If u make any modifications in

existing Z-table it will reflect to the existing data.

when it will happens means:Eg

Case1. If u r using this in Export params,portal people will

reimport this structure to get the data from R/3

side ok. From portal they have to make the

modifications while reimporting the structure.

Bcaz u r modifying the existing z-table.

This is the general case i have seen in my RFC.

Regards,

AshokChowdhary.M

[former_member202957]

Hi Priyanka,

After adding fields in DEV just go to the t-code SE14 and Adujst and Activate the table and transport to QAS system. It will not effect the data in the database. Until and unlsess if your adding any primary key it will not effect the database recordsin QAS.

Reward if useful,

Regards,

sunil kairam.