topic Re: how to update customized table in Application Development and Automation Discussions

how to update customized table

Former Member — Tue, 07 Oct 2008 09:16:48 GMT

Hi All,

How to update customized table from the standard table.

thanks,

srii.

Re: how to update customized table

bpawanchand — Tue, 07 Oct 2008 09:19:40 GMT

Check this

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21ec31446011d189700000e8322d00/content.htm

Regards

Pavan

Re: how to update customized table

RaymondGiuseppi — Tue, 07 Oct 2008 09:22:39 GMT

This is a very "open" question, can you be more specific on your request ?

Regards

Re: how to update customized table

Former Member — Tue, 07 Oct 2008 09:25:16 GMT

Hi,

i created one table with two fields KUNNR and ZMONTH,

i want to update the this tble with KNA1.

this is the requirement.

Thanks.

srii

Re: how to update customized table

Former Member — Tue, 07 Oct 2008 09:25:30 GMT

Hi,

you can fill your customized table..

first you can get the data from standard table into internal table..

then from that internal table you can insert the data into your customized table..

Regards,

venkat

Re: how to update customized table

prince_isaac — Tue, 07 Oct 2008 09:36:42 GMT

hie

simply write a select statement inserting the field contents into your table however you must have unique key fields to avoid instances where KUNNR and ZMONTH are existing

prince isaac

Re: how to update customized table

RaymondGiuseppi — Tue, 07 Oct 2008 09:42:03 GMT

Call transaction [FINF|https://www.sdn.sap.com/irj/sdn/advancedsearch?query=finf&cat=sdn_all] and select component FI-AR "Accounts Receivable" you will get a list of [Business Transaction Events|http://help.sap.com/erp2005_ehp_03/helpdata/EN/3b/7f3e8be57c11d1951f0000e82dec10/frameset.htm] where you can insert (via [FIBF|https://www.sdn.sap.com/irj/sdn/advancedsearch?query=fibf&cat=sdn_all]) a customer function module in which you will be able to update your z-table when the standard table will be updated. (In FINF double-click on a BTE to look at the sample FM and the online documentation)

e.g. : [Business Transaction Event |https://www.sdn.sap.com/irj/sdn/advancedsearch?cat=sdn_all&query=businessTransactionEvent+&adv=false&sortby=cm_rnd_rankvalue] 00001320 is called when customer master data are created or changed. Copy the sample function module SAMPLE_INTERFACE_00001320 into a new customer of one of your group, and attach it via transaction FIBF. (You may also look at other SAP implementation of the BTE like ALM_ME_BTE_00001320_CUSTOMER)

Of course, you may need to write a program to initialize your z-table "Init Delta" type.

Regards

Re: how to update customized table

Former Member — Tue, 11 Nov 2008 02:18:22 GMT

completed.