topic Re: Character type column alignment issue-SAP script in Application Development and Automation Discussions

Character type column alignment issue-SAP script

Former Member — Tue, 05 Nov 2013 13:04:34 GMT

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?

Re: Character type column alignment issue-SAP script

nabheetscn — Tue, 05 Nov 2013 13:06:40 GMT

Hi Rajat

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

Thanks

Nabheet

Re: Character type column alignment issue-SAP script

Former Member — Tue, 05 Nov 2013 13:49:17 GMT

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.

Re: Character type column alignment issue-SAP script

Former Member — Tue, 05 Nov 2013 14:48:03 GMT

Hi,

Make alignment as SIGN and try.

Regards,

Charan M.

Re: Character type column alignment issue-SAP script

Former Member — Tue, 05 Nov 2013 14:58:59 GMT

Hi CHaran,

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

Re: Character type column alignment issue-SAP script

nabheetscn — Tue, 05 Nov 2013 15:11:52 GMT

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

Re: Character type column alignment issue-SAP script

Former Member — Tue, 05 Nov 2013 16:00:44 GMT

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.

Re: Character type column alignment issue-SAP script

Former Member — Tue, 05 Nov 2013 18:26:30 GMT

Hi charan,

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

Thanks.

Re: Character type column alignment issue-SAP script

Former Member — Wed, 06 Nov 2013 06:24:38 GMT

Have you tried changing the Quantity to SIGN or CENTER

Re: Character type column alignment issue-SAP script

nabheetscn — Wed, 06 Nov 2013 06:31:28 GMT

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