topic Re: Getting date changes in Purchase Requisition in Application Development and Automation Discussions

Getting date changes in Purchase Requisition

Former Member — Wed, 07 Mar 2007 14:22:38 GMT

Hi all,

Does anybody know how to find the date of change status in purchase requisition (transaction ME53N, menu "Environment/Item changes") ?

Maybe the solution is in the "change document", but I don't know how to find this.

Thanks for your help,

Re: Getting date changes in Purchase Requisition

Former Member — Wed, 07 Mar 2007 14:35:34 GMT

Use the function modules:

CHANGEDOCUMENT_READ_HEADERS

CHANGEDOCUMENT_READ_POSITIONS

to read the change document info

Regards,

Ravi

Re: Getting date changes in Purchase Requisition

Former Member — Wed, 07 Mar 2007 14:52:55 GMT

Thanks for your answer, but I don't see how to use this function because I'm working on table EBAN in my report, so how can I do the link with the function modules ?

Regards,

Re: Getting date changes in Purchase Requisition

Former Member — Thu, 08 Mar 2007 10:13:09 GMT

Hi,

U can find the changes done in 2 table:cdhdr, cdpos.

In CDPOS table, 1)give tabname as table name ie. eban in your case,

2)give objectclas as 'BANF',

3)object id - pr no

4)fname- field name

you wil get the change details-item level.

As for header,

In CDHDR ,give 1)give objectclas as 'BANF',

2)object id - pr no

3)USERNAME- User who changed it(if known)

4)UDATE -Change Date

you wil get the change details-HEADER

Hope this solves your proble,

Viji

Re: Getting date changes in Purchase Requisition

Former Member — Thu, 08 Mar 2007 10:15:22 GMT

Hi,

U can find the changes done in 2 table:cdhdr, cdpos.

In CDPOS table, 1)give tabname as table name ie. eban in your case,

2)give objectclas as 'BANF',

3)object id - pr no

4)fname- field name

you wil get the change details-item level.

As for header,

In CDHDR ,give 1)give objectclas as 'BANF',

2)object id - pr no

3)USERNAME- User who changed it(if known)

4)UDATE -Change Date

you wil get the change details-HEADER

Hope this solves your proble,

Viji

Re: Getting date changes in Purchase Requisition

Former Member — Fri, 09 Mar 2007 15:58:12 GMT

Hi Viji and thanks for your answer which solves my problems.

Regards,