SAP FI Module Tutorial
SAP FI ( Financial Accounting ) is one the functional module in SAP software.Company-wide control and integration of financial information is essential to strategic decision making, SAP ERP Financials enables you to centrally track financial accounting data within an international framework of multiple companies, languages, currencies, and charts of accounts.SAP FI module mainly deals withFixed asset
accrual
bank
cash journal
inventory
tax accounting
General ledger,
Accounts receivable
accounts payable
AR/AP,
Fast close functions
Financial statements
Parallel valuations
Master data governance.
SAP FI Consultants responsible for implementing Financial Accounting with SAP ERP Financials.
Important Tables in SAP FI & CO ( Controlling )
Its good to know about the important and frequently used tables in modules where we are working with.Here we are listing the tables in SAP FI & CO modules. List contains the table names with main field names and specific usage of that table.
TABLES IN SAP CONTROLLING
Table Name : AUSP
Table Purpose : Characteristic Values
Fields:
MANDT
OBJEK
ATINN
ATZHL
MAFID
KLART
ADZHL
CO-KBAS – Overhead Cost Controlling
Table Name : A132
Table Purpose : Price per CostCenter
Fields:
MANDT
KAPPL
KSCHL
KOKRS
VERSN
RESRC
KOSTL
DATBI
Table Name : A136
Table Purpose : Price per Controlling Area
Fields:
MANDT
KAPPL
KSCHL
KOKRS
VERSN
RESRC
DATBI
Table Name : A137
Table Purpose : Price per Country / Region
Fields:
MANDT
KAPPL
KSCHL
KOKRS
VERSN
RESRC
LAND1
REGIO
DATBI
Table Name : COSC
Table Purpose : CO Objects: Assignment of Original Costing Sheets
Fields:
MANDT
OBJNR
SCTYP
VERSN
GJAHR
Table Name : CSSK
Table Purpose : CostCenter / Cost Element
Fields:
MANDT
VERSN
KOKRS
GJAHR
KOSTL
KSTAR
Table Name : CSSL
Table Purpose : CostCenter / Activity Type
Fields:
MANDT
KOKRS
KOSTL
LSTAR
GJAHR
Table Name : KAPS
Table Purpose : CO Period Locks
Fields:
MANDT
KOKRS
GJAHR
VERSN
VRGNG
PERBL
CO-KBASCORE – Overhead Cost Controlling: General Services
Table Name : CSKA
Table Purpose : Cost Elements (Data Dependent on Chart of Accounts)
Fields:
MANDT
KTOPL
KSTAR
Table Name : CSKB
Table Purpose : Cost Elements (Data Dependent on Controlling Area)
Fields:
MANDT
KOKRS
KSTAR
DATBI
Table Name : CSKS
Table Purpose : CostCenter Master Data
Fields:
MANDT
KOKRS
KOSTL
DATBI
Table Name : CSLA
Table Purpose : Activity Master
Fields:
MANDT
KOKRS
LSTAR
DATBI
CO-OM (KACC) – Overhead Cost Controlling
Table Name : COBK
Table Purpose : CO Object: Document Header
Fields:
MANDT
KOKRS
BELNR
Table Name : COEJ
Table Purpose : CO Object: Line Items (by Fiscal Year)
Fields:
MANDT
KOKRS
BELNR
BUZEI
PERBL
Table Name : COEJL
Table Purpose : CO Object: Line Items for Activity Types (by Fiscal Yr)
Fields:
MANDT
KOKRS
BELNR
BUZEI
PERBL
Table Name : COEJR
Table Purpose : CO Object: Line Items for SKF (by Fiscal Year)
Fields:
MANDT
KOKRS
BELNR
BUZEI
PERBL
Table Name : COEJT
Table Purpose : CO Object: Line Items for Prices (by Fiscal Year)
Fields:
MANDT
KOKRS
BELNR
BUZEI
PERBL
Table Name : COEP
Table Purpose : CO Object: Line Items (by Period)
Fields:
MANDT
KOKRS
BELNR
BUZEI
Table Name : COEPL
Table Purpose : CO Object: Line Items for Activity Types (by Period)
Fields:
MANDT
KOKRS
BELNR
BUZEI
Table Name : COEPR
Table Purpose : CO Object: Line Items for SKF (by Period)
Fields:
MANDT
KOKRS
BELNR
BUZEI
Table Name : COEPT
Table Purpose : CO Object: Line Items for Prices (by Period)
Fields:
MANDT
KOKRS
BELNR
BUZEI
Table Name : COKA
Table Purpose : CO Object: Control Data for Cost Elements
Fields:
MANDT
OBJNR
GJAHR
KSTAR
HRKFT
Table Name : COKL
Table Purpose : CO Object: Control Data for Activity Types
Fields:
MANDT
LEDNR
OBJNR
GJAHR
VERSN
Table Name : COKP
Table Purpose : CO Object: Control Data for Primary Planning
Fields:
MANDT
LEDNR
OBJNR
GJAHR
WRTTP
VERSN
KSTAR
HRKFT
VRGNG
VBUND
PARGB
BEKNZ
TWAER
Table Name : COKR
Table Purpose : CO Object: Control Data for Statistical Key Figures
Fields:
MANDT
LEDNR
OBJNR
GJAHR
WRTTP
VERSN
STAGR
HRKFT
VRGNG
Table Name : COKS
Table Purpose : CO Object: Control Data for Secondary Planning
Fields:
MANDT
LEDNR
OBJNR
GJAHR
WRTTP
VERSN
KSTAR
HRKFT
VRGNG
PAROB
USPOB
BEKNZ
TWAER
CO-OM-CEL (KKAL) – Cost Element Accounting (Reconciliation Ledger)
Table Name : COFI01
Table Purpose : Object Table for Reconciliation Ledger COFIT
Fields:
MANDT
OBJNR
Table Name : COFI02
Table Purpose : Transaction Dependent Fields for Reconciliation Ledger
Fields:
MANDT
OBJNR
Table Name : COFIP
Table Purpose : Single Plan Items for Reconciliation Ledger
Fields:
RCLNT
GL_SIRID
Table Name : COFIS
Table Purpose : Actual Line Items for Reconciliation Ledger
Fields:
RCLNT
GL_SIRID
CO-OM-CCA – Cost Center Accounting (Cost Accounting Planning RK-S) – What is RK-S
Table Name : A138
Table Purpose : Price per Company Code
Fields:
MANDT
KAPPL
KSCHL
KOKRS
VERSN
RESRC
BUKRS
GSBER
DATBI
Table Name : A139
Table Purpose : Price per ProfitCenter
Fields:
MANDT
KAPPL
KSCHL
KOKRS
VERSN
RESRC
PRCTR
DATBI
CO-OM-OPA(KABR) – Overhead Orders: Application Development R/3 Cost Accounting Settlement
Table Name : AUAA
Table Purpose : Settlement Document: Receiver Segment
Fields:
MANDT
BELNR
LFDNR
Table Name : AUAB
Table Purpose : Settlement Document: Distribution Rules
Fields:
MANDT
BELNR
BUREG
LFDNR
Table Name : AUAI
Table Purpose : Settlement Rules per Depreciation Area
Fields:
MANDT
BELNR
LFDNR
AFABE
Table Name : AUAK
Table Purpose : Document Header for Settlement
Fields:
MANDT
BELNR
Table Name : AUAO
Table Purpose : Document Segment: CO Objects to be Settled
Fields:
MANDT
BELNR
LFDNR
Table Name : AUAV
Table Purpose : Document Segment: Transactions
Fields:
MANDT
BELNR
LFDNR
Table Name : COBRA
Table Purpose : Settlement Rule for Order Settlement
Fields:
MANDT
OBJNR
Table Name : COBRB
Table Purpose : Distribution Rules Settlement Rule Order Settlement
Fields:
MANDT
OBJNR
BUREG
LFDNR
CO-OM-OPA(KAUF) – Overhead Orders: Cost Accounting Orders
Table Name : AUFK
Table Purpose : Order Master Data
Fields:
MANDT
AUFNR
Table Name : AUFLAY0
Table Purpose : Enttity Table: Order Layouts
Fields:
MANDT
LAYOUT
EC-PCA (KE1) – Profit Center Accounting
Table Name : CEPC
Table Purpose : ProfitCenter Master Data Table
Fields:
MANDT
PRCTR
DATBI
KOKRS
Table Name : CEPCT
Table Purpose : Texts for ProfitCenter Master Data
Fields:
MANDT
SPRAS
PRCTR
DATBI
KOKRS
Table Name : CEPC_BUKRS
Table Purpose : Assignment of ProfitCenter to a Company Code
Fields:
MANDT
KOKRS
PRCTR
BUKRS
Table Name : GLPCA
Table Purpose : EC-PCA: Actual Line Items
Fields:
RCLNT
GL_SIRID
Table Name : GLPCC
Table Purpose : EC-PCA: Transaction Attributes
Fields:
MANDT
OBJNR
Table Name : GLPCO
Table Purpose : EC-PCA: Object Table for Account Assignment Element
Fields:
MANDT
OBJNR
Table Name : GLPCP
Table Purpose : EC-PCA: Plan Line Items
Fields:
RCLNT
GL_SIRID
EC-PCA BS (KE1C) – PCA Basic Settings: Customizing for Profit Center Accounting
Table Name : A141
Table Purpose : Dependent on Material and ReceiverProfitCenter
Fields:
MANDT
KAPPL
KSCHL
KOKRS
WERKS
MATNR
PPRCTR
DATBI
Table Name : A142
Table Purpose : Dependent on Material
Fields:
MANDT
KAPPL
KSCHL
WERKS
MATNR
DATBI
Table Name : A143
Table Purpose : Dependent on Material Group
Fields:
MANDT
KAPPL
KSCHL
WERKS
MATKL
DATBI
SAP FI Transaction code list
This documentation covers the detail list of transaction codes used in SAP FI module.Tcodes are the shortcut keys to access the reports / functions quickly. Each transaction is listed with the functionality here.
F-01 Enter Sample Document
F-02 Enter G/L Account Posting
F-03 Clear G/L Account
F-04 Post with Clearing
F-05 Post Foreign Currency Valuation
F-06 Post Incoming Payments
F-07 Post Outgoing Payments
F-18 Payment with Printout
F-19 Reverse Statistical Posting
F-20 Reverse Bill Liability
F-21 Enter Transfer Posting
F-22 Enter Customer Invoice
F-23 Return Bill of Exchange Pmt Request
F-25 Reverse Check/Bill of Exch.
F-26 Incoming Payments Fast Entry
F-27 Enter Customer Credit Memo
F-28 Post Incoming Payments
F-29 Post Customer Down Payment
F-30 Post with Clearing
F-31 Post Outgoing Payments
F-32 Clear Customer
F-33 Post Bill of Exchange Usage
F-34 Post Collection
F-35 Post Forfaiting
F-36 Bill of Exchange Payment
F-37 Customer Down Payment Request
F-38 Enter Statistical Posting
F-39 Clear Customer Down Payment
F-40 Bill of Exchange Payment
F-41 Enter Vendor Credit Memo
F-42 Enter Transfer Posting
F-43 Enter Vendor Invoice
F-44 Clear Vendor
F-46 Reverse Refinancing Acceptance
F-47 Down Payment Request
F-48 Post Vendor Down Payment
F-49 Customer Noted Item
F-51 Post with Clearing
F-52 Post Incoming Payments
F-53 Post Outgoing Payments
F-54 Clear Vendor Down Payment
F-55 Enter Statistical Posting
F-56 Reverse Statistical Posting
F-57 Vendor Noted Item
F-58 Payment with Printout
F-59 Payment Request
F-60 Maintain Table: Posting Periods
F-62 Maintain Table: Exchange Rates
F-63 Park Vendor Invoice
F-64 Park Customer Invoice
F-65 Preliminary Posting
F-66 Park Vendor Credit Memo
F-67 Park Customer Credit Memo
F-90 Acquisition from purchase w. vendor
F-91 Asset acquis. to clearing account
F-92 Asset Retire. frm Sale w/ Customer
F.01 ABAP/4 Report: Balance Sheet
F.02 Compact Journal
F.03 Reconciliation
F.04 G/L: Create Foreign Trade Report
F.05 Foreign Currency Val.: Open Items
F.06 Foreign Currency Valuation:G/L Assts
F.07 G/L: Balance Carried Forward
F.08 G/L: Account Balances
F.09 G/L: Account List
F.0A G/L: FTR Report on Disk
F.0B G/L: Create Z2 to Z4
F.10 G/L: Chart of Accounts
F.11 G/L: General Ledger from Doc.File
F.12 Advance Tax Return
F.13 ABAP/4 Report: Automatic Clearing
F.14 ABAP/4 Report: Recurring Entries
F.15 ABAP/4 Report: List Recurr.Entries
F.16 ABAP/4 Report: G/L Bal.Carried Fwd
F.17 ABAP/4 Report: Cust.Bal.Confirmation
F.18 ABAP/4 Report: Vend.Bal.Confirmation
F.19 G/L: Goods/Invoice Received Clearing
F.1A Customer/Vendor Statistics
F.1B Head Office and Branch Index
F.20 A/R: Account List
F.21 A/R: Open Items
F.22 A/R: Open Item Sorted List
F.23 A/R: Account Balances
F.24 A/R: Interest for Days Overdue
F.25 Bill of Exchange List
F.26 A/R: Balance Interest Calculation
F.27 A/R: Periodic Account Statements
F.28 Customers: Reset Credit Limit
F.29 A/R: Set Up Info System 1
F.2A Calc.cust.int.on arr.: Post (w/o OI)
F.2B Calc.cust.int.on arr.: Post(with OI)
F.2C Calc.cust.int.on arr.: w/o postings
F.2D Customrs: FI-SD mast.data comparison
F.2E Reconciliation Btwn Affiliated Comps
F.2F Management Acct Group Reconciliation
F.2G Create Account Group Reconcil. G/L
F.30 A/R: Evaluate Info System
F.31 Credit Management – Overview
F.32 Credit Management – Missing Data
F.33 Credit Management – Brief Overview
F.34 Credit Management – Mass Change
F.35 Credit Master Sheet
F.36 Adv.Ret.on Sls/Pur.Form Printout(DE)
F.37 Adv.rept.tx sls/purch.form print (BE
F.38 Transfer Posting of Deferred Tax
F.39 C FI Maint. table T042Z (BillExcTyp)
F.40 A/P: Account List
F.41 A/P: Open Items
F.42 A/P: Account Balances
F.44 A/P: Balance Interest Calculation
F.45 A/P: Set Up Info System 1
F.46 A/P: Evaluate Info System
F.47 Vendors: calc.of interest on arrears
F.48 Vendors: FI-MM mast.data comparison
F.4A Calc.vend.int.on arr.: Post (w/o OI)
F.4B Calc.vend.int.on arr.: Post(with OI)
F.4C Calc.vend.int.on arr.: w/o postings
F.50 G/L: Profitability Segment Adjustmnt
F.51 G/L: Open Items
F.52 G/L: Acct Bal.Interest Calculation
F.53 G/L: Account Assignment Manual
F.54 G/L: Structured Account Balances
F.56 Delete Recurring Document
F.57 G/L: Delete Sample Documents
F.58 OI Bal.Audit Trail: fr.Document File
F.59 Accum.Clas.Aud.Trail: Create Extract
F.5A Accum.Clas.Aud.Trail: Eval.Extract
F.5B Accum.OI Aud.Trail: Create Extract
F.5C Accum.OI Audit Trail: Display Extr.
F.5D G/L: Update Bal. Sheet Adjustment
F.5E G/L: Post Balance Sheet Adjustment
F.5F G/L: Balance Sheet Adjustment Log
F.5G G/L: Subseq.Adjustment(BA/PC) Sp.ErA
F.5I G/L: Adv.Rep.f.Tx on Sls/Purch.w.Jur
F.61 Correspondence: Print Requests
F.62 Correspondence: Print Int.Documents
F.63 Correspondence: Delete Requests
F.64 Correspondence: Maintain Requests
F.65 Correspondence: Print Letters (Cust)
F.66 Correspondence: Print Letters (Vend)
F.70 Bill/Exchange Pmnt Request Dunning
F.71 DME with Disk: B/Excha. Presentation
F.75 Extended Bill/Exchange Information
F.77 C FI Maintain Table T045D
F.78 C FI Maintain Table T045B
F.79 C FI Maintain Table T045G
F.80 Mass Reversal of Documents
F.81 Reverse Posting for Accr./Defer.Docs
F.90 C FI Maintain Table T045F
F.91 C FI Maintain Table T045L
F.92 C FI Maintain T012K (Bill/Exch.)
F.93 Maintain Bill Liability and Rem.Risk
F.97 General Ledger: Report Selection
F.98 Vendors: Report Selection
F.99 Customers: Report Selection
F/LA Create Pricing Report
F/LB Change pricing reports
F/LC Display pricing reports
F/LD Execute pricing reports
F00 SAPoffice: Short Message
F000 Accounting
F010 ABAP/4 Reporting: Fiscal Year Change
F01N Debit position RA single reversal
F01O Vacancy RU single reversal
F01P Accruals/deferrals single reversal
F01Q Debit position MC single reversal
F01R MC settlement single reversal
F01S Reverse Periodic Posting
F01T Reverse Acc./Def. General Contract
F040 Reorganization
F041 Bank Master Data Archiving
F042 G/L Accounts Archiving
F043 Customer Archiving
F044 Vendor Archiving
F045 Document Archiving
F046 Transaction Figures Archiving
F101 ABAP/4 Reporting: Balance Sheet Adj.
F103 ABAP/4 Reporting: Transfer Receivbls
F104 ABAP/4 Reporting: Receivbls Provisn
F107 FI Valuation Run
F110 Parameters for Automatic Payment
F111 Parameters for Payment of PRequest
F13E ABAP/4 Report: Automatic Clearing
F150 Dunning Run
F48A Document Archiving
F53A Archiving of G/L Accounts
F53V Management of G/L Account Archives
F56A Customer Archiving
F58A Archiving of Vendors
F61A Bank archiving
F64A Transaction Figure Archiving
F66A Archiving of Bank Data Storage
F8+0 Display FI Main Role Definition
F8+1 Maintain FI Main Role Definition
F8+2 Display FI Amount Groups
F8+3 Maintain FI Amount Groups
F8B4 C FI Maintain Table TBKDC
F8B6N C FI Maintain Table TBKPV
F8BC C FI Maintain Table TBKFK
F8BF C FI Maintain Table T042Y
F8BG Maintain Global Data for F111
F8BH Inconsistencies T042I and T042Y
F8BJ Maintain Clearing Accts (Rec.Bank)
F8BK Maintain ALE-Compatible Pmnt Methods
F8BM Maintain numb.range: Payment request
F8BN Corr.Acctg Documents Payment Block
F8BO Payment request archiving
F8BR Levels for Payment Requests
F8BS Detail display of payment requests
F8BT Display Payment Requests
F8BU Create payment runs automatically
F8BV Reversal of Bank-to-Bank Transfers
F8BW Reset Cleared Items: Payt Requests
F8BZ F111 Customizing
F8XX Payment Request No. Ranges KI3-F8BM
FA39 Call up report with report variant
FAKA Config.: Show Display Format
FAKP Config.: Maintain Display Format
FAR1 S FI-ARI Maint. table T061A
FARA S FI-ARI Maint. table T061P/Q
FARB C FI-ARI Maint. table T061R
FARI AR Interface: Third-party applicatns
FARY Table T061S
FARZ Table T061V
FAX1 BC sample SAP DE 2.1
FAX2 BC sample 2 SAP DE 2.1