	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

144 columns | ERP 6.0 | ENDDATE

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/ATL/FORECLOSURE	Foreclosures	15	ENDDATE	End date	nvarchar	8	0
2	/ATL/SHAAM	Withholding tax for vendors from shaam	4	ENDDATE	Withholding tax end date	nvarchar	8	0
3	/CEERE/FUC	Tax Offices - time dependent	4	ENDDATE	END date	nvarchar	8	0
4	/CEERE/FUKDC	Tax office: master data - time dependent	4	ENDDATE	END date	nvarchar	8	0
5	/CEERE/FUR	Regional Tax Office Workplace	5	ENDDATE	END date	nvarchar	8	0
6	/GEP/T_NEED	Graphischer Leitstand: Bedarfe (einzuplanende Objekte)	11	ENDDATE	Enddatum	nvarchar	8	0
7	/GEP/T_SPLIT	Graphischer Leitstand: Splits (eingeplante Objekte)	12	ENDDATE	Enddatum	nvarchar	8	0
8	/SOMO/JOBMON11	Job schedule information	44	ENDDATE		nvarchar	8	0
9	/XFT/EPA_BO_LEAN	Lend Data	8	ENDDATE	System Date	nvarchar	8	0
10	/XFT/EPA_DLEAN	Lend Data	7	ENDDATE	System Date	nvarchar	8	0
11	CNVA_00555_STATE	State Table for Run Time Estimation	9	ENDDATE	Field of type DATS	nvarchar	8	0
12	CNVA_CCD_ANA_STA	State Table for CC Deletion Analysis Package	10	ENDDATE	Field of type DATS	nvarchar	8	0
13	CNVCMISBACKUP_EX	Backup Functionality - Runtime Information	10	ENDDATE		nvarchar	8	0
14	CNVC_SCNG_EXTR	Extracts	6	ENDDATE	Date	nvarchar	8	0
15	CNV_20308_CMP	Header Data for Package Comparison	29	ENDDATE	Date	nvarchar	8	0
16	CNV_20308_DL	Downloads	16	ENDDATE	Date	nvarchar	8	0
17	CNV_ADT_DP_LOG	T. Summary: Data provider execution log (single DP)	7	ENDDATE	Date	nvarchar	8	0
18	CNV_ADT_DP_LOGP	T. Summary: Data provider execution log (whole package)	7	ENDDATE	Date	nvarchar	8	0
19	DMC_IU_UVERS	MWB: Backup Copy of UVERS	5	ENDDATE	Date	nvarchar	8	0
20	DMC_MDS_AVERS	MDS: Information About Updates of R/3 Add-On Products	7	ENDDATE	Date	nvarchar	8	0
21	DMC_MDS_UVERS	MDS: Backup of Upgrade Information	6	ENDDATE	Date	nvarchar	8	0
22	DVM_BOF_RUNS	Business Objects Footprint runs	12	ENDDATE	Date	nvarchar	8	0
23	REQHEADS	Temporary Header Data: Requirement Coverage Request (Limit)	54	ENDDATE	Timeframe	nvarchar	8	0
24	SUBST_SLANA_HDR	SL Analytics Header Data	7	ENDDATE		nvarchar	8	0
25	TNNL_HT_THESAURS	Diagnose Thesaurus Diagnose Konzepte	4	ENDDATE	Enddatum	nvarchar	8	0
26	TNNL_KT_DBC	Diagnose Thesaurus Beziehung DBC Kode	5	ENDDATE	Enddatum	nvarchar	8	0
27	TNNL_KT_DOMEINEN	Domänen	5	ENDDATE	Enddatum	nvarchar	8	0
28	TNNL_KT_ICD10	Diagnose Thesaurus Beziehung ICD10 Kode	5	ENDDATE	Enddatum	nvarchar	8	0
29	TNNL_RT_DBC	Diagnose Thesaurus Beziehung DBC	5	ENDDATE	Enddatum	nvarchar	8	0
30	TNNL_RT_ICD10	Diagnose Thesaurus Beziehung ICD10	4	ENDDATE	Enddatum	nvarchar	8	0
31	ZSKCOURSES	training courses	5	ENDDATE		nvarchar	8	0
32	ZSKCSPHJ02	csp	3	ENDDATE	Systemdatum	nvarchar	8	0
33	ZSKSCHEDULE	Course schedule for standard training	6	ENDDATE		nvarchar	8	0
34	ZTR_COURSES	training courses	8	ENDDATE		nvarchar	10	0
35	HRP1774	DB Table for Infotype 1774	23	ENDDATE	End Date of Individual Work	nvarchar	8	0
36	T7PIQ_NL_ADMREQ	Admission Requirements	8	ENDDATE	End Date	nvarchar	8	0
37	T7PIQ_NL_COUNTRY	Countries	5	ENDDATE	End Date	nvarchar	8	0
38	T7PIQ_NL_EDUC	Education Details	5	ENDDATE	End Date	nvarchar	8	0
39	T7PIQ_NL_EDUPGM	Educational Program Details	9	ENDDATE	End Date	nvarchar	8	0
40	T7PIQ_NL_INSBRIN	BRIN Number of the Institute	5	ENDDATE	End Date	nvarchar	8	0
41	T7PIQ_NL_INSTIT	Institutes and Education Details	7	ENDDATE	End Date	nvarchar	8	0
42	T7PIQ_NL_LOTDRAW	Application period second lottery drawing	7	ENDDATE	End Date	nvarchar	8	0
43	T7PIQ_NL_NATITY	Nationalities	5	ENDDATE	End Date	nvarchar	8	0
44	T7PIQ_NL_PREEDUC	Previous Education Details	4	ENDDATE	End Date	nvarchar	8	0
45	T7PIQ_NL_SUB	Subjects	3	ENDDATE	End Date	nvarchar	8	0
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
46	CRM_ECLOG_HEAD	Table for Replicated eCATT Log Header	6	ENDDATE	End Date	nvarchar	8	0
TOPALE Integration Technology
47	TBD00	Views of customer model	8	ENDDATE	End Date	nvarchar	8	0
48	TBD03	Communication relation between systems	10	ENDDATE	End Date	nvarchar	8	0
TOPBackground Processing
49	BTCOMSET	Definition of operation type sets and exception op. modes	4	ENDDATE	Start or end data of operation mode	nvarchar	8	0
50	TBTCO	Job Status Overview Table	20	ENDDATE	Job start date	nvarchar	8	0
TOPBank Customer Accounts
51	BKKBENCH	Benchmark Results	12	ENDDATE	End Date	nvarchar	8	0
52	BKKBENCHACBAL	Benchmark Results Account Balancing	16	ENDDATE	End Date	nvarchar	8	0
53	BKKBENCHBKSTAT	Benchmark Results Bank Statement	12	ENDDATE	End Date	nvarchar	8	0
TOPBusiness Consolidation
54	UCST001	SEM-BCS: Performance Statistics	6	ENDDATE	System Date	nvarchar	8	0
TOPBusiness Server Pages
55	AUOFFER	Auction Offer Table	4	ENDDATE	Auction Date Format	nvarchar	8	0
TOPClaims Management
56	ICLDIAGNOSIS	Diagnoses Made	17	ENDDATE	End Date	nvarchar	8	0
57	ICLITEM	Claim Item	33	ENDDATE	End Date	nvarchar	8	0
58	ICLITEMEV	Claim Item Evaluation	26	ENDDATE	End Date	nvarchar	8	0
59	ICLITEMEVB	Claim Item: Daily Rate Valuation	12	ENDDATE	End Date	nvarchar	8	0
60	ICLLITHEADER	Litigation	13	ENDDATE	Litigation End Date	nvarchar	8	0
61	ICL_WCMPH	Workers Comp - Header Data	17	ENDDATE	Initial Return to Work Date	nvarchar	8	0
62	ICSDIAGNOSIS	Diagnoses	17	ENDDATE	End Date	nvarchar	8	0
63	ICSITEM	Claim Item	33	ENDDATE	End Date	nvarchar	8	0
64	ICSITEMEV	Claim Item Evaluation	26	ENDDATE	End Date	nvarchar	8	0
65	ICSITEMEVB	Claim Item: Daily Rate Valuation	12	ENDDATE	End Date	nvarchar	8	0
66	ICSLITHEADER	Litigation	13	ENDDATE	Litigation End Date	nvarchar	8	0
67	ICS_WCMPH	Workers Comp - Header Data	17	ENDDATE	Initial Return to Work Date	nvarchar	8	0
TOPClinical System
68	N1MATVM	IS-H*MED: Medical info for material consumpt. documentation	7	ENDDATE	Closing Date	nvarchar	8	0
69	N2GL_TM_SCHEDULE	pathways Patient Pathway	28	ENDDATE	End Date of Patient Pathway	nvarchar	8	0
TOPContract Accounts Receivable and Payable
70	DFKKWLI	Work Items	48	ENDDATE	Work Item: Latest End Date	nvarchar	8	0
71	DFKKWLIA	Work Items (Work Item Type)	48	ENDDATE	Work Item: Latest End Date	nvarchar	8	0
TOPDocument Builder
72	/IPRO/TDOCMNT	Document Builder Documents	28	ENDDATE	End Date	nvarchar	8	0
TOPeCATT Extended Computer Aided Test Tool
73	ECLOG_AIDX	Table for Log Archive Index	13	ENDDATE	End Date	nvarchar	8	0
74	ECLOG_HEAD	Table for Log Header	5	ENDDATE	End Date	nvarchar	8	0
75	ECLOG_HYDRA	Several Header Entries for Log	14	ENDDATE	End Date	nvarchar	8	0
76	ECTRACE	eCATT Recordings	14	ENDDATE	System Date	nvarchar	8	0
77	TZRR_EVCMD	TestZone: Result Repository Event Command	7	ENDDATE	Event Date	nvarchar	8	0
78	TZRR_EXEC	TestZone: Result Repository Start Activity Data	12	ENDDATE	End Date	nvarchar	8	0
TOPEmployee Interaction Center
79	THREIC_CAT_RES1	EIC: Category and Resolution Assignment	3	ENDDATE	End Date	nvarchar	8	0
80	THREIC_CAT_RES2	EIC: Categories	3	ENDDATE	End Date	nvarchar	8	0
81	THREIC_FOLLOWUP	EIC Follow-Up	11	ENDDATE	EIC: Follow-Up End Date	nvarchar	8	0
TOPFlexible Real Estate Management
82	VIGBHV	LUM: Grundbuch - Herrschvermerke	6	ENDDATE	Datum Herrschvermerk	nvarchar	8	0
83	VIGBOOK	LUM: Grundbuch	24	ENDDATE	Schließungsdatum Grundbuch	nvarchar	8	0
84	VIGBVZUAB1	LUM: Grundbuch - Zu-/Abschreibungen BV	6	ENDDATE	Rötungsdatum BV-Nummer	nvarchar	8	0
TOPGeneral Ledger Accounting
85	NGLM_ANA_HD	Analysis Run Header	6	ENDDATE	Date	nvarchar	8	0
TOPGlobal Performance Analysis Transaction ST3
86	AMASTA	Global Performance Analysis: Application Statistc (from 7.0)	10	ENDDATE	SAP Workload NW Collector: Date	nvarchar	8	0
87	AMESISTA	Global Performance Analysis: Statistics Main Rec + ESI Total	10	ENDDATE	SAP Workload NW Collector: Date	nvarchar	8	0
88	AMSTA	Global Performance Analysis: Statistical Data	6	ENDDATE	End Date (Local) for Performance Log Statistical Record	nvarchar	8	0
TOPI18N Unicode
89	UMGTSKQ	SUMG: Worklist	10	ENDDATE	End Date	nvarchar	8	0
TOPIndustry Solution Catch Weight Management
90	/CWM/MIG_PROT_H	Migration Log Header	8	ENDDATE		nvarchar	8	0
TOPKnowledge Warehouse
91	KWDELTA_WL	IWB: Worklist for Delta Delivery (Content)	4	ENDDATE	Date	nvarchar	8	0
TOPLocalization
92	J_1AOIFWVL	Open item foreign currency valuation: temp. storage	14	ENDDATE	Key Date for OI Overview	nvarchar	8	0
93	J_3RSPASSDEAL	Deal Passport	18	ENDDATE	Deal Passport Expiration Date	nvarchar	8	0
TOPMonitoring
94	ALDWNTIME	Downtime of systems for availability calculations	10	ENDDATE	Date	nvarchar	8	0
TOPOnline Correction Support Support Package and Add-On Tools
95	PAT02	Conflicts Between Patches and Add-Ons	8	ENDDATE	Date	nvarchar	8	0
96	PATHISTORY	History of Imported SPAM/SAINT Queues	7	ENDDATE	Support Package import date	nvarchar	8	0
97	PATRTPHASE	OCS Runtime Analysis: Einspielphasen	9	ENDDATE	Einspieldatum des Support Package	nvarchar	8	0
TOPOverhead Cost Controlling
98	PFFLD	Period-End Partner: Organizational Log Information	25	ENDDATE	End Date for Processing	nvarchar	8	0
TOPPool Asset Management
99	PAMS_NEED	Graphical Planning Board: Requests (Objects to Schedule)	11	ENDDATE	End Date	nvarchar	8	0
100	PAMS_SPLIT	Graphical Planning Board: Splits (Scheduled Objects)	12	ENDDATE	End Date	nvarchar	8	0
TOPPortfolio Management
101	RPM_FIDATA	Financial Information	15	ENDDATE	Start Date	nvarchar	8	0
102	RPM_PROJECT_CO	Controlling Information about a project	12	ENDDATE	Start Date	nvarchar	8	0
103	RPM_SCENARIO_FIN	RPM : Scenario financial data	10	ENDDATE	Start Date	nvarchar	8	0
TOPPosition Budgeting and Control
104	HRFPM_RUNADMINS	HRFPM: Administration Information for Commitment Runs	5	ENDDATE	End Date of Commitment Run	nvarchar	8	0
TOPProduct Cost Controlling
105	CATDH	CATT Test Data Memory, History	17	ENDDATE	System Date	nvarchar	8	0
TOPProduct Cost Planning
106	TCWB_OBJECTS_HIS	Historie zum Testobjekt	14	ENDDATE	Systemdatum	nvarchar	8	0
TOPProduction and Revenue Accounting
107	OIUP_PDM_JOBS	PDM: Job Data	21	ENDDATE	Job start date	nvarchar	8	0
TOPProfitability Analysis
108	TKENC5	CO-PA Realignments: Execution Logs	12	ENDDATE	Finish date	nvarchar	8	0
TOPReal Estate Localization Czech Republic
109	/CEERE/KOEFMP	obsolete Koeficients for municipalities parts	11	ENDDATE	End Date	nvarchar	8	0
110	/CEERE/KOEFMPSIM	Koeficients for municipalities parts	11	ENDDATE	End Date	nvarchar	8	0
111	/CEERE/KOEF_K15	Koeficient 1,5 from § 11, 3b	5	ENDDATE	End Date	nvarchar	8	0
TOPReal Estate Management
112	VIGBUCH	Land register	25	ENDDATE		nvarchar	8	0
TOPReuse Services for Country Development
113	T5F99CD	Calculation of duration in HR	12	ENDDATE	Indicator of date adjustment for calculation of durations	nvarchar	5	0
TOPSAP Business Workflow
114	SWF_WFPREC	WF: Recovery information for Workflow Wizards	15	ENDDATE	System Date	nvarchar	8	0
TOPSAP Healthcare - Industry-Specific Components for Hospitals
115	TNNLTARIFF	Tariff	8	ENDDATE	ISH_NL: Ende datum	nvarchar	8	0
TOPSAP NetWeaver Mobile - Use subcomponents
116	MEREP_208	Replicator Run Control	6	ENDDATE	Job start date	nvarchar	8	0
TOPSAP Records Management
117	SRMWFPTHPS	Process Route Item for Workflow	19	ENDDATE	Date Process Route Item Executed	nvarchar	8	0
TOPSAP Utilities
118	ISU_WUI_DOC_FLTR	Document filter criteria for user	9	ENDDATE	Date	nvarchar	8	0
TOPScripting
119	CRMD_IC_SCRATTR	Script/Survey attributes (Interactive Script Editor)	6	ENDDATE	Date	nvarchar	8	0
TOPService Data Download
120	/SDF/BPM_ASTAD	BPMon Application Statistical Records	2	ENDDATE	SAP Workload: Workload: Date	nvarchar	8	0
121	/SDF/BPM_ASTAD2	BPMon Application Statistical Records	2	ENDDATE	SAP Workload: Workload: Date	nvarchar	8	0
122	/SDF/BPM_TSTAD	BPMon Technical Statistical Records	2	ENDDATE	SAP Workload: Workload: Date	nvarchar	8	0
123	/SDF/CMO_T_62B	CCMC Service: Period	2	ENDDATE	Field of type DATS	nvarchar	8	0
124	/SDF/SWCM_AVERSD	R/3 Add-On Product (DEV) Update Information	6	ENDDATE	Date	nvarchar	8	0
125	/SDF/SWCM_AVERSP	R/3 Add-On Product (PRD) Update Information	6	ENDDATE	Date	nvarchar	8	0
126	/SDF/SWCM_AVERSQ	R/3 Add-On Product (QAS) Update Information	6	ENDDATE	Date	nvarchar	8	0
127	/SOMO/JOSCHEDL	Job scheduling table for business process monitoring	24	ENDDATE		nvarchar	8	0
TOPTime Sheet
128	CATS_DEF_ACCOUNT	CATS Default Accounting	4	ENDDATE	End Date	nvarchar	8	0
TOPTools
129	HRPYO_D_CYCL	Cycles	9	ENDDATE	End Date	nvarchar	8	0
130	HRPYO_D_CYSTP	Steps of the cycles	15	ENDDATE	End Date	nvarchar	8	0
131	HRPYO_D_SCHDL	Schedule	10	ENDDATE	End Date	nvarchar	8	0
TOPTraining Management
132	PA3225	Personnel Record for Infotype 3225	28	ENDDATE	Course End Date	nvarchar	8	0
TOPTransaction Manager
133	TERTVWERKO	Executable Rights (Header)	6	ENDDATE	Term to	nvarchar	8	0
TOPTranslation Tools
134	TRACOLH	Request list of transport collector (header)	9	ENDDATE	Date of Last Change	nvarchar	8	0
TOPTransport Organizer
135	GUPDLAYOUT	List of Table Layouts that Need to Be Updated	11	ENDDATE	Date of Last Change	nvarchar	8	0
TOPUpgrade - General
136	AVERS	Information About Updates of R/3 Add-On Products	6	ENDDATE	Date	nvarchar	8	0
137	GODIRLOCK	Synchronization for Reports that Fill GODIR	5	ENDDATE	Date	nvarchar	8	0
138	MERGEH	Request List of the Transport Merger (Header)	12	ENDDATE	Merge period - End date	nvarchar	8	0
139	NAVERS	UPG: Information About Updates of R/3 Add-On Products	7	ENDDATE	Date	nvarchar	8	0
140	SUBST_UPGEV_HDR	Upgrade Evaluation (Customer Side) Header Table	4	ENDDATE	Text field length 14	nvarchar	14	0
141	UVERS	Upgrade Information	5	ENDDATE	Date	nvarchar	8	0
142	UVERS_HIST	Upgrade Information - History	7	ENDDATE	Date	nvarchar	8	0
TOPUpgrade Tools
143	DDCPRO	DD: Conversion projects	6	ENDDATE	System Date	nvarchar	8	0
TOPWeb Service and SOAP - ABAP
144	SRT_WSSELECTION	OBSOLETE Excerpt of Selection Criteria	13	ENDDATE	System Date	nvarchar	8	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

144 columns | ERP 6.0 | ENDDATE