Character type column alignment issue-SAP script

[Former Member]

Hello friends,

I am working on a SAP script, my form has four columns: Description, Quantity, Rate and Amount.

Description is of type bseg-sgtxt

Quantity is of type bseg-xref1 i.e. character 12

Rate is of type bseg-xref2 i.e. character 12

Amount is of type bseg-wrbtr i.e. Curr 13

Now my problem is quantity, rate and amount all can have decimal values and somehow these values are not getting aligned with decimal character.

I created a Paragraph format with the following TAB position:

Number  Tab position       Alignment

1          1.00   CM           LEFT

2          12.00  CM          DECIMAL

3          18.00  CM          DECIMAL

4           22.00 CM           DECIMAL

when I run my program with the above settings I get the attached output where only the Quantity column is getting aligned at the decimal character.

Can you please look into this and help me with what I am missing here?

[nabheetscn]

Hi Rajat

The quantity/Rate/Amount should be right aligned..Check in old editor you have proper tabs. It should be ,,

Thanks

Nabheet

[Former Member]

Hi Nabheet,

I tried the following setting:

Number     Tab position       Alignment

1          1.00   CM          LEFT

2          19.00  CM          RIGHT

3          22.00  CM          RIGHT

4          24.00  CM          RIGHT

Rate and amount columns are correctly aligned but the quantity column is still not aligned correctly. Please have a look at the attached file.

[Former Member]

Hi,

Make alignment as SIGN and try.

Regards,

Charan M.

[Former Member]

Hi CHaran,

I tried that too but the quantity column is not getting aligned properly.

[nabheetscn]

Can you pleade attach a screen shot of sap script code with old editor. Want to know about tabs given in element

[Former Member]

HI,

Me to faced same problem earlier, what i did is amount should be aligned towards right side for all the  three fields with single digit( please find the screen shot for the same), and change the alignment to sign.After doing this what ever amount you will give then it will align properly.

[Former Member]

Hi charan,

I tried what you recommended and this is what I am getting:

Thanks.

[nabheetscn]

Can you please attach your tab screen shot in classical editor of sapscript.. ?

[Former Member]

Have you tried changing the Quantity to SIGN or CENTER