topic Insert blank row in internal table having numeric fields in Application Development and Automation Discussions

Insert blank row in internal table having numeric fields

Former Member — Tue, 06 Oct 2009 10:49:24 GMT

I want to insert blank row in internal table (all the fields are numeric).

I m using ALV grid.

I want to display data like :

Name Amount1 Amount 2 Amount 3

A 1.00 7.00 3.00

B 4.00 1.00 8.00

C 5.00 9.00 8.00

<-----here i want to insert blank row

Total 10.00 17.00 19.00

and i m using :

APPEND INITIAL LINE TO ITAB_FINAL.

Output is :

Name Amount1 Amount 2 Amount 3

A 1.00 7.00 3.00

B 4.00 1.00 8.00

C 5.00 9.00 8.00

0.0 0.0 0.0 <----- Cause all the fields are currency type

Total 10.00 17.00 19.00

What should I do , please help me out.

Edited by: Pooja Rawat on Oct 6, 2009 4:20 PM

Re: Insert blank row in internal table having numeric fields

Former Member — Tue, 06 Oct 2009 10:51:22 GMT

That's just not possible.

But why do you even want that?

Re: Insert blank row in internal table having numeric fields

Former Member — Tue, 06 Oct 2009 10:52:31 GMT

make all fields as string type

Re: Insert blank row in internal table having numeric fields

Former Member — Tue, 06 Oct 2009 10:54:16 GMT

If the field types are currency it wont be possible. One way is to declare another internal table with fields of type string and append the lines of the previous internal table to the new one and the try using APPEND INITIAL LINE TO ITAB_FINAL

Re: Insert blank row in internal table having numeric fields

MarcinPciak — Tue, 06 Oct 2009 10:57:23 GMT

You did correctly with appending initial line, just set in fieldcatalog NO_ZERO = 'X'. it will suppress zeros output, hence will print empty line.

Regards

Marcin

Re: Insert blank row in internal table having numeric fields

Former Member — Tue, 06 Oct 2009 10:58:05 GMT

You may try creating another internal table with all fields of character type and use the same for appending blank line. Hence pass this internal table to ALV.

Thanks,

Preyansh

Re: Insert blank row in internal table having numeric fields

Former Member — Tue, 06 Oct 2009 11:04:11 GMT

I didn't find NO_ZERO = 'X'.

can u send me the syntax.

Re: Insert blank row in internal table having numeric fields

Former Member — Tue, 06 Oct 2009 11:04:42 GMT

Forget about the initial line and the total line. Use the ALV functionality to calculate any totals.

Re: Insert blank row in internal table having numeric fields

Former Member — Tue, 06 Oct 2009 11:09:28 GMT

NO_ZERO is in fieldcatalog,

gs_fcat-no_zero = 'X'.

ths gs_fcat is of type slis_fieldcat_alv

Re: Insert blank row in internal table having numeric fields

Former Member — Tue, 06 Oct 2009 11:19:51 GMT

I m using 'REUSE_ALV_GRID_DISPLAY'.

Re: Insert blank row in internal table having numeric fields

Former Member — Tue, 06 Oct 2009 11:29:58 GMT

I m using 'REUSE_ALV_GRID_DISPLAY'

How can I use ALV functionality to calculate the total.

Re: Insert blank row in internal table having numeric fields

MarcinPciak — Tue, 06 Oct 2009 11:42:18 GMT


> I m using 'REUSE_ALV_GRID_DISPLAY'
> 
> How can I use ALV functionality to calculate the total.

Sorry, but what you really need: add blank line or calculate total? I guess the initial question was different.

As for the component NO_ZERO, it it in SLIS type pool, more precisely type slis_fieldcat_main0 which is part of slis_fieldcat_alv . This one you used for typing fieldcatalog?

Regards

Marcin