How to extract data for condition records with different valid periods

[former_member841377]

Dear Gurus,

There was an error in the recent condition records price upload. Now, i want to extract the data into excel file depending on different valid dates. Please let me know how can i do this... in the extracted file i would like to have fields like, valid on and valid to dates, condition type, price list type, material, condition record no. , last changed date, last changed user id etc., please suggest...thanks in advance..

rgds

suri

[Former Member]

hi suresh

create a quick query (SQVI) and extract to excel table KONP

only thing you need to take care is table join for fields datab ( valid from) and tatbi (valid to) you need to take from right table which are present A-table,

Anil

[Former Member]

Hi Suresh,

You can create a pricing report using V/LA, specify the condition tables, and fields to be displayed.

Regards,

kev