transporting a Z table.....take points.

[Former Member]

Hi all,

-I want to transport a ztable that contain..some validation data.

-Thing is when i'll transport it to production, then how i will put data to the table, as we can not put directly data to a table in production server.

-Pleas give me a simple solution.

Have ur points.

Regards,

[Former Member]

U can keep data in excel file, and upload to the internal table using WS_UPLOAD Function module, and using INSERT statement insert to ur ZTABLE in production.

Write a program in development, transport to production and then execute by giving filename.

[Former Member]

Hi

In the Trasnport request you have to add an entry for the table data

double click on the request in SE09/se10

then add an entry like

R3TR-TABU-<tab name>

then press the function key side of this table name

takes you to other screen

there enter * (star) and save

it will save all the data of the table in the request

when you transport this request all the table data will be transported.

Reward if useful

regards

Anji

[former_member223537]

Hi Pradeep,

You can transport table along with table contents within a single TR.

Here are the steps:

1. Goto SE01.

2. Click New and create a New Work Bench Request.

3. Then place the cursor on the TR and click on Display Object List ( Shift + F11 )

4. Enter PGMID as R3TR

5. Enter OBJ as TABU

6. Enter OBJECT NAME as Z<TABLE NAME>

7. Again in the menu, select 'Extras>Change object function>Key according to key list'.

Now go to the menu, 'Goto-->Key list'. In the subsequent screen, click on 'Insert line' icon(with a + sign).

Best regards,

Prashant

[aaron_morden2]

When creating the Ztable, create a table maintenance view. Set the recording routine to Standard recording routine. You then will use SM30 to populate the table in DEV and then you will transport the contents of the table to PRD.

[Former Member]

Hi pradeep,

1. Important points :

a) the delivery class of the table should be C = Customizing (in se11)

b) then generate table maintenance

c) using sm30 , enter records in that table

(the system will automatically ask for request number)

d) enter the records in customzing client

regards,

amit m.

[Former Member]

hi,

create table maintanance generator for that ztable, then u can enter values in to that table

Table maintanance Generator is used to manually input values using transaction sm30.

follow below steps

- go to se11 check table maintanance check box under attributes tab

- utilities-table maintanance Generator->

create function group and assign it under function group input box.

also assign authorization group default &NC& .

- select standard recording routine radio in table table mainitainence generator to move table contents to quality and production by assigning it to request.

- select maintaience type as single step.

- maintainence screen as system generated numbers this dialog box appears when you click on create button

- save and activate table

- After creating table maintenance, From SM30 transaction user can do maintenance.

regards

siva

[Former Member]

Hi Pradeep,

In some unusual cases, you might have to transport data of a SAP table.

Go to transaction SE16, select your entries and go to Table entry -> Transport entries. It's only possible for some tables...

If you cannot do it that way, you have to create a Workbench transport order with transaction SE10. When created, click on it, go in menu Request/task -> Object list -> Display object list.

Go in modification mode and add a new line with:

PgmID = R3TR

Obj = TABU

Object name = Name of your table

Double-click on the created line and, depending on your need, put '*' in the key field or double-click on it and select the key you need to transport.

Thanks,

Vinay