	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

	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

	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

161 COLUMNS | 2 INDEXES | ERP 6.0 | HRP1030 TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Training and Event Management
1	ERP EHP7	6.0	HRP1030	161	2	Infotype 1030 DB table	Training and Event Management

SQL: selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, PLVAR, OTYPE, OBJID, SUBTY, ISTAT, BEGDA, ENDDA, VARYF, SEQNR, INFTY, OTJID, AEDTM, UNAME, REASN, HISTO, ITXNR, TEILN_TYP, BCHECK, VCHECK, KCHECK, QCHECK, QASSIGN, DELRKURS, INSRKTYP, XDATA, TEILNTYP01, BCHECK01, VCHECK01, KCHECK01, QCHECK01, QASSIGN01, DELRKURS01, INSRKTYP01, XDATA01, TEILNTYP02, BCHECK02, VCHECK02, KCHECK02, QCHECK02, QASSIGN02, DELRKURS02, INSRKTYP02, XDATA02, TEILNTYP03, BCHECK03, VCHECK03, KCHECK03, QCHECK03, QASSIGN03, DELRKURS03, INSRKTYP03, XDATA03, TEILNTYP04, BCHECK04, VCHECK04, KCHECK04, QCHECK04, QASSIGN04, DELRKURS04, INSRKTYP04, XDATA04, TEILNTYP05, BCHECK05, VCHECK05, KCHECK05, QCHECK05, QASSIGN05, DELRKURS05, INSRKTYP05, XDATA05, TEILNTYP06, BCHECK06, VCHECK06, KCHECK06, QCHECK06, QASSIGN06, DELRKURS06, INSRKTYP06, XDATA06, TEILNTYP07, BCHECK07, VCHECK07, KCHECK07, QCHECK07, QASSIGN07, DELRKURS07, INSRKTYP07, XDATA07, TEILNTYP08, BCHECK08, VCHECK08, KCHECK08, QCHECK08, QASSIGN08, DELRKURS08, INSRKTYP08, XDATA08, TEILNTYP09, BCHECK09, VCHECK09, KCHECK09, QCHECK09, QASSIGN09, DELRKURS09, INSRKTYP09, XDATA09, TEILNTYP10, BCHECK10, VCHECK10, KCHECK10, QCHECK10, QASSIGN10, DELRKURS10, INSRKTYP10, XDATA10, TEILNTYP11, BCHECK11, VCHECK11, KCHECK11, QCHECK11, QASSIGN11, DELRKURS11, INSRKTYP11, XDATA11, TEILNTYP12, BCHECK12, VCHECK12, KCHECK12, QCHECK12, QASSIGN12, DELRKURS12, INSRKTYP12, XDATA12, TEILNTYP13, BCHECK13, VCHECK13, KCHECK13, QCHECK13, QASSIGN13, DELRKURS13, INSRKTYP13, XDATA13, TEILNTYP14, BCHECK14, VCHECK14, KCHECK14, QCHECK14, QASSIGN14, DELRKURS14, INSRKTYP14, XDATA14, TEILNTYP15, BCHECK15, VCHECK15, KCHECK15, QCHECK15, QASSIGN15, DELRKURS15, INSRKTYP15, XDATA15 FROM HRP1030

TOP ERP 6.0 | HRP1030 COLUMNS

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	PLVAR	Plan Version	nvarchar	2	CHAR	(N' ')	No	T778P	PLVAR	Allow NULL?
3	OTYPE	Object Type	nvarchar	2	CHAR	(N' ')	No	T778O	OTYPE	Allow NULL?
4	OBJID	Object ID	nvarchar	8	NUMC	(N'00000000')	No	PLOGI	HROBJID	Allow NULL?
5	SUBTY	Subtype	nvarchar	4	CHAR	(N' ')	No	*	SUBTYP	Allow NULL?
6	ISTAT	Planning Status	char	1	CHAR	(N' ')	No	T778S	ISTAT_D	Allow NULL?
7	BEGDA	Start Date	nvarchar	8	DATS	(N'00000000')	No		BEGDATUM	Allow NULL?
8	ENDDA	End Date	nvarchar	8	DATS	(N'00000000')	No		ENDDATUM	Allow NULL?
9	VARYF	Variation Field for File PLOG	nvarchar	10	CHAR	(N' ')	No		VARYF	Allow NULL?
10	SEQNR	Number of Infotype Record with Same Key	nvarchar	3	NUMC	(N'000')	No		SEQNR	Allow NULL?
11	INFTY	Infotype	nvarchar	4	CHAR	(N' ')	No	T778T	INFOTYP	Allow NULL?
12	OTJID	Concatenation of Object Type and Object ID	nvarchar	10	CHAR	(N' ')	No		OTJID	Allow NULL?
13	AEDTM	Changed on	nvarchar	8	DATS	(N'00000000')	No		AEDTM	Allow NULL?
14	UNAME	User Name	nvarchar	12	CHAR	(N' ')	No		USRNAME	Allow NULL?
15	REASN	Reason	nvarchar	2	CHAR	(N' ')	No		REASN	Allow NULL?
16	HISTO	Historical Record Flag	char	1	CHAR	(N' ')	No		HISTO	Allow NULL?
17	ITXNR	Text Module for Infotype	nvarchar	8	NUMC	(N'00000000')	No		ITXNR	Allow NULL?
18	TEILN_TYP	Attendee type	nvarchar	2	CHAR	(N' ')	No	T778O	TEILNTYP	Allow NULL?
19	BCHECK	Check for bookings for same business event type	char	1	CHAR	(N' ')	No		BCHECK	Allow NULL?
20	VCHECK	Check for prebookings on same business event type	char	1	CHAR	(N' ')	No		VCHECK	Allow NULL?
21	KCHECK	Check for prerequisite business event	char	1	CHAR	(N' ')	No		KCHECK	Allow NULL?
22	QCHECK	Check Attendee's Qualification	char	1	CHAR	(N' ')	No		QCHECK	Allow NULL?
23	QASSIGN	Transfer objectives to attendee as qualifications	char	1	CHAR	(N' ')	No		QASSIGN	Allow NULL?
24	DELRKURS	Delete relationship business event/attendee after bus.event	char	1	CHAR	(N' ')	No		DELRKURS	Allow NULL?
25	INSRKTYP	Create relationship event type / attendee after bus. event	char	1	CHAR	(N' ')	No		INSRKTYP	Allow NULL?
26	XDATA	Reserve field PX030	nvarchar	6	CHAR	(N' ')	No		XDATA	Allow NULL?
27	TEILNTYP01	Attendee type	nvarchar	2	CHAR	(N' ')	No	T778O	TEILNTYP	Allow NULL?
28	BCHECK01	Check for bookings for same business event type	char	1	CHAR	(N' ')	No		BCHECK	Allow NULL?
29	VCHECK01	Check for prebookings on same business event type	char	1	CHAR	(N' ')	No		VCHECK	Allow NULL?
30	KCHECK01	Check for prerequisite business event	char	1	CHAR	(N' ')	No		KCHECK	Allow NULL?
31	QCHECK01	Check Attendee's Qualification	char	1	CHAR	(N' ')	No		QCHECK	Allow NULL?
32	QASSIGN01	Transfer objectives to attendee as qualifications	char	1	CHAR	(N' ')	No		QASSIGN	Allow NULL?
33	DELRKURS01	Delete relationship business event/attendee after bus.event	char	1	CHAR	(N' ')	No		DELRKURS	Allow NULL?
34	INSRKTYP01	Create relationship event type / attendee after bus. event	char	1	CHAR	(N' ')	No		INSRKTYP	Allow NULL?
35	XDATA01	Reserve field PX030	nvarchar	6	CHAR	(N' ')	No		XDATA	Allow NULL?
36	TEILNTYP02	Attendee type	nvarchar	2	CHAR	(N' ')	No	T778O	TEILNTYP	Allow NULL?
37	BCHECK02	Check for bookings for same business event type	char	1	CHAR	(N' ')	No		BCHECK	Allow NULL?
38	VCHECK02	Check for prebookings on same business event type	char	1	CHAR	(N' ')	No		VCHECK	Allow NULL?
39	KCHECK02	Check for prerequisite business event	char	1	CHAR	(N' ')	No		KCHECK	Allow NULL?
40	QCHECK02	Check Attendee's Qualification	char	1	CHAR	(N' ')	No		QCHECK	Allow NULL?
41	QASSIGN02	Transfer objectives to attendee as qualifications	char	1	CHAR	(N' ')	No		QASSIGN	Allow NULL?
42	DELRKURS02	Delete relationship business event/attendee after bus.event	char	1	CHAR	(N' ')	No		DELRKURS	Allow NULL?
43	INSRKTYP02	Create relationship event type / attendee after bus. event	char	1	CHAR	(N' ')	No		INSRKTYP	Allow NULL?
44	XDATA02	Reserve field PX030	nvarchar	6	CHAR	(N' ')	No		XDATA	Allow NULL?
45	TEILNTYP03	Attendee type	nvarchar	2	CHAR	(N' ')	No	T778O	TEILNTYP	Allow NULL?
46	BCHECK03	Check for bookings for same business event type	char	1	CHAR	(N' ')	No		BCHECK	Allow NULL?
47	VCHECK03	Check for prebookings on same business event type	char	1	CHAR	(N' ')	No		VCHECK	Allow NULL?
48	KCHECK03	Check for prerequisite business event	char	1	CHAR	(N' ')	No		KCHECK	Allow NULL?
49	QCHECK03	Check Attendee's Qualification	char	1	CHAR	(N' ')	No		QCHECK	Allow NULL?
50	QASSIGN03	Transfer objectives to attendee as qualifications	char	1	CHAR	(N' ')	No		QASSIGN	Allow NULL?
51	DELRKURS03	Delete relationship business event/attendee after bus.event	char	1	CHAR	(N' ')	No		DELRKURS	Allow NULL?
52	INSRKTYP03	Create relationship event type / attendee after bus. event	char	1	CHAR	(N' ')	No		INSRKTYP	Allow NULL?
53	XDATA03	Reserve field PX030	nvarchar	6	CHAR	(N' ')	No		XDATA	Allow NULL?
54	TEILNTYP04	Attendee type	nvarchar	2	CHAR	(N' ')	No	T778O	TEILNTYP	Allow NULL?
55	BCHECK04	Check for bookings for same business event type	char	1	CHAR	(N' ')	No		BCHECK	Allow NULL?
56	VCHECK04	Check for prebookings on same business event type	char	1	CHAR	(N' ')	No		VCHECK	Allow NULL?
57	KCHECK04	Check for prerequisite business event	char	1	CHAR	(N' ')	No		KCHECK	Allow NULL?
58	QCHECK04	Check Attendee's Qualification	char	1	CHAR	(N' ')	No		QCHECK	Allow NULL?
59	QASSIGN04	Transfer objectives to attendee as qualifications	char	1	CHAR	(N' ')	No		QASSIGN	Allow NULL?
60	DELRKURS04	Delete relationship business event/attendee after bus.event	char	1	CHAR	(N' ')	No		DELRKURS	Allow NULL?
61	INSRKTYP04	Create relationship event type / attendee after bus. event	char	1	CHAR	(N' ')	No		INSRKTYP	Allow NULL?
62	XDATA04	Reserve field PX030	nvarchar	6	CHAR	(N' ')	No		XDATA	Allow NULL?
63	TEILNTYP05	Attendee type	nvarchar	2	CHAR	(N' ')	No	T778O	TEILNTYP	Allow NULL?
64	BCHECK05	Check for bookings for same business event type	char	1	CHAR	(N' ')	No		BCHECK	Allow NULL?
65	VCHECK05	Check for prebookings on same business event type	char	1	CHAR	(N' ')	No		VCHECK	Allow NULL?
66	KCHECK05	Check for prerequisite business event	char	1	CHAR	(N' ')	No		KCHECK	Allow NULL?
67	QCHECK05	Check Attendee's Qualification	char	1	CHAR	(N' ')	No		QCHECK	Allow NULL?
68	QASSIGN05	Transfer objectives to attendee as qualifications	char	1	CHAR	(N' ')	No		QASSIGN	Allow NULL?
69	DELRKURS05	Delete relationship business event/attendee after bus.event	char	1	CHAR	(N' ')	No		DELRKURS	Allow NULL?
70	INSRKTYP05	Create relationship event type / attendee after bus. event	char	1	CHAR	(N' ')	No		INSRKTYP	Allow NULL?
71	XDATA05	Reserve field PX030	nvarchar	6	CHAR	(N' ')	No		XDATA	Allow NULL?
72	TEILNTYP06	Attendee type	nvarchar	2	CHAR	(N' ')	No	T778O	TEILNTYP	Allow NULL?
73	BCHECK06	Check for bookings for same business event type	char	1	CHAR	(N' ')	No		BCHECK	Allow NULL?
74	VCHECK06	Check for prebookings on same business event type	char	1	CHAR	(N' ')	No		VCHECK	Allow NULL?
75	KCHECK06	Check for prerequisite business event	char	1	CHAR	(N' ')	No		KCHECK	Allow NULL?
76	QCHECK06	Check Attendee's Qualification	char	1	CHAR	(N' ')	No		QCHECK	Allow NULL?
77	QASSIGN06	Transfer objectives to attendee as qualifications	char	1	CHAR	(N' ')	No		QASSIGN	Allow NULL?
78	DELRKURS06	Delete relationship business event/attendee after bus.event	char	1	CHAR	(N' ')	No		DELRKURS	Allow NULL?
79	INSRKTYP06	Create relationship event type / attendee after bus. event	char	1	CHAR	(N' ')	No		INSRKTYP	Allow NULL?
80	XDATA06	Reserve field PX030	nvarchar	6	CHAR	(N' ')	No		XDATA	Allow NULL?
81	TEILNTYP07	Attendee type	nvarchar	2	CHAR	(N' ')	No	T778O	TEILNTYP	Allow NULL?
82	BCHECK07	Check for bookings for same business event type	char	1	CHAR	(N' ')	No		BCHECK	Allow NULL?
83	VCHECK07	Check for prebookings on same business event type	char	1	CHAR	(N' ')	No		VCHECK	Allow NULL?
84	KCHECK07	Check for prerequisite business event	char	1	CHAR	(N' ')	No		KCHECK	Allow NULL?
85	QCHECK07	Check Attendee's Qualification	char	1	CHAR	(N' ')	No		QCHECK	Allow NULL?
86	QASSIGN07	Transfer objectives to attendee as qualifications	char	1	CHAR	(N' ')	No		QASSIGN	Allow NULL?
87	DELRKURS07	Delete relationship business event/attendee after bus.event	char	1	CHAR	(N' ')	No		DELRKURS	Allow NULL?
88	INSRKTYP07	Create relationship event type / attendee after bus. event	char	1	CHAR	(N' ')	No		INSRKTYP	Allow NULL?
89	XDATA07	Reserve field PX030	nvarchar	6	CHAR	(N' ')	No		XDATA	Allow NULL?
90	TEILNTYP08	Attendee type	nvarchar	2	CHAR	(N' ')	No	T778O	TEILNTYP	Allow NULL?
91	BCHECK08	Check for bookings for same business event type	char	1	CHAR	(N' ')	No		BCHECK	Allow NULL?
92	VCHECK08	Check for prebookings on same business event type	char	1	CHAR	(N' ')	No		VCHECK	Allow NULL?
93	KCHECK08	Check for prerequisite business event	char	1	CHAR	(N' ')	No		KCHECK	Allow NULL?
94	QCHECK08	Check Attendee's Qualification	char	1	CHAR	(N' ')	No		QCHECK	Allow NULL?
95	QASSIGN08	Transfer objectives to attendee as qualifications	char	1	CHAR	(N' ')	No		QASSIGN	Allow NULL?
96	DELRKURS08	Delete relationship business event/attendee after bus.event	char	1	CHAR	(N' ')	No		DELRKURS	Allow NULL?
97	INSRKTYP08	Create relationship event type / attendee after bus. event	char	1	CHAR	(N' ')	No		INSRKTYP	Allow NULL?
98	XDATA08	Reserve field PX030	nvarchar	6	CHAR	(N' ')	No		XDATA	Allow NULL?
99	TEILNTYP09	Attendee type	nvarchar	2	CHAR	(N' ')	No	T778O	TEILNTYP	Allow NULL?
100	BCHECK09	Check for bookings for same business event type	char	1	CHAR	(N' ')	No		BCHECK	Allow NULL?
101	VCHECK09	Check for prebookings on same business event type	char	1	CHAR	(N' ')	No		VCHECK	Allow NULL?
102	KCHECK09	Check for prerequisite business event	char	1	CHAR	(N' ')	No		KCHECK	Allow NULL?
103	QCHECK09	Check Attendee's Qualification	char	1	CHAR	(N' ')	No		QCHECK	Allow NULL?
104	QASSIGN09	Transfer objectives to attendee as qualifications	char	1	CHAR	(N' ')	No		QASSIGN	Allow NULL?
105	DELRKURS09	Delete relationship business event/attendee after bus.event	char	1	CHAR	(N' ')	No		DELRKURS	Allow NULL?
106	INSRKTYP09	Create relationship event type / attendee after bus. event	char	1	CHAR	(N' ')	No		INSRKTYP	Allow NULL?
107	XDATA09	Reserve field PX030	nvarchar	6	CHAR	(N' ')	No		XDATA	Allow NULL?
108	TEILNTYP10	Attendee type	nvarchar	2	CHAR	(N' ')	No	T778O	TEILNTYP	Allow NULL?
109	BCHECK10	Check for bookings for same business event type	char	1	CHAR	(N' ')	No		BCHECK	Allow NULL?
110	VCHECK10	Check for prebookings on same business event type	char	1	CHAR	(N' ')	No		VCHECK	Allow NULL?
111	KCHECK10	Check for prerequisite business event	char	1	CHAR	(N' ')	No		KCHECK	Allow NULL?
112	QCHECK10	Check Attendee's Qualification	char	1	CHAR	(N' ')	No		QCHECK	Allow NULL?
113	QASSIGN10	Transfer objectives to attendee as qualifications	char	1	CHAR	(N' ')	No		QASSIGN	Allow NULL?
114	DELRKURS10	Delete relationship business event/attendee after bus.event	char	1	CHAR	(N' ')	No		DELRKURS	Allow NULL?
115	INSRKTYP10	Create relationship event type / attendee after bus. event	char	1	CHAR	(N' ')	No		INSRKTYP	Allow NULL?
116	XDATA10	Reserve field PX030	nvarchar	6	CHAR	(N' ')	No		XDATA	Allow NULL?
117	TEILNTYP11	Attendee type	nvarchar	2	CHAR	(N' ')	No	T778O	TEILNTYP	Allow NULL?
118	BCHECK11	Check for bookings for same business event type	char	1	CHAR	(N' ')	No		BCHECK	Allow NULL?
119	VCHECK11	Check for prebookings on same business event type	char	1	CHAR	(N' ')	No		VCHECK	Allow NULL?
120	KCHECK11	Check for prerequisite business event	char	1	CHAR	(N' ')	No		KCHECK	Allow NULL?
121	QCHECK11	Check Attendee's Qualification	char	1	CHAR	(N' ')	No		QCHECK	Allow NULL?
122	QASSIGN11	Transfer objectives to attendee as qualifications	char	1	CHAR	(N' ')	No		QASSIGN	Allow NULL?
123	DELRKURS11	Delete relationship business event/attendee after bus.event	char	1	CHAR	(N' ')	No		DELRKURS	Allow NULL?
124	INSRKTYP11	Create relationship event type / attendee after bus. event	char	1	CHAR	(N' ')	No		INSRKTYP	Allow NULL?
125	XDATA11	Reserve field PX030	nvarchar	6	CHAR	(N' ')	No		XDATA	Allow NULL?
126	TEILNTYP12	Attendee type	nvarchar	2	CHAR	(N' ')	No	T778O	TEILNTYP	Allow NULL?
127	BCHECK12	Check for bookings for same business event type	char	1	CHAR	(N' ')	No		BCHECK	Allow NULL?
128	VCHECK12	Check for prebookings on same business event type	char	1	CHAR	(N' ')	No		VCHECK	Allow NULL?
129	KCHECK12	Check for prerequisite business event	char	1	CHAR	(N' ')	No		KCHECK	Allow NULL?
130	QCHECK12	Check Attendee's Qualification	char	1	CHAR	(N' ')	No		QCHECK	Allow NULL?
131	QASSIGN12	Transfer objectives to attendee as qualifications	char	1	CHAR	(N' ')	No		QASSIGN	Allow NULL?
132	DELRKURS12	Delete relationship business event/attendee after bus.event	char	1	CHAR	(N' ')	No		DELRKURS	Allow NULL?
133	INSRKTYP12	Create relationship event type / attendee after bus. event	char	1	CHAR	(N' ')	No		INSRKTYP	Allow NULL?
134	XDATA12	Reserve field PX030	nvarchar	6	CHAR	(N' ')	No		XDATA	Allow NULL?
135	TEILNTYP13	Attendee type	nvarchar	2	CHAR	(N' ')	No	T778O	TEILNTYP	Allow NULL?
136	BCHECK13	Check for bookings for same business event type	char	1	CHAR	(N' ')	No		BCHECK	Allow NULL?
137	VCHECK13	Check for prebookings on same business event type	char	1	CHAR	(N' ')	No		VCHECK	Allow NULL?
138	KCHECK13	Check for prerequisite business event	char	1	CHAR	(N' ')	No		KCHECK	Allow NULL?
139	QCHECK13	Check Attendee's Qualification	char	1	CHAR	(N' ')	No		QCHECK	Allow NULL?
140	QASSIGN13	Transfer objectives to attendee as qualifications	char	1	CHAR	(N' ')	No		QASSIGN	Allow NULL?
141	DELRKURS13	Delete relationship business event/attendee after bus.event	char	1	CHAR	(N' ')	No		DELRKURS	Allow NULL?
142	INSRKTYP13	Create relationship event type / attendee after bus. event	char	1	CHAR	(N' ')	No		INSRKTYP	Allow NULL?
143	XDATA13	Reserve field PX030	nvarchar	6	CHAR	(N' ')	No		XDATA	Allow NULL?
144	TEILNTYP14	Attendee type	nvarchar	2	CHAR	(N' ')	No	T778O	TEILNTYP	Allow NULL?
145	BCHECK14	Check for bookings for same business event type	char	1	CHAR	(N' ')	No		BCHECK	Allow NULL?
146	VCHECK14	Check for prebookings on same business event type	char	1	CHAR	(N' ')	No		VCHECK	Allow NULL?
147	KCHECK14	Check for prerequisite business event	char	1	CHAR	(N' ')	No		KCHECK	Allow NULL?
148	QCHECK14	Check Attendee's Qualification	char	1	CHAR	(N' ')	No		QCHECK	Allow NULL?
149	QASSIGN14	Transfer objectives to attendee as qualifications	char	1	CHAR	(N' ')	No		QASSIGN	Allow NULL?
150	DELRKURS14	Delete relationship business event/attendee after bus.event	char	1	CHAR	(N' ')	No		DELRKURS	Allow NULL?
151	INSRKTYP14	Create relationship event type / attendee after bus. event	char	1	CHAR	(N' ')	No		INSRKTYP	Allow NULL?
152	XDATA14	Reserve field PX030	nvarchar	6	CHAR	(N' ')	No		XDATA	Allow NULL?
153	TEILNTYP15	Attendee type	nvarchar	2	CHAR	(N' ')	No	T778O	TEILNTYP	Allow NULL?
154	BCHECK15	Check for bookings for same business event type	char	1	CHAR	(N' ')	No		BCHECK	Allow NULL?
155	VCHECK15	Check for prebookings on same business event type	char	1	CHAR	(N' ')	No		VCHECK	Allow NULL?
156	KCHECK15	Check for prerequisite business event	char	1	CHAR	(N' ')	No		KCHECK	Allow NULL?
157	QCHECK15	Check Attendee's Qualification	char	1	CHAR	(N' ')	No		QCHECK	Allow NULL?
158	QASSIGN15	Transfer objectives to attendee as qualifications	char	1	CHAR	(N' ')	No		QASSIGN	Allow NULL?
159	DELRKURS15	Delete relationship business event/attendee after bus.event	char	1	CHAR	(N' ')	No		DELRKURS	Allow NULL?
160	INSRKTYP15	Create relationship event type / attendee after bus. event	char	1	CHAR	(N' ')	No		INSRKTYP	Allow NULL?
161	XDATA15	Reserve field PX030	nvarchar	6	CHAR	(N' ')	No		XDATA	Allow NULL?

TOP ERP 6.0 | HRP1030 INDEXES

Name	Primary	Unique	Type	Columns
HRP1030~0	Yes	Yes	CLUSTERED	SEQNR, VARYF, ENDDA, BEGDA, ISTAT, SUBTY, OBJID, OTYPE, PLVAR, MANDT
HRP1030~1	No	No	NONCLUSTERED	MANDT, PLVAR, OTJID

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

161 COLUMNS | 2 INDEXES | ERP 6.0 | HRP1030 TABLE

TOP ERP 6.0 | HRP1030 COLUMNS

TOP ERP 6.0 | HRP1030 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

161 COLUMNS | 2 INDEXES | ERP 6.0 | HRP1030 TABLE

TOPERP 6.0 | HRP1030 COLUMNS

TOPERP 6.0 | HRP1030 INDEXES

TOP ERP 6.0 | HRP1030 COLUMNS

TOP ERP 6.0 | HRP1030 INDEXES