part8 - financial accounting

8/19/2019 Part8 - Financial Accounting

http://slidepdf.com/reader/full/part8-financial-accounting 1/81

Integrated business processes with SAP ERP

Script 8: Financial accounting in SAP ERP

Prof. Dr. Heimo H. Adelsberger

Dipl.-Wirt.-Inf. Pouyan Khatami

Dipl.-Wirt.-Inf. Taymaz Khatami




page 2

Copyright Prof. Dr. Heimo H. Adelsberger/Dipl.-Wirt.-Inf. Pouyan Khatami

/Dipl.-Wirt.-Inf. Taymaz Khatami

Table of contents

Table of contents ........................................................................................................................ 2

Table of figures .......................................................................................................................... 4

Copyright .................................................................................................................................... 6

1

Financial accounting in SAP ERP ...................................................................................... 7

1.1

Unit objectives “financial accounting in SAP ERP“ ................................................... 7

1.2 Scenario ....................................................................................................................... 8

2

Financial accounting with SAP ERP ................................................................................ 10

2.1 Theory – Duties in financial accounting .................................................................... 10

2.1.1

Integration of G/L accounts in financial accounting .......................................... 11

2.1.2 Financial accounting versus management accounting ....................................... 12

2.2

Theory – Organizational levels in financial accounting ............................................ 14

2.2.1

Company codes .................................................................................................. 14

2.2.2 Business areas .................................................................................................... 14

2.2.3

Controlling area .................................................................................................. 15

2.3 Practical application – Organizational levels in financial accounting ....................... 17

2.3.1

Definition: Customizing ..................................................................................... 17

2.3.2 Organizational structures in accounting ............................................................. 20

2.3.3

Questions ............................................................................................................ 20

2.3.3.1 Currency in company code 1000 ................................................................ 21

2.3.3.2

Cross-company code cost accounting ......................................................... 22

2.3.3.3

Fiscal year variant ....................................................................................... 23

2.3.3.4 Operating concern ....................................................................................... 24

2.3.3.5

Cost center accounting ................................................................................ 25

2.4

Theory – General ledger accounting ......................................................................... 26 2.4.1

Chart of accounts ................................................................................................ 26

2.4.1.1 Chart of account assignment ....................................................................... 26

2.4.1.2 G/L account master record .......................................................................... 27

2.4.1.3

Account groups for G/L accounts ............................................................... 28

2.4.1.4 Reconciliation accounts and sub-ledgers .................................................... 28

2.4.2

Advantages of the new general ledger in the SAP ERP system ......................... 29

2.4.2.1 Advantages in detail: Extended data structure ............................................ 30

2.4.2.2

Advantages in detail: Document splitting (online split) ............................. 30

2.4.2.3 Advantages in detail: Real-time integration FI CO ............................... 32

2.4.2.4

Advantages in detail: Parallel accounting ................................................... 33

2.4.3

G/L account posting ........................................................................................... 34

2.4.3.1

Posting key .................................................................................................. 35

2.4.3.2

Account data ............................................................................................... 35

2.5 Practical application – general ledger ........................................................................ 37

2.5.1

Chart of accounts ................................................................................................ 37

2.5.1.1 Display the chart of accounts ...................................................................... 38

2.5.1.2

Assign the chart of accounts ....................................................................... 38

2.5.1.3 Displaying the accounts of the chart of accounts ........................................ 39

2.5.2

G/L accounts ...................................................................................................... 40

2.5.2.1

Create a G/L account................................................................................... 40

2.5.2.2 Create G/L account in a company code ...................................................... 40

2.5.2.3

Enter G/L account document ...................................................................... 41




page 3



2.5.2.4 Check account ............................................................................................. 42

2.6

Theory – Accounts payable ....................................................................................... 44

2.6.1 The vendor master record ................................................................................... 44

2.6.2

Procurement process from an accounting point of view .................................... 44

2.6.3 Integration with materials management ............................................................. 45

2.6.4

AP credit/invoice memo entry ............................................................................ 45 2.6.5 Elements of the payment process ....................................................................... 46

2.6.6

Overview of the payment program ..................................................................... 47

2.7

Practical application – accounts payable .................................................................... 48

2.7.1 Vendor invoice ................................................................................................... 48

2.7.1.1

Enter vendor invoice ................................................................................... 48

2.7.1.2 Display open items of the vendor ............................................................... 49

2.7.2

Automatic payment ............................................................................................ 50

2.7.3 Display cleared items of the vendor ................................................................... 53

2.8 Theory – Accounts receivable ................................................................................... 55

2.8.1

The customer master record ............................................................................... 55

2.8.2

IDES credit control area ..................................................................................... 55

2.8.3

Credit management master record ...................................................................... 56

2.8.4 Sales process and integration ............................................................................. 57

2.8.5

Sales order process from an accounting point of view ....................................... 58

2.8.6 Credit control process ......................................................................................... 58

2.8.7

Incoming payments in Accounts receivable ....................................................... 59

2.9 Practical application – Accounts receivable .............................................................. 60

2.9.1

Credit management ............................................................................................ 60

2.9.1.1

Customer with missing credit data .............................................................. 60

2.9.1.2 Maintain credit management master data ................................................... 60

2.9.2

Enter sales order ................................................................................................. 61

2.9.3

Release blocked sales and distribution document .............................................. 61

2.10

Theory – Fixed asset accounting ............................................................................ 63

2.10.1 Assets in financial accounting organizational units ........................................... 63

2.10.2

Asset class .......................................................................................................... 63

2.10.3 Asset transactions ............................................................................................... 64

2.10.4 Transaction type ................................................................................................. 65

2.10.5

Asset explorer ..................................................................................................... 65

2.10.6 Depreciation areas .............................................................................................. 66

2.10.7

Depreciation run ................................................................................................. 67

2.11 Practical application – asset accounting................................................................. 68

2.11.1

Asset master record ............................................................................................ 68

2.11.2 Post asset acquisition .......................................................................................... 68

2.11.3

Asset Explorer .................................................................................................... 69

2.12

Theory – balance sheet and profit & loss statement .............................................. 71

2.12.1 Create balance sheet and P&L statement ........................................................... 71

2.12.2

Balance sheets – an alternative ........................................................................... 72

2.13 Practical application – balance sheet and profit & loss statement ......................... 73

2.13.1

Balance sheet and P&L statement structure ....................................................... 73

2.13.2 Create balance sheet and P&L statement report ................................................. 75

3

Completion ....................................................................................................................... 77

4 Reflections ........................................................................................................................ 78

4.1

Questions ................................................................................................................... 78 4.2

Standard solution ....................................................................................................... 80




page 4



Table of figuresFigure 1: Process overview: Financial accounting ..................................................................... 9

Figure 2: Duties in financial accounting .................................................................................. 11

Figure 3: Integration of G/L accounts in financial accounting ................................................ 12

Figure 4: Financial accounting versus managerial accounting ................................................ 13

Figure 5: Company codes ......................................................................................................... 14

Figure 6: Business areas ........................................................................................................... 15

Figure 7: Organizational levels ................................................................................................ 15

Figure 8: Controlling area ........................................................................................................ 16

Figure 9: Process overview: Customizing of the company’s structure in FI and CO .............. 17

Figure 10: IMG - Step 1: SAP system screenshot .................................................................... 18

Figure 11: IMG - Step 2: SAP system screenshot .................................................................... 18

Figure 12: Implementation guide - customizing menu: SAP system screenshot ..................... 19

Figure 13: Relationship of customizing and easy access menu; Rimmelspacher (2004) ........ 19

Figure 14: Organizational structures in accounting; Rimmelspacher (2004)........................... 20

Figure 15: No authorization: SAP system screenshot .............................................................. 20

Figure 16: Company code - Step 1: SAP system screenshot ................................................... 21

Figure 17: Company code - Step 2: SAP system screenshot ................................................... 21

Figure 18: Controlling area - Step 1: SAP system screenshot ................................................. 22



Figure 21: Controlling area – Step 1: SAP system screenshot ................................................. 23

Figure 22: Controlling area – Step 2: SAP system screenshot ................................................. 24

Figure 23: Operating concern - Step 1: SAP system screenshot .............................................. 24

Figure 24: Cost center accounting - Step 1: SAP system screenshot ....................................... 25

Figure 25: Cost center accounting - Step 2: SAP system screenshot ....................................... 25 Figure 26: Chart of accounts .................................................................................................... 26

Figure 27: Chart of account assignment ................................................................................... 27

Figure 28: G/L account master record ...................................................................................... 27

Figure 29: Account groups for G/L accounts ........................................................................... 28

Figure 30: Reconciliation accounts and sub-ledger ................................................................. 29

Figure 31: Advantages of the new general ledger .................................................................... 29

Figure 32: Extended data structure ........................................................................................... 30

Figure 33: Document splitting (1) (online split) ...................................................................... 31

Figure 34: Document splitting (2) (online split) ...................................................................... 32

Figure 35: Real-time integration FI - CO ................................................................................. 33

Figure 36: Parallel accounting .................................................................................................. 34

Figure 37: G/L account posting ................................................................................................ 34

Figure 38: Posting key .............................................................................................................. 35

Figure 39: Account data ........................................................................................................... 36

Figure 40: Process overview: General ledger accounting ........................................................ 37

Figure 41: INT chart of accounts: SAP system screenshot ...................................................... 38

Figure 42: Chart of accounts INT: SAP system screenshot ..................................................... 39

Figure 43: Enter G/L account document: SAP system screenshot ........................................... 42

Figure 44: Display balance in general ledger: SAP system screenshot ................................... 43

Figure 45: The vendor master record ....................................................................................... 44

Figure 46: Procurement process from an accounting point of view......................................... 45

Figure 47: Integration with materials management .................................................................. 45

Figure 48: Vendor invoice and credit memo ............................................................................ 46

Figure 49: Elements of the payment process ........................................................................... 47




page 5



Figure 50: Overview of the payment program ......................................................................... 47

Figure 51: Process overview: Accounts payable ...................................................................... 48

Figure 52: Enter vendor invoice: SAP system screenshot ....................................................... 49

Figure 53: Open items of the vendor: SAP system screenshot ................................................ 50

Figure 54: Automatic payment run (1): SAP system screenshot ............................................. 51

Figure 55: Automatic payment run (2): SAP system screenshot ............................................. 52 Figure 56: Automatic payment run (3): SAP system screenshot ............................................. 53

Figure 57: Cleared items of the vendor: SAP system screenshot ............................................ 54

Figure 58: The customer master record .................................................................................... 55

Figure 59: IDES credit control area ......................................................................................... 56

Figure 60: Credit management master record .......................................................................... 57

Figure 61: Sales process and integration .................................................................................. 57

Figure 62: Sales order process from an accounting point of view ........................................... 58

Figure 63: credit control process .............................................................................................. 59

Figure 64: Incoming payments in Accounts receivable ........................................................... 59

Figure 65: Process overview: Accounts receivable .................................................................. 60

Figure 66: Release blocked SD document: SAP system screenshot ........................................ 62

Figure 67: Assets in FI organizational units ............................................................................. 63

Figure 68: Asset class ............................................................................................................... 64

Figure 69: Asset transactions ................................................................................................... 64

Figure 70: Transaction type ...................................................................................................... 65

Figure 71: Asset explorer ......................................................................................................... 66

Figure 72: Depreciation areas................................................................................................... 66

Figure 73: Depreciation run ..................................................................................................... 67

Figure 74: Process overview: Asset accounting ....................................................................... 68

Figure 75: Post asset acquisition: SAP system screenshot ....................................................... 69

Figure 76: Asset Explorer: SAP-System-Screenshot ............................................................... 70

Figure 77: Create balance sheet and P&L statement ................................................................ 71

Figure 78: Balance sheets – an alternative ............................................................................... 72

Figure 79: Process overview: Balance sheet and profit & loss statement ................................ 73

Figure 80: Financial statement version: SAP system screenshot ............................................. 74

Figure 81: Change financial statement version: SAP system screenshot ................................. 75

Figure 82: Balance sheet and P&L statement report: SAP system screenshot ........................ 76




page 6



Copyright

- This document is mostly based on publications for the TERP10 course “mySAP ERP –

integrated business processes“– those parts are subject to the copyright of SAP AG.

- All figures used within this course are created in the style of TERP10, if not labeled

else wise. Those parts are subject to the copyright of SAP AG.- All screenshots used within this document, even if displayed in extracts, are subject to

the copyright of SAP AG.

- Distri bution and reproduction of th is document or parts of th is document i n any

form is prohibited without the written permission of Prof. Dr. Heimo H.

Adelsberger , Dipl.-Wi r t.-Inf . Pouyan Khatami, and Dipl.-Wir t.-Inf . Taymaz

Khatami .




page 7



1 Financial accounting in SAP ERP

1.1 Unit objectives “financial accounting in SAP ERP“ This unit aims at giving you an understanding of financial accounting in the SAP ERP system.

At the conclusion of this unit, you will be able to

- explain the organizational structures and master data used in financial accounting,

- explain the functionality of the new general ledger,

- execute typical accounting operations in the application components of financial

accounting,

- name the links to sales and distribution, materials management, internal accounting,

and controlling,

-

understand assets accounting, and- create financial reports

Note:

It is vital for the successful completion of this case study that you are familiar with the

navigation basics in SAP ERP systems (cf. unit Introduction/Navigation ). This includes that

you are able to handle the SAP Easy Access Menu as well as an understanding of the SAP

transaction concept. Your knowledge about help options and further documentation is to

enable you to mostly discover the complexity and potential of the system independently –

albeit you have to study with given scenarios.

Note: Please avoid to merely clicking through the described steps of the case studies without

thinking carefully about what you are doing to make sure you achieve sustained learn ing

success . Try to clarify at each step what is done and why it is done. Therefore, you should

regularly use the F1 and F4 help functions as well as the SAP online library’s help menu

(cf. introduction chapter, Help) to display further information and explanations regarding the

particular processes. Since we arranged the case studies neatly, not all entries that you need

to enter on the different screens can be explained in detail. Thus, you should try to get a

profound knowledge using the F1 and F4 keys regarding the meaning of the particular fields

and entries.

Please unconditionally use the SAP Easy Access Menu instead to the transaction codes. Thus,

you will quickly understand the structure and logic of SAP ERP. When you are a bit more

experienced using the SAP system, it is advisable to use the transaction codes. Please read the

case studies and advises carefully , since careless mistakes causing huge problems happen

quite often.




page 8



1.2 Scenario

In the practical application section of this unit, you will focus on the enterprise structures of

financial accounting and controlling in customizing. Consequently, you will get a short

overview of the chart of accounts. Tasks related to the chart of accounts are predominantlycarried out in customizing (IMG: implementation guide) of the SAP ERP system even if it

belongs to the general ledger topic-wise. Moreover, you will create an impersonal account in

the general ledger and carry out postings to this account.

In the accounts payable section, you will enter an invoice from your vendor and trigger the

automatic payment of the open item. In account receivable, you will focus on credit

management. At this point, you will also access the SD module. In asset accounting, you will

enter a new asset and take a look at its posting and depreciation in the asset explorer. Finally,

you will deal with the balance sheet and profit and loss statement of your company.

In the following figure, you can see the entire process that you will deal with independently in

the practical application section of this unit using the SAP ERP system. Except for the

enterprise structures in customizing and entering a sales order, you will focus exclusively on

the functional area financial accounting.




page 9



Figure 1: Process overview: Financial accounting




page 10



2 Financial accounting with SAP ERP

2.1 Theory – Duties in financial accountingFinancial accounting predominantly focuses on maintaining and processing the general

ledger, processing receivables, and asset accounting. Important tasks of financial accounting

are the recording of monetary- and value flows as well as valuation of inventories.

In the general ledger (GL), all business transactions relevant to accounting are recorded on

G/L accounts from a business perspective. The general ledger is structured according to a

chart of accounts. A chart of accounts contains structured definitions of all G/L accounts in

the general ledger. These definitions include the account number, the G/L account

designation, and the categorization of the G/L account as income statement or balance sheet

account . Due to clarity reasons, the general ledger usually contains collective positions. In

these cases, posting data are represented in more detail in so-called subledgers , from wheredata are transferred in compressed form to the general ledger. Using reconcil iation accounts ,

subledgers are linked to the general ledger in real-time, i.e., when a posting is made to a

subledger, the same posting is carried out on the respective reconciliation account in the

general ledger.

There are four subledgers in the SAP ERP system:

- The accounts payable accounting (AP) contains all business events concerning

relationships to suppliers. Thereby, the main source of data is purchasing (MM,

materials management).

- The accounts receivable accounting (AR) records all business events concerning

customer relationship. Main source of data is sales and distr ibu tion (SD).- The asset accounting (AA) records all business events concerning asset management.

- The bank ledger (BL) supports posting cash flows.




page 11



Figure 2: Duties in financial accounting

2.1.1 Integration of G/L accounts in financial accounting

The general ledger is managed on company code-level . From accounts movements in the

general ledger, the balance sheet and the P/L statement are created, as required by law.

Assets of a company are separated into assets (application of funds) and liabilities (source of

funds). Business events that are recorded in the subledgers (AP, ARP, etc.), in materials

management (material stock), or in treasury (management of financial resources), are

considered in the balance sheet in real time for integration reasons.

The treasury component (TR) focuses on functions such as payment means, treasury

management (including, for example, financial resources, foreign currency, derivatives, and

shares), loans, and market risk management.

The recording of business events aims at the creations of a balance sheet and P/L statement

in form of a report. These reports need to be adjusted to specific national requirements and

laws.Since a company can be subject to different reporting requirements regarding balance sheet

and P/L statement, different balance sheet and P/L statement structures can be created. With

these structures, you can determine which accounts appear in which balance sheet items; they

are delivered with the SAP standard installation already.

Financial reports required for external reporting purposes (e.g., balance sheet, P/L statement)

are created in FI. These external reporting requirements are provided by general accounting

standards such as US-GAAP or IAS, according to the respective law requirements of financial

authorities.




page 12



Figure 3: Integration of G/L accounts in financial accounting

2.1.2 Financial accounting versus management accounting

This chapter focuses on financial accounting, which aims at legal reporting. Balance sheets

and P/L statements can be created at the level of legal units. In turn, management accounting

serves the purpose of informing the company-internal management regarding cost and

revenue.

The level on which financial accounting is required is predominantly determined by law(e.g., commercial code) since it is an external obligation. Correspondingly, financial

accounting is carried out differently in distinct countries.

Costs and revenue from financial accounting are used in management accounting . In

management accounting, these financial data can be assigned via multiple department

boundaries (financial accounting). Usually, you want to ensure that results of financial

accounting are comparable to the results of management accounting (reconciliation). In

contrast to financial accounting, management accounting focuses predominantly on planning,

controlling, and coordination of valued business processes to increase corporate performance.

Determined information is used for the objective foundation of management decision-making.

Therefore, sources of corporate success are analyzed and aggregated, especially using cost

accounting and investment appraisal, to an encompassing controlling concept.

The following elements are part of financial accounting:

- Accoun ts receivable (AR),

- Accoun ts payable (AP),

- F ixed asset accounting (AA),

- Bank accounting (BL ),and

- General ledger (GL ),

providing an encompassing picture of financial accounting and accounts. Further components

are:

- Cash journal accounting

-

Inventory accounting- Tax accounting

- Accrual accounting




page 13



Due to simplification reasons, cash management, which actually belongs to financial supply

management, was included in financial accounting.

Management accounting features advanced measures of cost monitoring within a company

(cf. next unit).

Figure 4: Financial accounting versus managerial accounting




page 14



2.2 Theory – Organizational levels in financial accounting

2.2.1 Company codes

For each country, at least one individual company code is used. A company code must be

created according to tax law, commercial law, and other accounting-specific criteria.

The company code is the smallest organizational unit in SAP ERP for which you can issue a

balance sheet and a P/L statement . Within the productive environment, at least one company

code must be present so that a company can be productive within the SAP ERP system (i.e.,

the system can be implemented and you can go live). The company code key is a four-digit

alphanumeric field.

Figure 5: Company codes

2.2.2 Business areas

You can create several business areas in the SAP ERP system to which you can assign

postings from a company code defined in a client.

Business areas can be used to facilitate segment reporting. They cover the central operation

areas (product lines, subsidiaries) whenever required by law.

Implementing business areas is optional in case no external business segment reporting isrequired and flexible within business area definition.

The business area key a four-digit alphanumeric field.




page 15



Figure 6: Business areas

Generally, business areas are independent of company codes, i.e., you can post to them from

all company codes. For example, the following figure shows the business areas mechanical

engineering, plant engineering and automotive used commonly by different company codes

(USA, Canada, and Mexico).

Figure 7: Organizational levels

2.2.3 Controlling area

A controlling area is an independent organizational structure for which you can manage and

allocate costs and revenues. It is a separate unit of cost accounting.

You can assign one or several company codes to a controlling area. Thus, you can carry out

cross-cost center postings between company codes. However, this is only possible when theassigned company codes and controlling areas feature the same operating char t of accounts

and the same business year .




page 16



Figure 8: Controlling area




page 17



2.3 Practical application – Organizational levels in financial

accounting

In the following section, you will focus on the organizational levels of financial accounting inthe SAP ERP system. Accounting generally and in SAP ERP as well, is separated into

financial accounting and management accounting (or controlling, respectively). The main

focus of this chapter is on financial accounting. However, you will learn about organizational

levels of controlling (controlling area, operating concern) since management accounting and

financial accounting is closely linked to each other. For this reason, it would not be helpful to

consider them separately.

Figure 9: Process overview: Customizing of the company’s structure in FI and CO

During this chapter, you should answer the following questions. Answering these questions is

supposed to increase your learning progress.

1. Which currency is assigned to company code 1000?

2. Is there cross-company code cost accounting in controlling area 1000?

3. Which company codes are assigned to controlling are 1000? List five of them.

4.

What is a fiscal year variant?

5. Which fiscal year variant is assigned to controlling area 1000?

6. Which operating concern is assigned to controlling area 1000?

7. Can you carry out cost center accounting in controlling area 1000?

To answer these questions, go to customizing in the SAP ERP system.

2.3.1 Definition: Customizing

When a company decided to implement a SAP ERP system, the software needs to be adjustedto the business requirements. Customizing is carried out in SAP ERP using the

implementation guide (IMG). In customizing, relationships, selection options, etc. for the

application menu are determined (“Which functions are executable in the menu?”) .

Customizing can be called up with transaction <SPRO> and then by choosing the SAP

reference IMG (F5); or alternatively, by selecting the SAP easy access menu:




page 18



Figure 10: IMG - Step 1: SAP system screenshot

Figure 11: IMG - Step 2: SAP system screenshot

Browsing in customizing consists initially of a tree structure:




page 19



Figure 12: Implementation guide - customizing menu: SAP system screenshot

Relationship of customizing and easy access:Customizing determines the functionality of the SAP ERP system.

Figure 13: Relationship of customizing and easy access menu; Rimmelspacher (2004)

Settings in customizing determine the functionalities in the SAP easy access menu.

Consequently, you can determine all basic data and structures in customizing. Thus, you

can find the information regarding the organizational structure relevant for answering the

questions above there.




page 20



2.3.2 Organizational structures in accounting

From an accounting perspective, you can gain the following overview of a company:

Figure 14: Organizational structures in accounting; Rimmelspacher (2004)

As you can see from the figure above, the company codes 1, 2 and 3 use the same operational

chart of accounts. The operational chart of accounts is used by FI and CO commonly, i.e.,

primary cost and revenue elements in CO are revenue and expense accounts in FI

simultaneously. Consequently, a controlling area takes over the chart of accounts of the

assigned company codes. In cross-company code cost accounting (e.g., common product

controlling across several company codes), controlling area and all assigned company codes

must use the same chart of accounts.

2.3.3 Questions

Coming back to answering the questions: All tasks in this part of the case study start in

customizing . Since you are already experienced in SAP customizing from the previous case

studies, you are supposed to process the questions independently. You will find an approach

to solve each task at its end that you can use if necessary.

Due to restrictions of your account, you do not need to worry about, for example, unintended

momentous changes to the IDES group, since you are authori zed to read , but you do not have

a writing authorization.

Figure 15: No authorization: SAP system screenshot




page 21



2.3.3.1 Currency in company code 1000

Question 1: Which currency is assigned to company code 1000?

Approach for question 1:

Figure 16: Company code - Step 1: SAP system screenshot

Figure 17: Company code - Step 2: SAP system screenshot




page 22



2.3.3.2 Cross-company code cost accounting

Question 2: Is there cross-company code cost accounting in controlling area 1000?

Question 3: Which company codes are assigned to controlling area 1000? List five of them.

Approach for questions 2 and 3:

Figure 18: Controlling area - Step 1: SAP system screenshot





page 23




2.3.3.3 Fiscal year variant

Question 4: What is a fiscal year variant? Question 5: Which fiscal year variant is assigned to controlling area 1000?

Approach for questions 4 and 5:

Figure 21: Controlling area – Step 1: SAP system screenshot




page 24



Figure 22: Controlling area – Step 2: SAP system screenshot

2.3.3.4 Operating concern

Question 6: Which operating concern is assigned to controlling area 1000?


Figure 23: Operating concern - Step 1: SAP system screenshot




page 25



2.3.3.5 Cost center accounting

Question 7: Can you carry out cost center accounting in controlling area 1000?


Figure 24: Cost center accounting - Step 1: SAP system screenshot

Figure 25: Cost center accounting - Step 2: SAP system screenshot




page 26



2.4 Theory – General ledger accounting

2.4.1 Chart of accounts

A general ledger in SAP ERP is created based on a chart of accounts . A chart of accounts

contains the definition of all G/L accounts in structured form. The definition of a G/L account

includes predominantly the account number, the G/L account name, and the G/L account type

(P&L type account or balance sheet type account).

You can define an unlimited number of charts of accounts in the SAP system. Many country-

specific charts of accounts are included in the standard version of the system.

Figure 26: Chart of accounts

2.4.1.1 Chart of account assignment

Each company code must feature a chart of accounts for the general ledger, since it is an

independent accounting entity. This chart of accounts is assigned to the company code. A

chart of accounts can be used by several company codes (see figure). Consequently, the

general ledgers of these company codes are set up identically.




page 27



Figure 27: Chart of account assignment

2.4.1.2 G/L account master record

A G/L account master record contains two segments.

The first segment is the accoun ts segment . In the accounts segment, control features are

defined on high level. For example, you can determine the account description, i.e., whether it

is a balance sheet account or a P&L account (that controls the company code segment fields),

and the number of the consolidation account.

The second segment is the company code segment , which described how the company code

that used the specific account manages this account. This segment contains control elements

for the following functions:- account control

- account management

- financial details

- joint ventures

- interest calculation

- document control

Figure 28: G/L account master record




page 28



2.4.1.3 Account groups for G/L accounts

Using account groups, G/L account can be structured in user-defined segments. Within these

account groups, the number rages of the accounts are determined that are considered in the

user-defined segments.

The field status of the company code segment is determined in the master record at the time

of creating, changing, or displaying the same. The four field statuses of a field in the G/Lmaster record are suppress, required, display, and optional . You can determine in

customizing, which field status a field has at the time of its creation.

Figure 29: Account groups for G/L accounts

2.4.1.4 Reconciliation accounts and sub-ledgersReconciliation accounts conduce to real-time integration of a sub-ledger with the general

ledger. The reconciliation account itself is not meant for direct postings, i.e., no business

transactions can be posted directly to a reconciliation account. For example, customer

receivables are debited to the customer account of the customer sub-ledger. The balance of the

customer account is transferred to reconciliation account 140000 in the general ledger. Thus,

the reconciliation between sub-ledger and general ledger is always ensured. In the general

ledger, postings are restricted by the usage of account types to reconciliation accounts.

You are already familiar with reconciliation accounts (e.g., 140000) from the customer master

data and the vendor master data. These are used to directly record liabilities and receivables

from the sub-ledgers in the general ledger.




page 29



Figure 30: Reconciliation accounts and sub-ledger

2.4.2 Advantages of the new general ledger in the SAP ERP system

The new general ledger contains functions to unify the conventional general ledger with the

special ledgers components.

Note: Despite the new functionality, the GUI for data entry and postings are almost identical

to the previous release.

Figure 31: Advantages of the new general ledger




page 30



2.4.2.1 Advantages in detail: Extended data structure

The functional area field is now also stored in the general ledger. Thus, you do not need to

activate the sales ledger cost to create a profit and loss statement according to the cost-of-sale

accounting.

The fields profit center and partner profit center are also recorded in the general ledger.

This means that the general ledger can now also be used for management analysis.You can use the SAP ERP central component for displaying simplified management

accounting (“CO light”) in the general ledger. The available objects ar e cost centers and

primary cost types.

The segment field is a new entity (characteristic/category) and allows for processing segment

reporting. The table structure in the new general ledger is flexibly expandable, i.e., you can

insert own fields and carry out update totals. Standard reports are available for all

mentioned purposes.

Figure 32: Extended data structure

2.4.2.2 Advantages in detail: Document splitting (online split)

The GUI and the creation of accounting documents are similar to the previous release. Aninput tax rate of 16 % (German VAT, which in the meantime has raised to 19%) is assumed.

SAP supports now the derivation of segments from profit centers. In turn, profit centers can,

for example, be derived from a cost center, a management accounting internal order, or a

project.




page 31



Figure 33: Document splitting (1) (online split)

To ensure a continuous split of the segment characteristic, document split must be activated.

Continuous segmentation means that each document for an activated entity comes to the

balance 0 position. In addition to segmentation, inheritance of a segment to the lines vendor

and tax of the document is displayed.

The online split (and inheritance) replaces the period-end activities “balance sheetadjustment” (report SAPF180, perform balance sheet adjustment) and “profit and loss

adjustment” (report SAPF181, perform P/L adjustment).

Document split is carried out using “post processing processes” as well, e.g., numbers, cash

discount received, and cash discount paid are distributed to entities according to the amount of

the original expense account posting.

Customers invoices are processed the same way, i.e., revenues are distributed to different

entities.




page 32



Figure 34: Document splitting (2) (online split)

2.4.2.3 Advantages in detail: Real-time integration FI CO

In the following figure, you can see an example of real-time integration (CO-FI) using the

functional area as characteristic or criterion. The real-time integration can also be defined for

the criteria company code, business area, profit center, segment, funds, and receivables. The

selection is not an either-or decision. Real-time integration can also be activated for all these

characteristics at the same time.

What features financial accounting document 2B?

It is posted in real-time (per document). Reconciliation (summary reconciliation per expense

account/cost account) using the reconciliation ledger in cost accounting via transaction KALC

is no longer required.

It is a document that does not require a clearing account. However, clearing accounts are still

required for cross-company code transactions.

You can switch between the document created in FI in real-time and the management

accounting document: traceability of accounting documents.




page 33



Figure 35: Real-time integration FI - CO

2.4.2.4 Advantages in detail: Parallel accounting

In parallel accounting, one ledger in the new general ledger is the “leading ledger”. This

ledger is usually used for consolidated financial statements. The leading ledger reflects the

accounting rule, which is used for the consolidated financial statement. It is integrated with all

subledgers and updated for all company codes (provided that it is not posted ledger-specific).

The new general ledger allows for displaying parallel financial reports along with the leading

ledger. This function refers to the ledger solution in the new general ledger. In this context,

“ledger” does not refer to the special ledger as used in SAP R/3.

Excurse: In the application component special ledgers, the following ledger types are

available:

- Special ledgers are ledgers that are defined in accordance to special business-related

and organizational requirements. They contain only the dimensions you entered. In

the FI_SL-system, you can only create special ledgers.

- Standard ledgers are configured and delivered by SAP and maintained in

applications. You cannot maintain these ledgers with the FI-SL functionality, unlessthe functions of the respective applications allow you to do so (e.g., FI-SL posting

function). The standard ledgers include the general ledger, FI-LC/EC- MC’s consolidation ledger, EC- PCA’s profit center ledger, and CO-OM-CEL’s

reconciliation ledger.

Using additional accounts (account solution) you can still display parallel financial reports.

When selecting this option, the general ledger merely contains the general ledger as only

ledger. The ledger solution in the new general ledger and the account solution in SAP ERP

can be considered equivalent.

Display options from previous releases can still be used. For example, you can use the special

ledger and the company code variant, provided that they were available before implementingSAP ERP. However, they cannot be extended.




page 35



2.4.3.1 Posting key

Each document line item contains a posting key. The posting key is used for internal control

and is used for complex postings. It provides the system with the following information:

- account type to be posted,

- either it is a debit or credit posting, and

-

which fields of the line item have or need an entry

In the new ENJOY transaction, the posting key does not need to be entered anymore.

However, it appears in the document and its control functionality is still necessary.

Figure 38: Posting key

2.4.3.2 Account data

Balance display and line item display provide account data. Only if the particular function inthe G/L master record is activated, line item display is possible for a G/L account.

Balance display is an overview of the saved transaction amounts of an account. You can

navigate from the balance display to a list of line items from which the balance is computed.

From this line item report, you can in turn go back to the document containing the respective

line items. By choosing the document overview function, you can display the entiretransaction.

In case a real document is available for this SAP ERP document, which was optically

archived, you can display it as well.




page 36



Figure 39: Account data




page 37



2.5 Practical application – general ledger

You want to create a new G/L account from a FI point of view for department expenses

concerning the new department that you created in the human capital. Prior to this, you need

to focus on the chart of accounts principle in the SAP system. Moreover, you need todetermine, whether the G/L account (account number that you want to create) is already

existent or can be created.

Figure 40: Process overview: General ledger accounting

2.5.1 Chart of accounts

As explained in the theoretical section, a chart of accounts contains all accounts of a company

and structures them according to business-related characteristics. It is used by one or several

company codes for account validation in document posting and it is referred to as operating

chart of accounts.

Excurse: In addition, SAP ERP provides two other types of charts of accounts (alternativecharts of accounts), which reflect the law requirements of different countries and consolidate

reporting on enterprise-level.

The operational chart of accounts is used commonly by financial accounting and cost

accounting. The items of a chart of accounts can be expense or revenue accounts in FI and

cost or revenue elements in cost accounting.

You must assign one chart of accounts to each company code. Moreover, you can assign each

company code to a country-specific chart of accounts. Using the country-specific chart of

accounts, you can fulfill the country-specific accounting requirements and at the same time,

carry out management accounting consistently.

The chart of accounts and country-specific chart of accounts are linked using alternating

account numbers. Since the accounts in financial accounting and management accounting aremanaged with an integrated accounting system (i.e., there is no second accounting system for

cost accounting and primary cost types and revenue types are transferred from the P/L

expense accounts), you must consider the charts of accounts of the company codes at the time

of controlling area set-up. The controlling area uses the chart of accounts of the assigned

company code. In cross-company code accounting, the controlling area, and all assigned

company codes must use the same chart of accounts.

In the subsequent section, you will work with the INT (international) chart of accounts of the

SAP standard version. Thus is a pre-defined structuring scheme for recording values and

value flows for appropriate accounting. Multiple accounts are already assigned to the INT

chart of accounts.




page 38



2.5.1.1 Display the chart of accounts

Display the INT chart of accounts. Therefore, choose the following transaction in the

customizing menu.

IMG Financial Accounting (new) General Ledger Accounti ng (new) Master Data

G/L Accounts Preparations Edit Chart of Accounts L ist

Look for the IMG chart of accounts and double-click it.

Figure 41: INT chart of accounts: SAP system screenshot

At this point, you can maintain general control parameters for the chart of accounts. For

example, G/L accounts in the INT chart of accounts have a maximum length of ten digits. In

the G/L accounts of the present chart of accounts, you can also enter additional information

such as an enterprise account number. The system checks whether the enterprise account

number exists in the enterprise chart of accounts. If a chart of account structure is given, for

example, due to national requirements, you can define an enterprise chart of accounts. All

accounts contain an enterprise account number that is the same for equivalent accounts in

different charts of accounts. The definition of balance sheet and P/L statement from an

enterprise point of view can then be carried out using the enterprise account number, as

opposed to individual computation per country. For example, the enterprise chart of accountsCONS is here assigned to chart of accounts INT.

2.5.1.2 Assign the chart of accounts

Check the assignment of chart of accounts INT to company code.

IMG Financial Accounting (new) General Ledger Accounti ng (new) Master Data

G/L Accounts Preparations Assign Company Code to Char t of Accounts

Check whether the INT chart of accounts is assigned to company code 1000. The INT chart of

accounts should be entered in the chart of accounts column. You should see that the INT chartof accounts is assigned to several company codes. This only means that all these company

codes use the same account scheme. For the definition of G/L accounts in the chart of




page 39



accounts, an additional step is required that assigns the G/L account to a company code so that

the account is relevant to this company code in terms of accounting.

Go back to the IMG screen and choose

IMG Controll ing General Controll ing Organization Maintain Controll ingArea (

Maintain Controll ing Area)

Look for controlling area 1000 and double-click the entry. You can see here as well that the

INT chart of accounts was assigned. Next, focus on the chart of accounts in more detail.

2.5.1.3 Displaying the accounts of the chart of accounts

To check which accounts are included in the INT chart of accounts, display the chart of

accounts report . Therefore, go back to the SAP easy access menu and choose

I nf ormation System Accounting F inancial Accounting General Ledger Chart

of Accounts (transaction F .10)

Enter INT in the chart of accounts field and choose execute. The system displays all G/L

accounts of the INT chart of accounts.

Figure 42: Chart of accounts INT: SAP system screenshot




page 40



Look for account 140000 (domestic customer receivables). In the procurement process and

sales order management case studies, you already heard about the subledgers. This account is

a reconciliation account in the general ledger for customer accounts receivables. This account

records all changes regarding money values (receivables and liabilities) for all customers in

the general ledger. For example, if customer-999 claims 10000 Euro, then this amount isrecorded in customer account cutomer-999 (the customer master record is the corresponding

account in the customer sub-ledger as well). This amount is simultaneously recorded in the

general ledger on account 140000. Account 140000 is the standard reconciliation account in

the SAP INT chart of accounts for customers and is entered in the customer master record

when creating the customer in the reconciliation account field. Of course, you can use other

accounts as reconciliation accounts as well or create own accounts.

2.5.2 G/L accounts

2.5.2.1 Create a G/L account

Next, create a G/L account in the INT chart of accounts for expenses of your new department.

It is supposed to be a P/L account. By the end of the year, the balance of this account is closed

via retained earnings account 900000. Assign the account to the account group all G/L

accounts due to organizational reasons. It is assigned with account number 312600 to the

enterprise chart of accounts CONS.

To create the G/L account, choose

Accounting F inancial Accounting General Ledger Master Records G/L

Accounts I ndividual Processing I n Chart of Accounts (FSP0)

1. On the Edit G/L Account: Chart of accounts data screen, enter the following data:

a. G/L account 461xyy

b. Chart of accounts INT

Choose .2. In the Type/Descriptions tab, enter the subsequent data:

a. Account group SAKO General G/L accounts

b. P&L statement acct select

c. P&L statmt. acct type X

d. Functional area 0400

e.

Short text expenses SD&M xyyf. Group account number 312600

Save your entries.

2.5.2.2 Create G/L account in a company code

Make the new G/L account available in company code 1000. Line item display is required for

the new account. For line item display, sorting criteria are document number and fiscal year

(sort key 002). Since it is an expense account, field regarding expenses are supposed to be

displayed when processing document for this account. Assign the account to field status group

G033. Assign the account to commitment item 1423 for cash management reasons. Set the tax

category to input tax “-“. Set the flag “posting without tax permitted”.




page 41



Accounting F inancial Accounting General Ledger Master Records G/L

Accounts I ndividual Processing I n Company Code (FSS0)

1. On the Edi t G/L Account: Company code data screen, enter the following data:


b.

Company code 1000Choose .

2. In the control data tab, enter the following data:

a. Tax category - (only input tax allowed)

b. Posting without tax permitted select

c. Line item display select

d. Sort key 002

3. Go to the Create/bank/interesttab

a. Status group G033

b. commitment item 1423

Choose save .

2.5.2.3 Enter G/L account document

In your new department, expenses amount to 5000 Euro in company code 1000. Therefore,

you need to enter the expenses in the general ledger. To record the expenses, carry out a G/L

account posting. Use account 113100 for the corresponding items. Choose

Accounting F inancial Accounti ng General Ledger Posting

Enter G/L Account

Document (FB50)

1. When prompted to do so, enter company code 1000.

2.

Enter the following data:a. Document date current date

b. currency EUR

c. G/L account 461xyy

d. D/C debit

e. Amount in doc. curr 5000

f. Tax V0

g. G/L account 113100

h. D/C credit

i. Amount in doc. curr 5000

Save the document and list the document number on your data sheet.

G/L account document: ______________________________________

Note: In case you receive a message, select the second line and choose from the

lower part of the screen. Enter the curr ent date in the submi t on field. Choose and save the document again.

Cancel the transaction to leave it.




page 42



Figure 43: Enter G/L account document: SAP system screenshot

2.5.2.4 Check account

To ensure that the posting was carried out properly, check the balance of account 461xyy incompany code 1000 and go to the document. Choose

Accounting F inancial Accounting General Ledger Account Display Balances

(FS10N)

1. Enter the following data:


b. Company code 1000

c. Fiscal year current f iscal year

d. Business area no entry

2.

Choose Execute .




page 43



Figure 44: Display balance in general ledger: SAP system screenshot

The account’s balance for the current period is 5000 €.

Display the items of account 461xyy by double-clicking the passive balance (debit column)

for the current period.

Is the document number the same as the G/L account document posting?

List the answer on your data sheet. ________________________________________




page 44



2.6 Theory – Accounts payable

2.6.1 The vendor master record

The vendor master record contains data for controlling posting and processing of movement

data. This includes all information required for business transactions regarding a vendor .

On client-level, vendor-specific information such as name and address are stored. Each

company code assigned to the client can access this general information.

Company code-specific data record contains the part of the vendor master record that a

company needs to process vendor transactions by the respective company codes. Thus, it is

prevented that the same data are maintained in several company codes.

Goods and services purchased by a purchasing organization are procured from a vendor.

Payment is posted in vendor accounting. Therefore, different purchasing organizations of a

group must store purchasing-specific data in the vendor master record before they can usethe vendor master record.

Figure 45: The vendor master record

2.6.2 Procurement process from an accounting point of view

For individual sub-processes of procurement (purchase to pay), due to several subsequent

postings, the GR/IR clearing account as well as the bank clearing account are finally

balanced again. Short-term liabilities by the payment are cleared. From a balance sheet point

of view, procurement to stock is a material stock increase in combination with a bank

account reduction.

Possible external price volatilities in procurement can be recorded in the profit and loss

statement, depending on price control of the respective material in the master record of the

material.




page 45



Figure 46: Procurement process from an accounting point of view

2.6.3 Integration with materials management

The two last steps in the following figure can be carried out reversely. Thereby, it is important

whether goods receipt or invoice receipt is first. Using the GR/IR clearing account, you can

ensure that for each invoice receipt, a goods receipt occurred, and vice versa (GR/IR).

Figure 47: Integration with materials management

2.6.4 AP credit/invoice memo entry

Using a single-screen transaction, you can easily create and post a vendor invoice or a credit

memo. A vendor invoice or a credit memo is entered directly in vendor accounting. This type

of invoice is a miscellaneous invoice that does not refer to a purchase order. The screen toenter vendor invoices is structured as:




page 46



- In work templates, you can choose screen variants, account assignment templates, or

held documents as reference.

- In the header and vendor data, document header data and vendor line items are

recorded.

- In the line item information, the G/L line items for the document are entered.

-

In the information area, the document balance and vendor information are displayed.

Using this transaction, you can also create documents in different currencies. The foreign

currency amount is converted in the local currency using defined exchange rates.

Figure 48: Vendor invoice and credit memo

2.6.5 Elements of the payment process

The standard SAP system contains the usual payment methods and corresponding forms that

were entered for each country separately.




page 47



Figure 49: Elements of the payment process

2.6.6 Overview of the payment program

During the payment program, the system completes the following steps:

- posting payment documents

-

clearing open items- preparing data for printing payment media

Figure 50: Overview of the payment program




page 48



2.7 Practical application – accounts payable

2.7.1 Vendor invoice

You received a rent invoice of 10000 Euro from your vendor (who is also your hirer due to

simplification reasons) from the procurement process case study. This invoice is dated to

yesterday. Post the invoice to the cost center of your new department CC-MSD-xyy. Use G/L

account 470000 as offset account.

Figure 51: Process overview: Accounts payable

2.7.1.1 Enter vendor invoice

Choose

Accounting F inancial Accounti ng Vendors Document Entr y Invoice (FB60)

1. Enter the subsequent data:

a. vendor number of your vendor from case study 1

b. invoice date yesterday’s data

c.

posting date current dated. amount 10000

e. tax amount 0

f. tax code 0I (income tax 0%)

g. Text rent xyy

h. G/L account 470000

i. D/C debit

j. Amount in doc. curr 10000

k. Cost center CC-MSD-xyy

2. Choose save and list the document number and the vendor number on your data sheet.

vendor invoice: _______________________________________________

vendor: _________________________________________________________




page 49



Figure 52: Enter vendor invoice: SAP system screenshot

2.7.1.2 Display open items of the vendor

To check whether can open item was created for the vendor when posting your document, use

the report display/change line i tems. Determine the created open item using the document

number from the previous exercise.

Choose

Accounting F inancial Accounting Vendors Account Display/Change L ine

I tems (FBL1N)


a. Vendor account your vendor number


c. Open items select

d. Open to key date current date

2.

Choose execute .3. You can see the document from the previous exercise as open line item. Moreover,

you can see that the vendor is also an account in the vendor sub-ledger (account

100248), as mentioned earlier in the script. This account does not have a

corresponding one in the general ledger and is merely “synchronized” with the general

ledger using reconciliation account 140000.




page 50



Figure 53: Open items of the vendor: SAP system screenshot

2.7.2 Automatic payment

Create your own payment run. Carry out a payment selection run to pay the newly created

invoice of your vendor. Choose

Accounti ng F inancial Accounti ng Vendors Periodic Processing Payments

(F110)


a.

Run date current date

b. Identification GRxyy

2. Press Enter.

3. The status of your new pay run should be “no parameters entered as yet”.

Maintain the run parameters. Therefore, choose the parameters tab. The pay run selects all

recorded documents until the following month for your vendor in company code 1000. All

payments in this run are to be out using checks (S). You have to enter the posting date of the

next pay run so that the system can determine whether the payment is carried out in this run or

whether it can wait until the next one. The next pay run is supposed to be carried out today

plus one month.

4. In the parameters tab, enter the following data:

a. Posting date current date

b. Documents posted units current date

c. Company code 1000

d. Pmnt meths S

e. Next p/date current date + 1 month

f. vendor your vendor number

5. Choose Save and go back to the status tab.




page 51



Figure 54: Automatic payment run (1): SAP system screenshot

Plan a proposal run by choosing the proposal button. Immediately start the program.

6. Choose start immediately.

7.

Schedule the payment run by pressing Enter .

8. Update the status . The status should now be payment proposal has been

created .

To monitor the payment program run, choose the status symbol from the symbol bar. When

the system displays the message that the program is closed, continue processing.

Display the payment proposal

1. Select the display proposal button .

2.

The system displays a created check for the vendor.




page 53



Figure 56: Automatic payment run (3): SAP system screenshot

2.7.3 Display cleared items of the vendor

Next, check whether the originally open item was cleared by the automatic pay run using the

display/change li ne items function.

Accounting F inancial Accounting Vendors Account Display/Change L ine

I tems (FBL1N)


a. Vendor account number of your vendor


c. All items select

d. Posting date current date

2. Choose execute.

Was the originally open item cleared? Which document type is the new payment

item?

List the answer on your data sheet. ______________________________________________________________________

______________________________________________________________________




page 54



Figure 57: Cleared items of the vendor: SAP system screenshot




page 55



2.8 Theory – Accounts receivable

2.8.1 The customer master record

The customer master record contains data to control postings and process movement data.

This includes all information for processing business transactions concerning a customer .

On client-level, customer-specific information such as name and address are stored. Each

company code included in the client can access these data.

Company code-specific data include the part of the customer master data that a company

required to process transactions with customers in company codes. Thus, you do not have to

maintain the same data in different company codes.

Prior to processing any business transaction with customers, you need to determine sales area-

specific settings for a customer in a sales area (combination of sales organization, distribution

channel, and division). These settings can, for example, include special payment conditionsthat the customer negotiated with the respective sales area.

Figure 58: The customer master record

2.8.2 IDES credit control area

Credit control is performed by the organizational unit credit control area. The credit control

area can be assigned either to individual company codes (peripheral-organized company) or to

a group of company codes (centrally organized company).

A separate credit department generally performs management of a credit control area. The

credit department is structured in several credit representative groups. Each group consists of

several credit representatives.




page 56



The IDES group features four credit control areas:

- Mexico and Japan each have a separate credit department (credit control area 5000 and

6000).

- USA and Canada have a centralized credit control with credit control area 3000.

- For all European company codes, credit control is centralized as well (credit control

area 1000).

Figure 59: IDES credit control area

2.8.3 Credit management master record

The credit department creates a separate credit management master record, which is an

extension of the customer master record. Thus, the credit department can maintain and

monitor data regarding credit management.

The credit management master record consists of the following elements:

- General data that apply to all credit control areas. This includes, for example, address

and communication data of a customer or the maximum total limit that is allowed for

the sum of all granted credit limits.

- Credit control area data, which apply only to a particular credit control area. For

example, you can set the credit limit on credit control area level or a customer riskcategory.

- An overview, which contains the most important data from all previous sections.




page 57



Figure 60: Credit management master record

2.8.4 Sales process and integration

On the day a good is shipped, an outbound delivery document is created. The goods to be

delivered are posted as goods issue. Then, a goods issue document is created in materials

management and an accounting document is created in financial accounting. Thus, the goods

issue is posted to the correct G/L accounts. The accounting document debits the accounts with

the sold goods and credits the accounts with the stock.Billing completes the sales process. In the last stage of the sales process in SD, billing is

carried out and the customer receives a printed invoice. Simultaneously, a document is created

in FI. Thus, receivables and revenue can be posted to the correct accounts.

Figure 61: Sales process and integration




page 58



2.8.5 Sales order process from an accounting point of view

You can see in the following figure that the external stock sales process creates several central

documents from an accounting point of view.For a better understanding, it is important to firstly focus on the activity output of a product.

In both external procurement and in-house production, expenses paid through bank accounts

(e.g., cost of a production order) preceded. In in-house production, a finished inventory was

created from the delivery of settlement of the production order.

Delivery in the order to cash process reduces the stock account by withdrawing from this

produced stock. Billing created the income and the corresponding receivables regarding the

customer. Payment clears these receivables and leads thus to a credit memo on the bank

account.

Ideally, all accounts are settled exactly, except for a higher bank balance, because the income

is higher than the expenses, which is shown in the P&L statement by a corresponding profit.

Figure 62: Sales order process from an accounting point of view

2.8.6 Credit control process

Credit control in SAP ERP is carried out as follows:

- When an order is placed, you firstly check whether accepting the order exceeds the

credit limit of the costumer. If the order is within the customer’s credit limit, the sales

process can be carried out as usual.

- In case the order exceeds the credit limit, the order is blocked. Then, the credit

department can carry out particular measures. The credit representative in charge can

either be notified via remote email, or can use a report to check all blocked orders.

- The credit representative clarifies the next steps by either using the credit information

system or calling the customer.

- After clarification, the credit representative can release the order and it can be

processed as usual. Alternatively, the credit representative can refuse to release the

order and the order is rejected.




page 59



Figure 63: credit control process

2.8.7 Incoming payments in Accounts receivable

When the customer pays the open items to the full amount or with an approved cash discount,

open items of the order are cleared. Small payment differences can be charged off

automatically. The maximum amount that comes under minor payment is set in the tolerance

group.

All payment differences outside the tolerance must be processed manually.- partial payment: an item that is partially paid is not cleared

- residual item: an open invoice is paid and a new open item (residual item) of the

amount of the payment difference is created

Figure 64: Incoming payments in Accounts receivable




page 60



2.9 Practical application – Accounts receivable

2.9.1 Credit management

For proper automatic credit control, you must maintain the credit management master data for

each customer. To ensure this, the credit department runs a program on daily basis that

displays all customers for those credit management master data were not maintained, yet.

Run this program for company code 1000. Within the displayed master records, you can find

your customer 50xyy .

Figure 65: Process overview: Accounts receivable

2.9.1.1 Customer with missing credit data

To display the customers without proper maintained credit management master record in the

system, choose

Accounting F inancial Accounting Customers Credit Management Credit

Management I nfo System M issing Data (F .32)

1.

Enter company code 1000 .2. Select execute .

3. In the list, customer 50xyy should be included. Select search (CRTL+F ) to find your

customer in the list.

4. You should see that credit data for several company codes are missing for your

customer.

5. Close the view.

2.9.1.2 Maintain credit management master data

Maintain the credit management master data for customer 50xyy. Choose

Accounting F inancial Accounting Customers Credit Management Master Data

Change (FD32)


a. Customer 50xyy

b. Credit control area 1000

c. Central data select

d. Status select

2. Confirm with Enter.

3. Enter the following central data:

a. Total amount 500000

b.

Individual limit 100000

c. Currency EUR

4. Again, confirm with Enter.




page 61



Data for credit control area 1000: A credit limit of 10000 Euro in credit control area 1000 is

supposed to be entered for the customer. Assign the customer to the risk class for customers

with low risk (001) and to the corresponding credit representative group (001).

5.

Enter the following status data:a. Credit limit 10000 (Do not choose Enter, yet!)

b. Risk category 001

c. Credit rep. group 001

6. Save your entries.

Therewith, you entered the credit limit for the customer.

2.9.2 Enter sales order

Enter a customer order for your customer 50xyy. Your customer wants to order 100Speedstarletts. Choose (…). You should already be familiar with the transaction to enter sales

orders. Recall how to enter a sales order. Subsequently, you can find the data that belong to

the sales order:

1. Initial screen:

a. Order type OR

b. Sales organization 1000

c. Distribution channel 10

d. Division 00

2. Order data:

a. Sold-to-party 50xyy

b. Order number 13xyy

c. Desired delivery date current date + 1 week

d. Material Speedstarlett-xyy

e. Order quantity 100

3. If prompted, confirm the delivery date for complete delivery.

4. Save the order. The system notifies you that it is carrying out a dynamic credit check.

The dynamic credit check issues a message that the credit limit was exceeded. Choose

Enter to skip the message.

5. Optionally, save the order again and skip a possible message regarding the billing date

with Enter .

List the order number on your data sheet.

Order number: ____________________________________________________

2.9.3 Release blocked sales and distribution document

Two times a day, the credit department runs a program that issues all SD documents blocked

due to credit checks. Run this program for low-risk customers in credit control area 1000.

Execute the report for blocked SD documents by choosing the following transaction:




page 62



Accounti ng F inancial Sccounting Customers Credit Management Exceptions

Blocked SD Documents (VKM1)


a. Credit control area 1000

b.

Representative group 001c. customer 50xyy

2. Choose execute .

3. Select your sales order.

4. Choose release .

5. Choose save .

Figure 66: Release blocked SD document: SAP system screenshot

This is how you can manually release documents blocked by the system for further

processing.




page 63



2.10 Theory – Fixed asset accounting

2.10.1 Assets in financial accounting organizational units

An asset represents an economic good that is used in a company on a long-term basis (cf. unit

10, enterprise asset management). Assets can be, for example, machines, buildings, or server).

Each asset is assigned to a company code and to a business area. All postings (acquisitions,

retirements, depreciations, etc,) are carried out in the assigned company code and business

area.

Moreover, assets can be assigned to different CO objects (cost center, internal order, activity

type, etc.) and to logistic organizational units (only for selection purposes).

Figure 67: Assets in FI organizational units

2.10.2 Asset class

The main criterion when defining assets is the asset class. Each asset must be assigned to an

asset class. In the asset class, you can define particular control parameters and default values

for depreciation and other master data.

Assets that do not appear in the same line item of the balance sheet (e.g., buildings and

equipment) are assigned to different asset classes. Additionally, there is at least one special

asset class for assets under construction and low-value economic goods. IDES AG uses the

following asset classes:

- 4000 for assets under construction

- 5000 for low-value economic goods

Note 1: You can also create asset classes for intangible assets and leased assts. Functions are

available for processing leased objects.

Note 2: The plant maintenance component (PM) is used for the technical management of

assets. The treasury component (TR) is used for managing financial assets.




page 64



Figure 68: Asset class

2.10.3 Asset transactions

To fulfill the organizational and business-related requirements of a company, acquisitions and

retirements (asset transactions) can be posted in several ways. In FI-AA (financial

accounting, assets accounting), you have the following:

- without a vendor or a purchase order: the offsetting entry is made to a G/L clearing

account

-

to a vendor but without reference to a purchase order

- via materials management using the MM functionality (purchase order, goods receipt,

and invoice receipt)

Figure 69: Asset transactions




page 65



2.10.4 Transaction type

The transaction type is an addition to the asset posting keys 70 (debit) and 75 (credit). It

needs to be stated when posting to an asset account. The transaction type is required in asset

accounting since it determines where the asset posting is listed in the asset history sheet.

The transaction type is the distinguishing characteristic of different asset postings, including:- buying and selling,

- credit memos,

- acquisitions from internal production,

- adjustment postings,

- retirements without revenues, and

- depreciations and appreciations

Figure 70: Transaction type

2.10.5 Asset explorer

The asset explorer in the SAP ERP system allows for a clear overview of all activities related

to an asset. Along with transactions posted to an asset account, planned and posted

depreciations per depreciation period and per fiscal year are displayed. You can also display

details of FI operations. Branching to master data records and other cost objects as well as

performing simulations is possible.




page 66



Figure 71: Asset explorer

2.10.6 Depreciation areas

Often asset balances and asset movements need to be valued due to various reasons.

Depreciation areas in SAP ERP allow for the usage of more than one valuation basis. There

are different transaction figures in each area, according to the asset and the depreciation area

and to individual value components, for example, balances, depreciation, and remaining book

value.

Various data for depreciation areas are stored in the asset master record. These data control

the calculation of normal and special depreciation for the respective depreciation area. Thus,

you can perform, for example, depreciation for business procedure and for tax authorities.

Figure 72: Depreciation areas




page 67



2.10.7 Depreciation run

You need to carry out a depreciation run so that depreciations are posted in asset accounting.

Only after the completion of the depreciation run, depreciations are posted in asset accounting

in the general ledger. Depreciation is posted to the respective asset accounts of the general

ledger and of the assigned CO cost object in the asset master record.

Figure 73: Depreciation run




page 68



2.11 Practical application – asset accounting

Due to the growing warehouse operations in the bicycle warehouse, your company purchases

a forklift. Prior to its activation, you need to create an asset master record for the forklift in

asset class 3100 (vehicles).

Figure 74: Process overview: Asset accounting

2.11.1 Asset master record

Assign your forklift to cost center CC-MSD-xyy.

Accounting Financial Accounting F ixed Assets Asset Create Asset (AS01)


a. Asset class 3100 (vehicles)


c. Number of similar assets 1

2. Choose the button to maintain the master data for this asset.

3. Enter description forklift-xyy and choose the time-dependent tab.

4.

Enter business area 3000 (vehicles), cost center CC-MSD-xyy , and plant 1000 .5. Save your asset and skip the following message with Enter .

List the number of the asset on your data sheet.

Asset number: ____________________________________________

2.11.2 Post asset acquisition

Your company purchases the forklift from vendor 1000. The forklift costs 35000 € net, i.e.,

without 10% tax. Post the asset acquisition integratively, i.e., post the asset acquisition and the

liabilities to the vendor account in one document. Invoice date and posting date is today. Add

10% income tax (1I) to the net amount. Choose

Accounting

F inancial Accounti ng F ixed Assets Postings Acquisiti on

External Acquisiti on With Vendor (F -90)


a. Document date current date

b. Posting date current date

c.

Posting key (Pstky) 31 (invoice)d. Account 1000

2. Confirm with Enter .




page 69



3. Enter the following information:

a. Amount 38500

b. Tax amount 3500

c. Tax key 1I (income tax 10%)

d. Posting key (Pstky) 70 (assets debit)

e.

Account your asset numberf. Transaction type 100 (external acquisition)

Figure 75: Post asset acquisition: SAP system screenshot

4. If you get a warning in the status bar, confirm with Enter .

5. On the next screen, enter * in the amount field and enter tax key 1I again. Confirm

with Enter. Save the document and list the document number.

Document number (asset): _____________________________________________

2.11.3 Asset Explorer

Use the asset explorer to check the values of the new asset in depreciation area 01 (book

depreciation). Choose

Accounting Financial Accounting F ixed Assets Asset Asset Explorer (AW01N)

1. Enter company code 1000 and your asset number in the asset field.

2.

Select depreciation area 01 (book depreciation and US-GAAP local, respectively) inthe upper left window.

3. Select the posted val uestab.




page 71



2.12 Theory – balance sheet and profit & loss statement

2.12.1 Create balance sheet and P&L statement

Currently, you have two options to create a balance sheet in the ERP system:

- using an ABAP report

- using the G/L accounts information system

Both methods allow you to

- use different balance sheet versions,

- create individual and aggregated balance sheets for company codes,

- create individual and aggregated balance sheets for business areas,

- create balance sheets according to the operational chart of accounts,

- create balance sheets according to the country chart of accounts, and

-

create variance analyses between two fiscal years or planned and actual values

Figure 77: Create balance sheet and P&L statement

Even if the new general ledger is active, you can create the balance sheet and the P&L

statement using the “classic” program RFBILA00 – it is still available from the information

system for the general ledger in the SAP easy access menu.

General Ledger Reports (new) Financial Statement/Cash Flow General

Actual/Actual Comparisons Financial Statement

Commonly used program variants can be saved for time efficiency reasons to call them up

again quickly.

The new feature of RFBILA00 is that you can select the ledger from the selection screen, forwhich the analysis is supposed to be run.




page 73



2.13 Practical application – balance sheet and profit & loss

statement

Enter the newly created G/L account 461xyy into the balance sheet/P&L statement version

INT so that it appears at the right position when running the balance sheet.

Figure 79: Process overview: Balance sheet and profit & loss statement

2.13.1 Balance sheet and P&L statement structure

The new account needs to be entered into financial statement version INT. Enter it into the

financial statement version other operating charges . Choose

Accounting F inancial Accounti ng General Ledger Master Records General

Ledger Accounts I ndividual Processing In Company Code (FSS0)




2. Choose change .

3. Select .

4. In the select fi nancial statement dialog, enter the financial statement version INT.

Confirm with Enter .

5. You can now see the financial statement version INT. This is a standard version in

SAP for entering all accounts of the INT chart of accounts. For example, when you

are running a balance sheet/P&L statement report, all accounts from the INT chart of

accounts are listed according to this structure in the balance sheet or P&L statement. If

you, for example, do not assign your newly created G/L account to a respective node,

it is displayed in the report under node 8000000 (unassigned accounts).




page 74



Figure 80: Financial statement version: SAP system screenshot

6. Click on the node 3082090 and choose . In the fr om acct and to acct

column, enter your account number 461xyy in the next empty row. If there is no

empty line for entering your account, click the symbol to create an empty line.

Note: The fi nancial statement version can only contain 40 accounts per node. In

case there is no space left in node 3082090, overwr i te the first accoun t in the list,

whi ch begins with the digits 461xyy. Un ti l then, the other course parti cipant should

have completed his or her case study ;-)

7. Check the box’ debit (D) and credit (C).




page 75



Figure 81: Change financial statement version: SAP system screenshot

8. Confirm with Enter and save the change.

2.13.2 Create balance sheet and P&L statement report

A company creates balance sheets displaying an actual/actual period comparison with the

previous period when closing its books. Use the financial statement version INT. Choose

Accounting F inancial Accounti ng General Ledger I nformation System General

Ledger Reports Balance Sheet/Profi t and Loss Statement/Cash F low General

Actual /Actual Comparison Periodic Actual /Actual Compari son (S_ALR_87012252)


a.

Company code 1000 b. FIS Annual Rep.Struc INT

c. Fiscal year current fiscal year

d. period current period




page 76



2. Select execute . If you are asked choose “New Selection”.

3. You receive the balance sheet of the current period in comparison to the same period

of the previous year. In the balance sheet, you can drill down until the account

transaction figures.

4. Open the commercial balance sheet folder in the F in . statemnt i tm column if it is not

opened yet. Select an account and choose GoTo L ine I tems from the menu tonavigate to the individual items of the account.

5. Expand the other operating charges folder and make sure that your account 461xyy is

displayed in this balance sheet. Leave the report without saving.

Figure 82: Balance sheet and P&L statement report: SAP system screenshot




page 77



3 CompletionCongratulations! You completed the fi nancial accounting case study.

The subsequent case studies are based on the results of this case study. In case your data

differs from the description in the script, please contact your tutor prior to processing another

case study.

In the case study financial accounting in SAP ERP, you learned about the functional area

financial accounting.

Finally, please submit the carefully completed data sheet to your tutor (use support email

address) for the case study financial accounting .

Please comply with the naming rules. Non-compliant data sheets will not be accepted; i.e. re-

name the document that you downloaded from this course’s download area as follows:

08-FinancialAccounting-xyy-zzz-surname.doc

Thereby, you need to replace xyy with your user number without the “WIP“ and without the

hyphen (WIPx-yy) and replace zzz with the number of the client you are working on.

Example:

Your name is Max Mustermann, you are working on client 901, and your user number is

WIP9-99. Then, name the document as follows:

08-FinancialAccounting-999-901-Mustermann.doc




page 79



8. Determine whether this statement is true or false.

When a purchase order is created, a financial document is also created.

___________________________________________________________________________

9.

When the billing document is created in sales and distribution, an accounting documentthat debits the _____________________ and credits _____________________ is

automatically created.

10. What are the carious acquisitions and retirements that can be posted in asset accounting?

___________________________________________________________________________

___________________________________________________________________________

___________________________________________________________________________

___________________________________________________________________________

11. What is the purpose of the asset explorer?

___________________________________________________________________________

___________________________________________________________________________

___________________________________________________________________________

___________________________________________________________________________




8. Determine whether this statement is true or false.

When a purchase order is created, a financial document is also created.

False. A financial document is created when goods are received and when the invoice is

received, but not when the purchase order is created.

9. When the billing document is created in sales and distribution, an accounting document

that debits the customer and credits revenue is automatically created.

10. What are the various acquisitions and retirements that can be posted in asset accounting?

(1) Without a vendor or purchase order, the offsetting entry is made to a GL clearing account,

(2) to a vendor, but without reference to a purchase order and (3) via MM by creating a

purchase order.

11. What is the purpose of the asset explorer?

The asset explorer gives a clear overview of the activity for an asset per depreciation area and

fiscal year for the planned values, posted transactions, posted amounts, posted and planned

depreciation, and depreciation parameters.