Overview of functional tables

Entities

Accounting Accounting documents Bill Of Material Capacity planning Classification Classification class types, classifiable objects Classification characteristics Configurator Cost elements centers and activities Customer Equipment Equipment status system status / user status Function location and reference function location General ledger accounts Goods movement Inventory document Maintenance Order PM order Material Material document Notifications

Orders Purchase orders Personel Production resource tools PRTs Project Purchase Requisition Purchasing document Purchasing Info record Reservation 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 STPO BOM item 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 Customizing 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
Tasklist	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

---

转载于:https://www.cnblogs.com/samuelhou/articles/1165053.html