STATUS_UPDATE error to update USER STATUS - Update termination error

[Former Member]

Hi All,

I am using status_update FM in sales order user exit MV45AFZZ in a perform routine for updating user status in line item for sales order. There are 4 custom statuses created for the sales order line item. 1,2 3, and 4 by configuration. My job is to select one of those based on user selection.

Scenario: During change order process using VA02, I have to change the existing status to a third status when user selects the second one. That is for example, in VA02, user selects status 4 from previous status 3, and save, I have to make the status 4 inactive and save the new status 2 instead of 3 though user selected 3. How do I achieve this.? ????Any programming example is really appreciated. Thanks!!!

I am right now using STATUS_READ and reading the existing status 4. Then making it inactive using status_update FM. And updating the new status 2 as active one and 3 as inactive again. Two inactive updates and one active update is throwing an update termination error while saving the sales order.

Any help is really appreciated.

Thanks

Ricky

[Former Member]

Hi All,

I am using status_update FM in sales order user exit MV45AFZZ in a perform routine for updating user status in line item for sales order. There are 4 custom statuses created for the sales order line item. 1,2 3, and 4 by configuration. My job is to select one of those based on user selection.

Scenario: During change order process using VA02, I have to change the existing status to a third status when user selects the second one. That is for example, in VA02, user selects status 4 from previous status 3, and save, I have to make the status 4 inactive and save the new status 2 instead of 3 though user selected 3. How do I achieve this.? ????Any programming example is really appreciated. Thanks!!!

I am right now using STATUS_READ and reading the existing status 4. Then making it inactive using status_update FM. And updating the new status 2 as active one and 3 as inactive again. Two inactive updates and one active update is throwing an update termination error while saving the sales order.

Any help is really appreciated.

Thanks

Ricky

[Former Member]

Hi ricky,

For saving any changes you need to have a Z-table.

In programs we can't store the user selection. In your case you can create a z-table and store the status there and delete the last status. The process would be faster as you will always have one record in the table.

. One more advantage is you can even track the changes through the Z-table(User who is changing it.)

Hope this solution will surely help you.

Cheers

Suvi

[Former Member]

Hi,

Not sure whether you understood what I was asking. I did not understand your response but understood one thing that you are suggesting some design change which is not possible at this point as the testing phase is already ending. So please suggest some method which wont change the design as it is.

[Former Member]

Any help is really appreciated as it is a long time search now. No ideas how to resolve this.

[Former Member]

anybody., This is a show stopper for go-live. Any help is really appreciated

[Former Member]

This message was moderated.