I_MAIFDynamicFormAgent

DDL: I_MAIFDYNAMICFORMAGENT Type: view_entity COMPOSITE

MAIF Dynamic Form Agent

I_MAIFDynamicFormAgent is a Composite CDS View that provides data about "MAIF Dynamic Form Agent" in SAP S/4HANA. It reads from 2 data sources (I_MAIFDynamicFormAgentBasic, I_MAIFDynamicFormAgentShadow) and exposes 35 fields with key field MAIFDynamicFormAgent. It has 1 association to related views.

2 data source(s) 35 fields

Data Sources (2)

SourceAliasJoin Type
I_MAIFDynamicFormAgentBasic I_MAIFDynamicFormAgentBasic from
I_MAIFDynamicFormAgentShadow I_MAIFDynamicFormAgentShadow union_all

Associations (1)

CardinalityTargetAliasCondition
[1..1] P_MAIFCstmzgDataLastChangeInfo _LastChangeInfo _LastChangeInfo.DatabaseTable = '/SMFND/C_DFA01' and _LastChangeInfo.TableChangeLogKey = I_MAIFDynamicFormAgentBasic.TableChangeLogKey

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label MAIF Dynamic Form Agent view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #COMPOSITE view

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY MAIFDynamicFormAgent I_MAIFDynamicFormAgentBasic MAIFDynamicFormAgent
MobileUserApplication I_MAIFDynamicFormAgentBasic MobileUserApplication
MAIFDynamicFormAgentHandler I_MAIFDynamicFormAgentBasic MAIFDynamicFormAgentHandler
MAIFDynamicFormAgentIsActive I_MAIFDynamicFormAgentBasic MAIFDynamicFormAgentIsActive
MaintMblApplSystemComponent I_MAIFDynamicFormAgentBasic MaintMblApplSystemComponent
MAIFDynamicFormObjectType I_MAIFDynamicFormAgentBasic MAIFDynamicFormObjectType
MAIFDynFmObjGrpTechEntityType I_MAIFDynamicFormAgentBasic MAIFDynFmObjGrpTechEntityType
MAIFDynFmObjectGroupFieldName I_MAIFDynamicFormAgentBasic MAIFDynFmObjectGroupFieldName
MAIFDynFmObjGrp1TechEntityType I_MAIFDynamicFormAgentBasic MAIFDynFmObjGrp1TechEntityType
MAIFDynFmObjectGroup1FieldName I_MAIFDynamicFormAgentBasic MAIFDynFmObjectGroup1FieldName
MAIFDynFmObjectGroupIsOptional I_MAIFDynamicFormAgentBasic MAIFDynFmObjectGroupIsOptional
MAIFDynFmMergingInProcgIsDsbld I_MAIFDynamicFormAgentBasic MAIFDynFmMergingInProcgIsDsbld
MAIFDynFormTemplateCacheIsUsed I_MAIFDynamicFormAgentBasic MAIFDynFormTemplateCacheIsUsed
MAIFDynFmExchTableIsTriggered I_MAIFDynamicFormAgentBasic MAIFDynFmExchTableIsTriggered
LastChangedByUser I_MAIFDynamicFormAgentBasic LastChangedByUser
CreatedByUser I_MAIFDynamicFormAgentBasic CreatedByUser
CreationDateTime I_MAIFDynamicFormAgentBasic CreationDateTime
TableChangeLogKeykeyMAIFDynamicFormAgent
MobileUserApplication MobileUserApplication
MAIFDynamicFormAgentHandler MAIFDynamicFormAgentHandler
MAIFDynamicFormAgentIsActive MAIFDynamicFormAgentIsActive
MaintMblApplSystemComponent MaintMblApplSystemComponent
MAIFDynamicFormObjectType MAIFDynamicFormObjectType
MAIFDynFmObjGrpTechEntityType MAIFDynFmObjGrpTechEntityType
MAIFDynFmObjectGroupFieldName MAIFDynFmObjectGroupFieldName
MAIFDynFmObjGrp1TechEntityType MAIFDynFmObjGrp1TechEntityType
MAIFDynFmObjectGroup1FieldName MAIFDynFmObjectGroup1FieldName
MAIFDynFmObjectGroupIsOptional MAIFDynFmObjectGroupIsOptional
MAIFDynFmMergingInProcgIsDsbld MAIFDynFmMergingInProcgIsDsbld
MAIFDynFormTemplateCacheIsUsed MAIFDynFormTemplateCacheIsUsed
MAIFDynFmExchTableIsTriggered MAIFDynFmExchTableIsTriggered
LastChangedByUser LastChangedByUser
CreatedByUser CreatedByUser
CreationDateTime CreationDateTime
LastChangeDateTime _LastChangeInfo LastChangeDateTime 
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY

@EndUserText.label: 'MAIF Dynamic Form Agent'

@Metadata.ignorePropagatedAnnotations: true

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

@VDM.viewType: #COMPOSITE

define view entity I_MAIFDynamicFormAgent
  as select from           I_MAIFDynamicFormAgentBasic

    left outer to one join I_MAIFDynamicFormAgentShadow on I_MAIFDynamicFormAgentShadow.MAIFDynamicFormAgent = I_MAIFDynamicFormAgentBasic.MAIFDynamicFormAgent

  association [1..1] to P_MAIFCstmzgDataLastChangeInfo as _LastChangeInfo on  _LastChangeInfo.DatabaseTable     = '/SMFND/C_DFA01'
                                                                          and _LastChangeInfo.TableChangeLogKey = I_MAIFDynamicFormAgentBasic.TableChangeLogKey
{
  key I_MAIFDynamicFormAgentBasic.MAIFDynamicFormAgent,

      I_MAIFDynamicFormAgentBasic.MobileUserApplication,
      I_MAIFDynamicFormAgentBasic.MAIFDynamicFormAgentHandler,
      I_MAIFDynamicFormAgentBasic.MAIFDynamicFormAgentIsActive,
      I_MAIFDynamicFormAgentBasic.MaintMblApplSystemComponent,
      I_MAIFDynamicFormAgentBasic.MAIFDynamicFormObjectType,
      I_MAIFDynamicFormAgentBasic.MAIFDynFmObjGrpTechEntityType,
      I_MAIFDynamicFormAgentBasic.MAIFDynFmObjectGroupFieldName,
      I_MAIFDynamicFormAgentBasic.MAIFDynFmObjGrp1TechEntityType,
      I_MAIFDynamicFormAgentBasic.MAIFDynFmObjectGroup1FieldName,
      I_MAIFDynamicFormAgentBasic.MAIFDynFmObjectGroupIsOptional,
      I_MAIFDynamicFormAgentBasic.MAIFDynFmMergingInProcgIsDsbld,
      I_MAIFDynamicFormAgentBasic.MAIFDynFormTemplateCacheIsUsed,
      I_MAIFDynamicFormAgentBasic.MAIFDynFmExchTableIsTriggered,
      I_MAIFDynamicFormAgentBasic.LastChangedByUser,
      I_MAIFDynamicFormAgentBasic.CreatedByUser,
      I_MAIFDynamicFormAgentBasic.CreationDateTime,
      _LastChangeInfo.LastChangeDateTime
}
where
  I_MAIFDynamicFormAgentShadow.MAIFDynamicFormAgent is null

union all

select from I_MAIFDynamicFormAgentShadow

association [1..1] to P_MAIFCstmzgDataLastChangeInfo as _LastChangeInfo on  _LastChangeInfo.DatabaseTable     = '/SMFND/YC_DFA01'
                                                                        and _LastChangeInfo.TableChangeLogKey = I_MAIFDynamicFormAgentShadow.TableChangeLogKey
{
  key MAIFDynamicFormAgent,

      MobileUserApplication,
      MAIFDynamicFormAgentHandler,
      MAIFDynamicFormAgentIsActive,
      MaintMblApplSystemComponent,
      MAIFDynamicFormObjectType,
      MAIFDynFmObjGrpTechEntityType,
      MAIFDynFmObjectGroupFieldName,
      MAIFDynFmObjGrp1TechEntityType,
      MAIFDynFmObjectGroup1FieldName,
      MAIFDynFmObjectGroupIsOptional,
      MAIFDynFmMergingInProcgIsDsbld,
      MAIFDynFormTemplateCacheIsUsed,
      MAIFDynFmExchTableIsTriggered,
      LastChangedByUser,
      CreatedByUser,
      CreationDateTime,
      _LastChangeInfo.LastChangeDateTime
}
where
  MAIFCustomizingDataIsDeleted = ''

Learn More