SADL_CDS_RS_SO_Root_w_DB_Hint

DDL: SADL_CDS_RS_SO_ROOT_W_DB_HINT SQL: SADL_SO_DB_HINT Type: view

Reference Scenario: Sales Order Root

SADL_CDS_RS_SO_Root_w_DB_Hint is a CDS View that provides data about "Reference Scenario: Sales Order Root" in SAP S/4HANA. It reads from 1 data source (sadl_rs_so_root) and exposes 5 fields with key field id. It has 2 associations to related views.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
sadl_rs_so_root root from

Associations (2)

CardinalityTargetAliasCondition
[*] Sadl_Cds_Rs_So_Item_w_DB_Hints _active_items $projection.id = _active_items.parent_id and $projection.act_indicator = 'X'
[*] Sadl_Cds_Rs_So_Item_w_DB_Hints _items $projection.id = _items.parent_id

Annotations (3)

NameValueLevelField
AbapCatalog.sqlViewName SADL_SO_DB_HINT view
EndUserText.label Reference Scenario: Sales Order Root view
Search.searchable true view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY id id
buyer_id buyer_id
seller_id seller_id
type_code type_code
_items _items 
@AbapCatalog.sqlViewName: 'SADL_SO_DB_HINT'
@EndUserText.label: 'Reference Scenario: Sales Order Root'
@Search.searchable: true

// Hint INDEX_SEARCH: Hints for Controlling Access Path

//                       Guides the optimizer to access the table by using the available index.

@AbapCatalog.dbHints: [{dbSystem: #HDB, hint: 'INDEX_SEARCH'}]
// Consumption.dbHints is the new annotation and overshadows AbapCatalog.dbHints


define view SADL_CDS_RS_SO_Root_w_DB_Hint
  as select from sadl_rs_so_root as root
  association [*] to Sadl_Cds_Rs_So_Item_w_DB_Hints as _active_items on  $projection.id            = _active_items.parent_id
                                                                     and $projection.act_indicator = 'X'
  association [*] to Sadl_Cds_Rs_So_Item_w_DB_Hints as _items on  $projection.id = _items.parent_id
{
  key id,
      act_indicator,
      buyer_id,
      seller_id,
      type_code,
      @Search.defaultSearchElement
      _items,
      _active_items
} 
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"SADL_RS_SO_ROOT"
],
"ASSOCIATED":
[
"SADL_CDS_RS_SO_ITEM_W_DB_HINTS"
],
"BASE":
[],
"VERSION":0
}
}*/

Learn More