cancel
Showing results for 
Search instead for 
Did you mean: 

FICO Tables

Former Member
0 Kudos

What are the important table names in SAP FICO from interview point of view ?

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos
andreas_mann3
Active Contributor
0 Kudos

Hi,

or look device class (package) FBAS with SE80

A.

Former Member
0 Kudos

Hi

please check this too

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

regards

Srinivas

Former Member
0 Kudos

Hi,

Master Data

LFB1 ( Vendor Company Code Data)

LFA1 ( Vendor General Data)

KNB1 ( Customer Company Code Data)

KNA1 (Customer General Data)

SKB1 ( GL Company Code Data)

SKA1 ( GL General Data)

FI

BSEG (Accounting Doc Line Item)

BKPF (Accounting Doc header)

BSIS(GL Open Item)

BSAS(GL Cleared Item)

BSIK(Vendor Open Item)

BSAK(Vendor Cleared Item)

BSAD(Customer Cleaerd Item)

BSID(Customer Open Item)

Pls provide points if found usefull

Thanks,

Praveen

Former Member
0 Kudos

thanks for ur answers but iam asking uses of tables not tables

can u tell me what is the use of tables in sap fico ,iam having tables

Former Member
0 Kudos

Hi,

FI/CO Tables:

BKPF Accounting Document Header

BSAD Accounting: Secondary Index for Customers

BSAK Accounting: Secondary Index for Vendors (C

BSAS Accounting: Secondary Index for G/L Accoun

BSAUTHORS Table of Authors

BSBM Document Valuation Fields

BSBMT Text for Valuation Adjustment or Deductibl

BSBOOK Bookshop - Table of Books

BSBW Document Valuation Fields

BSCATALOG Bookshop Catalog of All Available Books

BSCUSTOMER Bookshop Customers

BSEC One-Time Account Data Document Segment

BSED Bill of Exchange Fields Document Segment

BSEG Accounting Document Segment

BSEGC Document: Data on Payment Card Payments

BSEG_ADD Entry View of Accounting Document for Addi

BSES Document Control Data

BSET Tax Data Document Segment

BSE_CLR Additional Data for Document Segment: Clea

BSE_CLR_ASGMT Doc. Segment Add. Data: Clearing Info with

BSIA Archive Index for FI Documents (Outdated!

BSID Accounting: Secondary Index for Customers

BSIK Accounting: Secondary Index for Vendors

BSIM Secondary Index, Documents for Material

BSIP Index for Vendor Validation of Double Docu

BSIS Accounting: Secondary Index for G/L Accoun

BSIUDES BSI Default Destination

GL:

GLFLEXA Flexible general ledger: Actual line items

GLFLEXP Flexible G/L: Plan line items

GLFLEXT Flexible G/L: Totals

GLP0 Local Logical General Ledger Plan Line It

GLP1 Local Logical General Ledger Plan Line It

GLP2 Global Special Purpose Ledger Plan Line I

GLPCA EC-PCA: Actual Line Items

GLPCC EC-PCA: Transaction Attributes

GLPCO EC-PCA: Object Table for Account Assignme

GLPCP EC-PCA: Plan Line Items

GLPCT EC-PCA: Totals Table

GLPO1 Plan Line Items for Object Table

GLPO2 Plan Line Items for Object Table Global

GLPO3 Plan Line Items for Object Table

GLPPC Profit Center Accounting: Plan line items

GLS1 Local Logical General Ledger Actual Line I

GLS2 Global logical Consolidation line items

GLS2IDX Index table for FI-LC document cluster

GLSO1 FI-SL Line Item Table with Objects for GLT

GLSO2 FI-SL Table with Objects, Structure corres

GLSO3 FI-SL LI Table with Objects for GLTO3

GLSPC Profit Center Accounting: Line Items

GLT0 G/L account master record transaction figu

GLT1 Local General Ledger Summary Table

GLT2 Consolidation totals table

GLT3 Summary Data Preparations for Consolidatio

GLTO1 FI-SL Table with Objects, Structure Corres

GLTO2 FI-SL Table with Objects, Structure Corres

GLTO3 FISL Table with Objects, Amounts and Quant

GLTPC Profit Center Accounting

Costing:

CSKA Cost Elements (Data Dependent on Chart of

CSKB Cost Elements (Data Dependent on Controlli

CSKR Resource master record

CSKS Cost Center Master Data

CSKSTPL Template Assignment for Cost Centers

CSKT Cost Center Texts

CSKU Cost Element Texts

CSKV Resource texts

CSLA Activity master

CSLT Activity type texts

Vendor master:

LFA1 Vendor Master (General Section)

LFAS Vendor master (VAT registration numbers ge

LFAT Vendor master record (tax groupings)

LFB1 Vendor Master (Company Code)

LFB5 Vendor master (dunning data)

LFBK Vendor Master (Bank Details)

LFBW Vendor master record (withholding tax type

LFC1 Vendor master (transaction figures)

LFC3 Vendor master (special G/L transaction fig

LFCPR Function code profile per step

LFCTX Pushbutton text

LFEI Vendor Master: Preference for Import and E

LFINF Delivery information Project System

LFINFX Assignment delivery information to Project

LFLR Vendor Master Record: Supply Regions

LFM1 Vendor master record purchasing organizati

LFM2 Vendor Master Record: Purchasing Data

LFMC Vendor master (short texts for condition t

LFMH Vendor hierarchy

LFZA Permitted Alternative Payee

Customer Master:

KNA1 General Data in Customer Master

KNAS Customer master (VAT registration numbers

KNAT Customer Master Record (Tax Groupings)

KNB1 Customer Master (Company Code)

KNB4 Customer Payment History

KNB5 Customer master (dunning data)

KNBK Customer Master (Bank Details)

KNBW Customer master record (withholding tax ty

KNC1 Customer master (transaction figures)

KNC3 Customer master (special G/L transaction f

KNEA Assign Bank Details and Payment Methods to

KNEX Customer Master: Legal Control - Sanctione

KNKA Customer master credit management: Central

KNKK Customer master credit management: Control

KNKKF1 Credit Management: FI Status Data

KNKKF2 Credit Management: Open Items by Days in A

KNKO Assignment of Cost Est. Number to Config.

KNMT Customer-Material Info Record Data Table

KNMTK Customer-Material Info Record Header Table

KNOB Assignment of Cost Est. Number to Config.

KNVA Customer Master Loading Points

KNVD Customer master record sales request form

KNVH Customer Hierarchies

KNVI Customer Master Tax Indicator

KNVK Customer Master Contact Partner

KNVL Customer Master Licenses

KNVP Customer Master Partner Functions

KNVS Customer Master Shipping Data

KNVT Customer Master Record Texts for Sales

KNVV Customer Master Sales Data

KNZA Permitted Alternative Payer

Data is stored in Database Tables that would be displayed whenever you run reports. All the data is stored in database including customizing data, Master Data, Transaction Data etc.

You would need to store the data somewhere so that you can access it later. Hence, it is stored in Database Tables/Views.

Regards,

Naveen.