account balance table

[Former Member]

hi,

fs10n i can refer to table GLT0.

may i know fd10n and fx10n which table i can refer to?

thanks

[Former Member · Accepted solution]

Hi eliana ,

GLTO is for periodwise GL balance.

for line item :

FS10N : BSIS & BSAS

FD10N : BSID & BSAD

FK10N : BSIK & BSAK

regards

raj

[Former Member]

Hi,

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.

Reward point if it is useful to you.

Thanks & Regards,

nms