topic Re: Picking Changed Records in Application Development and Automation Discussions

Picking Changed Records

Former Member — Wed, 10 Aug 2005 12:23:45 GMT

hi all,

In my scenario, the program will pick only the PS Master data which is newly created & changed and then writes into a file on an hourly basis.

how to pick the changed records? because there is no time fields in the PRPS and PROJ tables.

and also if i change a record which is already created, no entry will be created in CDHDR and CDPOS tables.

Vetri

Re: Picking Changed Records

Former Member — Wed, 10 Aug 2005 12:29:23 GMT

Hi,

There is a field AEDAT in PRPS & PROJ. You can use this for taking the time.

Cheers,

Sam

Re: Picking Changed Records

christian_wohlfahrt — Wed, 10 Aug 2005 12:31:38 GMT

Hi Vetri!

Looks like own work:

Make an append / new table with pspnr key to add a flag field: already sent.

In a job (running every hour) you select entries with flag = space, after file creation you change the flag to 'X'.

If you prefer an own table, you should deactivate number range buffering and select document numbers higher then your z-table.

I hope you got the picture,

regards, Christian

Re: Picking Changed Records

Former Member — Thu, 11 Aug 2005 09:00:05 GMT

AEDAT is an date field. In my scenario it is an hourly basis.

vetri

Re: Picking Changed Records

Former Member — Thu, 11 Aug 2005 09:05:20 GMT

hi,

Is there is any Table for Transaction CJ20N to record the changes

Vetri

Re: Picking Changed Records

Former Member — Thu, 11 Aug 2005 09:38:20 GMT

HI,

check out if the changes are logged in CDHDR and CDPOS.

Re: Picking Changed Records

Former Member — Thu, 11 Aug 2005 09:39:03 GMT

it actually happens in my server

Re: Picking Changed Records

Former Member — Thu, 11 Aug 2005 09:40:54 GMT

or try SM20

or RBE

or SAPWL* (STAT FILES)

regards

Re: Picking Changed Records

Former Member — Fri, 12 Aug 2005 04:47:58 GMT

Thanks Arun & Surpreet

Re: Picking Changed Records

Former Member — Fri, 12 Aug 2005 05:28:04 GMT

was any answer helpful or very helpful

if yes do reward

regards.

Re: Picking Changed Records

Former Member — Fri, 12 Aug 2005 09:53:05 GMT

to add to it. If it does not work u have to check the change doc obj program in TXN SCDO. see u have the table added to the object. It has to get created in the chnge doc tables.