SADL_CDS_RS_SO_Root_Par_El_Drv

DDL: SADL_CDS_RS_SO_ROOT_PAR_EL_DRV SQL: SADL_SQL_SO_REPD Type: view

Reference Scenario: Derivation Test

SADL_CDS_RS_SO_Root_Par_El_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 5 fields.

1 data source(s) 5 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

Annotations (4)

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

Fields (5)

KeyFieldSource TableSource FieldDescription
lookupEntitySadl_Cds_Rs_Bp_Elem_Drv
resultElementtype_code_transl
buyer_id buyer_id
seller_id seller_id
type_code type_code 
@AbapCatalog.sqlViewName: 'SADL_SQL_SO_REPD'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Reference Scenario: Derivation Test'
define view SADL_CDS_RS_SO_Root_Par_El_Drv
  with parameters
    p_bp_id     : sadl_rs_id,
    @Consumption.derivation: { lookupEntity: 'Sadl_Cds_Rs_Bp_Elem_Drv',
      resultElement: 'type_code_transl', binding: [ {
        targetElement: '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
{
  key id,
      act_indicator,
      buyer_id,
      seller_id,
      type_code
}
where
  type_code = $parameters.p_type_code
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"SADL_RS_SO_ROOT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More