	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

91 columns | ERP 6.0 | TZONE

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/LOCSRM/SYS_MSG	System messages in Live auction for Brazil PPS	5	TZONE	Time Zone	nvarchar	6	0
2	/MRSS/C_NW_TZONE	Time Zone To Be Used for the Integration of Demands	3	TZONE	Time Zone to Be Used for the Integration of Demands	nvarchar	1	0
3	/MRSS/M_HCMTZONE	Assignment: Mirror for Personnel (Sub)Area - MRS Time Zone	6	TZONE	Standard Time Zone for SAP Multiresource Scheduling	nvarchar	6	0
4	/MRSS/M_R3_TZONE	Mirror for Time Zone attribute	5	TZONE	Indicator for Time Zone in Demand Integration	nvarchar	1	0
5	/OPT/CT_PDF_PF	PDF Log: Profiles	9	TZONE	Time Zone	nvarchar	6	0
6	/ORS/USER_PREFER	User preference	18	TZONE	Time Zone	nvarchar	6	0
7	/SMD/MD_____00M4	SID-Tabelle fuer Time zone	3	TZONE	Time Zone	nvarchar	6	0
8	/SOMO/JOBMON04	Job Metric definition table	24	TZONE	Time Zone	int	10	0
9	/SOMO/JOBMON11	Job schedule information	46	TZONE	Time Zone	int	10	0
10	BBPD_LA_ACTIVITY	User activities log	8	TZONE	Time Zone	nvarchar	6	0
11	BBPD_LA_BIDHIST	Bid history	21	TZONE	Time Zone	nvarchar	6	0
12	BBPD_LA_CHAT	Chat	10	TZONE	Time Zone	nvarchar	6	0
13	BBPD_LA_CLTSTAT	Client status	11	TZONE	Time Zone	nvarchar	6	0
14	BBPD_LA_LASTBID	Auction last (best) bid	9	TZONE	Time Zone	nvarchar	6	0
15	BBPD_LA_MESSAGE	Message	15	TZONE	Time Zone	nvarchar	6	0
16	BBPD_LA_PALASTB	Bidders' best bid	20	TZONE	Time Zone	nvarchar	6	0
17	BBPD_LA_PARTNERB	Best bid per bidder and auction item	10	TZONE	Time Zone	nvarchar	6	0
18	BBPD_LA_PROXYBID	Proxy bid status	13	TZONE	Time Zone	nvarchar	6	0
19	BBP_PDHGP	Business Transaction Purchasing Information	37	TZONE	Time Zone for Date and Time Fields of Procurement Document	nvarchar	6	0
20	DFKK_MA_H	Header Data of Master Agreement	16	TZONE	Time Zone of Master Agreement	nvarchar	6	0
21	EBILLPRG	IS-U: Billing Programs	6	TZONE	Time Zone for Usage in Billing Program	nvarchar	6	0
22	ECONDIPROCINTF	IS-U: Processing Interface for Conditions	6	TZONE	Time Zone for Usage in Billing Program	nvarchar	6	0
23	ETOUEXCPTPRG	TOU Exception Program	6	TZONE	Time Zone for TOU Exception Program	nvarchar	6	0
24	T243E	Time Zone of the Subsystems	3	TZONE	Time Zone	nvarchar	6	0
25	ZIDES_USR02	Logon data of certain users	32	TZONE	Time Zone	nvarchar	6	0
26	ZUSR02	Users and passwords	32	TZONE	Time Zone	nvarchar	6	0
TOPAccounting Interface
27	GLE_RUNADM_ID	ERP Run Administration	14	TZONE	Time Zone	int	10	0
TOPAddress ManagementBusiness Address
28	SADR	Address Management: Company Data	49	TZONE	Time Zone	nvarchar	6	0
TOPAuthentication and SSO
29	USR02	Logon Data (Kernel-Side Use)	32	TZONE	Time Zone	nvarchar	6	0
TOPBasic Functions
30	FSLST	Foreign Trade: Legal Control - SLS - Audit Trail	2	TZONE	Time Zone	nvarchar	6	0
31	FSLSTA	Foreign Trade: Legal Control - SLS - Audit Trail	2	TZONE	Time Zone	nvarchar	6	0
32	FTCOMT	Foreign Trade: Communication: Audit table for FT documents	2	TZONE	Time Zone	nvarchar	6	0
33	FTGKL	Legal Control: Log (Up-to-Date)	3	TZONE	Time Zone	nvarchar	6	0
34	FTGKLA	Legal Control: Log (Prestep for Archiving)	3	TZONE	Time Zone	nvarchar	6	0
35	FTGOVPA	Foreign Trade: Periodic Declarations	8	TZONE	Time Zone	nvarchar	6	0
36	MMPREF_PRO_01	Logging table for archiving object MMPREF	2	TZONE	Time Zone	nvarchar	6	0
37	MMPREF_PRO_01_B	Log table - Preference - Information from rules	2	TZONE	Time Zone	nvarchar	6	0
38	MMPREF_PRO_02	Log table - Main component - Information	2	TZONE	Time Zone	nvarchar	6	0
39	MMPREF_PRO_03	Log table - Component - Information	2	TZONE	Time Zone	nvarchar	6	0
40	MMPREK_PRO_01	Log table for archiving object MMPREK	2	TZONE	Time Zone	nvarchar	6	0
41	MMPREK_PRO_01_B	Log table - Preference - Info from rule	2	TZONE	Time Zone	nvarchar	6	0
42	MMPREK_PRO_02	Log table - Main component - Information	2	TZONE	Time Zone	nvarchar	6	0
43	MMPREK_PRO_03	Log table - Component - Information	2	TZONE	Time Zone	nvarchar	6	0
44	MMPREW_PRO_01	Log table for archiving object MMPREW	2	TZONE	Time Zone	nvarchar	6	0
45	MMPREW_PRO_01_B	Preference CPG: Log - Information from rule	2	TZONE	Time Zone	nvarchar	6	0
46	MMPREW_PRO_02	Preference CPG: Log main component - Information	2	TZONE	Time Zone	nvarchar	6	0
47	MMPREW_PRO_03	Preference CPG: Log components - Information	2	TZONE	Time Zone	nvarchar	6	0
TOPBilling in Contract Accounts Receivable and Payable
48	TFK8026	Billing Cycle	11	TZONE	Time Zone for Billing Cycle	nvarchar	6	0
TOPBusiness Planning and Simulation
49	UPS_LINKS	Links to Org. Values	9	TZONE	Time Zone	nvarchar	6	0
TOPComplaints and Returns
50	/SPE/INSPECRESH	Inspection Outcome: Header	12	TZONE	Time Zone	nvarchar	6	0
TOPContract Accounts Receivable and Payable
51	DFKK_VT_H	CT: Header Data of Provider Contract	19	TZONE	Time Zone of Provider Contract	nvarchar	6	0
TOPCross-Application Components
52	FRE_DB_SITE	Relevant site's in F&R	4	TZONE	Timezone for site	nvarchar	6	0
TOPCustomer Interaction Center
53	CCMCLBS	Call center callback - Whole	13	TZONE	Time Zone	nvarchar	6	0
TOPDigital Signature
54	TC71	Digital Signature	14	TZONE	Time Zone	nvarchar	6	0
TOPDownloadUpload
55	/DSD/HH_RADELHD	DSD Route Settlement: Delivery Execution - Header	9	TZONE	DSD - RA: Time Zone	nvarchar	6	0
TOPFlexible Real Estate Management
56	TIVCARECUR	Recurrence Rule	24	TZONE	Time Zone	nvarchar	6	0
57	VICARECUR	Deadline Regulation	24	TZONE	Time Zone	nvarchar	6	0
TOPGeographical Functions
58	GEOLOC	Geo location (lon/lat/alt/...)	9	TZONE	Time Zone	nvarchar	6	0
TOPGlobal Trade Services
59	/SAPSLL/TLEGTZ	Assign Time Zone to Deadline Type for Each Legal Regulation	5	TZONE	Time Zone	nvarchar	6	0
TOPImplementation Guide
60	TPRORGUNITS	Organizational Units Affected in a Project	8	TZONE	Time Zone	nvarchar	6	0
TOPIndustry-Specific Component Automotive
61	RESKEYR3	Resource Proxy ERP	9	TZONE	Time Zone	nvarchar	6	0
TOPInformation System, iViews
62	BWOM2_TIMEST	BW CO-OM: Timestamp Table for Delta Extraction	9	TZONE	Time Zone	int	10	0
TOPInterface to Terminal Automation System
63	OIK37	IS OIL: Shadow table for SD document processing	21	TZONE	Time Zone	nvarchar	6	0
64	TOIKOWC	Time windows	5	TZONE	Time Zone	nvarchar	6	0
TOPJust-In-Time Processing
65	JITBACKFTMP	Temporary File for Confirmation Pool	19	TZONE	Time Zone	nvarchar	6	0
66	JITCU	Customer data	6	TZONE	Time zone of customer plant	nvarchar	6	0
67	JITTC0	User Profile for the JIT Cockpit	6	TZONE	Time Zone of Specific User	nvarchar	6	0
TOPMaintenance Orders
68	/MRSS/C_HCMTZONE	Assignment: Personnel (Sub)Area - MRS Time Zone	4	TZONE	Time Zone	nvarchar	6	0
TOPRecycling Administration Core Functions
69	J_7LSADR	Address Management: Company Data	49	TZONE	Time Zone	nvarchar	6	0
TOPRemaining Beverage - Obsolete Objects
70	/BEV1/RPTZKD	Assignment Customer-Transportation Zone-Sequence No. (RPlan)	3	TZONE	Transportation zone to or from which the goods are delivered	nvarchar	10	0
71	/BEV1/RPTZZEIT	Times at Transportation Zone Level (Dyn.Transport.Planning)	3	TZONE	Transportation zone to or from which the goods are delivered	nvarchar	10	0
TOPReturnable Packaging Logistics
72	RLREPROC_ITEM	Item Default Data for Reprocessing Record	16	TZONE	Time Zone	nvarchar	6	0
TOPRoom Reservations and Seating Arrangements
73	TIVORRSAREA	Reservation Area	3	TZONE	Time Zone	nvarchar	6	0
74	VIORRS	Reservation	33	TZONE	Time Zone	nvarchar	6	0
TOPTime streams
75	TTSTR	Time stream: Administration table	11	TZONE	Time Zone	nvarchar	6	0
TOPTime Zones
76	TTZ5	Assign Time Tones to Countries	3	TZONE	Time Zone	nvarchar	6	0
77	TTZ5S	Assign time zones to regions	4	TZONE	Time Zone	nvarchar	6	0
78	TTZ5Z	Assign time zones to postal codes in gener. length	4	TZONE	Time Zone	nvarchar	6	0
79	TTZEX	Convert Time Zone ID from External to Internal	4	TZONE	Time Zone	nvarchar	6	0
80	TTZIN	Convert Time Zone ID from Internal to External	3	TZONE	Time Zone	nvarchar	6	0
81	TTZZ	Time zones	2	TZONE	Time Zone	nvarchar	6	0
82	TTZZT	Time Zones	3	TZONE	Time Zone	nvarchar	6	0
TOPTraders and Schedulers Workbench
83	OIGSV	TD Vehicles in Transport/Shipment	21	TZONE	Time Zone	nvarchar	6	0
84	OIGV	TD Vehicle Header	19	TZONE	Time Zone	nvarchar	6	0
TOPTraining and Event Management
85	HRP1026	Infotype 1026 DB table	32	TZONE	Time Zone	nvarchar	6	0
TOPUser and Authorization Management
86	USR03	User address data	28	TZONE	Time Zone	nvarchar	6	0
TOPWithout Description
87	CCMSBIAVAILDOWNT	Individual Non-Availability Settings	15	TZONE	Time Zone	nvarchar	6	0
88	CCMSBIAVLREPCF	Individual Reporting Settings: SLA Limits	20	TZONE	Time Zone	nvarchar	6	0
TOPWorkforce Management Core
89	/SAPAPO/LRPSOPRO	Supplied WD Time Overtime Profile Set	11	TZONE	TimeZone	nvarchar	6	0
90	WFDBPC_RULE	WFD Template rules	11	TZONE	Time zone of appointment	nvarchar	6	0
91	WFDOTPROF	Overtime Profile Configuration	9	TZONE	TimeZone	nvarchar	6	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

91 columns | ERP 6.0 | TZONE