FAC_CDS_UH_MAINTENANCE_LANG

DDL: FAC_CDS_UH_MAINTENANCE_LANG SQL: FACV_UH_LANG Type: view

Universal Hierarchy Maintenance Language

FAC_CDS_UH_MAINTENANCE_LANG is a CDS View that provides data about "Universal Hierarchy Maintenance Language" in SAP S/4HANA. It reads from 3 data sources (FAC_CDS_UH_VER_LANG, t002, t002t) and exposes 3 fields with key fields ver_id, spras.

3 data source(s) 3 fields

Data Sources (3)

SourceAliasJoin Type
FAC_CDS_UH_VER_LANG FAC_CDS_UH_VER_LANG left_outer
t002 lang_list right_outer
t002t t002t left_outer

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName FACV_UH_LANG view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Universal Hierarchy Maintenance Language view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY ver_id uhdt_vrsn ver_id
KEY spras t002 spras
sptxt t002t sptxt 
@AbapCatalog.sqlViewName: 'FACV_UH_LANG'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Universal Hierarchy Maintenance Language'
//@ClientHandling.algorithm: #SESSION_VARIABLE


@ObjectModel.usageType: {
  dataClass: #MASTER,
  serviceQuality: #C,
  sizeCategory: #M
}

define view FAC_CDS_UH_MAINTENANCE_LANG as 
select distinct from uhdt_vrsn
right outer join t002 as lang_list on lang_list.spras <> ''
//inner join t002c on lang_list.spras = t002c.spras and t002c.lainst = 'X'

left outer join t002t on lang_list.spras = t002t.sprsl and t002t.spras = $session.system_language
left outer join FAC_CDS_UH_VER_LANG on uhdt_vrsn.ver_id = FAC_CDS_UH_VER_LANG.ver_id and lang_list.spras = FAC_CDS_UH_VER_LANG.lang
{
  key uhdt_vrsn.ver_id,
  key lang_list.spras,
  t002t.sptxt,
  case when FAC_CDS_UH_VER_LANG.lang is null or FAC_CDS_UH_VER_LANG.lang = ''
       then cast ( ''   as htxtmaint )
       else 
  cast ( 'X'   as htxtmaint ) end   as  HierarchyNodeTextMaintained
}

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FAC_CDS_UH_VER_LANG",
"T000",
"T002",
"T002T",
"UHDT_VRSN"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More