SAP FICO Introduction and Basics
SAP FICO Introduction and Basics
SAP FICO Introduction and Basics
Big
Service Knowledge Natural
Orchestration Language
Chat Bots
Processing
Neural
Networks
Closed
</> Circuit TV
Blockchain Internet
of Things
Algorithms
Robotic Machine
Process Automation Learning
Cognitive
Process Computing
Automation Big Data
.
Digitization manifests through its five “senses” i.e. talk (chatbots etc), watch (IoT sensors, act (RPA etc.), think
(machine learning) and remember (big data) 2
SAP Solution Portfolio addresses digitization
Digital transformation for finance
Digitization of
Pinnacle
Application Server
• Application Server – This is where the code for all SAP
modules exist and interacts
Application Server
• S/4 HANA significantly reduces the number of tables used in
all modules. This streamlines many downstream processes
Database Server
For
For example
example in
in Finance,
Finance, 25
25 separate
separate tables
tables containing
containing financial
financial
information has been reduced to
information has been reduced to 4 4
SAP Fiori
• Enterprise Resource Planning and SAP
Presentation Server
In 2013, SAP launched ‘Fiori’ which represented a complete
redesign of the SAP GUI layer.
Application Server
Database Server
Unlike
Unlike previous
previous Presentation
Presentation Layers,
Layers, Fiori
Fiori apps
apps are
are fully
fully integrated
integrated
with
with cloud
cloud solutions
solutions and
and mobile
mobile
SAP Cloud Based Solutions
• Enterprise Resource Planning and SAP
Since 2010, SAP has been expanding its cloud
presence and offerings through R&D and
acquisitions. A few examples include:
• In an ‘On Premise’ deployment, the In ‘Private Cloud’ deployment, companies Part of financial statements and creates a
company installs and maintains its own their own hardware, but SAP proper posting in General Ledger
own hardware and software maintains the software (?)
This can be implemented in the shortest
Companies are not allowed to change core project timeline
• This involves the longest project SAP code, customization is extremely
timeline limited
Companies are not allowed to change core
SAP code, customization is extremely
• Companies have the most flexibility limited
to customize SAP code in this
deployment
Enterprise Resource Planning and SAP
FI
Asset
Accounting Manages fixed assets and depreciation
FI CO
Historical Forecasting
Financial Accounting (FI)
• SAP Finance and Controlling
• The FI module is designed for automated management and external reporting of
general ledger, accounts receivable, accounts payable, asset accounting, and other sub-
ledger accounts within the chart of accounts
Accounts
• Contains
Payable
• Contains Asset
Accounting
• Asset Classes
• Depreciation profiles Accounts
Payable
• Capitalized assets
• Tracked assets Accounts
Receivable
Financials (FI): Accounts Payable (AP)
• SAP Finance and Controlling
• Process invoices Financials
(FI)
Accounts
• Contains
Payable
• Vendors Accounts
Receivable
• Checks
Financials (FI): Accounts Receivable (AR)
• SAP Finance and Controlling
• Processes cash receipt transactions for either accounts Financials
(FI)
receivable or revenue transactions
General
Asset
Accounting
• Contains
• Customers Accounts
Payable
• Billing logic
• Dunning Accounts
Receivable
TRADITIONAL BOOKS OF ACCOUNTS
Payroll Journal
General Ledger
Account balances
&
Transactions
Accounts Accounts
Payable Receivable
G.L.Trial Balance
TRADITIONAL BOOKS OF ACCOUNTS - Continued …..
FOR THE PURPOSE OF BALANCE SHEET & TRADING ; PROFIT AND LOSS
ACCOUNTS
Customer Account
Sub ledger balances and details
BUSINESS PROCESSES IN ERP - Sales & Distribution
Customer • Sales Order Processing as integrated process
• Material Accounts updation on delivery
• GL Accounting entry for cost of goods sold
on delivery
• GL and Accounts Receivable updation as
Sales Order
automatic process.
• Controlling module posting for Profit center
Automatic Postings
Material Accounting
Financial Accounting
Controlling
Billing Sales Accounting
Enterprise Resource Planning Introduction
Operating
Operating Concern
Concern Company
Company Company represents
group entity
The Controlling Area is
A company code the business unit where
represents an Chart
Chart of
of accounts
accounts Cost & Revenue
independent legal Accounting & Analysis is
accounting entity for carried out in
external or statutory Functional
Functional management
reporting
Area
Area perspective.
Company
Company code
code Controlling
Controlling Company
Company code
code
Area
Area
Business
Business Business
Business
Area
Area Area
Area
Cost
Cost Centre
Centre //
Internal
Internal Order
Order // Represent separate areas of operation within
an organization and can be used across
Profit
Profit Centre
Centre // company codes for example, product lines,
Profitability
Profitability Segment
Segment divisions or branches. Normally used for
external reporting
Organizational units - interrelationships
Business Area 1
Controlling Area Controlling Area
1 2
Company Code
Company Code 2
Business Area 2 1
Company Code
– Business Area can be cross- company 3
codes.
– A controlling area may include single or
multiple company codes.
– Operating concern can have more than
one controlling areas assigned to it to
enable cross controlling area profitability Functional Area Functional Area
analysis across multiple company codes. (Sales) (Production)
– Functional area is also available across
multiple company codes.
Enterprise Resource Planning Introduction
Organization Structure
• A ‘company code’ and a ‘chart of accounts’ are both examples of organizational structure in SAP.
They must be defined in SAP configuration which is part of the design and build phases of a
project. Business users will not have access to change the organizational structure of the entity.
• A ‘general ledger account’ and ‘business partner account’ are both examples of master data in
SAP. There will be thousands of these master data accounts which will change over time. Every
day, normal business functions like setting up a new customer or changing the bank account
information of an existing vendor will require someone to create or edit one of these master
data accounts. Business users will have access to create/change/delete master data on a daily
basis.
SAP Data Hierarchy and Dependency - Illustration
• SAP Master Data
InfoStructures, Business Warehouse
Reporting
D
Journal Entries, A/P or A/R Transactional e
Invoices, Debit/Credit Memos Data p
e
n
Conditional d
Payment Terms, Payment e
methods, House Banks Master Data n
c
y
General Ledger Accounts,
Business Partners, Foundational Master Data
Materials
Enterprise Structures
Company Code, Plant,
(Configuration Data)
Purchasing Organization,
Sales Organization
Master Data - re-usable information which is required to create and maintain an enterprise-wide "system
of record“ which spans multiple business functions (e.g., purchasing, accounting, etc.).
Master Data
• The same Chart of Accounts can be assigned to any company code which uses the same accounting
methodology and language Overall
Entity
• One chart of accounts can be assigned to several company codes (variant principle).
• If company codes intend to use cross-company code controlling, they must use the same chart of accounts.
Creating General Ledger Accounts
• General Ledger and the Chart of Accounts
• Once a Chart of Accounts is created, the next step is to define General Ledger Accounts which
align with how the business wants to track its activity from an accounting perspective
• The master data of every General Ledger Account is broken down into two sections:
• Chart of Accounts Segment Data
• Company Code Data
• The Chart of accounts segment contains more general basic information about the accounts
including:
1. Account number
2. Name of the account (as short and as long text)
3. Control fields
4. Consolidation fields
General Ledger ‘Segment Data’
• General Ledger and the Chart of Accounts
• The ‘Chart of Accounts Segment’ master data information for the
“Buildings” GL Account is shown here
• Because the US and Canada company codes are using the same chart
of accounts, the Account Group and text cannot be different between
them.
These two types of accounts are treated differently in the closing procedure:
• Balance Sheet Accounts - Balance is carried forward to the same account.
• Profit and Loss Statement Accounts - Balance is carried forward to a retained earnings account and the
profit and loss statement account is set to zero
• Profit and Loss Accounts must be assigned to a Retained Earnings. This is a special account which forms the
connection between the Profit & Loss statement and the Balance Sheet. All income a company earns in a
year is moved from the Profit & Loss accounts to the Retained Earnings account at the end of the year.
• If there is only one retained earnings account, the system automatically uses the one defined in Customizing
• If there are more than one retained earnings account on creating a master record; the retained earnings
account for each profit and loss statement account can be selected
Account Groups for G/L Accounts
• General Ledger and the Chart of Accounts
• Since a chart of accounts contains many different types of
accounts, they can be grouped into different Account Groups
• Three account groups have been created for the US Chart of Accounts ‘0010’
• You can assign fields that you do not use the status Hide.
• Fields whose values must not be changed can have the status Display (even in
change mode).
• For fields where you must enter a value, you can define the status Required Entry.
• Fields that can contain an entry, but are not required, can be set to Optional Entry.
Field Status for Master Data
• General Ledger and the Chart of Accounts
• The fields displayed in the general ledger account master record are not only controlled by the account
group, but also by the transaction that you are using to edit the master data (transaction-specific
control)
• For each field, the field status definitions from the account group and the transaction are taken into
consideration and the one with higher priority is used
1. Currency
2. Taxes
3. Reconciliation account
4. Line item display
5. Sort key
6. Field status group
7. House bank
8. Interest calculation information
Reconciliation Accounts
• General Ledger and the Chart of Accounts
• Some General Ledger accounts have a special designation called ‘Reconciliation Accounts’ which is a concept in
SAP where one account can have multiple subaccounts roll up to it
• An example account which would be designated as a reconciliation account is the ‘Accounts Receivable’
General Ledger Account
• Accounts Receivable refers to all of the money that a company’s customers currently owe it. In the example
below, a company has three customers which collectively owe the company $1,000,000
United States Balance Sheet
12/31/2017
Subledger Accounts Assets (General Ledger Accounts)
Customer Account Customer Name Amount Owed Current Assets
2000000001 Customer 1 300,000 Cash 1,000,000
2000000002 Customer 2 300,000 Accounts Receivable 1,000,000
2000000003 Customer 3 400,000 Property, Plants, and Equipment
Fixed Assets 1,000,000
Equipment 1,000,000
Total Assets $ 4,000,000
Reconciliation Accounts Example
• General Ledger and the Chart of Accounts
• In this case the ‘Accounts Receivable’ general ledger account would be set up as a reconciliation account. This
account would be assigned to all customer accounts in the customer master data (which will be covered in more
detail later)
• All postings to the customer accounts (subledger accounts) are automatically posted to the assigned reconciliation
accounts.
• Because of this connection, you can never post an amount directly to a reconciliation account. The account is only
able to display the aggregate balance of all subledger accounts assigned to it.
• You define a G/L-account as a reconciliation account by entering one of the following account types in the field
Reconciliation Account for Account Type:
• Accounts with open item management must have line item display activated.
• You should use open item management for the following accounts:
• Bank clearing accounts
• Clearing accounts for goods receipt/invoice receipt
• Salary clearing accounts.
• You can only activate or deactivate open item management if the account has a
zero balance.
Open Item Manage Example
• General Ledger and the Chart of Accounts
• Certain processes in SAP are enabled by selecting the
‘Open Item Managed’ checkbox in the GL Account master
data.
• If the account currency is the local currency, the account can be posted to in any
currency. The other currencies are translated into the local currency for each line
item.
• Accounts with a foreign currency as the account currency can only be posted to
in this foreign currency.
Group Consolidation
• General Ledger and the Chart of Accounts
• If an entity wants to prepare reports for data which is contained in multiple countries around the world, there needs to be a method to
allow them to complete this consolidation
• In the example below, if the company is headquartered and publicly traded in the US, the Securities and Exchange Commission will require
them to submit financial statements which includes accounting information from all countries that they operate in
• SAP has two approaches to this issue: Group Chart of Accounts and Country-Specific Chart of Accounts
Overall
Entity
Operational
English Chart of German
Chart of
Accounts Chart of Accounts
Accounts
Disadvantage:
• Because the company codes use different operational charts of accounts, you cannot carry
out cross-company code controlling.
Country Chart of Accounts Methodology
• General Ledger and the Chart of Accounts
Overall Entity
Operational
Chart of English Chart of
Accounts Accounts
• Since all company codes use the same operational chart of accounts for postings, you can carry
out cross-company code controlling.
Disadvantage:
• Accounting clerks who may be familiar with the country charts of accounts will first have to get
used to using the operational chart of accounts.