Reg. Total in sap script

[Former Member]

I want Total in my script

my script design is

Amt disc amt

abc 100

___________________

Total 100

so is there any standard text in sap scriptfor total ?????

or define variable in print prog and also in sap script????

give me suggetion step by step

Vishal

[Former Member]

Hi Vishal,

Go through below link

http://sap-img.com/sapscripts/sapscript-how-to-calculate-totals-and-subtotals.htm

Regards,

Satish

[naimesh_patel]

Yes, you can define a variabe in your print program and pass it to the SAPScript.

LIKE:

Define L_SUM in the Global data.

DATA: L_SUM TYPE BSEG-DMBTR.


LOOP AT ITAB.
  L_SUM = L_SUM + ITAB-AMOUNT.
ENDLOOP.

CALL FUNCTION 'WRITE_FORM'
  WINDOW = 'MAIN'
  ELEMENT = 'TOTAL'.

Now, in your SAPScript, create a text element in MAIN window

/E TOTAL
*  Total,, &L_SUM&.

Regards,

Naimesh Patel

[Former Member]

Hi Naimesh,

But what i declare in itab-amount... cause i write currency field direct in sap script.

Like &regup-dmbtre&. i have not use iyab for currency(amount) field...

Vishal

[naimesh_patel]

Do you have your custom SAPScript and print program? I means Z developments

Regards,

Naimesh Patel

[Former Member]

Hi Naimesh,

I have create new SAP Script and i use zprog of standard sap print prog.

Vishal

[naimesh_patel]

In your Z prog you are calling the WRITE_FROM for the MAIN window and the amount which you are printing.

After that CALL Funciton, just add that amount to one variable.

L_SUM = L_SUM + REGUP-DMBTR.

And use this L_SUM in your SAPScript as per my earlier post.

Regards,

Naimesh Patel

[Former Member]

Hi Naimesh,

when i debuging my print program I got a value of L_SUM as well as i debuging in script also but in sap script L_SUM value is blank....... i declare write call function

then L_SUM = L_SUM + REGUP-DMBTR.

give me suggetion in which point i missing.

Vishal

[naimesh_patel]

Data definition of the L_SUM must be in the global data definition or TOP include.

DATA: L_SUM LIKE BSEG-DMBTR.

Regards,

Naimesh Patel

[Former Member]

Hi Naimesh,

Sorry for late reply.... but yet not working L_SUM is a blank.

Vishal

[naimesh_patel]

You need to call the WRITE_FORM for the TOTAL text element after your L_SUM = L_SUM + REGUP-DMBTR calculation...

inside the loop:

L_SUM = L_SUM + REGUP-DMBTR .

and after the loop eg ENDLOOP.

CALL FUNCTION 'WRITE_FORM

ELEMENT = 'TOTAL'

WINDOW = 'MAIN'.

Regards,

Naimesh Patel

[Former Member]

hi vishal,

did your problem related to total in sapscript get solved.

was the solution given by naimesh working?