Changing a custom report to be time sensitive

[Former Member]

Hi

We need to change the custom report zvenclass, it is a report that tells us the amount spent for each vendor in a specific class. I have the date/time sensistive information for the amount spent but not the change in vendor class from the vendor master. I need this to be date driven too. As in if a vendor is a small business in 2005 and you change the vendor to be a large vendor in 2011. Then I want the report for dates and values in 2008 to show small business and the dates and values in 2011 to show large business.

Any inputs on this will be appreciated.

Thanks

[Former Member]

We are trying to solve this by altering the code for the report.

Will update if it works though.

Thanks Christian for the help though.

[Former Member]

Hi Christian,

Thanks for your help,

Yes you are right, the assignment is not time dependent, it has to be manually changed.

I did see through the CDHDR and CDPOS tables, but could not pinpoint to the changes in the valuation classes.

Is there any other way if I can find whether I can find the changes?

Now I did review the values from the custom tables, here I find that there is a difference in the sum totals of the postings when I add up the individual years compared to the consolidated report (for ex: 200720082009 is not equal to 2007 to 2009) so am I right in assuming that the system does account for the changes. Any other help in this regard would be appreciated.

Regards.

Edited by: sapsap10 on Sep 14, 2010 4:59 PM

[Former Member]

Hi,

I assume that the assignment of a vendor to a particular class is not time-dependent (like the validity date from a cost center master data) because then you would have the solution already.

Check if there is a change document created when the vendor class is changed. If yes, the information is stored in tables CDHDR, CDPOS. You can use this information in your Z-report.

But if the change is not recorded at all there is no way to find the change date. and use this in your report.

Best regards, Christian