on 01-01-2015 1:01 PM
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,
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Try FM FM STATUS_TEXT_EDIT by passing production orders's object number(aufk).
Regards,
Venkat.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 ,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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)
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.