	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

136 columns | ERP 6.0 | LOCAT

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	P08P1CLS	CLASS CPX INTERFACE Snapshot Table	19	LOCAT	CLASS CPX INTERFACE Location	nvarchar	5	0
2	P2HK_TAXADR	HR-HK: Payroll structure for Tax Quarters - Tax year	9	LOCAT	2nd Address Line	nvarchar	30	0
3	P2RB_ADR	Address payroll Belgium	11	LOCAT	2nd Address Line	nvarchar	40	0
4	P2RF_SAR	Payroll Results: Garnishment	23	LOCAT	2nd Address Line	nvarchar	30	0
5	P2RK_ADR	Address	5	LOCAT	2nd Address Line	nvarchar	30	0
6	P2RN_NADR	Address Data	11	LOCAT	2nd Address Line	nvarchar	40	0
7	P2RU_ADR	Address	6	LOCAT	2nd Address Line	nvarchar	30	0
8	T7RU9A	Addresses of organizations	15	LOCAT	2nd Address Line	nvarchar	40	0
9	T7RUPA0006	PA0006 copy	35	LOCAT	2nd Address Line	nvarchar	40	0
TOPBenefits
10	PA0219	HR Master Record: Infotype 0219 (External Organizations)	29	LOCAT	2nd Address Line	nvarchar	40	0
TOPCross-Application Objects in HR
11	HRP5583	DB Table for Infotype 5583	24	LOCAT	2nd Address Line	nvarchar	40	0
TOPDenmark
12	T5M8T	Danish Postal Codes	6	LOCAT	Locality in a district	nvarchar	40	0
TOPFrance
13	PA0272	Infotype 0272 (Garnishment)	42	LOCAT	2nd Address Line	nvarchar	30	0
14	T5F4E	DDTEFP	9	LOCAT	2nd Address Line	nvarchar	30	0
15	T5F4E1	DDTEPP address	10	LOCAT	2nd Address Line	nvarchar	30	0
TOPGlobal Trade Services
16	/SAPSLL/CMDNOD	GTS: Transport Connection Point	7	LOCAT	Location for Global Trade Services	nvarchar	40	0
17	/SAPSLL/CORACT	Legal & Logistics Services: Activities	9	LOCAT	Location of Activity	nvarchar	40	0
TOPHong Kong
18	PA0344	HR Master Record: Infotype 0344 (Familiy members HK)	26	LOCAT	House number and street	nvarchar	30	0
TOPIndonesia
19	PA0318	HR Master Record: Infotype Family data for Indonesia (0318)	34	LOCAT	2nd Address Line	nvarchar	30	0
20	T7ID1A	Jamsostek office address (Indonesia)	8	LOCAT	2nd Address Line	nvarchar	30	0
TOPIreland
21	T7IE9	SIPTU	5	LOCAT	SIPTU Location	nvarchar	20	0
TOPMalaysia
22	PA0213	Additional family information - Malaysia	36	LOCAT	2nd Address Line	nvarchar	30	0
TOPMaterials Management
23	J_1GVL_ML	Material Ledger	9	LOCAT	Warehousebook location	nvarchar	10	0
24	J_1GVL_WHBPOL	material analytical ledger period totals	7	LOCAT	Warehousebook location	nvarchar	10	0
TOPNetherlands
25	T5N9A	Authority Addresses (NL)	12	LOCAT	2nd Address Line	nvarchar	30	0
TOPPatient Management
26	TN18L	Location	2	LOCAT	Location	nvarchar	2	0
27	TN18L_T	Location text	3	LOCAT	Location	nvarchar	2	0
TOPPersonnel Administration
28	PA0006	HR Master Record: Infotype 0006 (Addresses)	35	LOCAT	2nd Address Line	nvarchar	40	0
29	PA0226	Személyzeti törzsrekord 0164 infotípus tábla (TB - Magyaro.)	41	LOCAT	Adressenzusatz	nvarchar	30	0
TOPRecruitment
30	PB0006	HR Master Record: Infotype 0006 (Addresses)	35	LOCAT	2nd Address Line	nvarchar	40	0
TOPReporting
31	P05TPRNL_EE_PD	Pension Return: Personal Data - Pers Level	29	LOCAT	2nd Address Line	nvarchar	40	0
TOPRussia
32	PA0298	HR Master Record: Infotype 0298	29	LOCAT	Order Storage Location	nvarchar	30	0
TOPSingapore
33	PA0412	HR Master Record: Infotype 0412 [View to I0021] (SG)	27	LOCAT	2nd Address Line	nvarchar	30	0
34	T5R1A	Institution of Soc. Provident Funds SG	9	LOCAT	2nd Address Line	nvarchar	30	0
TOPTask Resource Management
35	LACTY	Activity catalog	2	LOCAT	Site	nvarchar	4	0
36	LACTYT	Activity catalog - description	3	LOCAT	Site	nvarchar	4	0
37	LAGAC	Assign Activity to Activity Groups	2	LOCAT	Site	nvarchar	4	0
38	LAGDF	Activity Group Definition	2	LOCAT	Site	nvarchar	4	0
39	LAGDFT	Activity Group - Description	3	LOCAT	Site	nvarchar	4	0
40	LALRT	Alert value mapping (threshold)	3	LOCAT	Presentation Profile/Site	nvarchar	4	0
41	LDPRF	Display profile	3	LOCAT	Presentation Profile/Site	nvarchar	4	0
42	LDPRFT	Display profile - description	4	LOCAT	Presentation Profile/Site	nvarchar	4	0
43	LEGOD	Execution Control Objects (ECO) definition	2	LOCAT	Site	nvarchar	4	0
44	LEGODT	Execution Control Objects (ECO) definition - description	3	LOCAT	Site	nvarchar	4	0
45	LEGOR	ECOs' subscriptions at runtime	2	LOCAT	Site	nvarchar	4	0
46	LEGRS	Resource-ECO subscription	2	LOCAT	Site	nvarchar	4	0
47	LELMT	Resource element	2	LOCAT	Site	nvarchar	4	0
48	LELTA	Allowed resource element type	2	LOCAT	Site	nvarchar	4	0
49	LELTY	Resource element type	2	LOCAT	Site	nvarchar	4	0
50	LELTYT	Resource element type - description	3	LOCAT	Site	nvarchar	4	0
51	LETYM	Entity hierarchy: modes/weighting factor	2	LOCAT	Site	nvarchar	4	0
52	LEXDT	Execution data (for exception information)	2	LOCAT	Site	nvarchar	4	0
53	LEXTP	External process - activity mapping	3	LOCAT	Presentation Profile/Site	nvarchar	4	0
54	LFCPR	Function code profile per step	3	LOCAT	Presentation Profile/Site	nvarchar	4	0
55	LFCTX	Pushbutton text	4	LOCAT	Presentation Profile/Site	nvarchar	4	0
56	LGPRI	Priority log	2	LOCAT	Site	nvarchar	4	0
57	LGRQA	Resource qualifications log	2	LOCAT	Site	nvarchar	4	0
58	LGTKA	Task actual execution data log	2	LOCAT	Site	nvarchar	4	0
59	LGTKL	Task pool log	2	LOCAT	Site	nvarchar	4	0
60	LGTKS	Task status log	2	LOCAT	Site	nvarchar	4	0
61	LIVPR	Input verification profile	3	LOCAT	Presentation Profile/Site	nvarchar	4	0
62	LLGRH	Request log	2	LOCAT	Site	nvarchar	4	0
63	LLGRI	Request item log	2	LOCAT	Site	nvarchar	4	0
64	LLGRN	Request network log	2	LOCAT	Site	nvarchar	4	0
65	LLGRS	Resource log	2	LOCAT	Site	nvarchar	4	0
66	LLGRT	Request - task progress log	2	LOCAT	Site	nvarchar	4	0
67	LLGST	Resource status log	2	LOCAT	Site	nvarchar	4	0
68	LLGTM	Route log	2	LOCAT	Site	nvarchar	4	0
69	LLMOD	Mode catalog	2	LOCAT	Site	nvarchar	4	0
70	LLMODT	Mode catalog - description	3	LOCAT	Site	nvarchar	4	0
71	LLOCT	Site	2	LOCAT	Site	nvarchar	4	0
72	LLOCTT	Site - description	3	LOCAT	Site	nvarchar	4	0
73	LLVEL	Level	2	LOCAT	Site	nvarchar	4	0
74	LLVELT	Level - description	3	LOCAT	Site	nvarchar	4	0
75	LMENU	Menu tree	3	LOCAT	Presentation Profile/Site	nvarchar	4	0
76	LMENUT	Menu tree - description	4	LOCAT	Presentation Profile/Site	nvarchar	4	0
77	LMNCT	Menu item catalog	3	LOCAT	Presentation Profile/Site	nvarchar	4	0
78	LMNCTT	Menu item catalog - description	4	LOCAT	Presentation Profile/Site	nvarchar	4	0
79	LMNRT	Mandatory routes	2	LOCAT	Site	nvarchar	4	0
80	LMOBD	Object class ID	3	LOCAT	Presentation Profile/Site	nvarchar	4	0
81	LMOCH	Objects class hierarchy	3	LOCAT	Presentation Profile/Site	nvarchar	4	0
82	LMOCM	Object class permitted movements	3	LOCAT	Presentation Profile/Site	nvarchar	4	0
83	LMVRT	Variant for TRM Monitoring	3	LOCAT	Presentation Profile/Site	nvarchar	4	0
84	LNODE	Node	2	LOCAT	Site	nvarchar	4	0
85	LNODET	Node - description	3	LOCAT	Site	nvarchar	4	0
86	LOBGR	Object grouping	2	LOCAT	Site	nvarchar	4	0
87	LOBSL	Obstacle	2	LOCAT	Site	nvarchar	4	0
88	LOBSLT	Obstacle - description	3	LOCAT	Site	nvarchar	4	0
89	LPAPS	Application parameters	2	LOCAT	Presentation Profile/Site	nvarchar	4	0
90	LPDVC	Presentation device	3	LOCAT	Presentation Profile/Site	nvarchar	4	0
91	LPLTM	Planned time for task creation lags	2	LOCAT	Site	nvarchar	4	0
92	LPRSN	Personalization	3	LOCAT	Presentation Profile/Site	nvarchar	4	0
93	LPRSNT	Personalization - description	4	LOCAT	Presentation Profile/Site	nvarchar	4	0
94	LPRVL_TSK	Entities value table for task management package	2	LOCAT	Site	nvarchar	4	0
95	LRITK	Request - task progress	2	LOCAT	Site	nvarchar	4	0
96	LRMSG	Resources messages	2	LOCAT	Site	nvarchar	4	0
97	LROUT	Routing	2	LOCAT	Site	nvarchar	4	0
98	LRQNT	Request network	2	LOCAT	Site	nvarchar	4	0
99	LRQSH	Request	2	LOCAT	Site	nvarchar	4	0
100	LRQSI	Request item	2	LOCAT	Site	nvarchar	4	0
101	LRSNC	External vs Internal reason code	2	LOCAT	Site	nvarchar	4	0
102	LRSNCT	External vs Internal reason code - description	3	LOCAT	Site	nvarchar	4	0
103	LRSQA	Resource qualifications	2	LOCAT	Site	nvarchar	4	0
104	LRSRC	Resource	2	LOCAT	Site	nvarchar	4	0
105	LRSTC	Resource type components	2	LOCAT	Site	nvarchar	4	0
106	LRSTY	Resource type	2	LOCAT	Site	nvarchar	4	0
107	LRSTYT	Resource type - description	3	LOCAT	Site	nvarchar	4	0
108	LRSWD	Workers of deactivated resources	2	LOCAT	Site	nvarchar	4	0
109	LRTCP	Capacity assignment for resource types	2	LOCAT	Site	nvarchar	4	0
110	LRTEX	Route exceptions	2	LOCAT	Site	nvarchar	4	0
111	LRTQA	Resource type and resource element qualifications	2	LOCAT	Site	nvarchar	4	0
112	LSECC	Capacity of Static Execution Control (SEC)	2	LOCAT	Site	nvarchar	4	0
113	LSRZN	Serving zone	2	LOCAT	Site	nvarchar	4	0
114	LSTLN	Logical transaction step flow	3	LOCAT	Presentation Profile/Site	nvarchar	4	0
115	LSTMP	Mapping Step Type to Step	3	LOCAT	Presentation Profile/Site	nvarchar	4	0
116	LSTSC	Physical screen variant per logical step	3	LOCAT	Presentation Profile/Site	nvarchar	4	0
117	LTCTW	Crit. time window & dynamic due date priority estimation	2	LOCAT	Site	nvarchar	4	0
118	LTKEG	Tasks-Execution Group Objects (EGO) mapping	2	LOCAT	Site	nvarchar	4	0
119	LTKPL	Task pool	2	LOCAT	Site	nvarchar	4	0
120	LTKRT	Task - resource type	2	LOCAT	Site	nvarchar	4	0
121	LTRCT	Logical transaction catalog	3	LOCAT	Presentation Profile/Site	nvarchar	4	0
122	LTRCTT	Logical transaction catalog - description	4	LOCAT	Presentation Profile/Site	nvarchar	4	0
123	LWKCN	Work center operations	2	LOCAT	Site	nvarchar	4	0
124	LWRKA	Working Area	2	LOCAT	Site	nvarchar	4	0
125	LWRKAT	Working Area - description	3	LOCAT	Site	nvarchar	4	0
126	LXRFN	Request cross-reference	2	LOCAT	Site	nvarchar	4	0
127	LZGDF	Zone group definition	2	LOCAT	Site	nvarchar	4	0
128	LZGDFT	Zone group - description	3	LOCAT	Site	nvarchar	4	0
129	LZGZN	Zone Group - Zone Relationship	2	LOCAT	Site	nvarchar	4	0
130	LZNDF	Zone	2	LOCAT	Site	nvarchar	4	0
131	LZNDFT	Zone - description	3	LOCAT	Site	nvarchar	4	0
132	LZNNX	Zone Entry-Exit	2	LOCAT	Site	nvarchar	4	0
TOPThailand
133	PA0187	Additional family data	31	LOCAT	Street/Road, Tambol	nvarchar	60	0
TOPUSA
134	PA0106	HR Master Record: Infotype 0106 (Related Persons NA)	32	LOCAT	House number and street	nvarchar	30	0
135	T5UAP	Address for personnel area/subarea	7	LOCAT	2nd Address Line	nvarchar	30	0
TOPWarehouse Management
136	T340D	WM Default Values	71	LOCAT	Site	nvarchar	4	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

136 columns | ERP 6.0 | LOCAT