2006 Jan 26 7:53 PM
Dear Gurus,
How can I capture conditions change date either at the sales side or purchase side.There is a field in KONV-KDATU but this contais the pricing date at the time of creation. I'm looking for condition change date.
Waiting for response.
Thanks in Advance,
Suresh.
2006 Jan 27 11:58 AM
Hi Suresh!
Document conditions or master data conditions? Or with other words, do you look for changed purchase / sales orders, are you looking for changes done in ME12, MEK2, VK12...
Anyway, change documents (tables CDHDR / CDPOS) will hold the data.
Purchase order has object EINKBELEG and objectid EBELN
Sales order has object VERKBELEG and objectid VBELN
Conditions have object COND_A and objectid KNUMH.
You can search yourself for specific field changes in CDPOS or take some function modules (e.g. CHANGEDOCUMENT_PREPARE_DISPLAY) for display.
Regards,
Christian
2006 Jan 27 12:28 PM
Hi Suresh,
In table CDPOS OBJECTCLAS VERKBELEG
OBJECTID Sales Order Number
CHANGENR
TABNAME KONVC
Get CDHDR-UDATE for this record
In table CDHDR :OBJECTCLAS VERKBELEG
OBJECTID Sales Order Number
CHANGENR CDPOS-CHANGENR
CDHDR-UDATE will give you the Change CONDITION date.
Hope this helps.
Regards,
Sudheer
2006 Jan 27 5:04 PM
Dear Sudhher,
Plese let me know , how can I get even for the purchase conditions. I mean I also want the chain to trace the change date of conditions for purchase order/Purchase contract.
Thanks in Advance,
Suresh
2006 Jan 27 5:09 PM
Hi Suresh,
CRHDR & CDPOS will contain all the history about any changed documents.