Overview of functional tables


Accounting documents
Bill Of Material
Capacity planning
Classification class types, classifiable objects
Classification characteristics
Cost elements centers and activities
Equipment status system status / user status
Function location and reference function location
General ledger accounts
Goods movement
Inventory document
Maintenance Order PM order
Material document
Orders Purchase orders
Production resource tools PRTs
Purchase Requisition
Purchasing document
Purchasing Info record
Sales document Invoice, delivery, partners, contacts
Sales requirements
Storage locations and stocks
Tasklist General ~, function location ~ or equipment ~
Transfer requirement
User data
Vendor master
Warehouse Management transfer

If the information above is not sufficient, this bit could be interesting to you:

The search for functional tables

Table overview

Accounting BSAD Accounting: Secondary index for customers (cleared items)
BSID Accounting: Secondary index for customers
BSIW Index table for customer bills of exchange used
BSIX Index table for customer bills of exchange used
BSAK Accounting: Secondary index for vendors (cleared items)
BSIK Accounting: Secondary index for vendors
BSIP Index for vendor validation of double documents
BSAS Accounting: Secondary index for G/L accounts (cleared items)
Logical databases: -
Accounting documents BKPF Accounting document header
BSEG Accounting document segment
BSET Tax data document segment
BSEC One-time account data document segment
Logical databases: BRM
Bill Of Material MAST Material to BOM Link
EQST Equipment to BOM Link
STAS BOMs header
STKO BOM header
STPN BOM follow-Up control
STPU BOM sub-item
STST Standard BOM link
STVB Bills of material - Serialization of posting
STZU Permanent BOM data
Logical databases: -
Bill Of Material KBED Capacity requirements record
Logical databases: POH
Classification CABS Result of the Statistical Analysis of Table AUSP
CUFM Customizing: Class/Config: Screendesigner Form
TCME Validity for Global Characteristics
KLAH Class Header Data
KLAT Classes: long texts
KSML Characteristics of a Class
AUSP Characteristic values
SWOR Classification System: Catchwords
KSSK Allocation Table: Object to Class
TCLG Class groups
TCLO Key Fields of Objects
TCLS Classes: Organizational areas
TCLST Classes: Org. Areas (Texts)
TCLU Class Status
COCC PP-PI attributes for characteristics
COFV Process management - process instr. charact. in ctrl. recipe
COME Process management - message characteristics
CORE Process mgmt.- display characteristics of the eval. version
PLFV PI Characteristics/Sub-Operation Parameter Values
Logical databases: -
Matchcodes: CLAS, MERK en KLSW
Classification TCLA Class Types
TCLAT Class Type Texts
TCLT Classifiable Objects
LTCLTT Classifiable Objects: Texts
Logical databases: -
Classification characteristics CABN Characteristic
CAWN Characteristic values
Logical databases: -
Configurator CUCO Additional Data for Configurable Objects
CUCVRNT Variants of Constraints
CUEX Dependency Storage - Compilation
CUFM Customizing: Class/Config: Screendesigner Form
CUKB Administrative Information for Dependency Maintenance
CUKBT Text Table for Dependency Maintenance Admin. Information
CUKN Dependency Storage - Variants/Configuration
CUOB Link between Object and Dependency
CUPE Extension to BOM Item for Variants
CURSADD Dependency Net Additional Data
CUVT Variant Table
CUXREF Object Dependency Cross References
Logical databases: -
Cost elements, centers, activities CSKA Cost elements (data dependent on chart of accounts)
CSKB Cost elements (data dependent on controlling area)
CSKS Cost center master
CSKT Cost center texts
CSKU Cost element texts
CSLA Activity master
CSLT Activity type texts
CSSK Cost center /cost element
CSSL Cost center / activity
Logical databases: -
Customer KNA1 General Data in Customer Master
KNAS Customer master (VAT registration numbers general section)
KNB1 Customer master (company code)
KNB4 Customer payment history
KNB5 Customer master (dunning data) (aanmaangegevens)
KNBK Customer master (bank details)
KNC1 Customer master (transaction figures)
KNC3 Customer master (special G/L transaction figures)
KNKA Customer master credit management: Central data
KNKK Customer master credit management: Control area data
KNMT Customer-Material Info Record Data Table
KNMTK Customer-Material Info Record Header Table
KNVA Customer Master Loading Points
KNVD Customer master record sales request form
KNVI Customer Master Tax Indicator
KNVK Customer Master Contact Partner
KNVL Customer Master Licenses
KNVP Customer Master Partner Functions
KNVS Customer Master Shipping Data
KNVT Customer Master Record Texts for Sales
KNVV Customer Master Sales Data
Logical databases: DDF
Equipment EQUI Equipment master data
EQKT Equipment short texts
EQUZ Equipment time segment
EAPL Allocation of Task Lists to Pieces of Equipment
Logical databases: EQI
Equipment status EQUI Equipment master data
JSTO Status object information
JEST Object status
TJ30 User status
TJ30T Texts for user status
TJ02 System status
TJ02T Texts for system status
Logical databases: -
Function location IFLOT Functional Location (Table)
IFLOTX Functional location: short texts
IRLOTX Reference functional location: short texts
TAPL Allocation of task lists to functional locations
Customizing tables
T370R Reference functional location category
Logical databases: -
General ledger accounts SKA1 G/L accounts master (chart of accounts)
SKAS G/L account master (chart of accounts: key word list)
SKAT G/L account master record (chart of accounts: description)
SKB1 G/L account master (company code)
SKM1 Sample G/L accounts
SKMT Sample account names
SKPF Header Data: Inventory Sampling
Logical databases: -
Goods movement AUFM Goods movements for order
AFFW Goods movements with errors from confirmations
SER03 Doc.header f.serial numbers for goods movements
T440C Planning file entries for goods movements
Logical databases: -
Inventory document IKPF Header: Physical Inventory Document
ISEG Physical Inventory Document Items
LINK Inventory document header in WM
LINP Inventory document item in WM
LINV Inventory data per quant
Maintenance Order
AFIH Maintenance Order Header
AFKO Order header data PP orders
AFPO Order item (not used much)
AFRU Order completion confirmations
AFVC Operation within an order
AFVV Order position data
CRCO Assignment of work center to cost center
OBJK Plant Maintenance Object List
CRHD Work Center Header
PLAF Planned order
HIKO Order master data history
HIVG PM order history: operations
Logical databases: CNJ
Material MARA Material Master: General Data
MARC Material Master: C Segment
MARD Material Master: Storage Location/Batch Segment
MAKT Material Descriptions
MAPL Allocation of task lists to materials
MARV Material Control Record
MARM Units of Measure
MBEW Material Valuation
MOFF Outstanding Material Master Records
MSTA Material Master Status
MVER Material consumption
MVKE Material Master: Sales Data
MAPR Material Index for Forecast
PROP Forecast parameters
Logical databases: MSM
Material document MKPF Header: Material Document
MSEG Document Segment: Material
BSIM Secondary Index, Documents for Material
Logical databases: -
Notifications QMEL Quality notification
QMIH Quality message - maintenance data excerpt
Logical databases: -
Orders AUFK Order master data
AFKO Order header data PP orders
AFPO Order item
JSTO Status object information
JEST Object status
Logical databases: ODK
Personel PCL5 HR/RP Cluster 5; HR Planning Usage
PREL HR Master Data (Version 3.0: Old Version !)
PTXT Texts for HR Master Data
.... table PREL has been changed to
PA0000 HR Master Record: Infotype 0000 (Events)
PA0001 HR Master Record: Infotype 0001 (Org. Assignment)
PA0002 HR Master Record: Infotype 0002 (Personal Data)
PA0003 HR Master Record: Infotype 0003 (Payroll Status)
PA0004 HR Master Record: Infotype 0004 (Challenge)
PA0005 HR Master Record: Infotype 0005 (Leave Entitlement)
PA0006 HR Master Record: Infotype 0006 (Addresses)
PA0007 HR Master Record: Infotype 0007 (Work Schedule)
PA0008 HR Master Record: Infotype 0008 (Basic Pay)
PA0009 HR Master Record: Infotype 0009 (Bank Details)
PA0010 HR Master Record: Infotype 0010 (Capital Formation)
PA0011 HR Master Record: Infotype 0011 (Ext.Bank Transfers)
PA0012 HR Master Record: Infotype 0012 (Fiscal Data Germany)
PA0013 Infotype Social Insurance - Germany
PA0014 HR Master Record: Infotype 0014 (Recurr. Bens/Deducs)
PA0015 HR Master Record: Infotype 0015 (Additional Payments)
PA0016 HR Master Record: Infotype 0016 (Contract Elements)
... and up to PA00281 and PA0900 is available !
Logical databases: PNP
Production resource tools AFFH PRT assignment data for the work order
CRVD_A Link of PRT to Document
CRVD_B Link of Document to PRT
CRVE_A Assignment PRT data - equipment
CRVE_B Assignment equipment - PRT data
CRVM_A Link of PRT data to a material
CRVS_A Relationship of PRT internal number to PRT external number
CRVS_B Relationship of PRT external number to PRT internal number
Customizing tables:
TCF02 PRT categories
TCF03 Texts for the production resources/tools category
TCF04 Status of the PRT master
TCF05 Language-dependent text table for PRT status
TCF06 Field groups in the PRT master for reference
TCF07 Language-dependent texts for field groups in PRT master
TCF08 Assignment of PRT master fields to field groups
TCF10 PRT control key
TCF11 Language-dependent text table for PRT control keys
TCF12 PRT group key
TCF13 Language-dependent text table for PRT group keys
Logical databases: -
Project PROJ Project definition
PRPS WBS (Work Breakdown Structure) Element Master Data
PRTE Scheduling Data for Project Item
Logical databases: CNJ, PSJ, IMA
Purchase Requisition EBAN Purchase Requisition
EBKN Purchase Requisition Account Assignment
EBUB Index for Stock Transport Requisitions for Material
Logical databases: BAM, BKM, BBM
Purchasing document EKAN Vendor Address: Purchasing Document
EKBE History of Purchasing Document
EKBZ History of Purchasing Document - Delivery Costs
EKET Delivery Schedules
EKKN Account Assignment in Purchasing Document
EKKO Purchasing Document Header
EKPO Purchasing Document Item
EKPB "Material Provided" Item in Purchasing Document
EKPV Shipping-Specific Data on Stock Tfr. for Purch. Doc. Item
Logical databases: -
Purchasing info record EINA Purchasing Info Record - General Data
EINE Purchasing Info Record - Purchasing Organization Data
EIPA Order Price History, Info Record
EIKP Export/import header data
EIPO Export/Import Item Data
KONH Conditions (Header)
KONP Conditions (Item)
KONM Conditions (1 Dimensional Quantity Scales)
KONW Conditions (1 Dimensional Value Scales)
Logical databases: IFM, ILM
Reservation RKPF Document Header: Reservation
RESB Reservation/dependent requirements
Logical databases: RKM, RNM, POH
Sales Document VBAK Header Data
VBAP Item Data
VBAG Release Data by Schedule Line in Sch.Agrmt.
VBUK Header Status and Administrative Data
VBUP Item Status
VBRL SD Document: Invoice List
VBPA partner
VBKD Business Data
VBKA Sales activities
VBEP Schedule Line Data
VBRK Billing: Header Data (invoice)
VBRP Billing: Item Data (invoice)
VBFA Sales Document Flow
LIKP Delivery Header Data
LIPS Delivery: Item data
Logical databases: AAV, AKV, ARV, VFV
Sales requirements VBBE Sales Requirements: Individual Records
VBBS Sales Requirement Totals Record
Logical databases: -
Storage locations and stocks LAGP Storage bins
LEIN Storage unit header records
LQUA Quants
LQUAB Total quant counts for certain strategies
MEIK Make-to-Order Stock for Customer Order
MSCA Sales Orders on Hand with Vendor
MSKA Sales Order Stock
MBPR Stock at Production Storage Bin
MLGN Material Data per Warehouse Number
MLGT Material Data per Storage Type
SLGH Elements of Stock Population
Logical databases: S1L, S2L
PLKO Task list - header
PLAS Task list - selection of operations/activities
PLPO Task list - operation/activity
PLKZ Task list: main header
PLWP Allocation of Maintenance Packages to Task List Operations
PLAB Relationships
PLFH Task list - production resources/tools
PLFL Task list - sequences
PLFT Process instructions
PLFV PI Characteristics/Sub-Operation Parameter Values
PLMZ Allocation of bill of material items to operations (component list)
PLPR Log collector for task lists
MAPL Allocation of task lists to materials
EAPL Allocation of task lists to pieces of equipments
TAPL Allocation of task lists to functional locations
Logical databases: -
Transfer requirement LTBK Transfer requirement header
LTBP Transfer requirement item
Logical databases: R1L, RBL, RUL
User data USR01User master record (run-time data)
USR02 Logon data
USR03 User address data
USR04 User master authorizations
USR05 User Master Parameter ID
USR06 Additional data per user
USR07 Object/values of last failed authorization check
USR08 Table for user menu entries
USR09 Entries for user menus (work areas)
USR10 User master authorization profiles
USR11 User Master Texts for Profiles (USR10)
USR12 User master authorization values
USR13 Short Texts for Authorizations
USR14 Surchargeable language versions per user
USR15 External User Name
USR20 Date of last user master reorganization
USR30 Additional Information for User Menu
USR40 Table for illegal passwords
USR41 User master: Additional data
USRCOBJ Object Filters for Exploding Product Structures
USRM0 Material Master User Settings: User Screen Reference
USRM1 Material Master User Settings: Organizational Levels
USRM2 Material Master User Settings: Logical Screens
USRMM User settings: material master
Vendor master LFA1 General section
LFAS VAT registration numbers general section
LFB1 Company code
LFB5 Dunning data
LFBK Bank details
LFC1 Transaction figures
LFC3 Special G/L transaction figures
LFM1 Record purchasing organization data
Logical databases: KDF
WM transfer LTAK WM transfer order header
LTAP WM transfer order item
LUBU Posting change document
Logical databases: R0L, RTL

Converted from CHM to HTML with chm2web Standard 2.7 (unicode)