Skip to Content
avatar image
Former Member

Information Steward : Date value changes when doing "view data" for table in SAP source

Hi Expert,

While performing "view Data" Under Data Insight for SAP table source into Information Steward, I am getting different value than it is really and which is causing me that i can't apply any date validation rule.

Any Suggestion is highly appreciated .

Shiva Sahu

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Oct 16, 2017 at 08:54 AM

    to_date (to_char(99999999 - to_decimal(GDATU, '.', ',', 8, 0) , '00000000'), 'YYYYMMDD')

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 12, 2017 at 06:26 AM

    error description. here GDATU is Field which is causing data issue

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 12, 2017 at 09:15 AM

    The GDATU field in the TCURR table field is stored in inverted date format. This is what you get and see in IS.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 13, 2017 at 11:28 AM

    Thank you Dirk . Also it would be great if you could suggest a solution to this issue.

    I have also tried using to_date () In Information Steward but that didn't work.

    Regards,

    Shiva Sahu

    Add comment
    10|10000 characters needed characters exceeded