Aps_V_Gke_View_Dd07t

DDL: APS_V_GKE_VIEW_DD07T SQL: APS_V_CKE_VSOT Type: view BASIC

Source Origin Text

Aps_V_Gke_View_Dd07t is a Basic CDS View that provides data about "Source Origin Text" in SAP S/4HANA. It reads from 1 data source (dd07t) and exposes 5 fields with key fields SourceOrigin, Language.

Data Sources (1)

SourceAliasJoin Type
dd07t dd07t from

Annotations (11)

NameValueLevelField
Analytics.dataExtraction.enabled true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey SourceOrigin view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
EndUserText.label Source Origin Text view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName APS_V_CKE_VSOT view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY SourceOrigin
KEY Language ddlanguage
SourceOriginName ddtext
_DD07L _DD07L
_Language _Language
@Analytics.dataExtraction.enabled: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.dataCategory: #TEXT
@ObjectModel.representativeKey: 'SourceOrigin'
@ObjectModel.usageType.dataClass: #META
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #S
@EndUserText.label: 'Source Origin Text'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck:#NOT_REQUIRED
@AbapCatalog.sqlViewName: 'APS_V_CKE_VSOT'
define view Aps_V_Gke_View_Dd07t as select from dd07t
association[0..1] to Aps_V_Gke_View_Dd07l as _DD07L on $projection.SourceOrigin = _DD07L.SourceOrigin
association[0..1] to I_Language as _Language on $projection.Language = _Language.Language
{
    @ObjectModel.foreignKey.association: '_DD07L'
    key substring(domvalue_l,1,3) as SourceOrigin,
    @Semantics.language: true
    @ObjectModel.foreignKey.association: '_Language'
    key ddlanguage as Language,  
    @Semantics.text: true
    ddtext as SourceOriginName,
    
    //Associations

    _DD07L,
    _Language
}
where dd07t.domname = 'DDDDLSRCORIGIN' and dd07t.as4local = 'A' and dd07t.ddlanguage = $session.system_language;   
 
  
  
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD07T"
],
"ASSOCIATED":
[
"APS_V_GKE_VIEW_DD07L",
"I_LANGUAGE"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/