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	BSEG	345	Accounting Document Segment
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
9	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
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	OPCH	386	A/P Invoice
7	INV1	265	A/R Invoice - Rows
8	JDT1	124	Journal Entry - Rows
9	OPOR	386	Purchase Order
10	OVTG	52	Tax Definition

B1 8.8: Top 10 requests

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

18 COLUMNS | 2 INDEXES | ERP 6.0 | ECTP_JOB_LIST TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Basis Components :: Test Workbench :: Use Subcomponents See SAP Note 1156876 :: eCATT Extended Computer Aided Test Tool
1	ERP EHP7	6.0	ECTP_JOB_LIST	18	2	Foreground Scheduler: List of test executions	eCATT Extended Computer Aided Test Tool

TOP ERP 6.0 | ECTP_JOB_LIST COLUMNS

	Column	Field	Description	SQL Type	Length	Decimals	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
	1	JOBGUID	Foreground Scheduler: GUID for a Job	nvarchar	32	0	CHAR	(N' ')	No		ETTP_JOBGUID	Allow NULL?
	2	JOBNAME	Test Proxy: Name for execution from TWB job	nvarchar	45	0	CHAR	(N' ')	Yes		ETTP_JOBNAME	Allow NULL?
	3	JOBSTATUS	Test Proxy: Status of Execution (Sched., Active, Finished)	char	1	0	CHAR	(N' ')	Yes		ETTP_JOBSTATUS	Allow NULL?
	4	USERNAME	Test Proxy: User Name	nvarchar	12	0	CHAR	(N' ')	Yes		ETTP_USERNAME	Allow NULL?
	5	PROXYTYPE	Foreground Scheduler: Type (ECATT,...)	nvarchar	10	0	CHAR	(N' ')	Yes		ETTP_TESTPROXY_TYPE	Allow NULL?
	6	TPGUID	Scheduler: GUID of a Frontend	nvarchar	32	0	CHAR	(N' ')	Yes		ETTP_TESTPROXY_GUID	Allow NULL?
	7	CUSER	Test Proxy: Creation user (remote system) of job entry	nvarchar	12	0	CHAR	(N' ')	Yes		ETTP_CRUSER	Allow NULL?
	8	CDATE	Test Proxy: Creation date of job entry for execution	nvarchar	8	0	DATS	(N'00000000')	Yes		ETTP_CRDATE	Allow NULL?
	9	CTIME	Test Proxy: Creation time of job entry for execution	nvarchar	6	0	TIMS	(N'000000')	Yes		ETTP_CRTIME	Allow NULL?
	10	FDATE	Test Proxy: Finish date of job entry for execution	nvarchar	8	0	DATS	(N'00000000')	Yes		ETTP_FIDATE	Allow NULL?
	11	FTIME	Test Proxy: Finish time of job entry for execution	nvarchar	6	0	TIMS	(N'000000')	Yes		ETTP_FITIME	Allow NULL?
	12	LUSER	Test Proxy: Last changed by User	nvarchar	12	0	CHAR	(N' ')	Yes		ETTP_LCUSER	Allow NULL?
	13	LDATE	Test Proxy: Last Changed On Date	nvarchar	8	0	DATS	(N'00000000')	Yes		ETTP_LCDATE	Allow NULL?
	14	LTIME	Test Proxy: Time of Last Change	nvarchar	6	0	TIMS	(N'000000')	Yes		ETTP_LCTIME	Allow NULL?
	15	ECATTLOGID	Test Proxy: eCATT Log ID (original: NUMC-10)	nvarchar	10	0	CHAR	(N' ')	Yes		ETTP_ECATTLOGID	Allow NULL?
	16	ABORTMSG	Test Proxy: Abort Message	nvarchar	100	0	CHAR	(N' ')	Yes		ETTP_ABORT_MSG	Allow NULL?
	17	JOBCOUNT	Identification of a Batch Job	nvarchar	8	0	CHAR	(N' ')	Yes		ECTP_BTC_JOBCNT	Allow NULL?
	18	JOBSTATUS_TEXT	Job Status Text	nvarchar	60	0	CHAR	(N' ')	Yes		ETTP_JOBSTATUS_TEXT	Allow NULL?

TOP ERP 6.0 | ECTP_JOB_LIST INDEXES

Name	Primary	Unique	Type	Columns
ECTP_JOB_LIST~0	Yes	Yes	CLUSTERED	JOBGUID
ECTP_JOB_LIST~ID1	No	No	NONCLUSTERED	PROXYTYPE, USERNAME