SAP 采购订单税率及含税金额取数

税码

 联查A003及KONP

 

 

    "采购税码的税率SELECT a~mwskz, "税码k~kbetr  "税率INTO TABLE @DATA(t_sl)FROM a003 AS a INNER JOIN konp AS kON a~knumh = k~knumhWHERE a~mwskz IN ( 'J0' , 'J1' , 'J2' , 'J3' , 'J4' , 'J5' , 'J6' )AND a~aland = 'CN'.SORT t_sl BY mwskz.......READ TABLE t_sl INTO DATA(s_sl) WITH KEY mwskz = ls_ekpo-mwskz BINARY SEARCH.IF sy-subrc = 0."含税单价itab-zhsdj = ls_ekpo-netpr  / ls_ekpo-peinh * ( 1 + s_sl-kbetr / 1000 )."含税总金额itab-zhsze = ls_ekpo-netpr  / ls_ekpo-peinh * ( 1 + s_sl-kbetr / 1000 ) * ls_ekpo-menge.ENDIF.    

另外，标准RFC GET_TAX_PERCENTAGE 也可以获得税率

 

不过这个函数会有循环，影响时间。实际上如果税码和税率不变的话，最直接的做法是自定义内表，罗列下税码和税率关系就行。