Can't we add new dates automatically via MDIS- unmapped values- ADD

[Former Member]

Hi,

I have a qualified table with non qualifier as Date(TYPE: Literal Date).

and Qualifiers as Valid from and valid to.

We have 4 dates currently in Date field.

Our incoming file will have New dates init, So want these new dates to be added automaticaly via Import map.

I have set the Date field property as MDIS unmapped fields as - ADD.

But it is not adding new dates.

When i have Date field with Type TEXT and not 'Literal Date' then the new dates from Incoming file are added automatically.

Is this Normal that MDIS unmapped value - ADD will not add date Type fields???

Please Help

KR

John

[Former Member · Accepted solution]

Hi John,

I am afraid to say but you are right this is some sort of bug, So I would suggest please raise an OSS note with SAP to find more details on this.

Please go through this complete thread where it throws error for Literal date but works absolutely fine for Text.

Regards,

Mandeep Saini

[Former Member · Accepted solution]

Hi,

One of my collegue raised this question with SAP and the response was that this functinality is not available for date fields.

At the mevement MDIS Unmapped values ADD will update Text fields and not fields of type Literal Date.

At the movement there are no plans to build this functinality in the next releases.

Anyways, thanks for the answers Experts.

KR

John

[Former Member]

Hi John,

Check the incoming date format if it for ex in YYYYDDMM check in import manager configuration dates and set date format as dere in file and all the new values will be created.

Regards

Sharath

[Former Member]

Hi,

the incoming date format is MM/DD/YYYY.

In configutration parameters it is mentioned as MM/DD/YYYY format.

If the incoming file has Existing dates in MDM then it updates Fine.

But if the Incoming file has a new date then it failes with value exception..

'error message : Type mismatch. Invalid field values.<LF/></Trace>

'

cant understand this behaviuor of Literal date Field...

Can anyone please help...

KR

John

[Former Member]

Hi,

Can anyone help please..

Tried multiple options but nothing fixed the bug..

KR

John