‎2008 Jul 09 6:33 AM
Provide validation in selection screen to restrict the users to enter only four digit account codes. Provide dropdown functionality to show the four digit statutory accounts list to allow users to select the required account from the list. When four digit account code is entered, select all the related six and eight digit account codes. Get all the accounting data for the selected accounts and diplay the data based on the level entered in the selection screen.
rewards will be given.
‎2008 Jul 09 6:39 AM
either use some search-help or do programming in AT SELECTION-SCREEN OUTPUT event
‎2008 Jul 09 6:46 AM
Hi,
take the 4 digit numbers into a seperate internal
table then pass it to the bellow fm.
CALL FUNCTION 'POPUP_WITH_TABLE_DISPLAY'
EXPORTING
ENDPOS_COL = 85
ENDPOS_ROW = 15
STARTPOS_COL = 35
STARTPOS_ROW = 6
TITLETEXT = 'Title'
IMPORTING
CHOISE = ITAB
TABLES
VALUETAB = IKNA1
EXCEPTIONS
BREAK_OFF = 1
OTHERS = 2.
IF SY-SUBRC <> 0.
MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
ENDIF.
‎2008 Jul 09 6:49 AM
Hi
For validation
At selection-screen on (select-option1)-low.
At selection-screen on (select-option1)-high.
Regards
Aditya
‎2008 Jul 09 7:41 AM
Hi,
U can set the limit to four digit using select options and then setting the High and Low limits.
Also you can do it by using search help.
Regards,
Manish
‎2008 Jul 09 8:56 AM
1:example
type-pools: vrm.
data: it_val type vrm_values,
w_line like line of it_val,
wa_line like w_line occurs 0.
parameters P_ACCOUN(4) as listbox visible length 4 obligatory.
--
initialization.
w_line-key = '0001'.
w_line-text = '0001'.
append w_line to it_val.
w_line-key = '0002'.
w_line-text = '0002'.
append w_line to it_val.
w_line-key = '0003'.
w_line-text = '0003'.
append w_line to it_val.
w_line-key = '0004'.
w_line-text = '0004'.
append w_line to it_val.
w_line-key = '0005'.
w_line-text = '0005'.
append w_line to it_val.
......
--
at selection-screen output.
call function 'VRM_SET_VALUES'
exporting
id = 'P_ACCOUN'
values = it_val.
2:
DATA:P_ACCOUNT TYPE ACCOUNT.
CONCATENATE P_ACCOUN '*' INTO P_ACCOUNT.
SELECT
.....
FROM TABLE
....
WHERE
....
AND ACCOUNT LIKE P_ACCOUNT
...
....
‎2008 Jul 09 9:14 AM
Hi get all acounts into one internal table.
LOOP AT itab INTO wa.
wa1-field = wa-field+0(4).
APPEND wa1 TO itab1.
CLEAR wa1.
ENDLOOP.
display itab1 in search help.
dynnr = sy-dynnr.
repid = sy-repid.
CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'
EXPORTING
RETFIELD = 'FIELD'
DYNPPROG = repid
DYNPNR = dynnr
DYNPROFIELD = 'ITAB1-FIELD'
VALUE_ORG = 'S'
TABLES
VALUE_TAB = itab1.
pass selected account 4 digit code into anthor table n get all acount detail data.
‎2008 Jul 09 9:19 AM
hi,
you can use at selection-screen on upper and lower limits of the field.
thanks