I_DFS_DcncdConncnStatusType

DDL: I_DFS_DCNCDCONNCNSTATUSTYPE Type: view_entity COMPOSITE

Admin App Connection status type

I_DFS_DcncdConncnStatusType is a Composite CDS View that provides data about "Admin App Connection status type" in SAP S/4HANA. It reads from 1 data source (dd07l) and exposes 2 fields with key field DfsDcncdOpsSystAvailyStsCode. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
dd07l dd07l from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_DFS_DcncdOpsConncnStatusText _DfsConncnStatusTypeText $projection.DfsDcncdOpsSystAvailyStsCode = _DfsConncnStatusTypeText.DfsDcncdOpsSystAvailyStsCode

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Admin App Connection status type view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey DfsDcncdOpsSystAvailyStsCode view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.resultSet.sizeCategory #XS view
VDM.viewType #COMPOSITE view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY DfsDcncdOpsSystAvailyStsCode
_DfsConncnStatusTypeText _DfsConncnStatusTypeText
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Admin App Connection status type'
@Metadata.ignorePropagatedAnnotations: true

@ObjectModel: { representativeKey: 'DfsDcncdOpsSystAvailyStsCode',
                usageType: {serviceQuality: #A,
                            sizeCategory: #M,
                            dataClass: #CUSTOMIZING},
                resultSet.sizeCategory: #XS }
@VDM.viewType: #COMPOSITE
define view entity I_DFS_DcncdConncnStatusType 
  as select from dd07l
    association [0..*] to I_DFS_DcncdOpsConncnStatusText as _DfsConncnStatusTypeText 
      on $projection.DfsDcncdOpsSystAvailyStsCode = _DfsConncnStatusTypeText.DfsDcncdOpsSystAvailyStsCode {
        key cast(dd07l.domvalue_l as dfs_dis_conncn_sts ) as DfsDcncdOpsSystAvailyStsCode,
            _DfsConncnStatusTypeText 
}
where
      dd07l.domname  = 'DFS_DIS_CONNCN_STS'
  and dd07l.as4local = 'A'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD07L"
],
"ASSOCIATED":
[
"I_DFS_DCNCDOPSCONNCNSTATUSTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/