Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Timestamp as key field on ODS

Hello Gurus,

I have defined as key, 0date and 0time fields on my ODS so that I get unique records. However, on loading data to the ODS, I still get duplicate 0date and 0time entries. I am populating the 0date with sysdatum and 0time with system local time at runtime within the update rules. However, for some reason, most of the records are being populated with the same 0date and 0time value. What is the best method for ensuring a unique timestamp for each record and if this cannot be achieved, can someone tell me how to generate a unique sequence?

Former Member
Not what you were looking for? View more on this topic or Ask a question