I_MAIFDynamicFormAgentText

DDL: I_MAIFDYNAMICFORMAGENTTEXT Type: view_entity COMPOSITE Package: VDM_MAO_MAIF_CONFIG_DAGENT

MAIF Dynamic Form Agent - Text

I_MAIFDynamicFormAgentText is a Composite CDS View that provides data about "MAIF Dynamic Form Agent - Text" in SAP S/4HANA. It reads from 2 data sources (I_MAIFDynFormAgentBasicText, I_MAIFDynFormAgentShadowText) and exposes 11 fields with key fields MAIFDynamicFormAgent, Language, Language. It has 2 associations to related views. Part of development package VDM_MAO_MAIF_CONFIG_DAGENT.

2 data source(s) 11 fields

Data Sources (2)

SourceAliasJoin Type
I_MAIFDynFormAgentBasicText I_MAIFDynFormAgentBasicText from
I_MAIFDynFormAgentShadowText I_MAIFDynFormAgentShadowText union_all

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_Language _Language _Language.Language = $projection.Language
[1..1] I_MAIFCstmzgDataLastChangeInfo _LastChangeInfo _LastChangeInfo.DatabaseTable = '/SMFND/C_DFA01T' and _LastChangeInfo.TableChangeLogKey = I_MAIFDynFormAgentBasicText.TableChangeLogKey

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label MAIF Dynamic Form Agent - Text view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey MAIFDynamicFormAgent view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #COMPOSITE view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY MAIFDynamicFormAgent I_MAIFDynFormAgentBasicText MAIFDynamicFormAgent
KEY Language I_MAIFDynFormAgentBasicText Language
MAIFDynamicFormAgentName I_MAIFDynFormAgentBasicText MAIFDynamicFormAgentName
TableChangeLogKey I_MAIFDynFormAgentBasicText TableChangeLogKey
LastChangeDateTime _LastChangeInfo LastChangeDateTime
TableChangeLogKeykeyMAIFDynamicFormAgent
KEY Language Language
MAIFDynamicFormAgentName MAIFDynamicFormAgentName
TableChangeLogKey TableChangeLogKey
LastChangeDateTime _LastChangeInfo LastChangeDateTime
_Language _Language 
@AccessControl.authorizationCheck: #NOT_REQUIRED

@EndUserText.label: 'MAIF Dynamic Form Agent - Text'

@Metadata.ignorePropagatedAnnotations: true

@ObjectModel: {
  dataCategory: #TEXT,
  representativeKey: 'MAIFDynamicFormAgent',
  usageType: {
    dataClass: #MIXED,
    serviceQuality: #C,
    sizeCategory: #M
  }
}

@VDM.viewType: #COMPOSITE

define view entity I_MAIFDynamicFormAgentText
  as select from           I_MAIFDynFormAgentBasicText

    left outer to one join I_MAIFDynFormAgentShadowText on  I_MAIFDynFormAgentShadowText.MAIFDynamicFormAgent = I_MAIFDynFormAgentBasicText.MAIFDynamicFormAgent
                                                        and I_MAIFDynFormAgentShadowText.Language             = I_MAIFDynFormAgentBasicText.Language

  association [0..1] to I_Language                     as _Language       on  _Language.Language = $projection.Language

  association [1..1] to I_MAIFCstmzgDataLastChangeInfo as _LastChangeInfo on  _LastChangeInfo.DatabaseTable     = '/SMFND/C_DFA01T' 
                                                                          and _LastChangeInfo.TableChangeLogKey = I_MAIFDynFormAgentBasicText.TableChangeLogKey
{

      @ObjectModel.text.element: ['MAIFDynamicFormAgentName']
  key I_MAIFDynFormAgentBasicText.MAIFDynamicFormAgent,
      @ObjectModel.foreignKey.association: '_Language'
      @Semantics.language: true
  key I_MAIFDynFormAgentBasicText.Language,

      @EndUserText: {
        label: 'Description',
        quickInfo: 'Description'
      }
      @Semantics.text: true
      I_MAIFDynFormAgentBasicText.MAIFDynamicFormAgentName,
      I_MAIFDynFormAgentBasicText.TableChangeLogKey,
      _LastChangeInfo.LastChangeDateTime,
      _Language
}
where
  I_MAIFDynFormAgentShadowText.MAIFDynamicFormAgent is null

union all

select from I_MAIFDynFormAgentShadowText

association [0..1] to I_Language                     as _Language       on  _Language.Language = $projection.Language

association [1..1] to I_MAIFCstmzgDataLastChangeInfo as _LastChangeInfo on  _LastChangeInfo.DatabaseTable     = '/SMFND/YC_DFA01T'
                                                                        and _LastChangeInfo.TableChangeLogKey = I_MAIFDynFormAgentShadowText.TableChangeLogKey
{
  key MAIFDynamicFormAgent,
  key Language,

      MAIFDynamicFormAgentName,
      TableChangeLogKey,
      _LastChangeInfo.LastChangeDateTime,
      _Language
}
where
  MAIFCustomizingDataIsDeleted = ''

Learn More