Visit the SAP Forum

Languages : English | Dutch | French | Portugese | Italian



INTERVIEW EBOOK
Get 30,000 Interview Questions & Answers in an eBook.

Interview Success Kit - Get Success in Job Interviews



Send your Resume to 6000 Companies
START YOUR WEBSITE
India's Best Web Hosting Company

Important Tables in SAP FI


Home »SAP Financial Modules »Important Tables in SAP FI


Important Tables in SAP FI

Financial Accounting

Table Name        Description                     Important Fields
Financial Accounting
FBAS  	Financial Accounting �Basis�
BKPF  	Accounting Document Header     BUKRS / BELNR / GJAHR
BSEG  	Accounting Document Segment    BUKRS / BELNR / GJAHR / BUZEI
BSIP  	Index for Vendor Validation    BUKRS / LIFNR / WAERS / BLDAT /
      	of Double

Documents XBLNR / WRBTR / BELNR / GJAHR / BUZEI BVOR Inter Company Posting BVORG / BUKRS / GJAHR / BELNR Procedure EBKPF Accounting Document Header GLSBK / BELNR / GJHAR / GLEBK (docs from 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 KUNNR / BUKRS / GJHAR Figures KNC3 Customer Master Special KUNNR / BUKRS / GJAHR / SHBKZ GL Transactions Figures LFB5 Vendor Master Dunning Data LIFNR / BUKRS / MABER LFBK Vendor Master Bank Details LIFNR / BANKS / BANKL / BANKN LFC1 Vendor Master Transaction LIFNR / BUKRS / GJHAR Figures LFC3 Vendor Master Special LIFNR / BUKRS / GJHAR / SHBKZ GL Transactions Figures VBKPF Document Header for AUSBK / BUKRS / BELNR / GJHAR Document Parking
FBASCORE         Financial Accounting General Services �Basis�
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 � SPRAS / KTOPL / SAKNR
      Description)
MAHNS Accounts Blocked by Dunning       KOART / BUKRS / KONKO / MABER
	Selection
MHNK  Dunning Data                 LAUFD / LAUFI / KOART / BUKRS /
      (Account Entries)            KUNNR / LIFNR / CPDKY / SKNRZE /
                                   SMABER / SMAHSK / BUSAB
FI-GL-GL (FBS)   General Ledger Accounting: Basic Functions- 
			G/L Accounts
SKAS  G/L Account Master        � SPRAS / KTOPL / SAKNR / SCHLW
      (Chart of Accounts 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 :         LOGSYS / KUNNR / KKBER / REGUL
	FI Status data 
RFRR     Accounting Data � A/R and A/P           RELID / SRTFD / SRTF2
         Information System
FI-BL-PT Bank Accounting: Payment (BFIBL_CHECK_D)  
		Transactions � 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 � 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

A D V E R T I S E M E N T

A D V E R T I S E M E N T

S A P - R E S O U R C E S


Get Free SAP Resources:

Are you looking for:
  • SAP Jobs
  • Free SAP eBooks
  • SAP Softwares
  • SAP Tutorials
  • ERP Implementation Examples
Enter Email Address:
(Enter your email address above and we will instantly send you the download link to you, when you confirm your email.)
Search SAP Resources:
discussionDiscussion Center
Discuss
Discuss

Query

Feedback
Yahoo Groups
Y! Group
Sirfdosti Groups
Sirfdosti
Contact Us
Contact
Sign in

User Name:
Password:
Forget password? | Register


INTERVIEW EBOOK

Get 30,000 Interview Questions & Answers in an eBook.

Interview Success Kit - Get Success in Job Interviews


Send your Resume to 6000 Companies

SAP Resources

  • SAP Articles
  • SAP Books
  • SAP Certifications
  • SAP Companies
  • SAP Study Materials
  • SAP Events
  • SAP Faqs
  • SAP Jobs
  • SAP Job Consultants
  • SAP Links
  • SAP News
  • SAP Sample Papers
  • SAP Interview Questions
  • SAP Training Institutes
  •  
    SAP Tutorial

  • Introduction
  • SAP History
  • SAP Facts
  • SAP Tables
  • SAP Function
  • SAP Report
  • Reasons To Use SAP
  • SAP Landscape
  • SAP Transaction Code
  • SAP Lotus Notes Integration
  • Business Connector and XML
  • Enterprise Release 4.7

  • SAP Training Institutes

  • SAP Training Institutes
  • Job Consultants Address
  • SAP Companies Address

  • Business Process Cycle

  • Analyze
  • Design
  • Implement
  • Operate
  • Optimize
  • Skills And Education

  • Logistics Module

  • Sales and Distribution
  • Quality Management
  • Materail Management
  • Plant Maintenance
  • Financial Modules (FI/CO)
  • Project system
  • Production Planning
  • Service Management

  • SAP NetWeaver

  • Introduction
  • Object Model
  • Interoperability
  • Creating Web Apps
  • Java Connector
  • Advantages & Conclusion
  • Life Cycle Management
  • Composite Application Framework

  • SAP Tools

  • SQL Trace Tool
  • SAP CRM
  • SAP SRM
  • SAP SCM
  • SAP ERP
  • SAP BW

  • SAP Modules

  • SAP FI Module
  • SAP CO Module

  • SAP Technical

  • SAP ITS Architecture
  • Financial Management
  • Manufacturing Planning and Execution
  • Customer Order Management
  • Lackbox Processing
  • SD and Financial Accounting Integration
  • SAP - HR (Human Resource)

  • SAP Miscellanous

  • Web Application Server(WAS)
  • Data Archiving
  • Mobile Engine
  • SAP Script
  • SAP Transactions
  • SAP Business Warehouse(BW)

  • SAP Reference

  • SAP Facts
  • SAP Tables
  • SAP Function
  • SAP Report
  • SAP Landscape

  • SAP Others

  • SAP Treasury
  • SAP Finance
  • SAP WAS
  • SAP Data Archiving
  • SAP ALE
  • SAP EDI
  • SAP Exchange
  • SAP X-APPS
  • SAP Applications Components
  • SAP Software
  • Dunning
  • SAP IDES
  • SAP Payroll Basics
  • SAP BASIS and Security Authorization
  • SAP Backup
  • SAP Router

  • ABAP Tutorials

  • Introduction
  • ABAP Transaction
  • ABAP Function
  • ABAP File Processing
  • ABAP Objects
  • ABAP Syntax
  • ABAP Queries
  • SAPMail Using ABAP
  • ABAP Programming Hints

  • SAP Projects & Codes

  • Finding the user-exits
  • Purchase Order Display
  • Batch Input
  • Dynamic Open SQL
  • Creating Extract Dataset
  • Reading database tables
  • Load table from a UNIX file
  • Create subscreen

  • SAP Resources

  • SAP Books
  • SAP Links

  • Interview Question



  • Common Interview Que.
  • ABAP Interview Que.
  • ERP Interview Que.
  • HR Interview Que.
  • MM Interview Que.
  • PP Interview Que.
  • ALE Interview Que.
  • EDI Interview Que.
  • Basis Interview Questions
  • SAP-SD Interview Questions
  • FI&CO Interview Questions
  • BW Interview Questions
  • CRM Interview Questions
  • Interview Questions

  • Careers at SAP

  • Careers in SAP (SAP Jobs)
  • Advertise
  •