SAP FICO FI-GL Dataflow

       

        
                                                                         

Master Data:

1.General Ledger Account Data Sources:

0GL_ACCOUNT_ATTR: account number attributes

0GL_ACCOUNT_TEXT: account number text

0GL_ACCOUNT_T011_HIER: G/L account number hierarchies

2.Company Code Data Source:

0COMP_CODE_ATTR: company code attributes

0COMP_CODE_TEXT: company code text

3.Business Area Data Sources:

0BUS_AREA_ATTR: business area attributes

0BUS_AREA_TEXT: business area text

FI-GL Transactional Data:

FI-GL Transaction codes:

F.01: Balance sheet

F.08: Account Balances

F.10: Chart of Accounts

FI-GL Tables:

BKPF: accounting document header

BSEG: accounting document segment

FAGLFLEXA: general ledger actual line item

FAGLFLEXP: general ledger plan line item

FI-GL Transactional Data Data sources:

0FI_GL_1: General ledger: Transaction figures

0FI_GL_2: General ledger:  transaction figures –cost of sales ledger

0FI_GL_4: General ledger:: line items with delta extraction

0FI_GL_6: GL sales figures via delta extraction

0FI_GL_7:Gl cost of sales ledger via delta extraction

0FI_GL_8:GL: Statistical key figures

0FI_GL_10: leading Ledger balances

0FI_GL_20: transaction figures

0FI_GL_21: cumulated balances

0FI_GL_40:GL acoounting: Line items

0FI_GL_50:GL: plan line items

FI-GL InfoCubes And DSO’s:

Object type    Technical name     Description

Info cube                   0FIGL_C01              GL Transaction figures 

Info cube                   0FIGL_C02              Cost of sales ledger: Transaction figures 

Info cube                   0FIGL_C10              GL (new) ledger Transaction figures 

Virtual Info cube       0FIGL_V10              General ledger (new): Financial statements 

DSO                          0FIGL_O10               General ledger (new): Transaction figures

DSO                          0FIGL_O14               General ledger Accounting (new): Line Items

FI-GL Data Flow Diagram:

Standard Queries in FI-GL:

Info Cube         Technical name       Description

0FIGL_C10            0FIGL_C10_Q0001     General ledger (new): balance display

0FIGL_C10            0FIGL_C10_Q0002     General ledger (new): balance-Cumulated, comparison with

                                                                                         Previous year

0FIGL_V10            0FIGL_V10_Q0001     Financial statements (new): Actual/actual comparison

0FIGL_V10            0FIGL_V10_Q0002     Financial key figures: overview

0FIGL_V10            0FIGL_V10_Q0003     Financial key figures: Details

0FIGL_R10            0FIGL_R10_Q0001     General ledger (new): balance Display, remote

0FIGL_R10            0FIGL_R10_Q0002     General ledger (new): balance- Cumulated, comparison with

                                                                                         Previous year