Skip to end of metadata
Go to start of metadata

Modeling Rule

  1. In CDS, short, medium or long text is modeled like this: If there is a text field with length <= 20, it is mapped to TXTSH, With length between 21 and 40 it is mapped to TXTMD and the other to TXTLG. By default, the shortest text is displayed.
  2. The time independent text CDS view should contain unique values. That is, there is no multiple text records for the same master data value.
  3. The time dependent text CDS view should contain unique value for any given time spot. That is, there is no multiple text records for the same master data value for any given time.


If point 2 or 3 are broken, the following may be observed:

  1. A query build on CDS model may get unexpected key figure multiplication when drill down some attribute text. The reason is similar to the effects explained in Ambiguous Join. Unique text is a fundamental pre-requisite for CDS modeling.
  2. In the query result output, one of the text record is shown as the text,  which may not be the one as expected.

Topics/Examples

  • No labels