	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	/ISDFPS/CHVW_E	34	External Batch Where-Used List
7	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	BSEG	345	Accounting Document Segment
10	FMARCPAR	4	Parallelization of FMARC_BATCH

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

	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	OINM	101	Whse Journal
10	OSRN	20	Serial Numbers Master Data

129 columns | ERP 6.0 | TELNR

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/OTEI/OCR_TSTG	Staging table for HDCC download data	16	TELNR	Telephone Number	nvarchar	14	0
2	HRP1655	DB Table for Infotype 1655	26	TELNR	Phone Number of Organization	nvarchar	25	0
3	P05EIR_ADDRESS	Electronic Illness Reporting: Employee's Address Data	17	TELNR	Telephone number for use in wage return	nvarchar	25	0
4	P2RB_ADR	Address payroll Belgium	12	TELNR	Telephone Number	nvarchar	14	0
5	T526	Administrators	6	TELNR	Telephone Number	nvarchar	14	0
6	T5C2Q	Payroll Unit WHT Return As of ELM 4.0	9	TELNR	HR-CH: Communication number of contact person	nvarchar	20	0
7	T5CSW	HR-CH: Work Center ELM 4.0	22	TELNR	HR-CH: Communication number of contact person	nvarchar	20	0
8	T5P0E	Establishment	19	TELNR	Telephone Number	nvarchar	14	0
9	T7RU9A	Addresses of organizations	21	TELNR	Telephone Number	nvarchar	14	0
10	T7RUPA0006	PA0006 copy	31	TELNR	Telephone Number	nvarchar	14	0
11	ZSMSM	control table for SMS in SD	6	TELNR	Mobiltelefonnummer des Empfängers	nvarchar	20	0
12	ZSMSV	control table for SMS in SD	7	TELNR	Mobiltelefonnummer des Empfängers	nvarchar	20	0
13	ZSMSV2	control table for SMS in SD	7	TELNR	Mobiltelefonnummer des Empfängers	nvarchar	20	0
14	T7PIQ_GB_SCHOOL	UCAS: Schools	19	TELNR	Telephone Number	nvarchar	25	0
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
15	UBURO	Office Workplaces for Non-Academic Employees	3	TELNR	Telephone number	nvarchar	14	0
TOPAddress ManagementBusiness Address
16	SADR2	Address Management: Telephone Numbers	5	TELNR	Addresses: telephone no.	nvarchar	30	0
TOPAdvertising Management
17	JJTTS	IS-M/AM: Barred Telephone Numbers List	5	TELNR	IS-M: Telephone Number	nvarchar	20	0
TOPAustria
18	T5A1T	Social insurance institutes	9	TELNR	Telephone Number	nvarchar	14	0
TOPBasic Data
19	NBAU	IS-H: Building Units	7	TELNR	Telephone Number	nvarchar	16	0
20	NORG	IS-H: Organizational Units	14	TELNR	IS-H: Telephone Number of Organizational Unit	nvarchar	16	0
TOPBelgium
21	PA0138	HR Master Record: Infotype 0138 (Family/Ref.Pers B)	32	TELNR	Telephone Number	nvarchar	14	0
22	T5B9A	Institutions (B)	11	TELNR	Telephone Number	nvarchar	14	0
TOPBenefits
23	PA0219	HR Master Record: Infotype 0219 (External Organizations)	34	TELNR	Telephone Number	nvarchar	14	0
TOPBrazil
24	PA0736	Alimony order for Brazil	42	TELNR	Telephone Number	nvarchar	14	0
TOPBusiness Application Support
25	CNVWD	CNV watchdog: Customizing table	10	TELNR	Char 20	nvarchar	20	0
26	CNVWDM	CNV watchdog: sent messages	3	TELNR	Char 20	nvarchar	20	0
TOPBusiness Information Collection
27	UIORD_R_IUSR	Relation between Research Request and InfoUser (SEM-BIC)	5	TELNR	Complete number: dialling code+number+extension	nvarchar	30	0
TOPCanada
28	T5UTL	Tax Company	8	TELNR	Telephone Number	nvarchar	14	0
TOPChina
29	PA0528	HR Master Record: Infotype 0528 (Family information)	34	TELNR	Telephone number	nvarchar	20	0
TOPClinical System
30	N2DLV_RECEIVER	i.s.h.med: Dispatch - Recipient	19	TELNR	IS-H: Telephone Number of Business Partner	nvarchar	16	0
31	N2MV_DISREQ	Dispatch Request Data Table	25	TELNR	Dispatch Control: Telephone Number	nvarchar	40	0
32	N2MV_VSDAT	Recipient Data Table	24	TELNR	Dispatch Control: Telephone Number	nvarchar	40	0
TOPCompany Pension Scheme Germany
33	PA0746	HR Master Record for Infotype 0746	63	TELNR	Telephone Number	nvarchar	20	0
34	T5DC3	Pension Organization for Company Pension Scheme	12	TELNR	Telephone Number	nvarchar	30	0
TOPConstruction Industry
35	T5DB4	HR Construction Site File	37	TELNR	Telephone Number	nvarchar	14	0
36	T5DB5	Construction Site File: Work Breakdown Structure Element	28	TELNR	Telephone Number	nvarchar	14	0
37	T5DB6	Construction Site File: Order	28	TELNR	Telephone Number	nvarchar	14	0
TOPCross-Application Components
38	SDEPMENT	Departments: Starting Situation	4	TELNR	Telephone number of a department	nvarchar	30	0
39	SDEPMENT_CH	Departments: Enhance with Dept. Head and Time in Incl. (2)	4	TELNR	Telephone number of a department	nvarchar	30	0
40	SDEPMENT_CSH	Departments: Collective Search Help	4	TELNR	Telephone number of a department	nvarchar	30	0
41	SDEPMENT_SEARCH	Departments: Search Help	4	TELNR	Telephone number of a department	nvarchar	30	0
TOPCross-Application Objects in HR
42	HRP5583	DB Table for Infotype 5583	29	TELNR	Telephone Number	nvarchar	14	0
TOPFSCM In-House Cash
43	IHC_DB_PN_BP	IHC: Address Data of Bus. Partners Involved in Payment Order	19	TELNR	First telephone number	nvarchar	16	0
TOPGermany
44	T5D1H	Supplementary Insurance	12	TELNR	Telephone Number	nvarchar	14	0
45	T5D1K	Branch Offices	14	TELNR	Telephone number (Long form)	nvarchar	30	0
TOPHong Kong
46	PA0344	HR Master Record: Infotype 0344 (Familiy members HK)	32	TELNR	Telephone Number	nvarchar	14	0
47	T7HK2H	Provider Attributes	14	TELNR	Telephone Number	nvarchar	25	0
TOPHospital Structure
48	HRT6083	Table for Infotype Additional Telephone Data	4	TELNR	Telephone Number	nvarchar	25	0
TOPIndonesia
49	PA0318	HR Master Record: Infotype Family data for Indonesia (0318)	30	TELNR	Telephone Number	nvarchar	14	0
50	T7ID1A	Jamsostek office address (Indonesia)	7	TELNR	Telephone Number	nvarchar	14	0
TOPInformation System
51	T001M	Data on Z5A Foreign Trade Regulations Report, Germany	8	TELNR	Telephone Number	nvarchar	14	0
TOPJapan
52	T5J61	HR Address Information of Pers. Subarea for Residence Tax	15	TELNR	Telephone Number	nvarchar	14	0
53	T5J62	HR Address Information of Personnel Subarea for Income Tax	15	TELNR	Telephone Number	nvarchar	14	0
54	T5JAD	HR company office address JP	13	TELNR	Telephone Number	nvarchar	14	0
55	T5JL1	HR Address Infomation 1 of Personnel Subarea for LI JP	11	TELNR	Telephone Number	nvarchar	14	0
56	T5JL2	HR Address Infomation 2 of Personnel Subarea for LI JP	13	TELNR	Telephone Number	nvarchar	14	0
57	T5JSI	HR Branch Office Information for Social Insurance JP	13	TELNR	Telephone Number	nvarchar	14	0
TOPKorea
58	T7KRR3	External Institution	3	TELNR	Telephone Number	nvarchar	14	0
TOPMalaysia
59	PA0213	Additional family information - Malaysia	43	TELNR	Telephone Number	nvarchar	14	0
TOPManagement of Global Employees
60	T76MGE_ADM	International HR Administrator	6	TELNR	Telephone Number	nvarchar	14	0
TOPMexico
61	PA0426	Garnishment	42	TELNR	Telephone Number	nvarchar	14	0
62	T7MX01	Additional Company Informaton	13	TELNR	Telephone Number	nvarchar	14	0
63	T7MX24	IMSS Employer Regis. nos.	12	TELNR	Telephone Number	nvarchar	14	0
TOPNetherlands
64	T5N1C	Health Insurance Companies (NL)	13	TELNR	Telephone Number	nvarchar	14	0
65	T5N9A	Authority Addresses (NL)	16	TELNR	Telephone Number	nvarchar	14	0
TOPNon Profit Organizations
66	T7UNPAD_EGSN	NPO: Education Grant Schools / Colleges	13	TELNR	Telephone Number	nvarchar	14	0
TOPNorway
67	T5V2G	Connection org. numbers and rep. org. number	18	TELNR	Telephone Number	nvarchar	14	0
TOPOrganizational Management
68	HRP1028	Infotype 1028 DB Table	23	TELNR	Telephone Number	nvarchar	25	0
69	T777A	Building Addresses	9	TELNR	Telephone Number	nvarchar	25	0
TOPPatient Accounting
70	TN19I	IS-H: Assign IV Documents to Processing Agent	6	TELNR	IS-H: Telephone Number	nvarchar	30	0
TOPPatient Management
71	NADR	IS-H: Addresses (Central Address Management)	17	TELNR	IS-H: Telephone Number	nvarchar	30	0
72	NADR2	IS-H: Telephone Numbers (Central Addess Management)	5	TELNR	IS-H: Telephone Number	nvarchar	30	0
73	NBEW	IS-H: Movements for Case	17	TELNR	IS-H: Telephone Number of Patient in Institution	nvarchar	16	0
74	NKSK	IS-H: Insurance verification/certificate - Header data	47	TELNR	IS-H: Telephone Number	nvarchar	30	0
TOPPatient Transport Service
75	N1FPV	IS-H*MED: Patient Transport Service - Available Transporters	7	TELNR	IS-H: Telephone Number	nvarchar	30	0
TOPPayroll
76	T5T1J	Health insurance institutions	12	TELNR	Telephone Number	nvarchar	14	0
77	T5T1K	Health insurance institutions	14	TELNR	Telephone Number	nvarchar	14	0
78	T5T1X	Last foreign Health insurance - name	12	TELNR	Telephone Number	nvarchar	14	0
79	T7SK1K	Health insurance institutions	15	TELNR	Telephone Number	nvarchar	14	0
80	T7TRG01	General information about company.	24	TELNR	Telephone Number	nvarchar	14	0
TOPPersonnel Administration
81	HRP1656	DB Table for Infotype 1656	27	TELNR	Contact Phone	nvarchar	10	0
82	PA0006	HR Master Record: Infotype 0006 (Addresses)	31	TELNR	Telephone Number	nvarchar	14	0
83	PA0517	HR Master Record: Infotype 0517	33	TELNR	Telephone Number	nvarchar	14	0
84	T521B	Payee Keys	14	TELNR	Telephone Number	nvarchar	14	0
85	T7CO01	Additional data of the company	8	TELNR	Payroll telephone number	nvarchar	20	0
86	T7GR1HR10T	Employer Department (Texts)	12	TELNR	Telephone	nvarchar	20	0
87	T7GR4CMP	Company Elements	11	TELNR	Telephone Number	nvarchar	14	0
88	T7GR4SUB	Company Subscribers	7	TELNR	Telephone Number	nvarchar	14	0
TOPPortugal
89	T5P0P	HR-PT: Personnel Subarea Supplements	21	TELNR	Telephone no.	nvarchar	9	0
90	T5P2I	HR-PT: Social Security Institutions	9	TELNR	Telephone Number	nvarchar	14	0
91	T5P2V	HR-PT: Social Security Institutions	11	TELNR	Telephone Number	nvarchar	14	0
TOPPublic Sector
92	P01ZFA_NN_DATA	ZfA: Notifications Not Assigned	42	TELNR	Telephone Number in ZfA Notifications	nvarchar	20	0
93	PA0329	HR Master Record: Infotype 0329 (Sideline Job)	33	TELNR	Telephone Number	nvarchar	14	0
TOPRecruitment
94	PB0006	HR Master Record: Infotype 0006 (Addresses)	31	TELNR	Telephone Number	nvarchar	14	0
TOPRemaining Beverage - Obsolete Objects
95	/BEV1/RPFZ	Vehicle Master (Route Planning)	40	TELNR	Phone Number/Car	nvarchar	15	0
96	/DSD/ME_CPT_VEHI	Maintenance Table for Vehicles in DSD Cockpit	24	TELNR	Phone Number/Car	nvarchar	15	0
TOPReporting
97	P05TPRNL_LP_ADM	Pension Return: Administration - Legal Pers Level	13	TELNR	Phone Number of Administrative Unit	nvarchar	30	0
98	P05T_JLO_STAT	Annual Wage Return status	11	TELNR	Telephone No. of Contact Person	nvarchar	14	0
TOPRussia
99	T7RU1B	Payee Keys of receiving orders (Russia standard)	18	TELNR	Telephone Number	nvarchar	14	0
TOPSecurity
100	LAW_GROUPING	Temporary Table for Grouping Users	18	TELNR	Telephone number (work)	nvarchar	16	0
101	LAW_UNIQUE	Grouped User Data	18	TELNR	Telephone number (work)	nvarchar	16	0
TOPSingapore
102	PA0412	HR Master Record: Infotype 0412 [View to I0021] (SG)	32	TELNR	Telephone Number	nvarchar	14	0
103	T5R1A	Institution of Soc. Provident Funds SG	11	TELNR	Telephone Number	nvarchar	14	0
TOPSouth Africa
104	T5W1K	Pension Funds and Medical Aid Schemes (RSA)	16	TELNR	Telephone Number	nvarchar	14	0
105	T5W1M	Social insurance companies	8	TELNR	Telephone Number	nvarchar	14	0
TOPSwitzerland
106	T5C2M	Payroll unit - withholding tax	6	TELNR	HR-CH: Communication number of contact person	nvarchar	20	0
107	T5C2N	Payroll unit - wage statement	12	TELNR	HR-CH: Communication number of contact person	nvarchar	20	0
108	T5CS9	HR-CH: Payroll unit - AHV/UI	11	TELNR	HR-CH: Communication number of contact person	nvarchar	20	0
109	T5CSA	HR-CH: Payroll unit UVG	10	TELNR	HR-CH: Communication number of contact person	nvarchar	20	0
110	T5CSB	HR-CH: Payroll unit: Social Funds	9	TELNR	HR-CH: Communication number of contact person	nvarchar	20	0
111	T5CSC	HR-CH: Payroll Unit: Voluntary Accident Insurance	10	TELNR	HR-CH: Communication number of contact person	nvarchar	20	0
112	T5CSD	HR-CH: Payroll Unit - Sickness Indemnity Insurance	10	TELNR	HR-CH: Communication number of contact person	nvarchar	20	0
113	T5CSE	HR-CH: Payroll unit: NBU additional insurance	10	TELNR	HR-CH: Communication number of contact person	nvarchar	20	0
114	T5CSF	HR-CH: Payroll Unit - ASM	7	TELNR	HR-CH: Communication number of contact person	nvarchar	20	0
115	T5CSG	HR-CH: Payroll Unit BFS	8	TELNR	HR-CH: Communication number of contact person	nvarchar	20	0
116	T5CSJ	Payroll Units for the Employer Statement	15	TELNR	HR-CH: Communication number of contact person	nvarchar	20	0
117	T5CSK	HR-CH: PAyroll Unit Compensation Fund VD	9	TELNR	HR-CH: Communication number of contact person	nvarchar	20	0
118	T5CSM	HR-CH: Payroll Unit BVG ELM	10	TELNR	HR-CH: Communication number of contact person	nvarchar	20	0
119	T5CSX	HR-CH: Payroll unit: Customer insurance 1	10	TELNR	HR-CH: Communication number of contact person	nvarchar	20	0
120	T5CSY	HR-CH: Payroll unit: Customer insurance 2	10	TELNR	HR-CH: Communication number of contact person	nvarchar	20	0
121	T5CSZ	HR-CH: Payroll unit: Customer insurance 3	10	TELNR	HR-CH: Communication number of contact person	nvarchar	20	0
122	T5CZ1	HR-CH: Payroll Unit: Family-Related Bonuses	12	TELNR	HR-CH: Communication number of contact person	nvarchar	20	0
TOPTaiwan
123	PA0352	NHI for Family member (TW)	35	TELNR	Telephone Number	nvarchar	14	0
TOPThailand
124	PA0187	Additional family data	30	TELNR	Telephone Number	nvarchar	14	0
TOPUSA
125	PA0106	HR Master Record: Infotype 0106 (Related Persons NA)	37	TELNR	Telephone Number	nvarchar	14	0
126	T5UAP	Address for personnel area/subarea	12	TELNR	Telephone Number	nvarchar	14	0
127	T5UTV	Unemployment Insurance Work Sites/NC-9901 Locations	13	TELNR	Telephone Number	nvarchar	14	0
TOPUser and Authorization Management
128	USR03	User address data	20	TELNR	Telephone number (work)	nvarchar	16	0
TOPWorkbench Utilities
129	FLEMP	Employees	6	TELNR	Telephone	nvarchar	7	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

129 columns | ERP 6.0 | TELNR