update routine - date difference need to be calculated
-
Hi,
I have a report for which I need to add 6 keyfigure fields.
I need abap code to add to my update routine
They are:
Early – ZEARLYDT
On Time – ZONTIME
Late – ZLATEDT
Early%
On Time%
Late%
The is what the scenario is:
If Completion Date (ZCOMP_DT) < Request Date (ZRQEND_DT) then,
Early = 1, OnTime = 0, Late = 0
If Completion Date (ZCOMP_DT) = Request Date (ZRQEND_DT) then,
Early = 0, On Time = 1, Late = 0
If Completion Date (ZCOMP_DT) > Request Date (ZRQEND_DT) then,
Early = 0, On Time = 0, Late = 1
If Early = 1, Early% = 100%
If Early = 0, Early% = 0%
If On Time = 1, On Time% = 100%
If On Time = 0, On Time% = 0%
If Late = 1, Late% = 100%
If Late = 0, late% = 0%
QMMA/JCDS – Source Table(s) for "Complete Date"
"PETER" – Source Field for "Complete Date"
QMEL – Source Table for "Request Date"
LTRMN – Source Field for "Request Date"
--
Bluesky
