How to maintain bank master in S4/HANA Finance NWBC and its import/export process
NWBC – Create Bank Master, Account ID assignment to the House bank and importing/exporting Bank accounts
Step 1: Create House Bank in SAP S4/HANA Finance
Transaction Code: FI12_HBANK
Proprietary information is shaded in black on purpose.
After you are done with House bank creation, the next step is to create the bank account in NWBC and assign account ID to this bank.
Please ensure that you have following roles in NWBC to perform this activity. Ask your security team to assign these roles to your profile
After logging into NWBC, you should be able to view the following attributes to create a bank account.
Click on ‘New Bank Account’ Tab to create the bank master
After filling in all the mandatory details in the ‘General Data’ tab, click on the ‘connectivity path’ tab.
Enter the information in the tabs marked with
Click ‘Save as active’ tab after all the mandatory fields in the ‘Connectivity Path’ tab are filled in. You are all set. Your house bank has now tied to an Account ID and saved in the database.
The next step is: How to import this information from one client to another client because when you do the configuration in the gold client it is client specific and these changes are not recorded in a transport. In order to achieve this purpose, SAP has provided the import and export of NWBC bank master. See below for details:
Import and Export of Bank master from one Client to another
Please ensure that your computer satisfies the following prerequisites:
- You computer must have MS-Office 2010 or higher version with MS-Excel installed.
- You also need to enable the Developer tab in Microsoft Excel per screenshot below
Please follow the navigation path as: Microsoft Excel – Go to File Options – Customize Ribbon – Enable the Developer checkbox and choose OK.
After you are done with enabling the developer tab follow the following Export Procedure:
- From NWBC application, click on the Import and Export Bank Accounts tab. Follow screenshot below
- For exporting the bank accounts, select Export Bank Accounts into an XML File.
- Save the file by giving the file name as Bank_Accounts.xml.
The downloaded file consists of all the bank account master data that exist in your system in XML format. In this downloaded version you can directly make changes to the XML file.
When you choose Export Bank Accounts to an XML File, you should get this pop up on your screen, save it to any folder of your preference. This option is useful when you have to export all the records together
- If your preference is to edit your file in the spreadsheet format, you got to select the 2nd option “Download XML Spreadsheet Template” per screenshot above.
- Save and open the file by assigning the filename as XML_SpreadSheet_Template.xml.
- Steps 4 & 5 are additional steps and it is at your discretion if you want to utilize these as well. Else you can jump to Step 6 after step 3. Click on the Developer tab, choose Import and then select the file Bank_Accounts.xml.
You can now view and make changes to your bank account in spreadsheet format.
You can save this file per screenshot below:
Import Procedure. The same process works for full directory load or you want a selective load by deleting some of the entries in the template.
- From the NWBC application, choose Tool Import and Export Bank Accounts.
- Pick the file you downloaded in the export procedure above for importing to a new client.
- For this blog I picked the file XML_SpreadSheet_Template.xml.
- In the XML file, enter the information that is important to your business needs either by manually entering data or by copying and pasting data to the corresponding tabs of the excel sheets. You can open the file in excel to Edit. See example below. Data will get auto stored in 3 tabs. You can edit the fields and save as well. The next step is to save this edited file in XML format.
- On the Developer tab, choose Export to export the data as an XML file.
- To import the bank accounts, specify the import path of the XML source data file generated in step 5 and then choose Import to upload the file. You are all set. You can see the import details in the validation results section.
Before exporting the data into MS-Excel, you need to ensure that the following conditions are met:
- All the bank account master data entries you want to import to other clients are inside the blue frame of the excel sheet you have downloaded. See downloaded excel sheet screenshot after the 4th step of the import procedure
- The import process does not import any information which is not embedded within the blue frame.
- No empty rows are allowed in the excel sheet between bank account entries.
- The import process that runs in the background treats empty rows as incorrect entries.
- It is highly recommended that you first select the option “Import with Test Run”. The test run log gives you the flexibility to review the log and apply necessary corrections before you execute the update run eventually.