Invoice table, Lines move down with Font/Data type

[Former Member]

Hi,

I designed an invoice with 5 columns in the table.

MAT , MAT Description, Qty, Unit Price, Total Price.

The first two are character types, and the last three obviously number types ( type p to be precise).

The first two columns prints on the same line, but the last three drops down one line. Why does this happen and how can I fix it? Is it because of different data types, or perhaps the width of the columns?

Please help. I'm looking for bridges again...

[Former Member · Accepted solution]

Hi

exactly its because of data type and alignment, character are left justified and where as number are right justified.

Pls let me know if u need any clarifications

BR

Lavanya

Edited by: Lavanya K on Aug 11, 2008 3:50 PM

[Former Member]

I got it to work eventually - I changed the Data type, and it worked fine then.

[Former Member]

Try to create a paragraph format and define your tab spaces in paragrpah format, and use newly paragraph format while displaying your items.

Example create paragrpah format AS.

Define tab space in paragraph format

1.50 CM LEFT

4.00 CM Right

6.50 CM RIGHT

8.00 Cm Right

Use like this

AS &MAT& ,, &MAT Description&,, &Qty&,, &Unit Price&,, &Total Price&

Note: ,, represents tab space. try to adjust your tab spaces in you paragraph format.

Above mentioned is a a rough example.

rgds,

SaiRam

[Former Member]

Hi,

In smartforms this kind of problem would exist in two cases...

1. the material description field while being displayed use as below.

&table-field(<C)&

2. check for the third field ( quantity ) node in smartform ...

whether it is set with New Paragraph .If so then change it to 'Append directly '.

Regards,

Ram

[Former Member]

HI,

As they are of Decimal type...they are right justified...

inorder to fix this u need to condense last 3 fields...

ie in hte smart form or script while printing &Qty(C)&.

use the character C like this.

[Former Member]

Ok, more info on this problem.

When I use Font Helvetica, everything aligns properly on one line. When I change to Courier New (we're going to use dot matrix printers), the number formats drop down a line.

I've been trying to make the fields shorter with the SHIFT command, is there any other way to reduce the length of a field - in other words, say the field is 9 of length, but the amount is 1000, to reduce it to a length of 4?

Sorry for the trouble, I am very new to ABAP (this is my 6th month).

[Former Member]

HI,

This is mostly happening because of the allignment of the fields which are of numeric types.They are right justified so they are going on to the next line. So if you want those fields to be right alligned reduce the width of the colums little bit or you can make them left justified.

Hope this helps.

Thanks,

Sneha.