There are few financial tables FAGLFLEXT, GLTO, COSS, ACDOCA, BSEG, and FAGLFLEXA that you’ll access in SAP Simple Finance system. To display financial tables, use Transaction Code – SE16n.

Step 1 − Login to SAP system and enter Transaction SE16n in Transaction box → Press ENTER key.

Step 2 − Within the next window, enter FAGLFLEXT within the Table field and press ENTER key to confirm your entry.

Step 3 − To ascertain the output of the table, navigate to Table Display → Execute → Online.

Step 4 − The classic General Ledger Totals table is now a HANA generated view table. To view, Enter the table name BSIS and press the ENTER key.

Step 5 − Enter the table name and navigate to Table Display → Execute → Online.

Step 6 − To ascertain index tables, which are now HANA generated view table, enter the table name COSS and press ENTER key.

Step 7 − To ascertain CO totals tables, which are now also HANA generated view table, enter the table name ACDOCA and press the ENTER key.

Step 8 − To ascertain the huge amount of fields from all other applications, including the custom fields added to the coding block, press F7 button.

You’ll check the approximate line items within the Universal Journal Table. These are mostly a direct result from the migration to Simple Finance.

View BSEG table that has much fewer entries when compared to ACDOCA. This is to be expected as CO line items, Asset Accounting, and Ledger information amongst others is not held within the table.

Step 9 − To look at faglflexa table, enter the table name FLAGFLEXA within the table box and confirm the entry by pressing the ENTER key. Point to note here is that you’ll ascertain the new g/l line items table due to extra characteristics (such as the ledger) and document splitting has many more entries than BSEG.

You’ll also take an extract of the table within the background, or create an extract within the background.

Step 10 − Move to Information (CoCd) Wb to select it. Click the Save button.

l10

So, this brings us to the end of blog. This Tecklearn ‘How to Display Financial Tables in SAP Simple Finance’ blog helps you with commonly asked questions if you are looking out for a job in SAP S4 Simple Finance and SAP Domain. If you wish to learn SAP S4 Simple Finance and build a career in SAP domain, then check out our interactive, SAP S4 HANA Simple Finance Training, that comes with 24*7 support to guide you throughout your learning period. Please find the link for course details:

https://www.tecklearn.com/course/sap-s4-hana-simple-finance-training-and-certification/

SAP S4 HANA Simple Finance Training

About the Course

This SAP S4 Simple Finance 1909 and SAP FICO training course, you will learn various aspects of financial planning, accounting management, and enterprise risk. As part of this training, you will also learn SAP Fiori to work with real-time analytics, prediction, and simulation for all financial and operational data through hands-on projects. SAP S4 HANA Central Finance allows you to establish a Central Reporting Platform for FICO with the option of creating a common reporting structure. Additionally, selected financial processes can be executed centrally in this system. To prepare common reporting structures, you can map your different accounting entities (for example, account, profit centre, or cost centre) in your source systems to one common set of master data in the central system. You can then replicate Financial Accounting and Management Accounting postings to your Central Finance system.

Why Should you take SAP S4 HANA Finance Training?

The average salary of an entry-level SAP FICO Consultant in the US is about $83,974 per annum. Based on experience, this salary might rise to $118,000 per annum.
Global demand for this role is growing, and everyone who has obtained the industry-recognized FICO certification can immediately find a great job!
Worldwide Business Intelligence and Analytics Market to grow to $22.8 billion in next 2 years – Gartner.

What you will Learn in this Course?

Overview of SAP HANA

Basic HANA introduction
SAP’s Big thing
SAP Fi, SAP CO, SAP BW, SAP APO
SAP S4 Hana next generation business suite
On Premise edition and Cloud edition
S4 HANA simplifier of enterprise software
Functional scope
Roadmap
SAP Hana History
ECC and ERP Concepts
Profitability
SAP COPA
Different types of tables
MATDOC
Green Field Implementation
Transformation of SAP to different Version of HANA

SAP Hana Implementation and Finance Concepts

Customer Program
Quota Management
FIORI
Rationalization
Profit Center
IOT
ECC
New GL Concept
SAP Vs SAP Fi
WorkCenter and RECIPE
Column Based reading
Company Code
Production Order
Cost of Activity
Cost of Production

General Ledger Accounting and Master Data

Material Document
Kinds of Data
Master data and transaction
Sub ledger
ACDOCA
FIORI App
ECC V/s HANA
Rationalization

Integrated Business Processes

General Table Display
Document number, Company Code, Fiscal Year
Asset Accounting
Cost Center
Cost element
Profitability segment
Sales and Distribution
Type of accounting
Central finance
Credit Control area

Organization Structure

Creation of new company codes
Defining business area
Functional area
IFRS
Profit Center
Product hierarchy
Profit center finalization and profit center dissension
Financial accounting organizational structure
Group Currency

CO (Controlling)

Controlling organisation structure
Current and valuation profile
Controlling area
Operating Concern
Financial accounting global setting
Ledgers
Currency Types
Legal View

Concepts of General Ledger Accounting Continued

Fiscal year
Shortened fiscal year
Purchase to pay
Order to cash
Goods receipts
Invoice

Master Data Management and Migration

Upgrade and migrate
S4 HANA component
Deployment of SAP HANA
SAP HANA Database migration
Replicate to central finance
Fiori
Simplified data model in finance
Avoid redundancy
Data footprint

Management Accounting and CO-PA

Account before simple finance
Finance implication
COPA revenue
COPA cost
Revenue
The new architecture with simple finance
Cost element
Simple IT with SAP simple finance architecture
GL account and cost element details

Material Ledger and Centralized Master Data for GL

Material ledger
Prima Nota in simple finance
Mr21 and Mr22
Multi-dimensional income statement
Merge of account
GL Account
Customer account
System work through
Header table
Transaction code and parameter
TSRC table
FI/CO document
Variant related program
Difference between Tcode and program

Financials for SAP S4 Hana

Tax in SAP
Direct and Indirect Tax
Account
Document Type in SAP Fi
Posting Key
Purchase order
Checking controlling area and company code object

SAP Product Costing

Cost objects
Cost Management & Profitability Analysis
Checking scrapping document
What is scrapping means

Materials Management

Material Vs Asset
Receipts and consumption
Material price analysis
Two type of consumption
Cost center
Material price analysis
Changing cost components splits of a material

Functionalities in New Asset Accounting

SAP Hana Implementation
G/L Account
Cost Object
Revenue collector
Asset accounting
HANA road map
Standard optimized transaction
Service order
Consignment
Fault part return
Accrual Management
What is underlined process
How finance support other modules
Positive post to order and negative post to order
Go-live and post migration activities
KPI with HANA
Monitor business performance
Accrual entry
Pricing procedure
Expense and revenue account

Finance process improvement

Over absorption and under absorption
Types of cycle
SAP treasury and risk management
Functional changes in HANA

Migration to SAP S4HANA Finance and General Ledger Accounting Continued

Project system
Data archiving
Profit center
Reconciliation issue
Migration to S4 Hana
Enablement of SAP S4 Hana
Implementing new G/L
Document Splitting
Parallel accounting

SAP Central Finance on S4 Hana

Replication to central finance
Non ECC system
Central finance mapping
Type of deployment

S4 Hana project phases

Preparation phase
Feasibility check
Check Size
Active business function
Parallel valuation
Depreciation calculation
Consistency check
Customizing
Data migration
Post migration
Testing
Preparation phase
Important SAP notes
Scope – ABAP
Active business function
FI consistency check

Reconciliation Process in SAP Hana

Reconciliation of general ledger and account payable
Reconciliation of the general ledger with materials management
Reconciliation of the ledgers
Ledger Comparison
Consistency check
Migration of general ledger settings
Defining setting for the journal entry ledger

Other Key Topics

Document types for Co
Real time reconciliation
Execute consistency check of general ledger setting
Data migration
Universal journal entry table
Management accounting
Migrate secondary cost elements to the card of accounts
Migration of cost elements to G/L account
Automatic account determination

Material Valuation in SAP Hana

Automatic determination of the account
Material valuation
Migrate default account assignments

Customizing Financials in SAP S/4HANA

Reconcile transnational data
Types of reconcile
Enrichment of data
Migration of line items into new data structure
Universal journal entry structure

Got a question for us? Please mention it in the comments section and we will get back to you.

554