Error printing an ALV

[former_member329522]

Hi everyone!!

I´ve a problem, I´ve an ALV, and it runs OK, put when I try to Print it, the columns are different from ALV, are smaller...

Also, the columns are in a incorrect place...

Please Help me!!

Thanks a lot!

[Former Member]

Hi,

Check with the variant for the ALV .. There may be different sequence getting displyed than the actual one.

Hope this solves your purpose.

Award points if it helps.

-Gaurang

[former_member329522]

Sorry, i think that the variant is ok. I´ve commented all sentences for variant and the problem persist

[Former Member]

hi,

internal table with header line.

data : begin of itab_mara,

matnr like mara-matnr,

enum like mara-enum,

end of itab_mara.

data : begin of itab_marc,

matnr like marc-matnr,

werks like marc-werks,

end of itab_marc

data : begin of itab_final,

matnr like mara-matnr,

enum like mara-enum,

werks like marc-werks,

end of itab_final.

data : d_fieldcat type slis_t_fieldcat_alv,

d_fieldcat_wa type slis_fieldcat_alv.

selection-screen : begin of block blk1 with frame title text-001.

select-options : s_matnr for mara-matnr,

s_werks for marc-werks.

selection-screen : end of block blk1.

select matnr erdat from table itab_mara where matnr in s_matnr.

if not itab_mara is initial.

select matnr werks from table itab_marc where werks in s_werks.

endif.

d_fieldcat_wa-fieldname = 'MATNR'.

d_fieldcat_seltext_l = 'material number'.

d_fieldcat_wa-col_pos = 1.

append d_fieldcat_wa to t_fieldcat.

clear d_fieldcat_wa.

d_fieldcat_wa-fieldname = 'WERKS'.

d_fieldcat_seltext_l = 'plants'.

d_fieldcat_wa-col_pos = 2.

append d_fieldcat_wa to t_fieldcat.

clear d_fieldcat_wa.

data :gd_repid like sy-repid.

gd_repid = sy-repid.

call function module reuse_grid_display_alv.

exporting.

proramname = gd_repid.

fieldcat = d_fieldcat.

importing.

t_outtab = itab_final.

exceptions.

reward with points if helpful.

[former_member329522]

Hi Vinutha YV.

My internal table has header line... isn´t correct??

[former_member329522]

Please, I need a good idea...

There aren´t columns of some z tables...

[former_member329522]

This is my itab

DATA: BEGIN OF it_datos OCCURS 0,

box,

pspid LIKE proj-pspid, "proyecto

posid LIKE prps-posid, "elemento PEP

alineacion LIKE mast-matnr, "alineación

matnr LIKE mara-matnr, "componente

concepto LIKE stpox-sortf, "montaje o prefabricado

destinado TYPE c, "destinado

maktx LIKE marav-maktx, "denominación de componente

rsnum LIKE resb-rsnum, "número de reserva

clabs LIKE mchb-clabs, "stock libre disposición

cant_reserva LIKE mchb-clabs, "cantidad de reserva, si existe

meins LIKE zalineaciones-meins, "unidad

• JPV añadimos campo posición y marcado de borrado

xloek LIKE resb-xloek, "Borrado

posnr LIKE zalineaciones-posnr, "Posición

kzear LIKE resb-kzear, "sacado

ebeln LIKE ekkn-ebeln, "pedido

ebelp LIKE ekkn-ebelp, "posición de pedido

charg LIKE mchb-charg, "lote

menge LIKE stpox-menge, "cantidad

cod_ser LIKE zservicios_unv-codigo, "servicio

cod_blo LIKE zbloque_unv-codigo, "bloque

cod_zon LIKE zzonas_unv-codigo.

DATA:END OF it_datos.

[Former Member]

Hi,

Pls check in ur Field catlogs whether u have give the sequence correctly that means what ever way u want the columns is to there.

[former_member329522]

I thinks that de flied cat is ok

FORM alv_fieldcat USING fieldcat TYPE slis_t_fieldcat_alv.

DATA: ls_fieldcat TYPE slis_fieldcat_alv.

CLEAR ls_fieldcat.

ls_fieldcat-fieldname = 'PSPID'.

ls_fieldcat-tabname = 'IT_DATOS'.

ls_fieldcat-seltext_l = 'Proyecto'.

ls_fieldcat-seltext_m = 'Proyecto'.

ls_fieldcat-seltext_s = 'Proyecto'.

APPEND ls_fieldcat TO fieldcat.

CLEAR ls_fieldcat.

ls_fieldcat-fieldname = 'ALINEACION'.

ls_fieldcat-ref_tabname = 'IT_DATOS'.

ls_fieldcat-seltext_l = 'Alineación'.

ls_fieldcat-seltext_m = 'Alineación'.

ls_fieldcat-seltext_s = 'Alineación'.

*nvm 16.04.07

ls_fieldcat-no_zero = 'X'.

*fin nvm

APPEND ls_fieldcat TO fieldcat.

CLEAR ls_fieldcat.

ls_fieldcat-fieldname = 'MATNR'.

ls_fieldcat-ref_tabname = 'IT_DATOS'.

ls_fieldcat-seltext_l = 'Componente'.

ls_fieldcat-seltext_m = 'Componente'.

ls_fieldcat-seltext_s = 'Componente'.

APPEND ls_fieldcat TO fieldcat.

CLEAR ls_fieldcat.

ls_fieldcat-fieldname = 'POSID'.

ls_fieldcat-ref_tabname = 'IT_DATOS'.

ls_fieldcat-seltext_l = 'Elemento PEP'.

ls_fieldcat-seltext_m = 'Elemento PEP'.

ls_fieldcat-seltext_s = 'Elemento PEP'.

APPEND ls_fieldcat TO fieldcat.

*JPV INI 07.05.2007

CLEAR ls_fieldcat.

ls_fieldcat-fieldname = 'POSNR'.

ls_fieldcat-ref_tabname = 'IT_DATOS'.

ls_fieldcat-seltext_l = 'Posición'.

ls_fieldcat-seltext_m = 'Posición'.

ls_fieldcat-seltext_s = 'Posición'.

APPEND ls_fieldcat TO fieldcat.

*JPV FIN

*nvm 16.04.07

CLEAR ls_fieldcat.

ls_fieldcat-fieldname = 'CHARG'.

ls_fieldcat-ref_tabname = 'IT_DATOS'.

ls_fieldcat-seltext_l = 'Lote'.

ls_fieldcat-seltext_m = 'Lote'.

ls_fieldcat-seltext_s = 'Lote'.

APPEND ls_fieldcat TO fieldcat.

*fin nvm

CLEAR ls_fieldcat.

ls_fieldcat-fieldname = 'COD_SER'.

ls_fieldcat-ref_tabname = 'IT_DATOS'.

ls_fieldcat-seltext_l = 'Servicio'.

ls_fieldcat-seltext_m = 'Servicio'.

ls_fieldcat-seltext_s = 'Servicio'.

APPEND ls_fieldcat TO fieldcat.

CLEAR ls_fieldcat.

ls_fieldcat-fieldname = 'COD_BLO'.

ls_fieldcat-ref_tabname = 'IT_DATOS'.

ls_fieldcat-seltext_l = 'Bloque'.

ls_fieldcat-seltext_m = 'Bloque'.

ls_fieldcat-seltext_s = 'Bloque'.

APPEND ls_fieldcat TO fieldcat.

CLEAR ls_fieldcat.

ls_fieldcat-fieldname = 'COD_ZON'.

ls_fieldcat-ref_tabname = 'IT_DATOS'.

ls_fieldcat-seltext_l = 'Zona'.

ls_fieldcat-seltext_m = 'Zona'.

ls_fieldcat-seltext_s = 'Zona'.

APPEND ls_fieldcat TO fieldcat.

• Concepto

CLEAR ls_fieldcat.

ls_fieldcat-fieldname = 'CONCEPTO'.

ls_fieldcat-tabname = 'IT_DATOS'.

ls_fieldcat-seltext_l = 'Concepto'.

ls_fieldcat-seltext_m = 'Concepto'.

ls_fieldcat-seltext_s = 'Concepto'.

ls_fieldcat-outputlen = 10.

APPEND ls_fieldcat TO fieldcat.

• Destinado

ls_fieldcat-fieldname = 'DESTINADO'.

ls_fieldcat-tabname = 'IT_DATOS'.

ls_fieldcat-seltext_l = 'Destinado'.

ls_fieldcat-seltext_m = 'Destinado'.

ls_fieldcat-seltext_s = 'Destinado'.

ls_fieldcat-checkbox = 'X'.

ls_fieldcat-outputlen = 8.

APPEND ls_fieldcat TO fieldcat.

CLEAR ls_fieldcat.

• Denominación de Componente

ls_fieldcat-fieldname = 'MAKTX'.

ls_fieldcat-seltext_l = 'Denominación Componente'.

ls_fieldcat-seltext_m = 'Den. Componente'.

ls_fieldcat-seltext_s = 'Den. Comp.'.

ls_fieldcat-ref_fieldname = 'MAKTX'.

ls_fieldcat-tabname = 'IT_DATOS'.

ls_fieldcat-ref_tabname = 'MARA'.

ls_fieldcat-outputlen = 35.

APPEND ls_fieldcat TO fieldcat.

CLEAR ls_fieldcat.

• Número de Reserva

ls_fieldcat-fieldname = 'RSNUM'.

ls_fieldcat-ref_fieldname = 'RSNUM'.

ls_fieldcat-tabname = 'IT_DATOS'.

ls_fieldcat-ref_tabname = 'RESB'.

ls_fieldcat-seltext_l = 'Reserva'.

ls_fieldcat-seltext_m = 'Reserva'.

ls_fieldcat-seltext_s = 'Reserva'.

ls_fieldcat-outputlen = 10.

APPEND ls_fieldcat TO fieldcat.

CLEAR ls_fieldcat.

• Existencias

ls_fieldcat-fieldname = 'CLABS'.

ls_fieldcat-ref_fieldname = 'CLABS'.

ls_fieldcat-tabname = 'IT_DATOS'.

ls_fieldcat-ref_tabname = 'MCHB'.

ls_fieldcat-seltext_s = 'Stock Total'.

ls_fieldcat-seltext_m = 'Stock Total'.

ls_fieldcat-seltext_l = 'Stock Total'.

ls_fieldcat-outputlen = 15.

APPEND ls_fieldcat TO fieldcat.

CLEAR ls_fieldcat.

• Cantidad de reserva

CLEAR ls_fieldcat.

ls_fieldcat-fieldname = 'CANT_RESERVA'.

ls_fieldcat-ref_fieldname = 'CLABS'.

ls_fieldcat-ref_tabname = 'MCHB'.

ls_fieldcat-tabname = 'IT_DATOS'.

ls_fieldcat-seltext_s = 'Reserv'.

ls_fieldcat-seltext_m = 'Reservado'.

ls_fieldcat-seltext_l = 'Stock Reservado'.

ls_fieldcat-outputlen = 10.

APPEND ls_fieldcat TO fieldcat.

• stock necesario

CLEAR ls_fieldcat.

ls_fieldcat-fieldname = 'MENGE'.

ls_fieldcat-ref_fieldname = 'MENGE'.

ls_fieldcat-ref_tabname = 'RC29P'.

ls_fieldcat-tabname = 'IT_DATOS'.

ls_fieldcat-seltext_s = 'Neces.'.

ls_fieldcat-seltext_m = 'Necesario'.

ls_fieldcat-seltext_l = 'Stock Necesario'.

ls_fieldcat-outputlen = 10.

APPEND ls_fieldcat TO fieldcat.

• Sacado

ls_fieldcat-fieldname = 'KZEAR'.

ls_fieldcat-tabname = 'IT_DATOS'.

ls_fieldcat-seltext_m = 'Sacado'.

ls_fieldcat-seltext_l = 'Sacado'.

ls_fieldcat-seltext_s = 'Sacado'.

ls_fieldcat-checkbox = 'X'.

ls_fieldcat-outputlen = 6.

APPEND ls_fieldcat TO fieldcat.

CLEAR ls_fieldcat.

[Former Member]

Hi ,

In the program , when u r creating the field catalouge ,create the same way as u want dem in the output, and also take care of field lengths.

[Former Member]

Hi ,

Pls try this way.

FORM ALV_BUILD_FIELDCAT3 USING P_INT_FIELDCAT TYPE SLIS_T_FIELDCAT_ALV.

DATA: WA_ALV_FIELDCAT TYPE SLIS_FIELDCAT_ALV.

CLEAR WA_ALV_FIELDCAT.

WA_ALV_FIELDCAT-FIELDNAME = 'ACTGRP'.

WA_ALV_FIELDCAT-REF_TABNAME = 'GLFUNCT'.

WA_ALV_FIELDCAT-OUTPUTLEN = '15'.

WA_ALV_FIELDCAT-TABNAME = 'IT_DATA2'.

WA_ALV_FIELDCAT-SELTEXT_L = 'Account Group'(T01).

WA_ALV_FIELDCAT-REF_FIELDNAME = 'RACCT'.

WA_ALV_FIELDCAT-COL_POS = '1'.

WA_ALV_FIELDCAT-KEY = 'X'.

APPEND WA_ALV_FIELDCAT TO P_INT_FIELDCAT.

CLEAR WA_ALV_FIELDCAT.

WA_ALV_FIELDCAT-FIELDNAME = 'DESC'.

WA_ALV_FIELDCAT-TABNAME = 'IT_DATA2'.

WA_ALV_FIELDCAT-OUTPUTLEN = '42'.

WA_ALV_FIELDCAT-SELTEXT_L = 'P & L Statement by Hyperion'(T02).

WA_ALV_FIELDCAT-COL_POS = '2'.

APPEND WA_ALV_FIELDCAT TO P_INT_FIELDCAT.