Skip to Content

Update system status in JEST table

Hi Experts,

I need to update the system status TECO as inactive in table JEST based on some condition from program manually. It might not be suggested to directly modify the database table. I got one BAPI function module BAPI_ALM_ORDER_MAINTAIN, but could not find how to use it.

Can you please let me know whether there are any BADIs or BAPIs to update the system status in JEST table.

Thanks in advance for you help.

regards,

Lakshmi.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Sep 10, 2010 at 07:55 AM

    Hi,

    I could not find such BAPI or FM but if you find one or write your own

    Make sure you update JEST and JCDS both the tables otherwise your order will go into dump.

    Regards

    Bikas

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi ,,

      Thank you for your suggestion. but I got a FM which exactly updates the system status in JEST and JCDS tables.

      The function module STATUS_CHANGE_INTERN and can be used as follows. We always need to follow one condition that, when the system status TECO is changing to inactive the REL status should be made Active.

      DATA: i_stat TYPE STANDARD TABLE OF jstat.

      DATA: wa_stat TYPE jstat.

      wa_stat-stat = 'I0045'.

      wa_stat-inact = 'X'.

      APPEND wa_stat TO i_stat.

      wa_stat-stat = 'I0002'.

      wa_stat-inact = ' '.

      APPEND wa_stat TO i_stat.

      CALL FUNCTION 'STATUS_CHANGE_INTERN'

      EXPORTING

      client = sy-mandt

      objnr = lv_objnr

      TABLES

      status = i_stat

      EXCEPTIONS

      object_not_found = 1

      status_inconsistent = 2

      status_not_allowed = 3

      OTHERS = 4.

      COMMIT WORK.

  • author's profile photo Former Member
    Former Member
    Posted on Sep 10, 2010 at 09:54 AM

    I used that F.M.

    CALL FUNCTION 'I_CHANGE_STATUS'

    EXPORTING

    objnr = object_tab-objnr

    estat_inactive = old_tj30-estat

    estat_active = wt_tj30-estat

    • STSMA =

    EXCEPTIONS

    cannot_update = 1

    OTHERS = 2

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.