	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

80 columns | ERP 6.0 | RTYPE

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/BI0/SRTYPE	Master Data IDs: InfoObject Exchange Rate Type	1	RTYPE	Exchange Rate Type	nvarchar	4	0
2	DRP_SMTC_METR	DEV Reporting (SE28): Formulas for Calculation	9	RTYPE	DEV Reporting (SE28): Result of Formula Interpreter	nvarchar	1	0
3	GRACBGRANGE	Range table values for Background Job variant	5	RTYPE	Character field, length 32	nvarchar	32	0
4	GRFNQRATING	Qustion Ratings	2	RTYPE	Question Rating Type	nvarchar	2	0
5	GRFNQRATINGT	Qustion Rating Texts	3	RTYPE	Question Rating Type	nvarchar	2	0
6	GRFNQRATINGTYPE	Question Rating Types	2	RTYPE	Question Rating Type	nvarchar	2	0
7	GRFNQRATINGTYPET	Question Rating Types - Text	3	RTYPE	Question Rating Type	nvarchar	2	0
8	P08P_USSC	USS Interface Control Table (Contributions & Salary Changes)	2	RTYPE	Interface Control File Run Type	nvarchar	1	0
9	P08P_USSC_CARE	USS Interface Control Table (Contributions & Salary Changes)	2	RTYPE	Interface Control File Run Type	nvarchar	1	0
10	P2RU_GRREC	Payroll Results: Garnishment for US Record	9	RTYPE	Record type	nvarchar	1	0
11	P2RU_TAXR	Payroll result: Tax authorities of resident/unemployment(US)	6	RTYPE	Letter	nvarchar	1	0
12	T512V	RPDSYS00 - Cross References	2	RTYPE	Documentation Object Type	nvarchar	4	0
13	T588F	- is no longer used (now T588G) -	5	RTYPE	Retroactive Accounting Category	nvarchar	1	0
14	T7CNRM_REPORT	Report	6	RTYPE	Report Type	nvarchar	1	0
15	ZTARGET_PARTNERG	System Landscapes: Header Data	4	RTYPE	Landscape name	nvarchar	20	0
TOPBasic Functions
16	T046S	Exceptions from cashed bills of exchange paid to vendors	5	RTYPE	Reason for refusal to pay bill/exch. returned to house bank	nvarchar	2	0
17	T884	Currency translation	8	RTYPE	Exchange rate indicator	nvarchar	1	0
18	TABA	Depreciation posting documents	12	RTYPE	Type of Depreciation Run	nvarchar	1	0
TOPClinical System
19	N1ORATE	IS-H*MED: Medication, Dosage Quantities Infusions	24	RTYPE	Medication: Flow Rate Type	nvarchar	2	0
20	N1TPORATE	IS-H*MED: Dosage Quantities of Template	20	RTYPE	Medication: Flow Rate Type	nvarchar	2	0
TOPCompensation Management
21	T71LB1	Award	20	RTYPE	Security Price Type	nvarchar	2	0
TOPConsumption-Based Planning See Also PP-MRP
22	MDRD	Delivery Relationships: Recipients per Plant and Material	5	RTYPE	Delivery Relationship: Type of Goods Recipient	nvarchar	1	0
23	MDRD_EXTWG	Delivery Relationships: Recipients per Plant and Material	5	RTYPE	Delivery Relationship: Type of Goods Recipient	nvarchar	1	0
24	WDRD	Delivery Relationships: Recipients per Plant and Material	5	RTYPE	Delivery Relationship: Type of Goods Recipient	nvarchar	1	0
25	WDRD_EXTWG	Delivery Relationships: Recipients per Plant and Material	5	RTYPE	Delivery Relationship: Type of Goods Recipient	nvarchar	1	0
TOPContract Accounts Receivable and Payable
26	DFKKDOUBTD_RET_W	Buffer: Printout for Ind.Val.Ad - Return Values (User Event)	19	RTYPE	FPRW: Record Type (Internal Use)	nvarchar	1	0
27	DFKKDOUBTD_W	Buffer: Create Printout for Receivables Adjustment	34	RTYPE	FPRW: Record Type (Internal Use)	nvarchar	1	0
TOPData Staging
28	RSTRAN_R_CURR	Currency Translations for Transformation Runtime Unit Test	2	RTYPE	Exchange Rate Type	nvarchar	4	0
TOPEnvironment, Health and Safety Master Data
29	THM097	DG: Mixed Loading Rules	6	RTYPE	Response Type for Mixed Loading Rules	nvarchar	1	0
TOPFinancial Accounting
30	FBICRC001A	ICRC: Open Items GL Accounts: Documents	19	RTYPE	Record Type	nvarchar	1	0
31	FBICRC001C	ICRC: Open Items GL Accounts: Object Table 2	4	RTYPE	Record Type	nvarchar	1	0
32	FBICRC001P	Not in use	18	RTYPE	Record Type	nvarchar	1	0
33	FBICRC001T	ICRC: Open Items GL Accounts: Totals	18	RTYPE	Record Type	nvarchar	1	0
34	FBICRC002A	ICRC: GL Accounts: Documents	19	RTYPE	Record Type	nvarchar	1	0
35	FBICRC002C	ICRC: GL Accounts: Object table 2	4	RTYPE	Record Type	nvarchar	1	0
36	FBICRC002P	Not in use	18	RTYPE	Record Type	nvarchar	1	0
37	FBICRC002T	ICRC: GL Accounts: Totals	18	RTYPE	Record Type	nvarchar	1	0
38	FBICRC003A	ICRC: Open Items Customers/Vendors: Documents	20	RTYPE	Record Type	nvarchar	1	0
39	FBICRC003C	ICRC: Open Items Customers/Vendors: Object table 2	4	RTYPE	Record Type	nvarchar	1	0
40	FBICRC003P	Not in use	19	RTYPE	Record Type	nvarchar	1	0
41	FBICRC003T	ICRC: Open Items Customers/Vendors: Totals	19	RTYPE	Record Type	nvarchar	1	0
TOPForms
42	T59_PROTL	RPDSYS-SE61 Conversion: Log Table Reference	9	RTYPE	Documentation Object Type	nvarchar	4	0
TOPGlobal Trade Services
43	/SAPSLL/LCCUSMPT	SLL: Reproduction of Customs Duty Types - Description	5	RTYPE	Duty Type from Data Provider	nvarchar	4	0
44	/SAPSLL/LC_CUSM	GTS: Customs Processing: Mapping of Customs Duty Types	3	RTYPE	Duty Type from Data Provider	nvarchar	4	0
45	/SAPSLL/LC_CUSMP	SLL: Customs Processing: Reproduction of Customs Duty Types	4	RTYPE	Duty Type from Data Provider	nvarchar	4	0
TOPGreat Britain
46	T5G28	SMP Rates Payable	6	RTYPE	Maternity pay record type - amount/percent	nvarchar	1	0
TOPIreland
47	T7IEE	EHECS: Return Data	9	RTYPE	EHECS: Report Type	nvarchar	1	0
TOPJapan
48	T7JPLV_FILESTRU	Define File Structure	6	RTYPE	Record Type	nvarchar	2	0
TOPLong-Term Incentives
49	T71LTI02	LTI Plan Time Dependent Attributes	9	RTYPE	Security Price Type	nvarchar	2	0
TOPNorway
50	REIMB_RECON_COM	Comments for Reimbursement Reconciliation report	5	RTYPE	Single-Character Indicator	nvarchar	1	0
TOPOLAP Technology
51	RSCURTRT	Currency Translation Types	3	RTYPE	Exchange Rate Type	nvarchar	4	0
52	RSDDTPS_CONV	Conversion Indices in Polestar	4	RTYPE	Exchange Rate Type	nvarchar	4	0
TOPOverhead Cost Controlling
53	CSKR	Resource master record	6	RTYPE	Resource type	nvarchar	1	0
TOPPerformance Assessment Workbench
54	SLS_PRES	PAW - Person Results Structure	30	RTYPE	Result type (PAW)	nvarchar	1	0
55	SLS_RTEST	PAW - Participant's Aggregated Test Results	8	RTYPE	Result type (PAW)	nvarchar	1	0
56	SLS_YTEST	PAW - Participant's Aggregated Test Results	8	RTYPE	Result type (PAW)	nvarchar	1	0
TOPPersonnel Administration
57	T513V	RPDSYS00 - Cross References	3	RTYPE	Documentation Object Type	nvarchar	4	0
58	T588G	Field-Specific Retroactive Accounting Recognition	6	RTYPE	Retroactive Accounting Category	nvarchar	1	0
TOPProcess Controls
59	GRPCQLIBRARY	Question Library	7	RTYPE	Question Rating Type	nvarchar	2	0
TOPReporting
60	MCRSV_USR	Selection version: Assigned distribution lists or users	5	RTYPE	Specification of recipient type	nvarchar	1	0
TOPSAP Healthcare - Industry-Specific Components for Hospitals
61	/ISHFR/TN290_COD	IS-H FR: Receipt Codes	3	RTYPE	IS-H FR: Code Type (Receipt)	nvarchar	1	0
TOPStructures Workbench
62	/ISDFPS/CCRTYPE1	Assign Usage Types to Relationship Types	3	RTYPE	Relationship Type	nvarchar	3	0
63	/ISDFPS/CCRTYPE2	Relationship Assignment for Each Usage/Relationship Ty. Pair	3	RTYPE	Relationship Type	nvarchar	3	0
64	/ISDFPS/CFDPSC1	Relationship Types	2	RTYPE	Relationship Type	nvarchar	3	0
65	/ISDFPS/CFDPSC1T	Text Table Relationship Types	2	RTYPE	Relationship Type	nvarchar	3	0
66	/ISDFPS/CFDPSC2	Relationship Groups	2	RTYPE	Relationship Type	nvarchar	3	0
67	/ISDFPS/CFDPSC3	Relationship Group Assignment	2	RTYPE	Relationship Type	nvarchar	3	0
68	/ISDFPS/CFDPSC3T	Text Table Relationship Group Assignment	2	RTYPE	Relationship Type	nvarchar	3	0
69	/ISDFPS/CFDPSC4	Assignment of Relationship Types to Force Element Types	4	RTYPE	Relationship Type	nvarchar	3	0
TOPSyntax, Compiler, Runtime
70	SXBNFRULE	XBNF rules	3	RTYPE	XBNF RTYPE	nvarchar	1	0
TOPTraders and Schedulers Workbench
71	OIJNOMCOMM	Nomination Partner Communication	4	RTYPE	OIL-TSW: Role type	nvarchar	6	0
72	OIJRRA	OIL-TSW: Partner roles	6	RTYPE	OIL-TSW: Role type	nvarchar	6	0
73	OIJRRT	OIL-TSW: Partner role types	2	RTYPE	OIL-TSW: Role type	nvarchar	6	0
74	OIJRRTT	OIL-TSW: Partner role type texts	3	RTYPE	OIL-TSW: Role type	nvarchar	6	0
75	OIJSHIPVALD	OIL TSW: Shipper valid for other partner roles	2	RTYPE	OIL-TSW: Role type	nvarchar	6	0
76	TOIJ_BPD_FIELDS	Customizing Table Business Process Dialog	2	RTYPE	OIL-TSW: Role type	nvarchar	6	0
77	TOIJ_BPD_PMAP	Nomination Partner Communication Partner Mapping	2	RTYPE	OIL-TSW: Role type	nvarchar	6	0
78	TOIJ_EL_MVSCEN	TSW: Define Movement scenarios	17	RTYPE	OIL-TSW: Role type	nvarchar	6	0
TOPUSA
79	BRCDTA	BSI-TAX 4.0 BRCDTA	5	RTYPE	BSI40: RTYPE	nvarchar	1	0
80	BRCGDTA	BSI-TAX 4.0 BRCGDTA	5	RTYPE	BSI40: RTYPE	nvarchar	1	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

80 columns | ERP 6.0 | RTYPE