03-15-2007 4:16 PM
HELLO EXPERTS,
Here I am having a small issue...
I developed the field catalog with 15 fields and I assigned the filed postions and field descriptions but in the out put one field is coming in middle which i defined in 14th position not only that in the header it is not showing the description what i mentioned in the filed catalog.
I designed the internal table also in the same order
can u anyone guide me how to solve this problem..
SIRI
03-15-2007 4:24 PM
Hi Sri,
Are you passing the col_pos as 14 and the coltext as the description, like in the following example:
wa_catalog-fieldname = 'LIFNR'.
wa_catalog-tabname = 'L_ITAB_LFA1'.
<b> wa_catalog-coltext = 'Description'.</b>
wa_catalog-just = 'L'.
<b> wa_catalog-col_pos = 14.</b>
wa_catalog-outputlen = 12.
APPEND wa_catalog TO itab_catalog.
CLEAR wa_catalog.
Hope it helps.
Regards,
Gilberto Li
Message was edited by:
Gilberto Li
03-15-2007 4:32 PM
I declared the same Li ... But it is not working
can u check this code once plz...
fieldcatalog-fieldname = 'MENGE'.
fieldcatalog-seltext_m = 'QTY TO RECEIVE'.
fieldcatalog-col_pos = 13.
fieldcatalog-REF_TABNAME = 'EKES'.
fieldcatalog-REF_FIELDNAME = 'MENGE'.
append fieldcatalog to fieldcatalog.
clear fieldcatalog.
It is displaying in 6th position...
03-15-2007 4:39 PM
Hi again,
If you define correctly your catalog it shouldn't show in other position than 13th.
You should check if in another column after you're setting it to 6th position.
Another reason that this can be happening is that you load the output with a variant. Check that also, see if you're initializing the output with a custom variant.
If that didn't solve, you should post you're code so we can check it and be more helpful.
Regards,
Gilberto Li
03-15-2007 4:43 PM
check any default variant is available. if available delete it and test once again.,
aRs
03-15-2007 4:48 PM
Hi,
Try this..
fieldcatalog-fieldname = 'MENGE'.
fieldcatalog-col_pos = 13.
fieldcatalog-reptext_ddic = 'QTY To Receive'.
fieldcatalog-rollname = 'MENGE_D'.
append fieldcatalog to fieldcatalog.
clear fieldcatalog.
Thanks,
Naren
03-15-2007 5:04 PM
hi
there is no difference
here I am giving my field catalog description there r two fields with menge but from different tables and at different positions...
form build_fieldcatalog.
fieldcatalog-fieldname = 'EBELN'.
fieldcatalog-seltext_m = 'PO NUMBER'.
fieldcatalog-col_pos = 0.
fieldcatalog-outputlen = 10.
fieldcatalog-emphasize = 'X'.
fieldcatalog-REF_TABNAME = 'EKKO'.
fieldcatalog-REF_FIELDNAME = 'EBELN'.
append fieldcatalog to fieldcatalog.
clear fieldcatalog.
fieldcatalog-fieldname = 'AEDAT'.
fieldcatalog-seltext_m = 'PO DATE'.
fieldcatalog-col_pos = 1.
fieldcatalog-REF_TABNAME = 'EKKO'.
fieldcatalog-REF_FIELDNAME = 'AEDAT'.
append fieldcatalog to fieldcatalog.
clear fieldcatalog.
fieldcatalog-fieldname = 'EKGRP'.
fieldcatalog-seltext_m = 'PUR GRP/BUYER'.
fieldcatalog-col_pos = 2.
fieldcatalog-REF_TABNAME = 'EKKO'.
fieldcatalog-REF_FIELDNAME = 'EKGRP'.
append fieldcatalog to fieldcatalog.
clear fieldcatalog.
fieldcatalog-fieldname = 'EKORG'.
fieldcatalog-seltext_m = 'PUR ORG.'.
fieldcatalog-col_pos = 3.
fieldcatalog-REF_TABNAME = 'EKKO'.
fieldcatalog-REF_FIELDNAME = 'EKORG'.
append fieldcatalog to fieldcatalog.
clear fieldcatalog.
fieldcatalog-fieldname = 'LIFNR'.
fieldcatalog-seltext_m = 'VENDOR NO'.
fieldcatalog-col_pos = 4.
fieldcatalog-REF_TABNAME = 'EKKO'.
fieldcatalog-REF_FIELDNAME = 'LIFNR'.
append fieldcatalog to fieldcatalog.
clear fieldcatalog.
fieldcatalog-fieldname = 'EBELP'.
fieldcatalog-seltext_m = 'PO LINE'.
fieldcatalog-col_pos = 5.
fieldcatalog-REF_TABNAME = 'EKPO'.
fieldcatalog-REF_FIELDNAME = 'EBELP'.
append fieldcatalog to fieldcatalog.
clear fieldcatalog.
fieldcatalog-fieldname = 'MENGE'.
fieldcatalog-seltext_m = 'ORD QTY'.
fieldcatalog-col_pos = 6.
fieldcatalog-REF_TABNAME = 'EKET'.
fieldcatalog-REF_FIELDNAME = 'MENGE'.
append fieldcatalog to fieldcatalog.
clear fieldcatalog.
fieldcatalog-fieldname = 'MEINS'.
fieldcatalog-seltext_m = 'UNIT'.
fieldcatalog-col_pos = 7.
fieldcatalog-REF_TABNAME = 'EKPO'.
fieldcatalog-REF_FIELDNAME = 'MEINS'.
append fieldcatalog to fieldcatalog.
clear fieldcatalog.
fieldcatalog-fieldname = 'MATNR'.
fieldcatalog-seltext_m = 'MATERIAL'.
fieldcatalog-col_pos = 8.
fieldcatalog-REF_TABNAME = 'EKPO'.
fieldcatalog-REF_FIELDNAME = 'MATNR'.
append fieldcatalog to fieldcatalog.
clear fieldcatalog.
fieldcatalog-fieldname = 'TXZ01'.
fieldcatalog-seltext_m = 'DESCRIPTION'.
fieldcatalog-col_pos = 9.
fieldcatalog-REF_TABNAME = 'EKPO'.
fieldcatalog-REF_FIELDNAME = 'TXZ01'.
append fieldcatalog to fieldcatalog.
clear fieldcatalog.
fieldcatalog-fieldname = 'IDNLF'.
fieldcatalog-seltext_m = 'VEND MAT'.
fieldcatalog-col_pos = 10.
fieldcatalog-REF_TABNAME = 'EKPO'.
fieldcatalog-REF_FIELDNAME = 'IDNLF'.
append fieldcatalog to fieldcatalog.
clear fieldcatalog.
fieldcatalog-fieldname = 'LGPBE'.
fieldcatalog-seltext_m = 'ST.LOC SHELF BIN'.
fieldcatalog-col_pos = 11.
fieldcatalog-outputlen = 6.
fieldcatalog-REF_TABNAME = 'MARD'.
fieldcatalog-REF_FIELDNAME = 'LGPBE'.
append fieldcatalog to fieldcatalog.
clear fieldcatalog.
fieldcatalog-fieldname = 'LGOBE'.
fieldcatalog-seltext_m = 'ST.LOC DESCRIPTION'.
fieldcatalog-col_pos = 12.
fieldcatalog-REF_TABNAME = 'T001L'.
fieldcatalog-REF_FIELDNAME = 'LGOBE'.
append fieldcatalog to fieldcatalog.
clear fieldcatalog.
IF BLIND = ' '. " if the check box is not checked.
fieldcatalog-fieldname = 'MENGE'.
fieldcatalog-seltext_m = 'QTY TO RECEIVE'.
fieldcatalog-col_pos = 13.
fieldcatalog-REF_TABNAME = 'EKES'.
fieldcatalog-REF_FIELDNAME = 'MENGE1'.
fieldcatalog-rollname = 'MENGE_D'.
append fieldcatalog to fieldcatalog.
clear fieldcatalog.
fieldcatalog-fieldname = 'WEMNG'.
fieldcatalog-seltext_m = 'QTY RECEIVED'.
fieldcatalog-col_pos = 14 .
fieldcatalog-REF_TABNAME = 'EKET'.
fieldcatalog-REF_FIELDNAME = 'WEMNG'.
append fieldcatalog to fieldcatalog.
clear fieldcatalog.
endif.
endform. " build_fieldcatalog
03-15-2007 5:10 PM
Hi Sry,
Try putting this in the catalog just to make sure from where it gets the field:
form build_fieldcatalog.
fieldcatalog-fieldname = 'EBELN'.
fieldcatalog-seltext_m = 'PO NUMBER'.
fieldcatalog-col_pos = 0.
fieldcatalog-outputlen = 10.
fieldcatalog-emphasize = 'X'.
fieldcatalog-REF_TABNAME = 'EKKO'.
fieldcatalog-REF_FIELDNAME = 'EBELN'.
append fieldcatalog to fieldcatalog.
clear fieldcatalog.
fieldcatalog-fieldname = 'AEDAT'.
fieldcatalog-seltext_m = 'PO DATE'.
fieldcatalog-col_pos = 1.
fieldcatalog-REF_TABNAME = 'EKKO'.
fieldcatalog-REF_FIELDNAME = 'AEDAT'.
append fieldcatalog to fieldcatalog.
clear fieldcatalog.
fieldcatalog-fieldname = 'EKGRP'.
fieldcatalog-seltext_m = 'PUR GRP/BUYER'.
fieldcatalog-col_pos = 2.
fieldcatalog-REF_TABNAME = 'EKKO'.
fieldcatalog-REF_FIELDNAME = 'EKGRP'.
append fieldcatalog to fieldcatalog.
clear fieldcatalog.
fieldcatalog-fieldname = 'EKORG'.
fieldcatalog-seltext_m = 'PUR ORG.'.
fieldcatalog-col_pos = 3.
fieldcatalog-REF_TABNAME = 'EKKO'.
fieldcatalog-REF_FIELDNAME = 'EKORG'.
append fieldcatalog to fieldcatalog.
clear fieldcatalog.
fieldcatalog-fieldname = 'LIFNR'.
fieldcatalog-seltext_m = 'VENDOR NO'.
fieldcatalog-col_pos = 4.
fieldcatalog-REF_TABNAME = 'EKKO'.
fieldcatalog-REF_FIELDNAME = 'LIFNR'.
append fieldcatalog to fieldcatalog.
clear fieldcatalog.
fieldcatalog-fieldname = 'EBELP'.
fieldcatalog-seltext_m = 'PO LINE'.
fieldcatalog-col_pos = 5.
fieldcatalog-REF_TABNAME = 'EKPO'.
fieldcatalog-REF_FIELDNAME = 'EBELP'.
append fieldcatalog to fieldcatalog.
clear fieldcatalog.
fieldcatalog-fieldname = 'MENGE'.
fieldcatalog-seltext_m = 'ORD QTY'.
fieldcatalog-col_pos = 6.
fieldcatalog-REF_TABNAME = 'EKET'.
fieldcatalog-REF_FIELDNAME = 'MENGE'.
<b>fieldcatalog-tabname = 'EKET'.</b>
append fieldcatalog to fieldcatalog.
clear fieldcatalog.
fieldcatalog-fieldname = 'MEINS'.
fieldcatalog-seltext_m = 'UNIT'.
fieldcatalog-col_pos = 7.
fieldcatalog-REF_TABNAME = 'EKPO'.
fieldcatalog-REF_FIELDNAME = 'MEINS'.
append fieldcatalog to fieldcatalog.
clear fieldcatalog.
fieldcatalog-fieldname = 'MATNR'.
fieldcatalog-seltext_m = 'MATERIAL'.
fieldcatalog-col_pos = 8.
fieldcatalog-REF_TABNAME = 'EKPO'.
fieldcatalog-REF_FIELDNAME = 'MATNR'.
append fieldcatalog to fieldcatalog.
clear fieldcatalog.
fieldcatalog-fieldname = 'TXZ01'.
fieldcatalog-seltext_m = 'DESCRIPTION'.
fieldcatalog-col_pos = 9.
fieldcatalog-REF_TABNAME = 'EKPO'.
fieldcatalog-REF_FIELDNAME = 'TXZ01'.
append fieldcatalog to fieldcatalog.
clear fieldcatalog.
fieldcatalog-fieldname = 'IDNLF'.
fieldcatalog-seltext_m = 'VEND MAT'.
fieldcatalog-col_pos = 10.
fieldcatalog-REF_TABNAME = 'EKPO'.
fieldcatalog-REF_FIELDNAME = 'IDNLF'.
append fieldcatalog to fieldcatalog.
clear fieldcatalog.
fieldcatalog-fieldname = 'LGPBE'.
fieldcatalog-seltext_m = 'ST.LOC SHELF BIN'.
fieldcatalog-col_pos = 11.
fieldcatalog-outputlen = 6.
fieldcatalog-REF_TABNAME = 'MARD'.
fieldcatalog-REF_FIELDNAME = 'LGPBE'.
append fieldcatalog to fieldcatalog.
clear fieldcatalog.
fieldcatalog-fieldname = 'LGOBE'.
fieldcatalog-seltext_m = 'ST.LOC DESCRIPTION'.
fieldcatalog-col_pos = 12.
fieldcatalog-REF_TABNAME = 'T001L'.
fieldcatalog-REF_FIELDNAME = 'LGOBE'.
append fieldcatalog to fieldcatalog.
clear fieldcatalog.
IF BLIND = ' '. " if the check box is not checked.
fieldcatalog-fieldname = 'MENGE'.
fieldcatalog-seltext_m = 'QTY TO RECEIVE'.
fieldcatalog-col_pos = 13.
fieldcatalog-REF_TABNAME = 'EKES'.
fieldcatalog-REF_FIELDNAME = 'MENGE1'.
*fieldcatalog-rollname = 'MENGE_D'.
<b>fieldcatalog-tabname = 'EKES'.</b>
append fieldcatalog to fieldcatalog.
clear fieldcatalog.
fieldcatalog-fieldname = 'WEMNG'.
fieldcatalog-seltext_m = 'QTY RECEIVED'.
fieldcatalog-col_pos = 14 .
fieldcatalog-REF_TABNAME = 'EKET'.
fieldcatalog-REF_FIELDNAME = 'WEMNG'.
append fieldcatalog to fieldcatalog.
clear fieldcatalog.
endif.
endform. " build_fieldcatalog
Regards,
Gilberto Li
03-15-2007 6:39 PM
hi Li
It is same again....
can anyone guide me how to fix this problem
03-15-2007 6:43 PM
Hello Sri
In the situation where I want to define to order of the fieldcatalog explictly I arrange the records in the fieldcatalog itab accordingly and afterwards do a <b>renumbering</b>:
LOOP AT gt_fcat INTO ls_fcat.
ls_fcat-col_pos = syst-tabix.
MODIFY gt_fcat FROM ls_fcat INDEX syst-tabix.
ENDLOOP.
Regards
Uwe
03-15-2007 7:09 PM
Uwe
I tried this coding also but there is no change ....
If i log in to another client of same environment its showing in the same sequence what would be the reason for this...
Plz can anyone guide me how to do this.
03-16-2007 4:11 AM
PERFORM sub_fieldcat USING :
'CARRID' 'CARRID',
'CONNID' 'CONNID',
'FLDATE' 'FLDATE',
'BOOKID' 'BOOKID'.
FORM sub_fieldcat USING p_01
p_02.
is_fcat-tabname = 'IT_STEXCEL'.
is_fcat-fieldname = p_01.
is_fcat-seltext_l = p_02.
APPEND is_fcat TO it_fcat.
CLEAR is_fcat.
ENDFORM.