SAP FI - G/L Reporting & Tables

There are various G/L reports that can be generated in SAP FI. The most common ones are −

  • G/L Chart of Accounts List
  • G/L Account Balances
  • G/L Account List
  • G/L Account Totals and Balances

G / L Account Balances

Use the T-code S_ALR _87012277 or in the SAP easy access menu, go to Accounting → Finance Accounting → General Ledger → Information System → General Ledger Reports → Account Balances → General → G/L Account Balances → G/L Account Balances.


Enter the input parameters like company code to generate G/L Account Balances report → Execute.

G / L Account List

Use the T-code S_ALR_87012328 or go to the path given below −

Accounting → Finance Accounting → General Ledger → Information System → General Ledger Reports → Master Data → G/L Account List → G/L Account List.

Enter Input parameters such as Company Code, Chart of Accounts, etc. to apply filter to G/L Account List → Execute.


List of GL Account


G/L Account Totals and Balances

Use the T-code S_ALR_ 87012301 or go to the path shown in the following screenshot.


Enter the report input parameters such as company code, COA, etc. and click Execute. A report will be generated based on input parameters.

Document Journal

Step 1 : Path 


Step 2 :
Step 3 :



GL Balance Report :
T Code : FS10N
Step : 1
Step : 2

GL Account Balance Detailed Report
Step 1
Step 2

Step 3 : Click on Executive

GL Account Balance Report
Step 1:
Step 2 :
Step 3 :



GL Line Item Report :

T Code : FBL3N

Step 1



Step 2











GL Balance Report( Line Item wise) :
T Code : FS10N
Step : 1
Step : 2
Step : 3 Click on specific balance and line item will show up as per below




How to view the Table Fields in SE11

 Step 1: Execute the transaction code: SE11

Step 2: From ABAP: Dictionary initial screen, enter the table name under the field database table and click on the option ‘Display’ as shown image below

Here we have executed the table: SKA1. Now all the fields of the SKA1 table are displayed on the screen.

Click on Content

Go to More>Setting>User Parameter>Data Browser(Keyword) change to "Field Label"


Enter the required field



Click on execute


How to view Table content in SE16/SE16n

Step 1: Execute the transaction code: SE16N
Step 2: Enter the Table Name and required Fld Name

Step 3: Now you can give the required details under the selection criteria and click on execute.




Now it displays the BSEG table content as per the selection criteria data.








 

Comments

Post a Comment

Popular posts from this blog

What is General Ledger Master Data creation and deletion ?

Image
SAP FICO Global Parameters refer to a set of mandatory variants and control parameters that must be maintained for every company code to enable smooth financial accounting and integration with Controlling. These parameters define the basic accounting framework of a company code, such as: Chart of Accounts Fiscal Year Variant Posting Period Variant Field Status Variant All these are maintained based on the Variant Principle. Master Data O Master Data is the information which remains in the system for a long period of time and does not change so often such as G/L Master Data, Customer Master Data, Vendor Master Data, Bank Master Data, Item Master, User Master Data etc. O It represents the business objects that contains agreed upon information which is shared across an organization O It is non-transactional in nature but is used in transactional documents as an information about a G/L account, Customer/Vendor or an item etc. O G/L Master data (Centrally) - Both chart of accounts level/seg...
Read more

What is a Chart of Account and how to assign to company code in SAP FICO ?

Image
Chart of accounts  A Chart of Account is assigned to a company code in SAP Configuration by specifying the chart of accounts key in the company code settings. Each company code can be assigned to only one operational chart of accounts, but one chart of accounts can be assigned to multiple company codes. O Highest level of hierarchy for all the G/L accounts O It is created by following the 3-method variant principle O Create Chart of Accounts: T-code: OB13 O Define the properties to the chart of accounts O Assign company code to the chart of accounts: T-code: OB62 Menu path: Display IMG -> Financial Accounting -> General Ledger Accounting -> Master Data -> G/L Accounts -> Preparations -> Edit Chart of Accounts List O Table: SKAI can be viewed through T-code: SE16N to display the relevant information III. Defining Chart of Accounts in SAP S/4HANA – A Step-by-Step Configuration Guide In every SAP S/4HANA implementation, the Chart of Accounts (COA) is one of the most ...
Read more

Reconciliation Accounts and G/L Master Data Creation in SAP S/4HANA – A Complete Beginner’s Guide

Image
If you are learning SAP S/4HANA Finance , understanding Reconciliation Accounts and G/L Master Data is critical. These concepts form the backbone of FI postings, sub-ledger integration, and real-time financial reporting . This blog explains everything clearly, practically, and in simple terms . 1. General Ledger in SAP S/4HANA The General Ledger (GL) is the central repository of financial data in SAP. A G/L account consists of two segments: Chart of Accounts (CoA) segment – global level Company Code segment – company-specific level Business transactions are: Recorded using the double-entry accounting principle (Debit = Credit) Classified into Assets, Liabilities, Income, and Expenses Used to generate Balance Sheet and Profit & Loss statements All transactions with business partners are first posted to sub-ledgers , and their totals are automatically updated in the General Ledger . 1. What Is a Reconciliation Account? A Reconciliation Account is a s...
Read more