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: 

Auto update of Ztable when ever BSID or BSAD tables updated

Former Member
0 Kudos

Auto update of Ztable when ever DB table updated

Hi experts

I want my Ztable get updated automatically when ever a record is created or updated in BSID or BSAD tables.

Here clear requirement

Generally using Company code & Allocation number ( 18 char ) my programs access BSID & BSAD tables it is taking very long time for execution almost more than 30 minutes ( data in millions ).

Step 1.

I created a new Ztable with limited fields Company Code, Customer, Document, Allocation Number and Posting date.

Step 2.

Before look into BSID or BSAD my program searches Ztable for Customer number & Document number using Allocation field and Company code.

Step 3.

Once get the Customer & Document numbers accessing BSID & BSAD table is very easy (now just taking less than 1 minute).

Created a new program to update Ztable every day but BSID and BSAD are live table so I want my Ztable get updated immediately when any entry posted in BSID or BSAD

Please help me

Satya

Singapore

2 REPLIES 2

Former Member
0 Kudos

You need to check what is the procedure (T-Code) from which the data gets updated into these tables.

For example

when we craete a material from MM01 the data gets updated in the corresponding table i.e. EKPO.

In same way you need to find the process and then you can use BTE (Busineess transaction events) for that process. BTE are only for FI module and these tables are also related to FI .

Former Member
0 Kudos

Hi Satya,

I dont think its possible to do a simultaneous update of Ztable with BSID and BSAD table , cause system posts entries in these tables based on the nature of the Document (Open or closed customer invoices ) .

But in your case i feel an INDEX can help , You can try creating an INDEX on BSID and BSAD using the fields which you can use in the select query . Indexed search will ensure faster access to database table.

TC

Sajimon Chandran