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 :: South Africa
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0PA32022391HR Master Record: Infotype 3202South Africa
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, LRTYP, STATU, CASNR, REASN, DATEP, EXTRF, PARES01, PAOBT01, PAOBJ01, PAROL01, PABEG01, PAEND01, PARES02, PAOBT02, PAOBJ02, PAROL02, PABEG02, PAEND02, PARES03, PAOBT03, PAOBJ03, PAROL03, PABEG03, PAEND03, PARES04, PAOBT04, PAOBJ04, PAROL04, PABEG04, PAEND04, PARES05, PAOBT05, PAOBJ05, PAROL05, PABEG05, PAEND05, PARES06, PAOBT06, PAOBJ06, PAROL06, PABEG06, PAEND06, PARES07, PAOBT07, PAOBJ07, PAROL07, PABEG07, PAEND07, PARES08, PAOBT08, PAOBJ08, PAROL08, PABEG08, PAEND08, PARES09, PAOBT09, PAOBJ09, PAROL09, PABEG09, PAEND09, PARES10, PAOBT10, PAOBJ10, PAROL10, PABEG10, PAEND10, PARES11, PAOBT11, PAOBJ11, PAROL11, PABEG11, PAEND11, PARES12, PAOBT12, PAOBJ12, PAROL12, PABEG12, PAEND12, PARES13, PAOBT13, PAOBJ13, PAROL13, PABEG13, PAEND13, PARES14, PAOBT14, PAOBJ14, PAROL14, PABEG14, PAEND14, PARES15, PAOBT15, PAOBJ15, PAROL15, PABEG15, PAEND15, PRSTA01, PRBEG01, PREND01, PRREA01, PRSTA02, PRBEG02, PREND02, PRREA02, PRSTA03, PRBEG03, PREND03, PRREA03, PRSTA04, PRBEG04, PREND04, PRREA04, PRSTA05, PRBEG05, PREND05, PRREA05, PRSTA06, PRBEG06, PREND06, PRREA06, PRSTA07, PRBEG07, PREND07, PRREA07, PRSTA08, PRBEG08, PREND08, PRREA08, PRSTA09, PRBEG09, PREND09, PRREA09, PRSTA10, PRBEG10, PREND10, PRREA10, PRSTA11, PRBEG11, PREND11, PRREA11, PRSTA12, PRBEG12, PREND12, PRREA12, PRSTA13, PRBEG13, PREND13, PRREA13, PRSTA14, PRBEG14, PREND14, PRREA14, PRSTA15, PRBEG15, PREND15, PRREA15, OCTYP01, OCBEG01, OCEND01, OCAGR01, OCTYP02, OCBEG02, OCEND02, OCAGR02, OCTYP03, OCBEG03, OCEND03, OCAGR03, OCTYP04, OCBEG04, OCEND04, OCAGR04, OCTYP05, OCBEG05, OCEND05, OCAGR05, OCTYP06, OCBEG06, OCEND06, OCAGR06, OCTYP07, OCBEG07, OCEND07, OCAGR07, OCTYP08, OCBEG08, OCEND08, OCAGR08, OCTYP09, OCBEG09, OCEND09, OCAGR09, OCTYP10, OCBEG10, OCEND10, OCAGR10, OCTYP11, OCBEG11, OCEND11, OCAGR11, OCTYP12, OCBEG12, OCEND12, OCAGR12, OCTYP13, OCBEG13, OCEND13, OCAGR13, OCTYP14, OCBEG14, OCEND14, OCAGR14, OCTYP15, OCBEG15, OCEND15, OCAGR15 FROM PA3202
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? 
24LRTYPLabour Relations Typenvarchar40 Allow NULL? 
25STATUStatus/Level of Labour Relations Interventionnvarchar30 Allow NULL? 
26CASNRCase Number (Labour Relations ZA)nvarchar120 Allow NULL? 
27REASNReason for / Nature of Labour Relations interventionnvarchar30 Allow NULL? 
28DATEPActual date of act/omission/misconductnvarchar80 Allow NULL? 
29EXTRFExternal Case/Reference numbernvarchar200 Allow NULL? 
30PARES01Current responsible party for a Lab.Rel casechar10 Allow NULL? 
31PAOBT01Object Typenvarchar20 Allow NULL? 
32PAOBJ01Object IDnvarchar80 Allow NULL? 
33PAROL01Participating Role in Labour Relation Interventionnvarchar30 Allow NULL? 
34PABEG01LR Participant : Begin date of participationnvarchar80 Allow NULL? 
35PAEND01LR Participant : End date of participationnvarchar80 Allow NULL? 
36PARES02Current responsible party for a Lab.Rel casechar10 Allow NULL? 
37PAOBT02Object Typenvarchar20 Allow NULL? 
38PAOBJ02Object IDnvarchar80 Allow NULL? 
39PAROL02Participating Role in Labour Relation Interventionnvarchar30 Allow NULL? 
40PABEG02LR Participant : Begin date of participationnvarchar80 Allow NULL? 
41PAEND02LR Participant : End date of participationnvarchar80 Allow NULL? 
42PARES03Current responsible party for a Lab.Rel casechar10 Allow NULL? 
43PAOBT03Object Typenvarchar20 Allow NULL? 
44PAOBJ03Object IDnvarchar80 Allow NULL? 
45PAROL03Participating Role in Labour Relation Interventionnvarchar30 Allow NULL? 
46PABEG03LR Participant : Begin date of participationnvarchar80 Allow NULL? 
47PAEND03LR Participant : End date of participationnvarchar80 Allow NULL? 
48PARES04Current responsible party for a Lab.Rel casechar10 Allow NULL? 
49PAOBT04Object Typenvarchar20 Allow NULL? 
50PAOBJ04Object IDnvarchar80 Allow NULL? 
51PAROL04Participating Role in Labour Relation Interventionnvarchar30 Allow NULL? 
52PABEG04LR Participant : Begin date of participationnvarchar80 Allow NULL? 
53PAEND04LR Participant : End date of participationnvarchar80 Allow NULL? 
54PARES05Current responsible party for a Lab.Rel casechar10 Allow NULL? 
55PAOBT05Object Typenvarchar20 Allow NULL? 
56PAOBJ05Object IDnvarchar80 Allow NULL? 
57PAROL05Participating Role in Labour Relation Interventionnvarchar30 Allow NULL? 
58PABEG05LR Participant : Begin date of participationnvarchar80 Allow NULL? 
59PAEND05LR Participant : End date of participationnvarchar80 Allow NULL? 
60PARES06Current responsible party for a Lab.Rel casechar10 Allow NULL? 
61PAOBT06Object Typenvarchar20 Allow NULL? 
62PAOBJ06Object IDnvarchar80 Allow NULL? 
63PAROL06Participating Role in Labour Relation Interventionnvarchar30 Allow NULL? 
64PABEG06LR Participant : Begin date of participationnvarchar80 Allow NULL? 
65PAEND06LR Participant : End date of participationnvarchar80 Allow NULL? 
66PARES07Current responsible party for a Lab.Rel casechar10 Allow NULL? 
67PAOBT07Object Typenvarchar20 Allow NULL? 
68PAOBJ07Object IDnvarchar80 Allow NULL? 
69PAROL07Participating Role in Labour Relation Interventionnvarchar30 Allow NULL? 
70PABEG07LR Participant : Begin date of participationnvarchar80 Allow NULL? 
71PAEND07LR Participant : End date of participationnvarchar80 Allow NULL? 
72PARES08Current responsible party for a Lab.Rel casechar10 Allow NULL? 
73PAOBT08Object Typenvarchar20 Allow NULL? 
74PAOBJ08Object IDnvarchar80 Allow NULL? 
75PAROL08Participating Role in Labour Relation Interventionnvarchar30 Allow NULL? 
76PABEG08LR Participant : Begin date of participationnvarchar80 Allow NULL? 
77PAEND08LR Participant : End date of participationnvarchar80 Allow NULL? 
78PARES09Current responsible party for a Lab.Rel casechar10 Allow NULL? 
79PAOBT09Object Typenvarchar20 Allow NULL? 
80PAOBJ09Object IDnvarchar80 Allow NULL? 
81PAROL09Participating Role in Labour Relation Interventionnvarchar30 Allow NULL? 
82PABEG09LR Participant : Begin date of participationnvarchar80 Allow NULL? 
83PAEND09LR Participant : End date of participationnvarchar80 Allow NULL? 
84PARES10Current responsible party for a Lab.Rel casechar10 Allow NULL? 
85PAOBT10Object Typenvarchar20 Allow NULL? 
86PAOBJ10Object IDnvarchar80 Allow NULL? 
87PAROL10Participating Role in Labour Relation Interventionnvarchar30 Allow NULL? 
88PABEG10LR Participant : Begin date of participationnvarchar80 Allow NULL? 
89PAEND10LR Participant : End date of participationnvarchar80 Allow NULL? 
90PARES11Current responsible party for a Lab.Rel casechar10 Allow NULL? 
91PAOBT11Object Typenvarchar20 Allow NULL? 
92PAOBJ11Object IDnvarchar80 Allow NULL? 
93PAROL11Participating Role in Labour Relation Interventionnvarchar30 Allow NULL? 
94PABEG11LR Participant : Begin date of participationnvarchar80 Allow NULL? 
95PAEND11LR Participant : End date of participationnvarchar80 Allow NULL? 
96PARES12Current responsible party for a Lab.Rel casechar10 Allow NULL? 
97PAOBT12Object Typenvarchar20 Allow NULL? 
98PAOBJ12Object IDnvarchar80 Allow NULL? 
99PAROL12Participating Role in Labour Relation Interventionnvarchar30 Allow NULL? 
100PABEG12LR Participant : Begin date of participationnvarchar80 Allow NULL? 
101PAEND12LR Participant : End date of participationnvarchar80 Allow NULL? 
102PARES13Current responsible party for a Lab.Rel casechar10 Allow NULL? 
103PAOBT13Object Typenvarchar20 Allow NULL? 
104PAOBJ13Object IDnvarchar80 Allow NULL? 
105PAROL13Participating Role in Labour Relation Interventionnvarchar30 Allow NULL? 
106PABEG13LR Participant : Begin date of participationnvarchar80 Allow NULL? 
107PAEND13LR Participant : End date of participationnvarchar80 Allow NULL? 
108PARES14Current responsible party for a Lab.Rel casechar10 Allow NULL? 
109PAOBT14Object Typenvarchar20 Allow NULL? 
110PAOBJ14Object IDnvarchar80 Allow NULL? 
111PAROL14Participating Role in Labour Relation Interventionnvarchar30 Allow NULL? 
112PABEG14LR Participant : Begin date of participationnvarchar80 Allow NULL? 
113PAEND14LR Participant : End date of participationnvarchar80 Allow NULL? 
114PARES15Current responsible party for a Lab.Rel casechar10 Allow NULL? 
115PAOBT15Object Typenvarchar20 Allow NULL? 
116PAOBJ15Object IDnvarchar80 Allow NULL? 
117PAROL15Participating Role in Labour Relation Interventionnvarchar30 Allow NULL? 
118PABEG15LR Participant : Begin date of participationnvarchar80 Allow NULL? 
119PAEND15LR Participant : End date of participationnvarchar80 Allow NULL? 
120PRSTA01Status/Level of Labour Relations Interventionnvarchar30 Allow NULL? 
121PRBEG01LR Process : Begin Date of an interventionnvarchar80 Allow NULL? 
122PREND01LR Process : End Date of an interventionnvarchar80 Allow NULL? 
123PRREA01LR Process : Reaction Timeframe (days)nvarchar40 Allow NULL? 
124PRSTA02Status/Level of Labour Relations Interventionnvarchar30 Allow NULL? 
125PRBEG02LR Process : Begin Date of an interventionnvarchar80 Allow NULL? 
126PREND02LR Process : End Date of an interventionnvarchar80 Allow NULL? 
127PRREA02LR Process : Reaction Timeframe (days)nvarchar40 Allow NULL? 
128PRSTA03Status/Level of Labour Relations Interventionnvarchar30 Allow NULL? 
129PRBEG03LR Process : Begin Date of an interventionnvarchar80 Allow NULL? 
130PREND03LR Process : End Date of an interventionnvarchar80 Allow NULL? 
131PRREA03LR Process : Reaction Timeframe (days)nvarchar40 Allow NULL? 
132PRSTA04Status/Level of Labour Relations Interventionnvarchar30 Allow NULL? 
133PRBEG04LR Process : Begin Date of an interventionnvarchar80 Allow NULL? 
134PREND04LR Process : End Date of an interventionnvarchar80 Allow NULL? 
135PRREA04LR Process : Reaction Timeframe (days)nvarchar40 Allow NULL? 
136PRSTA05Status/Level of Labour Relations Interventionnvarchar30 Allow NULL? 
137PRBEG05LR Process : Begin Date of an interventionnvarchar80 Allow NULL? 
138PREND05LR Process : End Date of an interventionnvarchar80 Allow NULL? 
139PRREA05LR Process : Reaction Timeframe (days)nvarchar40 Allow NULL? 
140PRSTA06Status/Level of Labour Relations Interventionnvarchar30 Allow NULL? 
141PRBEG06LR Process : Begin Date of an interventionnvarchar80 Allow NULL? 
142PREND06LR Process : End Date of an interventionnvarchar80 Allow NULL? 
143PRREA06LR Process : Reaction Timeframe (days)nvarchar40 Allow NULL? 
144PRSTA07Status/Level of Labour Relations Interventionnvarchar30 Allow NULL? 
145PRBEG07LR Process : Begin Date of an interventionnvarchar80 Allow NULL? 
146PREND07LR Process : End Date of an interventionnvarchar80 Allow NULL? 
147PRREA07LR Process : Reaction Timeframe (days)nvarchar40 Allow NULL? 
148PRSTA08Status/Level of Labour Relations Interventionnvarchar30 Allow NULL? 
149PRBEG08LR Process : Begin Date of an interventionnvarchar80 Allow NULL? 
150PREND08LR Process : End Date of an interventionnvarchar80 Allow NULL? 
151PRREA08LR Process : Reaction Timeframe (days)nvarchar40 Allow NULL? 
152PRSTA09Status/Level of Labour Relations Interventionnvarchar30 Allow NULL? 
153PRBEG09LR Process : Begin Date of an interventionnvarchar80 Allow NULL? 
154PREND09LR Process : End Date of an interventionnvarchar80 Allow NULL? 
155PRREA09LR Process : Reaction Timeframe (days)nvarchar40 Allow NULL? 
156PRSTA10Status/Level of Labour Relations Interventionnvarchar30 Allow NULL? 
157PRBEG10LR Process : Begin Date of an interventionnvarchar80 Allow NULL? 
158PREND10LR Process : End Date of an interventionnvarchar80 Allow NULL? 
159PRREA10LR Process : Reaction Timeframe (days)nvarchar40 Allow NULL? 
160PRSTA11Status/Level of Labour Relations Interventionnvarchar30 Allow NULL? 
161PRBEG11LR Process : Begin Date of an interventionnvarchar80 Allow NULL? 
162PREND11LR Process : End Date of an interventionnvarchar80 Allow NULL? 
163PRREA11LR Process : Reaction Timeframe (days)nvarchar40 Allow NULL? 
164PRSTA12Status/Level of Labour Relations Interventionnvarchar30 Allow NULL? 
165PRBEG12LR Process : Begin Date of an interventionnvarchar80 Allow NULL? 
166PREND12LR Process : End Date of an interventionnvarchar80 Allow NULL? 
167PRREA12LR Process : Reaction Timeframe (days)nvarchar40 Allow NULL? 
168PRSTA13Status/Level of Labour Relations Interventionnvarchar30 Allow NULL? 
169PRBEG13LR Process : Begin Date of an interventionnvarchar80 Allow NULL? 
170PREND13LR Process : End Date of an interventionnvarchar80 Allow NULL? 
171PRREA13LR Process : Reaction Timeframe (days)nvarchar40 Allow NULL? 
172PRSTA14Status/Level of Labour Relations Interventionnvarchar30 Allow NULL? 
173PRBEG14LR Process : Begin Date of an interventionnvarchar80 Allow NULL? 
174PREND14LR Process : End Date of an interventionnvarchar80 Allow NULL? 
175PRREA14LR Process : Reaction Timeframe (days)nvarchar40 Allow NULL? 
176PRSTA15Status/Level of Labour Relations Interventionnvarchar30 Allow NULL? 
177PRBEG15LR Process : Begin Date of an interventionnvarchar80 Allow NULL? 
178PREND15LR Process : End Date of an interventionnvarchar80 Allow NULL? 
179PRREA15LR Process : Reaction Timeframe (days)nvarchar40 Allow NULL? 
180OCTYP01Outcome of Labour Relations Interventionnvarchar30 Allow NULL? 
181OCBEG01LR Outcome : Begin date of an outcome/resolutionnvarchar80 Allow NULL? 
182OCEND01LR Outcome : End date of an outcome/resolutionnvarchar80 Allow NULL? 
183OCAGR01LR Outcome : Employee accepted Outcomechar10 Allow NULL? 
184OCTYP02Outcome of Labour Relations Interventionnvarchar30 Allow NULL? 
185OCBEG02LR Outcome : Begin date of an outcome/resolutionnvarchar80 Allow NULL? 
186OCEND02LR Outcome : End date of an outcome/resolutionnvarchar80 Allow NULL? 
187OCAGR02LR Outcome : Employee accepted Outcomechar10 Allow NULL? 
188OCTYP03Outcome of Labour Relations Interventionnvarchar30 Allow NULL? 
189OCBEG03LR Outcome : Begin date of an outcome/resolutionnvarchar80 Allow NULL? 
190OCEND03LR Outcome : End date of an outcome/resolutionnvarchar80 Allow NULL? 
191OCAGR03LR Outcome : Employee accepted Outcomechar10 Allow NULL? 
192OCTYP04Outcome of Labour Relations Interventionnvarchar30 Allow NULL? 
193OCBEG04LR Outcome : Begin date of an outcome/resolutionnvarchar80 Allow NULL? 
194OCEND04LR Outcome : End date of an outcome/resolutionnvarchar80 Allow NULL? 
195OCAGR04LR Outcome : Employee accepted Outcomechar10 Allow NULL? 
196OCTYP05Outcome of Labour Relations Interventionnvarchar30 Allow NULL? 
197OCBEG05LR Outcome : Begin date of an outcome/resolutionnvarchar80 Allow NULL? 
198OCEND05LR Outcome : End date of an outcome/resolutionnvarchar80 Allow NULL? 
199OCAGR05LR Outcome : Employee accepted Outcomechar10 Allow NULL? 
200OCTYP06Outcome of Labour Relations Interventionnvarchar30 Allow NULL? 
201OCBEG06LR Outcome : Begin date of an outcome/resolutionnvarchar80 Allow NULL? 
202OCEND06LR Outcome : End date of an outcome/resolutionnvarchar80 Allow NULL? 
203OCAGR06LR Outcome : Employee accepted Outcomechar10 Allow NULL? 
204OCTYP07Outcome of Labour Relations Interventionnvarchar30 Allow NULL? 
205OCBEG07LR Outcome : Begin date of an outcome/resolutionnvarchar80 Allow NULL? 
206OCEND07LR Outcome : End date of an outcome/resolutionnvarchar80 Allow NULL? 
207OCAGR07LR Outcome : Employee accepted Outcomechar10 Allow NULL? 
208OCTYP08Outcome of Labour Relations Interventionnvarchar30 Allow NULL? 
209OCBEG08LR Outcome : Begin date of an outcome/resolutionnvarchar80 Allow NULL? 
210OCEND08LR Outcome : End date of an outcome/resolutionnvarchar80 Allow NULL? 
211OCAGR08LR Outcome : Employee accepted Outcomechar10 Allow NULL? 
212OCTYP09Outcome of Labour Relations Interventionnvarchar30 Allow NULL? 
213OCBEG09LR Outcome : Begin date of an outcome/resolutionnvarchar80 Allow NULL? 
214OCEND09LR Outcome : End date of an outcome/resolutionnvarchar80 Allow NULL? 
215OCAGR09LR Outcome : Employee accepted Outcomechar10 Allow NULL? 
216OCTYP10Outcome of Labour Relations Interventionnvarchar30 Allow NULL? 
217OCBEG10LR Outcome : Begin date of an outcome/resolutionnvarchar80 Allow NULL? 
218OCEND10LR Outcome : End date of an outcome/resolutionnvarchar80 Allow NULL? 
219OCAGR10LR Outcome : Employee accepted Outcomechar10 Allow NULL? 
220OCTYP11Outcome of Labour Relations Interventionnvarchar30 Allow NULL? 
221OCBEG11LR Outcome : Begin date of an outcome/resolutionnvarchar80 Allow NULL? 
222OCEND11LR Outcome : End date of an outcome/resolutionnvarchar80 Allow NULL? 
223OCAGR11LR Outcome : Employee accepted Outcomechar10 Allow NULL? 
224OCTYP12Outcome of Labour Relations Interventionnvarchar30 Allow NULL? 
225OCBEG12LR Outcome : Begin date of an outcome/resolutionnvarchar80 Allow NULL? 
226OCEND12LR Outcome : End date of an outcome/resolutionnvarchar80 Allow NULL? 
227OCAGR12LR Outcome : Employee accepted Outcomechar10 Allow NULL? 
228OCTYP13Outcome of Labour Relations Interventionnvarchar30 Allow NULL? 
229OCBEG13LR Outcome : Begin date of an outcome/resolutionnvarchar80 Allow NULL? 
230OCEND13LR Outcome : End date of an outcome/resolutionnvarchar80 Allow NULL? 
231OCAGR13LR Outcome : Employee accepted Outcomechar10 Allow NULL? 
232OCTYP14Outcome of Labour Relations Interventionnvarchar30 Allow NULL? 
233OCBEG14LR Outcome : Begin date of an outcome/resolutionnvarchar80 Allow NULL? 
234OCEND14LR Outcome : End date of an outcome/resolutionnvarchar80 Allow NULL? 
235OCAGR14LR Outcome : Employee accepted Outcomechar10 Allow NULL? 
236OCTYP15Outcome of Labour Relations Interventionnvarchar30 Allow NULL? 
237OCBEG15LR Outcome : Begin date of an outcome/resolutionnvarchar80 Allow NULL? 
238OCEND15LR Outcome : End date of an outcome/resolutionnvarchar80 Allow NULL? 
239OCAGR15LR Outcome : Employee accepted Outcomechar10 Allow NULL? 
NamePrimaryUniqueTypeColumns
PA3202~0YesYesCLUSTEREDSEQNR, BEGDA, ENDDA, SPRPS, OBJPS, SUBTY, PERNR, MANDT