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
Will first logic’s global data quality connector for sap manage my international data?
What are the use of document types ?
What are characteristics and value fields?
What is web? What is its purpose?
How many ways can you create the asset master record ? : fi- asset accounting
What is a ZM entry, is it recorded in the general ledger, and what does it do?
DIfference between F-43
Explain what is validations and substitutions in sap?
How do you create gl account master data? : fi- general ledger
What is depreciation key? : fi- asset accounting
We use statistical internal orders to have more detail on the cost center for tracking activities in a vineyard. Example would be different operational cost centers buy supplies for pruning, fertilizing, planting, frost control, etc so we have internal orders to add to cost center and gl acct. GL acct is type of expense, labor, supplies, equipment etc. How can I get my internal orders at my cost centers to display both actual and plan in my report. the flext table does not store both cost objects so it will not work.....
while making DO in SAP system allowes passing an entry more than the credit limit set in the system configuration Please help me
What are the types of depreciation methods? : fi- asset accounting
Why is it not possible to post to a customer a/c in a previously closed period?
Explain how carry-forward happens in sap?