Transport Table entries...

[former_member583013]

Hi:

I have developed a custom customizable table...Which is maintained via ALV...I need to create a new Transport Request everytime a new record is created or any record is modified...Can you please tell me which FM can I use??? I have browse SE37 without any luck -:(

Greetings,

Blag.

[Former Member]

It looks like your intension is to record all changes to the customizable table. Can you not activate the log to record changes.

For transport of table contents then you can manually create a transport request and move it to the target system in defined intervals.

- Cheers

[former_member583013]

Thanks for your answer, but as I already said...The table is mantain via an ALV report, so when you press <b>SAVE</b>, a transport order should be created with all the created or modified fields...So they can be transported to QAS and PRD...That's why I need a FM...It should be an automate process...

Greetings,

Blag.

[Former Member]

Blag,

Check the below code :

• 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 = 'Enter table name '. " Enter table name here

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

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.

endif.

if p_radio eq 'X'.

if tvdir-flag eq 'X'.

update tvdir set: flag = ''

where tabname = p_tabnm.

endif.

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.

When you execute the report ,just change radio button and see the results

Good Luck

Thanks

Seshu

[rodrigo_paisante3]

Hi,

this can help you??

TR_EXT_CREATE_REQUEST

Regards.

-

---

this thread too

Message was edited by:

Rodrigo Paisante

[former_member583013]

Thanks Rodrigo! You second link do the trick...Now it's working great!!! -:D

Greetings,

Blag.