extract customer master changes for two fields for about 150k customers

[former_member405498]

Hi SAP gurus

i have to extract the changes made for two fields in genral data tab of customer master>but i have to do it for about 200k customers.i know that we can use OV51 to report the changes but as this is huge number of customers i cant use that tcode.for example ,for these 200k customers i have to extarct the chnages made to serchterm field and data line filed in genral data.i have to get the old and new values.can u please suggest me how i can achieve this.

thanks in advance

[eduardo_hinojosa · Accepted solution]

Hi

Other possible way is run report RSSCD100 for object DEBI. You can do the filter with the table (KNA1, KNB1 and so on) and after, in the ALV do a filter for the fields.

I hope this helps you

Regards

Eduardo

[Jelena]

Perhaps a simple query on the change documents (CDHDR / CDPOS tables) would do, especially if it's a one-time thing. Field name is one of the keys in CDPOS, so if you need a list for just two fields, it might be more efficient.

[Former Member]

Dear KM Ji,

After extract the report in OV51 you click on field name and set the filter, so that you can sort out the data which you required.

Regards

Dev D (Naidu)

[former_member405498]

thanks for the reply DEVD ,but the thing is i could nt execute the tcode and it retund the dump evn fora set of 3k customers.

[Lakshmipathi]

it retund the dump evn fora set of 3k customers.

Execute OV51 in background

G. Lakshmipathi