	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

113 columns | ERP 6.0 | FDATE

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/ATL/GL1V	Index Values	3	FDATE	Date As of Which the Exchange Rate Is Effective	nvarchar	8	0
2	DFKKBPLOCK	FI-CA: Business Partner Locks	5	FDATE	Lock valid from	nvarchar	8	0
3	DFKKBPLOCKH	FI-CA: Business Partner Locks - History	7	FDATE	Lock valid from	nvarchar	8	0
4	ETALLPAIRS_HEAD	Header Data of AllPairs Objects	6	FDATE	Created on	nvarchar	8	0
5	PA0429	HR Master Record, Infotype 0429	28	FDATE		nvarchar	8	0
6	PA0432	HR Master Record, Infotype 0432	26	FDATE		nvarchar	8	0
7	PB0432	HR Master Record, Infotype 0432	26	FDATE		nvarchar	8	0
8	REFXCN_CD_ADJ	Condition Adjustment	8	FDATE	Posting Date	nvarchar	8	0
9	HRP1707	Database Table for Infotype 1707	19	FDATE	Created On	nvarchar	8	0
TOPASAP AcceleratedSAP
10	IATNODE01	Node Table for Implementation Assistant	31	FDATE	Created on	nvarchar	8	0
11	TCUSTEMP	Customizing templates entity table	4	FDATE	Date created	nvarchar	8	0
12	TNODEREV	Structure Item Table for Review Structures	31	FDATE	Created on	nvarchar	8	0
TOPASAP Tools and Contents
13	SMAPTNODE	Solution Map: Node table	31	FDATE	Created on	nvarchar	8	0
TOPAuthoring Tools
14	QMM_NODE	QMM: Node Table for General Structure Storage	31	FDATE	Created on	nvarchar	8	0
TOPBasic Functions
15	T830A	FI-SL Master Record Table	4	FDATE	Valid from date (inverted: 99999999 - YYYYMMDD)	nvarchar	8	0
16	T830B	FI-SL Master Record Table	4	FDATE	Valid from date (inverted: 99999999 - YYYYMMDD)	nvarchar	8	0
17	T830D	FI-SL Master Record Table	4	FDATE	Valid from date (inverted: 99999999 - YYYYMMDD)	nvarchar	8	0
18	T831A	FI-SL Master data text	5	FDATE	Valid from date (inverted: 99999999 - YYYYMMDD)	nvarchar	8	0
19	T831B	FI-SL Master Record Table	5	FDATE	Valid from date (inverted: 99999999 - YYYYMMDD)	nvarchar	8	0
20	T831D	FI-SL Master data text	5	FDATE	Valid from date (inverted: 99999999 - YYYYMMDD)	nvarchar	8	0
21	T884H	Historical currency translation	7	FDATE	Delimitation date	nvarchar	8	0
TOPBusiness Navigator
22	BMTNODE01	Structure repository for process model objects: Node table	31	FDATE	Created on	nvarchar	8	0
23	DFTNODE01	Structure repository for process model objects: Node table	31	FDATE	Created on	nvarchar	8	0
TOPCanada
24	T5KSN	ROE Serial Number	10	FDATE	Date of first day worked	nvarchar	8	0
TOPCollectionsDisbursements
25	DIMACOPAST	Reversal of Contracts in CO-PA	4	FDATE	Posting Date in the Document	nvarchar	8	0
TOPContract Accounts Receivable and Payable
26	DFKKCFCSLOCKS	FI-CA Locks	11	FDATE	Lock valid from	nvarchar	8	0
27	DFKKLOCKS	FI-CA: Business Locks	6	FDATE	Lock valid from	nvarchar	8	0
28	DFKKLOCKSH	Business Lock Histories	7	FDATE	Lock valid from	nvarchar	8	0
29	DFKKOPL	Locks for Open Items (Change Document Interface)	7	FDATE	Lock valid from	nvarchar	8	0
30	DFKKORDERLOCKS	Requests: Processing Locks	7	FDATE	Lock valid from	nvarchar	8	0
31	DFKKORDERLOCKS_S	Request Templates: Processing Locks	7	FDATE	Lock valid from	nvarchar	8	0
32	DFKKPNBKA	Prenotification data (latest)	22	FDATE	Prenotification Valid-From Date	nvarchar	8	0
33	DFKKPNBKH	Prenotification data (history)	22	FDATE	Prenotification Valid-From Date	nvarchar	8	0
34	DFKKURE	Update Run: Defective Data Records	21	FDATE	Valid-From Date of Processing Lock	nvarchar	8	0
35	DFKK_IPL_CTRL	Control Entries for Installment Plan Key Date Recording	4	FDATE	Installment Due Dates Beginning From	nvarchar	8	0
TOPCross-System Tools
36	MCSTATLIST	Multiple Client Analysis: Status List	11	FDATE	Date	nvarchar	8	0
TOPCustomizing Tools Techniques
37	TCTM_ATTR	Table of Attributes for Context Management	5	FDATE	Creation Date	nvarchar	8	0
38	TCTM_COTY	Central Context Management Context Object Types	8	FDATE	Creation Date	nvarchar	8	0
TOPDenmark
39	T5MY0	HR-DK: Year-End Activities for PBS	6	FDATE	Date of Closing Year-End Activities for PBS	nvarchar	8	0
TOPDocument Management Framework
40	KDS_NODE	Node Table for General Structure Storage	31	FDATE	Created on	nvarchar	8	0
TOPDocument Management Services
41	SDOKNODE	SDOK: Node table for general structure repository	31	FDATE	Created on	nvarchar	8	0
TOPeCATT Extended Computer Aided Test Tool
42	ECATT_VER	Table for Storing Versions of eCATTs	8	FDATE	Created on	nvarchar	8	0
43	ECBR_NODE	SHI3 ECBR/ECBO - Node Table for eCATT Browser Nodes	31	FDATE	Created on	nvarchar	8	0
44	ECRP_DEF	OBSOLETE -	3	FDATE	Created on	nvarchar	8	0
45	ECSD_DEF	Table for Defining System Data Containers	3	FDATE	Created on	nvarchar	8	0
46	ECSP_DEF	Table for eCATT Start Profiles (eCATT Core)	3	FDATE	Created on	nvarchar	8	0
47	ECTC_ATTACH	External Documents linked to eCATT Objects	12	FDATE	Created on	nvarchar	8	0
48	ECTC_VER	Table for Storing Versions of Test Configurations	8	FDATE	Created on	nvarchar	8	0
49	ECTD_VER	Table for Storing Versions of Test Data Containers	8	FDATE	Created on	nvarchar	8	0
50	ECTP_JOB_LIST	Foreground Scheduler: List of test executions	10	FDATE	Test Proxy: Finish date of job entry for execution	nvarchar	8	0
51	ECVO_VER	eCATT Table for Versions of Validation Objects	8	FDATE	Created on	nvarchar	8	0
TOPEnvironment, Health and Safety
52	T7EHS00_FKATALOG	Administration Data EH&S Question Catalog	13	FDATE	Created On	nvarchar	8	0
53	T7EHS00_QUEST	Questionnaire Definition	10	FDATE	Created On	nvarchar	8	0
54	T7EHS00_QUESTQ	Individual Questions in Questionnaire	15	FDATE	Created On	nvarchar	8	0
TOPGRC Access Control Plug-In
55	/VIRSA/ZFFARCH	Archival Data File Information	3	FDATE	Date in user master record	nvarchar	8	0
TOPHierarchy Storage
56	TARCH01	Node Table for General Structure Storage	31	FDATE	Created on	nvarchar	8	0
57	TNODE01	Node Table for General Structure Storage	31	FDATE	Created on	nvarchar	8	0
58	TNODEH	List of valid node types	4	FDATE	Created on	nvarchar	8	0
59	TRTYPEH	List of valid link types	11	FDATE	Created on	nvarchar	8	0
60	TTREE	Definition table for structures	15	FDATE	Created on	nvarchar	8	0
61	TTREETYPE	List of valid structure types	10	FDATE	Created on	nvarchar	8	0
62	TTREV	Versions: Header Data	14	FDATE	Created on	nvarchar	8	0
63	TTREV_NODE	Hierarchy Tool: Structure Versioning Node Table	27	FDATE	Created on	nvarchar	8	0
64	TTREV_VLNK	Hierarchy Tool: Link Original/Version	4	FDATE	Created on	nvarchar	8	0
TOPImplementation Guide
65	CUS_ATRVSE	Attribute Variant Sequence	7	FDATE	System Date	nvarchar	8	0
66	CUS_IMGACH	IMG Activities	7	FDATE	Created on	nvarchar	8	0
67	DSYAH	Structures: Header Data	8	FDATE	Date documentation was created	nvarchar	8	0
68	DSYAV	Structures: Directory of Views on Books	6	FDATE	Date documentation was created	nvarchar	8	0
69	DSYOH	Hypertext: Version Management Structure	9	FDATE	Date created	nvarchar	8	0
70	DSYOI	DSYS Grouping - Aspect, Status, Version, Processed by	8	FDATE	Date created	nvarchar	8	0
71	EXCEPT1	IMG Activity-Specific BC Set Error Exception Table	19	FDATE	Date	nvarchar	8	0
72	EXCEPT2	Object-Specific BC Set Error Case Exception Table	16	FDATE	Date	nvarchar	8	0
73	TCUSP	Customizing: Implementation project profile	12	FDATE	Date created	nvarchar	8	0
74	TCUSP40	Customizing: Implementation project profile	12	FDATE	Date created	nvarchar	8	0
75	TDOKUIMG	Node Table for General Structure Storage	31	FDATE	Created on	nvarchar	8	0
76	TNODEIMG	Node table for the new IMG	31	FDATE	Created on	nvarchar	8	0
77	TNODEPR	Node Table for General Structure Storage	31	FDATE	Created on	nvarchar	8	0
78	TNODERELN	Node Table for General Structure Storage	31	FDATE	Created on	nvarchar	8	0
79	TPRCLASS	Project Management Project Classes	3	FDATE	Date created	nvarchar	8	0
80	TPROJECT	SPROJECT: Project Table	22	FDATE	Date created	nvarchar	8	0
81	TSTAHPR	Status: Project Status Information	18	FDATE	Date created	nvarchar	8	0
82	TSTAHTW	TWB Status Management: Status Information	22	FDATE	Date created	nvarchar	8	0
83	TSTATH	Status fields for an activity in a project	22	FDATE	Date created	nvarchar	8	0
84	TSTATH4	Status information for Test Workbench	10	FDATE	Date created	nvarchar	8	0
85	TVARH	Header entries for screen variants	6	FDATE	Date documentation was created	nvarchar	8	0
TOPInvoicing
86	EABPJVL_CORR	Correspondence Print: Bud. Bill. Plan Header and YAP Info.	25	FDATE	Lock valid from	nvarchar	8	0
87	EJVL	Yearly Advance Payment	22	FDATE	Lock valid from	nvarchar	8	0
TOPJoint Venture und Production Sharing Accounting
88	T8JG	Valid Investment Group	5	FDATE	Valid from date (inverted: 99999999 - YYYYMMDD)	nvarchar	8	0
TOPKnowledge Warehouse
89	CUSTNODE	Node Table for General Structure Storage	31	FDATE	Created on	nvarchar	8	0
90	IWB0NODE	Node Table for General Structure Storage	31	FDATE	Created on	nvarchar	8	0
91	IWB1NODE	Node Table for General Structure Storage	31	FDATE	Created on	nvarchar	8	0
92	IWB2NODE	Node Table for General Structure Storage	31	FDATE	Created on	nvarchar	8	0
93	IWB7NODE	Node Table for General Structure Storage	31	FDATE	Created on	nvarchar	8	0
94	KWN_NODE	Node Table for General Structure Storage	31	FDATE	Created on	nvarchar	8	0
95	TXML_NODE	XML: table of nodes	31	FDATE	Created on	nvarchar	8	0
TOPPackage Tools
96	APAUSED	Basis Objects Used in Other Packages	12	FDATE	Date created	nvarchar	8	0
97	APAUSED_TEST	Basis Objects Used in Other Packages	12	FDATE	Date created	nvarchar	8	0
TOPPerformance Assessment Workbench
98	KWPWNODE	Node Table for General Structure Storage	31	FDATE	Created on	nvarchar	8	0
TOPProduct Cost Planning
99	TCWB_TESTDATA	Testdaten	13	FDATE	Erstellungsdatum	nvarchar	8	0
100	TDATASET	CATT-Daten	14	FDATE	Erstellungsdatum	nvarchar	8	0
TOPProfitability Analysis
101	TKENODE01	CO-PA: Node Table for General Structure Repository	31	FDATE	Created on	nvarchar	8	0
TOPSAPscript
102	TFORM01	Node Table for SAPscript Form Tree	31	FDATE	Created on	nvarchar	8	0
TOPService
103	DVS1NODE	Node Table for General Structure Storage	31	FDATE	Created on	nvarchar	8	0
TOPSession Manager
104	BMENTTREE	Definition Table for Structures	12	FDATE	Created on	nvarchar	8	0
105	TMENU01	Node Table for General Structure Storage	31	FDATE	Created on	nvarchar	8	0
106	TMENUBK01	Node Table for General Structure Storage	31	FDATE	Created on	nvarchar	8	0
TOPSwitch Framework Tools
107	SFW_BFC_CTC	Link Business Function - Customer Test Catalog	5	FDATE	Created on	nvarchar	8	0
108	SFW_BFC_CUSTTC	Customer's Test Catalog of Business Functions	5	FDATE	Created on	nvarchar	8	0
TOPTest Organizer
109	TNODE02	Test Organizer, Node Table	31	FDATE	Created on	nvarchar	8	0
110	TNODE02A	Test Organizer, Test Catalog, Plan, Package Attributes	25	FDATE	Date of last status analysis	nvarchar	8	0
111	TNODE02_A	Test case attributes: Management	3	FDATE	Created on	nvarchar	8	0
TOPUser Administration
112	SPERS_REG	Personalization registration table	19	FDATE	Date	nvarchar	8	0
TOPWorkbench Utilities
113	RLB_DB_TR	Reuse Library: Structure Repository: Nodes	31	FDATE	Created on	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

113 columns | ERP 6.0 | FDATE