2006 Dec 31 6:14 AM
hi all,
may i know how and what table should i refer to for fiscal month in select-options.
i cannot use parameter as below for from month and to month as besides range, user requests to allow input individual month.
if possible, besides fiscal month, what table should refer to for fiscal year also.
PARAMETER p_mont1(2) TYPE n OBLIGATORY.
PARAMETER p_mont2(2) TYPE n OBLIGATORY.
thanks alot
hi all,
may i know how and what table should i refer to for fiscal month in select-options.
i cannot use parameter as below for from month and to month as besides range, user requests to allow input individual month.
if possible, besides fiscal month, what table should refer to for fiscal year also.
PARAMETER p_mont1(2) TYPE n OBLIGATORY.
PARAMETER p_mont2(2) TYPE n OBLIGATORY.
thanks alot
2006 Dec 31 7:49 PM
When working with periods(months), I usually try to use period and year together. For this I use the SPBUP data element. You can see this used in table MCS1. This will allow your user to enter values like 01/2007 in the input field and the internal format is 200701
Or you can check out table T009B for other fields like POPER and BDATJ
Regards,
RIch Heilman
2007 Jan 01 9:32 AM
Dear e l,
Please use Fiscal Year Period (MARD-LFMON).
Using this would resolve your problem. You can get hold of a range of months.
SELECT-OPTIONS: S_MON FOR MARD-LFMON.
Regards,
Abir
*******************************************
Please don't forget to award points *