chakri
Member
Hi Folks,
Here is a requirement for my client to have the report in the format attached .and the requirement is as follows.
Could anyone suggest me the best approach for this kind of requirement.
3. Processing options:
Standard Work Hours per Day = Used 8 as by default
4. Tables Used:
F0007, F4801, F31122 and F4812H
F0007.CZMMCU = F4801.WAMCU
F0007.CZYR = Year (F4801.WASTRX)
F0007.CZMT = Month (F4801.WASTRX)
F4801.WADOCO = F31122.WTDOCO
F4801.WADOCO = F4812H.WDDOC
5. Data Selection:
Year = F0007.CZYR (Used Year as: 2007 by default)
Month = F0007.CZMT (Used Month from: 1-12 by default)
BU = F0007.CZMMCU (Used BU: 9855 by default)
6. Data Sequencing:
Year = F0007.CZYR
Month = F0007.CZMT
BU = F0007.CZMMCU
7. Report Template Available: Yes,
8. Requested Report Columns & Specifications:
Header Section:
Report & Version Number [i.e. Batch application ID],
Report Title “Monthwise Labour Revenue Summary” [Bold, Font size 14, Underlined],
Run Date [format dd/mm/yyyy]
Time [hr:mn:ss]
From: Month, Year & BU: User input from data selection values
Detailed Section:
S. No, = Auto generated as per sort order
Month Name = Smart field for the Period No. reflecting the month
No. of Jobs = Count F4801.WADOCO Grouped on Year & Month
No. of Tech. = Count F31122.WTAN8 Grouped by F31122.WTAN8 for Year / month
Working Days = Count No of days F0007.CZTD01 To:
F0007.CZTD31, where: W = Working Days for the month
Available Hours = Total number of technicians * Working Days * PO Value for the month
Utilised Hours = Total of F31122.WTHRW for the month and MCU
% Utilised = Utilised Hours / Available Hours * 100
Idle Hours = Working Hours – Utilised Hours
% Idle = Idle Hours / Available Hours * 100
Labour Revenue = If F812H.WDEXA = Blank, then Sum of F4812H.WDBTOL for the month
Average Rate = Labour Revenue / Utilised Hours
Footer Section: (Summary) Grand Total of :
Total No. of Jobs = Sum of No. of Jobs
Total No. of Technicians = Sum of technicians
Total Working Days = Sum of days
Total Available Hours = Sum of Hours
Total Utilised Hours = Sum of Utilised Hours
Total Idle Hours = Sum of Idle Hours
Total % Utilised = Sum of % Utilised
Total % Idle = Sum of % Idle
Total Labour Revenue = Sum of Labour Revenue
Total Average Rate = Sum of Average rate
Thanks in Advance
Kalyan
8.11 SP1/Oracle 10g/64Bit
Here is a requirement for my client to have the report in the format attached .and the requirement is as follows.
Could anyone suggest me the best approach for this kind of requirement.
3. Processing options:
Standard Work Hours per Day = Used 8 as by default
4. Tables Used:
F0007, F4801, F31122 and F4812H
F0007.CZMMCU = F4801.WAMCU
F0007.CZYR = Year (F4801.WASTRX)
F0007.CZMT = Month (F4801.WASTRX)
F4801.WADOCO = F31122.WTDOCO
F4801.WADOCO = F4812H.WDDOC
5. Data Selection:
Year = F0007.CZYR (Used Year as: 2007 by default)
Month = F0007.CZMT (Used Month from: 1-12 by default)
BU = F0007.CZMMCU (Used BU: 9855 by default)
6. Data Sequencing:
Year = F0007.CZYR
Month = F0007.CZMT
BU = F0007.CZMMCU
7. Report Template Available: Yes,
8. Requested Report Columns & Specifications:
Header Section:
Report & Version Number [i.e. Batch application ID],
Report Title “Monthwise Labour Revenue Summary” [Bold, Font size 14, Underlined],
Run Date [format dd/mm/yyyy]
Time [hr:mn:ss]
From: Month, Year & BU: User input from data selection values
Detailed Section:
S. No, = Auto generated as per sort order
Month Name = Smart field for the Period No. reflecting the month
No. of Jobs = Count F4801.WADOCO Grouped on Year & Month
No. of Tech. = Count F31122.WTAN8 Grouped by F31122.WTAN8 for Year / month
Working Days = Count No of days F0007.CZTD01 To:
F0007.CZTD31, where: W = Working Days for the month
Available Hours = Total number of technicians * Working Days * PO Value for the month
Utilised Hours = Total of F31122.WTHRW for the month and MCU
% Utilised = Utilised Hours / Available Hours * 100
Idle Hours = Working Hours – Utilised Hours
% Idle = Idle Hours / Available Hours * 100
Labour Revenue = If F812H.WDEXA = Blank, then Sum of F4812H.WDBTOL for the month
Average Rate = Labour Revenue / Utilised Hours
Footer Section: (Summary) Grand Total of :
Total No. of Jobs = Sum of No. of Jobs
Total No. of Technicians = Sum of technicians
Total Working Days = Sum of days
Total Available Hours = Sum of Hours
Total Utilised Hours = Sum of Utilised Hours
Total Idle Hours = Sum of Idle Hours
Total % Utilised = Sum of % Utilised
Total % Idle = Sum of % Idle
Total Labour Revenue = Sum of Labour Revenue
Total Average Rate = Sum of Average rate
Thanks in Advance
Kalyan
8.11 SP1/Oracle 10g/64Bit