topic Re: Dynamic update in Application Development and Automation Discussions

Dynamic update

Former Member — Mon, 20 Nov 2006 21:06:33 GMT

Hello guys,

I have to write a aprogram to update one Z table. The problem is that the program has to be used to update different Z tables, with different structures. So, I have to update a table , but I don't know the structure of the table. I only know that I fill have some pairs of fields like 1_from and 1_to , 2_from and 2_to ...., fields that need to met some logical conditions (validation). Is this possible? I was thinking to have the table name as an input parameter, then to define an internal table type ref to tabname, and then to update it, but I don't know hou do do it.

Can anyone help ?

Thank You!

Re: Dynamic update

ferry_lianto — Mon, 20 Nov 2006 21:14:49 GMT

Hi,

Please check this blog perhaps it may help.

/people/rich.heilman2/blog/2005/07/27/dynamic-internal-tables-and-structures--abap

Regards,

Ferry Lianto

Re: Dynamic update

Former Member — Mon, 20 Nov 2006 21:17:28 GMT

You can use the Dynamic internal tables for the same,

Weblogs

/people/rich.heilman2/blog/2005/07/27/dynamic-internal-tables-and-structures--abap

/people/subramanian.venkateswaran2/blog/2004/11/19/dynamic-internal-table

Regards

Kathirvel

Re: Dynamic update

former_member186741 — Tue, 21 Nov 2006 03:52:22 GMT

here's a simple program to dynamicaly read and print the first 5 rows of any parameter supplied table. You can use the concepts to write an update program.

REPORT znrw_dyn_tab.

PARAMETERS: p_tab1 TYPE tabname.

DATA tabdref TYPE REF TO data.

FIELD-SYMBOLS <struc> TYPE ANY.

FIELD-SYMBOLS <tab> TYPE table.

PERFORM get_data USING tabdref p_tab1.

LOOP AT <tab> ASSIGNING <struc>.

PERFORM print USING <struc>.

ENDLOOP.

&----

*& Form get_data

&----

FORM get_data

USING us_tdref TYPE REF TO data

us_table TYPE tabname.

CREATE DATA us_tdref TYPE TABLE OF (us_table).

ASSIGN us_tdref->* TO <tab>.

SELECT * FROM (us_table) UP TO 5 ROWS INTO CORRESPONDING FIELDS OF

TABLE <tab>.

ENDFORM. "get_data

&----

*& Form print

&----

FORM print USING p_struc.

FIELD-SYMBOLS <field> TYPE ANY.

NEW-LINE.

DO.

*... work through all structure's components...

ASSIGN COMPONENT sy-index OF STRUCTURE p_struc TO <field>.

IF sy-subrc <> 0.

*... exit when reaching the end of components

EXIT.

ENDIF.

WRITE: <field>.

ENDDO.

ENDFORM. " print

Re: Dynamic update

Former Member — Wed, 22 Nov 2006 06:46:45 GMT

Thank you all for your reply's.

Very helpful example, thank you.

Any suggestion for the update part? I don't know how to build a dynamic screen, generating fields according to my dynamic table.

Re: Dynamic update

former_member186741 — Wed, 22 Nov 2006 22:45:48 GMT

we need to know a bit more to help you out on this.

1. do you really need to write a program? Why not use SM30? You might be trying to reinvent the wheel here.

2. do you know in advance the tables you are dealing with? If you do then you could build your screen with all the possible fields but only display the ones that relate to the entered table. Your PAI code would validate that the entered table is in the permitted set. Your PBO code would be hard-coded to hide fields not relating to the entered table.

3. if you want a slightly more generic approach you could create a control table which defines the tables allowed to be dealt with by this transaction and maybe another one defining the fields (name,type,length,Updateability etc). Your screen could have generic fields....field1,field2 etc. Your PAI code would consult the table to validate the entered table. The PBO code would use the entered table and the associated field list values to decide how many fields are displayed, what text precedes them and what format each one has.

Re: Dynamic update

Former Member — Thu, 23 Nov 2006 08:22:13 GMT

Thank you for your reply.

It would be nice to do it through SM30, but I have to do lots of validation and authorisation checks, and I really don't know how to modify that transaction.

Re: Dynamic update

Former Member — Thu, 23 Nov 2006 08:25:43 GMT

For validations, you can use the events that come with the table maintenance. See the document here, which explains how to deal with the events in detail.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/abap/how%20to%20implement%20events%20in%20table%20maintenance.doc

Regards

Ravi

Note - Please mark all the helpful answers

Re: Dynamic update

Former Member — Thu, 23 Nov 2006 09:04:01 GMT

Thank you very much for this tip.

Verry usefull. One more question: When I enter the events dialog, I have an information popup with "DO NOT CHANGE, SAP DATA".

Is it safe to add events there?

Thank you!

Re: Dynamic update

Former Member — Thu, 23 Nov 2006 09:14:17 GMT

You will not manually add event but select which ones to be activated and then it will give a sort of include where you do your coding.

Regards,

Ravi