2008 Jul 02 12:32 PM
hi gurus,
i have 3 fields on sel-screen.one for date of creation of sales order in range and three radiobuttons for yearly, quartly and monthly display of sales order.
i am creating this pgm to run in background.
pls, help me out to write a logic to break varint at run time.
for eg. if i m inputin 1jan 2007 to 15 feb 2007 than on monthly selection it should give 2 steps: 1 for 1jan to 31 jan and 2nd
for 1feb to 15 feb.
similarly, on quartly selection it will retrieve for 1jan to 15 feb.
pls, help me out to write a logic for this requirement.
it is very urgent...
pleeesee reply it immediatly
2008 Jul 02 12:58 PM
I suggest that you build an internal table with start date/end date for each interval that you have to output
take the date range from selection screen and loop on years / quarters / months according to radio button
then select data from database between first start date and last end date
do a LOOP on internal table containing intervals and collect data for it
2008 Jul 02 12:55 PM
Hi,
write a second report splittin dates as subscribed. SUBMIT the already existing report several times.
Spool might be a problem - EXPORT spool to MEMORY and IMPORT might solve the problem.
Better: plan differnt steps of the jopb for each period. If thsi must be done dynmically you may use function JOB_START to shedule jobs at runtime.
have fun,
HP
2008 Jul 02 12:58 PM
I suggest that you build an internal table with start date/end date for each interval that you have to output
take the date range from selection screen and loop on years / quarters / months according to radio button
then select data from database between first start date and last end date
do a LOOP on internal table containing intervals and collect data for it