on 10-18-2013 6:45 AM
Hi All,
I encounter an issue, please help me out from this trouble.
I check CJI3 report and found actual postings against registerd hours for a WBS period1 to 9.
And in a customize report we can see the registerd hours for period 1 to 9 for same WBS, but in both reports i get a difference of 731 hours.
Now i want to compare from where this diffrence is coming and trying to run both reports for every period one by one.
And each report i see the difference of hours as per below-
period | cji3 | z* | diffrence |
period1 | 18762.14 | 18762.14 | 0 |
period2 | 17250.06 | 17242.56 | 7.5 |
period3 | 17313.8 | 17358.55 | -44.75 |
period4 | 16550.98 | 16513.73 | 37.25 |
period5 | 15156.62 | 15179.12 | -22.5 |
period6 | 16888.03 | 16917.88 | -29.85 |
period7 | 16710.32 | 16657.97 | 52.35 |
period8 | 8503.91 | 11838.34 | -3334.43 |
period9 | 20560.00 | 16494.57 | 4065.43 |
total | 147695.86 | 146964.86 | 731 |
Now if I check both report from seprate periods and getting thousands of entries, so its not possible to check it 1 by 1 .
Any body can please suggest me how to proceed.
Thanking you in adavance.
Hi All,
Thanks for your replies.
Let me clarify about Z* report, in this we get all the registered hours only and against that we suppose to book the actual cost which should be displayed in CJI3.
Now here the situation is different, for some personnel numbers i checked randomely for different periods and found that double hours are available in CJI3, whereas in Z* report it is less for any perticular week.
So I can not check it manualy for each n every personel number & week.
Is it possible to find out the differences in a collective manner?
Thanking you all in advance.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You have already seen a difference, then you have to analyse for "this" difference where is the problem. It is possible you have more than one but at least you can start to analyse it. When you detect the logic of your problem it will be easy for you analyse the problem.
If you display duplicated hours in CJI3 this is because you have duplicated hours, and you have to check why in your Z* report there are missing.
Regards
Hi,
First thing you need to check what was the logic built in your Zreport.
Hours booked would be stored in CATSDB and then transferred would be seen CATSPS (here you can see X mark against field transferred)
In CJI3, costs and hours would be showing against PERNR number. So there is no question about. What I mean here though you booked your hours still yet to approve then those will not be seen in CJI3.
Coming to your Z report, you might have billed logic to display the hous when those werre booked along with costs also. Check with your ABAPer and if it was confirmed then chahge your logic to display hours as well costs also in Z then you will not see any differences.
One more thing you see in table AFRC - which display incorrect cost calculation against time booked means those hours are have issue. Also you can check CN30 - Post processing of time sheet.
Thanks,
Sudhakar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Vindhesh,
Check if you have used any filter in the report.
Also would suggest you to check Business transaction in CJI3 for each entry.
Regards
Tushar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vindhesh,
CJI3 only will display hours which costs have been transferred ( the controlling document have been generated)
Not sure what your Z* report is showing :
time registered in the system? or
time which cost have been transferred to controlling?
If your report is showing the time registered in the system you can have differences because it is possible some of this time have not been transferred the cost.
If you need more help I think you should provide more information about the Z* report.
Regards
User | Count |
---|---|
85 | |
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.