Skip to Content
0
Former Member
Mar 05, 2007 at 06:49 PM

is there and limit in "CONCATENATE" ?

657 Views

Hello ,

I need to "CONCATENATE” 30 fields of structure in size of 500 characters

to one line ( string/char ) , in order to pass internal table to excel file .

But after 225 characters i found that the line can't get data and its cut.

Even if i increase the size of the line to 1024 .

is there any limit or solution for this problem ?

my program lines :

LOOP AT IT_DLR_ORDER . " INTO WA_CHAREKPO.

PERFORM MOVE_TO_STRUCT .

CONCATENATE '=REPLACE("' WA_CHAREKPO-EBELP '",1,5,"'

WA_CHAREKPO-EBELP '")' INTO LD_STORE .

  • concatenate ld_store into .xls file instead of actual value(ebelp)

CONCATENATE WA_CHAREKPO-EBELN

LD_STORE

WA_CHAREKPO-AEDAT

WA_CHAREKPO-BUKRS

WA_CHAREKPO-LIFNR

WA_CHAREKPO-NAME1

WA_CHAREKPO-EKGRP

WA_CHAREKPO-EKNAM

WA_CHAREKPO-MATNR

WA_CHAREKPO-MAKTX

WA_CHAREKPO-MENGE

WA_CHAREKPO-KBETR

WA_CHAREKPO-KBETR_WITH_VAT

WA_CHAREKPO-KBETR_TOTAL

WA_CHAREKPO-KBETR_TOTAL_VAT

WA_CHAREKPO-KNUMV

WA_CHAREKPO-NETPR

WA_CHAREKPO-EFFWR

WA_CHAREKPO-NETPR_KOLL

WA_CHAREKPO-NETPR_KOLL_VAT

  • WA_CHAREKPO-ZBAS_DATE

  • WA_CHAREKPO-EXCH_RATE

  • WA_CHAREKPO-NETPR_SHEKEL

  • WA_CHAREKPO-NETPR_SHEKEL_VAT

  • WA_CHAREKPO-TOTAL_SHEKEL

  • WA_CHAREKPO-TOTAL_SHEKEL_VAT

  • WA_CHAREKPO-DELTA_SHEKEL

INTO IT_ATTACH SEPARATED BY CON_TAB.

CONCATENATE CON_CRET IT_ATTACH INTO IT_ATTACH.

APPEND IT_ATTACH.

ENDLOOP.