2008 Jul 18 1:26 PM
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.
2008 Jul 18 1:29 PM
what do you mean by this..
if i give input like matnr in selection screen as to get upto labst1
2008 Jul 18 1:32 PM
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
2008 Jul 18 1:38 PM
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.
2008 Jul 18 1:44 PM
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 ..........
2008 Jul 18 1:48 PM
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.
2008 Jul 18 1:56 PM
2008 Jul 21 4:16 PM
| User | Count |
|---|---|
| 4 | |
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |