How do we get the price strategy association start date and end date
Summary:
I am writing a report to fetch the pricing strategy, price list along with the method of pricing like Customer Number or Bill to Number. I am unable to find the table which stores Start Date and End Date of Price Strategy Association.
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
SELECT HP.PARTY_ID PRICING_PARTY_ID,
HP.PARTY_NUMBER PRICING_PARTY_NUMBER, HOU.NAME BU_NAME, QRS.NAME PRICING_STRATEGY_NAME,
QSD.START_DATE AS QSD_START_DATE, QSD.END_DATE as QSD_END_DATE,
Tagged:
0