topic Re: Change Documents for a Billing Document in Application Development and Automation Discussions

Change Documents for a Billing Document

Former Member — Wed, 24 Aug 2005 15:02:53 GMT

Hello All,

I need to write a report that captures all changes to a billing document regarding the pricing conditions. All billing document changes regarding pricing will appear under the OBJECTCLAS FAKTBELEG and TABNAME KONVC. If the FNAME is KEY, the CDPOS table will recognize that a change occured, however it does not capture what the change actually was. Is there a way to determine what this change is or am I misunderstanding what this entry is actually used for? Thanks for your help.

John

Re: Change Documents for a Billing Document

Former Member — Wed, 24 Aug 2005 17:11:01 GMT

Hi John,

I don't remember correcttly but it is stored VALUE_OLD and VALUE_NEW but in binary format. It will not show if you use SE16 to view table content. Try moving these fields into a type P field, you should be able to see the values (I Think !)

Cheers,

Sanjeev

Re: Change Documents for a Billing Document

Former Member — Wed, 24 Aug 2005 17:19:53 GMT

Use function module CHANGEDOCUMENT_READ. It will return you an internal table with all the changes based on your criteria. In that internal table you will have F_OLD and F_NEW fields, which will have the old and new values of the change.

Re: Change Documents for a Billing Document

Former Member — Thu, 25 Aug 2005 01:50:20 GMT

Hi John;

The standard report RV16ACHD gives a good display of all the changes to the conditions...

Cheers,

John

Re: Change Documents for a Billing Document

Former Member — Thu, 25 Aug 2005 03:58:25 GMT

Hi John,

If the Fname is given as Key, it means the key field of the table has been created => It is not a change. it is the first time creation of that record.

PS: Reward points for useful answers.

Regards,

Prabhu.

Re: Change Documents for a Billing Document

Former Member — Thu, 25 Aug 2005 04:33:37 GMT

Hi John,

In the Standard Report using SD_CONDITION_CHANGE_DOCS_LOAD function module for change logs,

If any addition/ deletion in the condition CDPOS value_old and value_new will be initial, in this case you need to retrive the values from KONV table with corresponding condition type.

Function module CHANGEDOCUMENT_READ used to capture all the changes, you need to pass Object class and objectid (document number ) and you get all the changes in the editpos internal table.

Cheers,

Sasi