Skip to main content
Question

Annotation

  • Jun 10, 2025 9:42 AM UTC
  • 4 replies
  • 437 views
Saba
Level 8
Forum|alt.badge.img+3

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

    Celonaut
    Forum|alt.badge.img+6

    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 8
      Forum|alt.badge.img+3
      • Saba
      • Author
      • Level 8
      • Jun 16, 2025 7:22 AM UTC

      Thanks for your reply!

      How can I combine them ?

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

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

      Saba
      Level 8
      Forum|alt.badge.img+3
      • Saba
      • Author
      • Level 8
      • Jul 7, 2025 10:01 AM UTC

      Thanks ​@mallik.koruk11 

        Community Code of ConductAccessibility statement