topic Re: where are customizing data changes stored in Application Development and Automation Discussions

where are customizing data changes stored

Former Member — Fri, 25 Aug 2006 03:27:11 GMT

Hi all,

I need to get the details of the data in the transaction FTXP(Maintain Tax Code) before and after changes.

Normally all master data changes are recorded in tables CDHDR and CDPOS and could be retrieved using function module "CHANGEDOCUMENT_READ_WITHOUT_ED". But FTXP being a customizing transaction, is not reflected these tables.

Can you tell me the table where I can see all customizing changes and any function module which can help retrieve them.

Thanks in advance

CMV

Re: where are customizing data changes stored

Former Member — Fri, 25 Aug 2006 03:41:54 GMT

hi,

CDHDR, CDPOS tables gets updated only if the checkbox Log data changes is checked. (Se11->Technical settings)

Otherwise they wont get reflected.

Check whether entries are exisitng in <b>DBTABLOG</b> table.

Regards,

Sailaja.

Re: where are customizing data changes stored

Former Member — Fri, 25 Aug 2006 04:31:58 GMT

Thanks you Sailaja for that input. But in DBTABLOG only tells which all tables were affected by chnages in a paricular transaction.

My issue is like I want to retrieve the old and new values as in CDHDR and CDPOS.

Anybody aware of this???

Re: where are customizing data changes stored

Former Member — Fri, 25 Aug 2006 04:45:18 GMT

Hi,

I checked the Standard code for storing the change log..

form ddntt_hist_get using tabname like x030l-tabname

tmst_low like x030l-crstamp

tmst_high like x030l-crstamp.

refresh ddntt_hist_tab. clear ddntt_hist_tab.

exec sql performing collect_ddntt_hist.

SELECT * INTO :DDNTT_HIST_TAB

FROM DDNTT_HIST

WHERE TABNAME = :TABNAME

AND CRTIMESTMP >= :TMST_LOW

AND CRTIMESTMP <= :TMST_HIGH

endexec.

endform.

form collect_ddntt_hist.

append ddntt_hist_tab.

endform.

Check the include LSDNTF01.

Please award the points if it helps..

Thanks,

Naren

Message was edited by: Narendran Muthukumaran