Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

IN ALV

Former Member
0 Likes
855

PLZ SOLVE MY QUERY...........

if i give input like matnr in selection screen as to get upto labst1

fcat-row_pos = 1.

FCAT-SELTEXT_L = 'SRL_NO'.

FCAT-COL_POS = W_POS.

FCAT-FIELDNAME = 'SLNO'.

FCAT-TABNAME = 'IT_FINAL'.

LAYOUT1-COLWIDTH_OPTIMIZE = 'X'.

APPEND FCAT.

CLEAR FCAT.

w_pos = w_pos + 1.

FCAT-SELTEXT_L = 'PARENT'.

FCAT-COL_POS = W_POS.

FCAT-FIELDNAME = 'PMATNR'.

FCAT-TABNAME = 'IT_FINAL'.

FCAT-NO_OUT = 'X'.

LAYOUT1-COLWIDTH_OPTIMIZE = 'X'.

APPEND FCAT.

CLEAR FCAT.

w_pos = w_pos + 1.

FCAT-SELTEXT_L = 'Tube S/A'.

FCAT-COL_POS = W_POS.

FCAT-FIELDNAME = 'IDNRK1'.

FCAT-IFIELDNAME = 'IDNRK1'.

FCAT-TABNAME = 'IT_FINAL'.

LAYOUT1-COLWIDTH_OPTIMIZE = 'X'.

APPEND FCAT.

CLEAR FCAT.

w_pos = w_pos + 1.

FCAT-SELTEXT_L = 'Tube Quantity'.

FCAT-COL_POS = W_POS.

FCAT-FIELDNAME = 'LABST1'.

FCAT-FIELDNAME = 'LABST1'.

FCAT-NO_ZERO = 'X'.

FCAT-FIX_COLUMN = 'X'.

FCAT-TABNAME = 'IT_FINAL'.

LAYOUT1-COLWIDTH_OPTIMIZE = 'X'.

APPEND FCAT.

CLEAR FCAT.

clear fcat.

w_pos = w_pos + 1.

FCAT-SELTEXT_L = 'P.Rod S/A'.

FCAT-COL_POS = W_POS.

FCAT-FIELDNAME = 'IDNRK2'.

FCAT-IFIELDNAME = 'IDNRK2'.

FCAT-TABNAME = 'IT_FINAL'.

LAYOUT1-COLWIDTH_OPTIMIZE = 'X'.

APPEND FCAT.

CLEAR FCAT.

w_pos = w_pos + 1.

FCAT-SELTEXT_L = 'P.Rod S/A Quantity'.

FCAT-COL_POS = W_POS.

FCAT-FIELDNAME = 'LABST2'.

FCAT-TABNAME = 'IT_FINAL'.

FCAT-NO_ZERO = 'X'.

LAYOUT1-COLWIDTH_OPTIMIZE = 'X'.

APPEND FCAT.

CLEAR FCAT.

w_pos = w_pos + 1.

FCAT-SELTEXT_L = 'Port A/S'.

FCAT-COL_POS = W_POS.

FCAT-FIELDNAME = 'IDNRK4'.

FCAT-TABNAME = 'IT_FINAL'.

LAYOUT1-COLWIDTH_OPTIMIZE = 'X'.

APPEND FCAT.

CLEAR FCAT.

w_pos = w_pos + 1.

FCAT-SELTEXT_L = 'Port Quantity'.

FCAT-COL_POS = W_POS.

FCAT-FIELDNAME = 'LABST4'.

FCAT-NO_ZERO = 'X'.

FCAT-TABNAME = 'IT_FINAL'.

LAYOUT1-COLWIDTH_OPTIMIZE = 'X'.

APPEND FCAT.

CLEAR FCAT.

w_pos = w_pos + 1.

FCAT-SELTEXT_L = 'Pipe'.

FCAT-COL_POS = W_POS.

FCAT-FIELDNAME = 'IDNRK5'.

FCAT-TABNAME = 'IT_FINAL'.

LAYOUT1-COLWIDTH_OPTIMIZE = 'X'.

APPEND FCAT.

CLEAR FCAT.

w_pos = w_pos + 1.

FCAT-SELTEXT_L = 'Pipe Quantity'.

FCAT-COL_POS = W_POS.

FCAT-FIELDNAME = 'LABST5'.

FCAT-NO_ZERO = 'X'.

FCAT-TABNAME = 'IT_FINAL'.

LAYOUT1-COLWIDTH_OPTIMIZE = 'X'.

APPEND FCAT.

CLEAR FCAT.

w_pos = w_pos + 1.

FCAT-SELTEXT_L = 'Pipe S/A'.

FCAT-COL_POS = W_POS.

FCAT-FIELDNAME = 'IDNRK6'.

FCAT-TABNAME = 'IT_FINAL'.

LAYOUT1-COLWIDTH_OPTIMIZE = 'X'.

APPEND FCAT.

CLEAR FCAT.

w_pos = w_pos + 1.

FCAT-SELTEXT_L = 'Pipe S/A Quantity'.

FCAT-COL_POS = W_POS.

FCAT-FIELDNAME = 'LABST6'.

FCAT-NO_ZERO = 'X'.

FCAT-TABNAME = 'IT_FINAL'.

LAYOUT1-COLWIDTH_OPTIMIZE = 'X'.

APPEND FCAT.

CLEAR FCAT.

w_pos = w_pos + 1.

FCAT-SELTEXT_L = 'Spare Seal Kit'.

FCAT-COL_POS = W_POS.

FCAT-FIELDNAME = 'IDNRK3'.

FCAT-TABNAME = 'WA_FINAL'.

LAYOUT1-COLWIDTH_OPTIMIZE = 'X'.

APPEND FCAT.

CLEAR FCAT.

w_pos = w_pos + 1.

FCAT-SELTEXT_L = 'Pipe S/A Quantity'.

FCAT-COL_POS = W_POS.

FCAT-FIELDNAME = 'LABST3'.

FCAT-NO_ZERO = 'X'.

FCAT-TABNAME = 'IT_FINAL'.

LAYOUT1-COLWIDTH_OPTIMIZE = 'X'.

APPEND FCAT.

CLEAR FCAT.

PLZ SOLVE MY QUERY...........

if i give input like matnr in selection screen as to get upto labst1

fcat-row_pos = 1.

FCAT-SELTEXT_L = 'SRL_NO'.

FCAT-COL_POS = W_POS.

FCAT-FIELDNAME = 'SLNO'.

FCAT-TABNAME = 'IT_FINAL'.

LAYOUT1-COLWIDTH_OPTIMIZE = 'X'.

APPEND FCAT.

CLEAR FCAT.

w_pos = w_pos + 1.

FCAT-SELTEXT_L = 'PARENT'.

FCAT-COL_POS = W_POS.

FCAT-FIELDNAME = 'PMATNR'.

FCAT-TABNAME = 'IT_FINAL'.

FCAT-NO_OUT = 'X'.

LAYOUT1-COLWIDTH_OPTIMIZE = 'X'.

APPEND FCAT.

CLEAR FCAT.

w_pos = w_pos + 1.

FCAT-SELTEXT_L = 'Tube S/A'.

FCAT-COL_POS = W_POS.

FCAT-FIELDNAME = 'IDNRK1'.

FCAT-IFIELDNAME = 'IDNRK1'.

FCAT-TABNAME = 'IT_FINAL'.

LAYOUT1-COLWIDTH_OPTIMIZE = 'X'.

APPEND FCAT.

CLEAR FCAT.

w_pos = w_pos + 1.

FCAT-SELTEXT_L = 'Tube Quantity'.

FCAT-COL_POS = W_POS.

FCAT-FIELDNAME = 'LABST1'.

FCAT-FIELDNAME = 'LABST1'.

FCAT-NO_ZERO = 'X'.

FCAT-FIX_COLUMN = 'X'.

FCAT-TABNAME = 'IT_FINAL'.

LAYOUT1-COLWIDTH_OPTIMIZE = 'X'.

APPEND FCAT.

CLEAR FCAT.

clear fcat.

w_pos = w_pos + 1.

FCAT-SELTEXT_L = 'P.Rod S/A'.

FCAT-COL_POS = W_POS.

FCAT-FIELDNAME = 'IDNRK2'.

FCAT-IFIELDNAME = 'IDNRK2'.

FCAT-TABNAME = 'IT_FINAL'.

LAYOUT1-COLWIDTH_OPTIMIZE = 'X'.

APPEND FCAT.

CLEAR FCAT.

w_pos = w_pos + 1.

FCAT-SELTEXT_L = 'P.Rod S/A Quantity'.

FCAT-COL_POS = W_POS.

FCAT-FIELDNAME = 'LABST2'.

FCAT-TABNAME = 'IT_FINAL'.

FCAT-NO_ZERO = 'X'.

LAYOUT1-COLWIDTH_OPTIMIZE = 'X'.

APPEND FCAT.

CLEAR FCAT.

w_pos = w_pos + 1.

FCAT-SELTEXT_L = 'Port A/S'.

FCAT-COL_POS = W_POS.

FCAT-FIELDNAME = 'IDNRK4'.

FCAT-TABNAME = 'IT_FINAL'.

LAYOUT1-COLWIDTH_OPTIMIZE = 'X'.

APPEND FCAT.

CLEAR FCAT.

w_pos = w_pos + 1.

FCAT-SELTEXT_L = 'Port Quantity'.

FCAT-COL_POS = W_POS.

FCAT-FIELDNAME = 'LABST4'.

FCAT-NO_ZERO = 'X'.

FCAT-TABNAME = 'IT_FINAL'.

LAYOUT1-COLWIDTH_OPTIMIZE = 'X'.

APPEND FCAT.

CLEAR FCAT.

w_pos = w_pos + 1.

FCAT-SELTEXT_L = 'Pipe'.

FCAT-COL_POS = W_POS.

FCAT-FIELDNAME = 'IDNRK5'.

FCAT-TABNAME = 'IT_FINAL'.

LAYOUT1-COLWIDTH_OPTIMIZE = 'X'.

APPEND FCAT.

CLEAR FCAT.

w_pos = w_pos + 1.

FCAT-SELTEXT_L = 'Pipe Quantity'.

FCAT-COL_POS = W_POS.

FCAT-FIELDNAME = 'LABST5'.

FCAT-NO_ZERO = 'X'.

FCAT-TABNAME = 'IT_FINAL'.

LAYOUT1-COLWIDTH_OPTIMIZE = 'X'.

APPEND FCAT.

CLEAR FCAT.

w_pos = w_pos + 1.

FCAT-SELTEXT_L = 'Pipe S/A'.

FCAT-COL_POS = W_POS.

FCAT-FIELDNAME = 'IDNRK6'.

FCAT-TABNAME = 'IT_FINAL'.

LAYOUT1-COLWIDTH_OPTIMIZE = 'X'.

APPEND FCAT.

CLEAR FCAT.

w_pos = w_pos + 1.

FCAT-SELTEXT_L = 'Pipe S/A Quantity'.

FCAT-COL_POS = W_POS.

FCAT-FIELDNAME = 'LABST6'.

FCAT-NO_ZERO = 'X'.

FCAT-TABNAME = 'IT_FINAL'.

LAYOUT1-COLWIDTH_OPTIMIZE = 'X'.

APPEND FCAT.

CLEAR FCAT.

w_pos = w_pos + 1.

FCAT-SELTEXT_L = 'Spare Seal Kit'.

FCAT-COL_POS = W_POS.

FCAT-FIELDNAME = 'IDNRK3'.

FCAT-TABNAME = 'WA_FINAL'.

LAYOUT1-COLWIDTH_OPTIMIZE = 'X'.

APPEND FCAT.

CLEAR FCAT.

w_pos = w_pos + 1.

FCAT-SELTEXT_L = 'Pipe S/A Quantity'.

FCAT-COL_POS = W_POS.

FCAT-FIELDNAME = 'LABST3'.

FCAT-NO_ZERO = 'X'.

FCAT-TABNAME = 'IT_FINAL'.

LAYOUT1-COLWIDTH_OPTIMIZE = 'X'.

APPEND FCAT.

CLEAR FCAT.

7 REPLIES 7
Read only

Former Member
0 Likes
831

what do you mean by this..

if i give input like matnr in selection screen as to get upto labst1

Read only

0 Likes
831

think that there are 5 col........... like 101 to 105............

if i give input as a 101or 102 or 103 based on input its display

Read only

0 Likes
831

you will enter the column name in the selection screen.

Assume Input MATNR.

then

using the input check the values.

FIELDCAT-FIELDNAME = 'MATNR'.

IF INPUT <> FIELDCAT-FIELDNAME.

FIELDCAT-NO_OUT = 'X'.

ENDIF.

APPEND FIELDCAT.

CLEAR FIELDCAT.

FIELDCAT-FIELDNAME = 'LABST1'.

IF INPUT <> FIELDCAT-FIELDNAME.

FIELDCAT-NO_OUT = 'X'.

ENDIF.

APPEND FIELDCAT.

CLEAR FIELDCAT.

Now only one column will be displayed which is MATNR.

Read only

0 Likes
831

in selection screen i will enter values like cwm103* (fld is matnr)

for this input i as t get idnrk1 labst1 slno plz check the code ihad send ..........

Read only

0 Likes
831

in selection screen i will enter values like cwm103* (fld is matnr)

for this input i as t get idnrk1 labst1 slno plz check the code ihad send ..........

your post Question is not clear and your code is not clear

so if you enter the material , you are getting the values. but what to hide . are you talking about Filter Option in ALV.

Read only

0 Likes
831

can send source code on hide options it will very helpful

Read only

0 Likes
831

hi vijay

can send u r mail id