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

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

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.

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

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

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 ,

Hi,

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

Regards,

Venkat.

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