What are the tables will deal a sap fico consultant?
Answers were Sorted based on User's Feedback
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)
Is This Answer Correct ? | 28 Yes | 1 No |
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.
Is This Answer Correct ? | 19 Yes | 9 No |
can anybody tell for what purpose we are using these tables
with example please
Is This Answer Correct ? | 15 Yes | 8 No |
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.
Is This Answer Correct ? | 5 Yes | 2 No |
Answer / harshul
Use Tcode SE11, enter the desired table you will get the
contents of the table
Is This Answer Correct ? | 4 Yes | 2 No |
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
Is This Answer Correct ? | 2 Yes | 1 No |
How do you connect to your servers?
FBN! - Number ranges :- Hi All When i am going for posting the number ranges in FBN1. After I enter the company code I enter. Then when I go to intervals I am seeing many number ranges already present. Even X2,X3…Should I delete all those present & enter new ones from my company code or how to go about.
What is the overview of Depreciation? how it will be calculated in asset account? please tel me...
In G/L master records there is a field( in control tab)'alternate account number'. What is required to be filled in that field?
Explain statistical key figure
How account payable in fi is related to g/l?
why are you choose sap fi/co
Hi One important Question, I am trying to run depreciation for this month at AFAB it says job RBACH00 is complete and but at SM35 i cant the created batch for the same. In sm37 when i give the same batch name and execute it says " status as finished but depreciation is not processed. Can any one plz throw some light on this?
What are the master data pre-requisites for document clearing?
In F110 - Automatic Payment Program, while setting parameters we need to put " Posting date for next payment run". Please explain what is the significance of putting that. Why is that required to be put?
please any body can tell me ,what reponsibilities and roles should a sap fico consultant do in the job
How do you control field status of GL master records and from where do you control.