Updating custom field in a standard table - AFVC

[Former Member]

Hi All,

We have created a custom field in table AFVC. While updating other things related to that Order/Operation, we need to update this custom field.

Can you kindly let me know how we can approach this? Do we use a direct Modify/update statement in such cases to update the standard sap table?

Regards

An

[former_member156446]

Hi Ankur you need to find a user exit / enhancement spot to have the table updated... Direct update should never be your option.

[Former Member]

Thanks so much for the quick reply.

The scenario is quite different. From a third party software, I am just calling a remote Function Module which updates the Operation User Status. After that, we need to update this custom field to record the reason why the user status was updated.

So I need to do it in the Function Module call.. Can you kindly let me know how shall I proceed.

Ankur

[former_member156446]

I am not sure how is your RFC FM writen, I beleave you would be using a wrapper or directly calling BAPI_ALM_ORDER_MAINTAIN... this BAPI / RFC function has an table parameter called EXTENSION_IN using which you can update the custom fields.

[Former Member]

Hi Ankur,

There are few ways to do.

1) Implement the screen field in the transaction at the operation level for visibilty to all the reason code. After updation of USER STATUS you need write the small utlity to update that field through LSMW or any other way to update this field in the transaction directly to save in the database table.

2) AFVC means orders operation data. In this table many types of order data will store so you have to choose which type of order you are going to update whether it will be Internal order or production order or maintaineance order etc..

3) Direct updation is last preference if there is no way for updation.

Please let me know which order cateogry you are updating from thrid party sytem to your current system.

As J@Y said if you are updating through some function module then in that case for BAPI's there is separate structure EXTENSION_IN and OUT to update the custom fields.

Thanks,

Satheesh