Generally big organizations receives bank files daily and it is parked in AL11 folder. In cash management module it is critical to have updated bank balances in SAP.
Through intraday statements bank balance is updated in every 10-15 mins. But intraday statements only carries transactions in delta manner throughout day. So it does not contain opening balance of banks.
So opening balance has to fetch from previous days ending balance. From daily bank recon files.
Let’s see how to achieve that:
Below is sample BAI file format
This is processed file format, generally when file is received from bank it needs some correction.
In above file format you can notice from line 4, there are codes like 010, 015 & 045 and after this code there are some values.
Let’s understand what these codes stands for:
010 – opening balance
015 – closing balance
045 – total balance
So while creating opening balance memo record, 045 is crucial code. Value afterwards 045 code is considered as opening balance for memo records.
045 code balance is stored in FEBIP-TOTAL field and then it is considered for opening bal memo records creation.
In OT83 transaction BTC Internal external allocation for code 045 (see below screenshot)
Notice first entry in above screenshot for external transaction 045 with processing type 20.
Without this opening balance memo records will be created without any balance.
Once this setup is in place you can use same bank statement to upload as cash memo records and it will update opening balance of banks in cash management.
S4HANA 2021 & ECC EHP7 Functional & ABAP Server Access with all authorizations related functional & technical transactions, customization and tables. With 24*7 support to system access and authorization related queries.
System access time: 24*7
Support: 24*7
Installation: Can provide software (Installation not included)
You can trace the database using ST05 transaction to find out what tables / structures underlying program is using. It is extremely great tool to have when you want to analyze any transaction and there is just not enough information available over internet.
ST05 is used to analyze performance of programs majorly.
There are five important types of trace we can perform using ST05 and each is very important in specific context.
Here we have multiple options to filter trace of any program:
SQL Trace: this trace helps to find out all tables and structures used by any program/transaction for performing statements like select, insert, delete and update
Buffer Trace: to check table buffer (helpful to decide performance tuning opportunity area)
Enqueue Trace: enqueue function is used to lock object at the time of updating data and then unlocking it after data update is finished. Many times, you receive errors like ‘xyz table is locked by user’ these errors are issued because of this enqueue function.
RFC Trace: this is useful to find out if program is making any remote calls to another system. (useful when analyzing interfaces)
HTTP Trace: to trace HTTP requests from program/application.
SQL Trace
First we need to activate trace from ST05 transaction
There are two options to activate trace, you can see highlighted in above screenshot
One should always select activate trace with filter option
In the next prompted screen (above) you should enter your username, transaction name and program name if possible for which you want to activate trace. In lower side you also have include and exclude options to narrow down the trace criteria.
Activating trace is a big deal. Because system collects huge data for analysis purpose, so be mindful while activating trace.
Now after entering filter criteria press enter and trace will be activated.
We are trying to trace FB03 transaction
Open FB03 transaction in other screen
Enter document details and press enter. You can keep going on like opening line item of journal entry or exploring various options from menu, system will keep recording trace of each and every activity. For this e.g. to keep it simple, we will just open journal enter and then close FB03 transaction.
Now go back to ST05 screen and deactivate trace
Then click on display trace option and execute report
And here you go, you got list of programs and objects (tables/structures) along with how much time it took.
You can double click on program name and system will take to that program statement.
To simplify this list further and we are also only interested table checked by FB03, hence we will go to aggregate trace option and select access to table (as displayed in below screenshot)
In next screen you will only see the list of tables that are used.
Let’s make it more simpler to understand, as we can see there are multiple tables that we might not be aware of.
Click on component hierarchy and select level 0 (as shown in below screenshot)
You can double click on table name to check table details.
In next screen you will see tables are segregated based on their modules
You can notice first BASIS tables are displayed under Basis Component head. Next Financial account tables are displayed. This will help you to check on right tables.
This was about SQL Trace.
Similarly you can use other trace to find out is there any RFC calls made or HTTP request in application. Many times you will come across multiple scenarios where you would like to know what this Z transaction do at that time instead of checking program line by line. You can simply activate all trace in ST05 and then analyze each trace separately.
In this blogpost we will see how to configure company code in all FICO sub modules. This blog will be a collection of SAP College YouTube videos, where all sub modules configuration steps explained in sequence.
Setup FI-GL module (Create Company code)
Company code configuration step by step guide in 14 steps. Configure usable company code in 15 minutes. Ready to post documents.
Download free document of configuration steps to setup FI GL AP AR AA CO module:
Complete Accounts Payable and Automatic Payment program setup in SAP. Configure AP & APP setup to successfully post AP Invoice and run Automatic payment program (F110).
Accounts Receivable and Dunning setup
What are the mandatory steps to follow for new company code to extend it in SAP AR Module. A brief overview and to the point action items in 10 minute.
Asset Accounting and Controlling Area Setup
Complete setup of Enterprise Asset Management in SAP. Extend your company code to asset accounting in few steps. In this video we have extended our company code to Asset Accounting and Controlling submodule. To test the configuration, we have created asset master data, acquisition of asset and posted depreciation on same asset.
