Skip to Content
Former Member
Dec 15, 2015 at 02:28 PM

Date value conversion in SAP BODS


SAP table PRPS has a date field 'USR08' and when trying to extract using BODS, blank date values in SAP are getting converted into some default values.

When the target field is set as varchar ,

(i.e). SAP_PRPS.USR08(date) ---> BODS.USR08(VARCHAR)

Explicit usage of to_Char (Blank --> 19000101)

Direct casting to varchar (Blank --> 00000000)

both are giving different defaults in place of blank.

When the target field is also set as Date ,

(i.e). Direct extract of date

PRPS.USR08(date) ---> BODS.USR08(date)

(Blank --> 1900.01.01)

Format of date (YYYYMMDD,DDMMYYY,YYYY.DD.MM,YYYY-DD-MM) is not the issue. Default in places of blank is the only issue.

What could be the reason for blanks getting converted into random defaults ?

Note : Version of BODS used : 4.2 , DB Connection : SQL Server management Studio 2008