topic Re: Date fetching from table in Application Development and Automation Discussions

Date fetching from table

Former Member — Tue, 08 Aug 2006 07:16:09 GMT

I have a customized table which contains monthwise details.say 12 entries for an year.I want to fetch the previous 5 month entries from the table wrto sy-datum.

ie) if the month is 08 , then i want the records frm 03-07.

ie) if the month is 02, i want the records 01,12,11,10,09.

What logic to use?

Rgds,

SAPUSER100

Re: Date fetching from table

naimesh_patel — Tue, 08 Aug 2006 07:19:17 GMT

Hello,

ranges: r_mon for monat.

l_month = sy_datum+4(2) - 5.

do 5 times.

r_mon-sign = 'I'.

r_mon-option = 'EQ'.

r_mon-low = l_month.

append r_mon.

l_mont = l_month + 1.

if l_month > 12.

l_month = 1.

endif.

enddo.

regards,

Naimesh

Re: Date fetching from table

Former Member — Tue, 08 Aug 2006 07:34:29 GMT

hi ,

how you fetch it from an itab ?

hav to use READ st by comparing two tables or any direct way is possible ?

Re: Date fetching from table

naimesh_patel — Tue, 08 Aug 2006 07:41:39 GMT

Hello,

You have to also consider the year in your selection. so, change in the logic ...

data: begin of r_mon occurs 0,

mon(2),

year(4),

end of r_mon.

l_month = sy_datum+4(2) - 1.

l_year = sy_datum+0(4).

do 5 times.

r_mon-mon = l_month.

r_mon-year = l_year.

append r_mon.

clear r_mon

l_mont = l_month - 1.

if l_month = 0 .

l_month = 12.

l_year = sy_datum+0(4) - 1.

endif.

enddo.

Once you got filled your range of the Month,

I would advice like,

loop at r_mon.

select * from ztab

appending table itab

where mon = r_mon-mon

and year = r_mon-year.

endloop.

Regards,

Naimesh

Re: Date fetching from table

Former Member — Tue, 08 Aug 2006 07:55:14 GMT

Hi everyone,

just a tip: I've worked a lot with date manipulation and I had a lot of tiny problems when doing so manually, you know month 13 or month 00...

Then my lazyness wakes up and then I think: "let another one do the job for you". So if you use function module ADD_TIME_TO_DATE, you'll avoid some headaches.

Best regards,

Alvaro

Re: Date fetching from table

Former Member — Tue, 08 Aug 2006 09:21:45 GMT

Just try out this function module.Using this you can solve your problem,i guess. Execute it in SE37 and see if it is giving the required result for you.

CCM_GO_BACK_MONTHS

Regards,

Vijay Penumaka

Re: Date fetching from table

Former Member — Tue, 08 Aug 2006 09:29:47 GMT

even you can check this function module,

/BEV4/PLPS__ADD_MONTH_TO_DATE

say -5 in months & give data is current date.

this works fine.

regards

srikanth