Skip to Content
Technical Articles

Migration of House Banks from ECC to SAP S/4HANA

Prima facie Migration of House Banks to SAP S/4HANA seems to be simple. Sometimes,  it creates challenging and interesting issues as we go through the Migration process.

I tried to provide a brief information, relating to House Bank Migration:

  1. What is New in SAP S/4HANA 1909 (from Migration Cockpit perspective)
  2. High level SAP S/4HANA Data Model changes relating to House Banks
  3. Pre-requisites for House Bank Migration
  4. House Bank Migration
  5. How to Access House Bank Accounts after migration.
  6. References/SAP Notes

What is New:

To simplify the migration process, as of SAP S/4HANA 1909, following manual steps are included in Central Migration Cockpit (Start and Monitor Data Migration)

  • Activities “Fill in Due Dates in FI Document and Display Status of Filling Due Dates into FI Documents are now executed automatically in the Enrich Transactional Data (ENR) step of the Start and Monitor Data Migration activity.

 

  • Migrate House Bank Accounts now executed automatically in the Migrate House Bank Account (T012K) to Bank Account (CM1) step of the Start and Monitor Data Migration Activity

 

  • Migrate General Ledger Allocations activity now executed automatically in the Migration of the GL Allocations (GL)AL_MIG) step of the Start and Monitor Data Migration activity.

 


High -level SAP S/4HANA Data Model Changes relating to House Banks:

House Banks in SAP S/4HANA:

  1. House bank accounts merged into bank account master data. As a part of migration,  house bank accounts originally stored in database table T012K moves to table FCLM_BAM_ACLINK2.
  2. After Migration, we can create the House banks using transaction code FI12_HBANK. This transaction code is only for creating the House bank but not Bank Accounts for House Banks.
  3. Activation of Business Function FIN_FSCM_CLM is not mandatory for Migration of House Banks. (Not full scope of CLM used)
  4. Some House Bank Related table names

Table Name

Description

FCLM_BAM_AC_LINK

Linkages Between House Bank Accounts and Bank Accounts

FCLM_BAM_AC_TYPE

Bank Account Type

FCLM_BAM_AC_TYPT

Bank Account Type Text

FCLM_BAM_ACLINK2

Linkages Between Bank Account and House Bank Accounts

FCLM_BAM_AMD

Bank Account Master Data

FCLM_BAM_AMD_T

Bank Account Master Data: Text table of Account Descriptio

FCLM_BAM_BKBPHIS

History for Bank and BP Linkage

FCLM_BAM_BNKABP2

Relationship between Bank and Business Partner

FCLM_BAM_CONFIG

Configuration for Bank Account Management

FCLM_BAM_HIER

Bank Account Hierarchy

FCLM_BAM_HIERBGN

Bank – bank group name mapping

FCLM_BAM_REQ

Change request for bank account master data

FCLM_BAM_REQACNT

Change Request:Bank Accounts

 


Pre-requisites for House Bank Migration

Following flow charts indicates the  pre-requisites before starting the Migration/Conversion.

 

The Bank Account Master Data Processing with Full Cash Management versions including Direct Revision Activate, Dual Control Revision Activate and Workflow Revision Activate, require an additional license for SAP Cash Management powered by SAP HANA.


House bank Migration

House Bank Migration is a part of Migration Cockpit. (IMG>Conversion of Accounting to SAP S/4HANA>Data Migration>Start and Monitor Data Migration.

All the pre-conversion requisites to be completed.

All pre-requisites for executing the Migration Cockpit is completed.

As a part of Migration Cockpit execution, House Bank also gets migrated.

If the errors are relating to pre-delivered content, we can also accept the errors, if we are convinced about the nature of those errors. If it is relating to the Business bank data information, further analysis and fix is required.

Based on the errors during Migration Cockpit execution, we can fix the errors whatever is possible, reset and reexecute the step in Migration Cockpit.

If any errors found during the migration cockpit run, we can also execute the house bank migration manually using Tcode: FCLM_BAM_MIGRATION. This tcode gives an opportunity to see the status traffic light. We can re-execute for the red ones to know any further errors.

After executing the migration, we can also see log in tcode: SLG1 to see the details of the error.

Most of the errors during House bank migration are self explanatory.

SAP Notes, given under references section gives a good idea about House Banks related topics.

Please note, we need to document the process steps followed for resolution of the House bank migration issues and thorough testing is done subsequent to migration. This helps to have a clarity  during the next/subsequent cycle runs before the Production run of migration.


How to Access House bank Accounts, after Migration.

House Bank Accounts can be accessed either by Fiori Apps or through NWBC.

We can find the fiori apps in the fiori apps library https://fioriappslibrary.hana.ondemand.com/sap/fix/externalViewer/#/home

During the initial phase of Conversion/Migration cycles – fiori set up may not be ready, possibly!

This is required only to see the house bank after migration or to set up new house bank accounts for testing.

Technical Team can help us on this set up.

  1. Set up NWBC
  2. Activate the following Webdynpro using Tcode: SICF
    1. WDA_FCLM_BAM_HIERARCHY

    2. WDA_FCLM_BAM_ACC_MASTER

    3. WDA_FCLM_UPLOAD_DOWNLOAD

  3. Assign PFCG role for example: SAP_FI_BL_BANK_MASTER_DATA to  required users.
  4. From SAP GUI, use tcode: NWBC

 

 

 


Please refer the below notes and references mentioned within the notes, this helps to understand any issues during migration/conversion to SAP S/4HANA.

References/SAP Notes:

  1. 2162297 – Check Configuration Before Migrating House Bank Accounts
  2. 2270400 – S4TWL – Cash Management – General
  3. 2175053 – Trouble-Shooting Note for House Bank Account Migration
  4. 2873947 – House Bank Account Migration: Prepare account type ’01’ for house bank account migration activity CM1
  5. 2874558 – House Bank Account Migration: Avoid Internal Database Error of CM1
  6. 2763559 – FCLM_BAM_MIGRATION error BF00211: “Bank & & does not exist”
  7. 2463516 – Error FCLM_BAM_MAINT057 – Cannot find configuration for Bank Account Management
  8. 2824605 – House Bank Account Migration: Number Range Object FC_ACCID Missing
  9. https://help.sap.com/doc/saphelp_sfin300/3.5/en-US/88/b30755e654eb14e10000000a4450e5/frameset.htm
  10. Fiori Apps: https://fioriappslibrary.hana.ondemand.com/sap/fix/externalViewer/#/home

 

5 Comments
You must be Logged on to comment or reply to a post.
  • Dear Venkata

    You have given very enriched information for house bank migration.

    When I migrate it, I have two quesitons which will make me confused.

    First, the account id’s description which is existed in tabel T012T in orginal system partly backuped in the proxy oject V_T012T_BAM and I can’t find the rule of backup and un-backup item.

    second, why the only item in orginal system have serval different REVISION Number after migration, and why is the field DELETED_FLAG for some item?  which reasons resulted it?

    thank you

    Darcy

     

  • Good article.  I am curious about the reduction of Account Type from multiple values in earlier versions to the single 01 value in 1909. In prior versions, we had been doing the manual mapping of our house banks to different account Types for Current, Payroll, ZBA, Lockbox, etc..  We had concluded that the Account Type does not necessarily control any SAP functionality; but, it would be helpful if reporting the different types of accounts in use.

    1. Is there really now a single standard account Type (01) that SAP expects to be used across all house banks in best practice implementation?
    2. Can the Account Type be changed after migration if we still would like to have the categorization for reporting?

    Thanks in advance for any guidance.