cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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,

Accepted Solutions (0)

Answers (7)

Answers (7)

former_member215526
Active Participant
0 Kudos

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

VenkatRamesh_V
Active Contributor
0 Kudos

Hi,

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

Regards,

Venkat.

Former Member
0 Kudos

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 ,

sjeevan
Active Contributor
0 Kudos

To meet your criteria you need to have two blank fields CAUFV-IDAT2 and AFPO-ELIKZ. You can do this using simple querying (SQVI) or Z-program.

If IDAT2 is empty, order is not TECO'ed yet, if it is filled with a date, it means the order is TECO'ed on that date.

If ELIKZ is empty, order is not completely delivered yet (it could have partially delivered or not delivered at all), if it equal to X, it means order is fully delivered.

So, in your query/z-report join table CAUFV or AUFK with table AFPO on field AUFNR

then you need to run your query (or put conditions in z-program) with CAUFV-IDAT2 = ' ' (blank) and AFPO-ELIKZ = ' ' (blank)

Former Member
0 Kudos

Hi Rakesh,

If the solution provided by us solves your requirement then close the thread.

Regards / US

former_member193808
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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

VenkatRamesh_V
Active Contributor
0 Kudos

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.

Former Member
0 Kudos

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 .

Best Regards,

DB49