EWM S4 specific Tables like /SCWM/T300 are getting replicated in Snapshot Mgmt but failed to repopulated in Administer->Setup->Value Mapping config throwing error 'Incorrect Syntax '/'.
Other check tables like T001W, T006 are working fine.
Is this some sort of Value Mapping feature constraint of not able to determine '/' tables, please guide here to resolve it.
I believe there may be an issue with the / in the table name that would mean that we would need to place [ ] around the table name for the SQL to recognise the table. If you can raise a support ticket for this so that we can then investigate if this is a defect that needs a patch in the product that would be great.
If you click on the edit icon for the specific table in question you should be able to edit the SQL statement for the value mapping config.
Example:
SELECT MSEHI AS TARGET_VALUE, MSEHI AS LOAD_VALUE, MSEHT AS Description
FROM T006A AS C
change to
SELECT MSEHI AS TARGET_VALUE, MSEHI AS LOAD_VALUE, MSEHT AS Description
FROM [T006A] AS C
Please sign in to leave a comment.
Comments
1 comment