	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	/ISDFPS/CHVW_E	34	External Batch Where-Used List
7	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	BSEG	345	Accounting Document Segment
10	FMARCPAR	4	Parallelization of FMARC_BATCH

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	OJDT	100	Journal Entry
6	INV1	265	A/R Invoice - Rows
7	OPCH	386	A/P Invoice
8	JDT1	124	Journal Entry - Rows
9	OPOR	386	Purchase Order
10	OVTG	52	Tax Definition

	Table	Columns	Description
1	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OIVL	77	Whse Journal
5	OVPM	154	Outgoing Payments
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OINM	101	Whse Journal
10	OSRN	20	Serial Numbers Master Data

109 columns | ERP 6.0 | IS_ACTIVE

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/IWFND/C_CFIWAT	Customizing Table "SAP NetWeaver Gateway Activation"	2	IS_ACTIVE	Indicates that SAP NetWeaver Gateway is Active	nvarchar	1	0
2	/IWFND/C_COOBGR	Customizing Table "Object Group"	3	IS_ACTIVE	Indicates that the GSDO Group is Active	nvarchar	1	0
3	/IWFND/I_MED_AEN	annotated entities characteristic	2	IS_ACTIVE	Active Flag for Model	nvarchar	1	0
4	/IWFND/I_MED_ALE	Annotated Language-Dependent Entities Characteristics	2	IS_ACTIVE	Active Flag for Model	nvarchar	1	0
5	/IWFND/I_MED_ALK	annotated entity language keys	2	IS_ACTIVE	Active Flag for Model	nvarchar	1	0
6	/IWFND/I_MED_CDK	Language-Independent Table for Codelist	2	IS_ACTIVE	Active Flag for Model	nvarchar	1	0
7	/IWFND/I_MED_CDL	Language-Dependent Table for Codelist	2	IS_ACTIVE	Active Flag for Model	nvarchar	1	0
8	/IWFND/I_MED_EMM	External Model Interface - Mapping to identifier	2	IS_ACTIVE	Active Flag for Model	nvarchar	1	0
9	/IWFND/I_MED_EPC	table to manage internal relationships such as parent-child	2	IS_ACTIVE	Active Flag for Model	nvarchar	1	0
10	/IWFND/I_MED_ESM	External Service Interface - Mapping to identifier	2	IS_ACTIVE	Active Flag for Model	nvarchar	1	0
11	/IWFND/I_MED_INH	object model inheritance table	2	IS_ACTIVE	Active Flag for Model	nvarchar	1	0
12	/IWFND/I_MED_MEX	maps an external identifier to the mapping	2	IS_ACTIVE	Active Flag for Model	nvarchar	1	0
13	/IWFND/I_MED_MHD	mapping header table	2	IS_ACTIVE	Active Flag for Model	nvarchar	1	0
14	/IWFND/I_MED_MIN	Model Information	2	IS_ACTIVE	Active Flag for Model	nvarchar	1	0
15	/IWFND/I_MED_MPR	mapping of model properties	2	IS_ACTIVE	Active Flag for Model	nvarchar	1	0
16	/IWFND/I_MED_NOD	node entity table for meta model	2	IS_ACTIVE	Active Flag for Model	nvarchar	1	0
17	/IWFND/I_MED_OHD	Meta Model Header - Containing management information	2	IS_ACTIVE	Active Flag for Model	nvarchar	1	0
18	/IWFND/I_MED_OHT	Model Header Texts	2	IS_ACTIVE	Active Flag for Model	nvarchar	1	0
19	/IWFND/I_MED_OP	operation entity for meta model	2	IS_ACTIVE	Active Flag for Model	nvarchar	1	0
20	/IWFND/I_MED_PRP	property entity for meta model	2	IS_ACTIVE	Active Flag for Model	nvarchar	1	0
21	/IWFND/I_MED_REF	reference entity for meta model	2	IS_ACTIVE	Active Flag for Model	nvarchar	1	0
22	/IWFND/I_MED_SIN	Service Information	2	IS_ACTIVE	Active Flag for Model	nvarchar	1	0
23	/IWFND/I_MED_SRG	Service Group for GSDO	2	IS_ACTIVE	Active Flag for Model	nvarchar	1	0
24	/IWFND/I_MED_SRH	Service Group Header	2	IS_ACTIVE	Active Flag for Model	nvarchar	1	0
25	/IWFND/I_MED_SRK	Service Key Words / Tags	2	IS_ACTIVE	Active Flag for Model	nvarchar	1	0
26	/IWFND/I_MED_SRS	General Service Groups	2	IS_ACTIVE	Active Flag for Model	nvarchar	1	0
27	/IWFND/I_MED_SRT	Service Group Description	2	IS_ACTIVE	Active Flag for Model	nvarchar	1	0
28	/IWFND/I_MED_TXK	Language-Independent Table for entity texts	2	IS_ACTIVE	Active Flag for Model	nvarchar	1	0
29	/IWFND/I_MED_TXR	Table for Text references	2	IS_ACTIVE	Active Flag for Model	nvarchar	1	0
30	/IWFND/I_MED_TXT	Language-Dependent Table for Property Texts	2	IS_ACTIVE	Active Flag for Model	nvarchar	1	0
31	/IWFND/I_MED_VEH	versionable entity headtable for meta model	2	IS_ACTIVE	Active Flag for Model	nvarchar	1	0
32	/IWFND/I_RMI_MTF	Model Entity Transformation Assignment	2	IS_ACTIVE	Active Flag for Model	nvarchar	1	0
33	/OTTM/OCR_T_OCIC	Input Channels for OCR	3	IS_ACTIVE	Indicator Active (X) / Deactive ( )	nvarchar	1	0
34	/SAPSRM/C_UM_S01	Synchronization Check For BP<->US (Customizing)	3	IS_ACTIVE	Activate Synchronization Check for Attribute	nvarchar	1	0
35	/XFT/DDSMIGTC01	Customizing: Migration Type	3	IS_ACTIVE	Boolean (Constants: /XFT/IF_CONSTANT)	nvarchar	1	0
36	/XFT/SRMCREC50	Cust.: Status Profile	3	IS_ACTIVE	Active [Yes = /XFT/IF_CONSTANT=>TRUE, Otherwise NO]	nvarchar	1	0
37	/XFT/SRMPROFTC0	Smart Views Type (Customizing)	3	IS_ACTIVE	Active [Yes = /XFT/IF_CONSTANT=>TRUE, Otherwise NO]	nvarchar	1	0
38	/XFT/SRMPROFTC1	Smart Views Space (Customizing)	3	IS_ACTIVE	Active [Yes = /XFT/IF_CONSTANT=>TRUE, Otherwise NO]	nvarchar	1	0
39	CNVLTHCM_CWBPACK	LT HCM: Assigned CWB Packages	5	IS_ACTIVE	Conversion Active	nvarchar	1	0
40	CNVLTHCM_TABGRP	LT HCM: Table Groups	4	IS_ACTIVE	Group of Tables to be Included in Transfer	nvarchar	1	0
41	CNV_MBT_ME_MAPPS	Table for mappings of the Mapping Engine	4	IS_ACTIVE	Flag to indicate whether an entity is active	nvarchar	1	0
42	CTS_TPROPS	Properties of all CTS Plug-In related stuff	4	IS_ACTIVE	General Flag	nvarchar	1	0
43	DMC_IU_PLIST	MWB Upgrade: Object List for an Integrated Upgrade	3	IS_ACTIVE	MWB Upgrade: Status IS_ACTIVE	nvarchar	1	0
44	DMC_MT_HEADER	DMC: Header Record of a Mass Data Transfer	3	IS_ACTIVE	Boolean Variable (X=True, -=False, Space=Unknown)	nvarchar	1	0
45	ECPAO_ERPTMPL	Employee Central Template	5	IS_ACTIVE	Is Active	nvarchar	1	0
46	ECPAO_MNGR_TYPE	Manager Type	5	IS_ACTIVE	Relationship Type Is Active	nvarchar	1	0
47	FBICRC_C_CONF	ICR: Customizing Table for Assign Confirm Dialog	4	IS_ACTIVE	Confirmation Required When Assigning Data Records	nvarchar	1	0
48	GRACROLEACT	Role Action Table	5	IS_ACTIVE	Indicator	nvarchar	1	0
49	IUUC_ODQ_TABLES	tables for processing as ODQ provider	5	IS_ACTIVE	Boolean Variable (X=True, -=False, Space=Unknown)	nvarchar	1	0
50	N1CORDTPLWARNING	CORD: Clinical Order Template User Warning Checked	6	IS_ACTIVE	CORD: Clinical Order Template Active Indicator	nvarchar	1	0
51	N1SE_INDEX_ATTR	ISHMED: Search Index Attributes	10	IS_ACTIVE	Single-Character Indicator	nvarchar	1	0
52	OA2C_SAML2_ENT	SAML2 Entity Table for OAuth 2.0 Client	3	IS_ACTIVE	SAML2 Truth Value	nvarchar	1	0
53	RSBPCB_EMAIL	BPC: BPF Email Template	3	IS_ACTIVE	BPC: BPF Email Template Status	nvarchar	1	0
54	RSBPCW_EMAIL	BPC Work Status - Email Setting Table	3	IS_ACTIVE	BPC: Work Status Email Template Is Active	nvarchar	1	0
55	TEXC_COEX_ACTIVE	Activation of Commodity Price Exposures	2	IS_ACTIVE	Activation of Commodity Price Exposures	nvarchar	1	0
56	TILM_STOR_MON_A	ILM DB Store: Monitoring Agent	7	IS_ACTIVE	Boolean Variable (X=True, -=False, Space=Unknown)	nvarchar	1	0
57	TIVYCSETTLPARAM	CAM Settlement Parameters	3	IS_ACTIVE	Parameter Is Active for CAM	nvarchar	1	0
58	VMP_PLSCP_CUST	Table to activate/deactivate the Planning scope scenarios	3	IS_ACTIVE	Planning Scenario: Active/ Inactive	nvarchar	1	0
59	/BOBF/TRA_PI_ACT	Plugin Restrictions of the Transaction Manager	2	IS_ACTIVE	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')	nvarchar	1	0
TOPAccounting Engine
60	/EACC/TBTA4000	Configuration Status of the Generic BTA per Data Basis	4	IS_ACTIVE	Boolean Type for e-Accounting	nvarchar	1	0
61	/EACC/TBTA4001	Activation Status of Generated BTA w. Ref. to Assd BTA Cats	5	IS_ACTIVE	Boolean Type for e-Accounting	nvarchar	1	0
TOPArchive Development Kit
62	ARCH_DAS	Configuration of the Data Archiving Service	3	IS_ACTIVE	Active XML DAS Instance	nvarchar	1	0
TOPAuthentication and SSO
63	SAML2_ENTITY	SAML2 Entity Table	7	IS_ACTIVE	SAML2 Truth Value	nvarchar	1	0
64	SAML2_SESS_EXT	List: External Participants for a SAML Session	4	IS_ACTIVE	SAML2 Truth Value	nvarchar	1	0
TOPAuthorizations and Access Control Context
65	/PLMB/AUTH_CLASS	Customizing classes of factory class	5	IS_ACTIVE	Change Pointers of Controller Class Processes	nvarchar	1	0
66	HRP7600	DB Table for Infotype 7600	19	IS_ACTIVE	Context Activation Status	nvarchar	1	0
TOPBusiness Framework Architecture
67	TERPSOFTSWITCHES	Soft Switches for PDF-based Forms	3	IS_ACTIVE	Flag: object group is active	nvarchar	1	0
TOPBusiness Partner
68	CSXO_CNS_TYPE	Obsolete	2	IS_ACTIVE	Boolean Value ('X' = True ' ' = False)	nvarchar	1	0
TOPClinical System
69	N1CORDTPL	CORD: Clinical Order Templates	4	IS_ACTIVE	CORD: Clinical Order Template Active Indicator	nvarchar	1	0
TOPCross-Application Topics
70	/SPE/CTRL_FUNCM	Switch matrix for the SPE control functions	4	IS_ACTIVE	Activity of the control function	nvarchar	1	0
TOPFinancials Basis
71	ACCLOGOBJCAT02	Activation Status of a Logistical Object Type	5	IS_ACTIVE	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')	nvarchar	1	0
TOPForce Element
72	/ISDFPS/CSTASUC	Obsolete: New Table /ISDFPS/STA_SUC	12	IS_ACTIVE	General Flag	nvarchar	1	0
73	/ISDFPS/CSTASUCC	Obsolete: New Table /ISDFPS/STA_UCC	13	IS_ACTIVE	General Flag	nvarchar	1	0
TOPGateway Business Workflow enablement
74	/IWWRK/I_WF_PACT	Activation Status of Workflow Task Providers	2	IS_ACTIVE	Workflow: is provider active?	nvarchar	1	0
TOPGeographical Information System
75	GEO_CONTEXT_APPL	Application Specific Geo Context	3	IS_ACTIVE	Checkbox	nvarchar	1	0
TOPInventory Accounting
76	UAINVT4000	Configuration Status of Inventory/WIP for Accounting Systems	4	IS_ACTIVE	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')	nvarchar	1	0
TOPLocal Event Infrastructure
77	SLEI_LNKG_C	LEI Linkages - Client specific	11	IS_ACTIVE	Checkbox	nvarchar	1	0
TOPLocalization
78	J_3RFTAX_FRMTS	Electronic Tax Format Versions	3	IS_ACTIVE	Electronic Format Version Active	nvarchar	1	0
TOPMaintenance Orders
79	/MRSS/D_SQP_EHDR	Employee Profile : Header Attributes	3	IS_ACTIVE	Active Flag	nvarchar	1	0
80	/MRSS/D_SQP_ESTR	Employee Profile - Structured Qualifications	4	IS_ACTIVE	Active Flag	nvarchar	1	0
81	/MRSS/D_SQP_EUST	Employee Profile : Unstructured Qualifications	4	IS_ACTIVE	Active Flag	nvarchar	1	0
82	/MRSS/D_SQP_HDTX	Profile/structured qualifications: text table	3	IS_ACTIVE	Active Flag	nvarchar	1	0
TOPMetadata Repository
83	RSOSC_SW_REPL	Switch replicated into BI (including Status)	3	IS_ACTIVE	Flag: Switch / Business Function is active	nvarchar	1	0
TOPOrganizational Flexibility
84	/ISDFPS/STA_SUC	Follow-Up Action After Status Change	5	IS_ACTIVE	Check Active	nvarchar	1	0
85	/ISDFPS/STA_SUCC	Customer Table for Follow-Up Action After Status Change	6	IS_ACTIVE	Check Active	nvarchar	1	0
TOPPosition Budgeting and Control
86	T77HRFPM_PCS_03	Definition of Consolidation Rules	6	IS_ACTIVE	Enh. PCS Handling: Field is Active	nvarchar	1	0
87	T77HRFPM_PCS_04	Activation of Consolidation Rules	5	IS_ACTIVE	Enh. PCS Handling: Field is Active	nvarchar	1	0
TOPProcess Controls
88	GRPC_SCOPIN_FREQ	Scoping Freqency Configuration	3	IS_ACTIVE	GRPC Active Flag	nvarchar	1	0
TOPProcess Monitoring Infrastructure
89	SSPIADMEV	PMI: Configuration for Metrics (Events)	5	IS_ACTIVE	PMI Flag: Metric Active/Inactive	tinyint	3	0
90	SSPIADMEVHISTORY	History of Metrics Configuration	10	IS_ACTIVE	PMI Flag: Metric Active/Inactive	tinyint	3	0
91	SSPISTCONF	Configuration for Performance Data Analysis	11	IS_ACTIVE	SPI Statistics: Are the statistics set to active?	tinyint	3	0
TOPQuery Management
92	/PLMPCV/C_QASYNC	Customizing for asynchronous and parallel query processing	3	IS_ACTIVE	Active Query Processing Profile	nvarchar	1	0
TOPSales-Based Rent and Settlement
93	TIVSRSETTLPARAM	Settlement Parameters	3	IS_ACTIVE	Is Parameter Active	nvarchar	1	0
TOPSAP Business Workflow
94	SWF_TRC_HEAD	Trace: Catalog	4	IS_ACTIVE	Trace active	nvarchar	1	0
TOPService Charge Settlement
95	TIVSCSETTLPARAM	Settlement Parameters	3	IS_ACTIVE	Parameter Is Active for Service Charge Settlement	nvarchar	1	0
TOPTransaction Manager
96	TCORC_BUSGRP	Treasury correspondence: Business group definition	3	IS_ACTIVE	Business Partner Group Activation	nvarchar	1	0
TOPTransport Organizer
97	CTS_IMEXP_LOCK	Contains all locks for transport of collections	8	IS_ACTIVE	Boolean Variable (X=True, -=False, Space=Unknown)	nvarchar	1	0
TOPVisual Business
98	VBCD_CNTXT	Model context	10	IS_ACTIVE	Active Flag	nvarchar	1	0
99	VBCD_DATA_OBJ	Data Objects	8	IS_ACTIVE	Active Flag	nvarchar	1	0
100	VBCD_MESSAGE_OBJ	Message Objects	8	IS_ACTIVE	Active Flag	nvarchar	1	0
101	VBCD_MODEL_OBJ	Main Visual Business Model XML Streams	7	IS_ACTIVE	Active Flag	nvarchar	1	0
102	VBCD_VISUAL_OBJ	Visual Objects	8	IS_ACTIVE	Active Flag	nvarchar	1	0
TOPWorkforce Management Application
103	WFATM_SR_ROT_TMP	TM Temp Table: Schedule Rule - Rotation	11	IS_ACTIVE	Flag (Active = 'X', Inactive = ' ')	nvarchar	1	0
104	WFA_AGT_ROT	Agent Rotation	4	IS_ACTIVE	Flag (Active = 'X', Inactive = ' ')	nvarchar	1	0
105	WFA_EMPERROT	Employee Work Rule Rotation	4	IS_ACTIVE	Flag (Active = 'X', Inactive = ' ')	nvarchar	1	0
106	WFA_SCHDL_EVT	Scheduled activites(meetings)	11	IS_ACTIVE	Flag (Active = 'X', Inactive = ' ')	nvarchar	1	0
TOPWorkforce Management Core
107	WFMCAS_AGT_ROT	Agent Rotation	4	IS_ACTIVE	Flag (Active = 'X', Inactive = ' ')	nvarchar	1	0
108	WFMCAS_SCHDL_EVT	Scheduled activites(meetings)	11	IS_ACTIVE	Flag (Active = 'X', Inactive = ' ')	nvarchar	1	0
109	WFMTM_SR_ROT_TMP	TM Temp Table: Schedule Rule - Rotation	11	IS_ACTIVE	Flag (Active = 'X', Inactive = ' ')	nvarchar	1	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

109 columns | ERP 6.0 | IS_ACTIVE