How to check the records that were inserted in a day?Please Help!

[Former Member]

HI All,

How to check the records that were insterted in a day in a standard SAP table?

For example : I want retrieve the records that were added in a day in WLK1 table.

How do i do this?

Urgent!! Please help!

Thanks in advance!

Sandeep Shenoy

[Former Member]

Hello,

I have encountered the same issue and found the solution for that. (For some further requests on forum)

If you want to check history changes on a table without using CDHDR and CDPOS tables (it takes too long to analyse header change documents). You can use the following standard report : RSSCD150.

Regards,

Sami

[Former Member]

Hi sandeep,

use the fm CHANGEDOCUMENT_READ

Thanks

eswar

[Former Member]

HI

Changes to data within a table can be automatically logged. Such automatic logging of changes is called automatic table history. To turn on logging, tickmark the Log Data Changes check box on the Technical Settings screen

IF THIS IS ALREADY DONE FOR A PARTICULAR TABLE, YOU CAN GET THE RECORD OF CHANGES THAT YOU MADE FOR THAT PARTICULAR TABLE AS EXPLAINED UNDER

<a href="http://64.233.179.104/search?q=cache:pOdVy55jfAIJ:cma.zdnet.com/book/abap/ch06/ch06.htmHISTORYOFUPDATESINADAYINABAP&hl=en&gl=in&ct=clnk&cd=1">Automatic Table History and Change Documents</a>

IF ITS HELPFUL PLEASE REWARD POINTS

REGARDS

ANOOP

[Former Member]

Hi Guys,

Thanks to each one of you for a quick reply,

DATAE does not help me much based on the scenario i have,but CDHDR and CDPOS definetly helps.

Thanks again!

Sandeep Shenoy

[Former Member]

Hi sandeep,

1. we can use simple program and sql.

2. Just copy paste in new program.

REPORT abc.

DATA : wlk1 LIKE TABLE OF wlk1 WITH HEADER LINE.

PARAMETERS : mydate LIKE sy-datum.

SELECT * FROM wlk1

INTO TABLE wlk1

WHERE datae = mydate.

BREAK-POINT.

regards,

amit m.

[Former Member]

hi

When you are selecting from the table WLK1 in the where clause give DATAE = sy-datum.

write:/ sy-dbcnt.

hope this helps,

thanks,

priya

[former_member181962]

Hi sandeep,

Check for the field DATAE in WLK1 table.

Or else, you should go for cdhdr and cdpos tables as already suggested.

Regards,

Ravi

[vinod_gunaware2]

Hi

WLK1-DATAE Date of last change

Put today date in above field.

regards

vinod

[Former Member]

Hi,

In most of the cases, there is a created date field in tthe table itself.

if not, then you can always check in the history tables

CDHDR and CDPOS.

Hope this helps..

Regards,

Shashank