Skip to Content

Copy standard table data to ztable with similar structure without coding.

Hi,

I need to create z table z** by copying table T042 with additional field in the beginning as checkbox.

Can anybody tell me how to do this.

Also how can replicate the same data as T042 table without coding.Is there a solution to this.

can it be doen using VIEW.

Regards,

Akash

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    Posted on Dec 08, 2014 at 06:35 AM

    Hi, what Mohammed has told is true but it only copies the table structure not the data also. To copy the data from the standard table(without any coding) use FM 'se16n_interface' . Execute the FM with table(standard) name and with edit = 'X'. Copy all the records and execute the same FM with the Ztable with edit='X'. Now paste the copied records and save it.

    Otherwise write a report with the query: select * from <source table> into <target table>.

    If you want to add extra field as check box then first build the desired structure of the table and then write query :select *from <source table> into corresponding fields of <target table>.

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Sk,

      Thanks for your detailed explanation.

      But here we need to run the report in some time interval to keep the data updated in ztable right?

      Is there any way by which data will transferred between the tables in real time without any need to run the report like the functionality in VIEW?

      Regard,

      Akash

  • author's profile photo Former Member
    Former Member
    Posted on Dec 06, 2014 at 03:20 PM

    In TCODE SE11 there is an option (menu dictionary object) to copy table to target table (Ztable).

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 08, 2014 at 07:03 AM

    why don't you schedule a background job to transfer data at some interval?

    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.