cds problem: can i make more associations in cds to the same target

[helmut_sieberer]

hello,

maybe i can get some help:

i have a customizing table which holds different informations.

in my source i have 3 fields for classifications (aKlassi, kbKlassi, gpKlassi) - if i want the text for this 3 keys, i have to read it in zkd_fieldcust- fieldname for the text is there fvalb.

aKlassi with type '30' , kbKlassi with type '31' and gpKlassi with '32' (fieldname fvalt in zkd_fieldcust)

but i get no values for the 3 textfields

first association to zkd_dokverfahren works fine - but that is a simple one

thanks for your help

Helmut

define view zkd_icf_items_cds as select from zish_dokiticf as icfItem

// association zum Dokumentationsverfahren
association [1] to zkd_dokverfahren as _dokVerfahren on
$projection.dokvfk = _dokVerfahren.dokvfk 

// association zu aKlassifikation
association [1] to zkd_fieldcust as _aKlassi on
$projection.dokvfk = _aKlassi.dokvfk and
_aKlassi.fvalt =  '30' and
$projection.aKlassi = _aKlassi.fvalk

// association zu gpKlassifikation
association [1] to zkd_fieldcust as _gpKlassi on
$projection.dokvfk = _gpKlassi.dokvfk and
_gpKlassi.fvalt =  '31' and
$projection.gpKlassi = _gpKlassi.fvalk


// association zu kbKlassifikation
association [1] to zkd_fieldcust as _kbKlassi on
$projection.dokvfk = _kbKlassi.dokvfk and
_kbKlassi.fvalt =  '32' and
$projection.kbKlassi = _kbKlassi.fvalk

{

    key icfItem.dokvfk,
    key icfItem.itemm,
    key icfItem.items,
  
    icfItem.bezeichn,
    icfItem.aklassi,
    icfItem.gpklassi,
    icfItem.kbklassi,
    _dokVerfahren.bezeichk,
    _aKlassi.fvalb as aKlassiText,
    _gpKlassi.fvalb as gpKlassiText,
    _kbKlassi.fvalb as kbKlassiText,