topic Re: Function module to update the Z-table in Application Development and Automation Discussions

Function module to update the Z-table

Former Member — Mon, 04 Dec 2006 07:59:44 GMT

Hi All,

Is there any function module to insert a new record in to the Z-table.I want to give the Z-table name and the specific fields to be inserted and the value for those firlds.Examples will be useful.

Thanks in Advance.

Re: Function module to update the Z-table

Former Member — Mon, 04 Dec 2006 08:03:34 GMT

I don't think there is any generic function that can be used to update any Z Table.

You might have to write one.

Regards,

Ravi

note - Please mark all the helpful answers

Re: Function module to update the Z-table

Former Member — Mon, 04 Dec 2006 11:21:16 GMT

You need to write your logic to update it. Please check this....

DATA WF_TABLE_NAME LIKE DD02L-TABNAME.

DATA ITABREF TYPE REF TO DATA.

DATA WF_WHERE(100) TYPE C.

FIELD-SYMBOLS:

<DBTAB> TYPE STANDARD TABLE,

<FS_ITAB> TYPE ANY.

Get WF_TABLE_NAME value from user input.

SELECT SINGLE * FROM DD02L

WHERE TABNAME EQ WF_TABLE_NAME AND

AS4LOCAL EQ 'A'.

If sy-subrc eq 0.

CREATE DATA ITABREF TYPE STANDARD TABLE OF (WF_TABLE_NAME).

ASSIGN ITABREF->* TO <DBTAB>.

SELECT * FROM (WF_TABLE_NAME)

INTO TABLE INT_TABLE WHERE <fldname> = WF_WHERE.

IF SY-SUBRC EQ 0.

LOOP AT INT_TABLE ASSIGNING <FS_ITAB>.

******

Write your logic....

******

ENDLOOP.

ENDIF.

Let me know, if you need any info.

Regards,

Ramki.

Re: Function module to update the Z-table

Former Member — Mon, 04 Dec 2006 13:55:30 GMT

1. Go to SE80.

2. Create a Z function group

3. Create a Z function module inside that group

4. Put all the input data as the import parametr of the FM. Can use a structure also

5. Inside the FM do the insert of the data into the Z table

6. Also do exception handling and documentation

Re: Function module to update the Z-table

Lakshmant1 — Tue, 05 Dec 2006 08:44:56 GMT

Hi Shri Ram,

Try FM COC2_TABLE_INSERT_DB.

Hope this helps

Thanks

Lakshman