Picking Changed Records

[Former Member]

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

[Former Member]

Hi,

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

Cheers,

Sam

[Former Member]

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

vetri

[christian_wohlfahrt]

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

[Former Member]

hi,

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

Vetri

[Former Member]

HI,

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

[Former Member]

it actually happens in my server

[Former Member]

or try SM20

or RBE

or SAPWL* (STAT FILES)

regards

[Former Member]

Thanks Arun & Surpreet

[Former Member]

was any answer helpful or very helpful

if yes do reward

regards.

[Former Member]

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.