目錄TOC\o"1-5"\h\zSAP表修改記錄查詢 1更改記錄表CDHDR和CDPOS 2SAP保存操作記錄CDHDR和CDPOS表 2通過CDHDRCDPOS獲取增量數據 7其他方式 11SAP表修改記錄查詢SAP中修改頻率較低的定制表（T001等）一般都會有修改記錄存在，查看一個表有沒有修改記錄可以在SE11中查看他的技術設置，如果其中的LOGDATACHANGES選中則表示此表有歷史修改記錄存在。要查看他的修改記錄可以使用Tcode：SCU3。菜單路徑：工具一定制一IMG—IMGLogging參考說明：/saphelp_nw04...cfab6dZframeset.htm系統讀取歷史修改記錄的Function:DBLOG_READ_WITH_STATISTIC轉載：/blog/1317901SE16N通過&sap_edit可以修改表，修改表后如何查看呢。分兩步進行。事務碼SE16N,然后輸入表SE16N_CD_Key,輸入相應的查詢條件。例如table名，查出相應的ID事務碼SE16N,然后輸入表SE16N_CD_DATA,輸入相應的ID,就可以查詢到修改的內容。其他方式：表DBTABLOGCDHDR更改日志表頭CDPOS更改日志行項目查詢用戶的最近一次登陸日期和時間，USR02中有個上次登陸日期和登陸時間；或者用SE38跑下RSUSR200，輸入用戶名即可查詢上次登陸日期還有個方法是ST03N,專家模式，選擇時間段，選擇user和userprofile，可惜，小弟權限不夠沒法測試更改記錄表CDHDR和CDPOSSE16N查詢CDPOS表，在字段OBJECTCLAS（更改文檔對象，VERKBELEG表示銷售憑證，不同的憑證類別代碼不同的文檔對象，如需查看文檔對象，可使用事務代碼SCDO，相關表為TCDOB/TCDOBT）中輸入：VERKBELEG，TABNAME（表名）輸入：VBAK/VBAP（VBAK查詢整張訂單、VBAP查詢訂單行項目），CHNGIND（修改標識符）輸入：D（U表示更新，I表示插入，E表示刪除單個字段，D表示刪除整行或整個單據），執行后，字段OBJECTID（對象價值）表示訂單號碼，字段TABKEY（表鍵）中的最后兩位表示訂單行號，同理，我們可查看其他刪除或修改的各種單據和憑證。SAP保存操作記錄CDHDR和CDPOS表轉載自/derrial/item/4eb7c5da614ed83c49e1dd0b(在此基礎上做了修改)sap的字段和對象的修改都會保存舊值，數據保存在CDHDR和CDPOS表中，提取舊值可以采用兩種方法1)使用sap的標準函數CHANGEDOCUMENT_READ_HEADERS和CHANGEDOCUMENTREADPOSITIONSCALLFUNCTION'CHANGEDOCUMENT_READ_POSITIONS'"Changedocument:ReadchangedocumentitemsEXPORTINGarchivehandle=0changenumber=tablekey=SPACEtablename=SPACEarchivehandle=0changenumber=tablekey=SPACEtablename=SPACE"cdpos-changenrChangedocumentnumber"cdpos-tabkeyObjectclasstablekey"cdpos-tabnameObjectclasstablenametablekey254=SPACE"cdpos_uid-tabkeyTableKeyforCDPOSinCharacter254keyguid=SPACE"cdpos_uid-keyguidUUIDinCharacterFormatkeyguid_str=SPACE"cdpos_str-keyguidUUIDinCharacterFormatIMPORTINGheader="cdhdrChangedocumentheader(structureCDHDR)etcdredstr="cdred_str_tabAdditionalChangeDocument-TableforSTRINGs*TABLEStablekey254=SPACE"cdpos_uid-tabkeyTableKeyforCDPOSinCharacter254keyguid=SPACE"cdpos_uid-keyguidUUIDinCharacterFormatkeyguid_str=SPACE"cdpos_str-keyguidUUIDinCharacterFormatIMPORTINGheader="cdhdrChangedocumentheader(structureCDHDR)etcdredstr="cdred_str_tabAdditionalChangeDocument-TableforSTRINGs*TABLES*editpos="cdshwTablewitheditedchangedocumentitemsEDITPOSWITHHEADER=EDITPOSWITHHEADER="CDRED更改文檔，顯示結構EXCEPTIONSNO_POSITION_FOUND=1 "NoitemfounWRONG_ACCESS_TO_ARCHIVE=2"incorrectaccesstoarchive2)使用select語句直接從表中讀取。直接使用SELECT語句讀取數據的示例：*提取信用額度字段修改的抬頭信息 selectcdhdr~changenrcdhdr~udatecdhdr~utimeintocorrespondingfieldsoftablep_cdhdrfromcdhdrwherecdhdr~objectclas='KLIM'andcdhdr~objectid=wa_customerinfo-kunnr. ifsy-subrc=0.*提取信用額度字段修改的字段值 selectcdpos~changenrcdpos~value_oldcdpos~value_newintocorrespondingfieldsoftablep_cdposfromcdposforallentriesinp_cdhdrwherecdpos~objectclas='KLIM'and cdpos~objectid=wa_customerinfo-kunnrand cdpos~changenr=p_cdhdr-changenrand cdpos~tabname='KNKK'andcdpos~fname='KLIMK'. ifsy-subrc=0.endif.endif.可以在CHANGEDOCUMENT_READ_HEADERS中設置中斷獲得對象類型。ex.提取有變動的Acc.changesSELECTSINGLEtabkeyvalue_newINTO(cdpos-tabkey,ikoinh)FROMcdposWHEREobjectclas='KRED'ANDobjectid=itab-lifnrANDchangenr=itab-changenrANDtabname='LFBK'ANDfname='KOINH'.提取有變動的vendor最新日期SELECTMAX(udate)INTOitab-cndateFROMcdhdrWHEREobjectclas='KRED'ANDobjectid=itab-lifnr.抓取所有有變動的程序reportztest001.TYPE-POOLSslis.DATA:cdhdrTYPEcdhdr.SELECT-OPTIONS:s_objclsFORcdhdr-objectclasOBLIGATORY,s_objtidFORcdhdr-objectid,s_chngnrFORcdhdr-changenr,s_usrnamFORcdhdr-usernameDEFAULTsy-uname,s_udateFORcdhdr-udateDEFAULTsy-datum,s_timeFORcdhdr-utime,s_tcodeFORcdhdr-tcode,s_plncnrFORcdhdr-planchngnr,s_chngnoFORcdhdr-act_chngno,s_wsplndFORcdhdr-was_plannd,s_chngidFORcdhdr-change_ind.SELECTION-SCREENSKIP.PARAMETERSp_maxTYPEnumc3OBLIGATORYDEFAULT'200'.**—TYPES:BEGINOFty_s_cdhdr.INCLUDESTRUCTUREcdhdr.TYPES:checkbox,ENDOFty_s_cdhdr,BEGINOFty_s_cdpos.INCLUDESTRUCTUREcdpos.TYPES:checkbox,ENDOFty_s_cdpos.**—DATA:LayoutforALVgs_layoutTYPEslis_layout_alv,Changedocumentheadert_cdhdrTYPETABLEOFty_s_cdhdr.*—START-OF-SELECTION.*ReadChangedocumentheaderSELECT*INTOTABLEt_cdhdrUPTOp_maxROWSFROMcdhdrWHEREobjectclasINs_objclsandobjectidins_objtidandchangenrins_chngnrANDusernameINs_usrnamANDudate INs_udateANDutime INs_timeANDtcode INs_tcodeANDplanchngnrINs_plncnrANDact_chngnoINs_chngnoANDwas_planndINs_wsplndANDchange_indINs_chngid.gs_layout-zebra='X'.gs_layout-colwidth_optimize='X'.gs_layout-box_fieldname='CHECKBOX'.DisplayALVCALLFUNCTION'REUSE_ALV_GRID_DISPLAY'EXPORTINGi_callback_program=sy-cprogi_callback_user_command='USER_COMMAND'i_structure_name='CDHDR'is_layout =gs_layoutTABLESt_outtab =t_cdhdr.*—FORMUSER_COMMAND **—FORMuser_commandUSINGu_ucommTYPEsyucommus_selfieldTYPEslis_selfield."#ECCALLEDMacrodefinitionDEFINEm_sort.add1tols_sort-spos.ls_sort-fieldname=&1.ls_sort-up='X'.appendls_sorttolt_sort.END-OF-DEFINITION.DATA:ls_cdhdrTYPEty_s_cdhdr,ls_sortTYPEslis_sortinfo_alv,lt_sortTYPEslis_t_sortinfo_alv,Changedocumentitemslt_cdposTYPETABLEOFty_s_cdpos.CASEu_ucomm.WHEN'&IC1'.PERFORMcheck_markedUSINGus_selfield.ReadChangedocumentitemsLOOPATt_cdhdrINTOls_cdhdrWHEREcheckbox='X'.SELECT*APPENDINGTABLElt_cdposFROMcdposWHEREobjectclas=ls_cdhdr-objectclasANDobjectid=ls_cdhdr-objectidANDchangenr=ls_cdhdr-changenr.ENDLOOP.msort'CHANGENR'.DisplayALVCALLFUNCTION'REUSE_ALV_GRID_DISPLAY'EXPORTINGi_structure_name='CDPOS'is_layout=gs_layoutit_sort=lt_sortTABLESt_outtab=lt_cdpos.ENDCASE.ENDFORM. "USER_COMMAND FORMcheck_markedUSINGus_selfieldTYPEslis_selfield.FIELD-SYMBOLS:<cdhdr>TYPEty_s_cdhdr.READTABLEt_cdhdrTRANSPORTINGNOFIELDSWITHKEYcheckbox='X'.IFNOTsy-subrcISINITIALANDNOTus_selfield-tabindexISINITIAL.READTABLEt_cdhdrINDEXus_selfield-tabindexASSIGNING<cdhdr>.<cdhdr>-checkbox='X'.ENDIF.ENDFORM.通過CDHDRCDPOS獲取增量數據REPORTzscm_vendor2LINE-SIZE1023.DATA:BEGINOFitabOCCURS0,sprasLIKElfa1-spras,lifnrLIKElfa1-lifnr,name1LIKEadrc-name1,name3LIKEadrc-name3,regioLIKElfa1-regio,strasLIKElfa1-stras,str_suppl1LIKEadrc-str_suppl1,pstlzLIKElfa1-pstlz,telf1LIKElfa1-telf1,telfxLIKElfa1-telfx,name2LIKEknvk-name1,smtp_addrLIKEadr6-smtp_addr,buy_id(12)TYPEc,stcegLIKElfa1-stceg,bankaLIKEbnka-banka,banknLIKElfbk-bankn,vendor_type⑶TYPEc,*balance_type(4)TYPEc,ENDOFitab.DATA:BEGINOFitab_tempOCCURS0,adrnrLIKElfa1-adrnr.INCLUDESTRUCTUREitab.DATA:ENDOFitab_temp.DATA:BEGINOFitab_adrcOCCURS0,addrnumberLIKEadrc-addrnumber,name1LIKEadrc-name1,name3LIKEadrc-name3,str_suppl1LIKEadrc-str_suppl1,smtp_addrLIKEadr6-smtp_addr,ENDOFitab_adrc.DATA:BEGINOFitab_knvkOCCURS0,lifnrLIKElfa1-lifnr,name2LIKEknvk-namel,ENDOFitab_knvk.DATA:BEGINOFitab_bnkaOCCURS0,lifnrLIKElfbk-lifnr,bankaLIKEbnka-banka,banknLIKElfbk-bankn,ENDOFitab_bnka.DATA:BEGINOFitab_lfb1OCCURS0,lifnrLIKElfb1-lifnr,bukrsLIKElfb1-bukrs,ztermLIKElfb1-zterm,ENDOFitab_lfb1.DATA:changenrLIKEzcdhdr_max-changenr.PARAMETER:dateTYPEsyst-datum.DATA:BEGINOFitab_objectOCCURS0,objectidLIKElfa1-lifnr,ENDOFitab_object.PERFORMgetvendordata.*0 *& *&Formgetvendordata*0 *& FORMgetvendordata.**getmaxchangenrSELECTMAX(zcdhdr_max~changenr)INTOchangenrFROMzcdhdr_maxWHEREzcdhdr_max~erdat<date.getobjectidfromcdhdrbyusingkred,maxchangenr,anddateSELECTcdhdr~objectidINTOCORRESPONDINGFIELDSOFTABLEitab_objectFROMcdhdrWHEREcdhdr~objectclas='KRED'ANDcdhdr~changenr>changenrANDcdhdr~udate=date.LOOPATitab_object.IFitab_object-objectid+0(1)='B'.“B為公司職員DELETEitab_object.ENDIF.ENDLOOP.*DELETEADJACENTdataSORTitab_object.DELETEADJACENTDUPLICATESFROMitab_object.CHECKNOTitab_object[]ISINITIAL.SELECTlfa1~spraslfa1~lifnrlfa1~stceglfa1~regiolfa1~straslfa1~pstlzlfa1~telf1lfa1~telfxlfa1~adrnrlfa1~ernamASbuy_idlfa1~ktokkASvendor_typeINTOCORRESPONDINGFIELDSOFTABLEitab_tempFROMlfa1FORALLENTRIESINitab_objectWHERElfa1~lifnr=itab_object-objectid.SELECTknvk~lifnrknvk~name1ASname2INTOCORRESPONDINGFIELDSOFTABLEitab_knvkFROMknvkFORALLENTRIESINitab_objectWHEREknvk~lifnr=itab_object-objectid.SELECTlfbk~lifnrbnka~bankalfbk~banknINTOCORRESPONDINGFIELDSOFTABLEitab_bnkaFROMlfbkINNERJOINbnkaONlfbk~banks=bnka~banksANDlfbk~bankl=bnka~banklFORALLentriesINitab_objectWHERElfbk~lifnr=itab_object-objectid.CHECKNOTitab_temp[]ISINITIAL.SELECTadrc~addrnumberadrc~str_suppl1adrc~name1adr