topic Re: more and more about scripts...... in Application Development and Automation Discussions

more and more about scripts......

kiran_k8 — Wed, 06 Jun 2007 06:19:30 GMT

Hi Folks,

1.How to validate the no.of records that has to be printed per page I mean to say I just want to print only 10 records in the first page,if the records exceeds then it has to go to next page.?

2.I have a barcode which has to be displayed only at the last page,how?

3.I am using &sy-pagno& but it is not incrementing,it is showing page number as 0 on all the pages.How to correct this.

4.Can we give colors to the text in scripts?

Thanks,

K.Kiran.

Note:- I will be posting many questions related to scripts under the same thread,so please do consider.

Re: more and more about scripts......

Former Member — Wed, 06 Jun 2007 06:25:11 GMT

1.How to validate the no.of records that has to be printed per page I mean to say I just want to print only 10 records in the first page,if the records exceeds then it has to go to next page.?

Generally we see the print previews of the Document and see how many recoprds/items are printing correctly and we ADJUST THE SIZE OF THE WINDOW, as we can't not handle the no of records in internal table in script.

so based on the window size we restrict limit the print.and we use

PROTECT..ENDPROTECT to see that all the records related to a item is printed in that page itself.

2.I have a barcode which has to be displayed only at the last page,how?

see the attached doc below(lastly)

3.I am using &sy-pagno& but it is not incrementing,it is showing page number as 0 on all the pages.How to correct this.

Use the variable &PAGE& to print the page

&SAPSCRIPT-FORMPAGES& will give the total no of pages.

4.Can we give colors to the text in scripts?

NO colors, only you can change the FONT size.

Barcode:

To Create a Bar code prefix:

1) Go to T-code - SPAD -> Full Administration -> Click on Device Type -> Double click the device for which you wish to create the print control -> Click on Print Control tab ->Click on change mode -> Click the plus sign to add a row or prefix say SBP99 (Prefix must start with SBP) -> save you changes , it will ask for request -> create request and save

2) Now when you go to SE73 if you enter SBP00 for you device it will add the newly created Prefix

Create a character format C1.Assign a barcode to the character format.Check the check box for the barcode.

The place where you are using the field value use like this

<C1> &itab-field& </C1>.

You will get the field value in the form of barcode.

Which barcode printer are you using ? Can you download this file and see.

http://www.servopack.de/Files/HB/ZPLcommands.pdf.

It will give an idea about barcode commands.

Check this link:

http://www.sap-img.com/abap/questions-about-bar-code-printing-in-sap.htm

Check this link:

http://help.sap.com/saphelp_nw04/helpdata/en/d9/4a94c851ea11d189570000e829fbbd/content.htm

Detailed information about SAP Barcodes

A barcode solution consists of the following:

- a barcode printer

- a barcode reader

- a mobile data collection application/program

A barcode label is a special symbology to represent human readable information such as a material number or batch number

in machine readable format.

There are different symbologies for different applications and different industries. Luckily, you need not worry to much about that as the logistics supply chain has mostly standardized on 3 of 9 and 128 barcode symbologies - which all barcode readers support and which SAP support natively in it's printing protocols.

You can print barcodes from SAP by modifying an existing output form.

Behind every output form is a print program that collects all the data and then pass it to the form. The form contains the layout as well as the font, line and paragraph formats. These forms are designed using SAPScript (a very easy but frustratingly simplistic form format language) or SmartForms that is more of a graphical form design tool.

Barcodes are nothing more than a font definition and is part of the style sheet associated with a particular SAPScript form. The most important aspect is to place a parameter in the line of the form that points to the data element that you want to represent as barcode on the form, i.e. material number. Next you need to set the font for that parameter value to one of the supported barcode symbologies.

Reward points if useful

Regards

Anji

Re: more and more about scripts......

Former Member — Wed, 06 Jun 2007 06:48:52 GMT

Hi.

Additional info to 1.

You can do a limitation to x records per page. Therefore you have to create a element in mainwindow containing the sapscript statement

/: NEW-PAGE

In the loop over your records you call the newly created element if you reached the 10th record. Don't forget to initialize the counter afterwards.

Regards,

Timo.

Re: more and more about scripts......

kiran_k8 — Wed, 06 Jun 2007 07:01:14 GMT

Anji,

Thanks a ton.

1.Page No and no.of records per page issue got solved.

2.I want to give index to the records like 1,2,3.... on every page,I used sy-tabix but didn't get the desired result.How to achieve this?

3.Bar code I am using aufnr which is sap defined.The PDF you had given is very handy.I have to go through in detail.I am getting the barcode in all the pages but I want it to be confined to only last page.How to do that.

4.If possible kindly let me know how to create a label in a script and its usage.

Once again thanks a ton.

K.Kiran.

Message was edited by:

Kiran K

Re: more and more about scripts......

kiran_k8 — Wed, 06 Jun 2007 08:30:47 GMT

Hi,

If I am giving like this in sap script text editor

if &page& = 5

<c1?

endif.

I am getting the barcode in the last page which is 5th.

If I am giving like this in sap script text editor

if &page& = &sapscript-formpages&

<c1>

endif.

I am not getting the barcode in the lastpage.

Where I am going wrong.

Thanks,

K.Kiran

Re: more and more about scripts......

Former Member — Thu, 07 Jun 2007 13:40:19 GMT

Hi.

You want to print an index to every item and start at 1 again if a page break occurs? Then you should count up a variable in your loop an refresh it, if you force a page break.

Unfortunately you can't use the variable &sapscript-formpages&. This variable is determined at the very end of the processing. So at the moment your last page is printed it is not available.

You have to count the remaining items in your loop.

If it is less or equal the number of entries on one page, you must switch to another page similar to the 4 pages before but where the barcode is defined.

So use NEW_PAGE BARC if your page with barcode defined is called BARC.

Hope that helps,

Timo.

Re: more and more about scripts......

kiran_k8 — Tue, 24 Jul 2007 05:38:18 GMT

Problem Solved.

Thanks a ton.

K.Kiran.