-
Notifications
You must be signed in to change notification settings - Fork 53
/
CLAS_ZSAPLINK_TABLE_CONTENTS.slnk
428 lines (377 loc) · 19.1 KB
/
CLAS_ZSAPLINK_TABLE_CONTENTS.slnk
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
<?xml version="1.0" encoding="iso-8859-1"?>
<CLAS CLSNAME="ZSAPLINK_TABLE_CONTENTS" VERSION="1" LANGU="E" DESCRIPT="SAPlink - Table Contents" UUID="FAD377BAD34F5248A16A198E70B1EA84" CATEGORY="00" EXPOSURE="2" STATE="1" RELEASE="0" AUTHOR="BCUSER" CREATEDON="20070901" CHANGEDBY="BCUSER" CHANGEDON="00000000" CHGDANYON="00000000" CLSFINAL="X" CLSCCINCL="X" FIXPT="X" UNICODE="X" R3RELEASE="700" CLSBCCAT="00" DURATION_TYPE="0 " RISK_LEVEL="0 " REFCLSNAME="ZSAPLINK">
<publicSection>class ZSAPLINK_TABLE_CONTENTS definition
public
inheriting from ZSAPLINK
final
create public .
*"* public components of class ZSAPLINK_TABLE_CONTENTS
*"* do not include other source files here!!!
public section.
methods CHECKEXISTS
redefinition .
methods CREATEIXMLDOCFROMOBJECT
redefinition .
methods CREATEOBJECTFROMIXMLDOC
redefinition .</publicSection>
<protectedSection>*"* protected components of class ZSAPLINK_TABLES
*"* do not include other source files here!!!
protected section.
methods DELETEOBJECT
redefinition .
methods GETOBJECTTYPE
redefinition .</protectedSection>
<privateSection>*"* private components of class ZSAPLINK_TABLES
*"* do not include other source files here!!!
private section.</privateSection>
<localImplementation>*"* local class implementation for public class
*"* use this source file for the implementation part of
*"* local helper classes</localImplementation>
<localTypes>*"* use this source file for any type declarations (class
*"* definitions, interfaces or data types) you need for method
*"* implementation or private method's signature</localTypes>
<localMacros>*"* use this source file for any macro definitions you need
*"* in the implementation part of the class</localMacros>
<inheritance CLSNAME="ZSAPLINK_TABLE_CONTENTS" REFCLSNAME="ZSAPLINK" VERSION="1" STATE="1" AUTHOR="BCUSER" CREATEDON="20070901" CHANGEDON="00000000">
<redefinition CLSNAME="ZSAPLINK_TABLE_CONTENTS" REFCLSNAME="ZSAPLINK" VERSION="1" MTDNAME="CHECKEXISTS"/>
<redefinition CLSNAME="ZSAPLINK_TABLE_CONTENTS" REFCLSNAME="ZSAPLINK" VERSION="1" MTDNAME="CREATEIXMLDOCFROMOBJECT"/>
<redefinition CLSNAME="ZSAPLINK_TABLE_CONTENTS" REFCLSNAME="ZSAPLINK" VERSION="1" MTDNAME="CREATEOBJECTFROMIXMLDOC"/>
<redefinition CLSNAME="ZSAPLINK_TABLE_CONTENTS" REFCLSNAME="ZSAPLINK" VERSION="1" MTDNAME="DELETEOBJECT"/>
<redefinition CLSNAME="ZSAPLINK_TABLE_CONTENTS" REFCLSNAME="ZSAPLINK" VERSION="1" MTDNAME="GETOBJECTTYPE"/>
</inheritance>
<method CLSNAME="ZSAPLINK" CMPNAME="CHECKEXISTS" VERSION="0" EXPOSURE="0" STATE="0" EDITORDER="0 " DISPID="0 " CREATEDON="00000000" CHANGEDON="00000000" MTDTYPE="0" MTDDECLTYP="0" BCMTDCAT="00" BCMTDSYN="0">
<source>*/---------------------------------------------------------------------\
*| This file is part of SAPlink. |
*| |
*| SAPlink is free software; you can redistribute it and/or modify |
*| it under the terms of the GNU General Public License as published |
*| by the Free Software Foundation; either version 2 of the License, |
*| or (at your option) any later version. |
*| |
*| SAPlink is distributed in the hope that it will be useful, |
*| but WITHOUT ANY WARRANTY; without even the implied warranty of |
*| MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
*| GNU General Public License for more details. |
*| |
*| You should have received a copy of the GNU General Public License |
*| along with SAPlink; if not, write to the |
*| Free Software Foundation, Inc., |
*| 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA |
*\---------------------------------------------------------------------/
METHOD checkexists.
* Plugin created by:
* Rich Heilman
* rich.heilman.jr@gmail.com
* No implementation
ENDMETHOD.</source>
</method>
<method CLSNAME="ZSAPLINK" CMPNAME="CREATEIXMLDOCFROMOBJECT" VERSION="0" EXPOSURE="0" STATE="0" EDITORDER="0 " DISPID="0 " CREATEDON="00000000" CHANGEDON="00000000" MTDTYPE="0" MTDDECLTYP="0" BCMTDCAT="00" BCMTDSYN="0">
<source>*/---------------------------------------------------------------------\
*| This file is part of SAPlink. |
*| |
*| SAPlink is free software; you can redistribute it and/or modify |
*| it under the terms of the GNU General Public License as published |
*| by the Free Software Foundation; either version 2 of the License, |
*| or (at your option) any later version. |
*| |
*| SAPlink is distributed in the hope that it will be useful, |
*| but WITHOUT ANY WARRANTY; without even the implied warranty of |
*| MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
*| GNU General Public License for more details. |
*| |
*| You should have received a copy of the GNU General Public License |
*| along with SAPlink; if not, write to the |
*| Free Software Foundation, Inc., |
*| 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA |
*\---------------------------------------------------------------------/
METHOD createixmldocfromobject.
* Plugin created by:
* Rich Heilman
* rich.heilman.jr@gmail.com
TYPES: BEGIN OF ttabname,
tabname TYPE dd02v-tabname,
END OF ttabname.
DATA xtabname TYPE ttabname.
DATA xdd02v TYPE dd02v.
DATA root_node TYPE REF TO if_ixml_element.
DATA datarow_node TYPE REF TO if_ixml_element.
DATA rc TYPE sysubrc.
DATA _tablname TYPE ddobjname.
DATA _objtype TYPE string.
DATA dref_tab TYPE REF TO data.
DATA dref_wa TYPE REF TO data.
FIELD-SYMBOLS: <dyn_tab> TYPE table.
FIELD-SYMBOLS: <dyn_wa> TYPE ANY.
* Check that table exits.
_tablname = objname.
* Does the table exist?
CALL FUNCTION 'DDIF_TABL_GET'
EXPORTING
name = _tablname
IMPORTING
dd02v_wa = xdd02v
EXCEPTIONS
illegal_input = 1
OTHERS = 2.
IF sy-subrc <> 0 OR xdd02v-tabname IS INITIAL.
RAISE EXCEPTION TYPE zcx_saplink
EXPORTING textid = zcx_saplink=>error_message
msg = `Table not found`.
ENDIF.
* Create parent node
_objtype = getobjecttype( ).
root_node = xmldoc->create_element( _objtype ).
xtabname-tabname = xdd02v-tabname.
me->setattributesfromstructure( node = root_node structure = xtabname ).
* Create dynamic internal table and work area
CREATE DATA dref_tab TYPE TABLE OF (xdd02v-tabname).
ASSIGN dref_tab->* TO <dyn_tab>.
CREATE DATA dref_wa LIKE LINE OF <dyn_tab>.
ASSIGN dref_wa->* TO <dyn_wa>.
* Select all data
SELECT * INTO TABLE <dyn_tab> FROM (xdd02v-tabname).
* Write records to XML node
LOOP AT <dyn_tab> ASSIGNING <dyn_wa>.
datarow_node = xmldoc->create_element( `DataRow` ).
me->setattributesfromstructure( node = datarow_node structure = <dyn_wa> ).
rc = root_node->append_child( datarow_node ).
ENDLOOP.
* Add node
rc = xmldoc->append_child( root_node ).
ixmldocument = xmldoc.
ENDMETHOD.</source>
</method>
<method CLSNAME="ZSAPLINK" CMPNAME="CREATEOBJECTFROMIXMLDOC" VERSION="0" EXPOSURE="0" STATE="0" EDITORDER="0 " DISPID="0 " CREATEDON="00000000" CHANGEDON="00000000" MTDTYPE="0" MTDDECLTYP="0" BCMTDCAT="00" BCMTDSYN="0">
<source>*/---------------------------------------------------------------------\
*| This file is part of SAPlink. |
*| |
*| SAPlink is free software; you can redistribute it and/or modify |
*| it under the terms of the GNU General Public License as published |
*| by the Free Software Foundation; either version 2 of the License, |
*| or (at your option) any later version. |
*| |
*| SAPlink is distributed in the hope that it will be useful, |
*| but WITHOUT ANY WARRANTY; without even the implied warranty of |
*| MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
*| GNU General Public License for more details. |
*| |
*| You should have received a copy of the GNU General Public License |
*| along with SAPlink; if not, write to the |
*| Free Software Foundation, Inc., |
*| 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA |
*\---------------------------------------------------------------------/
METHOD createobjectfromixmldoc.
* Plugin created by:
* Rich Heilman
* rich.heilman.jr@gmail.com
TYPES: BEGIN OF ttabname,
tabname TYPE dd02v-tabname,
END OF ttabname.
DATA xtabname TYPE ttabname.
DATA xdd02v TYPE dd02v.
DATA xtadir TYPE tadir.
DATA idd03p TYPE TABLE OF dd03p.
DATA xdd03p LIKE LINE OF idd03p.
DATA root_node TYPE REF TO if_ixml_element.
DATA datarow_node TYPE REF TO if_ixml_element.
DATA datarow_filter TYPE REF TO if_ixml_node_filter.
DATA datarow_iterator TYPE REF TO if_ixml_node_iterator.
DATA _objtype TYPE string.
DATA l_answer TYPE string.
DATA l_nameclass TYPE c.
DATA l_client_dependent TYPE abap_bool.
DATA dref_tab TYPE REF TO data.
DATA dref_wa TYPE REF TO data.
FIELD-SYMBOLS: <dyn_tab> TYPE table.
FIELD-SYMBOLS: <dyn_wa> TYPE ANY.
FIELD-SYMBOLS: <fs_mandt> TYPE ANY.
_objtype = getobjecttype( ).
xmldoc = ixmldocument.
root_node = xmldoc->find_from_name( _objtype ).
* Get table name from XML.
me->getstructurefromattributes(
EXPORTING node = root_node
CHANGING structure = xtabname ).
objname = xtabname-tabname.
* Check that table exists
CALL FUNCTION 'DDIF_TABL_GET'
EXPORTING
name = xtabname-tabname
IMPORTING
dd02v_wa = xdd02v
TABLES
dd03p_tab = idd03p
EXCEPTIONS
illegal_input = 1
OTHERS = 2.
IF sy-subrc <> 0 OR xdd02v-tabname IS INITIAL.
RAISE EXCEPTION TYPE zcx_saplink
EXPORTING textid = zcx_saplink=>error_message
msg = `Table not found`.
ENDIF.
* Check for MANDT field, if found, then set client dependent
READ TABLE idd03p INTO xdd03p WITH KEY fieldname = 'MANDT'.
IF sy-subrc = 0.
l_client_dependent = abap_true.
ENDIF.
* Only allow tables in customer namespace
CLEAR xtadir.
SELECT SINGLE * FROM tadir INTO xtadir
WHERE pgmid = 'R3TR'
AND object = 'TABL'
AND obj_name = xdd02v-tabname.
CALL FUNCTION 'TRINT_OBJECT_NAMESPACE_INFO'
EXPORTING
iv_pgmid = xtadir-pgmid
iv_object = xtadir-object
iv_objname = xtadir-obj_name
IMPORTING
ev_nameclass = l_nameclass
EXCEPTIONS
namespace_not_existing = 1
namespace_use_rejected = 2
invalid_object = 3
OTHERS = 4.
IF l_nameclass <> `C`.
RAISE EXCEPTION TYPE zcx_saplink
EXPORTING textid = zcx_saplink=>error_message
msg = 'Table is not within customer namespace'.
ENDIF.
* Create dynamic internal table and work area
CREATE DATA dref_tab TYPE TABLE OF (xdd02v-tabname).
ASSIGN dref_tab->* TO <dyn_tab>.
CREATE DATA dref_wa LIKE LINE OF <dyn_tab>.
ASSIGN dref_wa->* TO <dyn_wa>.
* Build dynamic internal table from XML
FREE: datarow_filter, datarow_iterator, datarow_node.
datarow_filter = xmldoc->create_filter_name( `DataRow` ).
datarow_iterator = xmldoc->create_iterator_filtered( datarow_filter ).
datarow_node ?= datarow_iterator->get_next( ).
WHILE datarow_node IS NOT INITIAL.
APPEND INITIAL LINE TO <dyn_tab> ASSIGNING <dyn_wa>.
me->getstructurefromattributes(
EXPORTING node = datarow_node
CHANGING structure = <dyn_wa> ).
datarow_node ?= datarow_iterator->get_next( ).
ENDWHILE.
* Any records imported from XML, if not, give error.
IF LINES( <dyn_tab> ) = 0.
RAISE EXCEPTION TYPE zcx_saplink
EXPORTING textid = zcx_saplink=>error_message
msg = `No data records present in XML document`.
ENDIF.
* Change MANDT field to current client number
* Always add imported records to current client number
IF l_client_dependent = abap_true.
LOOP AT <dyn_tab> ASSIGNING <dyn_wa>.
ASSIGN COMPONENT `MANDT` OF STRUCTURE <dyn_wa> TO <fs_mandt>.
<fs_mandt> = sy-mandt.
ENDLOOP.
ENDIF.
* Check that db table is initial, if so, then insert data and exit
DATA: l_count TYPE i.
CASE l_client_dependent .
WHEN abap_true.
SELECT COUNT( * ) INTO l_count
FROM (xdd02v-tabname) CLIENT SPECIFIED
WHERE mandt = sy-mandt.
WHEN abap_false.
SELECT COUNT( * ) INTO l_count
FROM (xdd02v-tabname).
ENDCASE.
IF l_count = 0.
INSERT (xdd02v-tabname) FROM TABLE <dyn_tab>.
name = objname.
RETURN.
ENDIF.
* Still here, then ask user how he wants to handle the existing
* data, either modify it, of delete/insert
DATA: text_question TYPE string.
text_question = `Table contains data which may be modified, ` &
`would you like to modify existing records, ` &
`or delete existing data first and insert`.
CALL FUNCTION 'POPUP_TO_CONFIRM'
EXPORTING
text_question = text_question
text_button_1 = 'Modify Data' " UPdate table via MODIFY
icon_button_1 = 'ICON_CHANGE'
text_button_2 = 'Del/Ins Data' " Delete data first, then INSERT
icon_button_2 = 'ICON_DELETE'
IMPORTING
answer = l_answer
EXCEPTIONS
text_not_found = 1
OTHERS = 2.
* Check answer
CASE l_answer .
WHEN '1'. "Modify existing rows, insert new rows based on key
MODIFY (xdd02v-tabname) FROM TABLE <dyn_tab>.
WHEN '2'. "Delete existing data first, then insert new data
CASE l_client_dependent .
WHEN abap_true.
DELETE FROM (xdd02v-tabname) WHERE mandt = sy-mandt.
WHEN abap_false.
DELETE FROM (xdd02v-tabname).
ENDCASE.
INSERT (xdd02v-tabname) FROM TABLE <dyn_tab>.
WHEN 'A'. "Action has been cancelled
RAISE EXCEPTION TYPE zcx_saplink
EXPORTING textid = zcx_saplink=>error_message
msg = `Action Cancelled`.
ENDCASE.
name = objname.
ENDMETHOD.</source>
</method>
<method CLSNAME="ZSAPLINK" CMPNAME="DELETEOBJECT" VERSION="0" EXPOSURE="0" STATE="0" EDITORDER="0 " DISPID="0 " CREATEDON="00000000" CHANGEDON="00000000" MTDTYPE="0" MTDDECLTYP="0" BCMTDCAT="00" BCMTDSYN="0">
<source>*/---------------------------------------------------------------------\
*| This file is part of SAPlink. |
*| |
*| SAPlink is free software; you can redistribute it and/or modify |
*| it under the terms of the GNU General Public License as published |
*| by the Free Software Foundation; either version 2 of the License, |
*| or (at your option) any later version. |
*| |
*| SAPlink is distributed in the hope that it will be useful, |
*| but WITHOUT ANY WARRANTY; without even the implied warranty of |
*| MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
*| GNU General Public License for more details. |
*| |
*| You should have received a copy of the GNU General Public License |
*| along with SAPlink; if not, write to the |
*| Free Software Foundation, Inc., |
*| 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA |
*\---------------------------------------------------------------------/
method DELETEOBJECT.
* Plugin created by:
* Rich Heilman
* rich.heilman.jr@gmail.com
* No implementation
endmethod.</source>
</method>
<method CLSNAME="ZSAPLINK" CMPNAME="GETOBJECTTYPE" VERSION="0" EXPOSURE="0" STATE="0" EDITORDER="0 " DISPID="0 " CREATEDON="00000000" CHANGEDON="00000000" MTDTYPE="0" MTDDECLTYP="0" BCMTDCAT="00" BCMTDSYN="0">
<source>*/---------------------------------------------------------------------\
*| This file is part of SAPlink. |
*| |
*| SAPlink is free software; you can redistribute it and/or modify |
*| it under the terms of the GNU General Public License as published |
*| by the Free Software Foundation; either version 2 of the License, |
*| or (at your option) any later version. |
*| |
*| SAPlink is distributed in the hope that it will be useful, |
*| but WITHOUT ANY WARRANTY; without even the implied warranty of |
*| MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
*| GNU General Public License for more details. |
*| |
*| You should have received a copy of the GNU General Public License |
*| along with SAPlink; if not, write to the |
*| Free Software Foundation, Inc., |
*| 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA |
*\---------------------------------------------------------------------/
method GETOBJECTTYPE.
* Plugin created by:
* Rich Heilman
* rich.heilman.jr@gmail.com
objecttype = 'TABU'. "Table Contents
endmethod.</source>
</method>
</CLAS>