SAP R/3 Main Tables Overview
Translated by
ScribdTranslationsSAP R/3 Main Tables Overview
Translated by
ScribdTranslationsIntroduction to SAP R/3/Main tables
< Introduction to SAP R/3
Go to navigationin the search
SAP system tables
Module Table Description
MM MARA General data of a material
MM MAKT Description of the material
MM MARM Units of measurement of a material
WM LQUA Inventory at location level
MM EKKO Purchase Order Header
MM EKPO Purchase order release
MM EKBE Purchase Order History
MM EKES Purchase order deliveries
MM EKET Delivery plan for a purchase order
MM EKPV Delivery plan for a purchase order
MM LTBK Header of a transportation need (TN)
MM LTBP Items of a transport need (NT)
MM LTAK Header of a transport order (TO)
Module Table Description
MM LTAP Open transportation order items
MM LIKP Delivery document header
MM LIPS Items of a delivery document
FI LFA1 General supplier data
FI LFB1 General supplier data at the company level
FI LFM1 General data of supplier at the organizational purchasing level
FI LFM2 General supplier data at the plant level.
TABLES BY CATEGORIES
Materials and production
Master of materials
Table Description Comment
MAKT Descriptions of material
MARA General data
MARC Material per center
MARD Warehouse/Batch Segment
MARM Units of measurement
MBEW Valuation-material
Table Descripción Comment
MEAN Number of European articles on mat
MKAL Fabric versions of the material
MLAN Classification of taxes mat
MLGN Mat data by warehouse number
MLGT Data mat by warehouse type
MOFF Masters of math still open
MSTA Materials teacher status
MVKE Sales data
2. Gestión de stocks 2.1. Estado de los stocks
Table Description Comment
MARD Stock by center/warehouse
MCHB Batch stocks
MSLB Special stock at supplier
MKOL Special stocks from the supplier
MSSL Special stock sum at supplier
2.2. Material documents
Table Description Comment
MKPF Header of the doc-material
Section of the document.
MSEG It contains the movement class of the material
mat
Reservation/needs The reservation number in the MKPF. From production, we
RESB
secondary schools link via AFKO-RSNUM
Texts class of
T156T
movement
3. Needs Planning
Table Description Comment
Characteristic. Planner of
MARC Material by center
needs
MDKP Header data of the planning document By planning character
MDVM Planning Request
T438M Planning Group
T399D Center data for needs planning
Designation of the planning element of
T457T
needs
4. Pre-planned need
Table Description Comment
PBIM Index of primary needs by material By class/version/plan-need pointer of need
Table Description Comment
PBED Primary nec. material data
MDPB MRP View
5. Forecasts
Table Descripción Comment
MAPR Materials index for forecasts
PROP Forecasting parameters
PROW Forecast values
PROF Forecast error
MVER Material consumption
6. Provisional order
Table Description Comment
PLAF Provisional order
7. Warehouse Management (SAP-WM)
7.1. Warehouses
Table Description Comment
LAGP Locations
LQUA How much storage
7.2. Transport order
Table Description Comment
LTAK Header data
LTAP Position data
7.3. Need for transport
Table Description Comment
LTBK Header data
LTBP Position data
7.4. Inventory document
Table Description Comment
LINK Inventory doc header
LINP Inventory doc position
LINV Inventory data for how much
8. Lots
Table Description Comment
MCHA Stock by material/center/batch Definition
MCHB Lot stocks Quantities
9. Manufacturing Orders
Table Description Comment
AFKO Header of OF
AFPO Position of OF
AUFK Master data OF At the header level
AFRU Notifications OF
Order operation. Elaborate key = AFKO-
AFVC Operations of an order
AUFPL
AFVV Operation ctd/dates/values Times
User positions of
AFVU Predefined values, times, transit...
operation
CAUFV View of the OF Header (assignment, dates/quantity)
TJ02T Texts for the status Relation between the order status description and the status
MDFA View of OF for MD
10. Material lists
Table Description Comment
All materials lists (combinations of
MAST Material/list of materials
alternatives and utilization
STKO Header materials list
STOP Components list materials
Table Description Comment
List of materials-selection of
STAS STKO-STPO link for different alternatives
positions
11. Roadmaps
Table Description Comment
MAPL Material/roadmaps
PLKO Header roadmap
PLPO Operations roadmaps PLKO-PLPO link for different alternatives
PLAS Selection of operations TJ02T–Text status
JEST Individual status by object
12. Job Positions
Table Description Comment
Header of the position of Accessed by an ID that is in the AFVC (field
CRHD
work ARBID
HOW Capacity Access is through an ID that is in the CRHD.
13. Serial numbers
Table Description Comment
EQUI Serial numbers for materials
Purchases
Master of suppliers
Table Descripción Comment
LFA1 Master data
LFB1 Suppliers by company
LFB5 Claim data
LFBK Banks/accounts
LFC1 Figures of movements
LFC3 CME movement figures
LFM1 Datos de la organización de compras
2. Purchase documents
Table Description Comment
Contains the type of
EKKO Header of the purchase document
document
EKPO Position of the purchasing document
EKET Distribution of the delivery plan
EKES Order confirmations
EKKN Allocation in the document
EKAN Supplier address in the purchase document
Table Description Comment
EKBE History for the doc.
EKUB Order index for material transfer
Reading view on request for transfer for taking-
MDUB
order
MDBS View of material in order/distribution position
EKBZ History for purchase document - Costs Contains Conditions Costs
3. Order Request
Table Description Comment
EBAN Request for order by position
EBKN Order request input
4. Order Book
Table Descripción Comment
EORD Purchase order book
5. Purchase info registration
Table Description Comment
EINA General data
A Data from the purchasing organization
Table Description Comment
KONP Conditions
EIPA Order price history of the record info
6. Purchase Invoices
Table Description Comment
RBKP Header of received invoice document
RSEG Position of received invoice document
RBCO [Link], invoice received, allocation
Sales
Customer Master
Table Description Comment
KNA1 Master data of customers
KNB1 Clients by company
KNBK Banks/accounts
KNVA Unloading places
KNVK Contact person (interlocutor)
The PARVW field differentiates between the different
KNVP Functions of interlocutor
interlocutors
Table Description Comment
KNVS Expedition data
KNVV Commercial data
Interlocutor (people of
KNVK
contact
Commercial Documents
Table Description Comment
VBUK Header status and management data
VBUP Position Status
VBFA Flow of commercial documents
VBPA Interlocutor
3. Sales Orders
Table Descripción Comment
VBAK Header
VBAP Position
VBFA Flow of commercial documents
VBKD Commercial data
VBEP Delivery data
4. Deliveries
Table Description Comment
LIKP Header data
LIPS Position data
LQUA How many/storage
5. Organizational structure
Table Description Comment
TVKO Sales organizations View V_TVKO_LK
TVKOT Texts org. Sales
TVKOV Distribution channels by sales organization View V_TVKOV_LK
TVKOS Sales Organization Sectors View V_TVKOS_LK
TVTA Áreas de ventas View V_TVTA_LK
TVKBZ Sales Office by Sales Area View V_TVKBZ_LK
TVBVK Group sellers by sales office View V_TVBVK_LK
TVKWZ Centers for sales organization View V_TVKWZ_LK
TVSWZ Dispatch locations by center View V_TVSWZ_LK
T001K View V_T001K
Invoices
Table Description Comment
VBRK Header data
VBRP Position data
7. Sales Index
Table Description Comment
VAKPA Orders by interlocutor function
VAPMA Order positions by material
8. Sales Needs
Table Descripción Comment
VBBE Individual sales need record
Classification system
Classes
Table Description Comment
KLAH Header data class Class and category Internal class number
KSML Characteristics of classes Núm interno clase Núm interno característica
KSSK Assignment table: object to class
2. Characteristics
Table Description Comment
CABN Characteristics Internal characteristic number
CAWN Values of the characteristics Internal num char values char
CAWNT Texts for the values
Internal number assignment to a To access AUSP for class features
INOB
object new
Eigenvalues of the
AUSP
characteristics
Finance
1. Accounting document
Table Description Comment
BKPF Document header for accounting
BSEG Segment of accounting document
2. Accounting (secondary indices)
Table Description Comment
BSAD For debtors ([Link].)
BSAK For creditors ([Link].)
BSAS For general accounts ([Link])
BSID For debtors
Table Description Comment
BSIK For creditors
BSIM For documents by material
BSIP For verification of double documents from creditors
BSIS For major accounts
BSIW For debtor purposes
BSIX For debtor purposes
3. Master of the general ledger
Table Description Comment
SKB1 Major Account (society)
SKAT Main Account (chart of accounts: designation)
4. Maestro of banks
Table Description Comment
BNKA Bank Master
5. Cost calculation
Table Description Comment
SKB1 Major account (society)
SKAT Account. Mayor (chart of accounts: denomination)
Various
Development environment
Table Description Comment
TBTCO Summary of job status
Selection condition variables
STXH STXD SAPscript file header text
TTXER Text Treatment: text ID groups
2. Configuration
Table Descripción Comment
T001 Companies
T001L Warehouses
Centers/branches
T005 Countries
T005T Country names
T005U Impuestos: provincia: textos
T006 Units of measurement
T009 Exercise variants
T024W Allowed purchases for center
Table Description Comment
T151T Debtors: client groups: texts
T171T Debtors: sales areas: texts
T460A Special collection key
T882 Assignment society FI
TFACS Factory Calendar
TPFKT Debtors: interlocutor: texts
TSPAT Unid. Org.: commercial sectors: texts
TVAGT Doc-sales: reason for rejection: texts
TVAKT Doc-ventas: clases: textos
TVAPT Sales Document: position types: texts
TVAUT Sales Document: order reasons: texts
TVGRT Unit of org.: selling groups: texts
TVKBT unid. of org.: sales offices: texts
TVKOT Unid. org.: sales organizations: texts
TVRO Routes
Table Description Comment
TVROT Text Routes
TVTWT Unid. org: distribution channels: texts
TVZBT Debtors: payment conditions: texts
3. Pricing conditions
Table Description Comment
KONH Header
KONP Position
KOND Data
KONV Operation data
4. Quota files
Table Description Comment
EQUK Header
EQUP Position
5. Modification documents
Table Description Comment
CDHDR Header
Table Description Comment
CDPOS Position
6. Address Management
Table Description Comment
SADR Company data
7. Order series