Skip to Content
author's profile photo Former Member
0
Former Member

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

Posted on Jan 01, 2015 at 01:01 PM 302 Views

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 a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

7 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 01, 2015 at 04:02 PM
    0

    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 a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Venkatramesh V
    Venkatramesh V
    Posted on Jan 01, 2015 at 05:21 PM
    0

    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 a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 02, 2015 at 12:14 PM
    0

    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 a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Prem Prabhakaran
    Prem Prabhakaran
    Posted on Jan 02, 2015 at 10:25 PM
    0

    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 a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 03, 2015 at 12:45 PM
    0

    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 a comment
    10|10000 characters needed characters exceeded

    Comment on This Answer
  • author's profile photo Venkatramesh V
    Venkatramesh V
    Posted on Jan 03, 2015 at 01:27 PM
    0

    Hi,

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

    Regards,

    Venkat.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Xavier Covis
    Xavier Covis
    Posted on Jan 05, 2015 at 07:54 PM
    0

    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 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.