on 06-08-2015 7:23 AM
Hi everyone,
Could you please suggest table where I can find WBS attached to process order.
We are developing one Z report where client require to fetch actual cost posted particularly on few cost elements, I used COEP table but it is showing only cost posted on WBS OBJNR, TO get appropriate value of actual cost, I need actual cost posted on order as well. If i get a table where i can find OBJNR of order attached to WBS, the same i can pass to COEP to get total actual cost. Looking forward for your responses.
Regards
Gaurav Ahuja
Hi Samar / Maria,
Somehow, I am not able to fetch orders list from AUFK table, field PSPEL is not updating there although WBS element is assigned in order. I am unable to find the reason being this. I have asked technical person to look into this if he can help in this.
Secondly - AFPO table may also fullfill my requirement in some way, Passing WBS element, It is showing attached orders, coping orders from this table, I can use AUFK table to get there OR* number. Passing OR* numbers to COEP displaying actual cost posted on orders.
Could you please suggest me, AFPO contain all orders attached to WBS or there may be some more process or order cost in the system ??
Regards
Gaurav Ahuja
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Samar,
Thanks !!
I can see orders detail attached to WBS in AUFK when i execute it directly by putting order in AUFK, but WBS field in AUFK table is blank correspond to that order. Also, correspond to that order, I can fetch actual cost posted from COEP table,
Now only assistance i need is to fetch orders based on WBS field.
regards
Gaurav
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Gaurav,
the reason is in AUFK table the WBS is not a primary key. and .In your case the table is not getting the required WBS though it is maintained in the front end.. Can you get it checked by your technical team why is that the case?
other way to get it would be to run actual cost report for Orders and get the WBS filtered from that report.. which is not the right solution..
regards
Samarr
Hi Gaurav,
In AUFK - PSPEL, you need to pass the WBS element. Below is the output i have received. What is the problem in obtaining the Order.
Normally in PM / PS, we have assignment of WBS Element, now you need to tell us, how the WBS element is linked with Process Order.
If you cannot get the output here, then you will a different table to obtain the relation and pass the process order number to AUFK to get the object number
Regards
Terence
Hi Gaurav,
have you checked the table AUFK for field PSPEL using the order type for the PO?
Regards
Sammar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I am not able to see actual cost posted on WBS through order in RPSCO & COEP table but i notice that cost in SLR58 & CJI3 report. Please suggest.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.