Answer / narayana

T001: Company Codes (BUKRS)
T880: Company Data(RCOMP,NAME1,CNTRY)
T001W: Plants (WERKS)
T001L: Storage Locations (LGORT)
T001K: Assign. Plant(Val.Area) to CC(BUKRS,BWKEY)
T002: Language Keys (SPRAS)
T003: FI Document Types (BLART)
T004: Chart of Accounts (KTOPL)
T005: Country Keys (LAND1)
T006: Basic Unit of Measurements (MSEHI)
T007A: Tax Keys (KALSM,MWSKZ)
T009: Fiscal Year Variants(PERIV)
T077s: Account Groups(GL Accounts)(KTOPL,KTOKS)
T010O: Posting Period Variants(OPVAR)
T010P: Posting Period Variants
Names(OPVAR,SPRAS,OPVTX)
T012: House Banks (BUKRS,HBKID,BANKS,BANKL)
T014: Credit Control Areas(KKBER,WAERS)
T247,T015M: Month Names(SPRAS,MNR,KTX)
TCURC: Currencies (WAERS)
TCURR,TCURT,TCURX: Currency related Tables
TKA01: Controlling Areas (KOKRS,BEZEI,KTOPL)
TKA02: Assignment of CC to CCA(BUKRS,KOKRS)
TBSL: Posting Keys (BSCHL,SHKZG,KOART)
TBSLT: Posting Key Texts (BSCHL,SPRAS,LTEXT)
SKA1: G/L Account Master (Chart of
Accounts)(KTOPL,SAKNR)
SKB1: G/L account master (Company code)(BUKRS,SAKNR)
SKAT: G/L Account Master-Description
(KTOPL,SAKNR,SPRAS,LTEXT)
KNBK: Customer master (bank details)
(KUNNR,BANKS,BANKL,BANKN)
LFBK: Vendor master (bank details)(LIFNR,BANKS,BANKL,BANKN)
BKPF: Accounting Doc.Header(BUKRS,GJAHR,BELNR,MONAT)
BSEG: Accounting Doc.Item (Cluster Table)
(BUKRS,GJAHR,BELNR,BUZEI)
BSIS: G/L Open Items
(BELNR,AUGBL,HKONT,BUZEI,BUKRS,ZUONR,GJAHR)
BSAS: G/L Closed Items
(BELNR,AUGBL,HKONT,BUZEI,BUKRS,GJAHR,ZUONR)
BSID: Customer Open Items(A/Receivables)
(BELNR,AUGBL,KUNNR,VBELN)
BSAD: Customer Closed Items(A/Receivables)
(BELNR,AUGBL,KUNNR,VBELN)
BSIK: Vendor Open Items(A/Payables)(BELNR,AUGBL,LIFNR,EBELN)
BSAK: Vendor Open Items(A/Payables)(BELNR,AUGBL,LIFNR,EBELN)
BKPF and BSEG tables Consists of data from BSIS,BSAS,BSID,
BSAD,BSIK and BSAK tables.
BSET: Tax Information Data (BELNR,BUZEI,HKONT,MWSKZ)
BSEC: One time Vendor records(BELNR,BUZEI,BUKRS,NAME1)
CSKS: Cost Center Master(KOKRS,KOSTL,BUKRS,GSBER,PRCTR)
CSKT: Cost Center Texts (KOSTL,KOKRS,SPRAS,LTEXT)
CSSK: Cost Center/Cost Element relations(KOKRS,KOSTL,KSTAR)
GLT0: G/L account master-Ledger
(RLDNR,RACCT,BUKRS,RVERS,RBUSA)
GLTPC: Profit Center Accounting
(RLDNR,RACCT,BUKRS,RVERS,PRCTR)
GLPCA: EC-PCA: Actual Line Items
(RLDNR,RACCT,KOSTL,KOKRS,RPRCTR)
GLPCT: EC-PCA: Totals Table
(RLDNR,RACCT,RPRCTR,TSLXX,HSLXX,KSLXX)
COEP: CO Object Line Items by period(KOKRS,BELNR,BUZEI)
COST: CO Object Price Totals(LEDNR,OBJNR,GJAHR,TKGXXX)
CSSL: Cost Center-Activity Type(KOKRS,KOSTL,LSTAR,GJAHR)
CRCO: Work Center-Cost Center Assignment(OBJID,KOSTL,LSTAR)
CSLA: Activity Types Master(KOKRS,LSTAR,DATBI,LATYP)
CSKB: COST Elements(KSTAR,KOKRS,KATYP)
COSS: Cost Totals (OBJNR,GJAHR,KSTAR)
CEPC: Profit Center Master Data(PRCTR,DATBI,KOKRS)
BNKA: Master Record of Banks(BANKS,BANKL,BANKA)
KEKO: Product Costing Header data(KALKA,KALNR,KADKY,MATNR)
ANLH: Main Asset Number(BUKRS,ANLN1)
ANLA: Asset Master Record Segment(BUKRS,ANLN1,ANLN2)
ANLB: Depreciation terms(BUKRS,ANLN1,ANLN2,AFABE)
ANLC: Asset Value Fields(BUKRS,ANLN1,ANLN2,AFABE)
ANEK: Document Header Asset Posting(BUKRS,ANLN1,ANLN2,GJAHR)
ANKT: Asset classes: Description(SPRAS,ANLKL,TXT50)

Answer / kiran kumar kakolu

The table Bkpf give you the detail view of the transaction
code used for a documnet. You can view the feild TCODE in
BKPF.The table BSEG gives you all the deatils regarding
documents, G/L aacounts, Vendors, Customers and Asssets. In
oreder to view this table quickly. you need to get the
document number from bkpf. then the acces wil be very fast

The table T030 defines the integration between FI and MM.
In this table the valuation class from MM is integarted to
a GL account from FI side.

Answer / majid khan md

can anybody tell for what purpose we are using these tables
with example please

Answer / pavan

As mentioned above different tables for FICO consultant
required. but the basic thing u need to learn how to
operate SE11 and se16.

SE11 is the t-code where u get lot of info. about the
tables like the relation between different fields and
tables, primary and foreign key info. and if any restricted
values for a particular field like for account type values
are restricted up to A,S,K,D,M,V....

so first familarize with SE11 using the above mentioned
tables.

Answer / harshul

Use Tcode SE11, enter the desired table you will get the
contents of the table

Answer / patel brothers

To store the Financial data

Answer / kishore

dear narayan plz help us to find tables in fi one way is to press f1 in particulat field and know the table name if we folow the same thing for gl open item as per your statement it is BSIS but where as per our method its not showing BSIS, SO PLZ PLZ PLZ HELP US

Answer / guest

SE11, SE16, BKPF BSEG,T030

Is it possible to change the indicator ‘only balances in local currency’ once the balances are updated to that GL account?

1 Answers  

Which is the payment term which actually gets defaulted in transaction (accounting view or purchasing view)?

0 Answers  

What is a client in an R3 System? (Multi)

5 Answers  

Who will be done the BDC(Batch Data Communication) process.. Is it consultant or technical people(ABAP PEOPLE)

2 Answers   Cambridge,

How do you create cost center in system? What are the requirements? : cost center accounting

0 Answers  

What are one-time vendors?

0 Answers  

Brief about g/r I/r clearing. Can’t v avoid this a/c? Process?

4 Answers   Accenture, TCS,

What are the functionalities available in the financial statement version?

0 Answers  

What is the number of configured currencies per company code?

0 Answers  

which fields we cannot control through the field status groups at the time of document posting?

2 Answers   HP,

Q.what type of issues you are getting and tell me some issues in asset acctng,fi-mm,co?

0 Answers   iGate,

Suppose we have created a PO with qty 100 Ton and we have done MIGO with qty 99 Ton and after that we have MIRO 100 Ton. Interviewer asked me how can we load the difference qty balance of migo and miro (100-99=1ton) on material? please help regards sandeep.

0 Answers   Fujitsu,