SAP TABLES

• Sales and Distribution Tables
• Materials Management Tables
• Purchasing Tables
• Plant Maintenance/Sales and Distribution Tables
• Finance Tables
• Human Resources Tables/Infotypes
• Project Systems Tables
• Production Planning
• System Tables

Sales and Distribution Tables

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/Sales and Distribution Tables

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

Finance Tables 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
Human Resources Tables/Infotypes CATSCO Cross-Application Time Sheet (CATS)- Transfer to CO CATSDB CATS- Database Table for Time Sheet CATSHR Cross-Application Time Sheet (CATS)- Transfer to HR CATSMM Cross-Application Time Sheet (CATS)- Transfer to MM CATSPM Cross-Application Time Sheet (CATS)- Transfer to PM/CS CATSPS Cross-Application Time Sheet (CATS)- Transfer to PS CSKS Cost Center Master Data CSKT Cost Center Texts PCL1 HR Cluster 1 PCL2 HR Cluster 2 T001P Personnel Area/Subarea T001T Company code-dependent texts T500L Personnel Country Grouping T500P Personnel Areas T502T Marital Status Designators T503 Employee Group/Subgroup T503T Employee Subgroup Names T508A Work Schedule Rules T510 Pay Scale Groups T510A Pay Scale Types T510F Assign Pay Scale --- Currency T510W Pay Scale - Period Parameter Assignment T511 Wage Types T512T Wage Type Texts T512W Wage Type Valuation T512Z Permissibility of Wage Types per Infotype T527X Organizational Units T528T Position Texts T529T Personnel Action Texts T529U Status Values T530 Reasons for Actions T530T Reason for Action Texts T549A Payroll Accounting Areas T549Q Payroll Periods T550A Daily Work Schedule T550S Daily Work Schedule Texts T551S Period Work Schedule Texts T552A Monthly Work Schedule T554C Absence Valuation T554S Attendance and Absence Types T554T Attendance and Absence Texts T558B Payroll Account Transfer- Payroll Periods T569V Control Records T5K8C Transfer ext. payroll results into Canadian specific tables T74FA Benefit insurance plan T74FC Benefits Insurance Coverage Rule HRP1000 Infotype 1000 DB Table (Objects) HRP1001 Infotype 1001 DB Table (Relationships) HRP1002 Infotype 1002 DB Table HRP1003 Infotype 1003 DB Table HRP1004 Infotype 1004 DB table HRP1005 DB Table for Infotype 1005 (Planned Compensation) HRP1006 Infotype 1006 DB table HRP1007 Infotype 1007 DB Table HRP1008 Infotype 1008 DB Table HRP1009 Infotype 1009 DB table HRP1010 Infotype 1010 DB table HRP1011 Infotype 1011 DB Table HRP1013 Infotype 1013 DB Table HRP1014 Infotype 1014 DB Table HRP1015 Infotype 1015 DB table HRP1016 Infotype 1016 DB Table HRP1017 Infotype 1016 DB Table HRP1018 DB Table for Infotype 1018 Cost Distribution HRP1019 DB Table for Infotype 1019 Required Positions HRP1020 Infotype 1020 DB table HRP1021 INFOTYPE 1021 DB TABLE HRP1023 Infotype 1023 DB table HRP1024 INFOTYPE 1024 DB TABLE HRP1025 INFOTYPE 1025 DB TABLE HRP1026 Infotype 1026 DB table HRP1027 Infotype 1027 DB table HRP1028 Infotype 1028 DB Table HRP1029 Infotype 1029 DB table HRP1030 Infotype 1030 DB table HRP1031 Infotype 1031 DB table HRP1032 Infotype 1032 DB Table HRP1033 DB table for infotype 1033 HRP1034 Infotype 1034 DB table HRP1035 Infotype 1035 DB Table HRP1036 Infotype 1036 DB table HRP1037 Infotype 1037 DB Table HRP1038 Infotype 1038 DB table HRP1039 Database Table for Infotype 1039 HRP1040 Database Table for Infotype 1040 HRP1041 DB Table for Infotype 1041 HRP1042 Infotype 1042 DB Table HRP1043 DB Table for Infotype 1043 HRP1044 DB Table for Infotype 1044 HRP1045 DB Table for Infotype 1045 HRP1046 Database Table for Infotype 1046 HRP1047 DB Table for Infotype 1047 HRP1048 DB Table for Infotype 1048 HRP1049 Database Tables for Infotype 1049 HRP1050 DB Table for Infotype 1050 (Job Evaluation Results) HRP1051 DB Table for Infotype 1051 (Survey Results) HRP1060 DB Table for Infotype 1060 HRP1061 DB Table for Infotype 1061 HRP1062 DB Table for Infotype 1062 HRP1063 DB Table for Infotype 1063 HRP1201 Infotype 1201 DB Table HRP1205 Infotype 1205 DB Table HRP1206 Infotype 1206 DB Table HRP1208 Infotype 1208 DB Table HRP1209 Infotype 1209 DB Table HRP1210 Infotype 1210 DB Table HRP1211 Infotype 1211 DB Table HRP1212 Infotype 1212 DB Table HRP1213 Infotype 1213 DB Table HRP1214 Infotype 1214 DB Table HRP1215 Infotype 1215 DB Table HRP1216 Infotype 1216 DB Table HRP1217 Infotype 1217 DB Table HRP1218 DB Table for Infotype 1218 HRP1220 DB Table for Infotype 1220 Activity Profile HRP1221 DB Table for Infotype 1221 Excluded Activities HRP1222 Infotype 1222- General attribute maintenance HRP1230 DB Table for Infotype 1230 HRP1240 DB Table for Infotype 1240 HRP1250 DB table for infotype 1250 HRP1251 DB table for infotype 1251 HRP1252 DB table for infotype 1252 HRP1253 DB table for infotype 1253 HRP1254 DB Table for Infotype 1254 HRP1260 DB Table for Infotype 1260 HRP1270 DB Table for Info Type 1270 HRP1403 DB table for infotype 1403 HRP1404 DB table for infotype 1404 HRP1500 DB Table for Infotype 1500 HRP1501 DB Table for Infotype 1501 HRP1502 DB Table for Infotype 1502 HRP1503 DB Table for Infotype 1503 HRP1504 DB Table for Infotype 1504 HRP1505 DB Table for Infotype 1505 HRP1506 DB Table for Infotype 1506 HRP1507 DB Table for Infotype 1507 HRP1518 DB Table for Infotype 1518 HRP1519 DB Table for Infotype 1519 HRP1520 DB Table for Infotype 1520 HRP1600 Database Table for Infotype 1600 HRP1601 Database Table for Infotype 1601 HRPAD21 Additional data PAD21 HRPAD22 Additional data PAD22 HRPAD23 Additional data PAD23 HRPAD25 Additional data PAD25 HRPAD27 Additional data PAD27 HRPAD31 Additional data PAD31 HRPAD34 Additional Data for Relationship 'has attended' HRPAD44 PAD44 Additional Data HRPAD47 PAD47 Additional Data HRPAD48 Additional Data PAD48 HRPAD50 Additional Data PAD50 HRPAD51 Additional data PAD51 HRPAD53 Additional Data PAD53 HRPAD63 PAD63 Additional Data HRPAD77 Additional data for PAD77 HRPADBLIST Additional Data Databases HRPADD2 Additional Data PADD2 HRPADD3 Additional Data PADD3 HRPADIC Additional Data PADD2 HRPADNLIST Additional Data Number List HRPADNN General Additional Data Table HRPADP1 Additional Data PADP1 HRPADP2 Additional Data PADP2 HRPADPM Additional Data PADPM HRPADTI PADTI Additional Data HRPADUZ PADUZ Additional Data- Requirements Assignment of Persons HRPADXN Additional Data PADXN HRPS_T012K For Decoupled Access to T012K (House Bank and Account) HRPVAC List of vacant positions HRPXXXX DB Table for Infotype XXXX HRPYYYY DB Table for Infotype YYYY PA2001 HR Time Record- Infotype 2001 (Absences) PA2001_UGR Generated Table for View PA2001_UGR PA2002 HR Time Record- Infotype 2002 (Attendances) PA2002_UGR Generated Table for View PA2002_UGR PA2003 HR Time Record- Infotype 2003 (Substitutions) PA2004 HR Time Record- Infotype 2004 (Availability) PA2005 HR Time Record- Infotype 2005 (Overtime) PA2006 HR Time Record- Infotype 2006 (Absence Quotas) PA2006_UGR Generated Table for View PA2006_UGR PA2007 HR Time Record- Infotype 2007 (Attendance Quotas) PA2007_UGR Generated Table for View PA2007_UGR PA2010 HR Time Record- Infotype 2010 (Employee Remuneration Info.) PA2012 HR Time Record- Infotype 2012 (Time Transfer Specifications) PA2013 HR Time Record- Infotype 2013 (Quota Corrections) PA2500 HR Master Record for Infotype 2500 PA2501 HR Master Record for Infotype 2501 PA2502 HR Master Record for Infotype 2502 PA0000 HR Master Record- Infotype 0000 (Actions) 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 (Planned Working Time) 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 (Recur. Payments/Deds.) PA0015 HR Master Record- Infotype 0015 (Additional Payments) PA0016 HR Master Record- Infotype 0016 (Contract Elements) Project Systems Tables IMAK Appropriation requests - general data IMAV Appropriation request variant IMPR Investment Program Positions IMPU Texts for cap. inv. program positions IMTP Investment programs IMZO Assignment Table- CO Object - Capital Investment Prog.Pos. PMCO Cost structure of maintenance order PRHI Work Breakdown Structure, Edges (Hierarchy Pointer) PROJ Project definition PRPS WBS (Work Breakdown Structure) Element Master Data
Production Planning Tables 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) 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
Purchasing Tables 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. Materials and Management Tables 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