FI TABLES

[Former Member]

Hello Gurus,

I would be very grateful if someone could provide me with the Main Tables used in FI for:-

-

---

> All Master Data

-

---

>Line Items

Thanks in Anticipation,

Regards,

Debojit Dey

[Former Member · Accepted solution]

Hi Debojit,

SKA1 G/L Account Master (Chart of Accounts)

SKB1 G/L account master (company code)

SKAT G/L Account Master Record (Chart of Accounts: Description)

LFA1 Vendor Master (General Section)

LFB1

LFC1

KNA1 customer master data

KNB1

KNC1

BKPF accoutuing header

BSEG accounting line item

BSIS

BSIK

BSAD

you check se11 for description of these tables

Best Regards

Ashish Jain

[Former Member · Accepted solution]

Hi Ashis,

Thanks a lot for your reply. I really was looking for such a reply. You hit the bulls-eye.

Can you please provide me some more important tables using the same type of format?

Thanks Again,

Regards,

Debojit Dey

[Former Member · Accepted solution]

Hi Debojit,

Asset Accounting Tables

ANLA : Asset Master Record Segment

ANLB:Depreciation terms

ANLC: Asset Value Field

Controlling

CSKA Cost Elements (Data Dependent on Chart of Accounts)

CSKB: Cost Elements (Data Dependent on Controlling Area)

CSKS Cost Center Master Data

Purchase order

EKKO

EKPO

EINA

EKBE

MKPF

MSEG

Sales order

VBAP

VBAK

Delivery

LIKP

LIPS

Billing

VBRK

VBRP

Pls check the descrioptions in SE11/SE16

Best Regards

Ashish Jain

[Former Member · Accepted solution]

Hi Ashish,

Thanks a lot for your reply.

Your reply will go along way in helping me.

I would be really happy to help you in any manner if you need it.

Thanks Dude,

Regards,

Debojit Dey

[Former Member]

Dear Debojit,

Here some most common related <b>user tables with name identification</b> in <b>FICO</b> and if not sufficiant find enclosed list below

tcodes list

Payment transactions

F-06 Post Incoming Payments

F-07 Post Outgoing Payments

F-18 Payment with Printout

F-26 Incoming Payments Fast Entry

F-28 Post Incoming Payments

F-29 Post Customer Down Payment

F-31 Post Outgoing Payments

F-36 Bill of Exchange Payment

F-37 Customer Down Payment Request

F-39 Clear Customer Down Payment

F-40 Bill of Exchange Payment

F-47 Down Payment Request

F-48 Post Vendor Down Payment

F-52 Post Incoming Payments

F-53 Post Outgoing Payments

F-54 Clear Vendor Down Payment

F-58 Payment with Printout

F-59 Payment Request

F110 Parameters for Automatic Payment

F8BR Levels for Payment Requests

F8BS Detail display of payment requests

F8BT Display Payment Requests

F8BU Create payment runs automatically

F8BX Online Payment

F8XX Payment Request No. Ranges KI3-F8BM

FB03Z Display Document/Payment Usage

FB13 Release for Payments

FBA1 Customer Down Payment Request

FBA2 Post Customer Down Payment

FBA3 Clear Customer Down Payment

FBA6 Vendor Down Payment Request

FBA7 Post Vendor Down Payment

FBZ0 Display/Edit Payment Proposal

FBZ1 Post Incoming Payments

FBZ2 Post Outgoing Payments

FBZ3 Incoming Payments Fast Entry

FBZ4 Payment with Printout

FBZ5 Print Check for Payment Documen

FBZ8 Display Payment Run

FBZG Failed Customer Payments

- Reversal Transactions

CXA0 Mass reversal

F.80 Mass Reversal of Documents

F01N Debit Position LO Single Reversal

F01O Vacancy RU single reversal

F01P Accruals/deferrals single reversal

F01Q Debit position MC single reversal

F01R MC settlement single reversal

F01S Reversal of Periodic Postings

F8BV Reversal of Bank-to-Bank Transfers

FN37 Loan Reversal Chain

FNB3 Document Reversal - Loans

FNM3 Loans reversal module

FNM7 Loan reversal chain

FNRS Reversal Accrual/Deferral

FO08 Reversal input tax distribution

FO1F Owner Account Settlement Reversal

FO8B RealEstate accr./defer.- Reversal

FO8DM Input Tax Distribution Reversal

FOS8 Single Document Reversal

FOSC Debit position reversal

FOSD Deb.pos.-Partial reversal (in proc.)

FTR04 Reversal of Bill Transactions

FV02 Reversal of Correction Items

FZ52 Customizing Reasons for Reversal

FZFU Reversal Release

GC30 FI-LC: Mass Reversal

KE27S Reversal of KE27 Delta Line Items

KE4S00 CO-PA: Reversal of Line Items

KPSR Execute Plan Segment Reversal

MEB0 Reversal of Settlement Runs

MR11SHOW Account Maint.Docu.Display-Reversal

O54N Set reversal movement type indicator

O5BIC13 Define comp. str. for inv. reversal

O5BIC20 Define agg.schema for DBT reversals

PSCREV PSC calculation reversal

PSCTFREV PSC Transfer Funds Reversal

PUOCLL OC: List of Replacements/Reversals

TBC0 TR: Maintain manual reversal type

WLFJ Mass reversal of vendor billing docs

- Credit Transfer Transactions

F-27 Enter Customer Credit Memo

F-41 Enter Vendor Credit Memo

F-66 Park Vendor Credit Memo

F-67 Park Customer Credit Memo

F.28 Customers: Reset Credit Limit

FB10 Invoice/Credit Fast Entry

FB65 Enter Incoming Credit Memos

FB75 Enter Outgoing Credit Memos

FD24 Credit Limit Changes

S_ALR_87012221 Credit Limit Data Mass Change

- Write off Transactions

O3UH_ARWOC A/R Write Off Cents Report

O3UH_TP_WO Taxes Payable Write Off

- Adjustment transactions

ABCO Adjustment Posting to Areas

CJP1 Create Project Plan Adjustment

CJP2 Change Project Plan Adjustment

CJP3 Display Project Plan Adjustment

CJP4 Delete Project Plan Adjustment

CJPU Execute Project Plan Adjustment

CX3F5 Upload Equity Holdings Adjustments

CX3FD Upload Fair Value Adjustments(Value)

CX68 Equity Holdings Adjustments

CX6F2 Fair Value Adjustments

CX6F3 Reporting Fair Value Adjustment Data

CX6F6 Fair Value Adjustments

EW50 MM Post Adjustment Documents

EW68 EMU: AA Balance Adjustment

EW73 Investment Programs Adjustment

EWF1 Display FI/AA Adjustment Differences

EWF4 Display Clearing Proced.Adjustment

EWM4 MM Purchase Order History Adjustment

F.5D G/L: Update Bal. Sheet Adjustment

F.5E G/L: Post Balance Sheet Adjustment

F.5F G/L: Balance Sheet Adjustment Log

F.5G G/L: Subseq.Adjustment(BA/PC) Sp.ErA

FJA1 Inflation Adjustment of G/L Accounts

FJA4 Infl. Adjustment of Open Items (FC)

FNQ9 Int. adjustment run

FO1L Repost Input Tax Adjustments

- Clearing Transactions

ABZV Asset Acquis. Posted w/Clearing Acct

EW35 FI Previous Clearing Procedures

EWF4 Display Clearing Proced.Adjustment

EWM6 Reconcile GR/IR Clearing Account

F-04 Post with Clearing

F-30 Post with Clearing

F-51 Post with Clearing

F-91 Asset Acquis. Posted w/Clearing Acct

F.13 ABAP/4 Report: Automatic Clearing

F.19 G/L: Goods/Invoice Received Clearing

F13E ABAP/4 Report: Automatic Clearing

F8BJ Maintain Clearing Accts (Rec.Bank)

FB05 Post with Clearing

FB05_OLD Post with clearing

FNQ8 Automatic Clearing for Overpayments

FOPA OI Clearing on Rental Agreements

FO_V_TIV80 Clearing Accounts for Cost Accounts

GCAE Ledger comparison w/diff. clearing

GJ18 Partner Suspense Clearing

GJ61 JV Clearing billing indicator

GJ96 Payroll Burden Clearing

O3RCMM05 SSR Meters - Clearing

O3RCSM05 SSR Stocks - Clearing

O3RECH4 Assign Customer to Clearing house

O3UH_CC Check Clearing

O5BEAD16 SSR Clearing House Determination

OBXZ C FI Table T030 G/L Accont Clearing

OFM01A Create Doc. Type and Clearing Item

PRCC Credit Card Clearing

PRTC Docu.Buffer for Credit Card Clearing

- Posting of revenue (GL Summaries)

1KEF EC-PCA: Parameter acutal postings

ABCO Adjustment Posting to Areas

ABZO Asset acquis. autom. offset. posting

AD08 Enter G/L Account Posting

AFBP Create depreciation posting log

AO71 Document type for posting deprec.

AO72 Specify posting procedure

AOLAPOST Tabstrip Posting Transactions

ASIM Simulation of asset posting

ASKB Periodic Asset Postings

BD73 Reposting of IDocs (ALE)

CIPV Posting PDC records

CKM7 Analyze ML Postings

F-02 Enter G/L Account Posting

F-19 Reverse Statistical Posting

F-21 Enter Transfer Posting

F-38 Enter Statistical Posting

F-42 Enter Transfer Posting

F-55 Enter Statistical Posting

F-56 Reverse Statistical Posting

F-60 Maintain Table: Posting Periods

F-65 Preliminary Posting

F.38 Transfer Posting of Deferred Tax

F.4C Calc.vend.int.on arr.: w/o postings

F.81 Reverse Posting for Accr./Defer.Docs

F01S Reversal of Periodic Postings

FB21 Enter Statistical Posting

FB22 Reverse Statistical Posting

FF/6 Deposit/loan mgmt analysis/posting

FGL6 IRE: One Time Posting - Gen. Contr

FLQT1 Create Transfer Posting

FLQT2 Change Transfer Posting

FLQT3 Display Transfer Posting

FMN0 Subsequent Posting of FI Documents

FMN1 Subsequent Posting of MM Documents

FMN2 Subsequent Posting of Billing Docs

FMRP18 Clear Subsequent Postings

FNM1 Automatic Posting

FNM1S Automatic Posting - Single

FNR0 Loans: Posting Journal

FO3K Maintain automatic postings accounts

FO8DB Input Tax Distribution Posting

FO8Q Incoming payments by posting date

FOB1 Lease-Out One-Time Postings

FOIQ RE Contract: Periodic Postings

FOJG RE Contract One-Time Posting

FOJR RE Contract: Periodic Postings Log

FOL6 IRE: one-time postings lease-out

FOMU OI Transfer Posting on Tenant Change

FOSL General Real Estate Posting Log

FOSM General Real Estate Posting Log

FOSN Real Estate - Posting

FOVD Input tax trtmnt: Monthly postings

FO_NKA_BUP SCS Follow-up Posting

FR03 Original Commitments: Prel.Posting

FWBJ Posting journal

FWBS Manual posting

FWOE Reverse posting

FWSO Automatic posting

FZXR Flow types per posting application

GCD2 List of FI-SL Direct Posting Tables

GCP1 FI-SL: Local Posting Periods

GCU4 Subsequent Posting of Data From MM

GCU5 Subsequent Posting of Data frm Sales

GCU6 CO plan doc subs. posting to FI-SL

GCUP Subsequently posting CO data to FISL

GJ49 Billing method posting rules

GJ50 JV Posting rule detail customizing

GJ83 JV Automatic posting

GJ85 JV Automated Postings (Cost Calcs)

GJPE Display Documents for re-posting

KAL1 Reconcil. Ledger follow-up posting

KALH Change Rules for Reconcil. Posting

KALK Create Rules for Reconcil. Posting

KALS Reverse Reconciliation Posting

KB11 Enter Reposting of Primary Costs

KB11N Enter Manual Repostings of Costs

KB11NP Enter Manual Repostings of Costs

KB13 Display Reposting of Primary Costs

KB13N Display Manual Repostings of Costs

KB13NP Display Manual Repostings of Costs

KB14 Reverse Reposting of Primary Costs

KB14N Reverse Manual Repostings of Costs

http://www.erpgenie.com/abap/tables_fi.htm

Hope above infirmation will helps you

Prem.

[Former Member]

hi Debojit,

Details showing important Tables in SAP

Table Name Description Important Fields

Financial Accounting

FBAS Financial Accounting “Basis”

BKPF Accounting Document Header MANDT / BUKRS / BELNR / GJAHR

BSEG Accounting Document Segment MANDT / BUKRS / BELNR / GJAHR / BUZEI

BSIP Index for Vendor Validation of Double Documents MANDT / BUKRS / LIFNR / WAERS / BLDAT / XBLNR / WRBTR / BELNR / GJAHR / BUZEI

BVOR Inter Company Posting Procedure MANDT / BVORG / BUKRS / GJAHR / BELNR

EBKPF Accounting Document Header (docs from External Systems) MANDT / GLSBK / BELNR / GJHAR / GLEBK

FRUN Run Date of a Program MANDT / PRGID

KLPA Customer / Vendor Linking MANDT / NKULI / NBUKR / NKOAR / PNTYP / VKULI / VBUKR / VKOAR

KNB4 Customer Payment History MANDT / KUNNR / BUKRS

KNB5 Customer Master Dunning Data MANDT / KUNNR / BUKRS / MABER

KNBK Customer Master Bank Details MANDT / KUNNR / BANKS / BANKL / BANKN

KNC1 Customer Master Transaction Figures MANDT / KUNNR / BUKRS / GJHAR

KNC3 Customer Master Special GL Transactions Figures MANDT / KUNNR / BUKRS / GJAHR / SHBKZ

LFB5 Vendor Master Dunning Data MANDT / LIFNR / BUKRS / MABER

LFBK Vendor Master Bank Details MANDT / LIFNR / BANKS / BANKL / BANKN

LFC1 Vendor Master Transaction Figures MANDT / LIFNR / BUKRS / GJHAR

LFC3 Vendor Master Special GL Transactions Figures MANDT / LIFNR / BUKRS / GJHAR / SHBKZ

VBKPF Document Header for Document Parking MANDT / AUSBK / BUKRS / BELNR / GJHAR

FBASCORE Financial Accounting General Services “Basis”

KNB1 Customer Master (Company Code) MANDT / KUNNR / BUKRS

LFA1 Vendor Master (General Section) MANDT / LIFNR

LFB1 Vendor Master (company Code Section) MANDT / LIFNR / BUKRS

SKA1 G/L Account Master (Chart of Accounts) MANDT / KTOPL / SAKNR

SKAT G/L Account Master (Chart of Accounts – Description) MANDT / SPRAS / KTOPL / SAKNR

MAHNS Accounts Blocked by Dunning Selection MANDT / KOART / BUKRS / KONKO / MABER

MHNK Dunning Data (Account Entries) MANDT / LAUFD / LAUFI / KOART / BUKRS / KUNNR / LIFNR / CPDKY / SKNRZE / SMABER / SMAHSK / BUSAB

FI-GL-GL (FBS) General Ledger Accounting: Basic Functions- G/L Accounts

SKAS G/L Account Master (Chart of Accounts – Key Word list) MANDT / SPRAS / KTOPL / SAKNR / SCHLW

SKB1 G/L Account Master (Company Code) MANDT / BUKRS / SAKNR

FI-GL-GL (FBSC) General Ledger Accounting: Basic Functions - R/3 Customizing for G/L Accounts

FIGLREP Settings for G/L Posting Reports MANDT

TSAKR Create G/L account with reference MANDT / BUKRS / SAKNR

FI-GL-GL (FFE) General Ledger Accounting: Basic Functions - Fast Data Entry

KOMU Account Assignment Templates for G/L Account items MANDT / KMNAM / KMZEI

FI-AR-AR (FBD) Accounts Receivable: Basic Functions - Customers

KNKA Customer Master Credit Management : Central Data MANDT / KUNNR

KNKK Customer Master Credit Management : Control Area Data MANDT / KUNNR / KKBER

KNKKF1 Credit Management : FI Status data MANDT / LOGSYS / KUNNR / KKBER / REGUL

RFRR Accounting Data – A/R and A/P Information System MANDT / RELID / SRTFD / SRTF2

FI-BL-PT (BFIBL_CHECK_D) Bank Accounting: Payment Transactions – General Sections

PAYR Payment Medium File MANDT / ZBUKR / HBKID / HKTID / RZAWE / CHECT

PCEC Pre-numbered Check MANDT / ZBUKR / HBKID / HKTID / STAPL

FI-BL-PT-AP(FMZA) Bank Accounting: Payment Transactions – Automatic Payments

F111G Global Settings for Payment Program for Payment Requests MANDT

FDZA Cash Management Line Items in Payment Requests MANDT / KEYNO

PAYRQ Payment Requests MANDT / KEYNO

FI-AA-AA (AA) Asset Accounting: Basic Functions – Master Data

ANKA Asset Classes: General Data MANDT / ANLKL

ANKP Asset Classes: Fld Cont Dpndnt on Chart of Depreciation MANDT / ANLKL / AFAPL

ANKT Asset Classes: Description MANDT / SPRAS / ANLKL

ANKV Asset Classes: Insurance Types MANDT / ANLKL / VRSLFD

ANLA Asset Master Record Segment MANDT / BUKRS / ANLN1 / ANLN2

ANLB Depreciation Terms MANDT / BUKRS / ANLN1 / ANLN2 / AFABE / BDATU

ANLT Asset Texts MANDT / SPRAS / BUKRS / ANLN1 / ANLN2

ANLU Asset Master Record User Fields .INCLUDE / MANDT / BUKRS / ANLN1 / ANLN2

ANLW Insurable Values (Year Dependent) MANDT / BUKRS / ANLN1 / ANLN2 / VRSLFD / GJAHR

ANLX Asset Master Record Segment MANDT / BUKRS / ANLN1 / ANLN2

ANLZ Time Dependent Asset Allocations MANDT / BUKRS / ANLN1 / ANLN2 / BDATU

FI-AA-AA (AA2) Asset Accounting: Basic Functions – Master Data 2.0

ANAR Asset Types MANDT / ANLAR

ANAT Asset Type Text MANDT / SPRAS / ANLAR

FI-AA-AA (AB) Asset Accounting: Basic Functions – Asset Accounting

ANEK Document Header Asset Posting MANDT / BUKRS / ANLN1 / ANLN2 / GJAHR / LNRAN

ANEP Asset Line Items MANDT / BUKRS / ANLN1 / ANLN2 / GJAHR / LNRAN / AFABE

ANEV Asset Downpymt Settlement MANDT / BUKRS / ANLN1 / ANLN2 / GJAHR / LNRANS

ANKB Asset Class: Depreciation Area MANDT / ANLKL / AFAPL / AFABE / BDATU

ANLC Asset value Fields MANDT / BUKRS / ANLN1 / ANLN2 / GJAHR / AFABE

ANLH Main Asset Number MANDT / BUKRS / ANLN1

ANLP Asset Periodic Values MANDT / BUKRS / GJAHR / PERAF / AFBNR / ANLN1 / ANLN2 / AFABER

FI-SL-VSR (GVAL) Special Purpose Ledger: Validation, Substitution and Rules

GB03 Validation / Substitution User VALUSER

GB92 Substitutions MANDT / SUBSTID

GB93 Validation MANDT / VALID

Controlling

AUSP Characteristic Values MANDT / OBJEK / ATINN / ATZHL / MAFID / KLART / ADZHL

CO-KBAS Overhead Cost Controlling

A132 Price per Cost Center MANDT / KAPPL / KSCHL / KOKRS / VERSN / RESRC / KOSTL / DATBI

A136 Price per Controlling Area MANDT / KAPPL / KSCHL / KOKRS / VERSN / RESRC / DATBI

A137 Price per Country / Region MANDT / KAPPL / KSCHL / KOKRS / VERSN / RESRC / LAND1 / REGIO / DATBI

COSC CO Objects: Assignment of Original Costing Sheets MANDT / OBJNR / SCTYP / VERSN / GJAHR

CSSK Cost Center / Cost Element MANDT / VERSN / KOKRS / GJAHR / KOSTL / KSTAR

CSSL Cost Center / Activity Type MANDT / KOKRS / KOSTL / LSTAR / GJAHR

KAPS CO Period Locks MANDT / KOKRS / GJAHR / VERSN / VRGNG / PERBL

CO-KBASCORE Overhead Cost Controlling: General Services

CSKA Cost Elements (Data Dependent on Chart of Accounts) MANDT / KTOPL / KSTAR

CSKB Cost Elements (Data Dependent on Controlling Area) MANDT / KOKRS / KSTAR / DATBI

CSKS Cost Center Master Data MANDT / KOKRS / KOSTL / DATBI

CSLA Activity Master MANDT / KOKRS / LSTAR / DATBI

CO-OM (KACC) Overhead Cost Controlling

COBK CO Object: Document Header MANDT / KOKRS / BELNR

COEJ CO Object: Line Items (by Fiscal Year) MANDT / KOKRS / BELNR / BUZEI / PERBL

COEJL CO Object: Line Items for Activity Types (by Fiscal Yr) MANDT / KOKRS / BELNR / BUZEI / PERBL

COEJR CO Object: Line Items for SKF (by Fiscal Year) MANDT / KOKRS / BELNR / BUZEI / PERBL

COEJT CO Object: Line Items for Prices (by Fiscal Year) MANDT / KOKRS / BELNR / BUZEI / PERBL

COEP CO Object: Line Items (by Period) MANDT / KOKRS / BELNR / BUZEI

COEPL CO Object: Line Items for Activity Types (by Period) MANDT / KOKRS / BELNR / BUZEI

COEPR CO Object: Line Items for SKF (by Period) MANDT / KOKRS / BELNR / BUZEI

COEPT CO Object: Line Items for Prices (by Period) MANDT / KOKRS / BELNR / BUZEI

COKA CO Object: Control Data for Cost Elements MANDT / OBJNR / GJAHR / KSTAR / HRKFT

COKL CO Object: Control Data for Activity Types MANDT / LEDNR / OBJNR / GJAHR / VERSN

COKP CO Object: Control Data for Primary Planning MANDT / LEDNR / OBJNR / GJAHR / WRTTP / VERSN / KSTAR / HRKFT / VRGNG / VBUND / PARGB / BEKNZ / TWAER

COKR CO Object: Control Data for Statistical Key Figures MANDT / LEDNR / OBJNR / GJAHR / WRTTP / VERSN / STAGR / HRKFT / VRGNG

COKS CO Object: Control Data for Secondary Planning MANDT / LEDNR / OBJNR / GJAHR / WRTTP / VERSN / KSTAR / HRKFT / VRGNG / PAROB / USPOB / BEKNZ / TWAER

CO-OM-CEL (KKAL) Cost Element Accounting (Reconciliation Ledger)

COFI01 Object Table for Reconciliation Ledger COFIT MANDT / OBJNR

COFI02 Transaction Dependent Fields for Reconciliation Ledger MANDT / OBJNR

COFIP Single Plan Items for Reconciliation Ledger RCLNT / GL_SIRID

COFIS Actual Line Items for Reconciliation Ledger RCLNT / GL_SIRID

CO-OM-CCA Cost Center Accounting (Cost Accounting Planning RK-S) – What is RK-S

A138 Price per Company Code MANDT / KAPPL / KSCHL / KOKRS / VERSN / RESRC / BUKRS / GSBER / DATBI

A139 Price per Profit Center MANDT / KAPPL / KSCHL / KOKRS / VERSN / RESRC / PRCTR / DATBI

CO-OM-OPA (KABR) Overhead Orders: Application Development R/3 Cost Accounting Settlement

AUAA Settlement Document: Receiver Segment MANDT / BELNR / LFDNR

AUAB Settlement Document: Distribution Rules MANDT / BELNR / BUREG / LFDNR

AUAI Settlement Rules per Depreciation Area MANDT / BELNR / LFDNR / AFABE

AUAK Document Header for Settlement MANDT / BELNR

AUAO Document Segment: CO Objects to be Settled MANDT / BELNR / LFDNR

AUAV Document Segment: Transactions MANDT / BELNR / LFDNR

COBRA Settlement Rule for Order Settlement MANDT / OBJNR

COBRB Distribution Rules Settlement Rule Order Settlement MANDT / OBJNR / BUREG / LFDNR

CO-OM-OPA (KAUF) Overhead Orders: Cost Accounting Orders

AUFK Order Master Data MANDT / AUFNR

AUFLAY0 Enttity Table: Order Layouts MANDT / LAYOUT

EC-PCA (KE1) Profit Center Accounting

CEPC Profit Center Master Data Table MANDT / PRCTR / DATBI / KOKRS

CEPCT Texts for Profit Center Master Data MANDT / SPRAS / PRCTR / DATBI / KOKRS

CEPC_BUKRS Assignment of Profit Center to a Company Code MANDT / KOKRS / PRCTR / BUKRS

GLPCA EC-PCA: Actual Line Items RCLNT / GL_SIRID

GLPCC EC-PCA: Transaction Attributes MANDT / OBJNR

GLPCO EC-PCA: Object Table for Account Assignment Element MANDT / OBJNR

GLPCP EC-PCA: Plan Line Items RCLNT / GL_SIRID

EC-PCA BS (KE1C) PCA Basic Settings: Customizing for Profit Center Accounting

A141 Dependent on Material and Receiver Profit Center MANDT / KAPPL / KSCHL / KOKRS / WERKS / MATNR / PPRCTR / DATBI

A142 Dependent on Material MANDT / KAPPL / KSCHL / WERKS / MATNR / DATBI

A143 Dependent on Material Group MANDT / KAPPL / KSCHL / WERKS / MATKL / DATBI

1 Customising

1.1 General settings

1.1.1 Countries

T005 Countries

1.1.2 Currency

TCURC Currency codes

TCURR Wisselkoersen

TCURT Currency name

TCURX Decimal places for currencies.

1.1.3 Unit of measure

T006 Units of measure

1.1.4 Calendar functions

T247 Month names

TFACD Factory calendar definition

T015M Month names

TTZZ Time zones

TTZD Summer time rules

TTZDF Summer time rules (fixed annual dates)

TTZDV Summer time rules (variable dates)

TTZDT Summer time rules texts

TTZ5 Assign Time Tones to Countries

TTZ5S Assign time zones to regions

1.2 Enterprise structure

1.2.1 Definition

FI T880 Company

T001 Company code

CO TKA01 Controlling area

LO T001W Plant / sales organisation

T499S Locations

TSPA Division

SD TVKO Sales organisation / company code

TVTW Distribution channel

TVBUR Sales office

TVKBT Sales office text

TVKGR Sales group

TVGRT Sales group text

T171T Sales district text

MM T001L Storage locations

T024E Purchasing organization

T3001 Warehouse number

TVST Shipping point

TVLA Loading point

TTDS Transportation

1.2.2 Assignment

CO TKA02 Assign company code to controlling area

LO T001K Assign plant (valuation area) to company code

SD TVKO Sales organisation / company code

TVKOV Distribution channel / sales organisation

TVKOS Division to sales organization

TVTA Sales aria

TVKBZ Sales office to sales area

TVBVK Sales group to sales office

TVKWZ Plants to sales organization

MM T024E Purchasing organization / company code

T024W Plant to Purchase organization

T001K Link plant ( = valuation area) / company code

TVSWZ Shipping point to plant

T320 Assignment MM Storage Location to WM Warehouse

1.3 Financial accounting

1.3.1 Company code

T004 Chart of accounts

T077S Account group (g/l accounts)

T009 Fiscal year variants

T880 Global company data

T014 Credit control area

1.3.2 Fi document

T010O Posting period variant

T010P Posting Period Variant Names

T001B Permitted Posting Periods

T003 Document types

T012 House banks

1.4 Not categorized

T007a Tax keys

T134 Material types

T179 Materials: Product Hierarchies

T179T Materials: Product hierarchies: Texts

TJ02T Status text

TINC Customer incoterms

TVFK Billing doc types

T390 PM: Shop papers for print control

2 Basic data / administration

2.1 Workbench related tables

2.1.1 Data dictionary tables

DD02L Tables in SAP

DD02T Tables description

DD03L Field names in SAP

DD03T Field description in SAP

2.1.2 Workbench

TADIR Directory of R/3 Repository Objects

TRDIR System table TRDIR

TFDIR Function Module

TLIBG Person responsible for function class

TLIBT Function Group Short Texts

TFTIT Function Module Short Text

TSTC Transaction codes in SAP

TSTCT Transaction codes texts

T100 Message text (vb e000)

VARID Variant data

D020T Screen texts

TDEVC Development class

TDEVCT Texts for development classes

2.2 Administration

2.2.1 User administration

USR01 User master

USR02 Logon data

USR03 User address data

USR04 User master authorizations

USR11 User Master Texts for Profiles (USR10)

UST12 User master: Authorizations

USR12 User master authorization values

USR13 Short Texts for Authorizations

USR40 Prohibited passwords

TOBJ Objects

TOBC Authorization Object Classes

TPRPROF Profile Name for Activity Group

DEVACCESS Table for development user

2.2.2 Batch input queue

APQD DATA DEFINITION Queue

APQI Queue info definition

2.2.3 Job processing

TBTCO Job status overview table

TBTCP Batch job step overview

2.2.4 Spool

TSP02 Spool: Print requests

2.2.5 Runtime errors

SNAP Runtime errors

2.2.6 Message control

TNAPR Processing programs for output

NAST Message status

NACH Printer determination

2.2.7 EDI

EDIDC Control record

EDIDD Data record

EDID2 Data record 3.0 Version

EDIDS EDI status record

EDPAR Convert External < > Internal Partner Number

EDPVW EDI partner types

EDPI1 EDI partner profile inbound

EDPO1/2/3 EDI partner profile outbound

2.2.8 Change documents

CDHDR Change document header

CDPOS Change document positioned

JCDS Change Documents for System/User Statuses (Table JEST)

2.2.9 Reporting tree table

SERPTREE Reporting: tree structure

2.2.10 LIS structure/control tables

TMC4 Global Control Elements: LIS Info Structure

3 MASTER DATA:

3.1 Material master:

MARA Material master

MAKT Material text

MARC Material per plant / stock

MVKE Material master, sales data

MARD Storage location / stock

MSKA Sales order stock

MSPR Project stock

MARM Units of measure

MEAN International article number

PGMI Planning material

PROP Forecast parameters

MAPR Link MARC <=> PROP

MBEW Material valuation

MVER Material consumption

MLGN Material / Warehouse number

MLGT Material / Storage type

MPRP Forecast profiles

MDTB MRP table

MDKP Header data for MRP document

MLAN Tax data material master

MTQSS Material master view: QM

3.1.1 Basic data text (sap script)

STXB SAP script: Texts in non-SAP script format

STXH STXD SAP script text file header

STXL STXD SAP script text file lines

3.1.2 Batches

MCHA Batches

MCH1 Batches

MCHB Stock: batches

3.2 Customer master data

KNA1 Customer master

KNB1 Customer / company

KNVV Customer sales data

KNBK Bank details

KNVH Customer hierarchy

KNVP Customer partners

KNVS Shipment data for customer

KNVK Contact persons

KNVI Customer master tax indicator

3.3 Vendor

LFA1 Vendor master

LFB1 Vendor per company code

LFB5 Vendor dunning data

LFM1 Purchasing organization data

LFM2 Purchasing data

LFBK Bank details

3.4 Customer – material info record

KNMT Customer material info record

3.5 Bank data

BNKA Master bank data

4 Characteristics:

4.1 Characteristics:

CABN Characteristics ( o.a. batch/vendor)

CABNT Characteristics description

CAWN Characteristics ( o.a. material)

CAWNT Characteristics description

AUSP Characteristic Values

4.2 Class types and objects :

TCLAO Several class types for object

TCLA Class types ( vb. lfa1 => v10 en 010)

TCLAT Class type text

TCLT Classifiable objects

TCLC Classification status

4.3 Links:

INOB Link between Internal Number and Object

KLAH Class header data

KSSK Allocation Table: Object (vb.matnr) to Class

KSML Characteristics for a class (internal number)

5 FI/CO :

5.1 FI :

5.1.1 Master data

SKA1 Accounts

BNKA Bank master record

5.1.2 Accounting documents // indices

BKPF Accounting documents

BSEG item level

BSID Accounting: Secondary index for customers

BSIK Accounting: Secondary index for vendors

BSIM Secondary Index, Documents for Material

BSIP Index for vendor validation of double documents

BSIS Accounting: Secondary index for G/L accounts

BSAD Accounting: Index for customers (cleared items)

BSAK Accounting: Index for vendors (cleared items)

BSAS Accounting: Index for G/L accounts (cleared items)

5.1.3 Payment run

REGUH Settlement data from payment program

REGUP Processed items from payment program

5.2 CO :

TKA01 Controlling areas

TKA02 Controlling area assignment

KEKO Product-costing header

KEPH Cost components for cost of goods manuf.

KALO Costing objects

KANZ Sales order items - costing objects

5.2.1 Cost center master data

CSKS Cost Center Master Data

CSKT Cost center texts

CRCO Assignment of Work Center to Cost Center

5.2.2 Cost center accounting

COSP CO Object: Cost Totals for External Postings

COEP CO Object: Line Items (by Period)

. COBK CO Object: Document header

COST CO Object: Price Totals

Assign the points if helpfull..

Ranjit

[former_member197269]

hope this helps:

http://www.sap-img.com/financial/important-tables-in-sap-fi.htm

http://www.abap.es/Descargas/TAB%20-%20Relacion%20de%20las%20tablas%20por%20modulos.PDF

http://www.erpgenie.com/abap/tables_fi.htm

http://www.sap-topjobs.com/SAPIntTables.pdf

pls assign points as way to say thanks

[Former Member]

Finance Tables

AGKO Cleared Accounts

ANAR Asset Types

ANAT Asset type text

ANEK Document Header Asset Posting

ANEP Asset Line Items

ANEV Asset downpymt settlement

ANKT Asset classes- Description

ANLA Asset Master Record Segment

ANLB Depreciation terms

ANLC Asset Value Fields

ANLH Main asset number

AT02T Transaction Activity Category- Description

AT02A Transaction Code for Menu TIMN

AT10 Transaction type

AT10T Name of Transaction Type

BKDF Document Header Supplement for Recurring Entry

BKORM Accounting Correspondence Requests

BKPF Accounting Document Header

BLPK Document log header

BLPP Document log item

BLPR Document Log Index and Planned Order (Backflush)

BNKA Bank master record

BP000 Business Partner Master (General Data)

BPBK Doc.Header Controlling Obj.

BPEG Line Item Total Values Controlling Obj.

BPEJ Line Item Annual Values Controlling Obj.

BPEP Line Item Period Values Controlling Obj.

BPGE Totals Record for Total Value Controlling obj.

BPJA Totals Record for Annual Total Controlling Obj.

BSAD Accounting- Secondary Index for Customers (Cleared Items)

BSAK Accounting- Secondary Index for Vendors (Cleared Items)

BSAS Accounting- Secondary Index for G/L Accounts (Cleared Items)

BSEC One-Time Account Data Document Segment

BSEG Accounting Document Segment

BSID Accounting- Secondary Index for Customers

BSIK Accounting- Secondary Index for Vendors

BSIM Secondary Index, Documents for Material

BSIS Accounting- Secondary Index for G/L Accounts

CEPC Profit Center Master Data Table

CEPCT Texts for Profit Center Master Data

COBRA Settlement Rule for Order Settlement

COBRB Distribution Rules Settlement Rule Order Settlement

COKA CO Object- Control Data for Cost Elements

COSP CO Object- Cost Totals for External Postings

COSS CO Object- Cost Totals for Internal Postings

CRCO Assignment of Work Center to Cost Center

CSKA Cost Elements (Data Dependent on Chart of Accounts)

CSKB Cost Elements (Data Dependent on Controlling Area)

CSLA Activity master

FEBEP Electronic Bank Statement Line Items

FPLA Billing Plan

FPLT Billing Plan- Dates

GLPCT EC-PCA- Totals Table

KNA1 General Data in Customer Master

KOMK Pricing Communication Header

MAHNV Management Records for the Dunning Program

REGUT TemSe - Administration Data

SKA1 G/L Account Master (Chart of Accounts)

SKAT G/L Account Master Record (Chart of Accounts- Description)

SKB1 G/L account master (company code)

T003T Document Type Texts

T007S Tax Code Names

T087J Text

TAPRFT Text tab. for investment profile

TKA01 Controlling Areas

TKA09 Basic Settings for Versions

TKVS CO Versions

TZB0T Flow types text table

TZPAT Financial Assets Management product type texts

VBSEGS Document Segment for G/L Accounts Document Parking

VTBFHA Transaction

VTBFHAPO Transaction Flow

VTBFHAZU Transaction Activity

VTBFINKO Transaction Condition

VTIDERI Master Data Listed Options and Futures

VTIFHA Underlying transaction

VTIFHAPO Underlying transaction flows

VTIFHAZU Underlying transaction status table

VTIOF Options Additional Data

VWPANLA Asset master for securities

---

Eugene (eugenemessage@gmail.com)

[Former Member]

Hi Everyone,

I am really grateful that all of you took pains to provide me with the major Tables in FI.

Could you please do me another favour by providing me the tables in the format as followes:-

GL Master Data Tables

.

.

.

.

.

GL Document Level Tables

.

.

.

.

Vendor/Customer Master Data Tables

.

.

.

.

Vendor/Cuatomer Document Level Tables

.

.

.

Asset Master Data Tables

Thanks in Anticipation,

Regards,

Debojit Dey

[Former Member]

FBAS : Financial Accounting "Basis"

BKPF : Accounting Document Header

BSEG : Accounting Document Segment

BSIP : Index for Vendor Validation of Double Document

BVOR : Inter Company posting Procedure

KNB4 : Customer Payment History

KNB1 : Customer Master(Company code)

LFA1 : Vendor Master(General Section)

LFB1 : Vendor Master(company code section)

SKA1 : G/L Account master

SKAT : G/L Account master(Description)

[Former Member]

Master Data

COA - SKA1

Co code - SKB1

description -SKAT

Vendor - LFA1, LFB1

Customer - KNA1,KNB1

line items - BSEG

Asha