Skip to Content
author's profile photo Former Member
Former Member

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

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,

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

7 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 21, 2007 at 12:04 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 21, 2007 at 12:07 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 21, 2007 at 12:08 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 21, 2007 at 12:09 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 21, 2007 at 12:09 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 21, 2007 at 12:09 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 21, 2007 at 12:11 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.