SADL_RS_SO_ROOT_DYN_DB_HINTS

DDL: SADL_RS_SO_ROOT_DYN_DB_HINTS SQL: SADL_SO_DYN_HINT Type: view

Reference Scenario: Sales Order Root

SADL_RS_SO_ROOT_DYN_DB_HINTS 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_RS_SO_ITEM_DYN_DB_HINTS _active_items $projection.id = _active_items.parent_id and $projection.act_indicator = 'X'
[*] SADL_RS_SO_ITEM_DYN_DB_HINTS _items $projection.id = _items.parent_id

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName SADL_SO_DYN_HINT view
EndUserText.label Reference Scenario: Sales Order Root view
Search.searchable true view
Consumption.dbHintsCalculatedBy ABAP:CL_SADL_RS_ROOT_DYN_DB_HINT 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_DYN_HINT'
@EndUserText.label: 'Reference Scenario: Sales Order Root'
@Search.searchable: true

// Dummy hints :HDB_HINT1 HHB_HINT ALL_DB_HINT1 HDB_HINT2,HDB_HINT3 ALL_DB_HINT2 ALL_DB_HINT3


//@AbapCatalog.dbHints: [{dbSystem: #HDB, hint:'HDB_HINT1'},

//                       {dbSystem: #HHB, hint:'HHB_HINT'},

//                       {dbSystem: #ALL, hint:'ALL_DB_HINT1'}] //AbapCatalog.dbHints is ignored in the presence of Consumption.dbHints

                       
// Consumption.dbHints is the new annotation and overshadows AbapCatalog.dbHints; allow listed RAP                                             

@Consumption.dbHints: [ 'HEX_INDEX_JOIN', 'CONCAT_FILTER', 'COLUMN_VIEW_ESTIMATION' ]
                       
//@Consumption.dbHints: [ {dbSystem: #HDB, calculatedBy: 'ABAP:CL_SADL_RS_ROOT_DYN_DB_HINT'},

//                        {dbSystem: #ORA, calculatedBy: 'ABAP:CL_SADL_RS_ITEM_DYN_DB_HINT'}]

@Consumption.dbHintsCalculatedBy: 'ABAP:CL_SADL_RS_ROOT_DYN_DB_HINT'

define view SADL_RS_SO_ROOT_DYN_DB_HINTS
  as select from sadl_rs_so_root as root
  association [*] to SADL_RS_SO_ITEM_DYN_DB_HINTS as _active_items on  $projection.id            = _active_items.parent_id
                                                                     and $projection.act_indicator = 'X'
  association [*] to SADL_RS_SO_ITEM_DYN_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_RS_SO_ITEM_DYN_DB_HINTS"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More