Skip to Content
author's profile photo Former Member
Former Member

table saving all the changes to the document

hi,

scenario is : Sales order is been created and the shipping date is calculated as 2 months from toay ( what what ever reason, but that is not important) now after a couple of days its changed to some other date. I can see the changes in display document changes but some how am not able to find the table where they are getting stored. I want to find the original shipping date/mat avail date. This is important for backorder report.

Please help

Regards

Hrishi

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on May 23, 2007 at 01:42 AM

    i am not sure but check with cdhdr,cdpos

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 23, 2007 at 02:04 AM

    Hi Hrishi,

    Those tables are CDHDR & CDPOS.

    Join CDHDR and CDPOS on Objectclas, objectid and change number where ( Objectclas = 'VERKBELEG' or TCODE = 'VA02' )and Object ID = Sales order number)

    You will get the changes made to that particular order.

    CDPOS has 2 fields tabname & fname, which will contain the table and field you are trying to search for. And VALUE_OLD and VALUE_NEW will contain old and new values for that field.

    Code will be :

    SELECT VALUE_OLD INTO G_VALUE

    FROM CDHDR AS H

    INNER JOIN CDPOS AS P ON

    HOBJECTCLAS = POBJECTCLAS

    HOBJECTID = POBJECTID

    HCHANGENR = PCHANGENR

    WHERE (HOBJECTCLAS = 'VERKBELEG' OR HTCODE = 'VA02' )

    AND H~OBJECTID = sales order no

    AND H~TABNAME = table name(say vbrk)

    AND H~FNAME = field name.

    Hope this helps.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Experts

      I need help to developed report for the following

      I had gone through the tables there are CDHDR and CDPOS , from this tables

      the following items have to be retrive to display the report as in attachement

      These standards reports are taken from RVSD100 and RVSD200 reports which allow viewing changes on a single sales document in online mode howver the selection paratmeters for these two standard reports does not allow the selection parameters by plant code, document number, date ranges and also does not allow multiple sales document to be listed at the same time

      I need a report that will allow them to list the changes made in the contract documents with more ranges options on the report selection parameters

      basically this customised report will retrive all the changes made in sales contract documents within a plat , date ragne and other selection paramters

      The report must allow ALV display also

      sales office code and sales office description

      + contract document number

      sort by date, header data filed name <01> with old and new values changes and username

      sort by date, header data field name <02> with old and new values changes and username

      etc....

      etc...

      can you please help me how to start do we required funtional module etc.,I know it is easy but i need some push to start.

      regards

      Piroz

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.