topic Re: scripts- subtotals in Application Development and Automation Discussions

scripts- subtotals

Former Member — Tue, 12 Jun 2007 09:44:48 GMT

Hi,

how to get subtotals on each page of a script?

Regards,

pritha.

Re: scripts- subtotals

Former Member — Tue, 12 Jun 2007 09:46:34 GMT

Declare a variable like

/: DEFINE &TOTAL&

/ total = total + <&itab-netwr&>

and display the TOTAL field for subtotals

Reward points for useful Answers

Regards

Anji

Re: scripts- subtotals

dev_parbutteea — Tue, 12 Jun 2007 09:49:09 GMT

<b>In scripts and smartforms how to calculate totals and subtotals?</b>

To calculate totals and sub totals in sap scripts you have to use subroutines.

Say if you have to add the unit price (KOMVD-KBERT) then in the main window whereever tat value is picked write this routine

/: DEFINE &TOT_PRICE&

/: PERFORM F_GET_PRICE IN PROGRAM <subroutine prog name> /:USING &KOMVD-KBERT& /:CHANGING &TOT_PRICE& /:ENDPERFORM

Then write the variable where ever you want it to be printed (mostly it will be in footer window)

Then create subroutine pool program and you have to write the code.

FORM F_GET_PRICE tables int_cond structure itcsy

outt_cond structure itcsy. data : value type kbert.

statics value1 type kbert.

Read int_cond table index 1.

value = int_cond-value.

value1 = value1 + value.

Read outt_cond table index 1.

outt_cond-value = value1.

Modify outt_cond index 1.

ENDFORM.

I have given a rough outline, please be aware of the variable conversions as Int_cond-value and outt_cond-value are characters.

Regards,

Sooness

Re: scripts- subtotals

Former Member — Tue, 12 Jun 2007 09:59:10 GMT

Hi,

I already get the subtotals for each sales order no.

But for 1 order, there r about 200 records.

So they go on the next page.....the subtotlas gets printed after a sales order number.

but i want it on each page.

hope u r getting me......

plz reply

Re: scripts- subtotals

Former Member — Tue, 12 Jun 2007 10:01:32 GMT

good

SAP Printer commands in SAPScripts The command line in the editor must be as follows: /: PRINT-CONTROL xxxxx or /: PRINT-CONTROL 'xxxxx' where xxxxx stands for the five-character name of the print control. Example: /: PRINT-CONTROL ZM100 The complete printer command normally resides in the print control. If characters belonging to the print command follow after the print control in the text (only useful for the HPL2 printer driver for PCL-5 printers), the text line following after the PRINT-CONTROL command should begin with an equals sign (=) in the format column. Example: /: PRINT-CONTROL SESCP = *c5G If you do not use the equals sign, a space character is inserted between the print control SESCP and the character *c5G. Different font on the same line You can have different font on the same line by defining a character format. For example B for bold text and U for Underline. In your SAPScript apply like this : Underline Text<> Bold Text<> Print Footer notes only on the last page Command to used in your sapscripts :- /: IF &NEXTPAGE& EQ 0 whatever footer you want. /: ENDIF SAPscripts How to calculate Totals and Subtotals I have some doubs in BDC and SMART FORMS. I want to change the material number using the transaction code MM02 through BDC. In scripts and smartforms how to calculate totals and subtotals? To calculate totals and sub totals in sap scripts you have to use subroutines. Say if you have to add the unit price (KOMVD-KBERT) then in the main window whereever tat value is picked write this routine /: DEFINE &TOT_PRICE& /: PERFORM F_GET_PRICE IN PROGRAM <subroutine prog name> /:USING &KOMVD-KBERT& /:CHANGING &TOT_PRICE& /:ENDPERFORM Then write the variable where ever you want it to be printed (mostly it will be in footer window) Then create subroutine pool program and you have to write the code. FORM F_GET_PRICE tables int_cond structure itcsy outt_cond structure itcsy. data : value type kbert. statics value1 type kbert. Read int_cond table index 1. value = int_cond-value. value1 = value1 + value. Read outt_cond table index 1. outt_cond-value = value1. Modify outt_cond index 1. ENDFORM. I have given a rough outline, please be aware of the variable conversions as Int_cond-value and outt_cond-value are characters

thanks

mrutyun^

Re: scripts- subtotals

Former Member — Tue, 12 Jun 2007 10:04:06 GMT

Hi,

To calculate totals and sub totals in sap scripts you have to use subroutines.

Say if you have to add the unit price (KOMVD-KBERT) then in the main window whereever tat value is picked write this routine

/: DEFINE &TOT_PRICE&

/: PERFORM F_GET_PRICE IN PROGRAM <subroutine prog name> /:USING &KOMVD-KBERT& /:CHANGING &TOT_PRICE& /:ENDPERFORM

Then write the variable where ever you want it to be printed (mostly it will be in footer window)

Then create subroutine pool program and you have to write the code.

FORM F_GET_PRICE tables int_cond structure itcsy

outt_cond structure itcsy. data : value type kbert.

statics value1 type kbert.

Read int_cond table index 1.

value = int_cond-value.

value1 = value1 + value.

Read outt_cond table index 1.

outt_cond-value = value1.

Modify outt_cond index 1.

ENDFORM.

I have given a rough outline, please be aware of the variable conversions as Int_cond-value and outt_cond-value are characters.

Regards,

Bhaskar

Re: scripts- subtotals

dev_parbutteea — Tue, 12 Jun 2007 10:21:54 GMT

Hi,

print your subtotals in the footer window

Regards,

Sooness

Re: scripts- subtotals

Former Member — Tue, 12 Jun 2007 10:33:56 GMT

Hi Sooness,

I m printing it on main window at the bottom.

I need the subtotals on each page.

if i m having a sales order number with 200 records, it gets it's subtotal at last but i want the subtotals on each page.

Thanks inadvance.

Points will be awarded.

pritha

Re: scripts- subtotals

dev_parbutteea — Tue, 12 Jun 2007 10:40:09 GMT

Hi,

actually if you print it in the main window , it will be printed after aal displayed records.

So ,if you want to print it in all pages , try printing it in footer window instead.

You just have to update subtotal after each record or sales order using a perform.

Regards,

Sooness