What you need is called smart-link with intent-based navigation: a link which navigates to business object details by reading its semantic properties aka semantic object.
Semantic object can be defined in two ways:
- Through template-based approach, via annotation modeler in Web-IDE. Inside
@UI.Lineitem
add DataFieldWithIntentBasedNavigation
and point it to your field name coming from CDS report

the only difference from this GIF is that you needn't to specify GUI_NAVIGATE
property
Through column definition in CDS view
@Consumption.semanticObject: 'BusinessPartner'
@UI: {
identification: [{label: 'Vendor No', position: 10}],
lineItem:[{
position: 10,
semanticObjectAction: 'manage',
type: #WITH_INTENT_BASED_NAVIGATION
}],
selectionField.position: 10
}
Semantic object are stored in /UI2/SEMOBJ
and /UI2/SEMOBJ_SAP
tables, check the correct object before developing.