	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

137 columns | ERP 6.0 | RECORD_ID

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/FLDQ/AD_QU_INDX	QU2 Index Table	1	RECORD_ID	Parameter ID for Editing object	nvarchar	20	0
2	/FLDQ/HNA_PREQU2	staging table for RSADRQU2 report	1	RECORD_ID	Parameter ID for Editing object	nvarchar	20	0
3	/FLDQ/HNA_PSTQU2	Result Table for RSADRQU2 report	1	RECORD_ID	Parameter ID for Editing object	nvarchar	20	0
4	/SYCLO/PSH01	Syclo Push Register	5	RECORD_ID	Record Id	int	10	0
5	/SYCLO/PSH10	Push framework: subscription queue	3	RECORD_ID	Record Number	nvarchar	10	0
6	/SYCLO/SYSLOG001	System statistics - Middleware integration	3	RECORD_ID	Record no.	nvarchar	10	0
7	/SYCLO/WB001	DevTool: Mobile Screen Definition	7	RECORD_ID	DevTool: readable identifier	int	10	0
8	/SYCLO/WB001F	DevTool: Mobile Screen layout	12	RECORD_ID	DevTool: readable identifier	int	10	0
9	/SYCLO/WB001V	DevTool: Screen field value table	10	RECORD_ID	DevTool: readable identifier	int	10	0
10	/SYCLO/WB002	DevTool: object	7	RECORD_ID	DevTool: readable identifier	int	10	0
11	/SYCLO/WB002A	DevTool: Object attributes	9	RECORD_ID	DevTool: readable identifier	int	10	0
12	/SYCLO/WB003	DevTool: Mobile Screen Set	8	RECORD_ID	DevTool: readable identifier	int	10	0
13	/SYCLO/WB004	DevTool: Action definition	9	RECORD_ID	DevTool: readable identifier	int	10	0
14	/SYCLO/WB005	DevTool: client data table	8	RECORD_ID	DevTool: readable identifier	int	10	0
15	/SYCLO/WB005R	DevTool: Data table entries	8	RECORD_ID	DevTool: readable identifier	int	10	0
16	/SYCLO/WB006	DevTool: Transaction definition header	7	RECORD_ID	DevTool: readable identifier	int	10	0
17	/SYCLO/WB006A	DevTool: Client transaction attributes	10	RECORD_ID	DevTool: readable identifier	int	10	0
18	/XFT/EPA_B0001	Checklists	2	RECORD_ID	Record ID	nvarchar	32	0
19	/XFT/EPA_TBARCO	Open barcodes	5	RECORD_ID	Record ID	nvarchar	32	0
20	/XFT/EPA_TPROT	Log	3	RECORD_ID	Record ID	nvarchar	32	0
21	/XFT/SRM_DEMO_02	Property Extension	2	RECORD_ID	Record ID	nvarchar	32	0
22	CIAP_D_NF	CIAP Nota Fiscal/Record relationship	2	RECORD_ID	CIAP Record Unique ID	varbinary	16	0
23	CIAP_D_QUOTA	CIAP record quota	2	RECORD_ID	CIAP Record Unique ID	varbinary	16	0
24	CIAP_D_SUSP	CIAP Records that were manually suspended	2	RECORD_ID	CIAP Record Unique ID	varbinary	16	0
25	CNVC_CCE_USG_RES	Customizing Comparison:Result table for usage of customizing	6	RECORD_ID		nvarchar	10	0
26	T7BREFD_BENINFO	Beneficiary and income identification	3	RECORD_ID	Record code	nvarchar	9	0
27	T7BREFD_BENONRES	Data of beneficiary non-resident or resident abroad	3	RECORD_ID	Record code	nvarchar	9	0
28	T7BREFD_BRANCH	Place of work	3	RECORD_ID	Record code	nvarchar	9	0
29	T7BREFD_DEPPLAN	Dependent of health care private plan	3	RECORD_ID	Record code	nvarchar	9	0
30	T7BREFD_DETCOM	Detail of competences to which the payment refers	3	RECORD_ID	Record code	nvarchar	9	0
31	T7BREFD_DETDEDUC	Detail of deductions	3	RECORD_ID	Record code	nvarchar	9	0
32	T7BREFD_DNOD1300	Dependents control of the eSocial framework 1300 - PAY	3	RECORD_ID	Record code	nvarchar	9	0
33	T7BREFD_DTCTRL	Current and previous validity	3	RECORD_ID	Record code	nvarchar	9	0
34	T7BREFD_EEABS	Employee temporary absence	3	RECORD_ID	Record code	nvarchar	9	0
35	T7BREFD_EEADDR	Employee address	3	RECORD_ID	Record code	nvarchar	9	0
36	T7BREFD_EEASO	Occupational health certificate	3	RECORD_ID	Record code	nvarchar	9	0
37	T7BREFD_EEBANK	Employee bank details	3	RECORD_ID	Record code	nvarchar	9	0
38	T7BREFD_EECNTC	Employee contact information	3	RECORD_ID	Record code	nvarchar	9	0
39	T7BREFD_EECNTR	Employment information	3	RECORD_ID	Record code	nvarchar	9	0
40	T7BREFD_EECOMP	Employee identification additional information	3	RECORD_ID	Record code	nvarchar	9	0
41	T7BREFD_EEDEP	Dependents	3	RECORD_ID	Record code	nvarchar	9	0
42	T7BREFD_EEDISA	Challenged employee	3	RECORD_ID	Record code	nvarchar	9	0
43	T7BREFD_EEDOCS	Employee identification documents	3	RECORD_ID	Record code	nvarchar	9	0
44	T7BREFD_EEDWSC	Regular workday information	3	RECORD_ID	Record code	nvarchar	9	0
45	T7BREFD_EEEDMP	Dismissal protection end	3	RECORD_ID	Record code	nvarchar	9	0
46	T7BREFD_EEEODS	Union leader source company	3	RECORD_ID	Record code	nvarchar	9	0
47	T7BREFD_EEEWSC	Special workday information	3	RECORD_ID	Record code	nvarchar	9	0
48	T7BREFD_EEEXAM	Tests done	3	RECORD_ID	Record code	nvarchar	9	0
49	T7BREFD_EEFACT	Relevant fact statement	3	RECORD_ID	Record code	nvarchar	9	0
50	T7BREFD_EEFOR	Foreign employee	3	RECORD_ID	Record code	nvarchar	9	0
51	T7BREFD_EEFWSC	Workday in fixed shifts information	3	RECORD_ID	Record code	nvarchar	9	0
52	T7BREFD_EEGAR	Payments made to alimony beneficiaries	3	RECORD_ID	Record code	nvarchar	9	0
53	T7BREFD_EEIDPY	Worker identification	3	RECORD_ID	Record code	nvarchar	9	0
54	T7BREFD_EEINFO	Employee information	3	RECORD_ID	Record code	nvarchar	9	0
55	T7BREFD_EELAWS	Lawsuit of the employee	3	RECORD_ID	Record code	nvarchar	9	0
56	T7BREFD_EELINF	Employee legal information	3	RECORD_ID	Record code	nvarchar	9	0
57	T7BREFD_EELVNT	Employee leave notice	3	RECORD_ID	Record code	nvarchar	9	0
58	T7BREFD_EEOINF	Other information of employee	3	RECORD_ID	Record code	nvarchar	9	0
59	T7BREFD_EEORES	Condominium information	3	RECORD_ID	Record code	nvarchar	9	0
60	T7BREFD_EEPACT	Performed activity	3	RECORD_ID	Record code	nvarchar	9	0
61	T7BREFD_EERABS	Employee temporary absence return	3	RECORD_ID	Record code	nvarchar	9	0
62	T7BREFD_EEREM	Remuneration information	3	RECORD_ID	Record code	nvarchar	9	0
63	T7BREFD_EERISK	Harmful agents	3	RECORD_ID	Record code	nvarchar	9	0
64	T7BREFD_EERSNC	Change to absence reason	3	RECORD_ID	Record code	nvarchar	9	0
65	T7BREFD_EESDMP	Dismissal protection start	3	RECORD_ID	Record code	nvarchar	9	0
66	T7BREFD_EESVNC	Information group of employment relationship succession	3	RECORD_ID	Record code	nvarchar	9	0
67	T7BREFD_EETEMP	Worker on temporary loan	3	RECORD_ID	Record code	nvarchar	9	0
68	T7BREFD_EETERM	Termination	3	RECORD_ID	Record code	nvarchar	9	0
69	T7BREFD_EETRFR	Worker transfer information group	3	RECORD_ID	Record code	nvarchar	9	0
70	T7BREFD_EEVWSC	Relief shift workday information	3	RECORD_ID	Record code	nvarchar	9	0
71	T7BREFD_EEWDAY	Contract schedule	3	RECORD_ID	Record code	nvarchar	9	0
72	T7BREFD_EEWERT	Info termination employee with no employment relationship	3	RECORD_ID	Record code	nvarchar	9	0
73	T7BREFD_EEWRKP	Employee place of work	3	RECORD_ID	Record code	nvarchar	9	0
74	T7BREFD_EEWSCH	Workday	3	RECORD_ID	Record code	nvarchar	9	0
75	T7BREFD_ERBKSH	Bank information	3	RECORD_ID	Record code	nvarchar	9	0
76	T7BREFD_ERCNTC	Contact of person responsible for information	3	RECORD_ID	Record code	nvarchar	9	0
77	T7BREFD_ERCOINFO	Company additional information	3	RECORD_ID	Record code	nvarchar	9	0
78	T7BREFD_EREXEM	Additional information - Exempted companies - Exemption data	3	RECORD_ID	Record code	nvarchar	9	0
79	T7BREFD_ERFGTS	Exclusive information for FGTS	3	RECORD_ID	Record code	nvarchar	9	0
80	T7BREFD_ERINFO	Employer identification	3	RECORD_ID	Record code	nvarchar	9	0
81	T7BREFD_EROINF	Other employer information	3	RECORD_ID	Record code	nvarchar	9	0
82	T7BREFD_ERSWHO	Software house information	3	RECORD_ID	Record code	nvarchar	9	0
83	T7BREFD_EVDEL	Event exclusion	3	RECORD_ID	Record code	nvarchar	9	0
84	T7BREFD_EXMPINC	Exempt/non-taxable income	3	RECORD_ID	Record code	nvarchar	9	0
85	T7BREFD_FINIS	NIS archive information	3	RECORD_ID	Record code	nvarchar	9	0
86	T7BREFD_HELPLAN	CNPJ of health plan provider	3	RECORD_ID	Record code	nvarchar	9	0
87	T7BREFD_INFRRA	Additional information - income received cumulatively	3	RECORD_ID	Record code	nvarchar	9	0
88	T7BREFD_ININFO	Trainee exclusive information	3	RECORD_ID	Record code	nvarchar	9	0
89	T7BREFD_JOB	Job information	3	RECORD_ID	Record code	nvarchar	9	0
90	T7BREFD_LAWCOINF	Additional information of legal decisions	3	RECORD_ID	Record code	nvarchar	9	0
91	T7BREFD_LAWYER	Lawyer identification	3	RECORD_ID	Record code	nvarchar	9	0
92	T7BREFD_LEGALFEE	Detail of lawsuit fees	3	RECORD_ID	Record code	nvarchar	9	0
93	T7BREFD_LEGCOMP	Information regarding legal compensation	3	RECORD_ID	Record code	nvarchar	9	0
94	T7BREFD_NOTPER	Notice	3	RECORD_ID	Record code	nvarchar	9	0
95	T7BREFD_NRESIPAY	Payment to non-resident or resident abroad	3	RECORD_ID	Record code	nvarchar	9	0
96	T7BREFD_NTPRCA	Cancellation of notice period	3	RECORD_ID	Record code	nvarchar	9	0
97	T7BREFD_PAYBPF	Beneficiary natural person - resident in Brazil	3	RECORD_ID	Record code	nvarchar	9	0
98	T7BREFD_PAYBPJ	Framework table control	3	RECORD_ID	Record code	nvarchar	9	0
99	T7BREFD_PYAGRE	Identification of agreement/convention/bargaining	3	RECORD_ID	Record code	nvarchar	9	0
100	T7BREFD_PYCMPL	Payroll additional information	3	RECORD_ID	Record code	nvarchar	9	0
101	T7BREFD_PYGAR	Payments made to alimony beneficiaries	3	RECORD_ID	Record code	nvarchar	9	0
102	T7BREFD_PYINFO	Payroll additional information	3	RECORD_ID	Record code	nvarchar	9	0
103	T7BREFD_PYPAY	Wage types that form employee remuneration	3	RECORD_ID	Record code	nvarchar	9	0
104	T7BREFD_PYPER	period to which the remuneration differences refer to	3	RECORD_ID	Record code	nvarchar	9	0
105	T7BREFD_PYREM	Employee remuneration information	3	RECORD_ID	Record code	nvarchar	9	0
106	T7BREFD_PYREOT	Remuneration other company codes	3	RECORD_ID	Record code	nvarchar	9	0
107	T7BREFD_PYRESC	Information regarding indemnity amounts	3	RECORD_ID	Record code	nvarchar	9	0
108	T7BREFD_PYREVN	Payroll additional information	3	RECORD_ID	Record code	nvarchar	9	0
109	T7BREFD_PYTOT	Totaling of worker's remuneration	3	RECORD_ID	Record code	nvarchar	9	0
110	T7BREFD_PYWPL	Establishment identification and workplace	3	RECORD_ID	Record code	nvarchar	9	0
111	T7BREFD_PYWTAM	Wage types that form employee remuneration	3	RECORD_ID	Record code	nvarchar	9	0
112	T7BREFD_TEMPWRK	Infomation regarding temporary worker's remuneration	3	RECORD_ID	Record code	nvarchar	9	0
113	T7BREFD_WRKPLC	Workplace information	3	RECORD_ID	Record code	nvarchar	9	0
114	T7BREFD_WRKSCH	Workday information	3	RECORD_ID	Record code	nvarchar	9	0
115	T7BREFD_WTLAWS	Processes	3	RECORD_ID	Record code	nvarchar	9	0
116	T7BREFD_WTYPE	Wage type information	3	RECORD_ID	Record code	nvarchar	9	0
TOPBasis Components
117	/XFT/INV_Q	Invoice receipt queue: Header	23	RECORD_ID	Record ID	nvarchar	32	0
118	/XFT/INV_Q_S	Invoice receipt queue: Header	23	RECORD_ID	Record ID	nvarchar	32	0
TOPClinical System
119	N2DI_RECORD	Administration Data of Speech Recording	2	RECORD_ID	Recording ID	nvarchar	32	0
120	N2DI_RECORD_TEXT	Clear Text of Speech Recording	2	RECORD_ID	Recording ID	nvarchar	32	0
TOPContract Accounts Receivable and Payable
121	TFKK_EXTR_STR	Short Extracts: Structures	2	RECORD_ID	Short Extracts: Record ID	nvarchar	2	0
TOPEasy Enhancement Workbench
122	AXT_TABLE_TMPL	Extensibility Template for new tables	2	RECORD_ID	Record ID	varbinary	16	0
TOPLoans Management
123	VDCBR_RES_HT	Header and Totals Records for Data Reported to Credit Bur.	6	RECORD_ID	Key for Header Record of Reporting File	nvarchar	6	0
TOPMaster Data
124	BCA_US_HLD2REL	Hold Records which have not been released - Dual Control	4	RECORD_ID	Record ID Type for Hold Table	nvarchar	10	0
125	BCA_US_HOLD	Hold Amounts Which Affect Available Balance	4	RECORD_ID	Record ID Type for Hold Table	nvarchar	10	0
126	ISM_PCSADR_LOG	IS-M Postal Change Service: Address Update - Log Table	4	RECORD_ID	Record Index	nvarchar	9	0
TOPSAP Records Management
127	SRMRGCONTC	Context Counter: Highest Counter Readings	3	RECORD_ID	Record Character Generator: Unique ID	nvarchar	32	0
TOPWorkforce Management Application
128	WFA_AGTEVT_EL	Agent (Scheduled) Event Eligibility	7	RECORD_ID	WFM GUID	varbinary	16	0
129	WFA_SCEVT_ORG	Schedule Event - Organization Relationship	9	RECORD_ID	WFM GUID	varbinary	16	0
130	WFA_SCEVT_QUL	Schedule Event - Qualifications Relationship	9	RECORD_ID	WFM GUID	varbinary	16	0
131	WFA_SCEVT_WA	Work filter on schedule events	7	RECORD_ID	WFM GUID	varbinary	16	0
132	WFA_TEAM_EVT	Teams assigned to a scheduled event	10	RECORD_ID	WFM GUID	varbinary	16	0
TOPWorkforce Management Core
133	WFMCAS_AGTEVT_EL	Agent (Scheduled) Event Eligibility	7	RECORD_ID	WFM GUID	varbinary	16	0
134	WFMCAS_SCEVT_ORG	Schedule Event - Organization Relationship	9	RECORD_ID	WFM GUID	varbinary	16	0
135	WFMCAS_SCEVT_QUL	Schedule Event - Qualifications Relationship	9	RECORD_ID	WFM GUID	varbinary	16	0
136	WFMCAS_SCEVT_WA	Work filter on schedule events	7	RECORD_ID	WFM GUID	varbinary	16	0
137	WFMCAS_TEAM_EVT	Teams assigned to a scheduled event	10	RECORD_ID	WFM GUID	varbinary	16	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

137 columns | ERP 6.0 | RECORD_ID