Configuring Group Reporting With S/4 Hana 1909.

 

CONFIGURING GROUP REPORTING WITH S/4 HANA  1909.

    With S/4 HANA Finance 1809, SAP has introduced group reporting, a SAP’s consolidation solution. Group reporting’s innovations expose the new consolidation solution, which is a hybrid of SAP’s EC-CS, BCS and BPC functionalities. You’ve heard about Universal Journal, single source of truth, real-time processes, and UI improvements, in group reporting, you can leverage all these functionalities without additional acquisition of the software cost. SAP group reporting facilitates continuous accounting and consolidation in a single instance, thus reduces the financial closing manhours. With the tight integration of ACDOCA table and flexible upload functionalities help smooth transition of consolidation unit’s local data to consolidation data for financial consolidation. With the S/4 HANA 1909 release, SAP enhanced group reporting functionalities with new fiori tiles.

Configuring Group Reporting with S/4 HANA 1909 covers end to end solution with one complete consolidation of financial statements of integrated and non-integrated units. Highlights of Configuring Group Reporting with S/4 HANA 1909 ● Consolidation chart of account ● Integration of consolidation units and consolidation group ● Local and global accounting ● Currency translation, ● Interunit / intercompany eliminations ● Reclassification ● Elimination and adjustment of intercompany investment•Calculation of goodwill ● Calculation of minority interest, ● SAP Fiori Apps 

Content of the Book  Table of Contents PURPOSE

9

Audience of this Book

10

Structure of This Book

10

Chapter - 1Group Reporting Overview

11

Section 1.1Key Terms

20

1)Consolidation Ledger

20

2)Breakdown categories (BDC)

20

3)FS Items

21

4)FS Items vs GL accounts:

22

5)Statistical FS Items

22

6)Validation Methods

22

7)Reconciliation Case

23

8)Accounting Techniques

23

9)First consolidation

23

10)Sub-Items:

24

11)Transaction Types

25

12)Functional Areas

26

13)Consolidation unit

27

14)Posting Level

27

15)Document Type

28

16)Partner Unit

29

17)Financial Statement Items Hierarchies:

29

18)Version

29

19)Consolidation Group

29

20)Selection

30

21)Dimension

30

22)Purchase Method:

31

23)Equity Method:

31

24)Consolidation frequency:

32

25)Selection Attributes

32

26)Target Attributes:

32

Section 1.2Data Model

33

Section 1.3Limitation

34

Section 1.4Key Questions

35

Section 1.5Group Reporting Templates

36

Chapter - 2Configuration

37

Section 2.1Business Case

37

Section 2.2Global System Setting

41

Section 2.3Consolidation Ledger:

44

Section 2.4Consolidation Version:

45

1.Create Version from Reference Version

45

2.Define Versions

46

Section 2.5Consolidation Units:

49

1.Create company

49

2.Create company code

50

3.Assign the company code to company

51

4.Additional ERP configuration

52

5.Define Consolidation Master Data Fields

52

6.Maintain Global Parameter

53

7.Maintain Organizational Unit

54

8.Maintain Consolidation Group

63

9.Assign Consolidation Units to Consolidation Group

66

Section 2.6Consolidation Chart of account:

72

1.Define Sub-item Categories and Sub-items

72

2.Define Breakdown Categories

75

3.Define Default Values for Sub-assignments

77

4.Define Consolidation Chart of Accounts

78

5.Define FS Item Attribute Values

82

6.Specify Selected FS Items for Automatic Posting

84

7.Specify FS Items to be Carried Forward

87

8.Specify Account Numbers to be Carried Forward

89

Section 2.7Posting Control

89

1.Display Dimension

90

2.Edit Number Range Intervals for Posting

90

3.Define Document Types

91

4.Define Document Types for Reported Financial Data

94

5.Define Document Types for Manual Posting in Data Monitor

96

6.​Define Document Types for Reclassification in Data Monitor

98

7.Define Document Types for Manual Posting in Consolidation Monitor

99

8.Define Document Types for Reclassification in Consolidation Monitor

100

9.Define Method for Uploading Reported Financial Data

101

10.Define Period Categories

105

11.Specify Translation Ratios

105

12.Maintain Exchange Rates

106

13.Define Exchange Rate Indicators

107

14.Determine System Utilization for C/I

109

15.Define Task

111

16.Define Tasks for Manual Posting

113

17.Define Currency Translation Methods

115

18.Define Reclassification Methods

117

19.Define Reclassification Tasks

125

20.Define Methods

127

21.Define Task Group

128

22.Assign Task Group to Dimension

131

23.Specify Miscellaneous Selected Items

132

24.Define Number Range for Archiving

135

25.Maintain Log Archiving Settings for Tasks

136

26.Map Logical Port with Business System for Reported Data API

136

Chapter - 3Operation

138

Section 3.1Set Global Parameter

138

Section 3.2Update Master Data

140

1.Create Consolidation Hierarchy

140

2.Import FS Item Mapping

144

3.MAP FS Items with G/L Accounts

147

4.Assign FS Item mapping

150

5.Consistency checks of Accounting Integration

152

6.Define FS Item

155

Section 3.3Maintain Exchange Rate 1.Maintain exchange rates Section 3.4Post Transaction 1.Create a FB50 Posting in H100

157 157 159 159

Section 3.5Local Close

163

1.Data Monitor

164

2.Opening of Posting Period

168

3.The balance carries forward

169

4.Transfer / Upload Transactional Data

171

5.Validation of Universal Journal

187

6.Calculate Net Income

188

7.Reported Data Validation

190

8.Manual Posting

198

9.Foreign Currency Translation

200

10.Standardized Data Validation

215

Section 3.6Consolidation Data Preparation

216

1.IC Elim. Sales

218

2.IC Elim. Other Income/Expense

223

3.Dividends Elimination

227

4.IC Elim. Balance Sheet

230

5.Manual Eliminations (PL20)

233

6.Calculate Group Shares (PL 30)

235

7.Enter Group Shares (PL30)

236

8.Investments / Equity Elimination

241

9.Manual Eliminations (PL30)

287

10.Total Divestiture 11.Consolidated Data Validation Chapter - 4Miscellaneous

288 290 291

Section 4.1Intercompany Matching and Reconciliation

291

Section 4.2Consolidation of Investments (Activity-Based)

292

Section 4.3Use of SAP Fiori Apps

293

Section 4.4Configuration of SAP Fiori APP

300

Section 4.5Group Reporting Fiori Apps

303

Section 4.6References

304

 

Want to know More  Visit My WebSite- ​http://sap.suryapadhi.com/group-reporting   

Want to Purchase a Book.  ● Amazon - India   https://www.amazon.in/CONFIGURING-GROUP-REPORTING-HANA-1909-ebook/dp/B08BS38GZ C/ref=sr_1_1?dchild=1&keywords=surya+padhi&qid=1593791183&sr=8-1  ● Amazon - USA  https://www.amazon.com/CONFIGURING-GROUP-REPORTING-HANA-1909/dp/0578667231/ref= tmm_pap_swatch_0?_encoding=UTF8&qid=1593788323&sr=8-1