[Foreword]

Decision has been deeply involved in the SAP field for more than 19 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]

Large corporations require their subsidiaries and branches to input the consolidation transaction type when entering financial documents, facilitating the generation of consolidated financial statements by the group headquarters. How can this consolidation transaction type be entered into document line items in the SAP system?
 

[Problem Analysis]

1. Compile a list of merge transaction types for the group headquarters and configure the merge transaction types using transaction code OC08.
 

2. Account types are categorized as follows:

S General Ledger Accounts

D Customer Control Accounts

K Supplier Control Accounts

A Asset Control Accounts

M Materials & Inventory Control Accounts

3. In the SAP system, each account type has a different voucher generation method, so the merged transaction type needs to be considered for each account type.

4. Adjust the field status group, transaction code OBC4, and set the merged transaction type to: Optional.
 

5. Account Type = S General Ledger Account

Taking transaction code FB01/F-02 as an example, in the "Other" field, COBL-RMVCT (CodingBlock field) is used.
 

6. Account Type = D Customer Control Account

Taking transaction code FB01/F-02 as an example, in "Other Data", BSEG-BEWAR (not the CodingBlock field) is used.
 

7. Account Type = K Vendor Control Account

Taking transaction code FB01/F-02 as an example, in "Other Data", BSEG-BEWAR (not the CodingBlock field) is used.
 

8. Account Type = A Asset Control Account

SAP provides a configuration table, transaction code OCBO, that maps asset business types to merged transaction types.
 

9. Account Type = M Material Inventory Control Account

SAP provides a configuration table, transaction code SM30, view V_T856L, to map the movement type and evaluation type.
 

10. The merge transaction type has over 130 defined enumeration values, requiring custom development and maintenance of three tables:

A. Merge Transaction Groups
 

B. Merge transaction categories and corresponding merge transaction options
 

C. Each subject corresponds to a merged transaction group.
 

11. For the COBL-RMVCT field, the search help is COBL_EX_RMVCT.
 

12. For the BSEG-BEWAR field, the search help has been changed to: COBL_EX_RMVCT.

Before modification:
 

Revised version:
 

13. When processing vouchers manually at the front desk, after entering "Accounts Receivable," users can select the corresponding merged transaction type. There are only 6 types available, which is convenient for users. (Displaying more than 130 types would make it inconvenient for users to choose.)
 

14. To import vouchers in batches, call the function BAPI_ACC_DOCUMENT_POST.
 

As you can see, the BAPIACGL09 structure contains a corresponding merge transaction type;

However, BAPIACAR09 and BAPIACAP09 do not have corresponding merge transaction types.

Therefore, the voucher batch extension structure ZSEXTEN needs to be adjusted.
 

Note: The field is RMVCT, not BEWAR, because the voucher is generated through the ACCIT structure, and in the ACCIT structure, the merge transaction type field is RMVCT.

Testing BAPI import of vouchers:
 

After importing, querying the vouchers shows that the batch import of S/D/K account type vouchers indicates that the merged transaction type data was entered correctly.
 

15. SAP also has a configuration option, transaction code SM30 view V_T856K, which allows you to configure the merge transaction type based on account and debit/credit side.
 

【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. Nineteen years of quality, trustworthy!