topic Re: Transfer Table Data? in Application Development and Automation Discussions

Transfer Table Data?

Former Member — Wed, 17 Oct 2007 16:44:24 GMT

Hi Experts,

I want to move Table data from Quality Server into Development Server,(tables like MARA,MARC,BKPF,BSEG)

How can I do this,Please guide.

Regards,

Raghu

Re: Transfer Table Data?

Former Member — Wed, 17 Oct 2007 16:50:06 GMT

Hi raghu,

table data is client dependent, you can not transport. the only way is, you have to download from quality server and upload to develeopment server. You need to write a program to download and upload.

<b>Reward for helpful answers</b>

-Satish

Re: Transfer Table Data?

JozsefSzikszai — Wed, 17 Oct 2007 16:56:20 GMT

hi,

you have to do a client copy, i. e. moving everything from one system to other at the same time. You cannot move some tables only, because that can lead to incostincies in your database!

<b>Don't reward for unhelpful answers</b>

Re: Transfer Table Data?

Former Member — Wed, 17 Oct 2007 17:06:14 GMT

What for you are asking this I don't know?

Generally we move the development data into Quality server using the transpot requests

But in implementation projects to have some test data ffrom quality or PRD to DEV we use client copy

You can do client copy for moving the complete good test data into dev server using SCC1 tcode

check with the BASIS person to do this.

Regards

Anji

Re: Transfer Table Data?

Former Member — Wed, 17 Oct 2007 17:11:50 GMT

You really can't move these tables. There are so many inter-relations between them and other tables that you'd have to move all tables.

Client copy is one solution.

But with a client copy to DEV, you will lose version management. This would be a really bad theing.

The best alternative is to leave things as they are and do teesting in QA.

Rob

Re: Transfer Table Data?

Former Member — Thu, 18 Oct 2007 02:12:22 GMT

Thanks for ur suggestions...

I created a report which uses a RFC to get data from Quality Server, I am able to get all data from Q Server .

But when I try to modify my tables in Dev System, I am getting Dump.(But I am able to Modify Small Tables like MAKT..),but like tables like MARA, MARC gives me dump.

(Small Tables means, less number of fields and not data)

Please Give ur Suggestion.

Regards,

Raghu

Re: Transfer Table Data?

Former Member — Thu, 18 Oct 2007 02:16:47 GMT

Hi Raghu,

can you paste your code?

Regards,

Atish

Re: Transfer Table Data?

Former Member — Thu, 18 Oct 2007 02:27:01 GMT

Hi Raghu,

If you want to move data from PRD/QAS to DEV you should use area-menu BALM for the same.

Regards,

Atish

Re: Transfer Table Data?

Former Member — Thu, 18 Oct 2007 04:40:08 GMT

Hi,

This is the code..

TYPE-POOLS sscr.

DATA: restrict TYPE sscr_restrict,

opt_list TYPE sscr_opt_list,

ass TYPE sscr_ass.

DATA: options TYPE STANDARD TABLE OF rfc_db_opt ,

fields TYPE STANDARD TABLE OF rfc_db_fld ,

meta TYPE STANDARD TABLE OF ywas_metadata ,

xml_out TYPE string .

DATA: wa_options LIKE LINE OF options,

wa_fields LIKE LINE OF fields ,

wa_meta LIKE LINE OF meta .

FIELD-SYMBOLS: <outtab> TYPE STANDARD TABLE,

<l_line> TYPE ANY,

<l_field> TYPE ANY.

DATA: new_table TYPE REF TO data.

DATA: new_line TYPE REF TO data.

DATA: xslt_error TYPE REF TO cx_xslt_exception ,

xslt_message TYPE string .

DATA: it_fieldcat TYPE lvc_t_fcat,

is_fieldcat LIKE LINE OF it_fieldcat.

PARAMETERS: tab TYPE dd02l-tabname OBLIGATORY ,

r_skips TYPE soid-accnt ,

r_count TYPE soid-accnt .

SELECT-OPTIONS: opt FOR wa_options-text NO INTERVALS,

flds FOR wa_fields-fieldname NO INTERVALS .

INITIALIZATION .

CLEAR restrict .

CLEAR opt_list.

MOVE 'EQ' TO opt_list-name.

opt_list-options-eq = 'X'.

APPEND opt_list TO restrict-opt_list_tab.

ass-kind = 'S'.

ass-name = 'OPT'.

ass-sg_main = 'I'.

ass-sg_addy = ' '.

ass-op_main = 'EQ'.

ass-op_addy = 'EQ'.

APPEND ass TO restrict-ass_tab.

CLEAR ass.

ass-kind = 'S'.

ass-name = 'FLDS'.

ass-sg_main = 'I'.

ass-sg_addy = ' '.

ass-op_main = 'EQ'.

ass-op_addy = 'EQ'.

APPEND ass TO restrict-ass_tab.

CALL FUNCTION 'SELECT_OPTIONS_RESTRICT'

EXPORTING

restriction = restrict

EXCEPTIONS

OTHERS = 1.

START-OF-SELECTION .

IF NOT opt[] IS INITIAL .

LOOP AT opt .

CLEAR wa_options .

MOVE: opt-low TO wa_options-text .

APPEND wa_options TO options .

CLEAR wa_options .

ENDLOOP .

ENDIF .

IF NOT flds[] IS INITIAL .

LOOP AT flds .

CLEAR wa_fields .

MOVE: flds-low TO wa_fields-fieldname .

APPEND wa_fields TO fields .

CLEAR wa_fields .

ENDLOOP .

ENDIF .

CALL FUNCTION 'YWAS_RFC_READ_TABLE'

EXPORTING

query_table = tab

rowskips = r_skips

rowcount = r_count

IMPORTING

xml_out = xml_out

TABLES

OPTIONS = options

fields = fields

meta = meta

EXCEPTIONS

table_not_available = 1

table_without_data = 2

option_not_valid = 3

field_not_valid = 4

not_authorized = 5

data_buffer_exceeded = 6

OTHERS = 7.

IF sy-subrc <> 0.

MESSAGE e000(00) WITH 'Error' .

ENDIF.

IF NOT meta[] IS INITIAL .

CLEAR: is_fieldcat .

REFRESH: it_fieldcat .

CLEAR wa_meta .

LOOP AT meta INTO wa_meta.

is_fieldcat-fieldname = wa_meta-fieldname.

is_fieldcat-outputlen = wa_meta-outputlen .

is_fieldcat-datatype = wa_meta-datatype.

is_fieldcat-scrtext_l = wa_meta-scrtext_l.

APPEND is_fieldcat TO it_fieldcat.

CLEAR : is_fieldcat .

ENDLOOP .

IF NOT it_fieldcat[] IS INITIAL .

CALL METHOD cl_alv_table_create=>create_dynamic_table

EXPORTING

it_fieldcatalog = it_fieldcat

IMPORTING

ep_table = new_table.

ASSIGN new_table->* TO <outtab>.

CREATE DATA new_line LIKE LINE OF <outtab>.

ASSIGN new_line->* TO <l_line> .

ENDIF .

IF NOT xml_out IS INITIAL .

TRY .

CALL TRANSFORMATION (`Y_RRT_TRANSFORM`)

SOURCE XML xml_out

RESULT outtab = <outtab>.

CATCH cx_xslt_exception INTO xslt_error.

xslt_message = xslt_error->get_text( ).

WRITE:/ xslt_message .

ENDTRY.

ENDIF .

*******

FIELD-SYMBOLS:

<L_TABLE> TYPE STANDARD TABLE. "Internal table

loop at <outtab> into <l_line>.

modify <outtab> from <l_line> index sy-tabix.

endloop.

move <outtab> to <l_table>.

Modify (tab) from table <outtab>.

ENDIF .

*ENDIF .