BASIS--使用DELETE_USER_ON_DB批量删除用户
来源:互联网 发布:less.js中文文档 编辑:程序博客网 时间:2024/06/10 11:24
REPORT ZDELUSER.
TABLES: USR01, USR02, *USR02, USR04, *USR04.
TABLES: USR03, USR05, USGRP, USR08, USR09, USR30.
TABLES: USR10, USR11, USR12, *USR10, *USR12, USR13, *USR13, USR16.
TABLES: USH04, USH10, USH12, USH02.
TABLES: UST04, UST10C, UST10S, UST12.
TABLES: USRBF.
PARAMETER UGRP LIKE USR03-CLASS.
DATA: BEGIN OF INTUSR02 OCCURS 200,
BNAME LIKE USR02-BNAME,
END OF INTUSR02.
DATA: CNTR TYPE P VALUE 0.
SELECT * FROM USR02 WHERE CLASS = UGRP.
INTUSR02-BNAME = USR02-BNAME.
APPEND INTUSR02.
ENDSELECT.
LOOP AT INTUSR02.
CALL FUNCTION 'DELETE_USER_ON_DB'
EXPORTING USER = INTUSR02-BNAME
EXCEPTIONS OTHERS = 1.
CNTR = CNTR + 1.
ENDLOOP.
WRITE : / 'Users deleted ', CNTR.
TABLES: USR01, USR02, *USR02, USR04, *USR04.
TABLES: USR03, USR05, USGRP, USR08, USR09, USR30.
TABLES: USR10, USR11, USR12, *USR10, *USR12, USR13, *USR13, USR16.
TABLES: USH04, USH10, USH12, USH02.
TABLES: UST04, UST10C, UST10S, UST12.
TABLES: USRBF.
PARAMETER UGRP LIKE USR03-CLASS.
DATA: BEGIN OF INTUSR02 OCCURS 200,
BNAME LIKE USR02-BNAME,
END OF INTUSR02.
DATA: CNTR TYPE P VALUE 0.
SELECT * FROM USR02 WHERE CLASS = UGRP.
INTUSR02-BNAME = USR02-BNAME.
APPEND INTUSR02.
ENDSELECT.
LOOP AT INTUSR02.
CALL FUNCTION 'DELETE_USER_ON_DB'
EXPORTING USER = INTUSR02-BNAME
EXCEPTIONS OTHERS = 1.
CNTR = CNTR + 1.
ENDLOOP.
WRITE : / 'Users deleted ', CNTR.
Trackback: http://tb.blog.csdn.net/TrackBack.aspx?PostId=1755725
- BASIS--使用DELETE_USER_ON_DB批量删除用户
- BASIS--使用DELETE_USER_ON_DB批量删除用户
- 批量删除用户
- 批量创建&删除用户
- 批量删除用户
- 用户批量删除
- BASIS--如何删除开发用户的开发Key
- BASIS--如何删除开发用户的开发Key
- 用户管理(二):使用shell脚本批量删除除root用户以外的其它用户
- 批量添加删除用户脚本
- Linux批量添加删除用户
- Linux 批量增加,删除用户
- tppabs批量删除 使用notepad批量删除
- redigo 批量删除使用
- BASIS-如何删除SAP在用户修改表结构时创建的临时表
- BASIS-如何删除SAP在用户修改表结构时创建的临时表
- java实现批量删除用户,选中删除用户
- java实现批量删除用户,选中删除用户
- C++--深入分析MFC文档视图结构(项目实践)
- C++如何修改SDI程序的默认背景颜色
- SD--定价过程的16个字段的作用说明
- C++--在单文档的应用程序增加多个视图
- 祝愿我所有的朋友身体健康,事业有成,天天快乐,幸福永远.....
- BASIS--使用DELETE_USER_ON_DB批量删除用户
- ABAP--通过'ARCHIV_CREATE_FILE'上传员工照片(代码摘抄OAOH)
- SD--Message Control Configure
- HR--配置HR的员工照片存储和上载的步骤
- ABAP--通过BDC倒入员工照片的参考代码
- ABAP--批量建立员工照片关联程序参考代码
- 同学走了,我的心很承重,一位才子就这么远去了,他远离我们而去,为他的离去而悲...
- SD-- SAP定义的几个标准Cost Condition的说明
- HTML--如何实现通过鼠标事件拖动页面图像(代码)