SAP - Master Data Tables - Overview
| Material Master Data | |
| MARA | Material master |
| MAKT | Material text |
| MARC | Material per plant / stock |
| MVKE | Material master, sales data |
| MARD | Storage location / stock |
| MSKA | Sales order stock |
| MSPR | Project stock |
| MARM | Units of measure |
| MEAN | International article number |
| PGMI | Planning material |
| PROP | Forecast parameters |
| MAPR | Link MARC < => PROP |
| MBEW | Material valuation |
| MVER | Material consumption |
| MLGN | Material / Warehouse number |
| MLGT | Material / Storage type |
| MPRP | Forecast profiles |
| MDTB | MRP table |
| MDKP | Header data for MRP document |
| MLAN | Tax data material master |
| MTQSS | Material master view: QM |
| Basic data text | |
| STXB | SAPscript: Texts in non-SAPscript format |
| STXH | STXD SAPscript text file header |
| Batches | |
| MCHA | Batches |
| MCH1 | Batches |
| MCHB | Stock : batches |
| Customer Master Data | |
| KNA1 | Customer master |
| KNB1 | Customer / company |
| KNVV | Customer sales data |
| KNBK | Bank details |
| KNVH | Customer hierarchy |
| KNVP | Customer partners |
| KNVS | Shipment data for customer |
| KNVK | Contact persons |
| KNVI | Customer master tax indicator |
| Vendor Master Data | |
| LFA1 | Vendor master |
| LFB1 | Vendor per company code |
| LFB5 | Vendor dunning data |
| LFM1 | Purchasing organisation data |
| LFM2 | Purchasing data |
| LFBK | Bank details |
SAP Tables - Purchasing
| Table | Description – All Tables: 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 Agr ement 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 |
| T- Tables | |
| 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 Complia ce 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 Routin s |
| 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 |
| T1 0Y | 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, Purc ase Requisitio |
| T161I | Determination of Release Strategy |
| T161M | FineTuned 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 T1 2/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 Printou s |
| 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 SAP Tables
Important SAP - Tables- Material Management
- Purchasing
- Sales and Distribution
- Plant Maintenance
- Finance
- Production
- System Tables
| MM Material Management | |
| 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 |
| MM Purchasing | |
| 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 |
| SD Sales and Distribution | |
| KONV | Conditions for Transaction Data |
| KONP | Conditions for Items |
| LIKP | Delivery Header Data |
| LIPS | Delivery: Item data |
| VBAK | Sales Document: Header Data |
| VBAP | Sales Document: Item Data |
| VBBE | Sales Requirements: Individual Records |
| VBEH | Schedule line history |
| VBEP | Sales Document: Schedule Line Data |
| VBFA | Sales Document Flow |
| VBLB | Sales document: Release order data |
| VBLK | SD Document: Delivery Note Header |
| VBPA | Sales Document: Partner |
| VBRK | Billing: Header Data |
| VBRP | Billing: Item Data |
| VBUK | Sales Document: Header Status and Administrative Data |
| VBUP | Sales Document: Item Status |
| VEKP | Handling Unit - Header Table |
| VEPO | Packing: Handling Unit Item (Contents) |
| VEPVG | Delivery Due Index |
| Plant Maintenance | |
| AFAB | Network - Relationships |
| AFFH | PRT assignment data for the work order |
| AFFL | Work order sequence |
| AFFT | Order - Process Instructions |
| AFFV | Order - Process Instruction Values |
| AFFW | Goods movements with errors from confirmations |
| AFIH | Maintenance order header |
| AFKO | Order header data PP orders |
| AFPO | Order item |
| AFRC | Incorrect cost calculations from confirmations |
| AFRD | Default values for collective confirmation |
| AFRH | Header information for confirmation pool |
| AFRU | Order completion confirmations |
| AFRV | Confirmations pool |
| AFVC | Operation within an order |
| AFVU | DB structure of the user fields of the operation |
| AFVV | DB structure of the quantities/dates/values in the operation |
| AFWI | Subsequently posted goods movements for confirmations |
| AUFK | Order master data |
| AUFM | Goods movements for order |
| BGMK | Master Warranty Header |
| BGMP | Master Warranty Item |
| BGMS | Master Warranty Text Item |
| BGMT | Master Warranty Text |
| BGMZ | Warranty Counter |
| CRHD | Work Center Header |
| CRTX | Text for the Work Center or Production Resource/Tool |
| EQKT | Equipment Short Texts |
| EQST | Equipment to BOM Link |
| EQUI | Equipment master data |
| EQUZ | Equipment time segment |
| HIKO | Order master data history |
| IFLO | Table generated for View IFLO |
| IFLOT | Functional Location (Table) |
| IFLOTX | Functional Location- Short Texts |
| IHGNS | Permit Segment for Plant Maintenance |
| IHPA | Plant Maintenance- Partners |
| IHSG | Object-Related Permits in Plant Maintenance |
| ILOA | PM Object Location and Account Assignment |
| IMPTT | Measuring Point (Table) |
| IMRG | Measurement Document |
| KAKO | Capacity Header Segment |
| KONP | Conditions (Item) |
| KONV | Conditions (Transaction Data) |
| OBJK | Plant Maintenance Object List |
| QMEL | Quality Notification |
| QMFE | Quality notification - items |
| QMIH | Quality message - maintenance data excerpt |
| QMMA | Quality notification - activities |
| QMSM | Quality notification - tasks |
| QMUR | Quality notification - causes |
| T001 | Company Codes |
| T001L | Storage Locations |
| T001W | Plants/Branches |
| T077D | Customer account groups |
| T003O | Order Types |
| T352R | Maintenance revisions |
| T353I_T | Maintenance activity type description |
| T356 | Priorities |
| T357G | Permits |
| T357G_T | Text for Table 357GT |
| T370A | Activity Category for PM Lists |
| TINCT | Customers- Incoterms- Texts |
| TVKO | Organizational Unit- Sales Organizations |
| TVKOS | Organizational Unit- Divisions per Sales Organization |
| TVKOV | Org. Unit- Distribution Channels per Sales Organization |
| TVTA | Organizational Unit- Sales Area(s) |
| VIAUFKST | Generated Table for View VIAUFKST |
| FI – Finance | |
| AGKO | Cleared Accounts |
| ANAR | Asset Types |
| ANAT | Asset type text |
| ANEK | Document Header Asset Posting |
| ANEP | Asset Line Items |
| ANEV | Asset downpymt settlement |
| ANKT | Asset classes- Description |
| ANLA | Asset Master Record Segment |
| ANLB | Depreciation terms |
| ANLC | Asset Value Fields |
| ANLH | Main asset number |
| AT02T | Transaction Activity Category- Description |
| AT02A | Transaction Code for Menu TIMN |
| AT10 | Transaction type |
| AT10T | Name of Transaction Type |
| BKDF | Document Header Supplement for Recurring Entry |
| BKORM | Accounting Correspondence Requests |
| BKPF | Accounting Document Header |
| BLPK | Document log header |
| BLPP | Document log item |
| BLPR | Document Log Index and Planned Order (Backflush) |
| BNKA | Bank master record |
| BP000 | Business Partner Master (General Data) |
| BPBK | Doc.Header Controlling Obj. |
| BPEG | Line Item Total Values Controlling Obj. |
| BPEJ | Line Item Annual Values Controlling Obj. |
| BPEP | Line Item Period Values Controlling Obj. |
| BPGE | Totals Record for Total Value Controlling obj. |
| BPJA | Totals Record for Annual Total Controlling Obj. |
| BSAD | Accounting- Secondary Index for Customers (Cleared Items) |
| BSAK | Accounting- Secondary Index for Vendors (Cleared Items) |
| BSAS | Accounting- Secondary Index for G/L Accounts (Cleared Items) |
| BSEC | One-Time Account Data Document Segment |
| BSEG | Accounting Document Segment |
| BSID | Accounting- Secondary Index for Customers |
| BSIK | Accounting- Secondary Index for Vendors |
| BSIM | Secondary Index, Documents for Material |
| BSIS | Accounting- Secondary Index for G/L Accounts |
| CEPC | Profit Center Master Data Table |
| CEPCT | Texts for Profit Center Master Data |
| COBRA | Settlement Rule for Order Settlement |
| COBRB | Distribution Rules Settlement Rule Order Settlement |
| COKA | CO Object- Control Data for Cost Elements |
| COSP | CO Object- Cost Totals for External Postings |
| COSS | CO Object- Cost Totals for Internal Postings |
| CRCO | Assignment of Work Center to Cost Center |
| CSKA | Cost Elements (Data Dependent on Chart of Accounts) |
| CSKB | Cost Elements (Data Dependent on Controlling Area) |
| CSLA | Activity master |
| FEBEP | Electronic Bank Statement Line Items |
| FPLA | Billing Plan |
| FPLT | Billing Plan- Dates |
| GLPCT | EC-PCA- Totals Table |
| KNA1 | General Data in Customer Master |
| KOMK | Pricing Communication Header |
| MAHNV | Management Records for the Dunning Program |
| REGUT | TemSe - Administration Data |
| SKA1 | G/L Account Master (Chart of Accounts) |
| SKAT | G/L Account Master Record (Chart of Accounts- Description) |
| SKB1 | G/L account master (company code) |
| T003T | Document Type Texts |
| T007S | Tax Code Names |
| T087J | Text |
| TAPRFT | Text tab. for investment profile |
| TKA01 | Controlling Areas |
| TKA09 | Basic Settings for Versions |
| TKVS | CO Versions |
| TZB0T | Flow types text table |
| TZPAT | Financial Assets Management product type texts |
| VBSEGS | Document Segment for G/L Accounts Document Parking |
| VTBFHA | Transaction |
| VTBFHAPO | Transaction Flow |
| VTBFHAZU | Transaction Activity |
| VTBFINKO | Transaction Condition |
| VTIDERI | Master Data Listed Options and Futures |
| VTIFHA | Underlying transaction |
| VTIFHAPO | Underlying transaction flows |
| VTIFHAZU | Underlying transaction status table |
| VTIOF | Options Additional Data |
| VWPANLA | Asset master for securities |
| PP – Production | |
| MAST | Material BOM |
| STKO | BOM Header |
| STPO | BOM Positions (detail) |
| MAPL | Assignment fo Task Lists to Materials |
| PLKO | Routing Group Header |
| PLSO | Routing Group Sequence |
| PLPO | Routing Group Operations |
| AFKO | Production Order Header |
| AFPO | Production Order Position (details) |
| SAP – System Tables | |
| ADCP | Person/Address assignment (central address administration) |
| ADIRACCESS | Table to store keys for TADIR objects |
| ADR2 | Telephone numbers (central address admin.) |
| ADRP | Persons (central address administration) |
| APQD | DATA DEFINITION Queue |
| APQI | Queue info definition |
| D010SINF | ABAP- Information about ABAP program source code |
| E071 | Change and Transport System- Object Entries of Requests/Tasks |
| E07T | Change and Transport System- Short Texts for Requests/Tasks |
| ENLFDIR | Additional Attributes for Function Modules |
| INDX | System table INDX |
| NAST | Message Status |
| STXH | STXD SAPscript text file header |
| T005 | Countries |
| T005S | Taxes- Region (Province) Key |
| T005U | Taxes- Region Key- Texts |
| T006 | Units of Measurement |
| T015M | Names of the months |
| T247 | Month name and short text |
| T777A | Building Addresses |
| TADIR | Directory of Repository Objects |
| TBTCO | Job status overview table |
| TBTCP | Batch job step overview |
| TFDIR | Function Module |
| TFTIT | Function Module Short Text |
| TSP03L | Spool- Long device names |
| TSTC | SAP Transaction Codes |
| TSTCT | Transaction Code Texts |
| TUTYP | User Types in Current Price List in SAP System |
| TUZUS | Special versions |
| TVARV | Table of variables in selection criteria |
| TVDIR | View Directory |
| US930 | Data Relevant to Measurement for User Master Record |
| USR01 | User master record (runtime data) |
| USR02 | Logon data |
| USR04 | User master authorizations |
| USR06 | Additional Data per User |
| USR14 | Surchargeable Language Versions per User |
| USR21 | Assign user name address key |
| ARCH_OBJ | Objects for archiving and reorganization |
| BTCUED | Description of user event IDs for background processing |
| BTXSUPB | BSI- Upgrade-Information |
| CCCFLOW | Client Copy Control Flow |
| DBSTATC | DB Optimizer Control (Statistics Creation) |
| DEVACCESS | Table for development users |
| DEVL | OBSOLETE- Do not use (See TCETRAL) |
| E070 | Change and Transport System- Header of Requests/Tasks |
| E070L | CTS- Index for Assigning Numbers to Requests/Tasks |
| INSTVERS | Documentation for installation Status and History |
| PAT03 | Patch Directory |
| SDBAC | DBA Action Table |
| T100 | Messages |
| TAPLT | Program Application Long Texts |
| TASYS | OBSOLETE- Do not use, see TCEDELI |
| TDEVC | Development Classes |
| TEMSE | Temp Sequential table. |
| TLOCK | Change and Transport System- Lock Table |
| TNAPR | Processing programs for output. Can be very handy to find the print program for a SAPScript. |
| TNAST | Printed output control table |
| TPFET | Table of profile parameters |
| TPFHT | Profile header, administration data for profiles in DB |
| TPROT | Table contains all DD tables to be logged |
| TRBAT | Communication Table for Transport Control |
| TRDIRT | Title texts for programs in TRDIR |
| TRESN | Table of Naming Conventions in ABAP Workbench |
| TRJOB | Job ID for Coordinating Batch-ABAP/UNIX for Transports |
| TSP03C | Spool- Device Description Extension |
| TST03 | TemSe data |
| TSYST | OBSOLETE- Do not use (see TCESYST) |
| TWSYS | OBSOLETE- Do not use (See TCETRAL) |
| USOBT | Relation transaction - authorization object |
| USR03 | User address data |
| USR05 | User Master Parameter ID |
| USR12 | User master authorization values |
| USR40 | Table for illegal passwords |
| USR41 | User master- Additional data |
| UST04 | User masters |
| VARIT | Variant texts |
| VARID | Variant directory |
| D010TAB | Table for Use Report---Tables |
| DD02L | SAP tables |
| DD02T | R/3 DD- SAP table texts |
| DD03L | Table Fields |
| DD03T | DD- Texts for fields (language dependent) |
| EDIDC | IDOC Control Records |
| EDIDOT | Short description of IDoc types |
| EDID2 | IDOC segments (version 3.1) |
| EDID4 | IDOC segments (version 4.6) |
| EDSEA | EDI- Table of all segments of current release |
| VRSX2 | Central Table for Version Management (Report Source) |
| TSE05 | Can add parameters to the INSERT COMMAND (IC). Then, when you insert command, your info appears in the editor. Useful for comment blocks, common section of code, etc. |
| CDPOS | Change document items |
| CDHDR | Change document header |
| T529A | governs the foreground sequence of infotypes the system will use to prompt the user during online and batch processing. You will have to code your BDC to follow that sequence of creating infotypes. |
| T588Z | governs the dynamic event processing that will only take place during online user inputs. For BDC''s you will have to create separate BDC''s to handle any infotypes that are inserted dynamically by this table. |
| T588M | Infotype Screen Control |
rn