GL master Data in SAP FICO- Complete Overview
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
Post a Comment