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

税码

 联查A003及KONP

 

 

    "采购税码的税率
    SELECT a~mwskz, "税码
           k~kbetr  "税率
      INTO TABLE @DATA(t_sl)
      FROM a003 AS a INNER JOIN konp AS k
        ON a~knumh = k~knumh
     WHERE 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 也可以获得税率

 

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