topic Re: ALV Report Problem in Application Development and Automation Discussions

ALV Report Problem

Former Member — Tue, 27 May 2008 09:13:32 GMT

Hi All,

I have a ALV Grid Report. when i execute the report, it shows the output..but somewhere it don't show the full description of fields...like materi....in place of material..

what is the problem in it..

plz tell....

Re: ALV Report Problem

Former Member — Tue, 27 May 2008 09:15:27 GMT

Hi Prince,

While preparing fieldcat pass value for all there

seltext_m

seltext_l.

This will solve your issue.

Thanks,

Arun

Re: ALV Report Problem

Former Member — Tue, 27 May 2008 09:15:44 GMT

Check the field catalouge for material.

wa_fieldcat-fieldname = 'MATNR'.

wa_fieldcat-seltext_m = 'Material'.

wa_fieldcat-just = 'L'.

wa_fieldcat-no_zero(1) = 'X'.

wa_fieldcat-outputlen = 20.

wa_fieldcat-tabname = 'IT_EXCEL'.

APPEND wa_fieldcat TO it_fieldcat.

CLEAR wa_fieldcat.

Amit.

Edited by: Jony on May 27, 2008 11:16 AM

Re: ALV Report Problem

Former Member — Tue, 27 May 2008 09:15:55 GMT

try assigning the sel_l field in the field catalog for the field which is for the display of long text.

Rgds,

Stck

Re: ALV Report Problem

Former Member — Tue, 27 May 2008 09:17:14 GMT

Set the flag of layout.

fld_alv_layout-colwidth_optimize = 'X'.

Regards

Raja.

Re: ALV Report Problem

former_member156446 — Tue, 27 May 2008 09:18:43 GMT

check the field catalog


l_fieldcat-outputlen = 10. "give it as much as u want...

Re: ALV Report Problem

Former Member — Tue, 27 May 2008 09:20:34 GMT

Hi Dear,

Thanks for reply...i think ur answer is correct but i have few changes in my report...plz tell me where i can change in it...

Code.....

*******************************************

REPORT ZAK_COQA LINE-SIZE 175 .

TABLES : MARA, T001L, MARD, MBEW.

TYPE-POOLS: SLIS.

DATA : BEGIN OF ITAB OCCURS 0,

MATNR LIKE MARA-MATNR, " Material No.

WERKS LIKE MARD-WERKS, " Plant

LGORT LIKE MARD-LGORT,

LABST LIKE MARD-LABST,

SALK3 LIKE MBEW-SALK3,

END OF ITAB.

**************************************************

DATA : W_CONTAINER TYPE SCRFNAME VALUE 'CL_GRID',

W_CPROG TYPE LVC_S_LAYO,

G_REPID LIKE SY-REPID,

W_SAVE TYPE C,

W_EXIT TYPE C,

CL_GRID TYPE REF TO CL_GUI_ALV_GRID,

CL_CUSTOM_CONTAINER TYPE REF TO CL_GUI_CUSTOM_CONTAINER,

IT_FLD_CATALOG TYPE SLIS_T_FIELDCAT_ALV,

WA_FLD_CATALOG TYPE SLIS_T_FIELDCAT_ALV WITH HEADER LINE ,

LAYOUT TYPE SLIS_LAYOUT_ALV,

COL_POS LIKE SY-CUCOL ,

ALVFC TYPE SLIS_T_FIELDCAT_ALV.

***************************************************

SELECTION-SCREEN BEGIN OF BLOCK A WITH FRAME.

SELECT-OPTIONS: MATNR FOR MARA-MATNR, " Material No.

WERKS FOR T001L-WERKS, " Plant

LGORT FOR T001L-LGORT.

SELECTION-SCREEN END OF BLOCK A.

***************************************************

PERFORM FILL_CATALOG1 USING:

'MATNR' 'ITAB' 'MATERIAL NUMBER',

'WERKS' 'ITAB' 'PLANT',

'LGORT' 'ITAB' 'STORAGE LOCATION',

'LABST' 'ITAB' 'QUANTITY',

'SALK3' 'ITAB' 'AMOUNT'.

***************************************************

SELECT A_{MATNR B}WERKS B_{LGORT B}LABST INTO CORRESPONDING FIELDS OF TABLE ITAB

FROM MARA AS A INNER JOIN MARD AS B ON A_{MATNR = B}MATNR

WHERE A~MATNR IN MATNR

AND B~WERKS IN WERKS

AND B~LGORT IN LGORT.

LOOP AT ITAB.

SELECT SALK3 FROM MBEW INTO (ITAB-SALK3) WHERE MATNR = ITAB-MATNR.

MODIFY ITAB INDEX SY-TABIX TRANSPORTING SALK3.

ENDSELECT .

ENDLOOP.

***************************************************

CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'

EXPORTING

I_CALLBACK_PROGRAM = 'ZAK_COQA'

IS_LAYOUT = LAYOUT

IT_FIELDCAT = IT_FLD_CATALOG

I_DEFAULT = 'X'

I_SAVE = 'A'

TABLES

T_OUTTAB = ITAB

EXCEPTIONS

PROGRAM_ERROR = 1

OTHERS = 2.

IF SY-SUBRC <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

&----

*& Form FILL_CATALOG1

&----

text

----

-->P_FIELDNAME text
-->P_REF_TABLE text
-->P_SCRTEXT text

----

FORM FILL_CATALOG1 USING P_FIELDNAME TYPE ANY

P_REF_TABLE TYPE ANY

P_SCRTEXT TYPE ANY.

CLEAR : WA_FLD_CATALOG.

WA_FLD_CATALOG-FIELDNAME = P_FIELDNAME.

WA_FLD_CATALOG-TABNAME = P_REF_TABLE.

WA_FLD_CATALOG-SELTEXT_S = P_SCRTEXT.

WA_FLD_CATALOG-SELTEXT_M = P_SCRTEXT.

WA_FLD_CATALOG-SELTEXT_L = P_SCRTEXT.

APPEND WA_FLD_CATALOG TO IT_FLD_CATALOG.

ENDFORM. " fill_catalog1

*******************************************

Plz tell.....

Edited by: Prince Kumar on May 27, 2008 3:00 PM

Re: ALV Report Problem

Former Member — Tue, 27 May 2008 09:39:16 GMT

you can do changes like shown below ---

FORM FILL_CATALOG1 USING P_FIELDNAME TYPE ANY

P_REF_TABLE TYPE ANY

P_SCRTEXT TYPE ANY.

CLEAR : WA_FLD_CATALOG.

WA_FLD_CATALOG-FIELDNAME = P_FIELDNAME.

WA_FLD_CATALOG-TABNAME = P_REF_TABLE.

WA_FLD_CATALOG-SELTEXT_S = P_SCRTEXT.

WA_FLD_CATALOG-SELTEXT_M = P_SCRTEXT.

WA_FLD_CATALOG-SELTEXT_L = P_SCRTEXT.

-->WA_FLD_CATALOG-OUTPUTLEN = 10.

APPEND WA_FLD_CATALOG TO IT_FLD_CATALOG.

hope it helps..

Reward if useful.

Regards

Megha Sharma

Re: ALV Report Problem

Former Member — Tue, 27 May 2008 09:43:39 GMT

hi,

add one more field in your layout.

layout_colwidth-optimize = 'X'.

This optimizes the column width to ensure that the content is displayed completely.

if u define this layout field than no need to define any kind of field catalog that defines a field length like seltext_l , seltext_m etc.

reward if helpful.

Re: ALV Report Problem

Former Member — Tue, 27 May 2008 10:18:00 GMT

Hi Megha Sharma,

Thanks Dear...My problem Solved Now.. Thanks once again...

Re: ALV Report Problem

Former Member — Tue, 27 May 2008 11:26:49 GMT

I have a little bit problem here.

Re: ALV Report Problem

Former Member — Tue, 27 May 2008 11:30:18 GMT

Hi Megha Sharma,

I have 1 more problem in this thread that when i download this executed data in to excel sheet, it don't show my required format, means not showing description complete in EXCEL..only showing complete after execute in sap not in excel.

Plz help...

Re: ALV Report Problem

Former Member — Tue, 27 May 2008 11:35:57 GMT

Hi,

Increase the output length and check.


gs_fieldcat-outputlen  = ' '. "Increase it by existing number

Thanks,

Sriram Ponna.

Re: ALV Report Problem

Former Member — Tue, 27 May 2008 11:40:14 GMT

Dear,

U r right but i mean from EXCEL....

When i executing report..showing correct description but when i downloading it into EXCEL not showing complete... it break description...

Plz Tell..

Edited by: Prince Kumar on May 27, 2008 5:21 PM

Re: ALV Report Problem

Former Member — Tue, 27 May 2008 11:53:10 GMT

remove fld_alv_layout-colwidth_optimize = 'X'. U should get.

Venkat

Re: ALV Report Problem

Former Member — Tue, 27 May 2008 12:01:05 GMT

Hi,

But i have not used fld_alv_layout-colwidth_optimize = 'X'. statement.

Where it is in my code...plz tell...

Edited by: Prince Kumar on May 27, 2008 5:55 PM