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.

Didn't find what you were looking for?

New post