Unfortunately, we cannot find this information in the “BSEG” table: As mentioned at the beginning of this article, we have to take the marking “XGKON” (incoming / outgoing money account) into account, which means that we have to join up with the table “SKB1”. To link tables together in SQL (join), we need so-called table joins on all the tables from which we want to retrieve information. SELECT BSEG.MANDT, BSEG.BUKRS, BSEG.GJAHR, BSEG.BELNR, BSEG.BUZEI, BSEG.HKONT ACCOUNT, SKAT1.TXT50 ACCOUNTTXT, BSEG.SHKZG, BSEG.DMBTR FROM BSEG If we put the individual modules of the query together and look at the respective table from which the information can be obtained, we arrive at the following selection (SELECT):
To assign the accounts and the corresponding values of the cash outflows, we also require the amount in local currency (DMBTR) and the corresponding account (HKONT), including the account name (TXT50) of the Accounting account.
This includes a few simple details that are needed for a basic overview: Now it starts to get more complicated, but don’t panic, I’ll explain everything step-by-step before we put the query together:įirst of all, we have to think about which fields are necessary for an evaluation. These are the corresponding reductions in assets on the bank account.
SAP DEBIT CREDIT INDICATOR CODE
A simple selection (SELECT) applied to an SAP table (SKB1) subject to the conditions of a given client (800), a company code (1000) and the indicator for incoming / outgoing payment accounts (X for applicable).Įxample of result: Finding all cash outflowsĪll outflows of funds can be found by looking at all the transaction lines in the Accounting bank accounts that are in credit. SELECT * FROM SKB1 WHERE MANDT='800' AND BUKRS='1000' AND XGKON='X' If we assume that you are examining SAP client 800 and company code 1000, the query for finding the financial accounting bank accounts is as follows: If you want to try the following queries yourself, use the transaction “DBACOCKPIT – Diagnostics – SQL Editor” in your SAP System. This information can be found for each company code and financial accounting account in the account master data in table “SKB1” in the field “XGKON”.
Where do I find the bank accounts in Accounting?įirst of all, you have to find out which of the Accounting accounts represent your own bank accounts. Welcome to the Audit Data Scientist’s guide to SQL DIY hacking guide. You’ll need to be determined though, because this time things will be get very SQL-heavy, something for real freaks of data analysis among you auditors out there. To try it out for yourself, there some suitable queries you can execute in SQL. This means we will concentrate on cash outflows and look at the corresponding offsetting accounts.
SAP DEBIT CREDIT INDICATOR HOW TO
In today’s blog post, though, I would like to show you how to use the data structures in SAP to find out where your money has gone. This is where the cash flows in or out – depending on the circumstances. In accounting, it is normal to always pay special attention to what is going on with your own bank accounts.
0 kommentar(er)
