Skip to Content
avatar image
Former Member

Need to exclude TECO and DLV in Z report for production orders

Hello Experts ,

A z report has to be created with production order TECO and DLV excluded.

We tried by using the JEST table to sort the orders but there are discrepancy.

Can you please suggest .It should exactly work like coois report when we exclude both the status.

Regards,

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

7 Answers

  • avatar image
    Former Member
    Jan 01, 2015 at 04:02 PM

    Rakesh,

    We tried by using the JEST table to sort the orders but there are discrepancy.

    That's pretty vague. If you want to emulate COOIS there are many tables to be considered. Just look at the code behind COOIS. Did you make any consideration of whether or not the JEST records are active/inactive in your logic? (JEST-INACT)

    For the best answers, I suggest you close this question, and then re-post in an ABAP forum, such as .ABAP Development

    Best Regards,

    DB49

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 01, 2015 at 05:21 PM

    Hi Rakesh,

    Check the FM STATUS_TEXT_EDIT .

    Goto : Se16n AUFK Table give the production order as input, get object number (objnr).

    se37 STATUS_TEXT_EDIT pass the object number and language(E).

    Get the production order status from FM.

    Hope it helpful.

    Regards,

    Venkat.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 02, 2015 at 12:14 PM

    Hi Rakesh,

    Try to use below logic instead of JEST table.

    Pass order number to AFPO with check below two fields

    AFPO-ELIKZ (Exclude the orders if it is filled with 'X')

    AFPO-DNREL (Exclude the orders if it is filled with 'X)

    This will provide only open orders.

    Regards / US

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 02, 2015 at 10:25 PM

    Hi,

    You should ideally get the correct data if you link AFKO and JEST. what exactly the mismatch details? can you specify a scenario/example?

    Thanks

    Prem

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 03, 2015 at 12:45 PM

    Hello Uma ,

    I am getting the open orders (Exclude DLV ,TECO) by

    AFPO-ELIKZ (Exclude the orders if it is filled with 'X')

    AFPO-DNREL (Exclude the orders if it is filled with 'X)

    Regards ,

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 03, 2015 at 01:27 PM

    Hi,

    Try FM FM STATUS_TEXT_EDIT by passing production orders's object number(aufk).

    Regards,

    Venkat.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 05, 2015 at 07:54 PM

    Dear Rakesh,

    I thing you will need Abap person help as say Dogboy, unless just to give you some idea.

    You can use many functions to check that:

    You need to have the OBJNR or Object number, you can select with the table AUFK filtering only Order category "10" PP orders and others.

    With STATUS_CHECK_MULTI and check with 2 loops the both status and in the metadata you can put all your AUFK- OBJNR.

    In the parameter "FLG_EXCLUDE" check if the status "Status Should not be Active".

    I hope this information can help you.

    Regards,

    Xavier

    Add comment
    10|10000 characters needed characters exceeded