Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Combine 3 tables in a CDS View [Problems with BEZEI20]

former_member812625
Explorer

‎2023 Jun 17 1:11 AM

0 Kudos
494

Hey everybody,

I'm writing a CDS View on the table [bseg] and already included information from [knb5].

Now, as the information in [bseg] doesn't have everythign I need, I need to combine 3 more tables, one is already an own CDS View [CDS_View]

The structure should be:

bseg.xref1 on knb5.

bseg.xref1 on CDS_View.KVGR1

CDS_View.PRCTR on CEPC.PRCTR

bseg.bukrs = knb5.bukrs

Tough for me. Moreover it seems that additional information for CDS_View.KVGR1 are stored in the table BEZEI20. However now I'm struggeling. I found out that behind the BEZEI20 is the table [TVSDT] - however there are online 3 fields? And none is working on the CDS_View.KVGR1 ? Although I see in the SAP that there should be the information.. Is it possible to combine these? Is BEZEI20 something special?

Thanks for help

1 REPLY 1

former_member812625
Explorer

‎2023 Jun 17 1:16 AM

0 Kudos
428

It seems that the description in the BEZEI20 is a "dynpro field"? Can I address that in the CDS view?