Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

how to update customized table

Former Member
0 Kudos

Hi All,

How to update customized table from the standard table.

thanks,

srii.

7 REPLIES 7

bpawanchand
Active Contributor

raymond_giuseppi
Active Contributor
0 Kudos

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

Regards

0 Kudos

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

0 Kudos

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

Former Member
0 Kudos

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

prince_isaac
Active Participant
0 Kudos

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

Former Member
0 Kudos

completed.