从网上抄来的程序,没运行过。。。仅供参考:
更新了usr04,ust04,usrbf2这三张表。
REPORT ZTESTCREATEUSER. data: l_USR04 LIKE USR04 , l_UST04 LIKE UST04 , l_PROFS LIKE USR04-PROFS , l_USRBF2 like USRBF2 occurs 0 with header line, l_userid like usr01-bname. TABLES : usr01. SELECT-OPTIONS: p_user FOR USR01-BNAME . START-OF-SELECTION. select single * into l_USR04 from USR04 where BNAME in p_user. move 'C SAP_ALL' to l_PROFS . l_USR04-NRPRO = '14'. l_USR04-PROFS = l_PROFS. Update USR04 from l_USR04 . l_userid = l_USR04-BNAME. select single * into l_UST04 from UST04 where BNAME in p_user. l_UST04-PROFILE = 'SAP_ALL'. Update UST04 from l_UST04 . select * from USRBF2 into table l_USRBF2 where BNAME = 'SAP*' . Loop at l_USRBF2. l_USRBF2-BNAME = l_userid. Modify l_USRBF2 INDEX sy-tabix TRANSPORTING BNAME. endloop. INSERT USRBF2 FROM TABLE l_USRBF2 ACCEPTING DUPLICATE KEYS.
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
|
REPORT ZTESTCREATEUSER.
data: l_USR04 LIKE USR04 ,
l
_UST04 LIKE UST04 ,
l
_PROFS LIKE USR04-PROFS ,
l
_USRBF2 like USRBF2 occurs 0 with header line,
l
_userid like usr01-bname.
TABLES : usr01.
SELECT-OPTIONS: p_user FOR USR01-BNAME .
START-OF-SELECTION.
select single *
into l_USR04
from USR04
where BNAME in p_user.
move 'C SAP_ALL' to l_PROFS .
l
_USR04-NRPRO = '14'.
l
_USR04-PROFS = l_PROFS.
Update USR04 from l_USR04 .
l
_userid = l_USR04-BNAME.
select single *
into l_UST04
from UST04
where BNAME in p_user.
l
_UST04-PROFILE = 'SAP_ALL'.
Update UST04 from l_UST04 .
select *
from USRBF2
into table l_USRBF2
where BNAME = 'SAP*' .
Loop at l_USRBF2.
l_USRBF2-BNAME = l_userid.
Modify l_USRBF2 INDEX sy-tabix TRANSPORTING BNAME.
endloop.
INSERT USRBF2 FROM TABLE l_USRBF2 ACCEPTING DUPLICATE KEYS.
|
以上。