R/3_4.70: Last modified data for any field on vendor master

[Former Member]

Hello Gurus,

I need to extract a report on the existing vendors and Company code assignment in our R/3 system.

I am using SQVI (tcode) to create a Table join query on LFA1 & LFB1.

I have got all the fields except the Last Modified On. These tables don't have such a field.

I know the changes to Vendor master are stored in CDHDR/CDPOS.

I want a simple way of finding out when was a Vendor master last changed (any fields).

Please provide your inputs.

Thanks,

Sushil.

[former_member184701 · Accepted solution]

dear,

just an example.

run SE11 or SE16 for table CDHDR

Table Contents - Display

type KRED in objectclas

type your vendor number in objectid (add leading zeroes)

execute

and get all changes for that vendor (one change = one record)

regards,

[Former Member · Accepted solution]

Thanks for your reply.

I had to extract the last modified date for about 35000 records.

So used SQIV instead and downloaded the data to an excel and used Pivot tables in excel to get the data pretty easliy.