Tables

[#1]

Hi

can any one give the list of tables related to Vendors, customer, materials, assets and of controlling

thanx in advance

[Former Member · Accepted solution]

Hi Aparna,

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 organisation data

LFM2 Purchasing data

LFBK Bank details

============================================================

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

===========================================================

Controlling

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

Hope this helps. please assign points.

Rgds

manish

[Former Member]

Table Name Description

Financial Accounting

FBAS -

---

Financial Accounting “Basis”

BKPF -

---

Accounting Document Header

BSEG -

---

Accounting Document Segment

BSIP -

---

Index for Vendor Validation of Double Documents

BVOR -

---

Inter Company Posting Procedure

EBKPF -

---

Accounting Document Header (docs from External Systems)

FRUN -

---

Run Date of a Program

KLPA -

---

Customer / Vendor Linking

KNB4 -

---

Customer Payment History

KNB5 -

---

Customer Master Dunning Data

KNBK -

---

Customer Master Bank Details

KNC1 -

---

Customer Master Transaction Figures

KNC3 -

---

Customer Master Special GL Transactions Figures

LFB5 -

---

Vendor Master Dunning Data

LFBK -

---

Vendor Master Bank Details

LFC1 -

---

Vendor Master Transaction Figures

LFC3 -

---

Vendor Master Special GL Transactions Figures

VBKPF---- Document Header for Document Parking

FBASCORE---- Financial Accounting General Services “Basis”

KNB1 -

---

Customer Master (Company Code)

LFA1 -

---

Vendor Master (General Section)

LFB1 -

---

Vendor Master (company Code Section)

SKA1 -

---

G/L Account Master (Chart of Accounts)

SKAT -

---

G/L Account Master (Chart of Accounts – Description)

MAHNS---- Accounts Blocked by Dunning Selection

MHNK -

---

Dunning Data (Account Entries)

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

SKAS -

---

G/L Account Master (Chart of Accounts – Key Word list))

SKB1 -

---

G/L Account Master (Company Code)

FI-GL-GL (FBSC) -

---

General Ledger Accounting: Basic Functions - R/3 Customizing for G/L Accounts

FIGLREP----Settings for G/L Posting Reports

TSAKR -

---

Create G/L account with reference

FI-GL-GL (FFE) -

---

General Ledger Accounting: Basic Functions - Fast Data Entry

KOMU -

---

Account Assignment Templates for G/L Account items

FI-AR-AR (FBD) -

---

Accounts Receivable: Basic Functions - Customers

KNKA -

---

Customer Master Credit Management : Central Data

KNKK -

---

Customer Master Credit Management : Control Area Data

KNKKF1 -

---

Credit Management : FI Status data

RFRR -

---

Accounting Data – A/R and A/P Information System

FI-BL-PT (BFIBL_CHECK_D) -

---

Bank Accounting: Payment Transactions – General Sections

PAYR -

---

Payment Medium File

PCEC -

---

Pre-numbered Check

FI-BL-PT-AP(FMZA) -

---

Bank Accounting: Payment Transactions – Automatic Payments

F111G -

---

Global Settings for Payment Program for Payment Requests

FDZA -

---

Cash Management Line Items in Payment Requests

PAYRQ -

---

Payment Requests

FI-AA-AA (AA) -

---

Asset Accounting: Basic Functions – Master Data

ANKA -

---

Asset Classes: General Data

ANKP -

---

Asset Classes: Fld Cont Dpndnt on Chart of Depreciation

ANKT -

---

Asset Classes: Description

ANKV -

---

Asset Classes: Insurance Types

ANLA -

---

Asset Master Record Segment

ANLB -

---

Depreciation Terms

ANLT -

---

Asset Texts

ANLU -

---

Asset Master Record User Fields

ANLW -

---

Insurable Values (Year Dependent)

ANLX -

---

Asset Master Record Segment

ANLZ -

---

Time Dependent Asset Allocations

[Former Member]

SKA1 G/l accounts

SKAT G/l accounts texts

SKB1 G/l accounts company level

CSKS Cost centers

CSKB Cost elements

CEPC Profit centers

ANLA Assets masterdata

ANLB Assets depreciation masterdata

ANLC Asset values by year

ANLZ Time dependent fields

Offen you can found the tables in the transaction SARA (archiving) from there you can see the tables used

Paul