Skip to Content
author's profile photo Former Member
Former Member

FI

ABAP GURU'S

1-WHAT ARE THE TABLES IN FI MODULE. PROVIDE THE LIST OF FI TABLES.

2- HOW I CAN SEE THE TABLES OF MI MODULE IN SAP?.

PLZ GIVE REPLY IMMEDEIATLY.

THANKS

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Posted on Apr 13, 2008 at 09:46 AM

    The main tables are BKPF and BSEG.

    See also: http://www.erpgenie.com/abap/tables_fi.htm.

    You can see these tables with tcode SE16.

    Regards,

    Bert

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 13, 2008 at 12:27 PM

    hi,

    hi use this link..

    http://www.erpgenie.com/abap/tables_fi.htm

    FI TABLES:

    AGKO Cleared Accounts

    ANAR Asset Types

    ANAT Asset type text

    ANEK Document Header Asset Posting

    ANEP Asset Line Items

    ANEV Asset downpymt settlement

    ANKT Asset classes- Description

    ANLA Asset Master Record Segment

    ANLB Depreciation terms

    ANLC Asset Value Fields

    ANLH Main asset number

    AT02T Transaction Activity Category- Description

    AT02A Transaction Code for Menu TIMN

    AT10 Transaction type

    AT10T Name of Transaction Type

    BKDF Document Header Supplement for Recurring Entry

    BKORM Accounting Correspondence Requests

    BKPF Accounting Document Header

    BLPK Document log header

    BLPP Document log item

    BLPR Document Log Index and Planned Order (Backflush)

    BNKA Bank master record

    BP000 Business Partner Master (General Data)

    BPBK Doc.Header Controlling Obj.

    BPEG Line Item Total Values Controlling Obj.

    BPEJ Line Item Annual Values Controlling Obj.

    BPEP Line Item Period Values Controlling Obj.

    BPGE Totals Record for Total Value Controlling obj.

    BPJA Totals Record for Annual Total Controlling Obj.

    BSAD Accounting- Secondary Index for Customers (Cleared Items)

    BSAK Accounting- Secondary Index for Vendors (Cleared Items)

    BSAS Accounting- Secondary Index for G/L Accounts (Cleared Items)

    BSEC One-Time Account Data Document Segment

    BSEG Accounting Document Segment

    BSID Accounting- Secondary Index for Customers

    BSIK Accounting- Secondary Index for Vendors

    BSIM Secondary Index, Documents for Material

    BSIS Accounting- Secondary Index for G/L Accounts

    CEPC Profit Center Master Data Table

    CEPCT Texts for Profit Center Master Data

    COBRA Settlement Rule for Order Settlement

    COBRB Distribution Rules Settlement Rule Order Settlement

    COKA CO Object- Control Data for Cost Elements

    COSP CO Object- Cost Totals for External Postings

    COSS CO Object- Cost Totals for Internal Postings

    CRCO Assignment of Work Center to Cost Center

    CSKA Cost Elements (Data Dependent on Chart of Accounts)

    CSKB Cost Elements (Data Dependent on Controlling Area)

    CSLA Activity master

    FEBEP Electronic Bank Statement Line Items

    FPLA Billing Plan

    FPLT Billing Plan- Dates

    GLPCT EC-PCA- Totals Table

    KNA1 General Data in Customer Master

    KOMK Pricing Communication Header

    MAHNV Management Records for the Dunning Program

    REGUT TemSe - Administration Data

    SKA1 G/L Account Master (Chart of Accounts)

    SKAT G/L Account Master Record (Chart of Accounts- Description)

    SKB1 G/L account master (company code)

    T003T Document Type Texts

    T007S Tax Code Names

    T087J Text

    TAPRFT Text tab. for investment profile

    TKA01 Controlling Areas

    TKA09 Basic Settings for Versions

    TKVS CO Versions

    TZB0T Flow types text table

    TZPAT Financial Assets Management product type texts

    VBSEGS Document Segment for G/L Accounts Document Parking

    VTBFHA Transaction

    VTBFHAPO Transaction Flow

    VTBFHAZU Transaction Activity

    VTBFINKO Transaction Condition

    VTIDERI Master Data Listed Options and Futures

    VTIFHA Underlying transaction

    VTIFHAPO Underlying transaction flows

    VTIFHAZU Underlying transaction status table

    VTIOF Options Additional Data

    VWPANLA Asset master for securities

    -


    Follow this link for modul ewise tables.

    http://www.erpgenie.com/abap/tables.htm

    All tables are stored in DD02L table and DD02T table is having the description text of the table

    OR

    Go to se11 there in the database field click on F4 and then click the button SAP Applications, then all the database tables module wise will be displayed.

    check this link

    http://sap-img.com/general/sap-r3-tables.htm

    Hope it helps u..

    Regards,

    KK

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 13, 2008 at 03:13 PM

    Hi,

    Very frequently used FI tables are as below:

    BSIS : GL Open Items

    BSAS : GL Closed Items

    BSID : Customer Open Items

    BSAD : Customer Closed Items

    BSIK: Vendor Open Items

    BSAK: Vendor Closed Items

    BKPF : Document Header

    BSEG : Document Segment

    Thanks,

    Sriram Ponna.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 04, 2008 at 10:04 AM

    Important Tables in SAP FI

    Financial Accounting

    Table Name Description Important Fields

    Financial Accounting

    FBAS Financial Accounting u201CBasisu201D

    BKPF Accounting Document Header BUKRS / BELNR / GJAHR

    BSEG Accounting Document Segment BUKRS / BELNR / GJAHR / BUZEI

    BSIP Index for Vendor Validation of Double BUKRS / LIFNR / WAERS / BLDAT /

    Documents XBLNR / WRBTR / BELNR / GJAHR / BUZEI

    BVOR Inter Company Posting Procedure BVORG / BUKRS / GJAHR / BELNR

    EBKPF Accounting Document Header (docs from GLSBK / BELNR / GJHAR / GLEBK

    External Systems)

    FRUN Run Date of a Program PRGID

    KLPA Customer / Vendor Linking NKULI / NBUKR / NKOAR / PNTYP

    / VKULI / VBUKR / VKOAR

    KNB4 Customer Payment History KUNNR / BUKRS

    KNB5 Customer Master Dunning Data KUNNR / BUKRS / MABER

    KNBK Customer Master Bank Details KUNNR / BANKS / BANKL / BANKN

    KNC1 Customer Master Transaction Figures KUNNR / BUKRS / GJHAR

    KNC3 Customer Master Special GL Transactions KUNNR / BUKRS / GJAHR / SHBKZ

    Figures

    LFB5 Vendor Master Dunning Data LIFNR / BUKRS / MABER

    LFBK Vendor Master Bank Details LIFNR / BANKS / BANKL / BANKN

    LFC1 Vendor Master Transaction Figures LIFNR / BUKRS / GJHAR

    LFC3 Vendor Master Special GL Transactions LIFNR / BUKRS / GJHAR / SHBKZ

    Figures

    VBKPF Document Header for Document Parking AUSBK / BUKRS / BELNR / GJHAR

    FBASCORE Financial Accounting General Services u201CBasisu201D

    KNB1 Customer Master (Company Code) KUNNR / BUKRS

    LFA1 Vendor Master (General Section) LIFNR

    LFB1 Vendor Master (company Code Section) LIFNR / BUKRS

    SKA1 G/L Account Master (Chart of Accounts) KTOPL / SAKNR

    SKAT G/L Account Master (Chart of Accounts u2013 SPRAS / KTOPL / SAKNR

    Description)

    MAHNS Accounts Blocked by Dunning Selection KOART / BUKRS / KONKO / MABER

    MHNK Dunning Data (Account Entries) LAUFD / LAUFI / KOART / BUKRS /

    KUNNR / LIFNR / CPDKY / SKNRZE /

    SMABER / SMAHSK / BUSAB

    FI-GL-GL (FBS) General Ledger Accounting: Basic Functions- G/L Accounts

    SKAS G/L Account Master (Chart of Accounts u2013 SPRAS / KTOPL / SAKNR / SCHLW

    Key Word list)

    SKB1 G/L Account Master (Company Code) BUKRS / SAKNR

    FI-GL-GL (FBSC) General Ledger Accounting: Basic

    Functions - R/3 Customizing for G/L Accounts

    FIGLREP Settings for G/L Posting Reports MANDT

    TSAKR Create G/L account with reference BUKRS / SAKNR

    FI-GL-GL (FFE) General Ledger Accounting: Basic

    Functions - Fast Data Entry

    KOMU Account Assignment Templates for G/L KMNAM / KMZEI

    Account items

    FI-AR-AR (FBD) Accounts Receivable: Basic Functions - Customers

    KNKA Customer Master Credit Management : KUNNR

    Central Data

    KNKK Customer Master Credit Management : KUNNR / KKBER

    Control Area Data

    KNKKF1 Credit Management : FI Status data LOGSYS / KUNNR / KKBER / REGUL

    RFRR Accounting Data u2013 A/R and A/P RELID / SRTFD / SRTF2

    Information System

    FI-BL-PT Bank Accounting: Payment (BFIBL_CHECK_D) Transactions u2013 General Sections

    PAYR Payment Medium File ZBUKR / HBKID / HKTID / RZAWE /

    CHECT

    PCEC Pre-numbered Check ZBUKR / HBKID / HKTID / STAPL

    FI-BL-PT-AP(FMZA)Bank Accounting: Payment Transactions u2013 Automatic Payments

    F111G Global Settings for Payment Program for MANDT

    Payment Requests

    FDZA Cash Management Line Items in Payment KEYNO

    Requests

    PAYRQ Payment Requests KEYNO

    What is the table name for G/L Master data, when we create centrally (T.Code - FS00)?

    As far as general ledger master data is concerned, the following tables are involved :

    Table name : SKB1 : G/L Account Master ( Company Code)

    Fields:

    BUKRS : Company Code

    SAKNR : G/L Account

    Table name : SKA1 : G/L Account Master ( Chart of Accounts )

    Fields:

    KTOPL : Char of Accounts

    SAKNR : G/L Account

    Table name : SKAT : G/L Account Master Record ( Chart of Accounts : Description )

    Fields:

    SPRAS : Language

    KTOPL : Char of Accounts

    SAKNR : G/L Account *-- Viji Balakrishnan

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 04, 2008 at 10:05 AM

    Important Tables in SAP FI

    Financial Accounting

    Table Name Description Important Fields

    Financial Accounting

    FBAS Financial Accounting u201CBasisu201D

    BKPF Accounting Document Header BUKRS / BELNR / GJAHR

    BSEG Accounting Document Segment BUKRS / BELNR / GJAHR / BUZEI

    BSIP Index for Vendor Validation of Double BUKRS / LIFNR / WAERS / BLDAT /

    Documents XBLNR / WRBTR / BELNR / GJAHR / BUZEI

    BVOR Inter Company Posting Procedure BVORG / BUKRS / GJAHR / BELNR

    EBKPF Accounting Document Header (docs from GLSBK / BELNR / GJHAR / GLEBK

    External Systems)

    FRUN Run Date of a Program PRGID

    KLPA Customer / Vendor Linking NKULI / NBUKR / NKOAR / PNTYP

    / VKULI / VBUKR / VKOAR

    KNB4 Customer Payment History KUNNR / BUKRS

    KNB5 Customer Master Dunning Data KUNNR / BUKRS / MABER

    KNBK Customer Master Bank Details KUNNR / BANKS / BANKL / BANKN

    KNC1 Customer Master Transaction Figures KUNNR / BUKRS / GJHAR

    KNC3 Customer Master Special GL Transactions KUNNR / BUKRS / GJAHR / SHBKZ

    Figures

    LFB5 Vendor Master Dunning Data LIFNR / BUKRS / MABER

    LFBK Vendor Master Bank Details LIFNR / BANKS / BANKL / BANKN

    LFC1 Vendor Master Transaction Figures LIFNR / BUKRS / GJHAR

    LFC3 Vendor Master Special GL Transactions LIFNR / BUKRS / GJHAR / SHBKZ

    Figures

    VBKPF Document Header for Document Parking AUSBK / BUKRS / BELNR / GJHAR

    FBASCORE Financial Accounting General Services u201CBasisu201D

    KNB1 Customer Master (Company Code) KUNNR / BUKRS

    LFA1 Vendor Master (General Section) LIFNR

    LFB1 Vendor Master (company Code Section) LIFNR / BUKRS

    SKA1 G/L Account Master (Chart of Accounts) KTOPL / SAKNR

    SKAT G/L Account Master (Chart of Accounts u2013 SPRAS / KTOPL / SAKNR

    Description)

    MAHNS Accounts Blocked by Dunning Selection KOART / BUKRS / KONKO / MABER

    MHNK Dunning Data (Account Entries) LAUFD / LAUFI / KOART / BUKRS /

    KUNNR / LIFNR / CPDKY / SKNRZE /

    SMABER / SMAHSK / BUSAB

    FI-GL-GL (FBS) General Ledger Accounting: Basic Functions- G/L Accounts

    SKAS G/L Account Master (Chart of Accounts u2013 SPRAS / KTOPL / SAKNR / SCHLW

    Key Word list)

    SKB1 G/L Account Master (Company Code) BUKRS / SAKNR

    FI-GL-GL (FBSC) General Ledger Accounting: Basic

    Functions - R/3 Customizing for G/L Accounts

    FIGLREP Settings for G/L Posting Reports MANDT

    TSAKR Create G/L account with reference BUKRS / SAKNR

    FI-GL-GL (FFE) General Ledger Accounting: Basic

    Functions - Fast Data Entry

    KOMU Account Assignment Templates for G/L KMNAM / KMZEI

    Account items

    FI-AR-AR (FBD) Accounts Receivable: Basic Functions - Customers

    KNKA Customer Master Credit Management : KUNNR

    Central Data

    KNKK Customer Master Credit Management : KUNNR / KKBER

    Control Area Data

    KNKKF1 Credit Management : FI Status data LOGSYS / KUNNR / KKBER / REGUL

    RFRR Accounting Data u2013 A/R and A/P RELID / SRTFD / SRTF2

    Information System

    FI-BL-PT Bank Accounting: Payment (BFIBL_CHECK_D) Transactions u2013 General Sections

    PAYR Payment Medium File ZBUKR / HBKID / HKTID / RZAWE /

    CHECT

    PCEC Pre-numbered Check ZBUKR / HBKID / HKTID / STAPL

    FI-BL-PT-AP(FMZA)Bank Accounting: Payment Transactions u2013 Automatic Payments

    F111G Global Settings for Payment Program for MANDT

    Payment Requests

    FDZA Cash Management Line Items in Payment KEYNO

    Requests

    PAYRQ Payment Requests KEYNO

    What is the table name for G/L Master data, when we create centrally (T.Code - FS00)?

    As far as general ledger master data is concerned, the following tables are involved :

    Table name : SKB1 : G/L Account Master ( Company Code)

    Fields:

    BUKRS : Company Code

    SAKNR : G/L Account

    Table name : SKA1 : G/L Account Master ( Chart of Accounts )

    Fields:

    KTOPL : Char of Accounts

    SAKNR : G/L Account

    Table name : SKAT : G/L Account Master Record ( Chart of Accounts : Description )

    Fields:

    SPRAS : Language

    KTOPL : Char of Accounts

    SAKNR : G/L Account *-- Viji Balakrishnan

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.