GL Master Data in SAP FICO- Complete Overview

 

GL master Data in SAP FICO- Complete Overview

Table of Contents:

1.What is G/L master data in SAP S/4 HANA?

2.Types of G/L Master Data?

3.Structure of G/L Mater Data?

4.Important T-Codes For G/L Master Data:

5.Types of G/L accounts in SAP S/4 Hana?

6.Important Fields in G/L Master Data?

7. Account Group Vs Field status Group?

8. Reconciliation Account?

9. Retained Earnings Account?

10. Open Item management Vs balance Management?

11.G/L Account creation in SAP S/4 HANA Step by Step?

12. three methods of Creating G/L accounts?

13. Important configuration prerequisites?

14. What Happens when you post a transaction to G/L account?

15. important tables Related to G/L master data?

16. SAP S/4 HANA Vs ECC – G/L Master Data differences

17.Common Mistakes while creating G/L master Data:

18 important restrictions while changing G/L Master data:

19. G/L master data in SAP Fiori:

20    AP FICO Interview questions of G/L Master Data

 

1.What is G/L account Master Data?

G/L master Data is collection of information maintained for every G/L account in SAP. It defines how an account behaves; how financial transactions are posted to it and how it balances are reported in Financial Statements.

For Examples, ABC C=Technologies put let has got Money that are distributed on different départements like rent, salaries. How these are posted is recorded in G/L Master data.

2.Types of G/L Master Data:

In SAP S/4 HANA, G/L master data is maintained at Two levels.

a. Chart Of accounts Segment

b. company Code Segment

a. COA Segment Contains information that s common across all Company Codes using the Same COA.

It Is Maintained at the client -independent COA level.

Suppose ABC Technologies has 2 Company Codes Hyderabad-1000, banglore-2000. Both Company Codes Use ZCOA.

b. Company Code Segment

The Company Code Segment Contains the information specific to an individual Company Code. It Controls how G/L Account behaves during accounting transactions in that Company Code.

The Same G/L Accounts Can have different Company code Specific settings depending on business requirements.

3. Structure of G/L master Data.

G/L Account 100000 divides 2 Company Codes where each company code has Same COA.

4. Important T-codes FOR G/L master data

T-Code

Purpose

FS00

Centrally create, change and display G/L accounts

FSP0

Create/change/display Chart of Accounts segment

FSS0

Create/change/display Company Code segment

OB13

Define Chart of Accounts

OB62

Assign Chart of Accounts to Company Code

OBD4

Define Account Groups

FS03

Display G/L Account

F.10

Balance Sheet and P&L reporting (classic transaction)

 

Note: In SAP S/4 HANA, FS00 remains an important transaction for G/L master maintenance. You can Also use Fiori app for managing G/L Accounts, depending on your system version and assigned roles.

5. Types of G/L accounts in SAP S/4 HANA.

SAP Classifies G/L Account into 4 important account types

Account type

Meaning

Business example

Balance Sheet Account

Records assets, liabilities and equity

Cash, Bank, Machinery

Nonoperating Expense or Income

Records income and expenses outside normal business operations

Interest income, investment loss

Primary Costs or Revenue

Records costs and revenues originating from business operations

Salary, Rent, Sales Revenue

Secondary Costs

Records internal cost allocations within an organization

Activity allocation, assessment

 

6. important Fields in G/L Master Data:

When You create G/L account using FS00, you will encounter several fields

a. Account Number -Every G/L account has Unique number within its COA

Example: Cash account -100000, Bank Account – 110000

B. Account Name/Description: This Fields describe the purpose of G/L account

Example: Short Text and Long Text

account group: is used to classify similar G/L accounts and Control how they are created.

Example: Assets – 100000-199999(Number range)

Liabilities- 200000-299999

Configuration: T-Code: OBD4

  • Configuration path: SPRO → Financial Accounting → General Ledger Accounting → G/L Accounts → Master Data → Preparations → Define Account Group.

Balance Sheet Account / Profit and Loss Account: this field determines whether the account belongs to Balance sheet or profit and Loss Statement.

Balance Sheet Account

P&L Account

Records assets, liabilities and equity

Records income and expenses

Balance is carried forward

Balance is transferred to retained earnings

Example: Bank Account

Example: Salary Expense

 

Account Currency:

Accounts Currency determines the Currency in Which postings are permitted for the G/L Account.

Example: If the Company maintains INR as local Currency, and USD as a foreign currency.

If the bank Account is maintained in USD, the account currency can be Set to USD.

F. tax Category:

Tax Category Controls whether tax Codes can be used when posting to a G/L Account.

Example: inputs Account and Output GST Account.

For Example, when recording an eligible office expense, the system may require appropriate input Gist tax Code.

G. Field Status Group:

This controls which fields appear as mandatory, optional, Suppressed or display only during document posting.

Example: When posting an I=office rent expense, the business may require the Cost Center field. If the cost center is mandatory the user cannot complete the posting without entering it.

Common field Status group:

G001-general field status group.

T-Code: OBC4 – Define field status variants and groups

T-Code: OB14-Maintain field status variant in the relevant configuration context.

H. Sort key

Sort key determines how line items are sorted and how certain assignment fields are populated during posting.

Example:

Posting Date-001, Document number -002

If an accountant wants bank account line items to be sorted by posting date, suitable sort key can help organize the line items.

I. Open Item management:

Open Item management helps track transactions that are not cleared.

Example: ABC technologies receive an invoice for rupees 50,000 but has not made any payment. The invoice remains open item until the corresponding payments recorded and items are closed.

Note: open item Management should be enabled only when the account’s business process requires individual open and cleared item tracking.

line Item Display: Line-item displays allow accountants to view individual posting made to a G/L account.

Difference between Line-item display and open item management.

Line-Item Display

Open Item Management

Displays individual transactions

Tracks uncleared transactions

Helps analyze account movements

Helps identify pending items

Does not itself perform clearing

Supports clearing functionality

 
7. Difference between Account group and Field status group.

Account Group

Field Status Group

Controls G/L master creation

Controls document posting fields

Defines account number intervals

Does not define account number intervals

Controls master record screen layout

Controls accounting document entry layout

Configured using OBD4

Field status groups configured using OBC4

Assigned in Chart of Accounts segment

Assigned in Company Code segment

 

8. Reconciliation account:

A reconciliation account is age/L account that automatically receives summarized posting from subsidiary ledgers.

In SAP Customers and vendors are maintained as business partners and their transactions are reflected in the Corresponding reconciliation G/L accounts.

9. retained Earnings account:

A retained earnings Account is used to transfer the balance of profit and loss accounts at fiscal yearend.

Configuration:

  • T-Code: OB53
  • Configuration path: SPRO → Financial Accounting → General Ledger Accounting → G/L Accounts → Master Data → Preparations → Define Retained Earnings Account.

 

10. open item management Vs balance management.

These concepts should not be confused.

Open Item Management

Balance Management

Tracks individual uncleared items

Tracks the account balance

Identifies pending transactions

Shows total debit and credit movements/balance

Used for clearing accounts

Relevant for general account balance reporting

Example: GR/IR clearing

Example: Fixed asset account

 

11. G/L account creation in SAP S/4 HANA – Step by Step.

Step1: Open T-Code FS00

Step2: Enter G/L account details

Step3:  maintain type / Description

Step4: maintain Control Data

Step5: Mainatain Create/Bank/interest information

Step6: Maintain Company Code information

Step7:  Save

12. three methods of creating G/L Accounts

SAP Provides three common approaches to maintaining G/L accounts

Method

Transaction

Explanation

Central Creation

FS00

Creates Chart of Accounts and Company Code segments together

Chart of Accounts Creation

FSP0

Creates the Chart of Accounts segment

Company Code Extension

FSS0

Extends an existing account to a company code

 

13.Important configuration prerequisites

Before creating G/L Accounts, the following configuration activities should be completed.

Sequence

Configuration activity

T-Code

1

Define Company Code

OX02

2

Define Chart of Accounts

OB13

3

Assign Chart of Accounts to Company Code

OB62

4

Define Account Groups

OBD4

5

Define Retained Earnings Account

OB53

6

Define Field Status Variants and Groups

OBC4

7

Assign Field Status Variant to Company Code

OBC5

8

Create G/L Accounts

FS00

 

14.important tables related to G/L master data:

SAP consultants should understand the important technical tables associated with G/L accounts.

Table

Purpose

SKA1

G/L Account Master – Chart of Accounts data

SKB1

G/L Account Master – Company Code data

SKAT

G/L Account Descriptions

ACDOCA

Universal Journal – Financial line items

T004

Chart of Accounts configuration

T077S

Account Group configuration

T001

Company Code information

 

15. SAP S/4 HANA Vs ECC – G/L master data differences

Particulars

SAP ECC

SAP S/4HANA

G/L Master Maintenance

FS00

FS00 and Fiori apps

Cost Element Maintenance

Separate cost element master

Integrated into G/L account

Primary Cost Elements

KA01

G/L account creation

Secondary Cost Elements

KA06

G/L account creation

Financial Data Structure

Traditional FI tables

Universal Journal – ACDOCA

Customer/Vendor Master

Separate customer/vendor master records

Business Partner approach

G/L Account Segments

CoA and Company Code

CoA, Company Code and relevant Controlling Area data

 

Most important interview point:

In SAP ECC cost elements were maintained separately from G/L accounts. In SAP S/4 HANA cost Elements are integrated into G/L Account master Data. This simplifies FI-CO integration.

16.Common Mistakes while creating G/L master Data:

Mistake

Business impact

Solution

Incorrect Account Group

Wrong number range or field layout

Verify account group in OBD4

Wrong Account Type

Incorrect accounting classification

Select the correct account type

Incorrect Currency

Posting restrictions or currency issues

Validate currency before postings

Wrong Field Status Group

Required fields may be missing or incorrectly displayed

Verify field status settings

Incorrect Tax Category

Tax posting errors

Validate tax requirements

Incorrect Open Item Management

Clearing problems

Understand the account's business purpose

Account not extended to company code

Posting error

Extend using FSS0 or FS00

Incorrect Retained Earnings configuration

Year-end closing issues

Verify OB53 configuration

 

17.G/L master Data in SAP FIORI

Image:

18. SAP FICO important interview questions on G/L master data:

1. What is G/L Master Data in SAP?

G/L Master Data contains the information required to control accounting postings and financial reporting for individual general ledger accounts

2.What are the two main segments of G/L master data?

A. Chart of accounts

Company Code Segment.

There is also controlling area segment for relevant cost and revenue accounts.

3.What is FS00?

FS00 is used to centrally create change, and display G/L Accounts.

4.What is an Account Group?

It groups Similar G/L Accounts and control account number ranges and master record screen layout.

5. What is field status group?

It controls the fields that appear during accounting document entry and determines whether they are mandatory, optional, suppressed or display only.

6. What is the difference between Balance sheet account and Panda L Account?

Balance sheet accounts carry forward their balances to next fiscal year. Where as Panda L balances are transferred to retained earnings.

7. Can a G/L accounts exists without Company Code?

Yes. It can exist at the chart of Accounts level, but it cannot be used for postings in a Company code until the relevant Company code segment is created.

8. What is reconciliation account

It connects subsidiary ledger transactions, such as customer and vendor transactions with the general ledger.

9. What is the difference between Open Item Management and Line-Item Display?

Open Item Management tracks uncleared transactions, whereas Line-Item Display provides visibility into individual account postings.

10. Can you change the account currency after posting Transactions?

Generally, No,

11.What is the purpose of OB53?

It is used to define the retained earnings account for profit and loss balance carry forward?

12.What is the difference between FS00, FSP0 and FSS0?

  • FS00: Central maintenance.
  • FSP0: Chart of Accounts segment.
  • FSS0: Company Code segment.

13.What is the difference between ECC and SAP S/4 HANA Cost element maintenance?

ECC uses separate cost element master maintenance. S/4 HANA integrates cost elements into the G/L account Master.

14. Which tables store the G/L accounts Master Data.

  • SKA1: Chart of Accounts data.
  • SKB1: Company Code data.
  • SKAT: Account descriptions.

15.why is retained earnings Account required?

It receives the Panda L Account balances during fiscal yearend balance carry forward.

 

Comments