通过跟踪SAP标准函数
税率是通过取A003的条件记录编号KNUMH,然后KONP-KNUMH = A003-KNUMH,KONP-KOPOS = 01 取KONP-KBETR,得到的值除以1000
SELECT DISTINCTa003~mwskz,a003~aland,division( konp~kbetr,1000,2 ) AS zsl "税率FROM a003INNER JOIN konp ON a003~knumh = konp~knumhINNER JOIN +eina ON a003~aland = +eina~land1 AND a003~mwskz = +eina~mwskzWHERE a003~kappl = 'TX'AND a003~kschl = 'MWVS'AND konp~kopos = '01'