1. SAP Glossary
  2. SAP BusinessObjects Design Studio
  3. non-compound key


What is non-compound key in SAP BI-RA-AD - SAP BusinessObjects Design Studio?


SAP Term: non-compound key

  • Component: BI-RA-AD

  • Component Name: SAP BusinessObjects Design Studio

  • Description: In SAP Web Dynpro apps, certain characteristic values can be shown together with their superordinate characteristic value. When you don't show this superordinate characteristic, you display the non-compound key. For example, G/L accounts can be shown as follows: Description ID Compound Key Chart of Accounts/G/L Account ID YCOA/10100000 Non-Compound Key G/L Account ID 10100000


Smart SAP Assistant

  • Key Concepts: 
    A non-compound key is a type of key used in SAP BusinessObjects Design Studio (BI-RA-AD) to identify a single record in a database table. It is composed of one or more fields that uniquely identify a record, and it is used to ensure that no two records have the same key. 
    
    How to use it: 
    In SAP BusinessObjects Design Studio, non-compound keys are used to identify records in a database table. To create a non-compound key, select the fields that will be used to uniquely identify each record. These fields can be any combination of text, numbers, or dates. Once the fields have been selected, they can be used to create a unique identifier for each record in the table. 
    
    Tips & Tricks: 
    When creating a non-compound key, it is important to select fields that will not change over time. This will ensure that the key remains unique and can be used to accurately identify each record in the table. Additionally, it is important to select fields that are not likely to be duplicated in other tables, as this could lead to confusion when trying to identify records. 
    
    Related Information: 
    Non-compound keys are just one type of key used in SAP BusinessObjects Design Studio. Other types of keys include compound keys and foreign keys. Compound keys are composed of multiple fields and are used to identify multiple records in a database table. Foreign keys are used to link two tables together and are composed of fields from both tables.
    • Do you have any question about this SAP term?


      Upgrade now to chat with this SAP term.

Related SAP Glossary Terms

Click the links below to see the following related SAP glossary terms:
Rating
The AI Support Assistant is great. It provides comprehensive assistance even on the most difficult issues. I highly recommend this service.
Rate 1
John Jordan
SAP Consultant & Author