	Table	Columns	Description
1	TJKWE	15	IS-M/SD: WBZ, Order Data for Inbound Processing
2	RSADMINC	96	Customizing Table General BW
3	BBP_PD_XML	8	Table for Persistent Class CL_XML_PPF_BBP
4	/OTX/RM_TELIB	24	Enterprise Library Server Settings
5	UMV_TR125	9	Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	INV1	265	A/R Invoice - Rows
6	OJDT	100	Journal Entry
7	OPCH	386	A/P Invoice
8	OVTG	52	Tax Definition
9	OPOR	386	Purchase Order
10	JDT1	124	Journal Entry - Rows

	Table	Columns	Description
1	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OVPM	154	Outgoing Payments
5	OIVL	77	Whse Journal
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

163 columns | ERP 6.0 | CREATOR

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/AIF/BDC_IF_CONF	Assign Batch Input Session and Creator (Config.)	6	CREATOR	Queue user ID / for historical reasons	nvarchar	12	0
2	/AIF/BDC_IF_GEN	Assign Batch Input Session and Creator (Gen.)	5	CREATOR	Queue user ID / for historical reasons	nvarchar	12	0
3	/AIF/BDC_ST_CONF	Define Pre-Interface Determination for Batch Input (Config.)	3	CREATOR	Queue user ID / for historical reasons	nvarchar	12	0
4	/AIF/BDC_ST_GEN	Define Pre-Interface Determination for Batch Input (Gen.)	2	CREATOR	Queue user ID / for historical reasons	nvarchar	12	0
5	/AIF/T_FG_MAP	mapping table for created objects	9	CREATOR	User Name	nvarchar	12	0
6	/AIF/T_SEL_BDC	Selection Set for BDC Interfaces	6	CREATOR	Queue user ID / for historical reasons	nvarchar	12	0
7	/OTEB/SWF_TACT	xIM activities business data	8	CREATOR	xIM activity creator	nvarchar	12	0
8	/OTEB/SWF_TMPSEL	Temporary save of selected actkeys (several workitems exist)	5	CREATOR	xIM activity creator	nvarchar	12	0
9	/OTEI/SWF_TMPSEL	Temporary save of selected actkeys (several workitems exist)	4	CREATOR	xIM activity creator	nvarchar	12	0
10	/OTEI/T_GU_LOG	GuestUser: Log-Table guest users	10	CREATOR	GuestUser: Account created by	nvarchar	12	0
11	/OTEI/T_GU_TIC	Guest user tickets	9	CREATOR	GuestUser: Account created by	nvarchar	12	0
12	/PLMI/AGT_MAP	Agent Mapping for process route templates	6	CREATOR	Creator of Agent Mapping	nvarchar	12	0
13	/PLMI/PRT_HEADER	template maintainance, prt header table	4	CREATOR	Name of Process Route Creator	nvarchar	12	0
14	/PLMI/TD_AGT_LST	Team Definition: Agent List	9	CREATOR	Name of Creator of Process Route Item	nvarchar	12	0
15	/SLOAP/ANALYSIS	SLOAP analysis data	5	CREATOR	SLOAS creator	nvarchar	12	0
16	/SLOAP/ANLREPORT	SLOAS analysis report control table	5	CREATOR	SLOAS creator	nvarchar	12	0
17	/SLOAP/ANL_MD	SLOAS Mapping of analyses to analysis modules	4	CREATOR	SLOAS creator	nvarchar	12	0
18	/SLOAP/AUTH	SLOAS: Authorization Data	4	CREATOR	SLOAS creator	nvarchar	12	0
19	/SLOAP/CUSTOMER	SLOAS customer data	4	CREATOR	SLOAS creator	nvarchar	12	0
20	/SLOAP/DESC_ALIA	SLOAS description alias to guid mapping	6	CREATOR	SLOAS creator	nvarchar	12	0
21	/SLOAP/DESC_ALIT	Transport table for /SLOAS/DESC_ALIA	8	CREATOR	SLOAS creator	nvarchar	12	0
22	/SLOAP/FIELD	SLOAS table fields	8	CREATOR	SLOAS creator	nvarchar	12	0
23	/SLOAP/FIELDT	Transport table for /SLOAS/FIELD	10	CREATOR	SLOAS creator	nvarchar	12	0
24	/SLOAP/HELP_HEAD	application help header entries	5	CREATOR	SLOAS creator	nvarchar	12	0
25	/SLOAP/IMP_LOG	Improvement message log	8	CREATOR	SLOAS creator	nvarchar	12	0
26	/SLOAP/KNA1_PROJ	SLOAS mapping of kunnr to project	4	CREATOR	SLOAS creator	nvarchar	12	0
27	/SLOAP/LOG_META	metainfo for sloap log content table	4	CREATOR	SLOAS creator	nvarchar	12	0
28	/SLOAP/MD_FIELD	SLOAS module-field mapping	5	CREATOR	SLOAS creator	nvarchar	12	0
29	/SLOAP/MD_FIELDT	transport table for /SLOAS/MD_FIELD	7	CREATOR	SLOAS creator	nvarchar	12	0
30	/SLOAP/MD_SYS	SLOAS analysis module to system type mapping	6	CREATOR	SLOAS creator	nvarchar	12	0
31	/SLOAP/MD_SYST	transport table for /SLOAS/MD_SYS	8	CREATOR	SLOAS creator	nvarchar	12	0
32	/SLOAP/MODULE	SLOAP analysis module data	7	CREATOR	SLOAS creator	nvarchar	12	0
33	/SLOAP/MODULET	transport table for /SLOAP/MODULE	9	CREATOR	SLOAS creator	nvarchar	12	0
34	/SLOAP/OUT_GR	SLOAP Output Group	8	CREATOR	SLOAS creator	nvarchar	12	0
35	/SLOAP/OUT_GRT	transport tables for /SLOAS/OUT_GR	10	CREATOR	SLOAS creator	nvarchar	12	0
36	/SLOAP/OUT_MD	SLOAP output module	6	CREATOR	SLOAS creator	nvarchar	12	0
37	/SLOAP/OUT_MDT	transport table for /SLOAS/OUT_MD	8	CREATOR	SLOAS creator	nvarchar	12	0
38	/SLOAP/OUT_PR	SLOAP Output Profile	8	CREATOR	SLOAS creator	nvarchar	12	0
39	/SLOAP/OUT_PRT	transport tables for /SLOAS/OUT_PR	10	CREATOR	SLOAS creator	nvarchar	12	0
40	/SLOAP/PRESER	SLOAS Service pertend table	4	CREATOR	SLOAS creator	nvarchar	12	0
41	/SLOAP/PROJECT	SLOAS Project data	4	CREATOR	SLOAS creator	nvarchar	12	0
42	/SLOAP/RESULT	SLOAP analysis results	9	CREATOR	SLOAS creator	nvarchar	12	0
43	/SLOAP/ROLE	SLOAS: Role data	4	CREATOR	SLOAS creator	nvarchar	12	0
44	/SLOAP/SERVICE	SLOAS - Analysis Services	4	CREATOR	SLOAS creator	nvarchar	12	0
45	/SLOAP/STORAGE	SLOAS storage control table	8	CREATOR	SLOAS creator	nvarchar	12	0
46	/SLOAP/STORAGET	transport table for /SLOAS/STORAGE	10	CREATOR	SLOAS creator	nvarchar	12	0
47	/SLOAP/SYS_MESS	System messages	9	CREATOR	User name	nvarchar	12	0
48	/SLOAP/TEXT	SLOAS text mappings	7	CREATOR	SLOAS creator	nvarchar	12	0
49	/SLOAP/TEXTT	transport tables for /SLOAS/TEXT	9	CREATOR	SLOAS creator	nvarchar	12	0
50	/SLOAP/TRANS	SAP LT AP: transport admin tables	8	CREATOR	SLOAS creator	nvarchar	12	0
51	/SLOAP/USER	SLOAS User data	4	CREATOR	SLOAS creator	nvarchar	12	0
52	CNV_MBT_ME_MAPPS	Table for mappings of the Mapping Engine	5	CREATOR	User Name	nvarchar	12	0
53	GRPCDBBUF	Dashboard buffer	7	CREATOR	User Name	nvarchar	12	0
54	J_8AFM	IXOS Forms Management: Permanent table	8	CREATOR	Form creator	nvarchar	12	0
55	LXE_PPAT_RUN	PPAT Run	5	CREATOR	User Name	nvarchar	12	0
56	SWF_UNIT_CONF	Workflow: Workflow Unit Configuration	5	CREATOR	User Name	nvarchar	12	0
57	TOAAT	Table to store the File attributes	4	CREATOR	User Name	nvarchar	12	0
TOPBackground Processing
58	FAVSELS	User-Specific Favorite Selection Criteria	2	CREATOR	User Name	nvarchar	12	0
TOPBusiness Package for Manager Self-Service FI
59	FPB_EXP_CA_ASSM	Express Planning: Assignments Context Elem. / Roadmap Elem.	9	CREATOR	Express Planning: Name of Created By User	nvarchar	12	0
60	FPB_EXP_CA_ITM	Express Planning: Elements of the Context Area (Obsolete)	8	CREATOR	Express Planning: Name of Created By User	nvarchar	12	0
61	FPB_EXP_CA_ITM1	Express Planning: Elements of the Context Area	9	CREATOR	Express Planning: Name of Created By User	nvarchar	12	0
62	FPB_EXP_GRP_STP	Express Planning: Assignment of Substeps to Steps	7	CREATOR	Express Planning: Name of Created By User	nvarchar	12	0
63	FPB_EXP_HIER	Express Planning: Object Hierarchies for Planning Instances	7	CREATOR	Express Planning: Name of Created By User	nvarchar	12	0
64	FPB_EXP_INST	Express Planning: Instances	8	CREATOR	Express Planning: Name of Created By User	nvarchar	12	0
65	FPB_EXP_INSTRUCT	Express Planning: Instruction Texts	7	CREATOR	Express Planning: Name of Created By User	nvarchar	12	0
66	FPB_EXP_INSTT	Express Planning: Instance Texts	8	CREATOR	Express Planning: Name of Created By User	nvarchar	12	0
67	FPB_EXP_INS_MAIL	Express Planning: Standard E-Mails	9	CREATOR	Express Planning: Name of Created By User	nvarchar	12	0
68	FPB_EXP_ROLE	Express Planning: User Roles for Planning Rounds	9	CREATOR	Express Planning: Name of Created By User	nvarchar	12	0
69	FPB_EXP_SCEN	Express Planning: Scenarios	5	CREATOR	Express Planning: Name of Created By User	nvarchar	12	0
70	FPB_EXP_SCENT	Express Planning: Scenario Texts	7	CREATOR	Express Planning: Name of Created By User	nvarchar	12	0
71	FPB_EXP_SCEN_GRP	Express Planning: Assignment of Steps to Scenarios	7	CREATOR	Express Planning: Name of Created By User	nvarchar	12	0
72	FPB_EXP_SECT	Express Planning: Context Area Sections	7	CREATOR	Express Planning: Name of Created By User	nvarchar	12	0
73	FPB_EXP_SECTT	Text Table for FPB_EXP_SECT	7	CREATOR	Express Planning: Name of Created By User	nvarchar	12	0
74	FPB_EXP_STP	Express Planning: Planning Substeps	8	CREATOR	Express Planning: Name of Created By User	nvarchar	12	0
75	FPB_EXP_STPGRP	Express Planning: Steps	6	CREATOR	Express Planning: Name of Created By User	nvarchar	12	0
76	FPB_EXP_STPGRPT	Express Planning: Groups or Planning Steps (Texts)	6	CREATOR	Express Planning: Name of Created By User	nvarchar	12	0
77	FPB_EXP_STPT	Express Planning: Texts for Substeps	6	CREATOR	Express Planning: Name of Created By User	nvarchar	12	0
78	FPB_EXP_UINST	Express Planning: User Instance	12	CREATOR	Express Planning: Name of Created By User	nvarchar	12	0
79	FPB_EXP_USCEN	Express Planning: Application Scenario per iView and User	6	CREATOR	Express Planning: Name of Created By User	nvarchar	12	0
80	FPB_EXP_VARVAL	Express Planning: Value Assignment to Variables (SAP & Ext.)	7	CREATOR	Express Planning: Name of Created By User	nvarchar	12	0
81	FPB_EXP_VAR_EXT	Express Planning: Customer-Specific Variables	6	CREATOR	Express Planning: Name of Created By User	nvarchar	12	0
82	FPB_EXP_VAR_EXTT	Express Planning: Customer-Specific Variables Texts	7	CREATOR	Express Planning: Name of Created By User	nvarchar	12	0
TOPCanada
83	PCERH	History of Payroll Posting Runs	9	CREATOR	User name	nvarchar	12	0
84	T5KR0	Record of Employment (ROE) History	15	CREATOR	User name	nvarchar	12	0
TOPComponent Integration Installation Windows Components
85	ECLSTAMPS	Table of All Existing Stamps for ECL Viewer	5	CREATOR		nvarchar	12	0
TOPCross-Application Components
86	/OPT/VPR	Vendor Portal Registration	5	CREATOR	User Name	nvarchar	12	0
87	CACNS_PM_PROJ	EasyProjectMarket	22	CREATOR	CACNS: Creator ID	nvarchar	12	0
88	ETP_TEXTHEADER	Easy Task Planning: Texts for Task	7	CREATOR	User Name	nvarchar	12	0
TOPData Transfer
89	PEVSH	History of Payroll Posting Runs	7	CREATOR	User name	nvarchar	12	0
90	PPDSH	Payroll Posting Document: Status History	7	CREATOR	User name	nvarchar	12	0
TOPDB2 for OS39
91	DB2BPTUNE	DB2/390: Buffer Pool Tuning Settings	1	CREATOR	Creator of BP tuning settings ( = SAP for default settings )	nvarchar	12	0
92	DB2CCDAILY	List of TS/IXS needing utility treatment (DSNACCOR Daily)	6	CREATOR	DB2 creator name	nvarchar	8	0
93	DB2CCDAILYX	List of TS/IXS needing utility treatment (DSNACCOX Daily)	6	CREATOR	DB2 creator name	nvarchar	8	0
94	DB2CCHOUR	List of TS/IXS needing utility treatment (DSNACCOR Hourly)	6	CREATOR	DB2 creator name	nvarchar	8	0
95	DB2DB02EXTENTS	Tx DB02: Data for DB02's Extent Monitor	5	CREATOR	DB2 creator name	nvarchar	8	0
96	DB2DB02TBDYN	Tx DB02: Dynamics of the size of tables	1	CREATOR	DB2 creator name	nvarchar	8	0
97	DB2DB02TBTOPGROW	Tx DB02: Top Twenty of table growth for fast access	1	CREATOR	DB2 creator name	nvarchar	8	0
98	DB2DB02TSDYN	Tx DB02: Dynamics of the size of tablespaces	4	CREATOR	DB2 creator name	nvarchar	8	0
99	DB2DB02TSSIZE	Transaction DB02: List of tablespace datasets	6	CREATOR	DB2 creator name	nvarchar	8	0
100	DB2DB02TS_SUM	Tx DB02: Summary of TS info. Partitions are summed up	5	CREATOR	DB2 creator name	nvarchar	8	0
101	DB2IXBACK	List of indexes that need a backup	6	CREATOR	DB2 creator name	nvarchar	8	0
102	DB2JOB	JCL Jobs for OS/390	2	CREATOR	Creator of the JCL job	nvarchar	18	0
103	DB2JSINF	Header Table of JCL Administration	2	CREATOR	Creator of the JCL job	nvarchar	18	0
104	DB2TSBACK	List of tablespaces that need a backup	7	CREATOR	DB2 creator name	nvarchar	8	0
105	DB2TSSIZE_T	DB2/390: Storage Information on R/3 Tablespaces	4	CREATOR	DB2 creator name	nvarchar	8	0
106	DBSTAIHDB2	DB2/390 Statistics for Indexes	2	CREATOR	DB2 creator name	nvarchar	8	0
107	DBSTATHDB2	DB2/390 Statistics for Tables (History)	2	CREATOR	DB2 creator name	nvarchar	8	0
108	DBSTATIDB2	DB2/390 Statistics for Indexes	2	CREATOR	DB2 creator name	nvarchar	8	0
109	DBSTATTDB2	DB2/390 Statistics for Tables	2	CREATOR	DB2 creator name	nvarchar	8	0
TOPDocument Management Framework
110	SKWF_LOG	Logging Table	3	CREATOR	Created By	nvarchar	12	0
TOPE-Recruiting
111	HRP5135	DB Table for Infotype 5135	32	CREATOR	User Name	nvarchar	12	0
112	HRP5136	DB Table for Infotype 5136	32	CREATOR	User Name	nvarchar	12	0
113	HRP5137	DB Table for Infotype 5137	32	CREATOR	User Name	nvarchar	12	0
114	HRP5138	DB Table for Infotype 5138	32	CREATOR	User Name	nvarchar	12	0
115	HRP5139	DB Table for Infotype 5139	32	CREATOR	User Name	nvarchar	12	0
116	HRP5140	DB Table for Infotype 5140	32	CREATOR	User Name	nvarchar	12	0
117	HRP5141	DB Table for Infotype 5141	32	CREATOR	User Name	nvarchar	12	0
118	HRP5142	DB Table for Infotype 5142	32	CREATOR	User Name	nvarchar	12	0
119	HRP5143	Database Table for Infotype 5143	32	CREATOR	User Name	nvarchar	12	0
120	HRP5144	Database Table for Infotype 5144	32	CREATOR	User Name	nvarchar	12	0
121	HRP5145	Database Table for Infotype 5145	32	CREATOR	User Name	nvarchar	12	0
122	HRP9901	eQuest Posting Information	67	CREATOR	User Name	nvarchar	12	0
TOPGovernance, Risk and Compliance
123	GRFNDMLOG	Datamart: Central Log	7	CREATOR	User Name	nvarchar	12	0
TOPGRC Risk Management
124	GRRMVALIDATION	Analysis Table	5	CREATOR	User Name	nvarchar	12	0
TOPKnowledge Management and Collaboration
125	CPETASKLOG	Database table with log information for Ad hoc Workflow	3	CREATOR	Character 100	nvarchar	100	0
TOPManagement of Internal Controls
126	FOPCRBFLOG	Reporting Buffers: Central Log	6	CREATOR	User Name	nvarchar	12	0
TOPMaster Data
127	JYT_LOG	IS-M: Log	4	CREATOR	Created By	nvarchar	12	0
128	JYT_LOG_HEADER	IS-M: Log, Header	7	CREATOR	Created By	nvarchar	12	0
TOPMaterial Master
129	WRF_HIER_NODES	Hierarchy Node	8	CREATOR	Created By	nvarchar	12	0
130	WRF_HIER_OBJ	Objects of a Hierarchy	8	CREATOR	Created By	nvarchar	12	0
TOPMonitoring
131	SQLRUSER	Customizing Table for SQL Trace Interpreter	7	CREATOR	User Name	nvarchar	12	0
132	SQLRUSER1	User Table for Groups for SQL Trace Interpreter	4	CREATOR	User Name	nvarchar	12	0
133	SQLRUSER2	User Table for Function for SQL Trace Interpreter	3	CREATOR	User Name	nvarchar	12	0
TOPMusing Tools
134	WDKSNAPSHOTS	Snapshops / Serialization	5	CREATOR	User Name	nvarchar	12	0
TOPPersonal Object Worklist
135	POWL_CATEGORY	Category definition	3	CREATOR	User name	nvarchar	12	0
136	POWL_QUERY	Query meta data	6	CREATOR	User name	nvarchar	12	0
TOPPosition Budgeting and Control
137	HRFPM_RUNADMINS	HRFPM: Administration Information for Commitment Runs	7	CREATOR	User name	nvarchar	12	0
TOPPost Processing Framework
138	PPFTBOOK	PPF: Book Management (Demo Application)	11	CREATOR	User Name	nvarchar	12	0
TOPProcess Controls
139	GRPCRBFLOG	Reporting Buffers: Central Log	6	CREATOR	User Name	nvarchar	12	0
TOPProduct Configurator
140	COMM_CFGKB	Runtime Version of SCE Knowledge Base	15	CREATOR	KB Creator	nvarchar	12	0
TOPPurchasing
141	MMPURUI_CFDOC	cFolders ID for Purchasing Documents	11	CREATOR	Name of Person who Created the Object	nvarchar	12	0
TOPReporting
142	T5KR4	Record of Employment (ROE) History for Concurrent Employment	14	CREATOR	User name	nvarchar	12	0
TOPSales and Distribution
143	SCEKB	Runtime Version of SCE Knowledge Base	9	CREATOR	User that created a knowledge base version	nvarchar	12	0
144	SCEKBOBJ	Knowledge-Base Object (SCE)	7	CREATOR	Name of Person who Created the Object	nvarchar	12	0
TOPSAP Business Workflow
145	SWLWPTSSID	Task Linkages for WebFlow Services	7	CREATOR	User Name	nvarchar	12	0
146	SWU5_DYNP	Chronology of generated program objects	10	CREATOR	User Name	nvarchar	12	0
TOPSAP Records Management
147	SRMDPDISP	Circular	6	CREATOR	Circular Created By	nvarchar	12	0
148	SRMWFPATH	Workflow Process Route	6	CREATOR	Name of Process Route Creator	nvarchar	12	0
149	SRMWFPTHPS	Process Route Item for Workflow	11	CREATOR	Name of Creator of Process Route Item	nvarchar	12	0
TOPSouth Africa
150	T5W63	SARS Interface : Run Attributes	10	CREATOR	PAYE Reference Number	nvarchar	10	0
151	T5W66	SARS Interface : PAYE Reference Number Attributes	4	CREATOR	Indicator: Registered as Creator at SARS	nvarchar	1	0
152	T5W72	UIF interface: Runs per UIF reference number	5	CREATOR	UIF reference number	nvarchar	9	0
TOPStakeholder Relationship Management
153	USS_COMP_FIGS	Key Figures Related to Company	10	CREATOR	Source of Asset	nvarchar	10	0
154	USS_SHARE_FIGS	Key Figure Related to Securities	10	CREATOR	Source of Asset	nvarchar	10	0
TOPSupplier Managed Inventory
155	SMI_PROFILE	SMI Profile	34	CREATOR	Name of Person who Created the Object	nvarchar	12	0
TOPThird Party Remittance
156	T51R5_HIST	Remittance accumulated posting data history	10	CREATOR	User name	nvarchar	12	0
TOPUI Services, Screen, Batch Input
157	APQI	Queue info definition	14	CREATOR	Queue user ID / for historical reasons	nvarchar	12	0
158	APQL	Batch Input Log Directory	7	CREATOR	Queue user ID / for historical reasons	nvarchar	12	0
159	BDCUSEOP	User-Specific Options for Transaction SM35	5	CREATOR	Queue user ID / for historical reasons	nvarchar	12	0
TOPUse Subcomponents
160	SOOD	SAPoffice: Object definition	89	CREATOR	Creator for MacIntosh-based files	nvarchar	4	0
161	SOST	SAPoffice: Status log table	27	CREATOR	User name responsible for creating status	nvarchar	12	0
TOPWithout Description
162	KAP_PSR_OBJ	Object: Element, Sample	4	CREATOR	Created by	nvarchar	12	0
TOPWorkbench Tools Editors, Painters, Modelers
163	MIME_LOG	MIME Repository: Logging Table	3	CREATOR	Created By	nvarchar	12	0

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

163 columns | ERP 6.0 | CREATOR