Re: Table List

GauthamV — Mon, 09 Jun 2008 12:24:47 GMT

hi,

Common Tables used by SAP MM

Below are few important Common Tables used in Materials Management Modules:

EINA Purchasing Info Record- General Data

EINE Purchasing Info Record- Purchasing Organization Data

MAKT Material Descriptions

MARA General Material Data

MARC Plant Data for Material

MARD Storage Location Data for Material

MAST Material to BOM Link

MBEW Material Valuation

MKPF Header- Material Document

MSEG Document Segment- Material

MVER Material Consumption

MVKE Sales Data for materials

RKPF Document Header- Reservation

T023 Mat. groups

T024 Purchasing Groups

T156 Movement Type

T157H Help Texts for Movement Types

MOFF Lists what views have not been created

A501 Plant/Material

EBAN Purchase Requisition

EBKN Purchase Requisition Account Assignment

EKAB Release Documentation

EKBE History per Purchasing Document

EKET Scheduling Agreement Schedule Lines

EKKN Account Assignment in Purchasing Document

EKKO Purchasing Document Header

EKPO Purchasing Document Item

IKPF Header- Physical Inventory Document

ISEG Physical Inventory Document Items

LFA1 Vendor Master (General section)

LFB1 Vendor Master (Company Code)

NRIV Number range intervals

RESB Reservation/dependent requirements

T161T Texts for Purchasing Document Types

SAP MM Tips by : Bahadur

Following are the list of Important MM tables. Please check if its useful.

Inventory Management:

---- ----
	Table	Description
---- ----
Material	MSEG	Material document / transaction details
Document/Movements	MKPF	Material document header information
---- ----
Material Stock Balances	MARD	Material stock
	MBEW	Material stock with valuation
---- ----
Sales Order Stock	MSKA	Stock balance with associated sales
		order data
---- ----
Stock Transport	EKUB	Index for Stock Transport Orders for
	MDUB	Material
		Reading View of Stock Transport Ord. for
		Release Ord.
---- ----
Special Stocks	MKOL	Consignment, material provided to
		vendor, etc.
---- ----

Material Master Data:

---- ----
	Table	Description
---- ----
Materials	MARA	General Data, material type, group,
		configurable & batch ind.
	MAKT	Short Texts, descriptions
	MARM	Conversion Factors
	MVKE	Sales Org, distribution channel
	MLAN	Sales data, tax indicator, tax
	MARC	classification
	MBEW	Plant Planning Data
	MLGN	Valuation Data
	MLGT	Warehouse Management Inventory Data
	MVER	Warehouse Management Storage Type
	MAPR	Data
	MARD	Consumption Data
	MCHA	Pointer for Forecast Data
	MCHB	Storage location data with stock
		balances
		Batches
		Batch Stocks

All The Tables In SAP MM Purchasing

Please find all tables in MM-PUR (Purchasing) :

EBAN - Purchase Requisition

EBKN - Purchase Requisition Account Assignment

EBUB - Index for Stock Transport Requisitions for Materi

EINA - Purchasing Info Record: General Data

EINE - Purchasing Info Record: Purchasing Organization D

EIPA - Order Price History: Info Record

EKAB - Release Documentation

EKAN - Vendor Address: Purchasing Document

EKBE - History per Purchasing Document

EKBEH - Removed PO History Records

EKBZ - History per Purchasing Document: Delivery Costs

EKBZH - History per Purchasing Document: Delivery Costs

EKEH - Scheduling Agreement Release Documentation

EKEK - Header Data for Scheduling Agreement Releases

EKES - Vendor Confirmations

EKET - Scheduling Agreement Schedule Lines

EKETH - Scheduling Agreement Schedules: History Tables

EKKI - Purchasing Condition Index

EKKN - Account Assignment in Purchasing Document

EKKO - Purchasing Document Header

EKPA - Partner Roles in Purchasing

EKPB - "Material Provided" Item in Purchasing Document

EKPO - Purchasing Document Item

EKPV - Shipping-Specific Data on Stock Tfr. for Purch. D

EKRS - ERS Procedure: Goods (Merchandise) Movements to b

EKUB - Index for Stock Transport Orders for Material

EORD - Purchasing Source List

EQUK - Quota File: Header

EQUP - Quota File: Item

T024 - Purchasing Groups

T024E - Purchasing Organizations

T024W - Valid Purchasing Organizations for Plant

T024Z - Purchasing Organizations

T027A - Shipping Instructions, Purchasing

T027B - Texts: Shipping Instructions

T027C - Codes for Compliance with Shipping Instructions

T027D - Compliance with Shipping Instructions: Texts

T069 - Certificate Categories

T069Q - Control Data for Source Determination and Checkin

T069T - Certificate Categories: Text Description

T160 - SAP Transaction Control, Purchasing

T160B - SAP Transaction Control, List Displays, Purchasin

T160C - SAP Transaction Control for List Displays in CALL

T160D - Function Authorizations: Purchase Order

T160E - Function Authorizations: Purchasing: Descriptions

T160I - Control of Intrastat Reports

T160J - Text Table for Intrastat Reports

T160L - Scope of Purchasing Lists

T160M - Message Control: Purchasing (System Messages)

T160O - Description of Scope of List

T160P - Entities Table Routines

T160Q - Scope of List: Buyer's Negotiation Sheet: Routine

T160R - Routines for Buyer's Negotiation Sheet

T160S - Selection Parameters for Purchasing Lists

T160T - Description of Selection Parameters

T160V - Default Values for Purchasing

T160W - Description for Default Values for Purchasing Ope

T160X - Scope of List: Buyer's Negotiation Sheet

T160Y - Scope of List: Buyer's Negotiation Sheet: Descrip

T161 - Purchasing Document Types

T161A - Linkage of Requisition Doc. Type to Purchasing Do

T161B - Default Business Transaction Type for Import

T161E - Release Codes

T161F - Release Point Assignment for Purchase Requisition

T161G - Release Prerequisite, Purchase Requisition

T161H - Fields for Release Procedure, Purchase Requisitio

T161I - Determination of Release Strategy

T161M - Fine-Tuned Control: Message Types

T161N - Message Determination Schemas: Assignment

T161P - Check of Document Type, Document Category, Item C

T161R - REORG Control, Purchasing

T161S - Release Indicator, Purchase Requisition

T161T - Texts for Purchasing Document Types

T161U - Texts for Release Indicator

T161V - Shipping-Specific Data for Stock Tfr. for Purch.

T161W - Order Types for Stock Transfer

T161Z - Additional Checks for Outline Agreements on Reorg

T162 - Field Selection, Purchasing Document

T162K - Field Selection, Account Assignment Fields, Purch

T162T - Description of Field Selection Reference Key

T162X - Description of Field Groups from T162/T162K

T162Y - Groups: Field Selection

T163 - Item Categories in Purchasing Document

T163A - Check Item Category/Account Assignment Category

T163B - Purchase Order History Categories

T163C - Texts for Purchase Order History Categories

T163D - Assignment Internal/External Confirmation Categor

T163E - Confirmation Categories

T163F - Confirmation Categories: Descriptions

T163G - Confirmation Control

T163I - Texts for Account Assignment Categories

T163K - Account Assignment Categories in Purchasing Docum

T163KS - Assignment of Tax Indicator to Account Assignment

T163L - Confirmation Control Keys

T163M - Confirmation Control Keys: Description

T163P - Release Creation Profile

T163S - Description for Release Creation Profile

T163X - "Zombie" T163X

T163Y - Texts for Item Categories

T165K - Copying Options: Header Texts

T165P - Copying Options: Item texts

T166A - Supplement Text in Purchasing Document Printouts

T166C - Print-Relevant Purchasing Document Changes

T166K - Header Texts in Purchasing Document Printouts

T166P - Item Texts in Purchasing Document Printouts

T166T - Change Texts in Purchasing Document Printouts

T166U - Headings in Purchasing Document Printout

T167 - Number Range Management for Purchasing Master Dat

T167T - Transaction Description

T168 - Screen Control, Purchasing

T168F - Function Codes, Purchasing

T168T - Screen Titles

T16FB - Release Indicators: Purchasing Document

T16FC - Release Codes

T16FD - Description of Release Codes

T16FE - Descriptions of Release Indicators: Purchasing Do

T16FG - Release Groups

T16FH - Descriptions of Release Groups

T16FK - Release Statuses

T16FS - Release Strategies

Important Tables in SAP FI

Financial Accounting

Table Name Description Important Fields

Financial Accounting

FBAS Financial Accounting u201CBasisu201D

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 u201CBasisu201D

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 u2013 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 u2013 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 u2013 A/R and A/P RELID / SRTFD / SRTF2

Information System

FI-BL-PT Bank Accounting: Payment (BFIBL_CHECK_D) Transactions u2013 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 u2013 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 *-- Viji Balakrishnan

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) u2013 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 u2013 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 u2013 Master Data 2.0

ANAR Asset Types ANLAR

ANAT Asset Type Text SPRAS / ANLAR

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

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

reward points if hlpful.

topic Re: Table List in Application Development and Automation Discussions

Table List

Re: Table List

Re: Table List

Re: Table List

Re: Table List