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	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

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	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

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	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

	Product	Version	Table	Columns	Indexes	Description	Module
Plant Maintenance :: Work Clearance Management
1	ERP EHP7	6.0	WCAAP	128	4	WCM: Application	Work Clearance Management

Column	Field	Description	SQL Type	Length	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	CLNT	(N'000')	No	T000	MANDT	Allow NULL?
2	WAPINR	Application	nvarchar	12	CHAR	(N' ')	No		WCEWAPINR	Allow NULL?
3	OBJNR	Object number	nvarchar	22	CHAR	(N' ')	Yes	ONR00	J_OBJNR	Allow NULL?
4	WAPITYP	Type of WCM Object	char	1	CHAR	(N' ')	Yes		WCETYP	Allow NULL?
5	WAPIUSE	Usage of WCM Object	nvarchar	3	CHAR	(N' ')	Yes	WCCY	WCEUSAGE	Allow NULL?
6	STXT	Descriptive Short Text	nvarchar	40	CHAR	(N' ')	Yes		WCESTXT	Allow NULL?
7	LFLG	Long Text Exists	char	1	CHAR	(N' ')	Yes		WCELTXTFLG	Allow NULL?
8	DELFLG	Delete	char	1	CHAR	(N' ')	Yes		WCEDELFLG	Allow NULL?
9	REQUALFLG	Requalification Text Exists	char	1	CHAR	(N' ')	Yes		WCEREQULTXTFLG	Allow NULL?
10	CATFLG1	Catalog Exists	char	1	CHAR	(N' ')	Yes		WCECATFLG	Allow NULL?
11	CATFLG2	Catalog Exists	char	1	CHAR	(N' ')	Yes		WCECATFLG	Allow NULL?
12	INGRP	Planner Group for Customer Service and Plant Maintenance	nvarchar	3	CHAR	(N' ')	Yes	T024I	INGRP	Allow NULL?
13	IWERK	Maintenance Planning Plant	nvarchar	4	CHAR	(N' ')	Yes	T399I	IWERK	Allow NULL?
14	WKCRTYP	Object types of the CIM resource	nvarchar	2	CHAR	(N' ')	Yes	CRID	CR_OBJTY	Allow NULL?
15	WKCRID	Object ID of the resource	nvarchar	8	NUMC	(N'00000000')	Yes	CRID	CR_OBJID	Allow NULL?
16	BEGRU	Technical object authorization group	nvarchar	4	CHAR	(N' ')	Yes	T370B	IAUTG	Allow NULL?
17	DATEFR	Valid-From Date for WCM Object	nvarchar	8	DATS	(N'00000000')	Yes		WCEDATEFR	Allow NULL?
18	TIMEFR	Valid-From Time for WCM Object	nvarchar	6	TIMS	(N'000000')	Yes		WCETIMEFR	Allow NULL?
19	DATETO	Valid-To Date for WCM Object	nvarchar	8	DATS	(N'00000000')	Yes		WCEDATETO	Allow NULL?
20	TIMETO	Valid-To Time for WCM Object	nvarchar	6	TIMS	(N'000000')	Yes		WCETIMETO	Allow NULL?
21	EXTPERIOD	Total Extension of Validity in Hours	int	10	INT4	((0))	No		WCEEXTTOTPERIOD	Allow NULL?
22	ANLZU	Overall Condition of Technical System	nvarchar	2	CHAR	(N' ')	Yes	WCCG	WCEANLZU	Allow NULL?
23	RCTIME	Recall Time	decimal	5	QUAN	((0))	Yes		WCERECTIME
24	RCUNIT	Unit of Recall Time	nvarchar	3	UNIT	(N' ')	Yes	T006	WCERECUNIT	Allow NULL?
25	PRIOK	Priority	char	1	CHAR	(N' ')	Yes	T356	PRIOK	Allow NULL?
26	TPLNR	Functional Location	nvarchar	30	CHAR	(N' ')	Yes	IFLOT	TPLNR	Allow NULL?
27	EQUNR	Equipment Number	nvarchar	18	CHAR	(N' ')	Yes	EQUI	EQUNR	Allow NULL?
28	LNKFLG	Object List Exists	char	1	CHAR	(N' ')	Yes		WCELNKFLG	Allow NULL?
29	TRAIN	Train	nvarchar	3	CHAR	(N' ')	Yes	WCCH	WCETRAIN	Allow NULL?
30	CRNAME	Created by	nvarchar	12	CHAR	(N' ')	Yes		WCECRNAME	Allow NULL?
31	CRDATE	Date on Which the Object Was Created	nvarchar	8	DATS	(N'00000000')	Yes		WCECRDATE	Allow NULL?
32	CRTIME	Time at Which Object was Created	nvarchar	6	TIMS	(N'000000')	Yes		WCECRTIME	Allow NULL?
33	CHNAME	Last Changed By	nvarchar	12	CHAR	(N' ')	Yes		WCECHNAME	Allow NULL?
34	CHDATE	Date on Which Object was Last Changed	nvarchar	8	DATS	(N'00000000')	Yes		WCECHDATE	Allow NULL?
35	CHTIME	Time at Which Object was Last Changed	nvarchar	6	TIMS	(N'000000')	Yes		WCECHTIME	Allow NULL?
36	PSPEL	Work Breakdown Structure Element (WBS Element)	nvarchar	8	NUMC	(N'00000000')	Yes	PRPS	PS_PSP_PNR	Allow NULL?
37	AUFNT	Number of superior network	nvarchar	12	CHAR	(N' ')	Yes	AUFK	CO_TEILNET	Allow NULL?
38	VORNR	Activity number replaced by sub-network	nvarchar	4	CHAR	(N' ')	Yes		CN_VORNRT	Allow NULL?
39	BDATE	Basic start date	nvarchar	8	DATS	(N'00000000')	Yes		CO_GSTRP	Allow NULL?
40	BTIME	Basic start time	nvarchar	6	TIMS	(N'000000')	Yes		CO_GSUZP	Allow NULL?
41	EDATE	Basic finish date	nvarchar	8	DATS	(N'00000000')	Yes		CO_GLTRP	Allow NULL?
42	ETIME	Basic finish (time)	nvarchar	6	TIMS	(N'000000')	Yes		CO_GLUZP	Allow NULL?
43	TSDATE	Scheduled start	nvarchar	8	DATS	(N'00000000')	Yes		CO_GSTRS	Allow NULL?
44	TSTIME	Scheduled Start (Time)	nvarchar	6	TIMS	(N'000000')	Yes		CO_GSUZS	Allow NULL?
45	TFDATE	Scheduled finish	nvarchar	8	DATS	(N'00000000')	Yes		CO_GLTRS	Allow NULL?
46	TFTIME	Scheduled finish time	nvarchar	6	TIMS	(N'000000')	Yes		CO_GLUZS	Allow NULL?
47	ESDATE	Date	nvarchar	8	DATS	(N'00000000')	Yes		WCEDATE	Allow NULL?
48	ESTIME	Time	nvarchar	6	TIMS	(N'000000')	Yes		WCETIME	Allow NULL?
49	EFDATE	Date	nvarchar	8	DATS	(N'00000000')	Yes		WCEDATE	Allow NULL?
50	EFTIME	Time	nvarchar	6	TIMS	(N'000000')	Yes		WCETIME	Allow NULL?
51	LSDATE	Date	nvarchar	8	DATS	(N'00000000')	Yes		WCEDATE	Allow NULL?
52	LSTIME	Time	nvarchar	6	TIMS	(N'000000')	Yes		WCETIME	Allow NULL?
53	LFDATE	Date	nvarchar	8	DATS	(N'00000000')	Yes		WCEDATE	Allow NULL?
54	LFTIME	Time	nvarchar	6	TIMS	(N'000000')	Yes		WCETIME	Allow NULL?
55	PSDATE	Date	nvarchar	8	DATS	(N'00000000')	Yes		WCEDATE	Allow NULL?
56	PSTIME	Time	nvarchar	6	TIMS	(N'000000')	Yes		WCETIME	Allow NULL?
57	PFDATE	Date	nvarchar	8	DATS	(N'00000000')	Yes		WCEDATE	Allow NULL?
58	PFTIME	Time	nvarchar	6	TIMS	(N'000000')	Yes		WCETIME	Allow NULL?
59	ASDATE	Actual start date	nvarchar	8	DATS	(N'00000000')	Yes		CO_GSTRI	Allow NULL?
60	ASTIME	Actual start time	nvarchar	6	TIMS	(N'000000')	Yes		CO_GSUZI	Allow NULL?
61	AFDATE	Actual finish date	nvarchar	8	DATS	(N'00000000')	Yes		CO_GLTRI	Allow NULL?
62	AFTIME	Actual End Date (Time)	nvarchar	6	TIMS	(N'000000')	Yes		WCEAFTIME	Allow NULL?
63	ETAPE	Revision Phase	nvarchar	20	CHAR	(N' ')	Yes	WCCF	WCEETAPE	Allow NULL?
64	DOCFLG	Linked to Document	char	1	CHAR	(N' ')	Yes		WCEDOCFLG	Allow NULL?
65	WAPISTSMA	Status Profile	nvarchar	8	CHAR	(N' ')	Yes	TJ20	J_STSMA	Allow NULL?
66	REFOBJ	Template (Object Number)	nvarchar	22	CHAR	(N' ')	Yes	*	WCEREFOBJ	Allow NULL?
67	REMARKFLG1	Remarks (Maintenance) Exist	char	1	CHAR	(N' ')	Yes		WCEREMARKFLG1	Allow NULL?
68	REMARKFLG2	Remarks (Operation) Exist	char	1	CHAR	(N' ')	Yes		WCEREMARKFLG2	Allow NULL?
69	IDATE	Issued	nvarchar	8	DATS	(N'00000000')	Yes		TTSE_ISDATE	Allow NULL?
70	ITIME	Issue Time	nvarchar	6	TIMS	(N'000000')	Yes		TTSE_ISTIME	Allow NULL?
71	RDATE	Received	nvarchar	8	DATS	(N'00000000')	Yes		TTSE_RCDATE	Allow NULL?
72	RTIME	Receive Time	nvarchar	6	TIMS	(N'000000')	Yes		TTSE_RCTIME	Allow NULL?
73	PDATES	Permit Start	nvarchar	8	DATS	(N'00000000')	Yes		TTSE_PEDATE	Allow NULL?
74	PTIMES	Permit Start Time	nvarchar	6	TIMS	(N'000000')	Yes		TTSE_PETIME	Allow NULL?
75	PDATEE	Permit End	nvarchar	8	DATS	(N'00000000')	Yes		TTSE_PEDATE_E	Allow NULL?
76	PTIMEE	Permit End Time	nvarchar	6	TIMS	(N'000000')	Yes		TTSE_PETIME_E	Allow NULL?
77	CDATE	Completed	nvarchar	8	DATS	(N'00000000')	Yes		TTSE_CMDATE	Allow NULL?
78	CTIME	Complete Time	nvarchar	6	TIMS	(N'000000')	Yes		TTSE_CMTIME	Allow NULL?
79	PLDATES	Planned Start	nvarchar	8	DATS	(N'00000000')	Yes		TTSE_PLDATE	Allow NULL?
80	PLTIMES	Plan Start Time	nvarchar	6	TIMS	(N'000000')	Yes		TTSE_PLTIME	Allow NULL?
81	PLDATEE	Planned End	nvarchar	8	DATS	(N'00000000')	Yes		TTSE_PLDATE_E	Allow NULL?
82	PLTIMEE	Plan End Time	nvarchar	6	TIMS	(N'000000')	Yes		TTSE_PLTIME_E	Allow NULL?
83	POWER_OFF	Power off status	char	1	CHAR	(N' ')	Yes		TTSE_POWER_OFF	Allow NULL?
84	NEWRESP	Change Work Responsible	nvarchar	10	CHAR	(N' ')	Yes		TTSE_NEWRESP	Allow NULL?
85	ISSUEDBY	Work Ticket Issuer	nvarchar	10	CHAR	(N' ')	Yes		TTSE_ISSUEDBY	Allow NULL?
86	RCHGDATE	Change Approved on	nvarchar	8	DATS	(N'00000000')	Yes		TTSE_RCHGDATE	Allow NULL?
87	RCHGTIME	issue time	nvarchar	6	TIMS	(N'000000')	Yes		TTSE_RCHGTIME	Allow NULL?
88	PTDATE	Extension Date and Time	nvarchar	8	DATS	(N'00000000')	Yes		TTSE_PTDATE	Allow NULL?
89	PTTIME	Work Ticket Extended totime(extension)	nvarchar	6	TIMS	(N'000000')	Yes		TTSE_PTTIME	Allow NULL?
90	EXTRESP	Work Responsible	nvarchar	10	CHAR	(N' ')	Yes		TTSE_EXTRESP	Allow NULL?
91	PERRESP	Work Permit Responsible	nvarchar	10	CHAR	(N' ')	Yes		TTSE_PERRESP	Allow NULL?
92	PRESP	Work Permit Responsible	nvarchar	10	CHAR	(N' ')	Yes		TTSE_PRESP	Allow NULL?
93	PRDATE	Change Approved on	nvarchar	8	DATS	(N'00000000')	Yes		TTSE_PRDATE	Allow NULL?
94	PREDATE	Extension Approved on	nvarchar	8	DATS	(N'00000000')	Yes		TTSE_PREDATE	Allow NULL?
95	PRTIME	WT Permit Resp. Time	nvarchar	6	TIMS	(N'000000')	Yes		TTSE_PRTIME	Allow NULL?
96	PRETIME	WT Permit Resp. Time(extension)	nvarchar	6	TIMS	(N'000000')	Yes		TTSE_PRETIME	Allow NULL?
97	EXTRTIME	WT Resp. Time(extension)	nvarchar	6	TIMS	(N'000000')	Yes		TTSE_EXTTIME	Allow NULL?
98	EXTRDATE	Extension Approved on	nvarchar	8	DATS	(N'00000000')	Yes		TTSE_EXTDATE	Allow NULL?
99	SHTCHF	Shift Chief	nvarchar	10	CHAR	(N' ')	Yes		TTSE_SHTCHF	Allow NULL?
100	SHCDATE	Extension Approved on	nvarchar	8	DATS	(N'00000000')	Yes		TTSE_SHCDATE	Allow NULL?
101	SHCTIME	Shift Chief Time(extension)	nvarchar	6	TIMS	(N'000000')	Yes		TTSE_SHCTIME	Allow NULL?
102	SHIFT	Crew ID	nvarchar	20	CHAR	(N' ')	Yes		TTSE_SFTN	Allow NULL?
103	PERSONNEL_NO	Work Responsible	nvarchar	10	CHAR	(N' ')	Yes		TTSE_PERSONNEL	Allow NULL?
104	NUM	Total Number of Crew Members	nvarchar	3	NUMC	(N'000')	Yes		TTSE_NUM	Allow NULL?
105	TTS_FLAG	Include Work Responsible	char	1	CHAR	(N' ')	Yes		TTSE_FLAG	Allow NULL?
106	THERM_APPR1	Thermal Control Work Ticket's Approver	nvarchar	12	CHAR	(N' ')	Yes		TTSE_THERM_APPR1	Allow NULL?
107	THERM_EXEC1	Thermal Control Work Ticket's Protection disabled Executor	nvarchar	12	CHAR	(N' ')	Yes		TTSE_THERM_EXEC1	Allow NULL?
108	THERM_EXEC2	Thermal Control Measure Executor	nvarchar	12	CHAR	(N' ')	Yes		TTSE_THERM_EXEC2	Allow NULL?
109	THERM_EXEC3	Operation Measure Executor	nvarchar	12	CHAR	(N' ')	Yes		TTSE_THERM_EXEC3	Allow NULL?
110	THERM_STDATE	Date	nvarchar	8	DATS	(N'00000000')	Yes		DATUM	Allow NULL?
111	THERM_STTIME	Time	nvarchar	6	TIMS	(N'000000')	Yes		UZEIT	Allow NULL?
112	THERM_OP_SPRV	Thermal Control Work Ticket's Operation Supervisor	nvarchar	12	CHAR	(N' ')	Yes		TTSS_THERM_SUPE	Allow NULL?
113	THERM_WORK_RESP	Thermal Control Work Ticket's Work Responsible	nvarchar	12	CHAR	(N' ')	Yes		TTSS_THERM_RESP	Allow NULL?
114	THERM_WORK_PERRESP	Thermal Control Work Ticket's Work Permit Responsible	nvarchar	12	CHAR	(N' ')	Yes		TTSS_THERM_PERM	Allow NULL?
115	PLANT_SIGN_WT7	Plant Supervisor	nvarchar	12	CHAR	(N' ')	Yes		TTSE_HOT_RESP1	Allow NULL?
116	SECU_SIGN_WT7	Security Officer	nvarchar	12	CHAR	(N' ')	Yes		TTSE_HOT_RESP2	Allow NULL?
117	FIRE_SIGN_WT7	Fire Protection Officer	nvarchar	12	CHAR	(N' ')	Yes		TTSE_HOT_RESP3	Allow NULL?
118	FIRE_MSR_WT7	Fire Protection Guardian	nvarchar	12	CHAR	(N' ')	Yes		TTSE_HOT_GRD1	Allow NULL?
119	PLANT_BGN_WT7	Plant Supervisor	nvarchar	12	CHAR	(N' ')	Yes		TTSE_HOT_RESP1	Allow NULL?
120	SECU_BGN_WT7	Security Officer	nvarchar	12	CHAR	(N' ')	Yes		TTSE_HOT_RESP2	Allow NULL?
121	FIRE_BGN_WT7	Fire Protection Officer	nvarchar	12	CHAR	(N' ')	Yes		TTSE_HOT_RESP3	Allow NULL?
122	EXEC_BGN_WT7	Hot Work Ticket's Executor	nvarchar	12	CHAR	(N' ')	Yes		TTSE_HOT_EXEC	Allow NULL?
123	FIRE_END_WT7	Fire Protection Guardian	nvarchar	12	CHAR	(N' ')	Yes		TTSE_HOT_GRD1	Allow NULL?
124	EXEC_END_WT7	Hot Work Ticket's Executor	nvarchar	12	CHAR	(N' ')	Yes		TTSE_HOT_EXEC	Allow NULL?
125	LOC_MSR_WT7	Measurement Location	nvarchar	30	CHAR	(N' ')	Yes		TTSE_HOT_LOC	Allow NULL?
126	EQUIP_MSR_WT7	Measurement Equipment	nvarchar	30	CHAR	(N' ')	Yes		TTSE_HOT_EQUIP	Allow NULL?
127	ITEM_MSR_WT7	Measurement Item	nvarchar	30	CHAR	(N' ')	Yes		TTSE_HOT_ITEM	Allow NULL?
128	ZP_WAPINR	Application	nvarchar	12	CHAR	(N' ')	Yes		WCEWAPINR	Allow NULL?

Name	Primary	Unique	Type	Columns
WCAAP~0	Yes	Yes	CLUSTERED	MANDT, WAPINR
WCAAP~A	No	No	NONCLUSTERED	MANDT, OBJNR
WCAAP~C	No	No	NONCLUSTERED	MANDT, TPLNR
WCAAP~E	No	No	NONCLUSTERED	MANDT, IWERK, WAPITYP, OBJNR

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

128 COLUMNS | 4 INDEXES | ERP 6.0 | WCAAP TABLE

TOP ERP 6.0 | WCAAP COLUMNS

TOP ERP 6.0 | WCAAP INDEXES

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

128 COLUMNS | 4 INDEXES | ERP 6.0 | WCAAP TABLE

TOPERP 6.0 | WCAAP COLUMNS

TOPERP 6.0 | WCAAP INDEXES

TOP ERP 6.0 | WCAAP COLUMNS

TOP ERP 6.0 | WCAAP INDEXES