在配置新系統時未配置 成本過賬的更新，導致所有費用過賬的成本中心和利潤中心未更新到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.

總結

以上是生活随笔為你收集整理的SAP FI FAGLFLEXT/FAGLFLEXA 数据不正确重新更新操作的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。