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
what is cr in sap
What is deffrent Between Company Act and Income Tax Act depriciayion
What is dunning in fi?
Which interface change sql requirements in the sap development system to those of the database?
Will a customer get support when recompiling the linux kernel or using 3rd-party software that modifies it?
What is a field status group? : fi- general ledger accounting
Can you have multiple retained earnings accont?
In extended withholding taxes for submission of tax returns i.e. quarterly & annual which sap note is used?
currently i am recruited in rollout project my parent company is singapore and now we are doing rollout in malaysia.so could any one please tell me what are the neccesaary steps
Define depreciation areas? : fi- asset accounting
How many dunning levels can be defined? : fi- accounts receivable
NO CENVAT AMOUNT TO BE POSTED --------Please reply me its very urgent till now I didnt get the answer DETAILS REGARDING THE ERROR Process: J1iex for GR Posting simulation using j1iex Part 1 is captured While posting, this issue is coming. No part 2 is getting captured.
how to control transport cost with sale invoices :- I want to know how to map tranport cost with respective sale invoices. This help us to avoid duplicate transport payment. As in PO freight condition is maintained ,is there is anyway to link or map transport cost with sale invoices
How do you configure the sapscript form financial statement version?
How do you create cost center in system? What are the requirements? : cost center accounting