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	BSEG	345	Accounting Document Segment
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	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

B1 8.8: Top 10 requests

	Table	Columns	Description
1	ORCT	154	Incoming Payment
2	OITM	249	Items
3	OINV	268	A/R Invoice
4	OIVL	77	Whse Journal
5	OINM	101	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

	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	SQL Create Statement
1	MANDT	Client	nvarchar	3	Allow NULL?
2	WAPINR	Application	nvarchar	12	Allow NULL?
3	OBJNR	Object number	nvarchar	22	Allow NULL?
4	WAPITYP	Type of WCM Object	char	1	Allow NULL?
5	WAPIUSE	Usage of WCM Object	nvarchar	3	Allow NULL?
6	STXT	Descriptive Short Text	nvarchar	40	Allow NULL?
7	LFLG	Long Text Exists	char	1	Allow NULL?
8	DELFLG	Delete	char	1	Allow NULL?
9	REQUALFLG	Requalification Text Exists	char	1	Allow NULL?
10	CATFLG1	Catalog Exists	char	1	Allow NULL?
11	CATFLG2	Catalog Exists	char	1	Allow NULL?
12	INGRP	Planner Group for Customer Service and Plant Maintenance	nvarchar	3	Allow NULL?
13	IWERK	Maintenance Planning Plant	nvarchar	4	Allow NULL?
14	WKCRTYP	Object types of the CIM resource	nvarchar	2	Allow NULL?
15	WKCRID	Object ID of the resource	nvarchar	8	Allow NULL?
16	BEGRU	Technical object authorization group	nvarchar	4	Allow NULL?
17	DATEFR	Valid-From Date for WCM Object	nvarchar	8	Allow NULL?
18	TIMEFR	Valid-From Time for WCM Object	nvarchar	6	Allow NULL?
19	DATETO	Valid-To Date for WCM Object	nvarchar	8	Allow NULL?
20	TIMETO	Valid-To Time for WCM Object	nvarchar	6	Allow NULL?
21	EXTPERIOD	Total Extension of Validity in Hours	int	10	Allow NULL?
22	ANLZU	Overall Condition of Technical System	nvarchar	2	Allow NULL?
23	RCTIME	Recall Time	decimal	5
24	RCUNIT	Unit of Recall Time	nvarchar	3	Allow NULL?
25	PRIOK	Priority	char	1	Allow NULL?
26	TPLNR	Functional Location	nvarchar	30	Allow NULL?
27	EQUNR	Equipment Number	nvarchar	18	Allow NULL?
28	LNKFLG	Object List Exists	char	1	Allow NULL?
29	TRAIN	Train	nvarchar	3	Allow NULL?
30	CRNAME	Created by	nvarchar	12	Allow NULL?
31	CRDATE	Date on Which the Object Was Created	nvarchar	8	Allow NULL?
32	CRTIME	Time at Which Object was Created	nvarchar	6	Allow NULL?
33	CHNAME	Last Changed By	nvarchar	12	Allow NULL?
34	CHDATE	Date on Which Object was Last Changed	nvarchar	8	Allow NULL?
35	CHTIME	Time at Which Object was Last Changed	nvarchar	6	Allow NULL?
36	PSPEL	Work Breakdown Structure Element (WBS Element)	nvarchar	8	Allow NULL?
37	AUFNT	Number of superior network	nvarchar	12	Allow NULL?
38	VORNR	Activity number replaced by sub-network	nvarchar	4	Allow NULL?
39	BDATE	Basic start date	nvarchar	8	Allow NULL?
40	BTIME	Basic start time	nvarchar	6	Allow NULL?
41	EDATE	Basic finish date	nvarchar	8	Allow NULL?
42	ETIME	Basic finish (time)	nvarchar	6	Allow NULL?
43	TSDATE	Scheduled start	nvarchar	8	Allow NULL?
44	TSTIME	Scheduled Start (Time)	nvarchar	6	Allow NULL?
45	TFDATE	Scheduled finish	nvarchar	8	Allow NULL?
46	TFTIME	Scheduled finish time	nvarchar	6	Allow NULL?
47	ESDATE	Date	nvarchar	8	Allow NULL?
48	ESTIME	Time	nvarchar	6	Allow NULL?
49	EFDATE	Date	nvarchar	8	Allow NULL?
50	EFTIME	Time	nvarchar	6	Allow NULL?
51	LSDATE	Date	nvarchar	8	Allow NULL?
52	LSTIME	Time	nvarchar	6	Allow NULL?
53	LFDATE	Date	nvarchar	8	Allow NULL?
54	LFTIME	Time	nvarchar	6	Allow NULL?
55	PSDATE	Date	nvarchar	8	Allow NULL?
56	PSTIME	Time	nvarchar	6	Allow NULL?
57	PFDATE	Date	nvarchar	8	Allow NULL?
58	PFTIME	Time	nvarchar	6	Allow NULL?
59	ASDATE	Actual start date	nvarchar	8	Allow NULL?
60	ASTIME	Actual start time	nvarchar	6	Allow NULL?
61	AFDATE	Actual finish date	nvarchar	8	Allow NULL?
62	AFTIME	Actual End Date (Time)	nvarchar	6	Allow NULL?
63	ETAPE	Revision Phase	nvarchar	20	Allow NULL?
64	DOCFLG	Linked to Document	char	1	Allow NULL?
65	WAPISTSMA	Status Profile	nvarchar	8	Allow NULL?
66	REFOBJ	Template (Object Number)	nvarchar	22	Allow NULL?
67	REMARKFLG1	Remarks (Maintenance) Exist	char	1	Allow NULL?
68	REMARKFLG2	Remarks (Operation) Exist	char	1	Allow NULL?
69	IDATE	Issued	nvarchar	8	Allow NULL?
70	ITIME	Issue Time	nvarchar	6	Allow NULL?
71	RDATE	Received	nvarchar	8	Allow NULL?
72	RTIME	Receive Time	nvarchar	6	Allow NULL?
73	PDATES	Permit Start	nvarchar	8	Allow NULL?
74	PTIMES	Permit Start Time	nvarchar	6	Allow NULL?
75	PDATEE	Permit End	nvarchar	8	Allow NULL?
76	PTIMEE	Permit End Time	nvarchar	6	Allow NULL?
77	CDATE	Completed	nvarchar	8	Allow NULL?
78	CTIME	Complete Time	nvarchar	6	Allow NULL?
79	PLDATES	Planned Start	nvarchar	8	Allow NULL?
80	PLTIMES	Plan Start Time	nvarchar	6	Allow NULL?
81	PLDATEE	Planned End	nvarchar	8	Allow NULL?
82	PLTIMEE	Plan End Time	nvarchar	6	Allow NULL?
83	POWER_OFF	Power off status	char	1	Allow NULL?
84	NEWRESP	Change Work Responsible	nvarchar	10	Allow NULL?
85	ISSUEDBY	Work Ticket Issuer	nvarchar	10	Allow NULL?
86	RCHGDATE	Change Approved on	nvarchar	8	Allow NULL?
87	RCHGTIME	issue time	nvarchar	6	Allow NULL?
88	PTDATE	Extension Date and Time	nvarchar	8	Allow NULL?
89	PTTIME	Work Ticket Extended totime(extension)	nvarchar	6	Allow NULL?
90	EXTRESP	Work Responsible	nvarchar	10	Allow NULL?
91	PERRESP	Work Permit Responsible	nvarchar	10	Allow NULL?
92	PRESP	Work Permit Responsible	nvarchar	10	Allow NULL?
93	PRDATE	Change Approved on	nvarchar	8	Allow NULL?
94	PREDATE	Extension Approved on	nvarchar	8	Allow NULL?
95	PRTIME	WT Permit Resp. Time	nvarchar	6	Allow NULL?
96	PRETIME	WT Permit Resp. Time(extension)	nvarchar	6	Allow NULL?
97	EXTRTIME	WT Resp. Time(extension)	nvarchar	6	Allow NULL?
98	EXTRDATE	Extension Approved on	nvarchar	8	Allow NULL?
99	SHTCHF	Shift Chief	nvarchar	10	Allow NULL?
100	SHCDATE	Extension Approved on	nvarchar	8	Allow NULL?
101	SHCTIME	Shift Chief Time(extension)	nvarchar	6	Allow NULL?
102	SHIFT	Crew ID	nvarchar	20	Allow NULL?
103	PERSONNEL_NO	Work Responsible	nvarchar	10	Allow NULL?
104	NUM	Total Number of Crew Members	nvarchar	3	Allow NULL?
105	TTS_FLAG	Include Work Responsible	char	1	Allow NULL?
106	THERM_APPR1	Thermal Control Work Ticket's Approver	nvarchar	12	Allow NULL?
107	THERM_EXEC1	Thermal Control Work Ticket's Protection disabled Executor	nvarchar	12	Allow NULL?
108	THERM_EXEC2	Thermal Control Measure Executor	nvarchar	12	Allow NULL?
109	THERM_EXEC3	Operation Measure Executor	nvarchar	12	Allow NULL?
110	THERM_STDATE	Date	nvarchar	8	Allow NULL?
111	THERM_STTIME	Time	nvarchar	6	Allow NULL?
112	THERM_OP_SPRV	Thermal Control Work Ticket's Operation Supervisor	nvarchar	12	Allow NULL?
113	THERM_WORK_RESP	Thermal Control Work Ticket's Work Responsible	nvarchar	12	Allow NULL?
114	THERM_WORK_PERRESP	Thermal Control Work Ticket's Work Permit Responsible	nvarchar	12	Allow NULL?
115	PLANT_SIGN_WT7	Plant Supervisor	nvarchar	12	Allow NULL?
116	SECU_SIGN_WT7	Security Officer	nvarchar	12	Allow NULL?
117	FIRE_SIGN_WT7	Fire Protection Officer	nvarchar	12	Allow NULL?
118	FIRE_MSR_WT7	Fire Protection Guardian	nvarchar	12	Allow NULL?
119	PLANT_BGN_WT7	Plant Supervisor	nvarchar	12	Allow NULL?
120	SECU_BGN_WT7	Security Officer	nvarchar	12	Allow NULL?
121	FIRE_BGN_WT7	Fire Protection Officer	nvarchar	12	Allow NULL?
122	EXEC_BGN_WT7	Hot Work Ticket's Executor	nvarchar	12	Allow NULL?
123	FIRE_END_WT7	Fire Protection Guardian	nvarchar	12	Allow NULL?
124	EXEC_END_WT7	Hot Work Ticket's Executor	nvarchar	12	Allow NULL?
125	LOC_MSR_WT7	Measurement Location	nvarchar	30	Allow NULL?
126	EQUIP_MSR_WT7	Measurement Equipment	nvarchar	30	Allow NULL?
127	ITEM_MSR_WT7	Measurement Item	nvarchar	30	Allow NULL?
128	ZP_WAPINR	Application	nvarchar	12	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