Expired Price Report

[senowak]

Hello there,

I wish to ask you about an expiring price report, but with specific requirements.
I use ZEXP t-code or display condition records in VK13 for that, but let me explain what I need.

For example, I need to extend prices valid till 12/31/2023 for next year.
However some prices are valid for each year f.e. 1/1/2023-12/31/2023 and then different price for 1/1/2024-12/31/2024.
If I use in ZEXP or VK13 valid to date 12/31/2023, report shows me that this price will expired, although the price is also set for the next year. I can use valid to date 12/31/2024 or even 9999, but then I have to review a few thousand records and check which of them have valid prices for next years.

My question is, is there a possibility to generate a report for expiring prices, but only if there is no any price for next year?

Thank you in advance for any suggestions.

[AlexGourdet]

Thank you for visiting SAP Community to get answers to your questions.

As you're looking to get most out of your community membership, please consider include a profile picture to increase user engagement & additional resources to your reference that can really benefit you:

• Profile https://developers.sap.com/tutorials/community-profile.html
• Tips for Questions: https://community.sap.com/resources/questions-and-answers
• Consider to take our Q&A tutorial at: https://developers.sap.com/tutorials/community-qa.html.

I hope you find this advice useful, and we're happy to have you as part of SAP Community!

All the best,

Alex

[kothandaraman_nagarajan]

Hi,

Have you tried with V/LD? You can define at start of validity and at end of validity period.

Regards,

Nagarajan

[senowak]

Hi there,

Thanks for your comments.

However, I have tried V/LD, but in case if we have price valid till 12/31/2023 and then new one (for the same part number) from 12/31/2024, I will see in V/LD only one if I set validity range till 12/31/2023 or both if I set till 12/31/9999.
I just wish to see only prices with no continuation in next year (price set till 12/31/2023 and there is no any price for 2024 f.e.)

Regards,

Sebastian