S4 ACDOCA会计凭证表的几个奇异点
S4 HANA会计凭证日记账表acdoca的一些奇特之处,做记录备忘。
1.如果一个凭证的BKPF-BSTAT = ‘U’ and ACDOCA-BSTAT = ‘U’,则该凭证在BSEG无行项目。因此SQL语句请写成类似如下格式,不要inner join bseg:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 |
define view ZCDS_TEST02 as select from acdoca as a inner join bkpf as b on a.rbukrs = b.bukrs and a.gjahr = b.gjahr and a.belnr = b.belnr left outer join bseg as c on a.belnr = c.belnr and a.rbukrs = c.bukrs and a.gjahr = c.gjahr and a.buzei = c.buzei { a.rbukrs, a.gjahr, a.belnr, a.buzei, a.docln, case when(a.drcrk = 'S' and a.hsl < 0 ) then 'H' //贷方反记账 when(a.drcrk = 'H' and a.hsl > 0 ) then 'S' //借方反记账 when(a.drcrk = 'S' and a.hsl > 0 ) then 'S' //普通的借方 when(a.drcrk = 'H' and a.hsl < 0 ) then 'H' //普通的贷方 end as drcrk, a.hsl, b.monat, b.waers, b.usnam, b.bktxt, c.rstgr, c.sgtxt } |
2.反记账行项目在ACDOCA中DRCRK字段是按相反反向存数据的,例如FB03显示是贷方反记账,则在ACDOCA中DRCRK的标识是S、金额与DRCRK所指的方向相反。没有专门的字段标识是反记账,只能通过DRCRK和金额的正负判断是否为反记账(S+负数,贷方反记账;H+正数,借方反记账)。
3.外币评估行项目默认不会进BSEG表,因此如果
剩余80%内容付费后可查看
如若转载,请注明出处:https://www.gavindong.com/3015.html