updation of data base table

[Former Member]

Hi All,

when we create or change the tranx va01 /va02 the data base tablea updated are vbak,vbap........,parrel to that i craeted a data base table with some fields of the sales order, i want to store the fields in the data base table when these to tranxs run, what i think is go to the standard module pool programme and pass the values to the created data base table into to the corresponding fields, is it correct and for every time i pass fields is needed updation,is it correct ,please provide the solution , i will be very thankful to u.

Thanks

Murali

[Vijay]

hi

the solution could be before updating table you can check the table if it having the same record already or not using the key field(s) of ur table.

if the record is present dont update otherwise create entry in table.

regards

vijay

reward points if helpfull

[Former Member]

Hi,

TO achive this you need to write some custom code in one of the Sales User Exit. ( Include MV45AFZZ ).

Write your code such that when ever a sales order is created/changed, control of the program would go to your code, will take the values in the work area and then use the MODIFY statement to update/craete the entry in your table.

Regards,

Lalit

[Former Member]

Hi,

go to the include 'MV45AFZZ' there you can find the user exit "userexit_save_document" there you can write the code to update your ZTABLE, i think this is the right place to update you table.

Reward if useful.

Thanks,

Sreeram.