	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

	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

	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

212 COLUMNS | 1 INDEXES | ERP 6.0 | PA0739 TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Personnel Management :: Personnel Administration :: Singapore
1	ERP EHP7	6.0	PA0739	212	1	HR Master Record: Infotype 0739 [Stock Option] (SG)	Singapore

SQL: selectupdate insert create

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

SELECT MANDT, PERNR, SUBTY, OBJPS, SPRPS, ENDDA, BEGDA, SEQNR, AEDTM, UNAME, HISTO, ITXEX, REFEX, ORDEX, ITBLD, PREAS, FLAG1, FLAG2, FLAG3, FLAG4, RESE1, RESE2, GRPVL, SCHEME_ID, PLAN_ID, NO_STOCKS_GRANT, GRANT_CURRENCY, GRANT_PRICE, GRANT_MKT_PRICE, RCB_NO, COMPANY_NAME, EXERCISE_DATE1, EXERCISE_PRICE1, NO_STOCK_EXERC1, EXER_CURRENCY1, EXER_MKT_PRICE1, HOLD_MKT_PRICE1, ACCOUNTED_YEAR1, EXERCISE_DATE2, EXERCISE_PRICE2, NO_STOCK_EXERC2, EXER_CURRENCY2, EXER_MKT_PRICE2, HOLD_MKT_PRICE2, ACCOUNTED_YEAR2, EXERCISE_DATE3, EXERCISE_PRICE3, NO_STOCK_EXERC3, EXER_CURRENCY3, EXER_MKT_PRICE3, HOLD_MKT_PRICE3, ACCOUNTED_YEAR3, EXERCISE_DATE4, EXERCISE_PRICE4, NO_STOCK_EXERC4, EXER_CURRENCY4, EXER_MKT_PRICE4, HOLD_MKT_PRICE4, ACCOUNTED_YEAR4, EXERCISE_DATE5, EXERCISE_PRICE5, NO_STOCK_EXERC5, EXER_CURRENCY5, EXER_MKT_PRICE5, HOLD_MKT_PRICE5, ACCOUNTED_YEAR5, EXERCISE_DATE6, EXERCISE_PRICE6, NO_STOCK_EXERC6, EXER_CURRENCY6, EXER_MKT_PRICE6, HOLD_MKT_PRICE6, ACCOUNTED_YEAR6, EXERCISE_DATE7, EXERCISE_PRICE7, NO_STOCK_EXERC7, EXER_CURRENCY7, EXER_MKT_PRICE7, HOLD_MKT_PRICE7, ACCOUNTED_YEAR7, EXERCISE_DATE8, EXERCISE_PRICE8, NO_STOCK_EXERC8, EXER_CURRENCY8, EXER_MKT_PRICE8, HOLD_MKT_PRICE8, ACCOUNTED_YEAR8, EXERCISE_DATE9, EXERCISE_PRICE9, NO_STOCK_EXERC9, EXER_CURRENCY9, EXER_MKT_PRICE9, HOLD_MKT_PRICE9, ACCOUNTED_YEAR9, EXERCISE_DATE10, EXERCISE_PRICE10, NO_STOCK_EXERC10, EXER_CURRENCY10, EXER_MKT_PRICE10, HOLD_MKT_PRICE10, ACCOUNTED_YEAR10, EXERCISE_DATE11, EXERCISE_PRICE11, NO_STOCK_EXERC11, EXER_CURRENCY11, EXER_MKT_PRICE11, HOLD_MKT_PRICE11, ACCOUNTED_YEAR11, EXERCISE_DATE12, EXERCISE_PRICE12, NO_STOCK_EXERC12, EXER_CURRENCY12, EXER_MKT_PRICE12, HOLD_MKT_PRICE12, ACCOUNTED_YEAR12, EXERCISE_DATE13, EXERCISE_PRICE13, NO_STOCK_EXERC13, EXER_CURRENCY13, EXER_MKT_PRICE13, HOLD_MKT_PRICE13, ACCOUNTED_YEAR13, EXERCISE_DATE14, EXERCISE_PRICE14, NO_STOCK_EXERC14, EXER_CURRENCY14, EXER_MKT_PRICE14, HOLD_MKT_PRICE14, ACCOUNTED_YEAR14, EXERCISE_DATE15, EXERCISE_PRICE15, NO_STOCK_EXERC15, EXER_CURRENCY15, EXER_MKT_PRICE15, HOLD_MKT_PRICE15, ACCOUNTED_YEAR15, EXERCISE_DATE16, EXERCISE_PRICE16, NO_STOCK_EXERC16, EXER_CURRENCY16, EXER_MKT_PRICE16, HOLD_MKT_PRICE16, ACCOUNTED_YEAR16, EXERCISE_DATE17, EXERCISE_PRICE17, NO_STOCK_EXERC17, EXER_CURRENCY17, EXER_MKT_PRICE17, HOLD_MKT_PRICE17, ACCOUNTED_YEAR17, EXERCISE_DATE18, EXERCISE_PRICE18, NO_STOCK_EXERC18, EXER_CURRENCY18, EXER_MKT_PRICE18, HOLD_MKT_PRICE18, ACCOUNTED_YEAR18, EXERCISE_DATE19, EXERCISE_PRICE19, NO_STOCK_EXERC19, EXER_CURRENCY19, EXER_MKT_PRICE19, HOLD_MKT_PRICE19, ACCOUNTED_YEAR19, EXERCISE_DATE20, EXERCISE_PRICE20, NO_STOCK_EXERC20, EXER_CURRENCY20, EXER_MKT_PRICE20, HOLD_MKT_PRICE20, ACCOUNTED_YEAR20, SING_GRANT_FLAG, AC_EX_DATE1, DE_EX_DATE1, AC_EX_DATE2, DE_EX_DATE2, AC_EX_DATE3, DE_EX_DATE3, AC_EX_DATE4, DE_EX_DATE4, AC_EX_DATE5, DE_EX_DATE5, AC_EX_DATE6, DE_EX_DATE6, AC_EX_DATE7, DE_EX_DATE7, AC_EX_DATE8, DE_EX_DATE8, AC_EX_DATE9, DE_EX_DATE9, AC_EX_DATE10, DE_EX_DATE10, AC_EX_DATE11, DE_EX_DATE11, AC_EX_DATE12, DE_EX_DATE12, AC_EX_DATE13, DE_EX_DATE13, AC_EX_DATE14, DE_EX_DATE14, AC_EX_DATE15, DE_EX_DATE15, AC_EX_DATE16, DE_EX_DATE16, AC_EX_DATE17, DE_EX_DATE17, AC_EX_DATE18, DE_EX_DATE18, AC_EX_DATE19, DE_EX_DATE19, AC_EX_DATE20, DE_EX_DATE20 FROM PA0739

TOP ERP 6.0 | PA0739 COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	CLNT	(N'000')	No	*	MANDT	Allow NULL?
2	PERNR	Personnel number	nvarchar	8	0	NUMC	(N'00000000')	No	PA0003	PERSNO	Allow NULL?
3	SUBTY	Subtype	nvarchar	4	0	CHAR	(N' ')	No		SUBTY	Allow NULL?
4	OBJPS	Object Identification	nvarchar	2	0	CHAR	(N' ')	No		OBJPS	Allow NULL?
5	SPRPS	Lock Indicator for HR Master Data Record	char	1	0	CHAR	(N' ')	No		SPRPS	Allow NULL?
6	ENDDA	End Date	nvarchar	8	0	DATS	(N'00000000')	No		ENDDA	Allow NULL?
7	BEGDA	Start Date	nvarchar	8	0	DATS	(N'00000000')	No		BEGDA	Allow NULL?
8	SEQNR	Number of Infotype Record with Same Key	nvarchar	3	0	NUMC	(N'000')	No		SEQNR	Allow NULL?
9	AEDTM	Changed On	nvarchar	8	0	DATS	(N'00000000')	Yes		AEDAT	Allow NULL?
10	UNAME	Name of Person Who Changed Object	nvarchar	12	0	CHAR	(N' ')	Yes		AENAM	Allow NULL?
11	HISTO	Historical Record Flag	char	1	0	CHAR	(N' ')	Yes		HISTO	Allow NULL?
12	ITXEX	Text Exists for Infotype	char	1	0	CHAR	(N' ')	Yes		ITXEX	Allow NULL?
13	REFEX	Reference Fields Exist (Primary/Secondary Costs)	char	1	0	CHAR	(N' ')	Yes		PRFEX	Allow NULL?
14	ORDEX	Confirmation Fields Exist	char	1	0	CHAR	(N' ')	Yes		ORDEX	Allow NULL?
15	ITBLD	Infotype Screen Control	nvarchar	2	0	CHAR	(N' ')	Yes		ITBLD	Allow NULL?
16	PREAS	Reason for Changing Master Data	nvarchar	2	0	CHAR	(N' ')	Yes	T530E	PREAS	Allow NULL?
17	FLAG1	Reserved Field/Unused Field	char	1	0	CHAR	(N' ')	Yes		NUSED	Allow NULL?
18	FLAG2	Reserved Field/Unused Field	char	1	0	CHAR	(N' ')	Yes		NUSED	Allow NULL?
19	FLAG3	Reserved Field/Unused Field	char	1	0	CHAR	(N' ')	Yes		NUSED	Allow NULL?
20	FLAG4	Reserved Field/Unused Field	char	1	0	CHAR	(N' ')	Yes		NUSED	Allow NULL?
21	RESE1	Reserved Field/Unused Field of Length 2	nvarchar	2	0	CHAR	(N' ')	Yes		NUSED2	Allow NULL?
22	RESE2	Reserved Field/Unused Field of Length 2	nvarchar	2	0	CHAR	(N' ')	Yes		NUSED2	Allow NULL?
23	GRPVL	Grouping Value for Personnel Assignments	nvarchar	4	0	CHAR	(N' ')	Yes		PCCE_GPVAL	Allow NULL?
24	SCHEME_ID	Stock Option Plan	nvarchar	4	0	CHAR	(N' ')	Yes	*	P25SOP_SCHEME_ID	Allow NULL?
25	PLAN_ID	Stock Option Scheme	nvarchar	6	0	CHAR	(N' ')	Yes	T5RSOP_PLAN	P25SOP_PLAN_ID	Allow NULL?
26	NO_STOCKS_GRANT	Number of stocks Granted	decimal	18	3	DEC	((0))	Yes		P25SOP_GRANT_NO
27	GRANT_CURRENCY	Currency key	nvarchar	5	0	CUKY	(N' ')	Yes	*	P25SOP_WAERS	Allow NULL?
28	GRANT_PRICE	Stock Option Grant Price	decimal	12	5	DEC	((0))	Yes		P25SOP_GRANT_PRICE
29	GRANT_MKT_PRICE	Market Price at time of Grant	decimal	12	5	DEC	((0))	Yes		P25SOP_GRANT_MKT_PRICE
30	RCB_NO	RCB No for the Company	nvarchar	12	0	CHAR	(N' ')	Yes		P25SOP_RCB_NO	Allow NULL?
31	COMPANY_NAME	Company Name for Stock Options	nvarchar	40	0	CHAR	(N' ')	Yes		P25SOP_COMPANY_NAME	Allow NULL?
32	EXERCISE_DATE1	Exercise Date	nvarchar	8	0	DATS	(N'00000000')	Yes		P25SOP_EXERCISE_DATE	Allow NULL?
33	EXERCISE_PRICE1	Exercise Price	decimal	12	5	DEC	((0))	Yes		P25SOP_EXERCISE_PRICE
34	NO_STOCK_EXERC1	No of stocks Exercised	decimal	18	3	DEC	((0))	Yes		P25SOP_EXERC_NO
35	EXER_CURRENCY1	Currency key	nvarchar	5	0	CUKY	(N' ')	Yes	*	P25SOP_WAERS	Allow NULL?
36	EXER_MKT_PRICE1	Market Price at time of Exercise	decimal	12	5	DEC	((0))	Yes		P25SOP_EXERC_MKT_PRICE
37	HOLD_MKT_PRICE1	Market Price at the end of holding period	decimal	12	5	DEC	((0))	Yes		P25SOP_HOLD_MKT_PRICE
38	ACCOUNTED_YEAR1	Accounted Year	nvarchar	4	0	CHAR	(N' ')	Yes		P25SOP_ACCOUNTED_YEAR	Allow NULL?
39	EXERCISE_DATE2	Exercise Date	nvarchar	8	0	DATS	(N'00000000')	Yes		P25SOP_EXERCISE_DATE	Allow NULL?
40	EXERCISE_PRICE2	Exercise Price	decimal	12	5	DEC	((0))	Yes		P25SOP_EXERCISE_PRICE
41	NO_STOCK_EXERC2	No of stocks Exercised	decimal	18	3	DEC	((0))	Yes		P25SOP_EXERC_NO
42	EXER_CURRENCY2	Currency key	nvarchar	5	0	CUKY	(N' ')	Yes	*	P25SOP_WAERS	Allow NULL?
43	EXER_MKT_PRICE2	Market Price at time of Exercise	decimal	12	5	DEC	((0))	Yes		P25SOP_EXERC_MKT_PRICE
44	HOLD_MKT_PRICE2	Market Price at the end of holding period	decimal	12	5	DEC	((0))	Yes		P25SOP_HOLD_MKT_PRICE
45	ACCOUNTED_YEAR2	Accounted Year	nvarchar	4	0	CHAR	(N' ')	Yes		P25SOP_ACCOUNTED_YEAR	Allow NULL?
46	EXERCISE_DATE3	Exercise Date	nvarchar	8	0	DATS	(N'00000000')	Yes		P25SOP_EXERCISE_DATE	Allow NULL?
47	EXERCISE_PRICE3	Exercise Price	decimal	12	5	DEC	((0))	Yes		P25SOP_EXERCISE_PRICE
48	NO_STOCK_EXERC3	No of stocks Exercised	decimal	18	3	DEC	((0))	Yes		P25SOP_EXERC_NO
49	EXER_CURRENCY3	Currency key	nvarchar	5	0	CUKY	(N' ')	Yes	*	P25SOP_WAERS	Allow NULL?
50	EXER_MKT_PRICE3	Market Price at time of Exercise	decimal	12	5	DEC	((0))	Yes		P25SOP_EXERC_MKT_PRICE
51	HOLD_MKT_PRICE3	Market Price at the end of holding period	decimal	12	5	DEC	((0))	Yes		P25SOP_HOLD_MKT_PRICE
52	ACCOUNTED_YEAR3	Accounted Year	nvarchar	4	0	CHAR	(N' ')	Yes		P25SOP_ACCOUNTED_YEAR	Allow NULL?
53	EXERCISE_DATE4	Exercise Date	nvarchar	8	0	DATS	(N'00000000')	Yes		P25SOP_EXERCISE_DATE	Allow NULL?
54	EXERCISE_PRICE4	Exercise Price	decimal	12	5	DEC	((0))	Yes		P25SOP_EXERCISE_PRICE
55	NO_STOCK_EXERC4	No of stocks Exercised	decimal	18	3	DEC	((0))	Yes		P25SOP_EXERC_NO
56	EXER_CURRENCY4	Currency key	nvarchar	5	0	CUKY	(N' ')	Yes	*	P25SOP_WAERS	Allow NULL?
57	EXER_MKT_PRICE4	Market Price at time of Exercise	decimal	12	5	DEC	((0))	Yes		P25SOP_EXERC_MKT_PRICE
58	HOLD_MKT_PRICE4	Market Price at the end of holding period	decimal	12	5	DEC	((0))	Yes		P25SOP_HOLD_MKT_PRICE
59	ACCOUNTED_YEAR4	Accounted Year	nvarchar	4	0	CHAR	(N' ')	Yes		P25SOP_ACCOUNTED_YEAR	Allow NULL?
60	EXERCISE_DATE5	Exercise Date	nvarchar	8	0	DATS	(N'00000000')	Yes		P25SOP_EXERCISE_DATE	Allow NULL?
61	EXERCISE_PRICE5	Exercise Price	decimal	12	5	DEC	((0))	Yes		P25SOP_EXERCISE_PRICE
62	NO_STOCK_EXERC5	No of stocks Exercised	decimal	18	3	DEC	((0))	Yes		P25SOP_EXERC_NO
63	EXER_CURRENCY5	Currency key	nvarchar	5	0	CUKY	(N' ')	Yes	*	P25SOP_WAERS	Allow NULL?
64	EXER_MKT_PRICE5	Market Price at time of Exercise	decimal	12	5	DEC	((0))	Yes		P25SOP_EXERC_MKT_PRICE
65	HOLD_MKT_PRICE5	Market Price at the end of holding period	decimal	12	5	DEC	((0))	Yes		P25SOP_HOLD_MKT_PRICE
66	ACCOUNTED_YEAR5	Accounted Year	nvarchar	4	0	CHAR	(N' ')	Yes		P25SOP_ACCOUNTED_YEAR	Allow NULL?
67	EXERCISE_DATE6	Exercise Date	nvarchar	8	0	DATS	(N'00000000')	Yes		P25SOP_EXERCISE_DATE	Allow NULL?
68	EXERCISE_PRICE6	Exercise Price	decimal	12	5	DEC	((0))	Yes		P25SOP_EXERCISE_PRICE
69	NO_STOCK_EXERC6	No of stocks Exercised	decimal	18	3	DEC	((0))	Yes		P25SOP_EXERC_NO
70	EXER_CURRENCY6	Currency key	nvarchar	5	0	CUKY	(N' ')	Yes	*	P25SOP_WAERS	Allow NULL?
71	EXER_MKT_PRICE6	Market Price at time of Exercise	decimal	12	5	DEC	((0))	Yes		P25SOP_EXERC_MKT_PRICE
72	HOLD_MKT_PRICE6	Market Price at the end of holding period	decimal	12	5	DEC	((0))	Yes		P25SOP_HOLD_MKT_PRICE
73	ACCOUNTED_YEAR6	Accounted Year	nvarchar	4	0	CHAR	(N' ')	Yes		P25SOP_ACCOUNTED_YEAR	Allow NULL?
74	EXERCISE_DATE7	Exercise Date	nvarchar	8	0	DATS	(N'00000000')	Yes		P25SOP_EXERCISE_DATE	Allow NULL?
75	EXERCISE_PRICE7	Exercise Price	decimal	12	5	DEC	((0))	Yes		P25SOP_EXERCISE_PRICE
76	NO_STOCK_EXERC7	No of stocks Exercised	decimal	18	3	DEC	((0))	Yes		P25SOP_EXERC_NO
77	EXER_CURRENCY7	Currency key	nvarchar	5	0	CUKY	(N' ')	Yes	*	P25SOP_WAERS	Allow NULL?
78	EXER_MKT_PRICE7	Market Price at time of Exercise	decimal	12	5	DEC	((0))	Yes		P25SOP_EXERC_MKT_PRICE
79	HOLD_MKT_PRICE7	Market Price at the end of holding period	decimal	12	5	DEC	((0))	Yes		P25SOP_HOLD_MKT_PRICE
80	ACCOUNTED_YEAR7	Accounted Year	nvarchar	4	0	CHAR	(N' ')	Yes		P25SOP_ACCOUNTED_YEAR	Allow NULL?
81	EXERCISE_DATE8	Exercise Date	nvarchar	8	0	DATS	(N'00000000')	Yes		P25SOP_EXERCISE_DATE	Allow NULL?
82	EXERCISE_PRICE8	Exercise Price	decimal	12	5	DEC	((0))	Yes		P25SOP_EXERCISE_PRICE
83	NO_STOCK_EXERC8	No of stocks Exercised	decimal	18	3	DEC	((0))	Yes		P25SOP_EXERC_NO
84	EXER_CURRENCY8	Currency key	nvarchar	5	0	CUKY	(N' ')	Yes	*	P25SOP_WAERS	Allow NULL?
85	EXER_MKT_PRICE8	Market Price at time of Exercise	decimal	12	5	DEC	((0))	Yes		P25SOP_EXERC_MKT_PRICE
86	HOLD_MKT_PRICE8	Market Price at the end of holding period	decimal	12	5	DEC	((0))	Yes		P25SOP_HOLD_MKT_PRICE
87	ACCOUNTED_YEAR8	Accounted Year	nvarchar	4	0	CHAR	(N' ')	Yes		P25SOP_ACCOUNTED_YEAR	Allow NULL?
88	EXERCISE_DATE9	Exercise Date	nvarchar	8	0	DATS	(N'00000000')	Yes		P25SOP_EXERCISE_DATE	Allow NULL?
89	EXERCISE_PRICE9	Exercise Price	decimal	12	5	DEC	((0))	Yes		P25SOP_EXERCISE_PRICE
90	NO_STOCK_EXERC9	No of stocks Exercised	decimal	18	3	DEC	((0))	Yes		P25SOP_EXERC_NO
91	EXER_CURRENCY9	Currency key	nvarchar	5	0	CUKY	(N' ')	Yes	*	P25SOP_WAERS	Allow NULL?
92	EXER_MKT_PRICE9	Market Price at time of Exercise	decimal	12	5	DEC	((0))	Yes		P25SOP_EXERC_MKT_PRICE
93	HOLD_MKT_PRICE9	Market Price at the end of holding period	decimal	12	5	DEC	((0))	Yes		P25SOP_HOLD_MKT_PRICE
94	ACCOUNTED_YEAR9	Accounted Year	nvarchar	4	0	CHAR	(N' ')	Yes		P25SOP_ACCOUNTED_YEAR	Allow NULL?
95	EXERCISE_DATE10	Exercise Date	nvarchar	8	0	DATS	(N'00000000')	Yes		P25SOP_EXERCISE_DATE	Allow NULL?
96	EXERCISE_PRICE10	Exercise Price	decimal	12	5	DEC	((0))	Yes		P25SOP_EXERCISE_PRICE
97	NO_STOCK_EXERC10	No of stocks Exercised	decimal	18	3	DEC	((0))	Yes		P25SOP_EXERC_NO
98	EXER_CURRENCY10	Currency key	nvarchar	5	0	CUKY	(N' ')	Yes	*	P25SOP_WAERS	Allow NULL?
99	EXER_MKT_PRICE10	Market Price at time of Exercise	decimal	12	5	DEC	((0))	Yes		P25SOP_EXERC_MKT_PRICE
100	HOLD_MKT_PRICE10	Market Price at the end of holding period	decimal	12	5	DEC	((0))	Yes		P25SOP_HOLD_MKT_PRICE
101	ACCOUNTED_YEAR10	Accounted Year	nvarchar	4	0	CHAR	(N' ')	Yes		P25SOP_ACCOUNTED_YEAR	Allow NULL?
102	EXERCISE_DATE11	Exercise Date	nvarchar	8	0	DATS	(N'00000000')	Yes		P25SOP_EXERCISE_DATE	Allow NULL?
103	EXERCISE_PRICE11	Exercise Price	decimal	12	5	DEC	((0))	Yes		P25SOP_EXERCISE_PRICE
104	NO_STOCK_EXERC11	No of stocks Exercised	decimal	18	3	DEC	((0))	Yes		P25SOP_EXERC_NO
105	EXER_CURRENCY11	Currency key	nvarchar	5	0	CUKY	(N' ')	Yes	*	P25SOP_WAERS	Allow NULL?
106	EXER_MKT_PRICE11	Market Price at time of Exercise	decimal	12	5	DEC	((0))	Yes		P25SOP_EXERC_MKT_PRICE
107	HOLD_MKT_PRICE11	Market Price at the end of holding period	decimal	12	5	DEC	((0))	Yes		P25SOP_HOLD_MKT_PRICE
108	ACCOUNTED_YEAR11	Accounted Year	nvarchar	4	0	CHAR	(N' ')	Yes		P25SOP_ACCOUNTED_YEAR	Allow NULL?
109	EXERCISE_DATE12	Exercise Date	nvarchar	8	0	DATS	(N'00000000')	Yes		P25SOP_EXERCISE_DATE	Allow NULL?
110	EXERCISE_PRICE12	Exercise Price	decimal	12	5	DEC	((0))	Yes		P25SOP_EXERCISE_PRICE
111	NO_STOCK_EXERC12	No of stocks Exercised	decimal	18	3	DEC	((0))	Yes		P25SOP_EXERC_NO
112	EXER_CURRENCY12	Currency key	nvarchar	5	0	CUKY	(N' ')	Yes	*	P25SOP_WAERS	Allow NULL?
113	EXER_MKT_PRICE12	Market Price at time of Exercise	decimal	12	5	DEC	((0))	Yes		P25SOP_EXERC_MKT_PRICE
114	HOLD_MKT_PRICE12	Market Price at the end of holding period	decimal	12	5	DEC	((0))	Yes		P25SOP_HOLD_MKT_PRICE
115	ACCOUNTED_YEAR12	Accounted Year	nvarchar	4	0	CHAR	(N' ')	Yes		P25SOP_ACCOUNTED_YEAR	Allow NULL?
116	EXERCISE_DATE13	Exercise Date	nvarchar	8	0	DATS	(N'00000000')	Yes		P25SOP_EXERCISE_DATE	Allow NULL?
117	EXERCISE_PRICE13	Exercise Price	decimal	12	5	DEC	((0))	Yes		P25SOP_EXERCISE_PRICE
118	NO_STOCK_EXERC13	No of stocks Exercised	decimal	18	3	DEC	((0))	Yes		P25SOP_EXERC_NO
119	EXER_CURRENCY13	Currency key	nvarchar	5	0	CUKY	(N' ')	Yes	*	P25SOP_WAERS	Allow NULL?
120	EXER_MKT_PRICE13	Market Price at time of Exercise	decimal	12	5	DEC	((0))	Yes		P25SOP_EXERC_MKT_PRICE
121	HOLD_MKT_PRICE13	Market Price at the end of holding period	decimal	12	5	DEC	((0))	Yes		P25SOP_HOLD_MKT_PRICE
122	ACCOUNTED_YEAR13	Accounted Year	nvarchar	4	0	CHAR	(N' ')	Yes		P25SOP_ACCOUNTED_YEAR	Allow NULL?
123	EXERCISE_DATE14	Exercise Date	nvarchar	8	0	DATS	(N'00000000')	Yes		P25SOP_EXERCISE_DATE	Allow NULL?
124	EXERCISE_PRICE14	Exercise Price	decimal	12	5	DEC	((0))	Yes		P25SOP_EXERCISE_PRICE
125	NO_STOCK_EXERC14	No of stocks Exercised	decimal	18	3	DEC	((0))	Yes		P25SOP_EXERC_NO
126	EXER_CURRENCY14	Currency key	nvarchar	5	0	CUKY	(N' ')	Yes	*	P25SOP_WAERS	Allow NULL?
127	EXER_MKT_PRICE14	Market Price at time of Exercise	decimal	12	5	DEC	((0))	Yes		P25SOP_EXERC_MKT_PRICE
128	HOLD_MKT_PRICE14	Market Price at the end of holding period	decimal	12	5	DEC	((0))	Yes		P25SOP_HOLD_MKT_PRICE
129	ACCOUNTED_YEAR14	Accounted Year	nvarchar	4	0	CHAR	(N' ')	Yes		P25SOP_ACCOUNTED_YEAR	Allow NULL?
130	EXERCISE_DATE15	Exercise Date	nvarchar	8	0	DATS	(N'00000000')	Yes		P25SOP_EXERCISE_DATE	Allow NULL?
131	EXERCISE_PRICE15	Exercise Price	decimal	12	5	DEC	((0))	Yes		P25SOP_EXERCISE_PRICE
132	NO_STOCK_EXERC15	No of stocks Exercised	decimal	18	3	DEC	((0))	Yes		P25SOP_EXERC_NO
133	EXER_CURRENCY15	Currency key	nvarchar	5	0	CUKY	(N' ')	Yes	*	P25SOP_WAERS	Allow NULL?
134	EXER_MKT_PRICE15	Market Price at time of Exercise	decimal	12	5	DEC	((0))	Yes		P25SOP_EXERC_MKT_PRICE
135	HOLD_MKT_PRICE15	Market Price at the end of holding period	decimal	12	5	DEC	((0))	Yes		P25SOP_HOLD_MKT_PRICE
136	ACCOUNTED_YEAR15	Accounted Year	nvarchar	4	0	CHAR	(N' ')	Yes		P25SOP_ACCOUNTED_YEAR	Allow NULL?
137	EXERCISE_DATE16	Exercise Date	nvarchar	8	0	DATS	(N'00000000')	Yes		P25SOP_EXERCISE_DATE	Allow NULL?
138	EXERCISE_PRICE16	Exercise Price	decimal	12	5	DEC	((0))	Yes		P25SOP_EXERCISE_PRICE
139	NO_STOCK_EXERC16	No of stocks Exercised	decimal	18	3	DEC	((0))	Yes		P25SOP_EXERC_NO
140	EXER_CURRENCY16	Currency key	nvarchar	5	0	CUKY	(N' ')	Yes	*	P25SOP_WAERS	Allow NULL?
141	EXER_MKT_PRICE16	Market Price at time of Exercise	decimal	12	5	DEC	((0))	Yes		P25SOP_EXERC_MKT_PRICE
142	HOLD_MKT_PRICE16	Market Price at the end of holding period	decimal	12	5	DEC	((0))	Yes		P25SOP_HOLD_MKT_PRICE
143	ACCOUNTED_YEAR16	Accounted Year	nvarchar	4	0	CHAR	(N' ')	Yes		P25SOP_ACCOUNTED_YEAR	Allow NULL?
144	EXERCISE_DATE17	Exercise Date	nvarchar	8	0	DATS	(N'00000000')	Yes		P25SOP_EXERCISE_DATE	Allow NULL?
145	EXERCISE_PRICE17	Exercise Price	decimal	12	5	DEC	((0))	Yes		P25SOP_EXERCISE_PRICE
146	NO_STOCK_EXERC17	No of stocks Exercised	decimal	18	3	DEC	((0))	Yes		P25SOP_EXERC_NO
147	EXER_CURRENCY17	Currency key	nvarchar	5	0	CUKY	(N' ')	Yes	*	P25SOP_WAERS	Allow NULL?
148	EXER_MKT_PRICE17	Market Price at time of Exercise	decimal	12	5	DEC	((0))	Yes		P25SOP_EXERC_MKT_PRICE
149	HOLD_MKT_PRICE17	Market Price at the end of holding period	decimal	12	5	DEC	((0))	Yes		P25SOP_HOLD_MKT_PRICE
150	ACCOUNTED_YEAR17	Accounted Year	nvarchar	4	0	CHAR	(N' ')	Yes		P25SOP_ACCOUNTED_YEAR	Allow NULL?
151	EXERCISE_DATE18	Exercise Date	nvarchar	8	0	DATS	(N'00000000')	Yes		P25SOP_EXERCISE_DATE	Allow NULL?
152	EXERCISE_PRICE18	Exercise Price	decimal	12	5	DEC	((0))	Yes		P25SOP_EXERCISE_PRICE
153	NO_STOCK_EXERC18	No of stocks Exercised	decimal	18	3	DEC	((0))	Yes		P25SOP_EXERC_NO
154	EXER_CURRENCY18	Currency key	nvarchar	5	0	CUKY	(N' ')	Yes	*	P25SOP_WAERS	Allow NULL?
155	EXER_MKT_PRICE18	Market Price at time of Exercise	decimal	12	5	DEC	((0))	Yes		P25SOP_EXERC_MKT_PRICE
156	HOLD_MKT_PRICE18	Market Price at the end of holding period	decimal	12	5	DEC	((0))	Yes		P25SOP_HOLD_MKT_PRICE
157	ACCOUNTED_YEAR18	Accounted Year	nvarchar	4	0	CHAR	(N' ')	Yes		P25SOP_ACCOUNTED_YEAR	Allow NULL?
158	EXERCISE_DATE19	Exercise Date	nvarchar	8	0	DATS	(N'00000000')	Yes		P25SOP_EXERCISE_DATE	Allow NULL?
159	EXERCISE_PRICE19	Exercise Price	decimal	12	5	DEC	((0))	Yes		P25SOP_EXERCISE_PRICE
160	NO_STOCK_EXERC19	No of stocks Exercised	decimal	18	3	DEC	((0))	Yes		P25SOP_EXERC_NO
161	EXER_CURRENCY19	Currency key	nvarchar	5	0	CUKY	(N' ')	Yes	*	P25SOP_WAERS	Allow NULL?
162	EXER_MKT_PRICE19	Market Price at time of Exercise	decimal	12	5	DEC	((0))	Yes		P25SOP_EXERC_MKT_PRICE
163	HOLD_MKT_PRICE19	Market Price at the end of holding period	decimal	12	5	DEC	((0))	Yes		P25SOP_HOLD_MKT_PRICE
164	ACCOUNTED_YEAR19	Accounted Year	nvarchar	4	0	CHAR	(N' ')	Yes		P25SOP_ACCOUNTED_YEAR	Allow NULL?
165	EXERCISE_DATE20	Exercise Date	nvarchar	8	0	DATS	(N'00000000')	Yes		P25SOP_EXERCISE_DATE	Allow NULL?
166	EXERCISE_PRICE20	Exercise Price	decimal	12	5	DEC	((0))	Yes		P25SOP_EXERCISE_PRICE
167	NO_STOCK_EXERC20	No of stocks Exercised	decimal	18	3	DEC	((0))	Yes		P25SOP_EXERC_NO
168	EXER_CURRENCY20	Currency key	nvarchar	5	0	CUKY	(N' ')	Yes	*	P25SOP_WAERS	Allow NULL?
169	EXER_MKT_PRICE20	Market Price at time of Exercise	decimal	12	5	DEC	((0))	Yes		P25SOP_EXERC_MKT_PRICE
170	HOLD_MKT_PRICE20	Market Price at the end of holding period	decimal	12	5	DEC	((0))	Yes		P25SOP_HOLD_MKT_PRICE
171	ACCOUNTED_YEAR20	Accounted Year	nvarchar	4	0	CHAR	(N' ')	Yes		P25SOP_ACCOUNTED_YEAR	Allow NULL?
172	SING_GRANT_FLAG	Singapore tracking of grant	char	1	0	CHAR	(N' ')	Yes		P25SOP_SG_GNT_FL	Allow NULL?
173	AC_EX_DATE1	Exercise Date	nvarchar	8	0	DATS	(N'00000000')	Yes		P25SOP_EXERCISE_DATE	Allow NULL?
174	DE_EX_DATE1	Deemed Exercise Date	nvarchar	8	0	DATS	(N'00000000')	Yes		P25SOP_DE_EX_DATE	Allow NULL?
175	AC_EX_DATE2	Exercise Date	nvarchar	8	0	DATS	(N'00000000')	Yes		P25SOP_EXERCISE_DATE	Allow NULL?
176	DE_EX_DATE2	Deemed Exercise Date	nvarchar	8	0	DATS	(N'00000000')	Yes		P25SOP_DE_EX_DATE	Allow NULL?
177	AC_EX_DATE3	Exercise Date	nvarchar	8	0	DATS	(N'00000000')	Yes		P25SOP_EXERCISE_DATE	Allow NULL?
178	DE_EX_DATE3	Deemed Exercise Date	nvarchar	8	0	DATS	(N'00000000')	Yes		P25SOP_DE_EX_DATE	Allow NULL?
179	AC_EX_DATE4	Exercise Date	nvarchar	8	0	DATS	(N'00000000')	Yes		P25SOP_EXERCISE_DATE	Allow NULL?
180	DE_EX_DATE4	Deemed Exercise Date	nvarchar	8	0	DATS	(N'00000000')	Yes		P25SOP_DE_EX_DATE	Allow NULL?
181	AC_EX_DATE5	Exercise Date	nvarchar	8	0	DATS	(N'00000000')	Yes		P25SOP_EXERCISE_DATE	Allow NULL?
182	DE_EX_DATE5	Deemed Exercise Date	nvarchar	8	0	DATS	(N'00000000')	Yes		P25SOP_DE_EX_DATE	Allow NULL?
183	AC_EX_DATE6	Exercise Date	nvarchar	8	0	DATS	(N'00000000')	Yes		P25SOP_EXERCISE_DATE	Allow NULL?
184	DE_EX_DATE6	Deemed Exercise Date	nvarchar	8	0	DATS	(N'00000000')	Yes		P25SOP_DE_EX_DATE	Allow NULL?
185	AC_EX_DATE7	Exercise Date	nvarchar	8	0	DATS	(N'00000000')	Yes		P25SOP_EXERCISE_DATE	Allow NULL?
186	DE_EX_DATE7	Deemed Exercise Date	nvarchar	8	0	DATS	(N'00000000')	Yes		P25SOP_DE_EX_DATE	Allow NULL?
187	AC_EX_DATE8	Exercise Date	nvarchar	8	0	DATS	(N'00000000')	Yes		P25SOP_EXERCISE_DATE	Allow NULL?
188	DE_EX_DATE8	Deemed Exercise Date	nvarchar	8	0	DATS	(N'00000000')	Yes		P25SOP_DE_EX_DATE	Allow NULL?
189	AC_EX_DATE9	Exercise Date	nvarchar	8	0	DATS	(N'00000000')	Yes		P25SOP_EXERCISE_DATE	Allow NULL?
190	DE_EX_DATE9	Deemed Exercise Date	nvarchar	8	0	DATS	(N'00000000')	Yes		P25SOP_DE_EX_DATE	Allow NULL?
191	AC_EX_DATE10	Exercise Date	nvarchar	8	0	DATS	(N'00000000')	Yes		P25SOP_EXERCISE_DATE	Allow NULL?
192	DE_EX_DATE10	Deemed Exercise Date	nvarchar	8	0	DATS	(N'00000000')	Yes		P25SOP_DE_EX_DATE	Allow NULL?
193	AC_EX_DATE11	Exercise Date	nvarchar	8	0	DATS	(N'00000000')	Yes		P25SOP_EXERCISE_DATE	Allow NULL?
194	DE_EX_DATE11	Deemed Exercise Date	nvarchar	8	0	DATS	(N'00000000')	Yes		P25SOP_DE_EX_DATE	Allow NULL?
195	AC_EX_DATE12	Exercise Date	nvarchar	8	0	DATS	(N'00000000')	Yes		P25SOP_EXERCISE_DATE	Allow NULL?
196	DE_EX_DATE12	Deemed Exercise Date	nvarchar	8	0	DATS	(N'00000000')	Yes		P25SOP_DE_EX_DATE	Allow NULL?
197	AC_EX_DATE13	Exercise Date	nvarchar	8	0	DATS	(N'00000000')	Yes		P25SOP_EXERCISE_DATE	Allow NULL?
198	DE_EX_DATE13	Deemed Exercise Date	nvarchar	8	0	DATS	(N'00000000')	Yes		P25SOP_DE_EX_DATE	Allow NULL?
199	AC_EX_DATE14	Exercise Date	nvarchar	8	0	DATS	(N'00000000')	Yes		P25SOP_EXERCISE_DATE	Allow NULL?
200	DE_EX_DATE14	Deemed Exercise Date	nvarchar	8	0	DATS	(N'00000000')	Yes		P25SOP_DE_EX_DATE	Allow NULL?
201	AC_EX_DATE15	Exercise Date	nvarchar	8	0	DATS	(N'00000000')	Yes		P25SOP_EXERCISE_DATE	Allow NULL?
202	DE_EX_DATE15	Deemed Exercise Date	nvarchar	8	0	DATS	(N'00000000')	Yes		P25SOP_DE_EX_DATE	Allow NULL?
203	AC_EX_DATE16	Exercise Date	nvarchar	8	0	DATS	(N'00000000')	Yes		P25SOP_EXERCISE_DATE	Allow NULL?
204	DE_EX_DATE16	Deemed Exercise Date	nvarchar	8	0	DATS	(N'00000000')	Yes		P25SOP_DE_EX_DATE	Allow NULL?
205	AC_EX_DATE17	Exercise Date	nvarchar	8	0	DATS	(N'00000000')	Yes		P25SOP_EXERCISE_DATE	Allow NULL?
206	DE_EX_DATE17	Deemed Exercise Date	nvarchar	8	0	DATS	(N'00000000')	Yes		P25SOP_DE_EX_DATE	Allow NULL?
207	AC_EX_DATE18	Exercise Date	nvarchar	8	0	DATS	(N'00000000')	Yes		P25SOP_EXERCISE_DATE	Allow NULL?
208	DE_EX_DATE18	Deemed Exercise Date	nvarchar	8	0	DATS	(N'00000000')	Yes		P25SOP_DE_EX_DATE	Allow NULL?
209	AC_EX_DATE19	Exercise Date	nvarchar	8	0	DATS	(N'00000000')	Yes		P25SOP_EXERCISE_DATE	Allow NULL?
210	DE_EX_DATE19	Deemed Exercise Date	nvarchar	8	0	DATS	(N'00000000')	Yes		P25SOP_DE_EX_DATE	Allow NULL?
211	AC_EX_DATE20	Exercise Date	nvarchar	8	0	DATS	(N'00000000')	Yes		P25SOP_EXERCISE_DATE	Allow NULL?
212	DE_EX_DATE20	Deemed Exercise Date	nvarchar	8	0	DATS	(N'00000000')	Yes		P25SOP_DE_EX_DATE	Allow NULL?

TOP ERP 6.0 | PA0739 INDEXES

Name	Primary	Unique	Type	Columns
PA0739~0	Yes	Yes	CLUSTERED	SEQNR, BEGDA, ENDDA, SPRPS, OBJPS, SUBTY, PERNR, MANDT

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

212 COLUMNS | 1 INDEXES | ERP 6.0 | PA0739 TABLE

TOP ERP 6.0 | PA0739 COLUMNS

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

212 COLUMNS | 1 INDEXES | ERP 6.0 | PA0739 TABLE

TOPERP 6.0 | PA0739 COLUMNS

TOPERP 6.0 | PA0739 INDEXES

TOP ERP 6.0 | PA0739 COLUMNS

TOP ERP 6.0 | PA0739 INDEXES