10-17-2007 5:44 PM
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
10-17-2007 5:50 PM
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
10-17-2007 5:56 PM
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!
ec
<b>Don't reward for unhelpful answers</b>
10-17-2007 6:06 PM
Hi
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
10-17-2007 6:11 PM
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
10-18-2007 3:12 AM
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
10-18-2007 3:16 AM
10-18-2007 3:27 AM
Hi Raghu,
If you want to move data from PRD/QAS to DEV you should use area-menu BALM for the same.
Regards,
Atish
10-18-2007 5:40 AM
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 .