Master Data Managment: Clear Valid From/To of Inventory Master Data
Dear Coresystems Helpdesk,
is there a possibilty to clear the date in the fields OITM.[validFrom] /.[validTo] with the Master Data Management?
I use the following SQL query to select the items with a Date in those fields.
SELECT T0.[ItemCode], T0.[validFrom], T0.[validTo] FROM OITM T0 WHERE T0.[validFor] = 'Y' AND (T0.[validFrom] IS NOT NULL OR T0.[validTo] IS NOT NULL)
But null as import value is not allowed. Is there a way to delete the dates?
Thank you in advance!
Please sign in to leave a comment.