where are customizing data changes stored

[Former Member]

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

[Former Member]

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.

[Former Member]

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???

[Former Member]

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