SAP FI FAGLFLEXT/FAGLFLEXA 数据不正确重新更新操作

最新推荐文章于 2023-12-07 12:52:28 发布

SAP剑客

最新推荐文章于 2023-12-07 12:52:28 发布

阅读量6k

点赞数 1

分类专栏：程序人生 ABAPer

程序人生 ABAPer 专栏收录该内容

1330 篇文章 171 订阅

订阅专栏

在配置新系统时未配置成本过账的更新，导致所有费用过账的成本中心和利润中心未更新到FAGLFLEXT

反思：1、赶出来的工作，太容易出错；

2、以后别抢着干活，不然结果自己一个人承担；

3、锁事儿是否应该放开些；

解决办法：（亲测有效）

1. Delete data in FAGLFLEXT and FAGLFLEXA table data.

2. Use tranaction code GLGCU1 to transfer data BSEG to FLEX table,which would copied all dimension data from BSEG.

FROM: http://scn.sap.com/thread/3429789 ManiKumar Yandrapu

为偷懒，自己写段代码用来删除表的数据

data: it_faglflexa like table of faglflexa,
      it_faglflext like table of faglflext.
select * into corresponding fields of table it_faglflext
from faglflext
  where  ryear = '2016' and rbukrs = 'C801'.

select * into corresponding fields of table it_faglflexa
from faglflexa
  where  ryear = '2016' and rbukrs = 'C801'.

delete faglflexa from table it_faglflexa .
delete faglflext from table it_faglflext.

commit work.

下面的没用：

  data: it_faglflexa like table of faglflexa,
      it_faglflext like table of faglflext.
"处理2015无利润中心数据
*SELECT * INTO CORRESPONDING FIELDS OF TABLE it_faglflext
* FROM faglflext
*  WHERE  ryear = '2015' AND rldnr = '0L'.
*
*SELECT * INTO CORRESPONDING FIELDS OF TABLE it_faglflexa
* FROM faglflexa
*  WHERE  ryear = '2015' AND rldnr = '0L'.
*
*
*IF it_faglflexa IS NOT INITIAL .
*  DELETE faglflexa FROM TABLE it_faglflexa .
*
*ENDIF.
*IF it_faglflext IS NOT INITIAL.
*  DELETE faglflext FROM TABLE it_faglflext.
*ENDIF.
*
*CLEAR:it_faglflexa,it_faglflext.
*COMMIT WORK.
"""""""""""""""""""""""""""""""""""""
"处理2016无利润中心数据 C087

*SELECT * INTO CORRESPONDING FIELDS OF TABLE it_faglflext
* FROM faglflext
*  WHERE  ryear = '2016' AND rldnr = '0L' AND rbukrs = 'C087'.
*
*SELECT * INTO CORRESPONDING FIELDS OF TABLE it_faglflexa
* FROM faglflexa
*  WHERE  ryear = '2016' AND rldnr = '0L' AND rbukrs = 'C087'.
*IF it_faglflexa IS NOT INITIAL .
*  DELETE faglflexa FROM TABLE it_faglflexa .
*
*ENDIF.
*IF it_faglflext IS NOT INITIAL.
*  DELETE faglflext FROM TABLE it_faglflext.
*ENDIF.
*CLEAR:it_faglflexa,it_faglflext.
*
*COMMIT WORK.

""""""""""""""""""""""""""""""""""""""""
"处理结转无利润中心
select * into corresponding fields of table it_faglflext
from faglflext
  where  ryear = '2016' and rldnr = '0L' and prctr not between 'C001000000' and 'C999999999'.

if it_faglflext is not initial.
  delete faglflext from table it_faglflext.
endif.
clear:it_faglflexa,it_faglflext.

commit work.