Table or FM for finding customer deleted date - Distribtn channel specific

[former_member624107]

Hi All,

I need your help in getting table name or any function module which will give the customer delete date.

I can not use CDHDR table since it only gives the customer number.( Same customer can exist in different distribution channel and i want to know the specific date on which specific distribution channel customer is deleted).

Note: Deleted date is not available in KNA1 or KNVV.

Any pointers will be rewarded.

Thank You.

Regards,

Sheeba

[Sridharnekkanti]

Hi,

you can get the deleted date from the CDHDR & CDPOS tables.

After deletion the record history will save in CHHDR & CDPOS tables.

To get the Sales Orga & Distribution, Refer the fields TABNAME & TABKEY in the table CDPOS.

[Former Member]

Hi,

Call FM CHANGEDOCUMENT_READ with parameters

OBJECTCLASS = 'DEBI'  &
OBJECTID    = <CUSTOMERID>.

Output structure EDITPOS will have change document data of all

customer related tables.

Regards

Vinod

[former_member624107]

Thanks for the help...

Regards,

Sheeba

Edited by: Sheeba Bhaskaran on Jul 6, 2010 2:27 PM

Edited by: Sheeba Bhaskaran on Jul 6, 2010 2:28 PM