What are the tables will deal a sap fico consultant?
Answer Posted / 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 |
Post New Answer View All Answers
How capital wip (work in process) and assets accounted for in sap?
What is the difference between set screen and call screen?
All fico interview questions
How is master data different from transaction data?
Where are payment terms for customer master maintained?
what is business area? What are its advantages and disadvantages?
What happens when the revaluation is done in actual costing run for the previous period?
Explain manual primary cost planning? : co- cost center accounting
Hi gurus, what is the critcal issue that you have faced during the support project? how did you resolve this issue. explain in step by step process/ kindly suggest me how to answer this question?
Can I integrate a data quality solution within other software applications?
What are the functionalities available in the financial statement version?
In selection screen I have three fields, plant mat number, and material group. If I input plant how do I get the mat number and material group based on plant dynamically?
What are the different standard reports in sap co system? : cost center accounting
Explain asset transfer in sap : fi- asset accounting
what is difference apportionment of costs, overhead expenses and how do they differ