	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

123 columns | ERP 6.0 | LOCID

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	CNVTDMS_05_OIJBR	TDMS Header for SPW(IS Oil and Gas)	4	LOCID	Location ID	nvarchar	10	0
2	T5Q_SUPERSTREAM	Super Stream Master Table	52	LOCID	Location ID	nvarchar	3	0
3	T5UPBSB2	Location ID	4	LOCID	Location ID	nvarchar	4	0
TOPAccounting Interface
4	GLE_FI_ITEM_MODF	ECS: Modified FI Line Items (Header/Item/Currency Data)	308	LOCID	Payment cards: Point of receipt for the transaction	nvarchar	10	0
5	GLE_FI_ITEM_ORIG	ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)	308	LOCID	Payment cards: Point of receipt for the transaction	nvarchar	10	0
TOPAP-LIM Logistics Inventory Management Engine
6	/LIME/COLL_APS	Collection for Planning System	31	LOCID	GUID for Location	varbinary	16	0
7	/LIME/COLL_BW	Collection for Business Warehouse	31	LOCID	GUID for Location	varbinary	16	0
8	/LIME/COLL_FIN	Collection for Financial System	31	LOCID	GUID for Location	varbinary	16	0
9	/LIME/COLL_INV	Collection for Inventory System	31	LOCID	GUID for Location	varbinary	16	0
10	/LIME/COLL_LEG	Collection for External System	31	LOCID	GUID for Location	varbinary	16	0
11	/LIME/COLL_MMIM	Collection for R/3 Inventory Management	31	LOCID	GUID for Location	varbinary	16	0
12	/LIME/COLL_W2IM	Collection for WME after ERP-MMIM	31	LOCID	GUID for Location	varbinary	16	0
13	/LIME/LOC_I006	LIME - Location Key Location GUID (ICH)	2	LOCID	GUID for Location	varbinary	16	0
14	/LIME/LOC_S006	Shadow Table for LIME - Location GUID (ICH)	2	LOCID	GUID for Location	varbinary	16	0
15	/LIME/PN_ITEM	Table to Save Prima Nota Item Data	13	LOCID	GUID for Location	varbinary	16	0
TOPBank Accounting
16	BSEGC	Document: Data on Payment Card Payments	21	LOCID	Payment cards: Point of receipt for the transaction	nvarchar	10	0
TOPClinical System
17	N1MEEVENT	IS-H*MED: Medication, Medication Event	21	LOCID	Medication: Localization ID	nvarchar	4	0
18	N1TPMEORDER	IS-H*MED: Medication, Medication Order Template	65	LOCID	Medication: Localization ID	nvarchar	4	0
19	TN1MELOC	IS-H*MED: Localization for Medication	2	LOCID	Medication: Localization ID	nvarchar	4	0
20	TN1MELOCEXT	i.s.h.med: Medication; Localization External Key	2	LOCID	Medication: Localization ID	nvarchar	4	0
21	TN1MELOCT	IS-H*MED: Lokalization for Medication - Description	3	LOCID	Medication: Localization ID	nvarchar	4	0
TOPGlobal Trade Services
22	/SAPSLL/CUIT	Customs Document: Item	84	LOCID	Location ID	nvarchar	3	0
23	/SAPSLL/CUSWLA	Worklist for Quantity Comparison Goods Issue/Customs Doc.	35	LOCID	Location ID	nvarchar	3	0
24	/SAPSLL/CUSWLB	Customs Worklist: Qty Adjustment - Completed Transactions	39	LOCID	Location ID	nvarchar	3	0
25	/SAPSLL/CUSWLD	Customs Processing: Procedures Completed for Customs Decl.	77	LOCID	Location ID	nvarchar	3	0
26	/SAPSLL/CUSWLE	Worklist for Processing Domestic Customs Warehouse Issues	38	LOCID	Location ID	nvarchar	3	0
27	/SAPSLL/CUSWLF	Customs Worklist: Domestic Issues - Completed Transactions	38	LOCID	Location ID	nvarchar	3	0
28	/SAPSLL/CUSWLM	Quantity Comparison: Customs Declaration/Goods Receipt	31	LOCID	Location ID	nvarchar	3	0
29	/SAPSLL/CUSWLN	Completed Quantity Comparisons Customs Declaration/GR	31	LOCID	Location ID	nvarchar	3	0
30	/SAPSLL/CUSWLO	Worklist for Transactions with Reference to Delivery or PO	77	LOCID	Location ID	nvarchar	3	0
31	/SAPSLL/CUSWLP	Customs Worklist: Periodic Declarations	16	LOCID	Location ID	nvarchar	3	0
32	/SAPSLL/CUSWLQ	Customs Worklist: Per. Declarations - Completed Transactions	16	LOCID	Location ID	nvarchar	3	0
33	/SAPSLL/GPASTOCK	Shared, Periodic, and Completed Stock	7	LOCID	Location ID	nvarchar	3	0
TOPIndustry-Specific Component Automotive
34	RESKEYR3	Resource Proxy ERP	7	LOCID	Plant	nvarchar	4	0
TOPIntegrated Product and Process Engineering
35	PAMODD	Duration of an Activity-Resource Relationship	8	LOCID	Plant/Location in iPPE	nvarchar	22	0
36	PNFLO	PVS Factory Layout Node: Attributes	5	LOCID	Plant/Location in iPPE	nvarchar	22	0
37	PNRES	iPPE Resource Node: Attributes	5	LOCID	Plant/Location in iPPE	nvarchar	22	0
38	PPEFILTEXPL	This table is obsolete, use PPEFILTEXPLPAR	5	LOCID	Plant/Location in iPPE	nvarchar	22	0
39	PPEFILTEXPLPAR	Explosion Parameters for the iPPE Filter	6	LOCID	Plant/Location in iPPE	nvarchar	22	0
40	PPEHDR	iPPE Access Object	4	LOCID	Plant/Location in iPPE	nvarchar	22	0
41	PVBASS	SA Assignment Table for iPPE Shop Floor Manufacturing	5	LOCID	Plant/Location in iPPE	nvarchar	22	0
TOPInterface to Terminal Automation System
42	OIKPEXLOC	OIL: Status of gen. Location in ext. Transport Planning Sy	3	LOCID	General location number	nvarchar	10	0
TOPliveCache Applications
43	/SAPAPO/ORDKEY	Key and descriptive data for order	26	LOCID	Internal Location Number (Customer, Vendor, or Plant)	nvarchar	22	0
44	/SAPAPO/RSP_LCCO	Maintenance of Objects in RSP liveCache Check	5	LOCID	Internal Location Number (Customer, Vendor, or Plant)	nvarchar	22	0
45	MATRIXINDEXTAB	(Only in the liveCache)	4	LOCID	Internal Location Number (Customer, Vendor, or Plant)	nvarchar	22	0
46	RPM_PERF_DATA	RPM: Performance Results (only in the liveCache)	4	LOCID	Internal Location Number (Customer, Vendor, or Plant)	nvarchar	22	0
47	RPM_PLAN_FILE	Matrix: RPM Markings (Only in liveCache)	4	LOCID	Internal Location Number (Customer, Vendor, or Plant)	nvarchar	22	0
TOPPayment Cards
48	FPLTC	Payment cards: Transaction data - SD	19	LOCID	Payment cards: Point of receipt for the transaction	nvarchar	10	0
49	TCCL	Payment cards: Point of receipt for the transaction	2	LOCID	Payment cards: Point of receipt for the transaction	nvarchar	10	0
50	TCCLT	Payment cards: Points of receipt for the transaction (text)	3	LOCID	Payment cards: Point of receipt for the transaction	nvarchar	10	0
TOPPerformance Assessment Workbench
51	SLS_CONTAC	PAW - Contact Data of Location	3	LOCID	Location identification from HR (PAW)	nvarchar	8	0
52	SLS_EVENT	PAW - Testing Events (related to TEM Events)	11	LOCID	Location identification from HR (PAW)	nvarchar	8	0
53	SLS_IOASGN	PAW - testtype - infoobjects	4	LOCID	PAW - Business event location	nvarchar	8	0
54	SLS_IOASGT	PAW - testtype - infoobjects	4	LOCID	PAW - Business event location	nvarchar	8	0
55	SLS_LOC	PAW - Locations	3	LOCID	Location identification from HR (PAW)	nvarchar	8	0
56	SLS_LOCT	PAW - Locations temp	2	LOCID	Location identification from HR (PAW)	nvarchar	8	0
57	SLS_LOCTTY	PAW - Location - Test Type	3	LOCID	Location identification from HR (PAW)	nvarchar	8	0
58	SLS_PROLOC	PAW - Access Profile: Location	4	LOCID	Location identification from HR (PAW)	nvarchar	8	0
TOPPeriodical Sales and Distribution
59	JFRKCC	IS-M/SD: Billing - Payment Card Data	19	LOCID	Payment cards: Point of receipt for the transaction	nvarchar	10	0
60	JKAPCC	Sales Order: Payment Card Data	20	LOCID	Payment cards: Point of receipt for the transaction	nvarchar	10	0
TOPSCM Basis
61	CIFERRLOG	Error Recording in Enhanced CIF Error Handling	19	LOCID	Location ID	nvarchar	22	0
TOPTraders and Schedulers Workbench
62	OIJBRD	OIL-TSW: Rundown table for Batch	3	LOCID	Location ID	nvarchar	10	0
63	OIJBRDACTUALS	IS-OIL TSW: Table to store the actuals	3	LOCID	Location ID	nvarchar	10	0
64	OIJBRDDOC	Rundown item / document X-ref table for Batch - WILL EXPIR	3	LOCID	Location ID	nvarchar	10	0
65	OIJBRDH	RD header f.batch:Don't use(obsolete) & don't delete(XPRA)	3	LOCID	Location ID	nvarchar	10	0
66	OIJBRDNOM	Stock Projection item / nomination X-ref table	3	LOCID	Location ID	nvarchar	10	0
67	OIJDOCFL	OIL-TSW : TICKET DOCUMENT FLOW TABLE Obsolete, do not use	3	LOCID	Location ID	nvarchar	10	0
68	OIJHCT01	OIL-TSW: Ticket Holding Table (Draft version 1) - OBSOLETE	3	LOCID	Location ID	nvarchar	10	0
69	OIJHUOM	OIL-TSW: Ticket additional units of measure	3	LOCID	Location ID	nvarchar	10	0
70	OIJLOC	Location table	2	LOCID	Location ID	nvarchar	10	0
71	OIJLOCMAT	OIL-TSW: Location Rundown/Planning material table	2	LOCID	Location ID	nvarchar	10	0
72	OIJNOMC	OIL-TSW: Nomination copy table	10	LOCID	Location ID	nvarchar	10	0
73	OIJNOMI	Nomination Item	10	LOCID	Location ID	nvarchar	10	0
74	OIJNOMIVERS	Nomination Item Version Table	12	LOCID	Location ID	nvarchar	10	0
75	OIJPHYINV	Physical inventory	2	LOCID	Location ID	nvarchar	10	0
76	OIJPLANLOC	OIL TSW: Multiple planning Locations	3	LOCID	Location ID	nvarchar	10	0
77	OIJPLANWL	OIJ-TSW: Worklist entries for planning	3	LOCID	Location ID	nvarchar	10	0
78	OIJPLCAL	OIL-TSW: Planning Calendar Definitions	3	LOCID	Location ID	nvarchar	10	0
79	OIJPLCALT	OIL_TSW: Planning Calendar Texts	4	LOCID	Location ID	nvarchar	10	0
80	OIJRD	OIL-TSW: Rundown table	3	LOCID	Location ID	nvarchar	10	0
81	OIJRDACTUALS	IS-OIL TSW: Table to store the actuals	3	LOCID	Location ID	nvarchar	10	0
82	OIJRDDOC	Rundown item / document X-ref table/ WILL EXPIRE IN FUTURE	3	LOCID	Location ID	nvarchar	10	0
83	OIJRDH	Rundown header: Don't use (obsolete) & don't delete (XPRA)	3	LOCID	Location ID	nvarchar	10	0
84	OIJRDHTPSET	OIL-TSW: Rundown Rack issue / throughput settings	3	LOCID	Location ID	nvarchar	10	0
85	OIJRDNOM	Stock Projection item / nomination X-ref table	3	LOCID	Location ID	nvarchar	10	0
86	OIJRDPLAN	OIL-TSW: Rundown planning proposal drill-down	3	LOCID	Location ID	nvarchar	10	0
87	OIJRDWL	Worklist items per Stock Projection object item	3	LOCID	Location ID	nvarchar	10	0
88	OIJRRA	OIL-TSW: Partner roles	12	LOCID	Location ID	nvarchar	10	0
89	OIJSDLOC	OIL-TSW: Multiple sources/destinations of location	2	LOCID	Location ID	nvarchar	10	0
90	OIJTHPUTFC	Rack issue / Throughput forecast	2	LOCID	Location ID	nvarchar	10	0
91	OIJTHPUTFCAVG	OIL-TSW: Rack issue / Throughput forecast daily average	2	LOCID	Location ID	nvarchar	10	0
92	OIJTHPUTFCEST	OIL-TSW: Rack issue / Throughput estimate pop-up	2	LOCID	Location ID	nvarchar	10	0
93	OIJTSLOC	OIL-TSW: transport system/location assignment table	3	LOCID	Location ID	nvarchar	10	0
94	OIJWL	OIL-TSW: Worklist	5	LOCID	Location ID	nvarchar	10	0
95	OIJ_EL_DOC_EV	Rules for nomination events	8	LOCID	Location ID	nvarchar	10	0
96	OIJ_EL_DOC_I_REF	Document item reference to nomination	14	LOCID	Location ID	nvarchar	10	0
97	OIJ_EL_DOC_MOT	Oil TSW: TSW Relevance of order item	9	LOCID	Location ID	nvarchar	10	0
98	OIJ_EL_LAYT_INF	Laytime terms	7	LOCID	Location ID	nvarchar	10	0
99	OIJ_EL_PROD_DATA	Production data for locations	2	LOCID	Location ID	nvarchar	10	0
100	OIJ_EL_TICKET_I	Universal ticket item table	16	LOCID	Location ID	nvarchar	10	0
101	OIJ_LB_OPENINV	Opening inventory table for Location Balancing.	3	LOCID	Location ID	nvarchar	10	0
102	OIJ_LMTIMECON	OILTSW: Time dependent constraints by location & material	2	LOCID	Location ID	nvarchar	10	0
103	OIJ_RDHEAD	Stock Projection header	3	LOCID	Location ID	nvarchar	10	0
104	OIJ_SCHED	Planned Schedule Lines	61	LOCID	Location ID	nvarchar	10	0
105	OIJ_SIM_SCHED	obsolete table (will be cleaned up)	7	LOCID	Location ID	nvarchar	10	0
106	OIJ_TGTSFTTIME	Time dependent target and safety levels	2	LOCID	Location ID	nvarchar	10	0
107	OIJ_VEH_PERF	Marine Scheduling - Table to Store vehicle Performanace	5	LOCID	Location ID	nvarchar	10	0
108	ROIJRDACT	IS-OIL TSW: Table to store the actuals X-ref table	3	LOCID	Location ID	nvarchar	10	0
109	S430	SIS: (OIL-TSW) Sales document statistics by TSW object	5	LOCID	Location ID	nvarchar	10	0
110	S431	PURCHIS: (OIL-TSW) Purchasing document stats by TSW object	5	LOCID	Location ID	nvarchar	10	0
111	TOI0_REL_NOM	IS-OIL: Relevance customizing for Nominations	14	LOCID	Location ID	nvarchar	10	0
TOPTraining and Event Management
112	HRPAD27	Additional data PAD27	6	LOCID	Business Event Location	nvarchar	8	0
113	HRPAD34	Additional Data for Relationship 'has attended'	8	LOCID	Business Event Location	nvarchar	8	0
114	HRT1060	Table Division for Infotype 1060	5	LOCID	Business Event Location	nvarchar	8	0
TOPTransportation
115	VTLST	Status of Gen. Location in Ext. Transportatn Planning System	3	LOCID	General location number	nvarchar	10	0
TOPTravel Planning
116	TA20PHC	Assignment Table of Hotel Catalog Items for Travel Profiles	4	LOCID	IATA location	nvarchar	3	0
117	TA21L	IATA Locations	2	LOCID	IATA location	nvarchar	3	0
118	TA21L1	IATA Locations (Language-Dependent)	3	LOCID	IATA location	nvarchar	3	0
119	TA21PH	Customer-Specific Hotel Catalog	4	LOCID	IATA location	nvarchar	3	0
120	TA21RZC	Assignment: Country-Subdividing Region to Location	3	LOCID	IATA location	nvarchar	3	0
121	TA23L_C	Assign Locations to IATA Locations (Car Rental)	3	LOCID	IATA location	nvarchar	3	0
122	TA23L_F	Assign Locations to IATA Locations (Flight)	3	LOCID	IATA location	nvarchar	3	0
123	TA23L_H	Assign Locations to IATA Locations (Hotel)	3	LOCID	IATA location	nvarchar	3	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

123 columns | ERP 6.0 | LOCID