topic Re: table in Sapscript in Application Development and Automation Discussions

table in Sapscript

Former Member — Tue, 27 Dec 2005 07:18:37 GMT

Hi All1

Is it possible to draw column lines in SAPSCRIPT for a dynamic table.Please suggest me the ways to accomplish this.

Thanks in advance

Prasanna Kumar

Re: table in Sapscript

Former Member — Tue, 27 Dec 2005 07:21:47 GMT

Hi prasanna,

1. No its not possible for dynamic table

having x number of rows.

2. At the most we can use the character

| (vertical line character)

but it won't look good.

(ie. it won't look like a table grid )

Regards,

Amit M.

Re: table in Sapscript

madan_ullasa — Tue, 27 Dec 2005 07:28:50 GMT

Yeah u can.

try sy-vline...

its like this..

in your script write,

&tab-field& &Sy-vline&. write this below a text element.

and use this in fm "WRITE_FORM". as u loop the table, each time the sy-vline is output.

hope this helps..:)-

madan...

Re: table in Sapscript

madan_ullasa — Tue, 27 Dec 2005 07:32:47 GMT

please close the thread by awarding points if your query is solved.

regrds,

Madan

Re: table in Sapscript

Former Member — Tue, 27 Dec 2005 07:38:16 GMT

Hi Prasanna,

Since it is dynamic table you cannot get the table view.

even if you use sy-vline.

regards

vijay

Re: table in Sapscript

Former Member — Tue, 27 Dec 2005 07:50:49 GMT

Not really,

But i have done it before, Though there are some limits to it.

You make a box in SAPSCRIPT with following statement

/: BOX FRAME 10 TW

draws a box around the window

You can create colums by drawing other boxes like this

/: BOX WIDTH '10' CM HEIGHT 1 CM FRAME 10 TW

and

/: BOX XPOS '10' CM WIDTH '10' CM HEIGHT 1 CM FRAME 10 TW

and so on

To have them dynamically there only one dirty solution (can be done with limited number of lines)

In you sapscript you make code like this.

/: IF &counter& > 1.

/: BOX WIDTH '10' CM HEIGHT 1 CM FRAME 10 TW

/: ENDIF.

/: IF &counter& > 2.

/: BOX YPOS '1' CM WIDTH '10' CM HEIGHT 1 CM FRAME 10 TW

/: ENDIF.

...

In your print program you have your output table and you do this test

abap code

DATA : counter type i.

DESCRIBE table out_tab lines into counter.

As you can see this can be done if you need to make a dynamic table of something like 5-10 lines but for large chuncks of data this becomes to messy.

You can also try to replace the XPOS and YPOS with dynamic values ex /: BOX YPOS &YPOS& CM FRAME 10 TW

but i'm not sure this works.

Hope this help was usefull.

Best Regards,

Defour Frederik

Re: table in Sapscript

Former Member — Tue, 27 Dec 2005 11:25:17 GMT

Hi Frederik!

I am using a SAP standard print program.Can I do the changes to the standard print program?Also how to access the print program of a standard SAP program in SAp.Please advice.

Rewarded points

Thanks in advance

Prasanna Kumar

Re: table in Sapscript

Former Member — Tue, 27 Dec 2005 11:56:10 GMT

Hello,

Sure you can, but i would advice to use a copy instead.

Your printprogram can be altered through custumizing (SPRO) -> look for output control ( It's different for eatch form ex. invoice, delivery... ).

The form and printprogram are attached to the output type.

In your case it could be possible to do it without print program changes. If your lucky you could have a field in your outputtable that can act as the "counter".

ex. In a invoice -> tvbrp-posnr ( If i recall correct ).

Hope this helps.

Best Regards,

Frederik Defour

Re: table in Sapscript

Former Member — Tue, 27 Dec 2005 14:07:28 GMT

Hi frederik!

I am working on customer statements F140_ACC_stat_01 standard program.Can u please suggest me the field name to be taken as the counter in this case.

Thanks

Prasanna KUmar

Re: table in Sapscript

Former Member — Tue, 27 Dec 2005 14:21:13 GMT

Sorry can't help you further with this one. Our Sap version has no F140... program.

Just use the sapscript debugger an see what fields and structures are used during printing. Front screen se71 > from menu > activate debugger.

Always helps me to find fields during sapscript.

Greetz,

Frederik Defour

Re: table in Sapscript

Former Member — Wed, 01 Feb 2006 12:16:25 GMT

hi aLL

i am using this as driver program to print the form

F140_ACC_STAT_01 problem is i am not able know from where the addresss is being picked from

This is about Account Statement printing output. The Logo has displayed in NZ (correct) but the address is still in Australia (wrong). It should be New Zealand Address.

can any oe tell me solution to do this

or at least from where the address is being picked in there based on which condition.

with regards

siddhartha

Re: table in Sapscript

Former Member — Wed, 01 Feb 2006 15:29:39 GMT

Hello,

Address is usually picked using pre-configured

INCLUDE T001G-TXTAB OBJECT TEXT ID ADRS LANGUAGE T001-SPRAS

Go to the table T001G and check the name of text go to the SO10 ... and ask your module consultant if you could change this text or maybe create the new ones in customizing

Bogusia