FAC_CDS_uhdt_hattrvals_SDM

DDL: FAC_CDS_UHDT_HATTRVALS_SDM SQL: UHHATRSMD Type: view

uhdt_hattrvals with SDM hryid field

FAC_CDS_uhdt_hattrvals_SDM is a CDS View that provides data about "uhdt_hattrvals with SDM hryid field" in SAP S/4HANA. It reads from 4 data sources (uhdt_hattrvals, uhdt_nattrvals, uhdt_hattrvals, uhdt_node) and exposes 3 fields with key field versionID.

4 data source(s) 3 fields

Data Sources (4)

SourceAliasJoin Type
uhdt_hattrvals contra_item left_outer
uhdt_nattrvals contra_value left_outer
uhdt_hattrvals fa_permit left_outer
uhdt_node node left_outer

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName UHHATRSMD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label uhdt_hattrvals with SDM hryid field view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY versionID vrsn ver_id
hryid vrsn hier_hid
attr_namethenXelseendasfa_permitted 
@AbapCatalog.sqlViewName: 'UHHATRSMD'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType: {
  dataClass: #MIXED,
  serviceQuality: #C,
  sizeCategory: #L
}
@EndUserText.label: 'uhdt_hattrvals with SDM hryid field'
define view FAC_CDS_uhdt_hattrvals_SDM as select distinct from uhdt_vrsn as vrsn
  left outer join uhdt_hattrvals as contra_item on vrsn.hier_catg = contra_item.hier_catg
                                                and vrsn.hier_hid = contra_item.hier_id
                                                and contra_item.attr_name = 'CONTRAITEMPERMIT'
                                                and contra_item.ver_id = ''
  
  left outer join uhdt_nattrvals as contra_value on vrsn.ver_id = contra_value.ver_id
                                                 and contra_value.attr_name = 'CONTRA_ITEM'
  
  left outer join uhdt_hattrvals as fa_permit on vrsn.hier_catg = fa_permit.hier_catg
                                              and vrsn.hier_hid = fa_permit.hier_id
                                              and fa_permit.attr_name = 'FUNAREAPERMIT'
                                              and fa_permit.ver_id = ''
  left outer join uhdt_node as node on vrsn.ver_id = node.ver_id
                                    and node.node_entity = 'FUNCTIONALAREA'
  
{
  key vrsn.ver_id as versionID,
  vrsn.hier_hid as hryid,
  case
    when ( contra_value.attr_lval is not initial and ( contra_item.attr_name is null or contra_item.attr_name = '' ) )
      or ( node.node_lval is not initial and ( fa_permit.attr_name is null or fa_permit.attr_name = '' ) )
      then '00'
    else
      '01'                                  
  end                                   as sdm_version,
  case when ( contra_value.attr_lval is not initial and ( contra_item.attr_name is null or contra_item.attr_name = '' ) )
    then 'X'
    else '' 
  end as contra_item_permitted,
  
  case when ( node.node_lval is not initial and ( fa_permit.attr_name is null or fa_permit.attr_name = '' ) )
    then 'X'
    else '' 
  end as fa_permitted
}
where vrsn.hier_catg = 'FSVN' and vrsn.ver_status <> 'T'
and vrsn.ver_status <> 'B' 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"UHDT_HATTRVALS",
"UHDT_NATTRVALS",
"UHDT_NODE",
"UHDT_VRSN"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More