Changing of BOM status through workflow

Hi Experts,

I have created a workflow for changing the status of BOM. The flow is as below : Workflow gets triggered (created a custom class and method) through CS01 / CS02 (Fiori App)>The status of BOM initially should be set to 2(Inactive) > This request comes to inbox of approver to approve or reject > If the approver approves the status of BOM should change to 1(Active). I tried to use the BAPI_BOM_UPDATE_SAVE but this is not updating the status. so i have tried to use FM DB_UPDATE_TABLE. Also in the workflow if the approver approves or rejects the initiator gets an alert.

But the workflow does not complete?.

How should the workflow conclude.?

What should i perform to conclude the workflow.?

Could anyone please help me with this issue, i have searched the forums for all suggestion, but did not find. Please provide me the FM or BAPI along with a example code .

This issue is pending from many days and i am unable to update this. Please help me.

Thanks in advance

Regards,

Rekha

      CALL FUNCTION 'DB_UPDATE_TABLE'
        EXPORTING
          tablename      = lc_stko
        TABLES
          inttab         = lt_stko
        EXCEPTIONS
          db_error       = 1
          not_found      = 2
          wrong_param    = 3
          internal_error = 4
          OTHERS         = 5.
      IF sy-subrc = 0.
        COMMIT WORK.
      ENDIF.