SAP取税率

通过跟踪SAP标准函数GET_TAX_PERCENTAGE

 税率是通过取A003的条件记录编号KNUMH，然后KONP-KNUMH = A003-KNUMH，KONP-KOPOS = 01 取KONP-KBETR，得到的值除以1000

  SELECT DISTINCT
  a003~mwskz,
  a003~aland,
  division( konp~kbetr,1000,2 ) AS zsl     "税率
  FROM a003
  INNER JOIN konp  ON a003~knumh = konp~knumh
  INNER JOIN +eina ON a003~aland = +eina~land1 AND a003~mwskz = +eina~mwskz
  WHERE a003~kappl = 'TX'
  AND   a003~kschl = 'MWVS'
  AND   konp~kopos = '01'