SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5OJDT100Journal Entry
6INV1265A/R Invoice - Rows
7OPCH386A/P Invoice
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data
Personnel Management :: Personnel Administration :: Singapore
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0PA07392121HR 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
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2PERNRPersonnel numbernvarchar80 Allow NULL? 
3SUBTYSubtypenvarchar40 Allow NULL? 
4OBJPSObject Identificationnvarchar20 Allow NULL? 
5SPRPSLock Indicator for HR Master Data Recordchar10 Allow NULL? 
6ENDDAEnd Datenvarchar80 Allow NULL? 
7BEGDAStart Datenvarchar80 Allow NULL? 
8SEQNRNumber of Infotype Record with Same Keynvarchar30 Allow NULL? 
9AEDTMChanged Onnvarchar80 Allow NULL? 
10UNAMEName of Person Who Changed Objectnvarchar120 Allow NULL? 
11HISTOHistorical Record Flagchar10 Allow NULL? 
12ITXEXText Exists for Infotypechar10 Allow NULL? 
13REFEXReference Fields Exist (Primary/Secondary Costs)char10 Allow NULL? 
14ORDEXConfirmation Fields Existchar10 Allow NULL? 
15ITBLDInfotype Screen Controlnvarchar20 Allow NULL? 
16PREASReason for Changing Master Datanvarchar20 Allow NULL? 
17FLAG1Reserved Field/Unused Fieldchar10 Allow NULL? 
18FLAG2Reserved Field/Unused Fieldchar10 Allow NULL? 
19FLAG3Reserved Field/Unused Fieldchar10 Allow NULL? 
20FLAG4Reserved Field/Unused Fieldchar10 Allow NULL? 
21RESE1Reserved Field/Unused Field of Length 2nvarchar20 Allow NULL? 
22RESE2Reserved Field/Unused Field of Length 2nvarchar20 Allow NULL? 
23GRPVLGrouping Value for Personnel Assignmentsnvarchar40 Allow NULL? 
24SCHEME_IDStock Option Plannvarchar40 Allow NULL? 
25PLAN_IDStock Option Schemenvarchar60 Allow NULL? 
26NO_STOCKS_GRANTNumber of stocks Granteddecimal183
27GRANT_CURRENCYCurrency keynvarchar50 Allow NULL? 
28GRANT_PRICEStock Option Grant Pricedecimal125
29GRANT_MKT_PRICEMarket Price at time of Grantdecimal125
30RCB_NORCB No for the Companynvarchar120 Allow NULL? 
31COMPANY_NAMECompany Name for Stock Optionsnvarchar400 Allow NULL? 
32EXERCISE_DATE1Exercise Datenvarchar80 Allow NULL? 
33EXERCISE_PRICE1Exercise Pricedecimal125
34NO_STOCK_EXERC1No of stocks Exerciseddecimal183
35EXER_CURRENCY1Currency keynvarchar50 Allow NULL? 
36EXER_MKT_PRICE1Market Price at time of Exercisedecimal125
37HOLD_MKT_PRICE1Market Price at the end of holding perioddecimal125
38ACCOUNTED_YEAR1Accounted Yearnvarchar40 Allow NULL? 
39EXERCISE_DATE2Exercise Datenvarchar80 Allow NULL? 
40EXERCISE_PRICE2Exercise Pricedecimal125
41NO_STOCK_EXERC2No of stocks Exerciseddecimal183
42EXER_CURRENCY2Currency keynvarchar50 Allow NULL? 
43EXER_MKT_PRICE2Market Price at time of Exercisedecimal125
44HOLD_MKT_PRICE2Market Price at the end of holding perioddecimal125
45ACCOUNTED_YEAR2Accounted Yearnvarchar40 Allow NULL? 
46EXERCISE_DATE3Exercise Datenvarchar80 Allow NULL? 
47EXERCISE_PRICE3Exercise Pricedecimal125
48NO_STOCK_EXERC3No of stocks Exerciseddecimal183
49EXER_CURRENCY3Currency keynvarchar50 Allow NULL? 
50EXER_MKT_PRICE3Market Price at time of Exercisedecimal125
51HOLD_MKT_PRICE3Market Price at the end of holding perioddecimal125
52ACCOUNTED_YEAR3Accounted Yearnvarchar40 Allow NULL? 
53EXERCISE_DATE4Exercise Datenvarchar80 Allow NULL? 
54EXERCISE_PRICE4Exercise Pricedecimal125
55NO_STOCK_EXERC4No of stocks Exerciseddecimal183
56EXER_CURRENCY4Currency keynvarchar50 Allow NULL? 
57EXER_MKT_PRICE4Market Price at time of Exercisedecimal125
58HOLD_MKT_PRICE4Market Price at the end of holding perioddecimal125
59ACCOUNTED_YEAR4Accounted Yearnvarchar40 Allow NULL? 
60EXERCISE_DATE5Exercise Datenvarchar80 Allow NULL? 
61EXERCISE_PRICE5Exercise Pricedecimal125
62NO_STOCK_EXERC5No of stocks Exerciseddecimal183
63EXER_CURRENCY5Currency keynvarchar50 Allow NULL? 
64EXER_MKT_PRICE5Market Price at time of Exercisedecimal125
65HOLD_MKT_PRICE5Market Price at the end of holding perioddecimal125
66ACCOUNTED_YEAR5Accounted Yearnvarchar40 Allow NULL? 
67EXERCISE_DATE6Exercise Datenvarchar80 Allow NULL? 
68EXERCISE_PRICE6Exercise Pricedecimal125
69NO_STOCK_EXERC6No of stocks Exerciseddecimal183
70EXER_CURRENCY6Currency keynvarchar50 Allow NULL? 
71EXER_MKT_PRICE6Market Price at time of Exercisedecimal125
72HOLD_MKT_PRICE6Market Price at the end of holding perioddecimal125
73ACCOUNTED_YEAR6Accounted Yearnvarchar40 Allow NULL? 
74EXERCISE_DATE7Exercise Datenvarchar80 Allow NULL? 
75EXERCISE_PRICE7Exercise Pricedecimal125
76NO_STOCK_EXERC7No of stocks Exerciseddecimal183
77EXER_CURRENCY7Currency keynvarchar50 Allow NULL? 
78EXER_MKT_PRICE7Market Price at time of Exercisedecimal125
79HOLD_MKT_PRICE7Market Price at the end of holding perioddecimal125
80ACCOUNTED_YEAR7Accounted Yearnvarchar40 Allow NULL? 
81EXERCISE_DATE8Exercise Datenvarchar80 Allow NULL? 
82EXERCISE_PRICE8Exercise Pricedecimal125
83NO_STOCK_EXERC8No of stocks Exerciseddecimal183
84EXER_CURRENCY8Currency keynvarchar50 Allow NULL? 
85EXER_MKT_PRICE8Market Price at time of Exercisedecimal125
86HOLD_MKT_PRICE8Market Price at the end of holding perioddecimal125
87ACCOUNTED_YEAR8Accounted Yearnvarchar40 Allow NULL? 
88EXERCISE_DATE9Exercise Datenvarchar80 Allow NULL? 
89EXERCISE_PRICE9Exercise Pricedecimal125
90NO_STOCK_EXERC9No of stocks Exerciseddecimal183
91EXER_CURRENCY9Currency keynvarchar50 Allow NULL? 
92EXER_MKT_PRICE9Market Price at time of Exercisedecimal125
93HOLD_MKT_PRICE9Market Price at the end of holding perioddecimal125
94ACCOUNTED_YEAR9Accounted Yearnvarchar40 Allow NULL? 
95EXERCISE_DATE10Exercise Datenvarchar80 Allow NULL? 
96EXERCISE_PRICE10Exercise Pricedecimal125
97NO_STOCK_EXERC10No of stocks Exerciseddecimal183
98EXER_CURRENCY10Currency keynvarchar50 Allow NULL? 
99EXER_MKT_PRICE10Market Price at time of Exercisedecimal125
100HOLD_MKT_PRICE10Market Price at the end of holding perioddecimal125
101ACCOUNTED_YEAR10Accounted Yearnvarchar40 Allow NULL? 
102EXERCISE_DATE11Exercise Datenvarchar80 Allow NULL? 
103EXERCISE_PRICE11Exercise Pricedecimal125
104NO_STOCK_EXERC11No of stocks Exerciseddecimal183
105EXER_CURRENCY11Currency keynvarchar50 Allow NULL? 
106EXER_MKT_PRICE11Market Price at time of Exercisedecimal125
107HOLD_MKT_PRICE11Market Price at the end of holding perioddecimal125
108ACCOUNTED_YEAR11Accounted Yearnvarchar40 Allow NULL? 
109EXERCISE_DATE12Exercise Datenvarchar80 Allow NULL? 
110EXERCISE_PRICE12Exercise Pricedecimal125
111NO_STOCK_EXERC12No of stocks Exerciseddecimal183
112EXER_CURRENCY12Currency keynvarchar50 Allow NULL? 
113EXER_MKT_PRICE12Market Price at time of Exercisedecimal125
114HOLD_MKT_PRICE12Market Price at the end of holding perioddecimal125
115ACCOUNTED_YEAR12Accounted Yearnvarchar40 Allow NULL? 
116EXERCISE_DATE13Exercise Datenvarchar80 Allow NULL? 
117EXERCISE_PRICE13Exercise Pricedecimal125
118NO_STOCK_EXERC13No of stocks Exerciseddecimal183
119EXER_CURRENCY13Currency keynvarchar50 Allow NULL? 
120EXER_MKT_PRICE13Market Price at time of Exercisedecimal125
121HOLD_MKT_PRICE13Market Price at the end of holding perioddecimal125
122ACCOUNTED_YEAR13Accounted Yearnvarchar40 Allow NULL? 
123EXERCISE_DATE14Exercise Datenvarchar80 Allow NULL? 
124EXERCISE_PRICE14Exercise Pricedecimal125
125NO_STOCK_EXERC14No of stocks Exerciseddecimal183
126EXER_CURRENCY14Currency keynvarchar50 Allow NULL? 
127EXER_MKT_PRICE14Market Price at time of Exercisedecimal125
128HOLD_MKT_PRICE14Market Price at the end of holding perioddecimal125
129ACCOUNTED_YEAR14Accounted Yearnvarchar40 Allow NULL? 
130EXERCISE_DATE15Exercise Datenvarchar80 Allow NULL? 
131EXERCISE_PRICE15Exercise Pricedecimal125
132NO_STOCK_EXERC15No of stocks Exerciseddecimal183
133EXER_CURRENCY15Currency keynvarchar50 Allow NULL? 
134EXER_MKT_PRICE15Market Price at time of Exercisedecimal125
135HOLD_MKT_PRICE15Market Price at the end of holding perioddecimal125
136ACCOUNTED_YEAR15Accounted Yearnvarchar40 Allow NULL? 
137EXERCISE_DATE16Exercise Datenvarchar80 Allow NULL? 
138EXERCISE_PRICE16Exercise Pricedecimal125
139NO_STOCK_EXERC16No of stocks Exerciseddecimal183
140EXER_CURRENCY16Currency keynvarchar50 Allow NULL? 
141EXER_MKT_PRICE16Market Price at time of Exercisedecimal125
142HOLD_MKT_PRICE16Market Price at the end of holding perioddecimal125
143ACCOUNTED_YEAR16Accounted Yearnvarchar40 Allow NULL? 
144EXERCISE_DATE17Exercise Datenvarchar80 Allow NULL? 
145EXERCISE_PRICE17Exercise Pricedecimal125
146NO_STOCK_EXERC17No of stocks Exerciseddecimal183
147EXER_CURRENCY17Currency keynvarchar50 Allow NULL? 
148EXER_MKT_PRICE17Market Price at time of Exercisedecimal125
149HOLD_MKT_PRICE17Market Price at the end of holding perioddecimal125
150ACCOUNTED_YEAR17Accounted Yearnvarchar40 Allow NULL? 
151EXERCISE_DATE18Exercise Datenvarchar80 Allow NULL? 
152EXERCISE_PRICE18Exercise Pricedecimal125
153NO_STOCK_EXERC18No of stocks Exerciseddecimal183
154EXER_CURRENCY18Currency keynvarchar50 Allow NULL? 
155EXER_MKT_PRICE18Market Price at time of Exercisedecimal125
156HOLD_MKT_PRICE18Market Price at the end of holding perioddecimal125
157ACCOUNTED_YEAR18Accounted Yearnvarchar40 Allow NULL? 
158EXERCISE_DATE19Exercise Datenvarchar80 Allow NULL? 
159EXERCISE_PRICE19Exercise Pricedecimal125
160NO_STOCK_EXERC19No of stocks Exerciseddecimal183
161EXER_CURRENCY19Currency keynvarchar50 Allow NULL? 
162EXER_MKT_PRICE19Market Price at time of Exercisedecimal125
163HOLD_MKT_PRICE19Market Price at the end of holding perioddecimal125
164ACCOUNTED_YEAR19Accounted Yearnvarchar40 Allow NULL? 
165EXERCISE_DATE20Exercise Datenvarchar80 Allow NULL? 
166EXERCISE_PRICE20Exercise Pricedecimal125
167NO_STOCK_EXERC20No of stocks Exerciseddecimal183
168EXER_CURRENCY20Currency keynvarchar50 Allow NULL? 
169EXER_MKT_PRICE20Market Price at time of Exercisedecimal125
170HOLD_MKT_PRICE20Market Price at the end of holding perioddecimal125
171ACCOUNTED_YEAR20Accounted Yearnvarchar40 Allow NULL? 
172SING_GRANT_FLAGSingapore tracking of grantchar10 Allow NULL? 
173AC_EX_DATE1Exercise Datenvarchar80 Allow NULL? 
174DE_EX_DATE1Deemed Exercise Datenvarchar80 Allow NULL? 
175AC_EX_DATE2Exercise Datenvarchar80 Allow NULL? 
176DE_EX_DATE2Deemed Exercise Datenvarchar80 Allow NULL? 
177AC_EX_DATE3Exercise Datenvarchar80 Allow NULL? 
178DE_EX_DATE3Deemed Exercise Datenvarchar80 Allow NULL? 
179AC_EX_DATE4Exercise Datenvarchar80 Allow NULL? 
180DE_EX_DATE4Deemed Exercise Datenvarchar80 Allow NULL? 
181AC_EX_DATE5Exercise Datenvarchar80 Allow NULL? 
182DE_EX_DATE5Deemed Exercise Datenvarchar80 Allow NULL? 
183AC_EX_DATE6Exercise Datenvarchar80 Allow NULL? 
184DE_EX_DATE6Deemed Exercise Datenvarchar80 Allow NULL? 
185AC_EX_DATE7Exercise Datenvarchar80 Allow NULL? 
186DE_EX_DATE7Deemed Exercise Datenvarchar80 Allow NULL? 
187AC_EX_DATE8Exercise Datenvarchar80 Allow NULL? 
188DE_EX_DATE8Deemed Exercise Datenvarchar80 Allow NULL? 
189AC_EX_DATE9Exercise Datenvarchar80 Allow NULL? 
190DE_EX_DATE9Deemed Exercise Datenvarchar80 Allow NULL? 
191AC_EX_DATE10Exercise Datenvarchar80 Allow NULL? 
192DE_EX_DATE10Deemed Exercise Datenvarchar80 Allow NULL? 
193AC_EX_DATE11Exercise Datenvarchar80 Allow NULL? 
194DE_EX_DATE11Deemed Exercise Datenvarchar80 Allow NULL? 
195AC_EX_DATE12Exercise Datenvarchar80 Allow NULL? 
196DE_EX_DATE12Deemed Exercise Datenvarchar80 Allow NULL? 
197AC_EX_DATE13Exercise Datenvarchar80 Allow NULL? 
198DE_EX_DATE13Deemed Exercise Datenvarchar80 Allow NULL? 
199AC_EX_DATE14Exercise Datenvarchar80 Allow NULL? 
200DE_EX_DATE14Deemed Exercise Datenvarchar80 Allow NULL? 
201AC_EX_DATE15Exercise Datenvarchar80 Allow NULL? 
202DE_EX_DATE15Deemed Exercise Datenvarchar80 Allow NULL? 
203AC_EX_DATE16Exercise Datenvarchar80 Allow NULL? 
204DE_EX_DATE16Deemed Exercise Datenvarchar80 Allow NULL? 
205AC_EX_DATE17Exercise Datenvarchar80 Allow NULL? 
206DE_EX_DATE17Deemed Exercise Datenvarchar80 Allow NULL? 
207AC_EX_DATE18Exercise Datenvarchar80 Allow NULL? 
208DE_EX_DATE18Deemed Exercise Datenvarchar80 Allow NULL? 
209AC_EX_DATE19Exercise Datenvarchar80 Allow NULL? 
210DE_EX_DATE19Deemed Exercise Datenvarchar80 Allow NULL? 
211AC_EX_DATE20Exercise Datenvarchar80 Allow NULL? 
212DE_EX_DATE20Deemed Exercise Datenvarchar80 Allow NULL? 
NamePrimaryUniqueTypeColumns
PA0739~0YesYesCLUSTEREDSEQNR, BEGDA, ENDDA, SPRPS, OBJPS, SUBTY, PERNR, MANDT