Skip to main content
Question

Annotation

  • June 10, 2025
  • 4 replies
  • 78 views

Saba
Level 7
Forum|alt.badge.img
  • Level 7
  • 16 replies

Hi everyone,

I want to use the Annotation Builder, but I don’t have a unique ID.

For example, the same material number exists in two different business units as you see in the picture.

What’s the best way to handle this?

 

Thanks for your help!

 

 

4 replies

Forum|alt.badge.img+2

If the material ID is not unique, it cannot serve as a primary key. To ensure uniqueness, additional columns can be combined with the material ID to form a composite primary key.


Saba
Level 7
Forum|alt.badge.img
  • Author
  • Level 7
  • 16 replies
  • June 16, 2025

Thanks for your reply!

How can I combine them ?


mallik.koruk11
Level 6
Forum|alt.badge.img+8

Create an Attribute using PQL - Material Number || ‘-’ || Business Unit will result as - WP941159-P18.


Saba
Level 7
Forum|alt.badge.img
  • Author
  • Level 7
  • 16 replies
  • July 7, 2025

Thanks ​@mallik.koruk11