topic Re: tables in Application Development and Automation Discussions

tables

Former Member — Tue, 10 Jul 2007 09:14:48 GMT

Hi,

Can anyone give me a list of some FI/CO tables?

Regards,

Hema

Re: tables

Former Member — Tue, 10 Jul 2007 09:16:50 GMT

Hi,

<a href="https://www.sdn.sap.comhttp://www.sdn.sap.comhttp://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/e944e133-0b01-0010-caa2-be2cb240f657">handy document</a>

grtz,

Koen

Re: tables

Former Member — Tue, 10 Jul 2007 09:17:05 GMT

Hi,

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

Refer

http://www.erpgenie.com/sapfunc/fi.htm

Regards,

PAdmam.

Re: tables

Former Member — Tue, 10 Jul 2007 09:17:12 GMT

Hi,

Check these tables.

Financial Accounting

Table Name Description Important Fields

Financial Accounting

FBAS Financial Accounting “Basis”

BKPF Accounting Document Header BUKRS / BELNR / GJAHR

BSEG Accounting Document Segment BUKRS / BELNR / GJAHR / BUZEI

BSIP Index for Vendor Validation of Double BUKRS / LIFNR / WAERS / BLDAT /

Documents XBLNR / WRBTR / BELNR / GJAHR / BUZEI

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

EBKPF Accounting Document Header (docs from GLSBK / BELNR / GJHAR / GLEBK

External Systems)

FRUN Run Date of a Program PRGID

KLPA Customer / Vendor Linking NKULI / NBUKR / NKOAR / PNTYP

/ VKULI / VBUKR / VKOAR

KNB4 Customer Payment History KUNNR / BUKRS

KNB5 Customer Master Dunning Data KUNNR / BUKRS / MABER

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

KNC1 Customer Master Transaction Figures KUNNR / BUKRS / GJHAR

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

Figures

LFB5 Vendor Master Dunning Data LIFNR / BUKRS / MABER

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

LFC1 Vendor Master Transaction Figures LIFNR / BUKRS / GJHAR

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

Figures

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

FBASCORE Financial Accounting General Services “Basis”

KNB1 Customer Master (Company Code) KUNNR / BUKRS

LFA1 Vendor Master (General Section) LIFNR

LFB1 Vendor Master (company Code Section) LIFNR / BUKRS

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

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

Description)

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

MHNK Dunning Data (Account Entries) 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 – SPRAS / KTOPL / SAKNR / SCHLW

Key Word list)

SKB1 G/L Account Master (Company Code) 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 BUKRS / SAKNR

FI-GL-GL (FFE) General Ledger Accounting: Basic

Functions - Fast Data Entry

KOMU Account Assignment Templates for G/L KMNAM / KMZEI

Account items

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

KNKA Customer Master Credit Management : KUNNR

Central Data

KNKK Customer Master Credit Management : KUNNR / KKBER

Control Area Data

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

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

Information System

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

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

CHECT

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

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

F111G Global Settings for Payment Program for MANDT

Payment Requests

FDZA Cash Management Line Items in Payment KEYNO

Requests

PAYRQ Payment Requests KEYNO

What is the table name for G/L Master data, when we create centrally (T.Code - FS00)?

As far as general ledger master data is concerned, the following tables are involved :

Table name : SKB1 : G/L Account Master ( Company Code)

Fields:

BUKRS : Company Code

SAKNR : G/L Account

Table name : SKA1 : G/L Account Master ( Chart of Accounts )

Fields:

KTOPL : Char of Accounts

SAKNR : G/L Account

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

Fields:

SPRAS : Language

KTOPL : Char of Accounts

SAKNR : G/L Account

Regards

Gaurav

Re: tables

Former Member — Tue, 10 Jul 2007 09:17:39 GMT

BSEG

BSIK

BSAK

BSAD

PAYR

BKPF

BVOR

Re: tables

Former Member — Tue, 10 Jul 2007 09:17:43 GMT

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

Regards,

Pavan P.

Re: tables

Former Member — Tue, 10 Jul 2007 09:17:44 GMT

Hi,

FI tables are..........

Check this -

http://searchsap.techtarget.com/searchSAP/downloads/Teach_yourself_SAP_C20.pdf#search=%22CREATE%20REPORT%20USING%20SQVI%20%2C%20SAP%22

***do rewards if usefull

vijay

Re: tables

Former Member — Tue, 10 Jul 2007 09:18:07 GMT

hi,

FI 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

Re: tables

Former Member — Tue, 10 Jul 2007 09:18:51 GMT

chk this

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

Re: tables

Former Member — Tue, 10 Jul 2007 09:19:21 GMT

Hi,

Important Tables in SAP FI

Financial Accounting

Table Name Description Important Fields

Financial Accounting

FBAS Financial Accounting “Basis”

BKPF Accounting Document Header BUKRS / BELNR / GJAHR

BSEG Accounting Document Segment BUKRS / BELNR / GJAHR / BUZEI

BSIP Index for Vendor Validation of Double BUKRS / LIFNR / WAERS / BLDAT /

Documents XBLNR / WRBTR / BELNR / GJAHR / BUZEI

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

EBKPF Accounting Document Header (docs from GLSBK / BELNR / GJHAR / GLEBK

External Systems)

FRUN Run Date of a Program PRGID

KLPA Customer / Vendor Linking NKULI / NBUKR / NKOAR / PNTYP

/ VKULI / VBUKR / VKOAR

KNB4 Customer Payment History KUNNR / BUKRS

KNB5 Customer Master Dunning Data KUNNR / BUKRS / MABER

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

KNC1 Customer Master Transaction Figures KUNNR / BUKRS / GJHAR

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

Figures

LFB5 Vendor Master Dunning Data LIFNR / BUKRS / MABER

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

LFC1 Vendor Master Transaction Figures LIFNR / BUKRS / GJHAR

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

Figures

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

FBASCORE Financial Accounting General Services “Basis”

KNB1 Customer Master (Company Code) KUNNR / BUKRS

LFA1 Vendor Master (General Section) LIFNR

LFB1 Vendor Master (company Code Section) LIFNR / BUKRS

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

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

Description)

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

MHNK Dunning Data (Account Entries) 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 – SPRAS / KTOPL / SAKNR / SCHLW

Key Word list)

SKB1 G/L Account Master (Company Code) 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 BUKRS / SAKNR

FI-GL-GL (FFE) General Ledger Accounting: Basic

Functions - Fast Data Entry

KOMU Account Assignment Templates for G/L KMNAM / KMZEI

Account items

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

KNKA Customer Master Credit Management : KUNNR

Central Data

KNKK Customer Master Credit Management : KUNNR / KKBER

Control Area Data

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

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

Information System

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

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

CHECT

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

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

F111G Global Settings for Payment Program for MANDT

Payment Requests

FDZA Cash Management Line Items in Payment KEYNO

Requests

PAYRQ Payment Requests KEYNO

Important Tables in SAP CO

Controlling

Table Name Description Important Fields

AUSP Characteristic Values MANDT / OBJEK / ATINN / ATZHL

CO-KBAS Overhead Cost Controlling

A132 Price per Cost Center MANDT / KAPPL / KSCHL / KOKRS

A136 Price per Controlling Area MANDT / KAPPL / KSCHL / KOKRS

A137 Price per Country / Region MANDT / KAPPL / KSCHL / KOKRS

COSC CO Objects: Assignment of Origina MANDT / OBJNR / SCTYP / VERSN

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

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

KAPS CO Period Locks MANDT / KOKRS / GJAHR / VERSN

CO-KBASCORE Overhead Cost Controlling: General Services

CSKA Cost Elements (Data Dependent on MANDT / KTOPL / KSTAR

CSKB Cost Elements (Data Dependent on 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 MANDT / KOKRS / BELNR / BUZEI

COEJL CO Object: Line Items for Activit MANDT / KOKRS / BELNR / BUZEI

COEJR CO Object: Line Items for SKF (by MANDT / KOKRS / BELNR / BUZEI

COEJT CO Object: Line Items for Prices MANDT / KOKRS / BELNR / BUZEI

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

COEPL CO Object: Line Items for Activit MANDT / KOKRS / BELNR / BUZEI

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

COEPT CO Object: Line Items for Prices MANDT / KOKRS / BELNR / BUZEI

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

COKL CO Object: Control Data for Activ MANDT / LEDNR / OBJNR / GJAHR

COKP CO Object: Control Data for Prima MANDT / LEDNR / OBJNR / GJAHR

COKR CO Object: Control Data for Stati MANDT / LEDNR / OBJNR / GJAHR

COKS CO Object: Control Data for Secon MANDT / LEDNR / OBJNR / GJAHR

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

COFI01 Object Table for Reconciliation L MANDT / OBJNR

COFI02 Transaction Dependent Fields for MANDT / OBJNR

COFIP Single Plan Items for Reconciliat RCLNT / GL_SIRID

COFIS Actual Line Items for Reconciliat 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

A139 Price per Profit Center MANDT / KAPPL / KSCHL / KOKRS

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

AUAA Settlement Document: Receiver Seg MANDT / BELNR / LFDNR

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

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

AUAK Document Header for Settlement MANDT / BELNR

AUAO Document Segment: CO Objects to b MANDT / BELNR / LFDNR

AUAV Document Segment: Transactions MANDT / BELNR / LFDNR

COBRA Settlement Rule for Order Settlem MANDT / OBJNR

COBRB Distribution Rules Settlement Rul 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 Da MANDT / SPRAS / PRCTR / DATBI

CEPC_BUKRS Assignment of Profit Center to a 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 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 Receive MANDT / KAPPL / KSCHL / KOKRS

A142 Dependent on Material MANDT / KAPPL / KSCHL / WERKS

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

Important Tables in SAP AA

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

ANKA Asset Classes: General Data ANLKL

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

of Depreciation

ANKT Asset Classes: Description SPRAS / ANLKL

ANKV Asset Classes: Insurance Types ANLKL / VRSLFD

ANLA Asset Master Record Segment BUKRS / ANLN1 / ANLN2

ANLB Depreciation Terms BUKRS / ANLN1 / ANLN2 / AFABE

/ BDATU

ANLT Asset Texts SPRAS / BUKRS / ANLN1 / ANLN2

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

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

GJAHR

ANLX Asset Master Record Segment BUKRS / ANLN1 / ANLN2

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

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

ANAR Asset Types ANLAR

ANAT Asset Type Text SPRAS / ANLAR

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

Asset Accounting

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

LNRAN

ANEP Asset Line Items BUKRS / ANLN1 / ANLN2 / GJAHR /

LNRAN / AFABE

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

LNRANS

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

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

AFABE

ANLH Main Asset Number BUKRS / ANLN1

ANLP Asset Periodic Values 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 SUBSTID

GB93 Validation VALID

Regards,

Bhaskar