Skip to Content
0
Dec 14, 2011 at 07:51 AM

HOW TO PRINT LONG TEXT OF 255 CHARACTER IN ALV GRID instead of132 Char's

1730 Views

Hi sir/mam

i'm sreekar can any one help me on this please

"As I took a variable 'STR' with 255 length, But still ALV GRID DISPLAYS the same 132 characters, and

When I download the report into excel it is showing the 250 charactered text"

how can i print it in alv grid

FORM BUID_CATALOG .

DATA : COL_POS TYPE I.

COL_POS = COL_POS + 1.

*--DECLARING FIELDCATALOG FOR HEADER

LT_FCAT-COL_POS = COL_POS.

LT_FCAT-FIELDNAME = 'EBELN'.

LT_FCAT-TABNAME = 'LT_FINAL'.

LT_FCAT-SELTEXT_L = 'Purch.doc.no.'(002).

LT_FCAT-REF_FIELDNAME = 'EBELN'.

LT_FCAT-REF_TABNAME = 'EKKO'.

APPEND LT_FCAT.

CLEAR LT_FCAT.

LT_FCAT-COL_POS = COL_POS.

LT_FCAT-FIELDNAME = 'BEDAT'.

LT_FCAT-TABNAME = 'LT_FINAL'.

LT_FCAT-SELTEXT_L = 'Po Date'(003).

LT_FCAT-REF_FIELDNAME = 'EBDAT'.

LT_FCAT-EDIT_MASK = '__.__.____'.

APPEND LT_FCAT.

CLEAR LT_FCAT.

LT_FCAT-COL_POS = COL_POS.

LT_FCAT-FIELDNAME = 'EKGRP'.

LT_FCAT-TABNAME = 'LT_FINAL'.

LT_FCAT-SELTEXT_L = 'Purch.Grp'(004).

LT_FCAT-REF_FIELDNAME = 'BKGRP'.

APPEND LT_FCAT.

CLEAR LT_FCAT.

LT_FCAT-COL_POS = COL_POS.

LT_FCAT-FIELDNAME = 'EKNAM'.

LT_FCAT-TABNAME = 'LT_FINAL'.

LT_FCAT-SELTEXT_L = 'Purch.Grp. Name'(005).

LT_FCAT-REF_FIELDNAME = 'EKNAM'.

APPEND LT_FCAT.

CLEAR LT_FCAT.

LT_FCAT-COL_POS = COL_POS.

LT_FCAT-FIELDNAME = 'LIFNR'.

LT_FCAT-TABNAME = 'LT_FINAL'.

LT_FCAT-SELTEXT_L = 'Vendor No.'(006).

LT_FCAT-REF_FIELDNAME = 'ELIFN'.

APPEND LT_FCAT.

CLEAR LT_FCAT.

LT_FCAT-COL_POS = COL_POS.

LT_FCAT-FIELDNAME = 'NAME1'.

LT_FCAT-TABNAME = 'LT_FINAL'.

LT_FCAT-SELTEXT_L = 'Vendor Name'(007).

LT_FCAT-REF_FIELDNAME = 'NAME1_GP'.

APPEND LT_FCAT.

CLEAR LT_FCAT.

LT_FCAT-COL_POS = COL_POS.

LT_FCAT-FIELDNAME = 'ZTERM'.

LT_FCAT-TABNAME = 'LT_FINAL'.

LT_FCAT-SELTEXT_L = 'Pay.Code'(008).

LT_FCAT-REF_FIELDNAME = 'ZTERM'.

APPEND LT_FCAT.

CLEAR LT_FCAT.

LT_FCAT-COL_POS = COL_POS.

LT_FCAT-FIELDNAME = 'TEXT1'.

LT_FCAT-TABNAME = 'LT_FINAL'.

LT_FCAT-SELTEXT_L = 'Own explanation'(009).

LT_FCAT-REF_FIELDNAME = 'DZTERM'.

LT_FCAT-OUTPUTLEN = '30'.

LT_FCAT-DDICTXT = 'L'.

APPEND LT_FCAT.

CLEAR LT_FCAT.

LT_FCAT-COL_POS = COL_POS.

LT_FCAT-FIELDNAME = 'WAERS'.

LT_FCAT-TABNAME = 'LT_FINAL'.

LT_FCAT-SELTEXT_L = 'Curr'(010).

LT_FCAT-REF_FIELDNAME = 'WAERS'.

APPEND LT_FCAT.

CLEAR LT_FCAT.

LT_FCAT-COL_POS = COL_POS.

LT_FCAT-FIELDNAME = 'NETWR'.

LT_FCAT-TABNAME = 'LT_FINAL'.

LT_FCAT-SELTEXT_L = 'Net Value'(011).

LT_FCAT-REF_FIELDNAME = 'BWERT'.

APPEND LT_FCAT.

CLEAR LT_FCAT.

ENDFORM. " BUID_CATALOG

CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'

EXPORTING

I_BUFFER_ACTIVE = 'X'

I_BACKGROUND_ID = 'ALV_BACKGROUND'

IS_LAYOUT = GS_LAYOUT

IT_FIELDCAT = LT_FCAT[]

I_SAVE = G_SAVE

IS_VARIANT = GS_VARIANT

IMPORTING

E_EXIT_CAUSED_BY_CALLER = G_EXIT_CAUSED_BY_CALLER

ES_EXIT_CAUSED_BY_USER = GS_EXIT_CAUSED_BY_USER

TABLES

T_OUTTAB = LT_FINAL[]

EXCEPTIONS

PROGRAM_ERROR = 1

OTHERS = 2.

IF SY-SUBRC = 0.

IF G_EXIT_CAUSED_BY_CALLER = 'X'.

ELSE.

IF GS_EXIT_CAUSED_BY_USER-BACK = 'X'. "F3

EXIT.

ELSE.

IF GS_EXIT_CAUSED_BY_USER-EXIT = 'X'. "F15

LEAVE TO SCREEN 1000.

ELSE.

IF GS_EXIT_CAUSED_BY_USER-CANCEL = 'X'. "F12

LEAVE TO SCREEN 1000.

ELSE.

EXIT.

ENDIF.

ENDIF.

ENDIF.

ENDIF.

ELSE.

ENDIF.

ENDFORM. " DISPLAY_DATA

CALL FUNCTION 'READ_TEXT'

EXPORTING

CLIENT = SY-MANDT

ID = 'F15' "ls_thead-tdid PAYMENT TERMS

LANGUAGE = SY-LANGU "ls_thead-tdspras "CURRENT LANGUAGE 'E'

NAME = NAME "ls_thead-tdname PO NUMBER LW_EKKO-EBELN

OBJECT = 'EKKO' "ls_thead-tdobject TABLE NAME EKKO

IMPORTING

HEADER = HTEXT

TABLES

LINES = LTEXT

EXCEPTIONS

ID = 1

LANGUAGE = 2

NAME = 3

NOT_FOUND = 4

OBJECT = 5

REFERENCE_CHECK = 6

WRONG_ACCESS_TO_ARCHIVE = 7

OTHERS = 8.

IF SY-SUBRC = 0.

LOOP AT LTEXT.

IF LTEXT-TDLINE NE ''.

MOVE LTEXT-TDLINE TO WA_WORD-TEXT.

APPEND WA_WORD TO LT_SENTENCE.

ENDIF.

ENDLOOP.

ENDIF.

LOOP AT LT_SENTENCE INTO WA_WORD.

COUNT = COUNT + 1.

IF COUNT = 1.

STR = WA_WORD-TEXT.

LW_FINAL-TEXT1 = STR.

ELSEIF COUNT = 2 OR COUNT = 3 OR COUNT = 4 OR COUNT = 5 OR COUNT = 6 OR COUNT = 7 OR COUNT = 8.

CONCATENATE STR WA_WORD-TEXT INTO STR SEPARATED BY SPACE.

LW_FINAL-TEXT1 = STR.

ENDIF.

ENDLOOP.