Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Picking Changed Records

Former Member
0 Kudos
319

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

1 ACCEPTED SOLUTION

christian_wohlfahrt
Active Contributor
0 Kudos
98

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

10 REPLIES 10

Former Member
0 Kudos
98

Hi,

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

Cheers,

Sam

0 Kudos
98

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

vetri

christian_wohlfahrt
Active Contributor
0 Kudos
99

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

0 Kudos
98

hi,

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

Vetri

0 Kudos
98

HI,

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

0 Kudos
98

it actually happens in my server

Former Member
0 Kudos
98

or try SM20

or RBE

or SAPWL* (STAT FILES)

regards

0 Kudos
98

Thanks Arun & Surpreet

Former Member
0 Kudos
98

was any answer helpful or very helpful

if yes do reward

regards.

Former Member
0 Kudos
98

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.