Current Position:Home > Two colums in F4 help

Two colums in F4 help

Update:11-30Source: network consolidation
Advertisement
Hi Folks,
i want to restirct the hit list in selection screen( F4 hlp). i am using the FM F4IF_INT_TABLE_VALUE_REQUEST. my requirment is i want display the filed Cred.rep.grp(KNKK-SBGRP) along with another field Cred.contr.area(KNKK-KKBER) in the same window.
please tell me ho to dispaly the two colum in one f4 help screen?
thanks in advance
regards
p r i y a

The Best Answer

Advertisement
Hi Priya,
You can do as Rich said to include two fields in your internal table and if you want to read multiple values based on the F4 selection, look at this code.
=======================================================
parameter: p_fname like z340b_md-fname.
tables: z340b.
DATA: BEGIN OF itab_details OCCURS 0,
ID like z340b_md-id,
fname like z340b_md-fname,
lname like z340b_md-lname.
DATA: END OF itab_details.
DATA it_return LIKE ddshretval OCCURS 0 WITH HEADER LINE.
SELECT * FROM z340b_md INTO CORRESPONDING FIELDS OF
itab_details WHERE fname eq p_fname.
APPEND itab_details.
ENDSELECT.
SORT itab_details BY ID.
CLEAR itab_details.
CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'
EXPORTING
retfield = 'ID'
window_title = 'Physicians details'
value_org = 'S'
TABLES
value_tab = itab_details
return_tab = it_return
EXCEPTIONS
parameter_error = 1
no_values_found = 2
OTHERS = 3.
IF sy-subrc = 0.
CLEAR itab_details.
READ TABLE it_return INDEX 1.
itab_details-ID = it_return-fieldval.
READ TABLE itab_details WITH KEY ID = itab_details-ID.
if sy-subrc eq 0.
write: / 'id:', itab_details-id.
write: / 'firstname:' , itab_details-fname.
write: / 'lastname:' , itab_details-lname.
endif.
ENDIF.
REFRESH itab_details. CLEAR: itab_details.
=======================================================
The idea is that, FM 'F4IF_INT_TABLE_VALUE_REQUEST' returns one value which you use to read the values of other fields from the internal table.
hope this will help you.
Regards,
Vivek
PS: Award points if helpful
  • Chnage colum from CLOB to Varchar2 and find the length of CLOB Update:10-11

    Hi, I have got tables contain CLOB fields. I want to converter them to varchar2? Is the a way to do it? how can I find the max of length the data in CLOB fields. Thanks in advance!! MichaelHi All, Thanks you for your useful information. What I need i

  • Colum names mapping from formate file is not working Update:10-11

    Hi All, i tried to import data from text file using BULK INSERT format file option, am able to load the data from file to table but when i change the column name order in the input file it is not inserting according to change column order  BULK INSER

  • Report Structure based CKF percentage total colume Error Update:10-11

    Dear Guru's In Report Created structure in Rows structure created formulas for sub total, CKF using in colume for finding percentage on sale, where formula used in structure, percentage also adding instead of average. Applied exception aggregation fo

  • How to total 2 colums with an -If then else- statement each Update:10-11

    Hello, I have 2 colums A en B who generate data based on an "If then else" statement. Colum A <?xdofx:if (OMZET_YTD_VJ )!='' then ((OMZET_YTD_VJ) * (BM_YTD - BM_YTD_VJ)) div 100 else 0 end if?> Colum B <?xdofx:if (BM_YTD)!='' then ((BM_

  • Display Image in Report Colum,  ORA-06502: PL/SQL whe column format is set Update:10-11

    Hi @all i created a small table CREATE TABLE my_sal201 ( grafikdid VARCHAR2(38) NULL, grafik BLOB NULL, mimetype VARCHAR2(255) NULL then i inserted one column with a page process BEGIN IF (:p6_filename IS NOT NULL) THEN INSERT INTO my_sal201 (grafikd

  • How to use the Combo Box In MAtrix Colums Update:10-11

    HI Experts, Good Mornong.How to use the Combo Box In MAtrix Colums? Regards And Thanks, M.Thippa Reddyhi, loading data in to the combobox on form load.but, it should be done when atleast one row is active. the values what ever you are inserting in to

  • How to find table with colum that not support by data pump network_link Update:10-11

    Hi Experts, We try to import a database to new DB by data pump network_link. as oracle statement, Tables with columns that are object types are not supported in a network export. An ORA-22804 error will be generated and the export will move on to the

  • How to find colums in CLOB variable and get this colums value to update col Update:10-11

    Question How to find colums in CLOB variable and get this colums value to update colum of oracle database table How my work will go Step-1 - I am creating XML FIle which is based on code that we discused before- Its developing xml file with data in <

  • How to group the colume in Enterprise link design studio Update:10-11

    I want count a table record by group some columes,After checking all the transforms,I can't found the appropriate one,Please give me some advices,thanks.hi You have to create a plan to connect to the external message source, get the message and parse

  • How to find out if colums is defined as VARCHAR2 in bytes or char? Update:10-11

    Hello, I'd like to know if it is possible to find out if a colum table (or view) is defined as a VARCHAR2 in bytes or in CHAR on Oracle 10g. When I do a desc, it shows only VARCHAR2 with its length but not if it is bytes or char. How can I know for s