saving created date and changed date automatically

lijisusan_mathews — Fri, 31 Oct 2008 10:20:14 GMT

is there a way by which i can save the created user, time and date for all the records i am inserting into a table using the statement

modify DBANAME from table INTERNAL_TABLE..

and using any other ways of inserting into table.

I tried using table events for creating new entry but that is working only when i enter a new record via sm30.. its not working when i enter values together from an internal table

Pls help

regards

Suzie.

Re: saving created date and changed date automatically

ThomasZloch — Fri, 31 Oct 2008 10:22:09 GMT

You could activate table logging for the table in question in the technical settings of SE11. The changes will then be stored in DBTABLOG and can be evaluated via SCU3. Profile parameter rec/client must be active as well for the system and client.

Thomas

Re: saving created date and changed date automatically

Former Member — Fri, 31 Oct 2008 10:25:35 GMT

Hello,

With Modify statement it will work fine better try with MODIFY.

Re: saving created date and changed date automatically

christine_evans — Fri, 31 Oct 2008 10:28:13 GMT

If you are updating your custom table from a program, you can set the date / time / id fields on your custom table in exactly the same way as you setting the other fields in the table.....where is the problem?

Re: saving created date and changed date automatically

Former Member — Fri, 31 Oct 2008 10:37:00 GMT

You can use change management.

1. in tcode: Scdo,insert table and generate it. ( for example, the table name is ZXSC_USRMGR_INFO

2. In view V_TVIMF, Insert record, for ZXSC_USRMGR_INFO,

Enter form routine name, for example 'ZXSC_USRMGR_INFO_01' 01

3. In program LZSECURITYF01(This program name is not the same, L+Auth grp + 01),write code

FORM zxsc_usrmgr_info_01.

Get all the records for the Table before Processing

SELECT * INTO TABLE yzxsc_usrmgr_info

FROM zxsc_usrmgr_info.

sy-subrc = 0. "need sy-subrc = 0 so data will be saved

ENDFORM. "ZXSC_USRMGR_INFO_01

&----

*& Form ZXSC_USRMGR_INFO_02

&----

text

----

FORM zxsc_usrmgr_info_02.

CONSTANTS:

c_update(1) TYPE c VALUE 'U', " Mode = Update

c_objectid LIKE cdhdr-objectid VALUE 'ZXSC_USRMGR_INFO'.

Here, data has been saved, so get after images - and call change
history function

SELECT * INTO TABLE xzxsc_usrmgr_info

FROM zxsc_usrmgr_info.

Sort Tables needed for SAP Comparisons

SORT xzxsc_usrmgr_info.

SORT yzxsc_usrmgr_info.

Set Update Indicator and Assign Fields

upd_zxsc_usrmgr_info = c_update.

objectid = c_objectid.

tcode = sy-tcode.

utime = sy-timlo.

udate = sy-datlo.

username = sy-uname.

Call SAP Routine to Update CDHDR and CDPOS

PERFORM cd_call_zsecurity.

ENDFORM. "ZXSC_USRMGR_INFO_02

&----

*& Form ZXSC_USRMGR_INFO_13

&----

text

----

FORM zxsc_usrmgr_info_13.

CLEAR xzxsc_usrmgr_info.

REFRESH xzxsc_usrmgr_info.

CLEAR yzxsc_usrmgr_info.

REFRESH yzxsc_usrmgr_info.

ENDFORM.

FORM CD_CALL_ZSECURITY .

IF ( UPD_ZXSC_AG_DSPLONLY NE SPACE )

OR ( UPD_ZXSC_COMP_AG_DET NE SPACE )

OR ( UPD_ZXSC_CP_MASTER NE SPACE )

OR ( UPD_ZXSC_CRTCD NE SPACE )

OR ( UPD_ZXSC_CRTX_CMNT NE SPACE )

OR ( UPD_ZXSC_FLOWS NE SPACE )

OR ( UPD_ZXSC_FLOW_STEPS NE SPACE )

OR ( UPD_ZXSC_GECRTX_CMNT NE SPACE )

OR ( UPD_ZXSC_MEMOS NE SPACE )

OR ( UPD_ZXSC_OBJ_COMMENT NE SPACE )

OR ( UPD_ZXSC_ORG_COMMENT NE SPACE )

OR ( UPD_ZXSC_PROF_TEST NE SPACE )

OR ( UPD_ZXSC_PROHIBITED NE SPACE )

OR ( UPD_ZXSC_RELEASE1 NE SPACE )

OR ( UPD_ZXSC_RISKS NE SPACE )

OR ( UPD_ZXSC_SOD_ACTIV NE SPACE )

OR ( UPD_ZXSC_SOD_CONFL NE SPACE )

OR ( UPD_ZXSC_SOD_EXCLUDE NE SPACE )

OR ( UPD_ZXSC_SOD_NOTES NE SPACE )

OR ( UPD_ZXSC_SOD_RTRAN NE SPACE )

OR ( UPD_ZXSC_SOD_TCODES NE SPACE )

OR ( UPD_ZXSC_STEP_ASSIGN NE SPACE )

OR ( UPD_ZXSC_USRMGR_INFO NE SPACE )

OR ( UPD_ZXSC_WRP_HEADER NE SPACE )

OR ( UPD_ICDTXT_ZSECURITY NE SPACE )

CALL FUNCTION 'SWE_REQUESTER_TO_UPDATE'.

CALL FUNCTION 'ZSECURITY_WRITE_DOCUMENT ' IN UPDATE TASK

EXPORTING

OBJECTID = OBJECTID

TCODE = TCODE

UTIME = UTIME

UDATE = UDATE

USERNAME = USERNAME

PLANNED_CHANGE_NUMBER = PLANNED_CHANGE_NUMBER

OBJECT_CHANGE_INDICATOR = CDOC_UPD_OBJECT

PLANNED_OR_REAL_CHANGES = CDOC_PLANNED_OR_REAL

NO_CHANGE_POINTERS = CDOC_NO_CHANGE_POINTERS

UPD_ZXSC_AG_DSPLONLY

= UPD_ZXSC_AG_DSPLONLY

UPD_ZXSC_COMP_AG_DET

= UPD_ZXSC_COMP_AG_DET

UPD_ZXSC_CP_MASTER

= UPD_ZXSC_CP_MASTER

UPD_ZXSC_CRTCD

= UPD_ZXSC_CRTCD

UPD_ZXSC_CRTX_CMNT

= UPD_ZXSC_CRTX_CMNT

UPD_ZXSC_FLOWS

= UPD_ZXSC_FLOWS

UPD_ZXSC_FLOW_STEPS

= UPD_ZXSC_FLOW_STEPS

UPD_ZXSC_GECRTX_CMNT

= UPD_ZXSC_GECRTX_CMNT

UPD_ZXSC_MEMOS

= UPD_ZXSC_MEMOS

UPD_ZXSC_OBJ_COMMENT

= UPD_ZXSC_OBJ_COMMENT

UPD_ZXSC_ORG_COMMENT

= UPD_ZXSC_ORG_COMMENT

UPD_ZXSC_PROF_TEST

= UPD_ZXSC_PROF_TEST

UPD_ZXSC_PROHIBITED

= UPD_ZXSC_PROHIBITED

UPD_ZXSC_RELEASE1

= UPD_ZXSC_RELEASE1

UPD_ZXSC_RISKS

= UPD_ZXSC_RISKS

UPD_ZXSC_SOD_ACTIV

= UPD_ZXSC_SOD_ACTIV

UPD_ZXSC_SOD_CONFL

= UPD_ZXSC_SOD_CONFL

UPD_ZXSC_SOD_EXCLUDE

= UPD_ZXSC_SOD_EXCLUDE

UPD_ZXSC_SOD_NOTES

= UPD_ZXSC_SOD_NOTES

UPD_ZXSC_SOD_RTRAN

= UPD_ZXSC_SOD_RTRAN

UPD_ZXSC_SOD_TCODES

= UPD_ZXSC_SOD_TCODES

UPD_ZXSC_STEP_ASSIGN

= UPD_ZXSC_STEP_ASSIGN

UPD_ZXSC_USRMGR_INFO

= UPD_ZXSC_USRMGR_INFO

UPD_ZXSC_WRP_HEADER

= UPD_ZXSC_WRP_HEADER

UPD_ICDTXT_ZSECURITY

= UPD_ICDTXT_ZSECURITY

TABLES

ICDTXT_ZSECURITY

= ICDTXT_ZSECURITY

XZXSC_AG_DSPLONLY

= XZXSC_AG_DSPLONLY

YZXSC_AG_DSPLONLY

= YZXSC_AG_DSPLONLY

XZXSC_COMP_AG_DET

= XZXSC_COMP_AG_DET

YZXSC_COMP_AG_DET

= YZXSC_COMP_AG_DET

XZXSC_CP_MASTER

= XZXSC_CP_MASTER

YZXSC_CP_MASTER

= YZXSC_CP_MASTER

XZXSC_CRTCD

= XZXSC_CRTCD

YZXSC_CRTCD

= YZXSC_CRTCD

XZXSC_CRTX_CMNT

= XZXSC_CRTX_CMNT

YZXSC_CRTX_CMNT

= YZXSC_CRTX_CMNT

XZXSC_FLOWS

= XZXSC_FLOWS

YZXSC_FLOWS

= YZXSC_FLOWS

XZXSC_FLOW_STEPS

= XZXSC_FLOW_STEPS

YZXSC_FLOW_STEPS

= YZXSC_FLOW_STEPS

XZXSC_GECRTX_CMNT

= XZXSC_GECRTX_CMNT

YZXSC_GECRTX_CMNT

= YZXSC_GECRTX_CMNT

XZXSC_MEMOS

= XZXSC_MEMOS

YZXSC_MEMOS

= YZXSC_MEMOS

XZXSC_OBJ_COMMENT

= XZXSC_OBJ_COMMENT

YZXSC_OBJ_COMMENT

= YZXSC_OBJ_COMMENT

XZXSC_ORG_COMMENT

= XZXSC_ORG_COMMENT

YZXSC_ORG_COMMENT

= YZXSC_ORG_COMMENT

XZXSC_PROF_TEST

= XZXSC_PROF_TEST

YZXSC_PROF_TEST

= YZXSC_PROF_TEST

XZXSC_PROHIBITED

= XZXSC_PROHIBITED

YZXSC_PROHIBITED

= YZXSC_PROHIBITED

XZXSC_RELEASE1

= XZXSC_RELEASE1

YZXSC_RELEASE1

= YZXSC_RELEASE1

XZXSC_RISKS

= XZXSC_RISKS

YZXSC_RISKS

= YZXSC_RISKS

XZXSC_SOD_ACTIV

= XZXSC_SOD_ACTIV

YZXSC_SOD_ACTIV

= YZXSC_SOD_ACTIV

XZXSC_SOD_CONFL

= XZXSC_SOD_CONFL

YZXSC_SOD_CONFL

= YZXSC_SOD_CONFL

XZXSC_SOD_EXCLUDE

= XZXSC_SOD_EXCLUDE

YZXSC_SOD_EXCLUDE

= YZXSC_SOD_EXCLUDE

XZXSC_SOD_NOTES

= XZXSC_SOD_NOTES

YZXSC_SOD_NOTES

= YZXSC_SOD_NOTES

XZXSC_SOD_RTRAN

= XZXSC_SOD_RTRAN

YZXSC_SOD_RTRAN

= YZXSC_SOD_RTRAN

XZXSC_SOD_TCODES

= XZXSC_SOD_TCODES

YZXSC_SOD_TCODES

= YZXSC_SOD_TCODES

XZXSC_STEP_ASSIGN

= XZXSC_STEP_ASSIGN

YZXSC_STEP_ASSIGN

= YZXSC_STEP_ASSIGN

XZXSC_USRMGR_INFO

= XZXSC_USRMGR_INFO

YZXSC_USRMGR_INFO

= YZXSC_USRMGR_INFO

XZXSC_WRP_HEADER

= XZXSC_WRP_HEADER

YZXSC_WRP_HEADER

= YZXSC_WRP_HEADER

ENDIF.

CLEAR PLANNED_CHANGE_NUMBER.

ENDFORM.

topic Re: saving created date and changed date automatically in Application Development and Automation Discussions

saving created date and changed date automatically

Re: saving created date and changed date automatically

Re: saving created date and changed date automatically

Re: saving created date and changed date automatically

Re: saving created date and changed date automatically