hi all

Former Member · ‎2008 May 23

hi all

in alv report how to display signs + or - with values.

rocky

Former Member · ‎2008 May 23

Hi,

U can write in fieldcat.

I am giving u all the fields of slis_fieldcat.

U just try with symbol i may work.

types: begin of slis_fieldcat_main0,

row_pos like sy-curow, " output in row

col_pos like sy-cucol, " position of the column

fieldname type slis_fieldname,

tabname type slis_tabname,

currency(5) type c,

cfieldname type slis_fieldname, " field with currency unit

ctabname type slis_tabname, " and table

ifieldname type slis_fieldname, " initial column

quantity(3) type c,

qfieldname type slis_fieldname, " field with quantity unit

qtabname type slis_tabname, " and table

round type i, " round in write statement

exponent(3) type c, " exponent for floats

key(1) type c, " column with key-color

icon(1) type c, " as icon

symbol(1) type c, " as symbol

checkbox(1) type c, " as checkbox

just(1) type c, " (R)ight (L)eft (C)ent.

lzero(1) type c, " leading zero

no_sign(1) type c, " write no-sign

no_zero(1) type c, " write no-zero

no_convext(1) type c,

edit_mask type slis_edit_mask, "

emphasize(4) type c, " emphasize

fix_column(1) type c, " Spalte fixieren

do_sum(1) type c, " sum up

no_out(1) type c, " (O)blig.(X)no out

tech(1) type c, " technical field

outputlen like dd03p-outputlen,

offset type dd03p-outputlen, " offset

seltext_l like dd03p-scrtext_l, " long key word

seltext_m like dd03p-scrtext_m, " middle key word

seltext_s like dd03p-scrtext_s, " short key word

ddictxt(1) type c, " (S)hort (M)iddle (L)ong

rollname like dd03p-rollname,

datatype like dd03p-datatype,

inttype like dd03p-inttype,

intlen like dd03p-intlen,

lowercase like dd03p-lowercase,

end of slis_fieldcat_main0.

types: begin of slis_fieldcat_main1,

ref_fieldname like dd03p-fieldname,

ref_tabname like dd03p-tabname,

roundfieldname type slis_fieldname,

roundtabname type slis_tabname,

decimalsfieldname type slis_fieldname,

decimalstabname type slis_tabname,

decimals_out(6) type c, " decimals in write statement

text_fieldname type slis_fieldname,

reptext_ddic like dd03p-reptext, " heading (ddic)

ddic_outputlen like dd03p-outputlen,

end of slis_fieldcat_main1.

Regards,

Jagadish

Former Member · ‎2008 May 23

Hi Robo,

1.If the value Associates a sign,then the sign can display with the value.Suppose dmbtr field consist the values with sign,then it can display the value with sign.

Regards,

Shiva Kumar

kesavadas_thekkillath · ‎2008 May 23

ultiply the value with -1.

value without sign is always +ve

Former Member · ‎2008 May 23

hi ricky ..use this cunction module..

CLOI_PUT_SIGN_IN_FRONT

check this example..

REPORT ztest_alv_perc_13317.

TYPE-POOLS: slis.

DATA: it_fieldcat TYPE slis_t_fieldcat_alv,

wa_fieldcat TYPE slis_fieldcat_alv,

it_events TYPE slis_t_event,

wa_events TYPE slis_alv_event,

it_sort TYPE slis_t_sortinfo_alv,

wa_sort TYPE slis_sortinfo_alv,

l_layout TYPE slis_layout_alv.

TYPES: BEGIN OF ty_itab,

field1(10),

qty1(3) TYPE c,

qty2 TYPE i,

qty3 TYPE i,

dummy TYPE c,

END OF ty_itab.

DATA: itab TYPE STANDARD TABLE OF ty_itab WITH HEADER LINE,

itab1 TYPE ty_itab.

START-OF-SELECTION.

itab-field1 = 'FIRST'.

itab-qty1 = 2.

itab-qty2 = 1.

itab-qty3 = 5.

itab-dummy = 10.

APPEND itab.

itab-field1 = 'FIRST'.

itab-qty1 = '-2'.

itab-qty2 = 1.

itab-qty3 = 5.

itab-dummy = 10.

APPEND itab.

itab-field1 = 'FIRST'.

itab-qty1 = '-8'.

itab-qty2 = 1.

itab-qty3 = 5.

itab-dummy = 10.

APPEND itab.

wa_fieldcat-col_pos = 1.

wa_fieldcat-fieldname = 'FIELD1'.

wa_fieldcat-tabname = 'ITAB'.