‎2009 Jan 12 10:56 AM
Hi Friends,
i am using a value help for screen field belnr.
when i hit f4 on the screen input field , i should get a window like we get in MM03 , on f4 for the material.
please give appropriate help.
thanks,
kat
‎2009 Jan 12 11:03 AM
‎2009 Jan 12 11:20 AM
I'm using a custom table. in which i need to add a search help with a popup window , which could enable me to select only one line item rather than displaying all the details.
‎2009 Jan 12 11:27 AM
Hi kat,
Try with the logic what I have mentioned. change the table from BSIK to your custom table.
Regards,
Phani.
‎2009 Jan 12 11:05 AM
Hi,
since BELNR is a structure.
If there is no standard search help , create it in screen painter for that feild.
Regards,
Phani.
‎2009 Jan 12 11:06 AM
Hi,
If you want F4 help for belnr , then declare the screen field as belnr along with the table name.
regards,
Advait
‎2009 Jan 12 11:09 AM
Hi Kat,
Create your own custom search help for the BELNR field in the selection screen.
by using the FM F"4IF_INT_TABLE_VALUE_REQUEST"
types : begin of gt_belnr,
bukrs type bukrs,
belnr type belnr_d,
end of gt_blenr.
parameter : p_bukrs like bsik-bukrs oblidatory default '1000'.
p_belnr like bsik-belnr.
AT SELECTION-SCREEN ON VALUE-REQUEST FOR p_belnr.
PERFORM f4help_belnr.
form f4help_belnr.
retrieve data from BSIK based on the company code into the table like format
DATA: lt_return TYPE STANDARD TABLE OF ddshretval.
DATA: ls_return TYPE ddshretval.
CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'
EXPORTING
retfield = 'BELNR'
value_org = 'S'
TABLES
value_tab = gt_belnr
return_tab = lt_return
EXCEPTIONS
parameter_error = 1
no_values_found = 2
OTHERS = 3.
READ TABLE lt_return INTO ls_return INDEX 1.
IF sy-subrc EQ 0.
MOVE ls_return-fieldval TO p_belnr.
CLEAR : ls_return.
ENDIF.
endform.
try with the above logic. this may help you.
Regards,
phani.
‎2009 Jan 12 11:28 AM
hi,
Following Code will help you out in this way in the bellow code i am selecting the RSM With Respect to Customer and then select ASM the People under RSM and then CR the all People under ASM,
Hope this will help you lot.
data: i_return type ddshretval occurs 0 with header line,
c type c value 'S'.
Search Help for RSM
at selection-screen on value-request for sorsmid-low.
types: begin of t_sh_rsmid,
rsmid like zsdo-rsmid,
ename like pa0001-ename,
end of t_sh_rsmid.
data: it_sh_rsmid type standard table of t_sh_rsmid with header line.
select distinct zsdorsmid pa0001ename
into corresponding fields of table it_sh_rsmid
from zsdo left outer join pa0001 on ( zsdorsmid = pa0001pernr and pa0001~endda = '99991231' )
where zsdo~kunnr in sokunnr.
delete it_sh_rsmid where rsmid = '00000000'.
sort it_sh_rsmid by rsmid.
call function 'F4IF_INT_TABLE_VALUE_REQUEST'
exporting
retfield = 'RSMID'
dynpprog = sy-repid
dynpnr = sy-dynnr
dynprofield = 'rsmid'
value_org = c
tables
value_tab = it_sh_rsmid
return_tab = i_return.
Search Help for ASM
at selection-screen on value-request for soasmid-low.
types: begin of t_sh_asmid,
asmid like zsdo-asmid,
ename like pa0001-ename,
end of t_sh_asmid.
data: it_sh_asmid type standard table of t_sh_asmid with header line.
select distinct zsdoasmid pa0001ename
into corresponding fields of table it_sh_asmid
from zsdo left outer join pa0001 on ( zsdoasmid = pa0001pernr and pa0001~endda = '99991231' )
where zsdo~kunnr in sokunnr.
delete it_sh_asmid where asmid = '00000000'.
sort it_sh_asmid by asmid.
call function 'F4IF_INT_TABLE_VALUE_REQUEST'
exporting
retfield = 'ASMID'
dynpprog = sy-repid
dynpnr = sy-dynnr
dynprofield = 'asmid'
value_org = c
tables
value_tab = it_sh_asmid
return_tab = i_return.
Search Help for CR
at selection-screen on value-request for socrid-low.
types: begin of t_sh_crid,
crid like zsdo-crid,
ename like pa0001-ename,
end of t_sh_crid.
data: it_sh_crid type standard table of t_sh_crid with header line.
select distinct zsdocrid pa0001ename
into corresponding fields of table it_sh_crid
from zsdo left outer join pa0001 on ( zsdocrid = pa0001pernr and pa0001~endda = '99991231' )
where zsdo~kunnr in sokunnr.
delete it_sh_crid where crid = '00000000'.
loop at it_sh_crid into it_sh_crid where crid '' and ename = ''.
count_loop = sy-tabix.
call function 'CONVERSION_EXIT_ALPHA_INPUT'
exporting
input = it_sh_crid-crid
importing
output = it_sh_crid-crid.
select single ename from pa0001 into it_sh_crid-ename where pernr = it_sh_crid-crid.
modify it_sh_crid from it_sh_crid index count_loop.
endloop.
sort it_sh_crid by crid.
delete adjacent duplicates from it_sh_crid comparing all fields.
call function 'F4IF_INT_TABLE_VALUE_REQUEST'
exporting
retfield = 'CRID'
dynpprog = sy-repid
dynpnr = sy-dynnr
dynprofield = 'crid'
value_org = c
tables
value_tab = it_sh_crid
return_tab = i_return.
‎2009 Jan 12 11:43 AM
Hi,
try this and look at the different F4-HELP.
SELECTION-SCREEN: SKIP.
PARAMETERS: P_MATNR0 LIKE MARA-MATNR MATCHCODE OBJECT MAT1.
SELECTION-SCREEN: SKIP 3.
PARAMETERS: P_MATNR1 LIKE MARA-MATNR MATCHCODE OBJECT MAT0M.
in se11 with MAT* on searchhelp you can see, what matchcode are possible.
Hope it helps.
Regards, Dieter
‎2009 Jan 12 11:52 AM
‎2009 Jan 12 12:01 PM
i think no one has under stood properly. i'm re wrting the issue
previous one
total 10 screen fields
3 are belnr , gjahr , bukrs
f4 is only available on belnr. when i click f4 on belnr and select any one value from the list all the 10 screen fields should fill automatically and this is happening now.
extension to previous one
when clicked f4 on same belnr. a popup window should come allowing me to enter only one line item i.e belnr should come and now here when i click f4 i should get the list of value if i have entered nothing else give one vaue if entered one only.
u can check the t code MM03.
i need the same way.
‎2009 Jan 12 2:31 PM
HI Kat,
Since you want two different outputs on F4 based on whether your belnr is already filled or not i can only suggest that you execute it through 'F4IF_INT_TABLE_VALUE_REQUEST'
On the event ON HELP-REQUEST check if the parameter for belnr has a value.. based on this either show the respective line items... or show a list of belnr that can be used for selection
Do revert if i dint understand ur reqrmnt.
‎2009 Jan 13 6:23 AM