CDS view extension association text

[asto]

Dear Community Members,

We tried to extend our first CDS view with CO-PA (WW) fields. As reference we used blog on LINK. We successful get fields into the C_MARKETSEGMENTQ2501, but problem is because we can't get text displayed in query browser.

What we have:

And what we would like to have:

We tried with text association LINK1 and LINK2, but we didn't have any success, we are not able to get it work.

So is it even possible to get text elements displayed in query browser and we are just doing something wrong? Are there any good source where can i learn how to do it?

Source code:

c-marketsegmentq2501-extension.txt

Best regards,

Alen

[former_member40251]

Hello Alen Stopar,

did you have success getting the text for the COPA Fields on the CDS views?

If yes, can you share the solution?

[dmitry_kuznetsov1]

Alen,

I would test them one-by-one, E_*, then I_*, then C_*. Are you getting the texts on any of the levels?

Also, I think you should do associations only on I_* level here..

Dmitry Kuznetsov

BI Consulting

[dmitry_kuznetsov1]

Hi,

The underlying t-tables do not exist in my system.

I would start analysis by seeing if texts are visible in underlying generated ODP provider.

Try:

Tcode RSRTS_ODP_DIS

CDS ZV_WWNP_T2500_V2

See if you have a text icon next to a field wwnp.

Cheers,

Dmitry Kuznetsov

BI Consulting

[asto]

Hello Dmitry

Thank you for your answer.

I checked in RSRTS_ODP_DIS for text icon and it is here.

I think on this layer everything is fine. Problem is in next step where i want to add association.

I have 3 additional views:

1. ACDOCA Extension for WW fields, where I extend E_JournalEntryItem,

2. Extension of Actual plan JEI Cube, where I extend I_JournalEntryItemCube,

3. Extension of Market Segment actual, where I extend C_MarketSegmentQ2501.

Soruce for extending E_JournalEntryItem:

@AbapCatalog.sqlViewAppendName: 'ZE_FIN_CDS_JEI'

@EndUserText.label: 'ACDOCA Extension for WW fields'

extend view E_JournalEntryItem with ZE_JOURNAL_ENTRY_ITEM

association [0..1] to ZV_WWNP_KEY_V2 on $projection.ze_wwnp_pa = ZV_WWNP_KEY_V2.wwnp

{

@ObjectModel.foreignKey.association: 'ZV_WWNP_KEY_V2'

Persistence.wwnp_pa as ze_wwnp_pa,

ZV_WWNP_KEY_V2

}

Is this correct or did I something wrong?

Best regards,

Alen