采购订单、发票校验、会计凭证中有税码,需要获取其对应的百分比,
数据存储再A003和KONP中,创建如下视图:
@AbapCatalog.sqlViewName: 'ZSDV_R025_003_V'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: '税码的百分比清单'
define view ZSDV_R025_003_E
as select from a003 as a
inner join konp as b on a.mandt = b.mandt
and a.knumh = b.knumh
{
a.mandt,
a.mwskz,
b.kbetr
}
where
a.kappl = 'TX'
and a.kschl = 'MWVS'
and a.aland = 'CN'
实际使用时,获取的百分比数值需要除以1000