SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema: Module: Table: Column: Search^beta

SAP TABLESv1

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

	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

B1 9.2: Top 10 requests

	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	OVTG	52	Tax Definition
9	OPOR	386	Purchase Order
10	JDT1	124	Journal Entry - Rows

B1 8.8: Top 10 requests

	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

19 COLUMNS | 1 INDEXES | ERP 6.0 | INFCFGTHRE TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Basis Components :: Use Subcomponents :: Monitoring :: Database Monitors
1	ERP EHP7	6.0	INFCFGTHRE	19	1	'Thresholds' for Informix/OS configuration check program	Database Monitors

TOP ERP 6.0 | INFCFGTHRE COLUMNS

	Column	Field	Description	SQL Type	Length	Decimals	Relation	Default Value	Constraints	SQL Create Statement
	1	SAPRELEASE	Release of SAP System	nvarchar	4	0				Allow NULL?
	2	INFRELEASE	Full qualified Informix release ('7.20.EV3P6') or '*'	nvarchar	10	0				Allow NULL?
	3	OSTYPE	OS type without release no. (or '*'): HP-UX, Windows NT, ...	nvarchar	10	0				Allow NULL?
	4	OSRELEASE	Full qualified operating system rel. number ('10.10') or '*'	nvarchar	10	0				Allow NULL?
	5	MODTIME	Modification (or inserting) timestamp (YYYYMMDDHHMMSS)	nvarchar	14	0				Allow NULL?
	6	MODUSER	Normal SAP User or Special User '#SAP#'	nvarchar	12	0				Allow NULL?
	7	PARAM	Informix/OS parameter name (to check): LTXHWM, ...	nvarchar	50	0				Allow NULL?
	8	CKDETAILNO	(Serial) detail number of logical check (LTXHWM: 1 & 2)	smallint	5	0
	9	PERFORMANC	Performance check or not ('Y'/'N') ?	char	1	0				Allow NULL?
	10	OCLASS	Origin class of parameter: 'ONCONFIG','OS',...	nvarchar	10	0				Allow NULL?
	11	SCLASS	System state class of parameter: 'DBDOWN', 'DBUP' or 'R3UP'	nvarchar	10	0				Allow NULL?
	12	ACTIV	Is check activated or not ('Y'/'N') ?	char	1	0				Allow NULL?
	13	SEVERITY	Check severity: 'A'...abort, 'E'...error, 'W'...warning	char	1	0				Allow NULL?
	14	CHECKOP	Check operator: '=','!=','<','>','<=','>=' or 'D' -> dynamic	nvarchar	2	0				Allow NULL?
	15	CHECKVAL	Absolute check value or 'D' (-> dynamic check)	nvarchar	50	0				Allow NULL?
	16	BYTEUNIT	Byte unit of check value: T...tera, G...giga, M...mega, ...	char	1	0				Allow NULL?
	17	CHCKMODIFY	Is modification for customer allowed ('Y'/'N') ?	char	1	0				Allow NULL?
	18	MODCOMMENT	Comment for customer modification	nvarchar	80	0				Allow NULL?
	19	REACTION	Triggered reaction if check 'becomes true'	nvarchar	50	0				Allow NULL?

TOP ERP 6.0 | INFCFGTHRE INDEXES

Name	Primary	Unique	Type	Columns
INFCFGTHRE~0	Yes	Yes	CLUSTERED	PERFORMANC, CKDETAILNO, PARAM, MODUSER, MODTIME, OSRELEASE, OSTYPE, INFRELEASE, SAPRELEASE