SAP Knowledge Base Article - Preview

3501259 - DTP execution fail with error "invalid DATE, TIME or TIMESTAMP value"

Symptom

When executing a DTP below message error appears:

  • invalid DATE, TIME or TIMESTAMP value: search table error: [6931] Failed to materialize column 'xxxxxxx'. Error: attribute
    date or wrong syntax;if(chars(string([here]daydate("xxxxxxx")) ) = 0, '00000000', "xxxxxxx"), xxxxxxx = 'X'[string]
  • A database error occured. The error message in the database was: "invalid DATE, TIME or TIMESTAMP value: Cannot convert string '{value}' to daydate". 


Read more...

Environment

SAP BW/4HANA

Product

SAP BW/4HANA all versions

Keywords

Invalid, DATE, TIME, TIMESTAMP, value, search table error, 6931, 69 31, Failed to materialize column, Error, attribute date or wrong syntax, if(chars(string([here]daydate, string, data, type, transformation, routine, mapping, ADSO, TRFN. , KBA , BW4-DM-TRFN , SAP HANA execution in Transformation and DTP , BW4-DM-DTP , ABAP Orchestration of Data Transfer Process , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.