Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Tables

Former Member
0 Kudos
97

How to you transport a custom table?Can any one provide me with the steps?

1 ACCEPTED SOLUTION

Former Member
0 Kudos
59

Please see the -> DB data

<b>Transport guide Tips for Different SAP Objects</b>

You may be wondering if you can transport certain SAP objects, and if possible, how?

<b>Here are tips for different objects: </b>

1 <b> LSMW There are 2 ways for transporting LSMW data from a system to another. </b>

1.1 Export/import This method gives you the opportunity to select the subprojects or objects you want to transfer. Hence you don't transfer the object a colleague might have created and that should stay in development system. LSMW -> Extras -> Export project

1.2 Transport request With this method, you can transport a LSMW project in full (you can not select the objects you want). With this method, the project will be transported as any other SAP object in a transport order.

LSMW -> Extras -> Create change request

<b>2 Program variants </b>

If you have several program variants in a development system that you want to transport, use the following method to transport them:

Execute program RSTRANSP (via se38) and inform the program and/or variant names (you can transport variant of several programs in one shot).

<b>3 Layout In some transactions, one can save layout of the screen (sort, filter, ... criteria).</b>

These layouts can be transported: In the required transaction, when your layouts have been saved, go to Settings -> Layout -> Layout Management. Select the desired layouts and go to Layout -> Transport… There you can add your layouts in existing TO or create a new one.

<b>DB data </b>

  "  please see  here

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.

<b>4 Queries</b>

Queries, datasets and user groups can be exported/imported between the systems thanks to the program RSAQR3TR.

<b>5 Standard texts </b>

Standard texts used in SAPScript (created with transaction SO10) can be included in transport orders. 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 = TEXT

Object name = TEXT,,ST,

Example :

R3TR / TEXT / TEXT,YMM_MEDRUCK_MAIN_16_EC,ST,F

You can also copy a Sapscript object (like standard text) with the program RSTXCPFS.

<b>How to transfer a executable report from dev server to prd server? And that report contains one user defined view. I want to transfer the report and the view from dev to prd.</b>

At the time of creating the report itself it will ask you to select the PACKAGE.

Here you should select the package instead of $TMP package, which for transporting the objects and create a new request and save it. If you want to give a TCode for the program that you have created just give SE93 in the GUI Window and give the TCode name there and enter the Create button. there you should give the name of the object or program that you have created and save it. After completing this go to SE09 TCode and select the MODIFIABLE Check box and press DISPLAY Button.

In the next screen you have to select the Request that you have created and click the check syntax icon. If no errors are there then you can press the Release Directy icon to transport the request to the Quality system. From there it has to be transported to the Production System. The latter part BASIS will take care.

reward points if it is usefull ....

Girish

4 REPLIES 4

former_member189059
Active Contributor
0 Kudos
59

Create a package in SE80

include that table in your package

put the package in a transport request

transport it all together

Former Member
0 Kudos
59

Hi,

ther're several possibilities to transport CU-Data

(it depends on table-attributes)

-SM30

-SE16, SE16N

-SE09 (manual)

-change object list

-insert line e.g. "R3TR" "TABU" "Yourtab"

-double click

-insert line

-key fields (-> fill your key fields)

-save

<b>Reward points</b>

Regards

Former Member
0 Kudos
60

Please see the -> DB data

<b>Transport guide Tips for Different SAP Objects</b>

You may be wondering if you can transport certain SAP objects, and if possible, how?

<b>Here are tips for different objects: </b>

1 <b> LSMW There are 2 ways for transporting LSMW data from a system to another. </b>

1.1 Export/import This method gives you the opportunity to select the subprojects or objects you want to transfer. Hence you don't transfer the object a colleague might have created and that should stay in development system. LSMW -> Extras -> Export project

1.2 Transport request With this method, you can transport a LSMW project in full (you can not select the objects you want). With this method, the project will be transported as any other SAP object in a transport order.

LSMW -> Extras -> Create change request

<b>2 Program variants </b>

If you have several program variants in a development system that you want to transport, use the following method to transport them:

Execute program RSTRANSP (via se38) and inform the program and/or variant names (you can transport variant of several programs in one shot).

<b>3 Layout In some transactions, one can save layout of the screen (sort, filter, ... criteria).</b>

These layouts can be transported: In the required transaction, when your layouts have been saved, go to Settings -> Layout -> Layout Management. Select the desired layouts and go to Layout -> Transport… There you can add your layouts in existing TO or create a new one.

<b>DB data </b>

  "  please see  here

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.

<b>4 Queries</b>

Queries, datasets and user groups can be exported/imported between the systems thanks to the program RSAQR3TR.

<b>5 Standard texts </b>

Standard texts used in SAPScript (created with transaction SO10) can be included in transport orders. 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 = TEXT

Object name = TEXT,,ST,

Example :

R3TR / TEXT / TEXT,YMM_MEDRUCK_MAIN_16_EC,ST,F

You can also copy a Sapscript object (like standard text) with the program RSTXCPFS.

<b>How to transfer a executable report from dev server to prd server? And that report contains one user defined view. I want to transfer the report and the view from dev to prd.</b>

At the time of creating the report itself it will ask you to select the PACKAGE.

Here you should select the package instead of $TMP package, which for transporting the objects and create a new request and save it. If you want to give a TCode for the program that you have created just give SE93 in the GUI Window and give the TCode name there and enter the Create button. there you should give the name of the object or program that you have created and save it. After completing this go to SE09 TCode and select the MODIFIABLE Check box and press DISPLAY Button.

In the next screen you have to select the Request that you have created and click the check syntax icon. If no errors are there then you can press the Release Directy icon to transport the request to the Quality system. From there it has to be transported to the Production System. The latter part BASIS will take care.

reward points if it is usefull ....

Girish

Former Member
0 Kudos
59

hi

u create a new package and work bench request.

save the table in new package and request.

in se09 -->display --> click on the request no.

it will display the programs and task. release task first and then program by clicking on lorry icon..

if there are any domain created by ourself in table except DB table fields , then that domain also should be moved to new package.

then basis people will take care.

reward if useful..