Table for SD Historical data

[Former Member]

Hi All,

I have one issue in knowing SD historical data.

Assuming a sales order is created on 1st April 2009 using a transaction VA01.

One month hence on 1st May 2009 the data becomes historical data.

This historical data is then used for sales budgeting using the infostructure S901.

What are the standard SAP SD tables that store the historical data?

Is there a program that triggers the movement of data from the Standard SAP SD tables that store the sales order details to the standard SAP SD tables that store the historical data and then to the infostructure S901?

Thanks,

Deep.

[Former Member · Accepted solution]

Hi,

You can use "CDHDR" table for checking the changes for the Header.

Also "CDPOS" table for checking the changes for Item details.

You can also use "TLOG" for History tracking.

Regards,

Krishna.

[Former Member]

Hi Deep

You can use CDPOS and CDHDR table in SAP to check the histroy of Sales document.

[Former Member]

Hello Deep,

Use document changes table CDHDR.You can the get history about the documents.

I think so this resolves your problem.

Best Regards

Vikram