[Foreword]

Decision has been deeply involved in the SAP field for more than 18 years and has been praised by many customers. In order to better help customers implement digital projects, the "Decision Expert Column" is completely free and open source, paying tribute to Musk's open source spirit!

Based on the senior capabilities of Decision's expert consultant team with more than 20 years of SAP experience, combined with Decision's 1,000+ successful project cases, this article summarizes and publishes the corresponding research experience and suggestions of enterprises in promoting ERP project implementation, and continues to escort the SAP implementation and delivery of enterprises.
 

[Problem Description]

Check the November balance of account 1404020100 in transaction code FAGLB03: 844,527.49 CNY; Check the November balance of account 1404020100 in transaction code FAGLL03: 844,443.84 CNY; The difference between the two is: 83.65 CNY. After careful checking, it is found that there is a difference of one voucher:

 

[Problem Analysis]

1. The current system version is S4 HANA 2022, and the account balance is obtained from the ACDOCA table.
2. In the S4 HANA system, the financial voucher line items are copied into two sets, which are stored in the old table BSEG and the new table ACDOCA.
3. In the case of passing, most of the data line items in the old table BSEG and the new table ACDOCA are the same (except for voucher status = U).
4. Transaction code FAGLB03, when viewing the account balance, the data is aggregated and calculated from the new table ACDOCA.
5. Transaction code FAGLL03, when viewing the account balance, there are two views:
(1) General ledger view: data is read from the new table ACDOCA
(2) Entry view: data is read from the new table BSEG
(3) View in general ledger view: does not include voucher 5200000048
 

(4) View in input view: including certificate 5200000048
 

6. Transaction code FB03 carefully check voucher 5200000048

It can be seen that the subjects of voucher 5200000048 are different in the input view and general ledger view!

7. In the SAP system, the default subject does not allow substitution modification. Obviously, there is a problem with the subject substitution in the system. The subject is not substituted at the source of the voucher generation, but only the subject is forcibly substituted at the back end of the voucher, so it leads to: some data table subjects are substituted successfully, and some are not substituted successfully!
 

[Solution]

1. Cancel this wrong substitution enhancement.
2. Modify the subject of the ACDOCA table of voucher 5200000048 to be consistent with the BSEG table!

 

【Service Guide】
For more information on SAP courses, project consultation and operation and maintenance, please call Decision's official consultation hotline: 400-600-8756

【About Decision】
Global professional consulting, technology and training service provider, SAP gold partner, SAP software partner, SAP implementation partner, SAP official authorized training center. Eighteen years of quality, trustworthy!