	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	OIVL	77	Whse Journal
5	OVPM	154	Outgoing Payments
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

161 columns | ERP 6.0 | PERID

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	HRP1789	DB Table for Infotype 1789	19	PERID	Academic Session	nvarchar	3	0
2	HRP1798	DB Table for Infotype 1798	19	PERID	Academic Session	nvarchar	3	0
3	P2RB_PERM	Personal Features	11	PERID	Personnel ID Number	nvarchar	20	0
4	P2RB_SV	Social Insurance payroll Belgium	16	PERID	Personnel ID Number	nvarchar	20	0
5	P2RD_PERM	Payroll Results: Personal Features	11	PERID	Personnel ID Number	nvarchar	20	0
6	P2RK_PERM	Personal Characteristics	6	PERID	Personnel ID Number	nvarchar	20	0
7	P2RM_MTAX	Payroll Result: Tax (DK)	9	PERID	Personnel ID Number	nvarchar	20	0
8	P2RU_PERM	Personal Characteristics	7	PERID	Personnel ID Number	nvarchar	20	0
9	PAPBSGB_SWF_STAF	SWF: Staff Details	14	PERID	Personnel ID Number	nvarchar	20	0
10	PIQDB_DE_STATHDR	Header Table for Statistical Reporting Germany	9	PERID	Academic Session	nvarchar	3	0
11	T7PIQ_DE_MTPERID	Mapping table for Academic Periods	2	PERID	Academic Session	nvarchar	3	0
12	T868	Elimination of IC profit and loss	5	PERID	Period	nvarchar	3	0
13	TSTGC	Consolidation test data	6	PERID	Period	nvarchar	3	0
14	HRP1707	Database Table for Infotype 1707	23	PERID	Note Reference to an Academic Session	nvarchar	3	0
15	HRP1739	DB Table for Infotype 1739	19	PERID	Academic Session	nvarchar	3	0
16	HRP1771	DB Table for Infotype 1771	19	PERID	Academic Session	nvarchar	3	0
17	HRP1772	DB Table for Infotype 1772	54	PERID	Academic Session	nvarchar	3	0
18	HRPAD503	Additional Data for PAD503	4	PERID	Academic Session	nvarchar	3	0
19	HRPAD506	Additional Data for PAD506	17	PERID	Academic Session	nvarchar	3	0
20	HRPAD512	Additional Data for PAD512	4	PERID	Academic Session	nvarchar	3	0
21	HRPAD532	Additional Data for PAD508	13	PERID	Academic Session	nvarchar	3	0
22	HRPAD547	Additional Data PAD547	6	PERID	Academic Session	nvarchar	3	0
23	HRT1737	Table Section for Infotype 1737	17	PERID	Academic Session for Progression Result	nvarchar	3	0
24	HRT1750	Table Section for Infotype 1750	6	PERID	Academic Session	nvarchar	3	0
25	HRT1764	Table Section for Infotype 1764	11	PERID	Academic Session	nvarchar	3	0
26	HRT1773	Table Section for Infotype 1773	32	PERID	Academic Session	nvarchar	3	0
27	PIQDBCMPRRECORDS	Assessment Process	9	PERID	Assessment Session	nvarchar	3	0
28	PIQDBEVOBOFFER	Scheduled Assessment	6	PERID	Academic Session	nvarchar	3	0
29	PIQDBEVOBOFFER2	Scheduled Assessment: Functions	6	PERID	Academic Session	nvarchar	3	0
30	PIQDBEVOBOFFER3	Scheduled Assessment: Location/Time	6	PERID	Academic Session	nvarchar	3	0
31	PIQDBLMSLPID	Learning Product UUID - LMS	5	PERID	Academic Session	nvarchar	3	0
32	PIQDBOFFERMP1	Templates Copied for Academic Period	4	PERID	Academic Session	nvarchar	3	0
33	PIQDBOFFERMP2	Business Events Copied for Academic Period	5	PERID	Academic Session	nvarchar	3	0
34	PIQPROC_ED_INT_W	ED Activity Document: Transferred Internal Academic Work	19	PERID	Assigned Academic Session of Internal Academic Work/Qualif.	nvarchar	3	0
35	PIQPROC_PG_DT	Activity Document: Progression Details	18	PERID	Academic Session for Progression Result	nvarchar	3	0
36	PIQPROC_PG_MB	Activity Document: Module Booking	10	PERID	Academic Session	nvarchar	3	0
37	T7PIQOFFERPATDEF	Session Pattern Definition	3	PERID	Academic Session	nvarchar	3	0
38	T7PIQPERASSIGN	Academic Session/Group Assignments	3	PERID	Academic Session	nvarchar	3	0
39	T7PIQPERIOD	Academic Sessions	2	PERID	Academic Session	nvarchar	3	0
40	T7PIQPERIODT	Academic Sessions (Text Table)	3	PERID	Academic Session	nvarchar	3	0
41	T7PIQSTDYEARPRD	Standard Academic Year/Session Assignments	3	PERID	Academic Session	nvarchar	3	0
42	T7PIQYEARPRD	Academic Year/Session Assignments	3	PERID	Academic Session	nvarchar	3	0
43	T7PIQ_NL_ENRNM	Mapping Table for Year/ Session and Enrollment Moment Code	3	PERID	Academic Session	nvarchar	3	0
44	T7PIQ_US_PTINDX	Customizing to map Program Full time and Performance Index	6	PERID	Academic Session	nvarchar	3	0
45	TCMACGRHD	Grants Document Header	4	PERID	Academic Session	nvarchar	3	0
46	TCMACGRIT	Grants Document Items	5	PERID	Academic Session	nvarchar	3	0
47	TCMACSUBTYPERID	CO-Integration: Map Acad. Session to Subtype of infty 1759	2	PERID	Academic Session	nvarchar	3	0
TOPBasic Data
48	TN01Z	IS-H: Table for Period Input Help	3	PERID	IS-H: Period for Time Interval Input Help	nvarchar	8	0
TOPBasic Functions
49	T850D	Assignment of business segment	4	PERID	Period	nvarchar	3	0
50	T850S	Tax rates	4	PERID	Period	nvarchar	3	0
51	T851	Changes in Investments	7	PERID	Period	nvarchar	3	0
52	T852P	Consolidation Periods	3	PERID	"To" period for the period interval	nvarchar	3	0
53	T852U	Subgroup companies	6	PERID	Period	nvarchar	3	0
54	T853	Company status	6	PERID	Period	nvarchar	3	0
55	T853K	Subgroup status	6	PERID	Period	nvarchar	3	0
56	T864	Reclassifications	3	PERID	Period	nvarchar	3	0
57	T865	Intercompany Elimination	3	PERID	Period	nvarchar	3	0
58	T868B	Elimination of IC profit/loss: Inventory management co.s	4	PERID	Period	nvarchar	3	0
59	T869	Consolidation methods	6	PERID	Goodwill amortization: Duration in months	nvarchar	3	0
60	T871	Changes in investee equity	6	PERID	Period	nvarchar	3	0
61	T872	Equity Holdings Adjustments	7	PERID	Period	nvarchar	3	0
62	T873	Hidden reserves	6	PERID	Period	nvarchar	3	0
63	T875	Asset transfers within the group	9	PERID	Period	nvarchar	3	0
64	T875C	Changes in depreciation	6	PERID	Period	nvarchar	3	0
65	T875D	Asset transfers	33	PERID	Period of asset transfer	nvarchar	3	0
66	T875E	Change in depreciation of asset transfers	7	PERID	Period	nvarchar	3	0
TOPBelgium
67	PA0735	HR Master Record: Infotype 0735 (Dimona B)	47	PERID	Dimona Period ID (00913)	nvarchar	12	0
68	T5BDI0	HR-BE: Dimona Central Table	4	PERID	Dimona Period ID (00913)	nvarchar	12	0
TOPBenefits
69	T74AB	COBRA dependent of qualified beneficiary	11	PERID	Personnel ID Number	nvarchar	20	0
TOPCollectionsDisbursements
70	TVS010H	IS-IS Scheduling: Percentage Distribution in Paymt Plan	3	PERID	Period identification	nvarchar	3	0
TOPConsolidation
71	TF080	List Directory of MCDX	7	PERID	Period	nvarchar	3	0
72	TF154	Dimensions year- and period-dependent	4	PERID	Effective from period	nvarchar	3	0
73	TF155	Dimensions: Assign Task Groups	5	PERID	Effective from period	nvarchar	3	0
74	TF163	Consolidation Units, Version/Period-Based Attributes	6	PERID	Effective from period	nvarchar	3	0
75	TF167	Consolidation Units Version- and Period-Dependent	6	PERID	Effective from period	nvarchar	3	0
76	TF169	Version/Period-Dependent Cons. Units: Tax Rates	6	PERID	Effective from period	nvarchar	3	0
77	TF183A	Consolidation Groups - Restricted Task Groups	5	PERID	Effective from period	nvarchar	3	0
78	TF187	Consolidation Group Set Assignments	6	PERID	Period	nvarchar	3	0
79	TF188	Consolidation Group Assignment of Task Group	6	PERID	Effective from period	nvarchar	3	0
80	TF189	Assignment of CG/CU, Version- and Period-Dependent	7	PERID	Effective from period	nvarchar	3	0
81	TF192	Hierarchies, Period-Dependent	5	PERID	Effective from period	nvarchar	3	0
82	TF242	Consolidation Periods	3	PERID	To period	nvarchar	3	0
83	TF250	Periods, Opened/Closed	6	PERID	Period	nvarchar	3	0
84	TF260	Overall Status of CG/CU - Data Monitor	6	PERID	Period	nvarchar	3	0
85	TF261	CG/CU: Detail Status of Tasks - Data Monitor	6	PERID	Period	nvarchar	3	0
86	TF262	History of Data Entry Layouts	5	PERID	Period	nvarchar	3	0
87	TF270	CG/CU Overall Status of Consolidation Monitor	6	PERID	Period	nvarchar	3	0
88	TF271	CG/CU: Detail Status of Tasks - Consolidation Monitor	6	PERID	Period	nvarchar	3	0
89	TF280	User-Defined Tasks	5	PERID	Effective from period	nvarchar	3	0
90	TF362	Download: Selection Parameters for Downloading Fin. Data	9	PERID	Period	nvarchar	3	0
91	TF425	Exchange Rate Indicators: ER Type Assignments	5	PERID	Effective from period	nvarchar	3	0
92	TF543	Consolidation Tasks: Assignments of Methods and Doc.Types	6	PERID	Effective from period	nvarchar	3	0
93	TF544	Tasks: Task Group Exceptions	7	PERID	Effective from period	nvarchar	3	0
94	TF545	Consolidation Tasks: Exceptions for Cons Units	7	PERID	Effective from period	nvarchar	3	0
95	TF562	Assignment of Method/Doc. Type to Task in Reclassification	6	PERID	Effective from period	nvarchar	3	0
96	TF570	Tasks for Manual Posting - Document Type Assignments	6	PERID	Effective from period	nvarchar	3	0
97	TF575	Tasks for CG Changes: Document Type Assignments	6	PERID	Effective from period	nvarchar	3	0
98	TF585	Inventory Data	6	PERID	Period	nvarchar	3	0
99	TF586	Supplier Data	5	PERID	Effective from period	nvarchar	3	0
100	TF595	Elimination of IU Profit/Loss in Inventory: Tasks	6	PERID	Effective from period	nvarchar	3	0
101	TF599	Global Settings for Elim. of IU P/L in Inventory	4	PERID	Effective from period	nvarchar	3	0
102	TF615	C/I Tasks: Assignment of Document Types	6	PERID	Effective from period	nvarchar	3	0
103	TF616	C/I Activities/Acctg Techniques: Document Type Assignments	7	PERID	Effective from period	nvarchar	3	0
104	TF620	Changes in Investments	8	PERID	Period	nvarchar	3	0
105	TF625	Group Shares	9	PERID	Effective from period	nvarchar	3	0
106	TF630	Changes in Investee Equity	8	PERID	Period	nvarchar	3	0
107	TF643	Fair Value Adjustments: Version/Date-Sensitive	8	PERID	Effective from period	nvarchar	3	0
108	TF645	Reporting Fair Value Adjustment Data	8	PERID	Period	nvarchar	3	0
109	TF650	C/I Activity Numbers	8	PERID	Period	nvarchar	3	0
110	TF651	Activity Numbers - Sequence	8	PERID	Period	nvarchar	3	0
111	TF652	Activity Numbers - Sequence - Sort Status	7	PERID	Period	nvarchar	3	0
112	TF660	Equity Holdings Adjustments	8	PERID	Period	nvarchar	3	0
113	TF661	Equity Holdings Adjustments by Upper Unit	8	PERID	Period	nvarchar	3	0
114	TFMIG10	Migration: Processing Options	7	PERID	Period	nvarchar	3	0
TOPFinland
115	T7FILIS	Table for Low Income Support Statement	6	PERID	HR_FI: Finnish person ID	nvarchar	11	0
116	T7FITELME	TEL messages	5	PERID	Social insurance number	nvarchar	11	0
TOPGermany
117	PA0521	HR Master Record: Infotype 0521 (Semiretirement D)	38	PERID	Personnel ID Number	nvarchar	20	0
TOPItaly
118	T5ITBS	Bonus Straordinario	14	PERID	Riferimento da	nvarchar	6	0
TOPNorway
119	PA0173	Tax card information	41	PERID	eTaxCard - Personnel ID Number	nvarchar	11	0
TOPPayroll
120	T5TA1	External transfers	6	PERID	Personnel ID Number	nvarchar	20	0
121	T5TELDP2004TRANS	Records ELDP for transfer from external system to SAP	24	PERID	Personnel ID Number	nvarchar	20	0
122	T5TREGTRANS	HRCZ - table for transfer items of Insured Register to SAP	18	PERID	Personnel ID Number	nvarchar	20	0
123	T7ROG2	EE register - EE history	15	PERID	Personnel ID Number	nvarchar	20	0
124	T7ROG6	EE register - EE history	17	PERID	Personnel ID Number	nvarchar	20	0
125	T7SIA3	M4 - Temporary data	5	PERID	Personnel ID Number	nvarchar	20	0
126	T7SKA1	External transfers	6	PERID	Personnel ID Number	nvarchar	20	0
TOPPayroll General Parts
127	T51G1	Off-Cycle Batch Table	13	PERID	Payroll period	nvarchar	6	0
TOPPersonnel Administration
128	PA0002	HR Master Record: Infotype 0002 (Personal Data)	54	PERID	Personnel ID Number	nvarchar	20	0
129	PA0152	Infotype 0152 - Tax data CZ	44	PERID	Personal ID number	nvarchar	20	0
130	PA0153	Infotype 0153 - SI CZ	69	PERID	Personal ID number	nvarchar	20	0
131	T7PL91	Seniority codes relevance to technical dates	5	PERID	Period identifier	nvarchar	1	0
132	T7PL92	Infotype record influence to seniority	7	PERID	Period identifier	nvarchar	1	0
TOPPortfolio Management
133	RPM_FIDATA	Financial Information	11	PERID	Period	nvarchar	3	0
134	RPM_PROJECT_CO	Controlling Information about a project	10	PERID	Period	nvarchar	3	0
135	RPM_SCENARIO_FIN	RPM : Scenario financial data	8	PERID	Period	nvarchar	3	0
TOPPublic sector Sweden
136	T5SA0_CE	Alecta	8	PERID	Personnel ID Number	nvarchar	20	0
137	T5SK0_CE	KPA events	11	PERID	Personnel ID Number	nvarchar	20	0
138	T5SP0_CE	PA91 periods	4	PERID	Personnel ID Number	nvarchar	20	0
139	T5SP1_CE	PA91 absence	4	PERID	Personnel ID Number	nvarchar	20	0
140	T5SP2_CE	PA91 income	4	PERID	Personnel ID Number	nvarchar	20	0
141	T5SS0_CE	PA03 periods	5	PERID	Personnel ID Number	nvarchar	20	0
142	T5SS1_CE	PA03 absences	5	PERID	Personnel ID Number	nvarchar	20	0
143	T5SS2_CE	PA03 income	5	PERID	Personnel ID Number	nvarchar	20	0
TOPRecruitment
144	PB0002	HR Master Record: Infotype 0002 (Personal Data)	54	PERID	Personnel ID Number	nvarchar	20	0
TOPRecycling Administration Core Functions
145	J_7LV1K	REA Document: Header Data	51	PERID	REA Declaration Periodicity	nvarchar	1	0
TOPSingapore
146	PA0412	HR Master Record: Infotype 0412 [View to I0021] (SG)	42	PERID	Personnel ID Number	nvarchar	20	0
TOPSouth Africa
147	T5WITA88	ITA88 Transaction Table	12	PERID	Personnel ID Number	nvarchar	20	0
TOPSpain
148	T5EL1	Protected data access log	6	PERID	Personnel ID Number	nvarchar	20	0
149	T5EL5	Protected data access log	5	PERID	Personnel ID Number	nvarchar	20	0
150	T5EL7	Log for accessing protected data for XML files	3	PERID	Personnel ID Number	nvarchar	20	0
TOPSweden
151	T5S0S	Messages for sickness administration (SE)	9	PERID	Personnel ID Number	nvarchar	20	0
152	T5SPP	HR-SE: Information needed to be reported to Alecta	13	PERID	Personnel ID Number	nvarchar	20	0
TOPTraining and Event Management
153	HRT1060	Table Division for Infotype 1060	4	PERID	Period for Training and Event Planning	nvarchar	3	0
TOPUnited Kingdom
154	PAGB_ASHE	ASHE Return Data	11	PERID	Personnel ID Number	nvarchar	20	0
TOPUSA
155	PA0106	HR Master Record: Infotype 0106 (Related Persons NA)	25	PERID	Personnel ID Number	nvarchar	20	0
156	T51G2	Off-Cycle Batch Table	7	PERID	Payroll period	nvarchar	6	0
TOPWorkbench Utilities
157	FLAPP	Internal flight applications	2	PERID	Personnel number	nvarchar	10	0
158	FLEMP	Employees	1	PERID	Personnel number	nvarchar	10	0
159	FLPAS	Passenger list	2	PERID	Personnel number	nvarchar	10	0
TOPWorkforce Management Application
160	WFAEM_START_DATE	Start date of the employee	6	PERID	Personnel ID Number	nvarchar	20	0
TOPWorkforce Management Core
161	WFMEM_START_DATE	Start date of the employee	6	PERID	Personnel ID Number	nvarchar	20	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

161 columns | ERP 6.0 | PERID