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]


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-ME-TRFN , Transformation Metadata , BW4-ME-ADSO , DataStore Object (Advanced) , BW4-ME-DTP , Data Transfer Process Metadata , Known Error

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.