topic database table entires in transport request in Application Development and Automation Discussions

database table entires in transport request

Former Member — Fri, 20 Jul 2007 19:20:09 GMT

Hi,

How can i transport the table entries .

Thanks

Kumar

Re: database table entires in transport request

Former Member — Fri, 20 Jul 2007 19:22:17 GMT

Yes you can.

You can create a REQUEST for that specifc entry and transport it from development box to other box.

To create a request and add a Table entry you need to follow this steps

transport also R3TR TABU table data, go to SE01, add an entry R3TR TABU <table name> and then go to key list and take all records by only selecting MANDT and a star * for the key or the required key entry.

Thaks,

Mahesh

Re: database table entires in transport request

Former Member — Fri, 20 Jul 2007 19:22:50 GMT

Refer these related threads

Re: database table entires in transport request

Former Member — Fri, 20 Jul 2007 19:25:02 GMT

Re: database table entires in transport request

Former Member — Fri, 20 Jul 2007 19:26:09 GMT

Hi,

If table maintenance generator is already there for your table maintenance generator then go to SM30 - give the table name, select the table entries which you want to transport then - menu - Edit - Transport - Include in request.

so automatically selected entries will be included in the transport.

Please let me know if you need any further information...

regards

reward for all useful answers.

Re: database table entires in transport request

Former Member — Fri, 20 Jul 2007 19:29:05 GMT

Check the below program :

if you maintained table maintaince for table,then it would be very easy.

select the standard radio button in table maintaince ,it will ask request for each record

report ztest_xyz.

Table diclaration

tables: tvdir.

Selection screento table View

selection-screen skip 2.

parameter p_tabnm(30) as listbox visible length 30 obligatory.

selection-screen skip 1.

selection-screen begin of block s1 with frame title text-001.

parameter: p_radio1 radiobutton group g1,

p_radio radiobutton group g1.

selection-screen end of block s1.

Add values to list box

at selection-screen output.

type-pools: vrm.

data: name type vrm_id,

list type vrm_values,

value like line of list.

name = 'P_TABNM'.

refresh list.

value-key = 'V_024'.

value-text = text-002. "'V_024-Purchasing Groups'.

append value to list.

value-key = 'V_T024D'.

value-text = text-003. "'V_T024D-MRP Controllers'.

append value to list.

value-key = 'ZT604'.

value-text = text-004. "'T604-Commodity Codes'.

append value to list.

value-key = 'T179'.

value-text = text-005. "'T179-Product Hierarchies'.

append value to list.

value-key = 'TVM1T'.

value-text = text-006. "'TVM1T-Business Manager'.

append value to list.

value-key = 'TVM2T'.

value-text = text-007. "'TVM2T-Division manager'.

append value to list.

value-key = 'TVM3T'.

value-text = text-008. "'TVM3T-Director'.

append value to list.

value-key = 'V_TVV2'.

value-text = text-009. "'V_TVV2-Customer Group 2'.

append value to list.

call function 'VRM_SET_VALUES'

exporting

id = name

values = list.

start-of-selection.

Get flag of corresponding table view

select single tabname flag from tvdir into tvdir

where tabname = p_tabnm.

Set flag of corresponding table view

if p_radio1 eq 'X'.

if tvdir-flag ne 'X'.

update tvdir set: flag = 'X'

where tabname = p_tabnm.

endif.

if p_radio eq 'X'.

if tvdir-flag eq 'X'.

update tvdir set: flag = ''

where tabname = p_tabnm.

endif.

Execute View/Table

call function 'VIEW_MAINTENANCE_CALL'

exporting

action = 'U'

view_name = p_tabnm

exceptions

client_reference = 1

foreign_lock = 2

invalid_action = 3

no_clientindependent_auth = 4

no_database_function = 5

no_editor_function = 6

no_show_auth = 7

no_tvdir_entry = 8

no_upd_auth = 9

only_show_allowed = 10

system_failure = 11

unknown_field_in_dba_sellist = 12

view_not_found = 13

others = 14.

if sy-subrc <> 0.

message id sy-msgid type sy-msgty number sy-msgno

with sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.

endif.

Reset flag of corresponding table view

update tvdir set: flag = tvdir-flag

where tabname = p_tabnm.

Thanks

Seshu