sap 表修改记录查询

目录

SAP表修改记录查询 ....................................................................................................................... 1 更改记录表CDHDR和CDPOS ......................................................................................................... 2 SAP保存操作记录CDHDR和CDPOS表 ......................................................................................... 2 通过CDHDR CDPOS获取增量数据 ................................................................................................. 7 其他方式......................................................................................................................................... 11

SAP表修改记录查询

SAP中修改频率较低的定制表（T001等）一般都会有修改记录存在，查看一个表有没有修改记录可以在SE11中查看他的技术设置，如果其中的LOG DATA CHANGES选中则表示此表有历史修改记录存在。

要查看他的修改记录可以使用Tcode：SCU3 。 菜单路径：工具－定制－IMG－IMG Logging

参考说明： http://help.sap.com/saphelp_nw04 ... cfab6d/frameset.htm 系统读取历史修改记录的Function ： DBLOG_READ_WITH_STATISTIC 转载：http://mahone.iteye.com/blog/1317901

SE16N 通过&sap_edit可以修改表，修改表后如何查看呢。分两步进行。

1. 事务码 SE16N, 然后输入表 SE16N_CD_Key，输入相应的查询条件。例如 table 名,查出相应的ID

2. 事务码 SE16N，然后输入表 SE16N_CD_DATA, 输入相应的ID，就可以查询到修改的内容。

其他方式：表 DBTABLOG

CDHDR 更改日志表头 CDPOS 更改日志行项目

查询用户的最近一次登陆日期和时间，USR02中有个上次登陆日期和登陆时间；或者用SE38跑下RSUSR200，输入用户名即可查询上次登陆日期

还有个方法是ST03N,专家模式，选择时间段，选择user和user profile，可惜，小弟权限不够没法测试

更改记录表CDHDR和CDPOS

SE16N查询CDPOS表，在字段OBJECTCLAS（更改文档对象，VERKBELEG表示销售凭证，不同的凭证类别代码不同的文档对象，如需查看文档对象，可使用事务代码SCDO，相关表为TCDOB/TCDOBT）中输入：VERKBELEG，TABNAME（表名）输入：VBAK/VBAP（VBAK查询整张订单、VBAP查询订单行项目），CHNGIND（修改标识符）输入：D（U表示更新，I表示插入，E表示删除单个字段，D表示删除整行或整个单据），执行后，字段OBJECTID（对象价值）表示订单号码，字段TABKEY（表键）中的最后两位表示订单行号，同理，我们可查看其他删除或修改的各种单据和凭证。 SAP保存操作记录CDHDR和CDPOS表

转载自http://hi.http://m.wodefanwen.com//derrial/item/4eb7c5da614ed83c49e1dd0b （在此基础上做了修改） sap的字段和对象的修改都会保存旧值，数据保存在CDHDR和CDPOS表中，提取旧值可以采用两种方法

1) 使用sap的标准函数CHANGEDOCUMENT_READ_HEADERS 和CHANGEDOCUMENT_READ_POSITIONS

CALL FUNCTION 'CHANGEDOCUMENT_READ_POSITIONS' \change document items EXPORTING

* archive_handle = 0 \ changenumber = \* tablekey = SPACE \* tablename = SPACE \

* tablekey254 = SPACE \* keyguid = SPACE \* keyguid_str = SPACE \IMPORTING

header = \

et_cdred_str = \* TABLES

* editpos = \EDITPOS_WITH_HEADER = \更改文档,显示结构 EXCEPTIONS

NO_POSITION_FOUND = 1 \

WRONG_ACCESS_TO_ARCHIVE = 2 \

2)使用select语句直接从表中读取。 直接使用SELECT语句读取数据的示例： *提取信用额度字段修改的抬头信息 select

cdhdr~changenrcdhdr~udatecdhdr~utime into corresponding fields of table

p_cdhdr from cdhdr where cdhdr~objectclas = 'KLIM' and cdhdr~objectid = wa_customerinfo-kunnr. if sy-subrc = 0. *提取信用额度字段修改的字段值 select cdpos~changenrcdpos~value_oldcdpos~value_new into corresponding fields of table p_cdpos from cdpos for all entries in p_cdhdr where cdpos~objectclas = 'KLIM' and cdpos~objectid = wa_customerinfo-kunnr and cdpos~changenr = p_cdhdr-changenr and cdpos~tabname = 'KNKK' and cdpos~fname = 'KLIMK'. ifsy-subrc = 0. endif. endif.

可以在CHANGEDOCUMENT_READ_HEADERS 中设置中断获得对象类型。 ex.

提取有变动的 Acc. changes

SELECT SINGLE tabkeyvalue_new INTO (cdpos-tabkey,ikoinh) FROM cdpos

WHERE objectclas = 'KRED' AND objectid = itab-lifnr AND changenr = itab-changenr AND tabname = 'LFBK' AND fname = 'KOINH'. 提取有变动的vendor最新日期

SELECT MAX(udate ) INTO itab-cndate FROM cdhdr WHERE objectclas = 'KRED' AND objectid = itab-lifnr. -------------------------------------------------------------------------------- 抓取所有有变动的程序 report ztest001. TYPE-POOLS slis. DATA :cdhdr TYPE cdhdr. SELECT-OPTIONS :

s_objcls FOR cdhdr-objectclas OBLIGATORY, s_objtid FOR cdhdr-objectid, s_chngnr FOR cdhdr-changenr,

s_usrnam FOR cdhdr-username DEFAULT sy-uname, s_udate FOR cdhdr-udate DEFAULT sy-datum, s_time FOR cdhdr-utime, s_tcode FOR cdhdr-tcode, s_plncnr FOR cdhdr-planchngnr, s_chngno FOR cdhdr-act_chngno, s_wsplnd FOR cdhdr-was_plannd, s_chngid FOR cdhdr-change_ind.

SELECTION-SCREEN SKIP.

PARAMETERS p_max TYPE numc3 OBLIGATORY DEFAULT '200'.

*---------------------------------------------------------------------* TYPES :

BEGIN OF ty_s_cdhdr.

INCLUDE STRUCTURE cdhdr. TYPES : checkbox, END OF ty_s_cdhdr,

BEGIN OF ty_s_cdpos.

INCLUDE STRUCTURE cdpos. TYPES : checkbox, END OF ty_s_cdpos.

*---------------------------------------------------------------------* DATA :

* Layout for ALV

gs_layout TYPE slis_layout_alv, * Change document header

t_cdhdr TYPE TABLE OF ty_s_cdhdr.

*---------------------------------------------------------------------* START-OF-SELECTION.

* Read Change document header SELECT * INTO TABLE t_cdhdr UP TO p_max ROWS FROM cdhdr

WHERE objectclas IN s_objcls and objectid in s_objtid and changenr in s_chngnr AND username IN s_usrnam AND udate IN s_udate AND utime IN s_time AND tcode IN s_tcode AND planchngnr IN s_plncnr AND act_chngno IN s_chngno AND was_plannd IN s_wsplnd AND change_ind IN s_chngid.

gs_layout-zebra = 'X'.

gs_layout-colwidth_optimize = 'X'. gs_layout-box_fieldname = 'CHECKBOX'.

* Display ALV

CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY' EXPORTING

i_callback_program = sy-cprog

i_callback_user_command = 'USER_COMMAND' i_structure_name = 'CDHDR' is_layout = gs_layout TABLES

t_outtab = t_cdhdr.

*---------------------------------------------------------------------* * FORM USER_COMMAND * *---------------------------------------------------------------------* FORM user_command USING u_ucomm TYPE syucomm us_selfield TYPE slis_selfield. \

* Macro definition DEFINE m_sort. add 1 to ls_sort-spos. ls_sort-fieldname = &1. ls_sort-up = 'X'. appendls_sort to lt_sort. END-OF-DEFINITION. DATA :

ls_cdhdr TYPE ty_s_cdhdr, ls_sort TYPE slis_sortinfo_alv, lt_sort TYPE slis_t_sortinfo_alv, * Change document items

lt_cdpos TYPE TABLE OF ty_s_cdpos.

CASE u_ucomm. WHEN '&IC1'.

PERFORM check_marked USING us_selfield.

* Read Change document items

LOOP AT t_cdhdr INTO ls_cdhdr WHERE checkbox = 'X'. SELECT * APPENDING TABLE lt_cdpos FROM cdpos

WHERE objectclas = ls_cdhdr-objectclas AND objectid = ls_cdhdr-objectid AND changenr = ls_cdhdr-changenr. ENDLOOP.

* CALL FUNCTION 'WS_DOWNLOAD' * EXPORTING

* filename = 'c:\\vendor.txt' * filetype = 'DAT' * TABLES

* data_tab = itab[].

ENDFORM. 其他方式

Tcode：STAD，SCU3，T03N

本文来源：https://www.bwwdw.com/article/uo0r.html