topic Re: How to Know Customer whose data was updated in Application Development and Automation Discussions

How to Know Customer whose data was updated

Former Member — Mon, 31 Jul 2006 11:03:53 GMT

hi,

can u tell me how to know customers whose data was update by some .

my requirement is that find customers whose data was modified.

<b>can u tell me bapi names to find modified customers.i can give customer id as input parameter.</b>

regards

Guru

Re: How to Know Customer whose data was updated

Former Member — Mon, 31 Jul 2006 11:08:56 GMT

see if the customer number has more than one record in CDHDR /CDPOS tables.

Regards,

Ravi

Re: How to Know Customer whose data was updated

naimesh_patel — Mon, 31 Jul 2006 11:11:28 GMT

Hello,

You can get the change details from table CDHDR and CDPOS.

Pass

OBJECTCLAS = DEBI

Object value = "Customer"

TO CDHDR and take CHANGENR.

and then pass OBJECTCLAS,Object value, CHANGENR to CDPOS. It will give the field name, old value and new value.

Regards,

Naimesh

Message was edited by: Naimesh Patel

Re: How to Know Customer whose data was updated

Former Member — Mon, 31 Jul 2006 11:21:31 GMT

HI,

U see the Table TOJTB where u can get all the information for the bapi Version etc...

Go to transaction SWO1, enter the name of the object type for your BAPI, hit display button, hit header button on next screen.

This will show you transport data, change data, customization etc for the object type.

Regards,

Laxmi.

Re: How to Know Customer whose data was updated

Former Member — Mon, 31 Jul 2006 11:26:54 GMT

hi,

Check for the changed details from CDHDR & CDPOS tables

Re: How to Know Customer whose data was updated

Former Member — Mon, 31 Jul 2006 12:36:09 GMT

Hi,

select from CDHDR table using keys :

OBJECTCLASS = DEBI,

OBJECTID = 'CUSTOMER NO' and

CHANGEIND = 'U'. (THIS is important to get records which are updated from old values).

Take the CHANGENR from CDHDR using above keys and pass it to CDPOS to get the actual changed values.

All the best.

Regards,

Leo

Re: How to Know Customer whose data was updated

Former Member — Mon, 31 Jul 2006 12:50:32 GMT

i am JCO programmer, can u please help me for knowing whether the customer information or product information had updated in R/3.

thanks and regards,

Naga laxmi