	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

98 columns | ERP 6.0 | NUM

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	DFKKODNREP	Official Document Number for Reporting	13	NUM	Char 20	nvarchar	20	0
2	DFKK_FAV_EXCL	Hidden Folders	4	NUM	Natural Number	int	10	0
3	DFKK_FAV_FAREA	Favorites Folder	4	NUM	Natural Number	int	10	0
4	DMC_CPU_SEM	Semaphores for Synchronisation of MWB Processes	3	NUM	Natural Number	int	10	0
5	FIKZD_CONTR_MAPC	Subsoil use contracts mapping	3	NUM	Sequential number	nvarchar	7	0
6	FIKZD_CONTR_MAPP	Subsoil use contracts mapping	3	NUM	Sequential number	nvarchar	7	0
7	FIKZD_REGINV_IN	Incoming Invoice Registration Journal	4	NUM	Number	nvarchar	10	0
8	FIKZD_REGINV_OUT	Outgoing Invoice Registration Journal	4	NUM	Number	nvarchar	10	0
9	FIKZ_FILE_TBL	Files for invoice journal record	4	NUM	Number	nvarchar	10	0
10	FIKZ_REGINV_LOG	Invoice Journal (Kazakhstan): History of Statuses	4	NUM	Number	nvarchar	10	0
11	J_1UFDI_FILE_TBL	Files for tax document register record	3	NUM	Entry Number	nvarchar	10	0
12	J_1UFDI_LOG	UA E-Invoices: History of Statuses	7	NUM	Entry Number	nvarchar	10	0
13	J_1UF_TAX_AN7_T3	Table3 for Annex 7: recalculation of share use prepaid tax	5	NUM	Line Number (Integer)	int	10	0
14	J_3RF_REGINV_IN	Incoming Invoice Registration Journal	4	NUM	10 digit number	nvarchar	10	0
15	J_3RF_RGTORG_FS1	File Storage ( Torg Electronic Documents )	4	NUM	Electronic Document Number	nvarchar	10	0
16	J_3RF_RGTORG_IFS	Index Electronic Documents File Storage	4	NUM	Electronic Document Number	nvarchar	10	0
17	J_3RF_RGTORG_IN	Incoming Journal of Acceptance Documents	4	NUM	Electronic Document Number	nvarchar	10	0
18	J_3RF_RGTORG_OUT	Outgoing Journal of Acceptance Documents	4	NUM	Electronic Document Number	nvarchar	10	0
19	J_3RF_TGXML_LOG	TORG Journal (Russia): History of Statuses	4	NUM	Electronic Document Number	nvarchar	10	0
20	T7RUPACK	PFR Packages	3	NUM	Package Number	nvarchar	5	0
21	T7RUPACKMAN	PFR Package persons	3	NUM	Package Number	nvarchar	5	0
22	TWFNS	Workflow: control table status transfers (next status)	5	NUM	Workflow: Transition rule: Seq. no. of subseq. status/agent	nvarchar	2	0
23	WB2_D_BVDETAIL	CCS: Detailed Statement for Settlement	2	NUM	Condition Contract	nvarchar	10	0
24	T7PIQEXAM_FUNC	Assessment: Activities and Functions	5	NUM	Number of Resources per Function	nvarchar	2	0
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
25	CHKAC	Check Table for Distributor: Generated Code	1	NUM	Consecutive numbering	nvarchar	3	0
26	CHKDC	Check Table for Compare Program	1	NUM	Consecutive numbering	nvarchar	3	0
TOPBank Customer Accounts
27	BKK_PAR_INTERVAL	Assigned Intervals	8	NUM	Offset for Number Assignment	smallint	5	0
TOPBatch-Oriented Parallel Processing of Mass Data
28	BCA_PAR_INTRVL_Y	Assigned Intervals	8	NUM	Offset for Number Assignment	smallint	5	0
TOPBusiness Application Support
29	CNV_CHKORDER_AR	Working table for function module cnv_check_seqnum_order	7	NUM	Sequence	nvarchar	2	0
TOPBusiness Planning and Simulation
30	UPWB_PROFILE	User-Specific Settings / Not Transported	3	NUM	Count parameters	nvarchar	4	0
31	UPWB_WEBAPPS	Current Web Applications	1	NUM	Count parameters	nvarchar	4	0
32	UPWB_WEBAPPST	Text Table for UPWB_WEBAPPS	1	NUM	Count parameters	nvarchar	4	0
TOPCapacity and Resource Planning
33	/MRSS/C_RM_SRCHC	Colors for Search Results	4	NUM	Dummy for B20 int1 (Local Everywhere)	tinyint	3	0
TOPChargeback
34	WB2_D_BUSVOLBASE	Rebates: Business Volume Base for Condition Contract	2	NUM	Condition Contract	nvarchar	10	0
35	WB2_D_BVB_SETTL	CCS: Snapshot Business Volume Base Data used for settlement	2	NUM	Condition Contract	nvarchar	10	0
36	WB2_D_SETTL_CAL	Rebates: Settlement Calendar	2	NUM	Condition Contract	nvarchar	10	0
37	WCOCOF	Condition Contract: Document Flow Data	6	NUM	Condition Contract	nvarchar	10	0
38	WCOCOH	Condition Contract: Header	2	NUM	Condition Contract	nvarchar	10	0
39	WCOCOI	Condition Contract: Eligible Partner	2	NUM	Condition Contract	nvarchar	10	0
40	WCOCOP	Condition Contract: Partner Assignment	2	NUM	Condition Contract	nvarchar	10	0
TOPClassification System New
41	CME_PATTERN_SIGN	CME Data Type: Template Characters	4	NUM	Digits	nvarchar	1	0
TOPCommunication Services Mail, Fax, SMS, Telephony
42	SRIRSCENDE	BCOM Internal Router: Scenario Destinations	4	NUM	2-Digit Numeric Value	nvarchar	2	0
43	SRIRSEARCH	BCOM Internal Router: Search Tables (with Addresses)	4	NUM	GUID in 'CHAR' Format in Uppercase	nvarchar	32	0
44	SRSCENDEST	Routing Scenario: Destinations	3	NUM	2-Digit Numeric Value	nvarchar	2	0
TOPContent Activation
45	BSANLY_BCACT_LOG	Activation Log for Content Bundles	9	NUM	Message Number	nvarchar	3	0
TOPContent Management Service
46	CREP_CERT	Certificates for HTTP Access to R3 Database	2	NUM		nvarchar	4	0
TOPData Staging
47	RSPAKPOS	Process position of the InfoPackages in InfoPackage groups	4	NUM	Four-digit number	nvarchar	4	0
TOPFinancials Basis
48	UBC_TB_INVHMES	Bill: Messages from Inbound Processing	4	NUM	Sequence Number	tinyint	3	0
TOPI18N Unicode
49	TECHED02_NUMBERS	Numbers names	3	NUM	Natural Number	int	10	0
50	UM4PMCNV	Reprocess Log Entries	6	NUM		int	10	0
51	UMGPMCNV	Reprocess Log Entries	6	NUM		int	10	0
52	UMGR3LLOG	r3load log for sumg	7	NUM		int	10	0
53	UMGR3LLOGINFO	SUMG: used for error handling during R3load log upload	3	NUM		int	10	0
TOPInformation Consistency
54	SIC_NORM_REGEXR	Basic Rules to Rule Type REGEX (CL_SIC_NORM_REGEX)	4	NUM	Number	int	10	0
55	SIC_NORM_TOKEN0R	Rules for Simple Tokenization (CL_SIC_NORM_SIMPLE_TOKENIZE)	3	NUM	Number	int	10	0
TOPIntegration Customer Relationship Management
56	ECRM_REPL_CD	Table for Change Documents FG EREPL_ERRORHANDLING	3	NUM	Four-digit number	nvarchar	4	0
57	ECRM_REPL_HD	Header Data for IS-U Sales Replication Error Handling	5	NUM	Four-digit number	nvarchar	4	0
58	EVER_CRMQ	ISU Contract CRM-Entry Queue	3	NUM	Four-digit number	nvarchar	4	0
59	EVER_CRMQ_CHEVNT	Contract Queue for Change Reference Numbers	3	NUM	Four-digit number	nvarchar	4	0
60	EVER_CRMQ_CONF	Contract Queue Configuration	3	NUM	Four-digit number	nvarchar	4	0
61	EVER_CRMQ_STATUS	Contract Queue Configuration	3	NUM	Four-digit number	nvarchar	4	0
TOPLocalization
62	J_3RFBS5_SELOP	Selection criteria values for asset classes	3	NUM	Count Parameters	nvarchar	4	0
TOPMaintenance Notifications
63	TQSUB	Notification: Subscreen control for notification	2	NUM	Sequence Number	nvarchar	3	0
64	TQSUBT	Notification: Subscreen control for notification text table	2	NUM	Sequence Number	nvarchar	3	0
TOPMaster Data
65	EVERH	IS-U Contract History	4	NUM	Four-digit number	nvarchar	4	0
TOPNon Profit Organizations
66	T7UNCMT_CURR	CMT Interface: Country	4	NUM		nvarchar	3	0
TOPPerformance Monitors TCC
67	GVD_PARAMETER	Copy of GV$PARAMETER	3	NUM	Oracle monitoring: Parameter number	decimal	22	0
68	GVD_PARAMETER2	Copy of GV$PARAMETER2 (currently not provided with snapshot	3	NUM	Oracle Monitoring: NUM: Parameter Number	decimal	22	0
TOPReport Selection for Product Costing
69	TKKB1	Costing Reports	12	NUM	Number of Objects	nvarchar	1	0
70	TKKB3	KKB: General Reports	6	NUM	Number of Objects	nvarchar	1	0
71	TKKBX	User Groups for Costing Reports	6	NUM	Number of Objects	nvarchar	1	0
TOPRuntime
72	SWFTSITSTDATA	TSI: Test Database Table	3	NUM	Work item ID	nvarchar	12	0
TOPSAP Query
73	AQGDBBG	SAP Query: User Groups	1	NUM	SAP Query (S): Name of a user group	nvarchar	12	0
74	AQGDBBN	SAP Query: Assigning Users to User Groups	1	NUM	SAP Query (S): Name of a user group	nvarchar	12	0
75	AQGDBBS	SAP Query: Assigning Functional Areas to User Groups	2	NUM	SAP Query (S): Name of a user group	nvarchar	12	0
76	AQGQCAT	SAP Query: Query Catalog	1	NUM	SAP Query (S): Name of a user group	nvarchar	12	0
77	AQGTB	SAP Query: Texts for User Groups	2	NUM	SAP Query (S): Name of a user group	nvarchar	12	0
78	AQGTQ	SP Query: Texts for Queries	2	NUM	SAP Query (S): Name of a user group	nvarchar	12	0
79	AQLQCAT	SAP Query: Query Catalog	2	NUM	SAP Query (S): Name of a user group	nvarchar	12	0
80	AQLTQ	SP Query: Texts for Queries	3	NUM	SAP Query (S): Name of a user group	nvarchar	12	0
TOPService Processing
81	/WSCGMBH/C_ASSIG	ClickSchedule: Assignment	4	NUM	ClickSchedule: Number	nvarchar	10	0
TOPTag Library
82	CRMD_FLEX_TITLES	titles for Flex table cells	5	NUM		nvarchar	2	0
TOPTraders and Schedulers Workbench
83	OIJ_RU_CARRSRVOP	Carrier Services - Selection	4	NUM	Count parameters	nvarchar	4	0
TOPTraining and Event Management
84	T77VB	Output Sequence of Text Elements	5	NUM	Sequence number for text element output	nvarchar	3	0
TOPTranslation Tools
85	LXE_AV	Translation Evaluations	9	NUM	Object List	nvarchar	5	0
86	LXE_NUMBER	Number	2	NUM	Object List	nvarchar	5	0
87	LXE_PP_MAP	Conversion During Remote Copy	1	NUM	2-Digit Numeric Value	nvarchar	2	0
88	TRNL_AV	Translation Evaluations	8	NUM	Run number for worklists: translation	nvarchar	5	0
89	TRNL_OL	Translation Object Lists	6	NUM	Run number for worklists: translation	nvarchar	5	0
90	TRNL_WL	Worklists of Translation (Header Data)	1	NUM	Run number for worklists: translation	nvarchar	5	0
TOPUser Administration
91	SMUM_ERDEC	SMUM error description	1	NUM	Message Number	nvarchar	3	0
TOPVirtual Machine Container
92	SVMCRT_BINDINGS	VMC Runtime: Resources	4	NUM		int	10	0
93	SVMCRT_MODULES	VMC Runtime: Modules	1	NUM	Module Number	int	10	0
94	SVMCRT_RESOURCES	VMC Runtime: Resources	3	NUM	Resource Number	int	10	0
95	SVMCRT_RES_TRANS	VMC Runtime: Transport Table for Resources	2	NUM		int	10	0
TOPWork Clearance Management
96	WCAAP	WCM: Application	104	NUM	Total Number of Crew Members	nvarchar	3	0
TOPWorkbench Utilities
97	TQSTQ1	Table of Questions for Online Questionnaires	3	NUM	Integer 4	int	10	0
98	TQSTQS	Table of Data for Online Questionnaires	5	NUM	Natural Number	int	10	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

98 columns | ERP 6.0 | NUM