	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

119 columns | ERP 6.0 | TPLNR

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/GEP/FLEET_T_CPO	Car Pools	2	TPLNR	Car Pool	nvarchar	30	0
2	/GEP/T_NEED	Graphischer Leitstand: Bedarfe (einzuplanende Objekte)	43	TPLNR	Fuhrpark	nvarchar	30	0
3	/GEP/T_SPLIT	Graphischer Leitstand: Splits (eingeplante Objekte)	44	TPLNR	Fuhrpark	nvarchar	30	0
4	/SMERP/STG_PM001	Data staging - Equipment complex table	121	TPLNR	Functional Location	nvarchar	30	0
5	/SMERP/STG_PM002	Data staging - Functional Location complex table	8	TPLNR	Functional Location	nvarchar	30	0
6	/SMERP/STG_PM003	Data staging - Equipment List Set - Hdr - complex tab	121	TPLNR	Functional Location	nvarchar	30	0
7	/SMERP/STG_PM004	Data staging - Equipment list set - Measuring Points	61	TPLNR	Functional Location	nvarchar	30	0
8	/SMERP/STG_PM008	Data staging - Functional Loc. List Set - Hdr - complex tab	8	TPLNR	Functional Location	nvarchar	30	0
9	/SMERP/STG_PM009	Data staging - Func. Loc. List Set - Meas. Pts - cmplex tab	61	TPLNR	Functional Location	nvarchar	30	0
10	/SMERP/STG_PM011	Data staging - Func Loc. LSet - Classifications - Cmplx Tab	8	TPLNR	Functional Location	nvarchar	30	0
11	/SMERP/STG_PM012	Data staging - Func Loc LSet - Char Values - complex table	8	TPLNR	Functional Location	nvarchar	30	0
12	CIF_IMRESTMFL	Integration Model Reference Table for Functional Location	2	TPLNR	Functional Location	nvarchar	30	0
13	CNVTDMS_05_TPLNR	Fill header for Conn. Object	3	TPLNR	Char 30	nvarchar	30	0
14	EAM_REG_PLAN	Regular Task Planning Schedule	9	TPLNR	Functional Location	nvarchar	30	0
15	GHO_ALC_SRC_DFEV	Deferment Event source data to invalidate Allocation results	6	TPLNR	Functional Location	nvarchar	30	0
16	GHO_ALERT	Store Network Alerts	10	TPLNR	Functional Location	nvarchar	30	0
17	GHO_DM_EVENT	Deferment Event Data	3	TPLNR	Functional Location	nvarchar	30	0
18	GHO_EVT_SRC_DATA	Table to store deferment events souce data used in alloc run	11	TPLNR	Functional Location	nvarchar	30	0
19	GHO_WC_NATURE	Well completion nature	2	TPLNR	Functional Location	nvarchar	30	0
20	GHO_WELLCLASS_LC	Well class Lifecycle	2	TPLNR	Functional Location	nvarchar	30	0
21	IEAM_TASK_LT	Task Attributes	5	TPLNR	Functional Location	nvarchar	30	0
22	S555E	S555 - Structural Information	4	TPLNR	Functional Location	nvarchar	30	0
23	S901E	S901 - Strukturinformationen	5	TPLNR	Technischer Platz	nvarchar	30	0
24	SFTT_EQUI	Equipment Status diary	6	TPLNR	Functional Location	nvarchar	30	0
25	SFTT_EQUIC	Equipment Current Status	4	TPLNR	Functional Location	nvarchar	30	0
26	SFTT_EQUIM	Equipment Master Data	4	TPLNR	Functional Location	nvarchar	30	0
27	SFTT_REG_TASK	Regular Tasks List for Item Data	9	TPLNR	Functional Location	nvarchar	30	0
28	SFTT_SN	Shift Notes: Master Data	7	TPLNR	Functional Location	nvarchar	30	0
29	TTS_SM_DATA	Safety Measure and Supplemental Safety Measure Data	4	TPLNR	Functional Location	nvarchar	30	0
TOPAerospace Defence Industry Solution
30	EQUIPKPI	Used to store the Delta values and counters for MTBE calc	5	TPLNR	Functional Location	nvarchar	30	0
TOPAppropriation Requests
31	IMAK	Appropriation requests - general data	17	TPLNR	Functional Location	nvarchar	30	0
TOPBasic Functions
32	ANLZ	Time-Dependent Asset Allocations	21	TPLNR	Functional Location	nvarchar	30	0
TOPBills of Material
33	TPST	Link Between Functional Location and BOM	2	TPLNR	Functional Location	nvarchar	30	0
TOPBulk Distribution Requirements Planning
34	OIIGMMK	GMM: General meter header table	6	TPLNR	Functional location ID	nvarchar	30	0
TOPData Collection
35	S064E	S064 - Structural information	3	TPLNR	Functional Location	nvarchar	30	0
36	S116	Customer Analysis	14	TPLNR	Functional Location	nvarchar	30	0
37	S116E	S116 - Structural information	9	TPLNR	Functional Location	nvarchar	30	0
38	S555	Info structure Wolgang Backes	9	TPLNR	Functional Location	nvarchar	30	0
39	S901	Garantieauswertung	10	TPLNR	??????????? ?????	nvarchar	30	0
TOPDistributed Maintenance
40	/ISDFPS/PMDISFL	Distributed Maintenance - Dismantled Functional Locations	2	TPLNR	Functional Location	nvarchar	30	0
TOPEquipment
41	IEQT_WL_ITEMS	Interim Statuses - Items	65	TPLNR	Functional Location	nvarchar	30	0
42	IEQT_WL_ITM_BAC	Interim Statuses - Items (Backup)	66	TPLNR	Functional Location	nvarchar	30	0
TOPFlexible Real Estate Management
43	VIBDPMFL	OBSOLETE: Link from RE Object to Functional Location	4	TPLNR	Functional Location	nvarchar	30	0
TOPFunctional Locations
44	IFLOCUST	System-Specific Settings	3	TPLNR	Functional Location	nvarchar	30	0
45	IFLOS	Functional Location Labels	2	TPLNR	Functional Location	nvarchar	30	0
46	IFLOS_VS	Functional Location Labels (Version Table)	3	TPLNR	Functional Location	nvarchar	30	0
47	IFLOT	Functional Location (Table)	2	TPLNR	Functional Location	nvarchar	30	0
48	IFLOTX	Functional Location: Short Texts	2	TPLNR	Functional Location	nvarchar	30	0
49	IFLOTX_VS	Functional Location Data Fields: Short Texts (Version Table)	3	TPLNR	Functional Location	nvarchar	30	0
50	IFLOT_VS	Functional Location (Version Table)	3	TPLNR	Functional Location	nvarchar	30	0
51	ILOA	PM Object Location and Account Assignment	3	TPLNR	Functional Location	nvarchar	30	0
52	ILOA_VS	Location & Account Assignment for PM Object (Version Table)	4	TPLNR	Functional Location	nvarchar	30	0
TOPGeographical Information System
53	GHO_TEMP_TPLNR	Stores temp tplnr table	1	TPLNR	Functional Location	nvarchar	30	0
TOPIndustrial Hygiene and Safety
54	CCIHT_IAL	EHS: Incident/Accident Log - Header	23	TPLNR	Functional Location	nvarchar	30	0
TOPInvestment Programs
55	IMPR	Investment Program Positions	25	TPLNR	Functional Location	nvarchar	30	0
TOPLogbook
56	ADFSH_FLGTDET	Flight Scheduling: Flight Schedule Details	11	TPLNR	Flight Scheduling: Actual Aircraft Registration	nvarchar	30	0
57	ADFSH_FLGTMAS	Flight Scheduling: Flight Schedule Master	22	TPLNR	Flight Scheduling: Planned Aircraft Registration	nvarchar	30	0
TOPMaintenance
58	/ISDFPS/PM_MB_H	PM Maintenance Book - Header	20	TPLNR	Functional Location	nvarchar	30	0
TOPMaintenance History
59	HIVG	PM order history - operations	71	TPLNR	Functional Location	nvarchar	30	0
TOPMaintenance Notifications
60	QMFE	Quality notification - items	57	TPLNR	Functional Location	nvarchar	30	0
TOPMaintenance Orders
61	/CUM/CUDESIGN	CU: Design Header Data	21	TPLNR	Functional Location	nvarchar	30	0
62	/CUM/PRF_ORD	CU: Profile for Order Generation	15	TPLNR	Functional Location	nvarchar	30	0
63	T352R	Maintenance revisions	13	TPLNR	Functional Location	nvarchar	30	0
64	TPMIM	IM allocation key	11	TPLNR	Funct.Loc. f. autom. deriv. of charactstcs for IM allocation	nvarchar	1	0
65	TPMUS	PM/SM - User default values	24	TPLNR	Functional Location	nvarchar	30	0
TOPMaintenance Program Definition
66	MPDCD	MPD: OBSOLETE - Counter Data for Maintenance Document Items	4	TPLNR	Functional Location	nvarchar	30	0
67	MPDCYCLE	MPD: Cycle Data for Maintenance Document Items	4	TPLNR	Functional Location	nvarchar	30	0
TOPMaintenance Task Lists
68	MPLA	Maintenance plan	13	TPLNR	Functional Location	nvarchar	30	0
69	TAPL	Allocation of task lists to functional locations	2	TPLNR	Functional Location	nvarchar	30	0
TOPMarketing Retail Network
70	OIFOIFLO	Object links - PM functional location (IS-Oil MRN)	12	TPLNR	Functional Location	nvarchar	30	0
TOPMeasurement System
71	GHO_IMPTT_EXT	Data Capture Header	6	TPLNR	Functional Location	nvarchar	30	0
72	GHO_IMRG_EXT	Extension Table for IMRG (Measurement Document)	5	TPLNR	Functional Location	nvarchar	30	0
TOPMigration
73	VIGW_IM_LO	Abbildung Immoobjekt zu Technischem Platz	3	TPLNR	Toimintopaikka	nvarchar	30	0
TOPNetwork Objects
74	GHO_IFLOT_EXT	Function location extension table	2	TPLNR	Functional Location	nvarchar	30	0
75	GHO_IFLOT_PLAN	Function location extension table	2	TPLNR	Functional Location	nvarchar	30	0
76	GHO_ILOA_EXT	OBSOLETE: DO NOT USE	8	TPLNR	Functional Location	nvarchar	30	0
77	GHO_NETOBJ_TD	Well Time Dependency	2	TPLNR	Functional Location	nvarchar	30	0
78	GHO_PROD_NW_FREQ	Frequencies for Production Network	2	TPLNR	Functional Location	nvarchar	30	0
79	GHO_PROD_NW_MED	Mediums for Production network	2	TPLNR	Functional Location	nvarchar	30	0
80	GHO_WELL_TD	Well Time Dependency	2	TPLNR	Functional Location	nvarchar	30	0
TOPOperative Structures
81	PRPS	WBS (Work Breakdown Structure) Element Master Data	40	TPLNR	Functional Location	nvarchar	30	0
TOPOwnership
82	GHO_OWN_NET_ASG	Ownership (DOI) assignment to Network Objects	4	TPLNR	Functional Location	nvarchar	30	0
TOPPermits
83	IHSG	Object-Related Permits in Plant Maintenance	15	TPLNR	Functional Location	nvarchar	30	0
TOPPlant Maintenance
84	MCB_BUD	MCB Retraction data for Budget check	3	TPLNR	Functional Location	nvarchar	30	0
85	PLMN_FL_EXT	GHO Object characteristics	2	TPLNR	Functional Location	nvarchar	30	0
TOPPool Asset Management
86	PAMS_TPOOLTP	PAM Pools for Functional Locations	3	TPLNR	Functional Location	nvarchar	30	0
TOPProduct Structure Browser
87	USROBJECTS	Table of Previous Initial Object in Structure Overview	12	TPLNR	Functional Location	nvarchar	30	0
TOPProduction and Revenue Accounting
88	OIU_ME_CNTNR	General measurement container	10	TPLNR	Functional Location	nvarchar	30	0
TOPProduction Orders
89	AFVC	Operation within an order	181	TPLNR	Functional Location	nvarchar	30	0
TOPQuality Inspection
90	QAPP	Inspection point	13	TPLNR	Functional Location	nvarchar	30	0
TOPReal Estate Management
91	VIOB29	OLD, replaced by VIOB39 for 3.0	3	TPLNR	Functional Location	nvarchar	30	0
92	VIOB39	Relationship between Real Estate objects and SAP-PM	3	TPLNR	Functional Location	nvarchar	30	0
TOPRemote Logistics Management
93	OIO_MX_OBJECT	RLM tracking extract object data	44	TPLNR	Functional Location	nvarchar	30	0
TOPReporting
94	MCIPMIS	PMIS: Master data characteristics for PMIS before image	19	TPLNR	Functional Location	nvarchar	30	0
95	S061	Location and planning	13	TPLNR	Functional Location	nvarchar	30	0
96	S061E	S061 - Structural Information	8	TPLNR	Functional Location	nvarchar	30	0
97	S063	Damage Analysis 30 .	8	TPLNR	Functional Location	nvarchar	30	0
98	S063E	S063 - Structural Information	3	TPLNR	Functional Location	nvarchar	30	0
99	S064	Single object - damage analysis	8	TPLNR	Functional Location	nvarchar	30	0
100	S070	Breakdown Statistics	9	TPLNR	Functional Location	nvarchar	30	0
101	S070E	S070 - Structural Information	4	TPLNR	Functional Location	nvarchar	30	0
102	S115	Cost Evaluation	10	TPLNR	Functional Location	nvarchar	30	0
103	S115E	S115 - Structural Information	5	TPLNR	Functional Location	nvarchar	30	0
TOPRouting
104	PLPO	Task list - operation/activity	218	TPLNR	Functional Location	nvarchar	30	0
TOPService Station Retailing
105	OIRBOIFLO	Object links - PM functional location (IS-Oil SSR)	13	TPLNR	Functional Location	nvarchar	30	0
TOPSimulation
106	VSAFVC_CN	Version: Operation in order	185	TPLNR	Functional Location	nvarchar	30	0
107	VSPRPS_CN	Version: WBS Element (Work Breakdwn Struc. Elem.) Mast. Data	41	TPLNR	Functional Location	nvarchar	30	0
TOPStatus Board
108	/ISDFPS/LINKSMEQ	Object Relationships of Master Equipment (Performance)	5	TPLNR	Functional Location	nvarchar	30	0
TOPTakeoverHandover of Technical Objects
109	PHINT	Phase In Table	23	TPLNR	Functional Location	nvarchar	40	0
TOPTechnical Objects
110	TITOB_IBASE	Creation of IBase: Buffer Table Structures	6	TPLNR	Functional Location	nvarchar	30	0
TOPTemplates
111	PRPSS	Standard WBS Element (WBS element) - Master Data	40	TPLNR	Functional Location	nvarchar	30	0
TOPTraders and Schedulers Workbench
112	OIISOCK	SOC: Storage object characteristic segment header	8	TPLNR	Functional location ID	nvarchar	30	0
TOPWaste Management
113	EEWA_PROP_H	Header data of property	9	TPLNR	Functional Location	nvarchar	30	0
114	EWAPROPSD	Allocation Table: Property <-> Sales Document Item	11	TPLNR	Functional Location	nvarchar	30	0
115	EWA_EL_WDPLANT	Waste Disposal Facility	6	TPLNR	Functional Location	nvarchar	30	0
TOPWork Clearance Management
116	WCAAP	WCM: Application	26	TPLNR	Functional Location	nvarchar	30	0
117	WCAHE	WCM: Work Clearance Document (Header)	26	TPLNR	Functional Location	nvarchar	30	0
118	WCAJ	WCM: Lineup	14	TPLNR	Functional Location	nvarchar	30	0
119	WCAW	WCM: Work Approval	24	TPLNR	Functional Location	nvarchar	30	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

119 columns | ERP 6.0 | TPLNR