sap scripts

Former Member — Sat, 17 Mar 2007 13:45:54 GMT

hi experts,

i ve a task to add taxes in purchase order form for every material , evrything is fine with po form except taxes , how can i do that and in which include i can do that and help me with some coding for calculating taxes for each material.

Re: sap scripts

Former Member — Mon, 19 Mar 2007 04:47:10 GMT

Hi Kannan,

Find out the field for tax and use AT NEW statement. For every new meterial SUM. Hope this helps you.

Regards,

Kumar

Re: sap scripts

Former Member — Mon, 19 Mar 2007 04:54:05 GMT

HI,

Write an external subroutine to get the tax related amounts for that PO and Material;

Two ways to get them:

first check in KONV table by passing the EKKO-KNUMV field to the table. search by KSCHL field whether the required taxes exist in that table or not.

second method:

With the help of condition type for that Taxes(KSCHL), Vendor(LIFNR) and Material(MATERIAL) taxes will be stored in some A* tables(Like A021), pass these 3 fields and get the KNUMH field and pass that field to KONP table and get the Tax values:

see the sample routine to be written in script and program:

REPORT ZMPO1 .

form get_freight tables in_par structure itcsy out_par structure itcsy.

tables: ekko,konv,t685t.

data: begin of itab occurs 0,

ebeln like ekko-ebeln,

knumv like ekko-knumv,

end of itab.

data: begin of itab1 occurs 0,

knumv like konv-knumv,

kposn like konv-kposn,

kschl like konv-kschl,

kbetr like konv-kbetr,

waers like konv-waers,

kwert like konv-kwert,

end of itab1.

data: begin of iout occurs 0,

kschl like konv-kschl,

vtext like t685t-vtext,

kbetr like konv-kbetr,

kwert like konv-kwert,

end of iout.

data v_po like ekko-ebeln.

read table in_par with key 'EKKO-EBELN'.

if sy-subrc = 0.

v_po = in_par-value.

select

ebeln

knumv

from ekko

into table itab

where ebeln = v_po.

if sy-subrc = 0.

loop at itab.

select

knumv

kposn

kschl

kbetr

waers

kwert

into table itab1

from konv

where knumv = itab-knumv and

kappl = 'M'.

endloop.

loop at itab1.

if itab1-kposn <> 0.

select single * from t685t

where kschl = itab1-kschl

and kappl = 'M'

and spras = 'EN'.

iout-vtext = t685t-vtext.

iout-kschl = itab1-kschl.

iout-kbetr = itab1-kbetr.

iout-kwert = itab1-kwert.

append iout.

clear iout.

endif.

endloop.

sort itab1 by kposn.

loop at iout.

sort iout by kschl.

if ( iout-kschl eq 'GSDC' OR

iout-kschl eq 'GSFR' OR

iout-kschl eq 'GSIR' ).

at end of kschl.

read table iout index sy-tabix.

sum.

write:/ iout-kschl,iout-vtext,iout-kwert.

out_par-name = 'A1'.

out_par-value = iout-vtext.

append out_par.

out_par-name = 'A2'.

out_par-value = iout-kwert.

append out_par.

endat.

endif.

endloop.

endif.

endform.

IN THE FORM I AM WRITING THIS CODE.

/:DEFINE &A1& = ' '

/:DEFINE &A2& = ' '

/:PERFORM GET_FREIGHT IN PROGRAM ZMFORM_PO1

/:USING &EKKO-EBELN&

/:CHANGING &A1&

/:CHANGING &A2&

/:ENDPERFORM

&A1&
&A2&

This Code is to be written in the PO form under ADDRESS window.

/:DEFINE &A1& = ' '

/:DEFINE &A2& = ' '

/:DEFINE &A3& = ' '

/:DEFINE &A4& = ' '

/:DEFINE &A5& = ' '

/:DEFINE &A6& = ' '

/:PERFORM GET_VENDOR IN PROGRAM ZMFORM_PO

/:USING &EKKO-EBELN&

/:CHANGING &A1&

/:CHANGING &A2&

/:CHANGING &A3&

/:CHANGING &A4&

/:CHANGING &A5&

/:CHANGING &A6&

/:ENDPERFORM

&A1&
&A2&
&A3&
&A4&
&A5&
&A6&

reward if useful.

Regards,

Anji

Re: sap scripts

Former Member — Mon, 19 Mar 2007 05:02:38 GMT

i think by default SAPFM06P print prog assigned to MEDRUCK..

just check

INCLUDE FM06PF01

INCLUDE FM06PF02

regards

shiba dutta

topic Re: sap scripts in Application Development and Automation Discussions

sap scripts

Re: sap scripts

Re: sap scripts

Re: sap scripts