Markier einmal ALLE Spalten und sortier diese.mpm@c2b hat geschrieben:Hey, danke für den Tip mit dem STRG+Shift+Maustaste....
ist ziemlich hilfreich.
Mein problem habe ich noch nicht gelöst, aber ich versuche.
Tipfehler sehe ich keine...scheint ok zu sein.
Wenn ich die ALV nach Excel exportiere funktioniert einwandfrei, aber die Vorschau nicht.![]()
Falls jemand noch ein Tip hat?!?![]()
Danke
Code: Alles auswählen.
form prepare_field_catalog changing pt_fieldcat type lvc_t_fcat .
data ls_fcat type lvc_s_fcat .
data: prg like sy-repid.
clear pt_fieldcat. refresh pt_fieldcat.
prg = sy-repid.
*1
ls_fcat-fieldname = 'SEMAFORO'.
ls_fcat-tabname = 'I_COLAB'.
ls_fcat-icon = 'X'.
ls_fcat-outputlen = '6'.
ls_fcat-coltext = 'Status'.
ls_fcat-seltext = 'Status'.
ls_fcat-scrtext_l = 'Status'.
ls_fcat-scrtext_m = 'Status'.
ls_fcat-scrtext_s = 'Status'.
ls_fcat-reptext = 'Status'.
append ls_fcat to pt_fieldcat.
clear ls_fcat.
*2
ls_fcat-fieldname = 'PERNR'. "N.º Pessoal
ls_fcat-tabname = 'I_COLAB'.
ls_fcat-outputlen = '10'.
ls_fcat-coltext = 'Nº pessoal '.
ls_fcat-seltext = 'Número pessoal'.
ls_fcat-scrtext_l = 'Número pessoal'.
ls_fcat-scrtext_m = 'Número pessoal'.
ls_fcat-scrtext_s = 'Nº pessoal'.
ls_fcat-reptext = 'Número pessoal'.
append ls_fcat to pt_fieldcat.
clear ls_fcat.
*3
ls_fcat-fieldname = 'NOMBRE'. "Nome
ls_fcat-tabname = 'I_COLAB'.
ls_fcat-outputlen = '55'.
ls_fcat-coltext = 'Nome completo'.
ls_fcat-seltext = 'Nome completo'.
ls_fcat-scrtext_l = 'Nome completo do colaborador'.
ls_fcat-scrtext_m = 'Nome completo'.
ls_fcat-scrtext_s = 'Nome completo'.
ls_fcat-reptext = 'Nome completo'.
append ls_fcat to pt_fieldcat.
clear ls_fcat.
*4
ls_fcat-fieldname = 'ZTERF'.
ls_fcat-tabname = 'I_COLAB'.
ls_fcat-outputlen = '14'.
ls_fcat-coltext = 'Status Tempos'.
ls_fcat-seltext = 'Status Tempos'.
ls_fcat-scrtext_l = 'Status de Tempos'.
ls_fcat-scrtext_m = 'Status Tempos'.
ls_fcat-scrtext_s = 'Status Tempos'.
ls_fcat-reptext = 'Status Tempos'.
append ls_fcat to pt_fieldcat.
clear ls_fcat.
endform. " prepare_field_catalog
Code: Alles auswählen.
ls_fcat-fieldname = 'PERNR'. "N.º Pessoal
ls_fcat-tabname = 'I_COLAB'.
* NEW
ls_fcat-REF_TABNAME = 'XXX'.
ls_fcat-REF_FIELDNAME = 'XXX'.
* ENDNEW
ls_fcat-outputlen = '10'.
ls_fcat-coltext = 'Nº pessoal '.
ls_fcat-seltext = 'Número pessoal'.
ls_fcat-scrtext_l = 'Número pessoal'.
ls_fcat-scrtext_m = 'Número pessoal'.
ls_fcat-scrtext_s = 'Nº pessoal'.
ls_fcat-reptext = 'Número pessoal'.
append ls_fcat to pt_fieldcat.
clear ls_fcat.
Code: Alles auswählen.
ls_fcat-fieldname = 'PERNR'. "N.º Pessoal
ls_fcat-tabname = 'I_COLAB'.
* NEW
ls_fcat-INTTYPE = 'C'.
* ENDNEW
ls_fcat-coltext = 'Nº pessoal '.
ls_fcat-seltext = 'Número pessoal'.
ls_fcat-scrtext_l = 'Número pessoal'.
ls_fcat-scrtext_m = 'Número pessoal'.
ls_fcat-scrtext_s = 'Nº pessoal'.
ls_fcat-reptext = 'Número pessoal'.
append ls_fcat to pt_fieldcat.
clear ls_fcat.