S4F01 Exercise

(1)

S4F01

Financial Accounting in SAP

S/4HANA

.

PARTICIPANT HANDBOOK

INSTRUCTOR-LED TRAINING . Course Version: 05 Course Duration: 2 Day(s) Material Number: 50136698

(2)

(3)

(4)

(5)

Course Overview

TARGET AUDIENCE

This course is intended for the following audiences:

● Application Consultant ● Support Consultant ● Super / Key / Power User

(8)

(9)

UNIT 1

Overview of Financials for SAP

S/4HANA

Lesson 1

Explaining the Purpose and Functions of SAP HANA and SAP S/4HANA 2

Lesson 2

Describing the new Architecture of Accounting 3 Exercise 1: Display Financial Tables in the SAP HANA Backend 5

Lesson 3

Explaining the Purpose and Functions of SAP Fiori 10 Exercise 2: Customize your Launchpad and Generate your own Tiles 11 Exercise 3: Post a Simple FI Document 17

Lesson 4

Outlining the Migration of Financials to SAP S/4HANA 23

UNIT OBJECTIVES

● Explain the purpose and functions of SAP HANA and SAP S/4HANA ● Explain the purpose and functions of SAP S/4HANA Finance ● Explain the idea and concept of the Universal Journal

● Explain how SAP safeguards customer investments ● Outline the architectural changes in SAP Finance ● Explain SAP Fiori applications and tools

(10)

Lesson 1

Explaining the Purpose and Functions of SAP

HANA and SAP S/4HANA

LESSON OBJECTIVES

After completing this lesson, you will be able to:

● Explain the purpose and functions of SAP HANA and SAP S/4HANA ● Explain the purpose and functions of SAP S/4HANA Finance

LESSON SUMMARY You should now be able to:

● Explain the purpose and functions of SAP HANA and SAP S/4HANA ● Explain the purpose and functions of SAP S/4HANA Finance

(11)

Unit 1

Lesson 2

Describing the new Architecture of Accounting

LESSON OBJECTIVES

● Explain the idea and concept of the Universal Journal ● Explain how SAP safeguards customer investments ● Outline the architectural changes in SAP Finance

(12)

(13)

Unit 1

Exercise 1

Display Financial Tables in the SAP HANA

Backend

1. In transaction SE16N, locate the following basic financial tables and identify the table type for each table: FAGLFLEXT, GLT0, BSIS, ACDOCA, and BSEG.

Table Table Type

FAGLFLEXT GLT0 BSIS ACDOCA BSEG

2. In transaction SE11, for table ACDOCA, identify the descriptions of the following fields: Field Name Short Description

ANLN1 AUFNR PRCTR RFAREA SEGMENT RCNTR

(14)

Solution 1

Display Financial Tables in the SAP HANA

Backend

1. In transaction SE16N, locate the following basic financial tables and identify the table type for each table: FAGLFLEXT, GLT0, BSIS, ACDOCA, and BSEG.

Table Table Type

FAGLFLEXT Generated View

GLT0 Generated View

BSIS Generated View

ACDOCA Transparent

BSEG Transparent

a) Run transaction SE16N.

b) In the Table field, enter FAGLFLEXT, and press Enter on your keyboard.

Note:

The new General Ledger Totals table is an SAP HANA generated view table.

c) In the Table field, enter GLT0, and press Enter on your keyboard.

Note:

The classic General Ledger Totals table is an SAP HANA generated view table.

d) In the Table field, enter BSIS, and press Enter on your keyboard.

Note:

The index tables are SAP HANA generated view tables.

(15)

Note:

ACDOCA is not a view table. It is a transparent table.

f) In the Table field, enter BSEG, and press Enter on your keyboard.

Note:

BSEG is not a view table. It is a transparent table.

2. In transaction SE11, for table ACDOCA, identify the descriptions of the following fields: Field Name Short Description

ANLN1 Main Asset Number

AUFNR Order Number

PRCTR Profit Center

RFAREA Functional Area

SEGMENT Segment for Segmental Reporting

RCNTR Cost Center

a) Run transaction SE11.

b) In the Database table field, enter ACDOCA, and choose Display.

c) Use the vertical scroll bar to display the desired screen area or use CTRL+F to find each field.

Note:

The table contains many fields from all other applications (G/L, AA, ML, CO), including the customer fields added to the coding block.

d) Note the Short Description for each field.

(16)

(17)

● Explain the idea and concept of the Universal Journal ● Explain how SAP safeguards customer investments ● Outline the architectural changes in SAP Finance

(18)

Lesson 3

Explaining the Purpose and Functions of SAP

Fiori

LESSON OBJECTIVES

(19)

Unit 1

Exercise 2

Customize your Launchpad and Generate your

own Tiles

1. Check the customizing functionality offered to users with the SAP Fiori Launchpad. Add the tile Audit Journal to your My Home group.

2. Generate your own tiles. The tile should display the supplier locked for payment. Use the

Manage Supplier Line Items tile as a template. Filter the Manage Supplier Line Items

according to payment block locked for payment. Save your results as your own tile with the name My Blocked Supplier Line Items.

3. You receive an invoice for a company car (car##) for EUR 4.400 (Tax 10% included). Enter the invoice using the information in the table. (Replace ## with your group number.) Make a note of the document number:

Field Name Value

Company Coder 1010

Vendor T-AV##

Invoice date today’s date

Posting Date today’s date

Reference car##

Amount 4400

Tax amount 400

Tax code 1I (10% Input Tax (Training))

Text post ##

G/L account 65003000 (Vehicle Cost)

D/C Debit

Amount in Doc. Curr.. 4000

(20)

Field Name Value

Cost center 10101101

4. Block the recently ordered bill for payment. Use the Manage Supplier Line Items tile. Check your result with your My Blocked Supplier Line Items variant.

(21)

Unit 1

Solution 2

Customize your Launchpad and Generate your

own Tiles

1. Check the customizing functionality offered to users with the SAP Fiori Launchpad. Add the tile Audit Journal to your My Home group.

a) In the SAP Fiori Launchpad, choose S4F01–## on the top left corner and click on App Finder.

b) In the Search field, enter Audit Journal. c) Choose + to add the tile to the My Home group. d) Choose Home.

2. Generate your own tiles. The tile should display the supplier locked for payment. Use the

Manage Supplier Line Items tile as a template. Filter the Manage Supplier Line Items

according to payment block locked for payment. Save your results as your own tile with the name My Blocked Supplier Line Items.

a) In the SAP Fiori Launchpad, to search for the Manage Supplier Line Items tile, choose

Search and click on the tile.

b) On the Manage Supplier Line Items screen choose Filters. c) In the Filter field, below the Payment , choose More Filters. d) In the Select Filters field, enter Item Payment Block. e) Select Item Payment Block and choose OK.

f) Under Item Payment Block, enter A, and choose Go.

Note:

You can optionally also save the filter as your own variant.

g) Choose Share and then Save as Tile on the bottom right of the screen.

h) Enter My Blocked Supplier Line Items in the field Name and choose OK. i) Choose Home.

3. You receive an invoice for a company car (car##) for EUR 4.400 (Tax 10% included). Enter the invoice using the information in the table. (Replace ## with your group number.)

(22)

Make a note of the document number:

Field Name Value

Company Coder 1010

Vendor T-AV##

Invoice date today’s date

Posting Date today’s date

Reference car##

Amount 4400

Tax amount 400

Tax code 1I (10% Input Tax (Training))

Text post ##

G/L account 65003000 (Vehicle Cost)

D/C Debit

Amount in Doc. Curr.. 4000

Tax code 1I

Cost center 10101101

a) In the SAP Fiori Launchpad, choose Search and search for the Create Incoming

Invoices tile.

b) Enter the data from the table. c) Choose Simulate.

d) Choose Post.

e) Make a note of the accounting document number. f) Choose Home.

4. Block the recently ordered bill for payment. Use the Manage Supplier Line Items tile. Check your result with your My Blocked Supplier Line Items variant.

a) In the SAP Fiori Launchpad, choose Search and search for the Manage Supplier Line

Items tile.

b) Choose Go.

c) Select your document number. d) Choose Blocked for payment.

(23)

f) Choose OK and exit to your launchpad home. g) Open your My blocked Supplier Line Items tile.

All payment blocked bills are listed in this tile, including your newly blocked line.

(24)

(25)

Unit 1

Exercise 3

Post a Simple FI Document

1. In the SAP Fiori Launchpad, use Post General Journal Entries to post a General Ledger journal entry. Post the following document: cash payment 550 Euro (Tax 10% included) for vehicle costs. Post the following transaction: 10010000 (Petty Cash); Vehicle Cost: 65003000, Cost Center: 10101101.

Record the document number.

Field Name Value

Document Date today’s date

Company Code 1010

G/L Account 65003000

Debit amt in DC 550

Item Text sample post ##

TAX Code 1I

Cost Center 10101101

G/L Account 10010000

Credit amt in DC 550

Calculate tax select

Net entry deselect

2. Use Manage Journal Entries to display and reverse the document you just posted.

Field Name Value

Posting Date Today's date

Tax Report Date Today's date

Reversal Reason Reversal in current period

(26)

The document is reversed.

3. Use Display G/L Account Line Item to display the lines for the document that you posted. Check the Cost Center assigned for G/L Account 65003000.

Field Name Value

Ledger 0L

G/L Account 65003000

Status All Items

(27)

Unit 1

Solution 3

Post a Simple FI Document

1. In the SAP Fiori Launchpad, use Post General Journal Entries to post a General Ledger journal entry. Post the following document: cash payment 550 Euro (Tax 10% included) for vehicle costs. Post the following transaction: 10010000 (Petty Cash); Vehicle Cost: 65003000, Cost Center: 10101101.

Record the document number.

Field Name Value

Document Date today’s date

G/L Account 65003000

Debit amt in DC 550

Item Text sample post ##

TAX Code 1I

Cost Center 10101101

G/L Account 10010000

Credit amt in DC 550

Calculate tax select

Net entry deselect

a) In the SAP Fiori Launchpad, choose Post General Journal Entries in the General Ledger

Accounting group.

b) Enter the data from the table.

Note:

Account 65003000 requires an assignment to a CO object. G/L account 65003000 is relevant to tax.

(28)

d) Choose Simulate.

Note:

The line items and tax line can be adjusted individually. Save your settings as a variant.

e) Choose Post. Make a note of the accounting document number.

Note:

You can add a note at any time and they are logged by user and time.

f) In the header, choose Notes.

g) In the Enter note... field, enter sample post ##. (Replace ## with your group number.)

h) Choose Submit.

Note:

You can see all related documents. You can also display all ledger-specific views of the document in addition to the Entry View.

2. Use Manage Journal Entries to display and reverse the document you just posted.

Field Name Value

Tax Report Date Today's date

Reversal Reason Reversal in current period

Add Note reversed

a) In the SAP Fiori Launchpad, in the General Ledger Accounting group, choose Manage

Journal Entries.

b) In the Company Code field, enter 1010. c) In the Document Date field, enter today’s date. d) In the Fiscal Year field, enter the current year. e) Choose Go.

f) Select your journal entry. g) Choose Reverse.

(29)

Note:

All customized reversal reasons are available to choose from.

i) Enter the today’s date in the Posting Date j) Choose OK.

k) Choose your journal entry and choose Manage Journal Entry. l) Choose Home.

The document is reversed.

3. Use Display G/L Account Line Item to display the lines for the document that you posted. Check the Cost Center assigned for G/L Account 65003000.

Field Name Value

Ledger 0L

G/L Account 65003000

Status All Items

a) In the SAP Fiori Launchpad, in the General Ledger Accounting group, choose Display

G/L Account Line Item.

b) In the Ledger field, enter 0L .

c) In the Company Code field, enter 1010. d) In the G/L Account field, enter 65003000. e) In the Status field, choose All Items.

f) In the Posting Date field, enter today’s date. g) Choose Go.

Note:

You can see more than 200 different fields to choose from when you go to the output settings.

h) Choose Settings and select Cost Center. i) Choose OK.

(30)

(31)

Unit 1

Lesson 4

Outlining the Migration of Financials to SAP S/

4HANA

LESSON OBJECTIVES

● Describe the migration process

(32)

(33)

UNIT 2

General Ledger Accounting

Lesson 1

Managing GL Accounts and Cost Elements in SAP S/4HANA 26 Exercise 4: Create a primary account 27 Exercise 5: Create a Business Partner 31

Lesson 2

Managing Ledgers in SAP Accounting Powered by SAP HANA 38 Exercise 6: Create an Extension Ledger and Post a Document to it 39

UNIT OBJECTIVES

● Explain the new master data maintenance model

● Understand the impact on authorizations and the posting period lock ● Use the Universal Journal to enhance ledgers

(34)

Lesson 1

Managing GL Accounts and Cost Elements in

SAP S/4HANA

LESSON OBJECTIVES

(35)

Unit 2

Exercise 4

Create a primary account

Your company (company code 1010) needs two new G/L primary cost accounts.

1. Create the primary cost account 650030## in chart of accounts. Create the new G/L account with the following values:

Field Name Value

G/L Account: 650030##

Chart of Accounts: YCOA

G/L Account Type: Primary Costs or Revenue

Account Group (on General tab) ERG. (Income statement accounts)

Short Text: Freight expenses ##

G/L Account Long Text (on General tab) Freight expenses ##

Group Account Number(on General tab) 65003000 (Vehicle Costs)

2. Before postings can be made to G/L account 650030## in company code 1010, you need to define the company code and controlling area-specific settings with the following values:

Field Name Value

Account Currency (on the Control Data tab) EUR

Tax Category:

-Posting without tax allowed: Check

Field Status Group: (on the Create/Bank/ Interest tab)

YB04

Cost Element Category 1 (Primary costs/cost-reducing

revenues)

Note:

You have successfully created your account in company code 1010.

3. Create G/L account in Chart of Accounts.

Create the second cost account by copying the 650030## template account. Create G/L account 650020## in chart of accounts YCOA.

(36)

Solution 4

Create a primary account

Your company (company code 1010) needs two new G/L primary cost accounts.

1. Create the primary cost account 650030## in chart of accounts. Create the new G/L account with the following values:

Field Name Value

G/L Account: 650030##

G/L Account Type: Primary Costs or Revenue

Account Group (on General tab) ERG. (Income statement accounts)

G/L Account Long Text (on General tab) Freight expenses ##

Group Account Number(on General tab) 65003000 (Vehicle Costs)

a) In the SAP Fiori launchpad, in the General Ledger Accounting group, choose Manage

G/L Account Master Data.

b) On the Manage G/L Account Master Data screen, choose Add (+) .

c) On the New G/L Account Master Data — Header screen, enter the following data: Field Name Value

G/L Account: 650030##

Account Type: P Primary Costs or Revenue

Account Group: ERG.

G/L Account Long Text Freight expenses ##

Group Account Number 65003000 (Vehicle Costs)

d) Choose Save.

(37)

2. Before postings can be made to G/L account 650030## in company code 1010, you need to define the company code and controlling area-specific settings with the following values:

Field Name Value

Account Currency (on the Control Data tab) EUR

Tax Category:

Field Status Group: (on the Create/Bank/ Interest tab)

YB04

Cost Element Category 1 (Primary costs/cost-reducing

revenues)

a) Click Edit, on the top-right to go back into editing mode. b) Click on the tab Company Code Data and choose Add (+) . c) Enter Company Code 1010.

d) On the Control Data section, enter the following values: Field Name Value

Account Currency: EUR

Tax Category:

e) Scroll down to the Create/Bank/Interest section and enter the following data: Field Name Value

Field Status Group: YB04

f) Choose OK.

g) Click on the tab Controlling Data, enter Cost element Category 01 and select Generate h) Select Save

Note:

You have successfully created your account in company code 1010.

3. Create G/L account in Chart of Accounts.

Create the second cost account by copying the 650030## template account. Create G/L account 650020## in chart of accounts YCOA.

a) On the Manage G/L Account Master Data tab, enter the following data and choose Go:

(38)

Column 11 heading Column 2 heading

G/L Account: 650030## previously created

View Chart of Account View

b) Select the G/L Account displayed c) Choose Copy.

d) On the New G/L Account Master Data screen, enter the following values: Field Name Value

G/L Account: 650020##

Short Text: Advertising Costs ##

G/L Account Long Text: Advertising Costs ##

Group Account Number 65002000 (Vehicle Costs)

(39)

Unit 2

Exercise 5

Create a Business Partner

Create a new Business Partner master record for a new customer.

Note:

This course uses the characters ## as a placeholder for your group number. Whenever you see ## in an exercise step, replace it with your group number.

1. In the SAP Fiori launchpad, in the General Ledger Accounting group, start the Maintain

Business Partner app located.

2. Create the new business partner and maintain the General Data using the following information:

Field Name Value

Business Partner Categorization Organization

Business Partner T-CUS##

Create in BP role Business Partner General (Gen.)

default value from system

Grouping External alpha-numeric numbering (BPAB)

Title Company

Name Bikes & More ##

Street/House Number Prinzering ##

Postal Code/City 70173 Stuttgart

Country DE (Germany)

Region BW (Baden-Wurttemberg)

Language German

3. Maintain the Company Code Data for the new business partner using the following information:

Field Name Value

BP Role FI Customer

(40)

Field Name Value Reconciliation Account 12100000

4. Maintain the Sales Area Data using the following information:

Field Name Value

BP Role Customer

Sales Organization 1010

Distribution Channel 10

Division 00

Sales District DE0002 (Southern Germany)

Currency EUR

Price Group C1 (Regular Buyer)

Customer Pricing Procedure 01 (Procedure 01)

Delivering Plant 1010

Shipping Conditions 01 (Standard)

Incoterms EXW

Inco. Location1 Plant 1

Terms of Payment 0001 (Pay immediately w/o deduc-tion))

Account Assignment Group 01 (Domestic Revenues)

Tax Classification 1 (Liable for Taxes)

5. Check that the mandatory partner functions have been filled automatically. Notes the values in the following table:

Partner Function Number Sold-To Party

Bill-To Party Payer

(41)

Unit 2

Solution 5

Create a Business Partner

Create a new Business Partner master record for a new customer.

Note:

This course uses the characters ## as a placeholder for your group number. Whenever you see ## in an exercise step, replace it with your group number.

1. In the SAP Fiori launchpad, in the General Ledger Accounting group, start the Maintain

Business Partner app located.

a) On the SAP Fiori launchpad, in your General Ledger Accounting group, choose the

Maintain Business Partner tile.

2. Create the new business partner and maintain the General Data using the following information:

Field Name Value

Business Partner Categorization Organization

Business Partner T-CUS##

Create in BP role Business Partner General (Gen.)

default value from system

Grouping External alpha-numeric numbering (BPAB)

Title Company

Name Bikes & More ##

Street/House Number Prinzering ##

Postal Code/City 70173 Stuttgart

Country DE (Germany)

Region BW (Baden-Wurttemberg)

Language German

a) On the Maintain Business Partner screen, choose Organization. b) Complete the Business Partner and Grouping fields.

(42)

d) Save your entries, but do not leave the screen.

3. Maintain the Company Code Data for the new business partner using the following information:

Field Name Value

BP Role FI Customer

Company Code 1010

Reconciliation Account 12100000

a) To switch to change mode, choose Switch between Display and Change. b) In the Change in BP role field, enter the value FI Customer.

c) Choose Company Code at the top of the screen. d) Enter the company code, and press Enter.

e) On the Customer: Account Management tab page, complete the Reconciliation

Account field.

f) Save your entries, but do not leave the screen.

4. Maintain the Sales Area Data using the following information:

Field Name Value

BP Role Customer

Sales Organization 1010

Distribution Channel 10

Division 00

Sales District DE0002 (Southern Germany)

Currency EUR

Price Group C1 (Regular Buyer)

Customer Pricing Procedure 01 (Procedure 01)

Delivering Plant 1010

Shipping Conditions 01 (Standard)

Incoterms EXW

Inco. Location1 Plant 1

Terms of Payment 0001 (Pay immediately w/o deduc-tion))

(43)

Field Name Value

Tax Classification 1 (Liable for Taxes)

a) In the Change in BP role field, enter Customer.

b) Choose Sales and Distribution at the top of the screen.

c) Complete the Sales Organization, Distribution Channel, and Division fields using the appropriate data from the table.

d) To confirm your entries, press Enter.

e) On the Orders tab, maintain the Sales District, Currency, Price Group, and Customer

Pricing Procedure fields.

f) On the Shipping tab, maintain the Delivering Plant and the Shipping Conditions fields. g) On the Billing tab, maintain the values for Incoterms, Inco. Location1, Terms of

Payment, Account Assignment Group, and Tax Classification.

h) Save your entries.

5. Check that the mandatory partner functions have been filled automatically. Notes the values in the following table:

Partner Function Number Sold-To Party

Bill-To Party Payer

Ship-to Party

a) On the Partner Functions tab, within the Customer Data of your new business partner (T-CUS##), check the values for the partner functions and note them in the table.

(44)

(45)

● Understand the impact on authorizations and the posting period lock

(46)

Lesson 2

Managing Ledgers in SAP Accounting Powered

by SAP HANA

LESSON OBJECTIVES

● Use the Universal Journal to enhance ledgers

(47)

Unit 2

Exercise 6

Create an Extension Ledger and Post a

Document to it

1. Create an extension ledger. The ledger code should start with one alphabetic character. Therefore, please use the following numbers for its new extension ledger:

Table 1: Extension Ledger User Numbers

User Numbers Use the following

1 – 9 Z1 – Z9

10 – 19 E0 – E9

20 – 29 F0 – F9

30 – 39 G0 – G9

Field Name Value

Ledger (Z# or E# or F# or G#)

Leading deselect

Ledger Type Extension Ledger

Ledger Name ## Extension Ledger

Underlying Ledger 0L

2. Assign a document type and a number range to the extension ledger.

Field Name Value

Ledger Your new Extension Ledger

Document Type SA

Number Range 70

3. Post a simple FI document only in your Extension Ledger ledger group (Z# or E# or F# or G#) and check the result. In the SAP Fiori launchpad and post a General Ledger journal entry, use the tile Post General Journal Entries. 50 Euro Cash payment (G/L account 10010000) and Fines and Penalties (G/L account 70900000).

Field Name Value

(48)

Field Name Value

Ledger Group (Z# or E# or F# or G#)

Journal Entry Type SA

Line1- G/L Account 70900000

Line1– Debit amt in DC 50

Line2- G/L Account 10010000

Line2- Credit amt in DC 50

4. Display the financial statement. In the SAP Fiori launchpad, choose Display Financial

Statement.

Field Name Value

Ledger ##

(49)

Unit 2

Solution 6

Create an Extension Ledger and Post a

Document to it

1. Create an extension ledger. The ledger code should start with one alphabetic character. Therefore, please use the following numbers for its new extension ledger:

Table 1: Extension Ledger User Numbers

User Numbers Use the following

1 – 9 Z1 – Z9

10 – 19 E0 – E9

20 – 29 F0 – F9

30 – 39 G0 – G9

Field Name Value

Ledger (Z# or E# or F# or G#)

Leading deselect

Ledger Type Extension Ledger

Ledger Name ## Extension Ledger

Underlying Ledger 0L

a) Navigate to Customizing Financial Accounting (New) → Financial Accounting Global

Settings (New) → Ledgers → Define Settings for Ledgers and Currency Types.

b) Choose New Entries.

c) On the Ledger dialog box, in the Ledger field, enter a ledger code. (Z# or E# or F# or G#).

d) In the Ledger Type field, enter Extension Ledger. e) In the Ledger Name box, enter ## Extension Ledger.

f) Choose 0L in the Underlying Ledger box. g) Choose Save.

(50)

Note:

You can see a ledger group with the same name is created. The ledger contains only this ledger.

Choose Continue.

2. Assign a document type and a number range to the extension ledger.

Field Name Value

Ledger Your new Extension Ledger

Document Type SA

Number Range 70

a) Configure an Extension Ledger in Customizing for Financial Accounting (New),

Financial Accounting Global Settings (New) → Document → Document Types

→ → Define Document Types for Entry View in a Ledger.

b) Choose New Entries.

c) In the Work Area dialog box, enter Your new Extension Ledger. d) Choose Continue.

e) Choose New Entries.

f) In the Document Type field, enter SA. g) To confirm your entry, press Enter. h) In the Number Range field, enter 70.

i) To confirm your entry, press Enter. j) Choose Save.

3. Post a simple FI document only in your Extension Ledger ledger group (Z# or E# or F# or G#) and check the result. In the SAP Fiori launchpad and post a General Ledger journal entry, use the tile Post General Journal Entries. 50 Euro Cash payment (G/L account 10010000) and Fines and Penalties (G/L account 70900000).

Field Name Value

Document Date Today's Date

Ledger Group (Z# or E# or F# or G#)

Journal Entry Type SA

Line1- G/L Account 70900000

(51)

Field Name Value

Line2- Credit amt in DC 50

a) In the SAP Fiori launchpad, in the General Ledger Accounting group, choose Post

General Journal Entries.

b) Enter the data from the table. c) To confirm your input, press Enter. d) Choose Simulate.

e) Choose Save.

You can see the values posted to your ledger. f) Choose Home.

4. Display the financial statement. In the SAP Fiori launchpad, choose Display Financial

Statement.

Field Name Value

Ledger ##

Financial Statement Version 1010

a) In the SAP Fiori launchpad, in the General Ledger Accounting group, choose Display

Financial Statement.

b) In the Company Code field, enter 1010. c) Choose Ledger.

d) In the Ledger field, enter Z#.

e) In the Financial Statement Version field, enter 1010. f) Choose Go.

You can see under Profit and Loss Statement –> Annual net income/ net loss –> Operating income –> Other Operating expenses the values posted to your ledger are added as a delta to the underlying values already posted to the account.

g) Choose Home.

(52)

(53)

● Use the Universal Journal to enhance ledgers

● Configure ledgers in SAP Accounting powered by SAP HANA

(54)

(55)

UNIT 3

Asset Accounting

Lesson 1

Analyzing the Posting Logic of new Asset Accounting 48 Exercise 7: Post Integrated Asset Acquisitions 49 Exercise 8: Post Integrated Asset Acquisition only for IFRS Accounting Principles 55

Lesson 2

Configuring new Asset Accounting 61

UNIT OBJECTIVES

● Understand the Architecture of Asset Accounting in SAP S/4HANA ● Explain the Posting Logic in Asset Accounting

● Understand the customizing of New Asset Accounting ● Perform the customizing of New Asset Accounting

(56)

Lesson 1

Analyzing the Posting Logic of new Asset

Accounting

LESSON OBJECTIVES

(57)

Unit 3

Exercise 7

Post Integrated Asset Acquisitions

Note:

In this exercise, replace ## with your unique group ID.

1. Create an asset in asset class 2000 using the data in the table.

Field Name Value

Asset Class 2000

Number of similar assets 1

Description Asset 2##

Cost Center T-CCA##

2. For your asset, post an acquisition to vendor T-AV## for January 7, CY (CY = current year). The purchase price is 11000 Euro (TAX 10% included). (Replace ## with your group number.)

Field Name Value

Document Date 07.01.CY

Posting Date 07.01.CY

Period 01

Reference asset 2##

Doc.Header Text asset 2##

PstKy 31 Account T-AV## Amount 11000 Tax Amount 1000 Tax code 1I PstKy 70

Account your asset

(58)

Field Name Value

Amount *

3. Check the posted values for your asset in the Asset Values tile.

4. There are 200 Euro transport costs included in your invoice. These transport costs should not be activated in the Depreciation Areas Local. Enter a credit (Transaction Typ 105) and book to transport costs (account 65002000).

.

Field Name Value

Existing asset your asset

Accounting Principle LG

Amount posted 200

Offsetting acct no. 65002000

Transaction Typ 105

(59)

Unit 3

Solution 7

Post Integrated Asset Acquisitions

Note:

1. Create an asset in asset class 2000 using the data in the table.

Field Name Value

a) In the SAP Fiori launchpad, in the Asset Accounting group, choose Create Asset Master

Record.

b) In the Asset Class field, enter 2000. c) In the Company Code field, enter 1010. d) In the Number of similar assets field, enter 1.

To confirm your entry, press Enter.

e) In the Description field, enter Asset 2## (replace ## with your group number). f) Open the Time-dependent tab.

g) In the Cost Center field, enter T-CCA##. h) Choose Save.

Alternatively, press Ctrl+S.

i) Choose Exit to quit the transaction.

2. For your asset, post an acquisition to vendor T-AV## for January 7, CY (CY = current year). The purchase price is 11000 Euro (TAX 10% included). (Replace ## with your group number.)

Field Name Value

(60)

Field Name Value

Period 01

TType 100

Amount *

a) In the SAP Fiori launchpad, in the Asset Accounting group, choose tile Acquisition

without order (integrated AP) .

b) Enter the data from the table. c) Choose Display Document overview. d) Choose Simulate Asset Accounting.

Alternatively, press Ctrl+F11.

Note:

Here you can clearly see the documents that will be generated during posting. The first three lines are the operational entry document, the next two are the Ledger specific documents.

e) Choose Accounting Principle and then choose the LG: Local GAAP menu item to execute it.

To confirm your entry, press Enter.

f) Choose IFRS: International Financial Reporting to execute it. To confirm your entry, press Enter.

Note:

The 0L and 2L documents are very similar, using the same accounts and only differentiating on the ledger level.

(61)

g) Choose Back to return to the previous page. Alternatively, press F3.

h) Choose Post.

i) Remain on this screen for the next task.

3. Check the posted values for your asset in the Asset Values tile.

a) In the SAP Fiori launchpad, under Asset Accounting, choose Asset Values . .

Note:

The asset, values are displayed per Depreciation Area, grouped by the Accounting Principle/Ledger Group.

b) Remain on this screen for the next task.

4. There are 200 Euro transport costs included in your invoice. These transport costs should not be activated in the Depreciation Areas Local. Enter a credit (Transaction Typ 105) and book to transport costs (account 65002000).

.

Field Name Value

Existing asset your asset

Accounting Principle LG

Amount posted 200

Offsetting acct no. 65002000

Transaction Typ 105

a) In the SAP Fiori launchpad, under Asset Accounting group, choose Post Acquisition

With Automatic Offsetting Entry.

b) Enter the appropriate data from the table.

c) Open the Additional Details tab and enter the appropriate data from the table. d) Choose Simulate menu item to execute the invoice.

Alternatively, press F9.

Note:

The document is only posted in ledger 2L (Local GAAP).

(62)

e) Choose Save.

f) Remain on this screen for the next task.

5. Check the posted values for your asset in the Asset Values transaction.

a) In the SAP Fiori launchpad, under Asset Accounting group, choose tile Asset Values. .

Note:

The credit memo is only recorded in Depreciation Area Local GAAP.

b) Choose Exit to quit the transaction. Alternatively, press Shift+F3.

(63)

Unit 3

Exercise 8

Post Integrated Asset Acquisition only for IFRS

Accounting Principles

Note:

1. Create an asset based on the data in the table. Check the Depreciation Area.

Field Name Value

2. For your asset, post an acquisition to vendor T-AV##. The purchase price is 11000 Euro (TAX 10% include). Use the data in the data to create the acquisition and replace ## with your group number.

Field Name Value

Posting Date Today's Date

(64)

Field Name Value

Amount *

(65)

Unit 3

Solution 8

Post Integrated Asset Acquisition only for IFRS

Accounting Principles

Note:

1. Create an asset based on the data in the table. Check the Depreciation Area.

Field Name Value

a) In the SAP Fiori launchpad, in the Asset Accounting group, choose Create Asset Master

Record.

b) Enter the data from the table.

c) Choose the Deprec. Areas tab to select it.

Note:

Only Depreciation Areas related to IFRS accounting principles are active (Area Number 20 CostAcct., 32 IFRSLocalCry and 33 IFRSGroupCry).

d) Choose Save.

e) Choose Exit to quit the transaction.

2. For your asset, post an acquisition to vendor T-AV##. The purchase price is 11000 Euro (TAX 10% include). Use the data in the data to create the acquisition and replace ## with your group number.

Field Name Value

(66)

Field Name Value

TType 100

Amount *

a) In the SAP Fiori launchpad, in the Asset Accounting group, choose Acquisition without

order (integrated AP).

b) Enter the data from the table. c) Choose Display Document overview. d) Choose Simulate Asset Accounting. e) Choose Accounting Principle.

f) Choose LG: Local GAAP.

Note:

The 2L document is not posting to the asset. It uses the Activation Differences account.

g) Choose Back to return to the previous page. Alternatively, press F3.

h) Choose Post.

Alternatively, press Ctrl+S.

i) Stay on this screen for the next task.

3. Check the posted values for your assets in the Asset Explorer transaction.

a) In the SAP Fiori launchpad, under theAsset Accounting group, choose Asset Values . .

(67)

Note:

For the asset created in previous exercise, values and transactions are only available for the depreciation area IFRS.

(68)

(69)

Unit 3

Lesson 2

Configuring new Asset Accounting

LESSON OBJECTIVES

(70)

(71)

UNIT 4

Reporting

Lesson 1

Providing an overview of Reporting Options 64 Exercise 9: Output a Financial Statement 65 Exercise 10: Use Analysis for Office Trial Balance 69 Exercise 11: Use SAP BusinessObjects Lumira to Visualize Data 73

UNIT OBJECTIVES

● Understand the Analytics Architecture in SAP S/4HANA ● Explain the different Data Consumption tools

(72)

Lesson 1

Providing an overview of Reporting Options

LESSON OBJECTIVES

(73)

Unit 4

Exercise 9

Output a Financial Statement

1. In the SAP Fiori launchpad, use Display Financial Statement to display the financial statement per Segment and Profit Center.

Field Name Value

Ledger 0L

Segment 1000_C

2. Search for the position Petty Cash (G/L Account 0010010000) in the segment balance sheet 1000_C and analyze the document with the highest amount. Answer the following questions:

● What is the amount on this account? ● Who posted this amount?

(74)

Solution 9

Output a Financial Statement

1. In the SAP Fiori launchpad, use Display Financial Statement to display the financial statement per Segment and Profit Center.

Field Name Value

Ledger 0L

Segment 1000_C

a) In the SAP Fiori launchpad, in the Operating Processing group, choose Display

Financial Statement.

b) In the Company Code field, enter 1010. c) In the Ledger field, enter 0L.

d) In the Financial Statement Version field, enter 1010. e) Choose Filters.

f) Choose More Filters under Financial Statement section. g) Select Profit Center and Segment. Choose OK.

h) Select the Add to Filter Bar . i) Choose Go.

The fields Profit Center and Segment are now ready for entry as selection fields. j) In the Segment field, enter 1000_C.

k) Choose Go.

The balance sheet of Segment 1000_C is now shown.

2. Search for the position Petty Cash (G/L Account 0010010000) in the segment balance sheet 1000_C and analyze the document with the highest amount. Answer the following questions:

● What is the amount on this account? ● Who posted this amount?

(75)

a) Choose ASSET → Current assets → IV. Checks, cash on hand, deposit main bank → 3.

Cash → Petty Cash.

b) Select the amount and choose the Display G/L Line Items app. c) Choose Journal Entry number 0100000012.

d) Click Journal Entry 0100000012 The Fact Sheet Journal Entry appears. e) Choose Home.

(76)

(77)

Unit 4

Exercise 10

Use Analysis for Office Trial Balance

1. Start Analysis for Microsoft Excel.

Field Name Value

System T41

Client 400

User S4F01–##

Password Welcome1

2. Analyze ledger 0L for company code 1010 of the current year.

Field Name Value

Ledger 0L

Posting Date From 01.01.CY

Posting Date To 31.12.CY

Comparison Posting Date From 01.01.LY

3. Use the side panel to improve the layout with drag-and-drop and a few clicks. As you don't want to renew the screen with every change, just use refresh. Focus on the field "Amount in CC". Since there is only one company, drag the company from the rows to the filter. Finally, add the Segment hierarchy for the financial accounts.

(78)

Solution 10

Use Analysis for Office Trial Balance

1. Start Analysis for Microsoft Excel.

Field Name Value

System T41

Client 400

User S4F01–##

a) To open Analysis, choose Analysis for Microsoft Excel. b) If asked to choose a workbook, select Blank workbook. c) In Excel, choose the Analysis tab.

d) In Analysis, ensure that cell A1 is selected on the Excel worksheet. In the ribbon, choose Insert Data Source and choose Select Data Source.

e) Choose Skip.

f) Select the T41 system, and choose Next. g) In the Client field, enter 400.

h) In the User field, enter S4F01–##.

i) In the Password field, enter your password and choose OK. j) In the Search For field, enter Trial and press Enter.

k) Select Trial Balance Comparison in the Search For field, and choose OK. 2. Analyze ledger 0L for company code 1010 of the current year.

Field Name Value

Ledger 0L

Posting Date From 01.01.CY

Posting Date To 31.12.CY

(79)

Field Name Value

a) In the Ledger field, enter 0L.

b) In the Company Code field, enter 1010.

c) In the Posting Date From field, enter 01.01.CY. d) In the Posting Date To field, enter 31.12.CY.

e) In the Comparison Posting Date From field, enter 01.01.LY. f) In the Comparison Posting Date To field, enter 01.12.LY.

The trial balance shows all accounts with beginning balance, debits / credits, and ending balance.

3. Use the side panel to improve the layout with drag-and-drop and a few clicks. As you don't want to renew the screen with every change, just use refresh. Focus on the field "Amount in CC". Since there is only one company, drag the company from the rows to the filter. Finally, add the Segment hierarchy for the financial accounts.

a) Choose Pause Refresh.

b) Double-click Measures and select Amount in CC, and then choose OK. c) Move the Company Code from Rows to Background filter.

d) Move Segment from Data Source to Columns. e) Choose Pause Refresh.

Note:

● All data is read in real-time from the universal journal in SAP

Accounting. And thanks to SAP HANA, this is done at phenomenal speed even with high data volumes.

.

(80)

(81)

Unit 4

Exercise 11

Use SAP BusinessObjects Lumira to Visualize

Data

1. Open SAP BusinessObjects Lumira using the information in the table.

Field Name Value

Connect to Local BW System

System T41[SPACE]

Client 400

User S4F01–##

Language EN

2. Create a new dataset for transient query 2CCSDSLSORDERITEMQ, which shows data for the analytical query CDS view C_SalesOrderItemQry (Incoming Sales Order). From the available fields, add Net Amount, Sales Organization, Sales Order, Sales Order Item, Material, Yr/Mo of Creation. Create a visualization 1: Geo Choropleth Chart. 3. Create a visualization 2 and 3: Funnel Chart To create visualization 3 duplicate

visualization 2 and filter on Sales Organization Dom. Sales Org US. 4. Create a Visualization 4: Crosstab

5. Compose a storyboard with your visualization, save it locally with name U##_Report and preview it. The result should look similar to the following two shown pages.

(82)

Solution 11

Use SAP BusinessObjects Lumira to Visualize

Data

1. Open SAP BusinessObjects Lumira using the information in the table.

Field Name Value

Connect to Local BW System

System T41[SPACE]

Client 400

User S4F01–##

Language EN

a) Choose SAP Lumira. b) Choose File → New.

c) Select Download from SAP Business Warehouse, then choose Next.

If the option Download from SAP Business Warehouse is not available Go to

Menu → File → Extensions. Download the extension for SAP BW. Restart SAP Lumira.

d) Enter the details from the table, and then choose Connect.

2. Create a new dataset for transient query 2CCSDSLSORDERITEMQ, which shows data for the analytical query CDS view C_SalesOrderItemQry (Incoming Sales Order). From the available fields, add Net Amount, Sales Organization, Sales Order, Sales Order Item, Material, Yr/Mo of Creation. Create a visualization 1: Geo Choropleth Chart.

a) In the View dropdown field, select Info/Area b) In the Find field, enter 2CCSDSLSORDERITEMQ.

Note:

The transient query is based SQL view CSDSLSORDERITEMQ with prefix 2C. The corresponding view name is C_SalesOrderItemQry .

c) Select the Incoming Sales Order entry and choose Next.

(83)

f) Select Sales Organization from the Dimensions field and click Add. g) Select Sales Order from the Dimensions field and click Add. h) Select Sales Order Item from the Dimensions field and click Add.

i) Select Material from the Dimensions field and click Add.

j) Select Yr/Mo of Creation from the Dimensions field and click Add. k) Choose Create.

l) From the Geographic Charts field, select type Geo Bublle Chart. m) Choose Options for Sales Organization.

n) Choose Create a geographic hierarchy → By name. o) Choose Confirm.

p) From the Recommendations dropdown boxes for Dom. Org DE, choose Germany. q) From the Recommendations dropdown boxes for Dom. Org US, choose United

States.

r) Choose Done.

s) Drag Net Amount from the Measures section to the Color field of the Measures section. t) Drag Geography_Sales Organization from the Dimension section to the Geography field

of the Dimension section.

u) Choose the Configuration button next to the name of the visualization above the top left of the map and rename the visualization title to Incoming Sales Orders by

Country.

3. Create a visualization 2 and 3: Funnel Chart To create visualization 3 duplicate visualization 2 and filter on Sales Organization Dom. Sales Org US.

a) To add a new visualization. choose the + button. b) From the Other Charts, select Line Chart.

c) Drag Net Amount from the Measures section to the Values field of the Measures section.

d) Drag Sales Order KEY from the Dimension section to the Color field of the Dimension section.

e) Choose Add filters and then Sales Organization. f) Select Dom. Sales ORG DE and choose Apply.

g) Choose Option and rename the visualization title to Germany /Incoming Sales

Order / Net Sales in USD.

h) From the context menu of visualization 2, choose Settings, then Duplicate. i) In the new duplicated Visualization, click Filter and choose Dom. Sales ORG US. j) Choose Option and rename the visualization title to United States/Incoming

Sales Order / Net Sales in USD.

(84)

4. Create a Visualization 4: Crosstab

a) Choose the + button to add a new visualization. b) From the Tables section, select Crosstab. c) Drag Net Amount to the Measures section.

d) Drag Yr/Mo of Creation to the Column section. Position it so that it is first. e) Drag Sales Organization to the Rows section.

f) Drag Material to the Rows section.

g) Choose Option and rename the visualization title to Incoming Sales Orders by

Sales Organization and Material..

5. Compose a storyboard with your visualization, save it locally with name U##_Report and preview it. The result should look similar to the following two shown pages.

a) Choose Compose.

b) Name your storyboard Incoming Sales Orders. c) Name the page Geographic Overview.

d) In the Templates field, choose Blank.

e) Add a title (Text –> Title) and your geo chart. f) Choose + Add Page.

g) Name the page Order Details. h) In the Templates field, choose Overview.

i) Add a title and the remaining visualization. j) In the Name field, enter U##_Report. k) Choose Save

(85)

(86)

(87)

UNIT 5

Lesson 1

Understanding Central Finance

LESSON OBJECTIVES

(89)

Unit 5

Lesson 2

Introducing Cash Management powered by

SAP HANA

LESSON OBJECTIVES

(90)

(91)

Unit 5

Exercise 12

Create New Bank Master Data

The Manage Banks app provides an overview of all the banks in the system. In this app, you can add new banks, contacts, and banking relationships to your database. Also provided is the functionality to create, display, change data for existing banks in company, for customers, and for suppliers.

In this exercise, replace ## with your participant ID

Note:

1. Create a bank and define the following common account properties:

Field Name Value Bank Country DE

Bank Key 987654## Bank Name Bank 987654##

(92)

Solution 12

Create New Bank Master Data

The Manage Banks app provides an overview of all the banks in the system. In this app, you can add new banks, contacts, and banking relationships to your database. Also provided is the functionality to create, display, change data for existing banks in company, for customers, and for suppliers.

In this exercise, replace ## with your participant ID

Note:

1. Create a bank and define the following common account properties:

Field Name Value Bank Country DE

Bank Key 987654## Bank Name Bank 987654##

a) In SAP Fiori, choose Bank Account Management → Manage Banks, and on the right down side of the screen, choose Create Bank.

b) In the General Data tab, define common account properties such as the bank country, bank key, bank name, as provided in the table.

c) Choose Save.

(93)

Unit 5

Exercise 13

Define Bank Master Data as House Bank

Note:

1. Define bank master data as House Bank using the following data:

Field Name Value

Company Code 1010

(94)

Solution 13

Define Bank Master Data as House Bank

Note:

1. Define bank master data as House Bank using the following data:

Field Name Value

Company Code 1010

House Bank T-B##

a) In SAP Fiori, choose Bank Account Management → Manage Banks.

b) On the Manage Bank screen, under Bank Type: My Banks, select the bank created previously (987654##), and choose Edit.

c) Under House Bank section, choose Add (+).

d) On the Create House Bank screen, enter the data provided in the table. e) Choose Save.

(95)

Unit 5

Exercise 14

Create New Bank Account Master Data

Note:

1. In the new bank account master data, define the following common account properties:

Field Name Value Opening Status Current Date Company Code 1010 Account Holder 1010 Bank Country DE Bank Key 987654## Currency EUR Account Number 111111##

Select IBAN button The proposed IBAN will be generated. Check and Save. Description Current Account EUR

(96)

Solution 14

Create New Bank Account Master Data

Note:

1. In the new bank account master data, define the following common account properties:

Field Name Value Opening Status Current Date Company Code 1010 Account Holder 1010 Bank Country DE Bank Key 987654## Currency EUR Account Number 111111##

Select IBAN button The proposed IBAN will be generated. Check and Save. Description Current Account EUR

Account Type 01 – Current Account

a) In SAP Fiori, choose Bank Account Management → Manage Bank Accounts. b) On the Active Accounts screen, choose New Bank Account.

c) In the General Data tab, define common account properties such as provided in the table.

d) Choose Save as Active.

(97)

Unit 5

Exercise 15

Maintain Connectivity Path

Note:

1. Maintain a connectivity path between the bank account and the corresponding house bank account. Enter the following bank account data:

Field Name Value

ID Category Central System: House Bank Account Company Code 1010 displayed by default

House Bank T-B## displayed by default

2. Enter the following data for the House Bank Account:

Field Name Value House Bank Account ID GIRO

Bank Account 111111## displayed by default GL Account 11001020

S4F01 Exercise

S4F01

Financial Accounting in SAP

S/4HANA

.

PARTICIPANT HANDBOOK

Contents

Course Overview

UNIT 1

Overview of Financials for SAP

S/4HANA

Lesson 1

Explaining the Purpose and Functions of SAP

HANA and SAP S/4HANA

Unit 1

Lesson 2

Describing the new Architecture of Accounting

Unit 1

Exercise 1

Display Financial Tables in the SAP HANA

Backend

Solution 1

Display Financial Tables in the SAP HANA

Backend

Lesson 3

Explaining the Purpose and Functions of SAP

Fiori

Unit 1

Exercise 2

Customize your Launchpad and Generate your

own Tiles

Unit 1

Solution 2

Customize your Launchpad and Generate your

own Tiles

Unit 1

Exercise 3

Post a Simple FI Document

Unit 1

Solution 3

Post a Simple FI Document

Unit 1

Lesson 4

Outlining the Migration of Financials to SAP S/

4HANA

UNIT 2

General Ledger Accounting

Lesson 1

Managing GL Accounts and Cost Elements in

SAP S/4HANA

Unit 2

Exercise 4

Create a primary account

Solution 4

Create a primary account

Unit 2

Exercise 5

Create a Business Partner

Unit 2

Solution 5

Create a Business Partner

Lesson 2

Managing Ledgers in SAP Accounting Powered

by SAP HANA

Unit 2

Exercise 6

Create an Extension Ledger and Post a

Document to it

Unit 2

Solution 6

Create an Extension Ledger and Post a

Document to it

UNIT 3

Asset Accounting

Lesson 1

Analyzing the Posting Logic of new Asset

Accounting

Unit 3

Exercise 7

Post Integrated Asset Acquisitions