S4 ACDOCA会计凭证表的几个奇异点

2020.05.06 23:23 • 文章 • 阅读 1471

S4 HANA会计凭证日记账表acdoca的一些奇特之处，做记录备忘。

1.如果一个凭证的BKPF-BSTAT = ‘U’ and ACDOCA-BSTAT = ‘U’,则该凭证在BSEG无行项目。因此SQL语句请写成类似如下格式，不要inner join bseg：

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

}

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+正数，借方反记账）。

S4 ACDOCA会计凭证表的几个奇异点

3.外币评估行项目默认不会进BSEG表，因此如果

剩余80%内容付费后可查看

如若转载，请注明出处：https://www.gavindong.com/3015.html

S4 ACDOCA会计凭证表的几个奇异点

相关推荐

SAP取累计余额的思路

S4记账期间管理OB52和ECC的差异

C_TS4CO_1909考试信息

通过ABAP程序模拟CCMS对S4 HANA的数据库进行监控并邮件提醒异常

SAP S4 HANA新增公司代码配置注意事项