SADL_CDS_RS_SO_Root_Param_Drv

DDL: SADL_CDS_RS_SO_ROOT_PARAM_DRV SQL: SADL_SQL_SO_RTPD Type: view

Reference Scenario: Derivation Test

SADL_CDS_RS_SO_Root_Param_Drv is a CDS View that provides data about "Reference Scenario: Derivation Test" in SAP S/4HANA. It reads from 1 data source (sadl_rs_so_root) and exposes 8 fields. It has 2 associations to related views.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
sadl_rs_so_root root from

Parameters (2)

NameTypeDefault
p_bp_id sadl_rs_id
p_type_code sadl_rs_tc

Associations (2)

CardinalityTargetAliasCondition
[*] Sadl_Cds_Rs_So_Item _items $projection.id = _items.parent_id
[0..1] Sadl_V_Aunit_Srs_Bp _seller $projection.seller_id = _seller.bp_id and $projection.act_indicator = 'X'

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName SADL_SQL_SO_RTPD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Reference Scenario: Derivation Test view

Fields (8)

KeyFieldSource TableSource FieldDescription
lookupEntitySadl_Cds_Rs_Bp_Param_Drv
resultElementtype_code_transl
act_indicatorXkeyid
buyer_id buyer_id
seller_id seller_id
type_code type_code
_items _items
_seller _seller 
@AbapCatalog.sqlViewName: 'SADL_SQL_SO_RTPD'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Reference Scenario: Derivation Test'
define view SADL_CDS_RS_SO_Root_Param_Drv
  with parameters
    p_bp_id     : sadl_rs_id,
    @Consumption.derivation: { lookupEntity: 'Sadl_Cds_Rs_Bp_Param_Drv',
      resultElement: 'type_code_transl', binding: [ {
        targetParameter: 'p_id', type: #PARAMETER, value : 'p_bp_id' } ]
    }
    @Consumption.hidden: true
    p_type_code : sadl_rs_tc
  as select from sadl_rs_so_root as root
  association [*]    to Sadl_Cds_Rs_So_Item as _items  on  $projection.id = _items.parent_id
  association [0..1] to Sadl_V_Aunit_Srs_Bp as _seller on  $projection.seller_id     = _seller.bp_id
                                                       and $projection.act_indicator = 'X'
{
  key id,
      act_indicator,
      buyer_id,
      seller_id,
      type_code,
      _items,
      _seller
}
where
  type_code = $parameters.p_type_code
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"SADL_RS_SO_ROOT"
],
"ASSOCIATED":
[
"SADL_CDS_RS_SO_ITEM",
"SADL_V_AUNIT_SRS_BP"
],
"BASE":
[],
"VERSION":0
}
}*/

Learn More