DDCDS_CUSTOMER_DOMAIN_VALUE

DDL: DDCDS_CUSTOMER_DOMAIN_VALUE SQL: DDCDS_CUSTDV Type: view_entity

DDCDS_CUSTOMER_DOMAIN_VALUE is a CDS View in SAP S/4HANA. It reads from 2 data sources (ARS_OBJECTS_ALL_SW_COMP_SCP, dd07l) and exposes 3 fields with key field domain_name.

2 data source(s) 3 fields

Data Sources (2)

SourceAliasJoin Type
ARS_OBJECTS_ALL_SW_COMP_SCP ARS_OBJECTS_ALL_SW_COMP_SCP inner
dd07l dd07l from

Parameters (1)

NameTypeDefault
p_domain_name sxco_ad_object_name

Annotations (1)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY domain_name dd07l domname
value_low dd07l domvalue_l
value_high dd07l domvalue_h 
//@AbapCatalog.sqlViewName: 'DDCDS_CUSTDV'

@AccessControl.authorizationCheck: #NOT_REQUIRED
define view entity DDCDS_CUSTOMER_DOMAIN_VALUE
  with parameters
    p_domain_name : sxco_ad_object_name --abap.char(30)
  as select from dd07l
    inner join   ARS_OBJECTS_ALL_SW_COMP_SCP on  ARS_OBJECTS_ALL_SW_COMP_SCP.program_id  = 'R3TR'
                                             and ARS_OBJECTS_ALL_SW_COMP_SCP.object_type = 'DOMA'
                                             and ARS_OBJECTS_ALL_SW_COMP_SCP.object_name = dd07l.domname
                                             and ARS_OBJECTS_ALL_SW_COMP_SCP.object_name = $parameters.p_domain_name

{
  key dd07l.domname    as domain_name,
  key dd07l.valpos     as value_position,
      dd07l.domvalue_l as value_low,
      dd07l.domvalue_h as value_high
}
where
  dd07l.as4local = 'A'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ARS_OBJECTS_ALL_SW_COMP_SCP",
"DD07L"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More