P_ACMLoadDataCptrDomainTxt

DDL: P_ACMLOADDATACPTRDOMAINTXT Type: view_entity COMPOSITE

Load Data Capture Domain text

P_ACMLoadDataCptrDomainTxt is a Composite CDS View that provides data about "Load Data Capture Domain text" in SAP S/4HANA. It reads from 2 data sources (dd07l, dd07t) and exposes 3 fields with key fields SAPDataDictionaryDomain, DomainValue.

2 data source(s) 3 fields

Data Sources (2)

SourceAliasJoin Type
dd07l dd07l from
dd07t dd07t inner

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Load Data Capture Domain text view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY SAPDataDictionaryDomain dd07l domname
KEY DomainValue dd07l domvalue_l
DomainText dd07t ddtext 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Load Data Capture Domain text'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
@VDM.private: true
@VDM.viewType: #COMPOSITE
define view entity P_ACMLoadDataCptrDomainTxt 
as select from dd07l
    inner join   dd07t on  dd07l.domname    = dd07t.domname
                       and dd07l.as4local   = dd07t.as4local
                       and dd07l.valpos     = dd07t.valpos
                       and dd07l.domvalue_l = dd07t.domvalue_l

{
  key dd07l.domname    as SAPDataDictionaryDomain,
  key dd07l.domvalue_l as DomainValue,
      dd07t.ddtext     as DomainText
}
where
      dd07t.ddlanguage = $session.system_language
  and dd07l.as4local   = 'A'
  and dd07l.domname    = '/ACCGO/D_UIS_TYPE'
  


/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD07L",
"DD07T"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More