Skip to Content
Technical Articles
Author's profile photo Uladzislau Pralat

Creation of Compounded Dimensions with ABAP CDS Views

When it comes to compounded dimension ABAP CDS views you do not need to create them often. But when you do, you might be lacking experience in this area. In my blog I shed some light on this topic. Do not forget a bonus – Field Name dimension that can be used in your next change management CDS view query.

As you can see in my change management CDS view query example cryptic table fields are complemented with table field descriptions. It is possible thanks to using Field Name custom compounded dimension CDS view. Field Name dimension is compounded with Table Name dimension. This is because the same field might exists in multiple tables and have different descriptions. Compounded dimension takes care of it all.

There are a few important points you need to know when creating compounded dimension CDS views:

  1. Compounding fields are defined before compounded field in the list of key fields and annotated with foreign key association
  2. Compounded field is defined last in the list key fields and annotated with text association (if applicable)
  3. Representation key is defined as compounded field

There is only one important point you need to know in case of compounded text CDS view:

  1. Compounding fields are defined in the list of key fields before compounded field

Compounding dimension and text CDS views are very trivial:

You can download complete source code for Field Name dimension CDS view from GitHub:

ZI_FieldName

ZI_FieldNameText

ZI_TableName

ZI_TableNameText

 

 

Assigned tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Jelena Perfiljeva
      Jelena Perfiljeva

      Thanks for sharing, Uladzislau! I went on to search what the heck is this compounded dimension concept and found this Wiki post that might be helpful to those wondering the same. 🙂

      There is a diagram that I think explains the concept very well.

      Thank you!