Dictionary of SAP standard tables

Introduction

SAP uses tables to store information, such as the parameterization of the actual data.   The tables contain one or more key fields, and they relate to each other through common fields. Besides the standard tables can also create tables for their own use, which SAP always recommends that the name begins with the letter Z.

The fastest way to access tables is using transaction SE16 Display tables or SM30 Modifying tables (not recommended).    Once you went into a table,  we can choose the view to display the names of the fields or   the technical name of SAP, for it you will go to Settings / User Parameters...  and change the following option:

Tables of Finance   (FI-CO)

1. Accounting documents

Table	Description
BKPF	Accounting document header
BSEG	Accounting document segment

2. Accounting (secondary indexes)

Table	Description
BSIS	G/L Accounts (open items)
BSAS	G/L Accounts (cleared items)
BSID	Customers (open items)
BSAD	Customers (cleared items)
BSIK	Vendors (open items)
BSAK	Vendors (cleared items)
BSIP	Double document verification vendors
BSIM	Documents for Material
BSIW	Effects of customers
BSIX	Effects of customers (used)

3. Major Account Master

Table	Description
SKA1	Acct. G/L (Level Plan)
SKAT	Acct. G/L (Level Plan Designation)
SKB1	Acct. G/L (Level Company)

4. Master of banks

Table	Description
BNKA	Master of banks
LFBK	Master Bank Vendors
KNBK	Master Bank Customers

5. Controlling

Table	Description
CSKA	Cost Elements
CSKB	Cost Elements (by Company)
CSKU	Cost Elements (Title)
CSKS	Master Cost Centers
CECP	Profit Centers
CECPT	Profit Centers - Title
KEKO	Header: calc. cost
KEPH	Elements of production costs of calc.
COSS	CO Object: Cost Totals internal postings
COST	Costs of a class of activity per period
CEPC	Master Data Profit Centers
TKA01	Societies CO
TKEAS	Derivation rules
TCKH3	Int allocation. schema elements (data KEPH)

6. Fixed Assets (AM)

Table	Description
ANLA	Asset Master - Record High
ANLB	Parameters amortization
ANEK	Doc header. Accounting AM
ANEP	Individual entries AM
ANLZ	Cost Centers Assignment
ANAR	Asset Classes
ANAT	Asset Classes (Lyrics)

Tables Sales (SD)

1. Customer Master

Table	Description
KNA1	Customer Master Data (General)
KNB1	Customer Master Data (by Company)
KNBK	Customer Data Banks
KNVA	Download locations
KNVK	Contact person (partner)
KNVP	Partner functions
KNVS	Shipping data
KNVV	Commercial data
KNVK	Questioner (contact persons)
ADRC	Phones data
ADR2	Phones data
ADR6	E-mails data

2. Business Documents

Table	Description
VBUK	Status header and data management
VBUP	Position Status
VBFA	Flow doc. commercial
VBPA	Interlocutor

3. Sales Orders

Table	Description
VBAK	Head
VBAP	Position
VBFA	Flow doc. commercial
VBKD	Corporate information
VBEP	Data sharing

4. Deliveries

Table	Description
LIKP	Header Data
LIPS	Position data
LQUA	How / storage

5. Organizational Structure Information

Table	Description	Comment
TVKO	Sales Organizations	View V_TVKO_LK
TVKOT	Texts org. Sales
TVKOV	Org distribution channels. sales	View V_TVKOV_LK
TVKOS	Sectors pro org. sales	View V_TVKOS_LK
TVTA	Sales areas	View V_TVTA_LK
TVKBZ	Sales Office by sales area	View V_TVKBZ_LK
TVBVK	Group sales office sellers	View V_TVBVK_LK
TVKWZ	Centers for org. sales	View V_TVKWZ_LK
TVSWZ	Center locations expedition	View V_TVSWZ_LK
T001K	Valuation area	View V_T001K

6. Invoices

Table	Description
VBRK	Header Data
VBRP	Position data

7. Sales index

Table	Description
VAKPA	Orders interlocutor function
VAPMA	Positions request for material
VRKPA	Invoices interlocutor function
VRPMA	Position bill for materials

8. Needs Sales

Table	Description
VBBE	Individual record sales of need

Purchasing Tables (MM)

1. Supplier Master

Table	Description
LFA1	Master Vendor (General)
LFB1	Master Vendor (Company)
LFM1	Master Vendor (Sorting Shopping)
LFM2	Master Vendor (Sorting Shopping)
LFBK	Data Banks
LFBW	Type Retention
LFZA	Receivers alternative payment
LFC1	Turnover
LFC3	Turnover CME
LFB5	Claim Data
ADRC	Phones data
ADR2	Phones data
ADR6	E-mails data

2. Purchasing documents

Table	Description
EKKO	Doc header. Shopping
EKPO	Doc position. Shopping
Eket	Distributions of scheduling
Ekes	Order Confirmations
EKKN	Imputation in document
Ekan	Address Vendor in the doc. Shopping
EKBE	History to the doc.
EKUB	Index for material transfer orders
MDUB	Having read about transfer request for decision-Order
MDBS	View order item material / delivery

3. Requisitioning

Table	Description
EBAN	Request by pedal position
EBKN	Allocation of purchase requisition

4. Order-book

Table	Description
EORD	Book purchase orders

5. Purchasing info record

Table	Description
EINA	General Information
EINE	Data from the purchasing organization
KONP	Terms
EIPA	Price History Registry Order info

Tables and Production Materials Management (MM)

1. Material Master

Table	Description
MARA	General Information
Makt	Material Descriptions
MARC	Material for center
MARD	Segment warehouse / batch
MARM	Units
MBEW	Rating-material
MEAN	Item No. European sea
MKAL	Versions material fabr
MLAN	Classification taxes sea
MLGN	Data warehouse mat by No.
MLGT	Data for storage type mat
MOFF	Teachers still open sea
MSTA	Material Master Status
MVKE	Sales Data

2. Inventory Management

Table	Description
MARD	Stock for center / warehouse
MCHB	Batch Stocks
MSLB	Special Stock at supplier
MKOL	Special Stocks Supplier
MSSL	Sum special stock Vendor

3. Documents material

Table	Description	Comment
MKPF	Header doc-material
MSEG	Document Segment-mat	Class contains material mov
RESB	Reservation / dependent requirements	The reservation number is in the MKPF. Since production is linked through Afko-RSNUM
T156T	Texts motion class

4. MRP

Table	Description	Comment
MARC	Material for center	Char. Planner needs
MDKP	Data planning doc header	For char. Planning
MDTB	Position doc. Planning	For planning table No.
MDVM	Schedule request
T438M	Task planning
T399D	Data center planning needs
T457T	Name of MRP element

5. Need preplanned

Table	Description	Comment
PBIM	Index nec. primary by material	For class / version / plan-nec - pointer need
PBED	Data nec. primary material
MDPB	View MRP

6. Pronósiticos

Table	Description
MAPR	Prognostic index materials
PROP	Prognostic parameters
PROW	Forecast values
PROF	Forecast error
MVER	Consumption of material

7. Interim Order

Table	Description
PLAF	Orden previsional

Tables Warehouse Management (SAP-WM)

1. Stores

Table	Description
LAGP	Locations
LQUA	How-storage

2. Transport Order

Table	Description
LTAK	Header Data
LTAP	Position data

3. Transport need

Table	Description
LtBk	Header Data
LTBP	Position data

4. Document inventory

Table	Description
LINK	Inventory doc-header
LINP	Doc-inventory position
LINV	Inventory data since

5. Lots

Table	Description	Comment
MCHA	Stock of material / center / lot	Definition
MCHB	Batch Stocks	Quantities

6. Production Orders

Table	Description	Comment
Afko	OF Header
AFPO	Position OF
AUFK	OF Master Data	A header level
Fruity	Notifications OF
AFVC	Operations of an order	Operation of order. Elaborac key ext = Afko-AUFPL
AFVV	Operation ctd / dates / values	Time
AFVU	Operation user dmfs	Defaults, times, transit ...
CAUFV	OF View	Header (assignment, dates / qty)
MDFA	View OF to MD
TJ02T	Texts for the status	Relac. Among the descr status and order status

7. Carts

Table	Description	Comment
MAST	Material / BOM	All bills of materials (combinations of alternatives and use)
STKO	BOM Header
POTS	BOM Components
STAS	BOM-position selection	STKO-POTS link for alternatives

8. Roadmaps

Table	Description	Comment
MAPL	Material / roadmaps
PLKO	Header roadmaps
PLPO	Operations roadmaps	Link PLKO-PLPO for alternatives
JEST	Single Status intended	YJ02T - Text status
PLAS	Selection of operations	STKO-POTS link for alternatives

9. Workstation

Table	Description	Comment
CRHD	Header job	Accessed by an id. That is in the AFVC (cpo ARBID)
KAKO	Capacity	Accessed by an id that is in the CRHD

10. Serial Numbers

Table	Description
EQUI	Serial numbers for materials

Classification System

1. Classes

Table	Description	Comment
Klah	Data class header	Class and category - internal class No.
KSML	Features Class	No. inner-inner class feature
KSSK	Allocation Table: Object to Class

2. Features

Table	Description	Comment
CABN	Features	No internal characteristic feature
CAWN	Characteristic values	No internal char. - Char values.
CAWNT	Texts for values
INOB	No internal assignment to an object	To access features AUSP for new classes
AUSP	Values ​​of the features

General Tables

1. Development Environment

Table	Description	Comment
TBTCO	Summary status of jobs
TVARV	Selection condition variables
STXH	STXD SAPscript text file header
TTXER	Word processing: groups of texts ID

2. General Settings

Table	Description	Comment
TSTC	SAP Transaction List
T001	Societies
T001L	Stores
T001W	Centers / branches
T005	Countries
T005T	Country names
T005U	Taxes: Province: texts
T006	Units
T009	Variants of exercise
T024W	Org. Shopping center allowed for
T151T	Debtors: customer groups: texts
T171T	Debtors: sales areas: texts
T460A	Key special collection
T882	Assignment society FI
TFACS	Calendar factory
TPFKT	Debtors: partner: texts
TSPAT	Units. Org.: Commercial sectors: texts
TVAGT	Doc-sales: rejection reason: texts
TVAKT	Doc-sales: classes: text
TVAPT	Doc-sales: position types: text
TVAUT	Doc-sales: Order reason: texts
TVGRT	Units. of org.: vendor groups: texts
TVKBT	Units. of org.: sales offices: texts
TVKOT	Units. org.: sales organizations: texts
TVRO	Routes
TVROT	Routes texts
TVTWT	Units. org: distribution channels: text
TVZBT	Debtors: Payment Terms: texts

3. Pricing conditions

Table	Description	Comment
Konh	Head
KONP	Position
KOND	Data
KONV	Operating Data

4. Files fees

Table	Description	Comment
EQUK	Head
EQUP	Position

5. Change documents

Table	Description	Comment
CDHDR	Head
CDPOS	Position

6. Address Management

Table	Description	Comment
SADR	Company Details

7. Series Order

Table	Description	Comment
SAFK	Master Data series of order

8. Registration info material

Table	Description
A017	Specific center
A018	Terms of sales for pricing structure

By Miguel Angel Aisa Alcaine