
2008-7-4 10:32
robinho_lu
abap中select 怎麼取SY-DATUM的年月
初寫abap遇到點問題,請大家幫我!
1.select 怎麼可以取sy-datum或其他欄位的年月
2.如何在SELECT-OPTIONS中寫可以選年月,而不是年月日的
2008-7-4 10:47
ryq0000
1.SY-DATUM+(6)就是年月了.
2.POPUP_TO_SELECT_MONTH这个函数可以.
eg.:
PARAMETER: p_month LIKE isellist-month.
DATA: l_code LIKE sy-subrc.
AT SELECTION-SCREEN ON VALUE-REQUEST FOR p_month.
CALL FUNCTION 'POPUP_TO_SELECT_MONTH'
EXPORTING
actual_month = '200807'
language = sy-langu
start_column = 8
start_row = 5
IMPORTING
selected_month = p_month
return_code = l_code
EXCEPTIONS
factory_calendar_not_found = 1
holiday_calendar_not_found = 2
month_not_found = 3
OTHERS = 4.
[[i] 本帖最后由 ryq0000 于 2008-7-4 10:49 编辑 [/i]]
2008-7-4 10:47
robinho_lu
各位高手也幫幫忙!在線等啊!
再出不來要死人了
2008-7-4 10:49
ryq0000
[quote]原帖由 [i]robinho_lu[/i] 于 2008-7-4 10:47 发表 [url=http://www.itpub.net/redirect.php?goto=findpost&pid=10851563&ptid=1016491][img]http://www.itpub.net/images/common/back.gif[/img][/url]
各位高手也幫幫忙!在線等啊!
再出不來要死人了 [/quote]
不是已经写给你了吗,兄弟.
2008-7-4 10:58
xiebinren
在网上搜索了没?
2008-7-4 11:02
robinho_lu
[quote]原帖由 [i]ryq0000[/i] 于 2008-7-4 10:49 发表 [url=http://www.itpub.net/redirect.php?goto=findpost&pid=10851589&ptid=1016491][img]http://www.itpub.net/images/common/back.gif[/img][/url]
不是已经写给你了吗,兄弟. [/quote]
謝謝大哥,
不過我用,提示沒有ISELLIST-MOTH,
幫我
SELECT-OPTIONS: S_BUKRS FOR BSID-BUKRS OBLIGATORY ,"公司代碼
[color=red]S_DATUM FOR isellist-month[/color] NO-EXTENSION. "收入期間
PARAMETERS: P_MONTH(2) TYPE N DEFAULT '6' ."資料抓取月份
SELECT-OPTIONS: S_KKBER FOR BSID-KKBER. "利潤中心
SELECTION-SCREEN END OF BLOCK bk1.
*PARAMETER: p_month LIKE isellist-month.
*AT SELECTION-SCREEN.
AT SELECTION-SCREEN ON VALUE-REQUEST FOR S_DATUM.
CALL FUNCTION 'POPUP_TO_SELECT_MONTH'
EXPORTING
actual_month = '200807'
language = sy-langu
start_column = 8
start_row = 5
IMPORTING
selected_month = S_DATUM
return_code = l_code
EXCEPTIONS
factory_calendar_not_found = 1
holiday_calendar_not_found = 2
month_not_found = 3
OTHERS = 4.
2008-7-4 11:11
ryq0000
[quote]原帖由 [i]robinho_lu[/i] 于 2008-7-4 11:02 发表 [url=http://www.itpub.net/redirect.php?goto=findpost&pid=10851797&ptid=1016491][img]http://www.itpub.net/images/common/back.gif[/img][/url]
謝謝大哥,
不過我用,提示沒有ISELLIST-MOTH,
幫我
SELECT-OPTIONS: S_BUKRS FOR BSID-BUKRS OBLIGATORY ,"公司代碼
S_DATUM FOR isellist-month NO-EXTENSION. "收入期間
PARAMETERS: P_MONTH(2) TYPE N DEFAULT '6' ."資料抓取月份
SELECT-OPTIONS: S_KKBER FOR BSID-KKBER. "利潤中心
SELECTION-SCREEN END OF BLOCK bk1.
*PARAMETER: p_month LIKE isellist-month.
*AT SELECTION-SCREEN.
AT SELECTION-SCREEN ON VALUE-REQUEST FOR S_DATUM.
CALL FUNCTION 'POPUP_TO_SELECT_MONTH'
EXPORTING
actual_month = '200807'
language = sy-langu
start_column = 8
start_row = 5
IMPORTING
selected_month = S_DATUM
return_code = l_code
EXCEPTIONS
factory_calendar_not_found = 1
holiday_calendar_not_found = 2
month_not_found = 3
OTHERS = 4. [/quote]
我有点小晕了啊,兄弟.
AT SELECTION-SCREEN ON VALUE-REQUEST FOR S_DATUM.
这一句的S_DATUM是P_MONTH啊,你看懂了没有啊?
2008-7-4 11:25
robinho_lu
[quote]原帖由 [i]ryq0000[/i] 于 2008-7-4 11:11 发表 [url=http://www.itpub.net/redirect.php?goto=findpost&pid=10851967&ptid=1016491][img]http://www.itpub.net/images/common/back.gif[/img][/url]
我有点小晕了啊,兄弟.
AT SELECTION-SCREEN ON VALUE-REQUEST FOR S_DATUM.
这一句的S_DATUM是P_MONTH啊,你看懂了没有啊? [/quote]
謝謝,有點看懂了啊!一個PARAMETERS可以選擇了!
我現在就是想要個選擇月份的區間
像SELECT-OPTIONS這樣的!或兩個PARAMETERS可不可以寫一行??
十分抱歉,我才上手,謝謝大哥
2008-7-4 12:21
ryq0000
[quote]原帖由 [i]robinho_lu[/i] 于 2008-7-4 11:25 发表 [url=http://www.itpub.net/redirect.php?goto=findpost&pid=10852278&ptid=1016491][img]http://www.itpub.net/images/common/back.gif[/img][/url]
謝謝,有點看懂了啊!一個PARAMETERS可以選擇了!
我現在就是想要個選擇月份的區間
像SELECT-OPTIONS這樣的!或兩個PARAMETERS可不可以寫一行??
十分抱歉,我才上手,謝謝大哥 [/quote]
1.你把SELECT-OPTIONS的变量p_month-LOW和p_month-HIGH分别传,试一下这样行不行.
2.兩個PARAMETERS并成一行,应该是可以的,要自己写位置了.比较麻烦.
你先试我第一种方法吧
2008-7-4 12:26
dreamgift
呵呵..
2008-7-4 14:13
dreamgift
[quote]原帖由 [i]ryq0000[/i] 于 2008-7-4 10:47 发表 [url=http://www.itpub.net/redirect.php?goto=findpost&pid=10851558&ptid=1016491][img]http://www.itpub.net/images/common/back.gif[/img][/url]
1.SY-DATUM+(6)就是年月了.
2.POPUP_TO_SELECT_MONTH这个函数可以.
eg.:
PARAMETER: p_month LIKE isellist-month.
DATA: l_code LIKE sy-subrc.
AT SELECTION-SCREEN ON VALUE-REQUEST FOR p_month.
CALL FUNCTION 'POPUP_TO_SELECT_MONTH'
EXPORTING
actual_month = '200807'
language = sy-langu
start_column = 8
start_row = 5
IMPORTING
selected_month = p_month
return_code = l_code
EXCEPTIONS
factory_calendar_not_found = 1
holiday_calendar_not_found = 2
month_not_found = 3
OTHERS = 4. [/quote]
:right:
页:
[1]

Powered by ITPUB论坛