I_MAIFDYNFORMAGENTDEFINITION

CDS View

MAIF Dynamic Form Agent Definition

I_MAIFDYNFORMAGENTDEFINITION is a CDS View in S/4HANA. MAIF Dynamic Form Agent Definition. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_MAIFDynFmAgentLastChangeInfo view_entity union COMPOSITE
R_MAIFDynFormAgentDefinitionTP view_entity from TRANSACTIONAL MAIF Dynamic Form Agent Definition - TP 
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY

@EndUserText.label: 'MAIF Dynamic Form Agent Definition'

@Metadata.ignorePropagatedAnnotations: true

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

@VDM.viewType: #COMPOSITE

define view entity I_MAIFDynFormAgentDefinition
  as select from           I_MAIFDynFmAgtDefinitionBasic

    left outer to one join I_MAIFDynFmAgtDefinitionShadow on  I_MAIFDynFmAgtDefinitionShadow.MAIFDynamicFormAgent           = I_MAIFDynFmAgtDefinitionBasic.MAIFDynamicFormAgent
                                                          and I_MAIFDynFmAgtDefinitionShadow.MAIFDynFormAgentDefinitionUUID = I_MAIFDynFmAgtDefinitionBasic.MAIFDynFormAgentDefinitionUUID

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

      I_MAIFDynFmAgtDefinitionBasic.MAIFDynFmAgtDefinitionIsActive,
      I_MAIFDynFmAgtDefinitionBasic.MAIFDynamicFormObjectGroup,
      I_MAIFDynFmAgtDefinitionBasic.MAIFDynamicFormObjectGroup1,
      I_MAIFDynFmAgtDefinitionBasic.MAIFDynamicFormApplication,
      I_MAIFDynFmAgtDefinitionBasic.MAIFDynamicFormName,
      I_MAIFDynFmAgtDefinitionBasic.MAIFDynamicFormVersion,
      I_MAIFDynFmAgtDefinitionBasic.MAIFDynFormInstanceIsRequired,
      I_MAIFDynFmAgtDefinitionBasic.MAIFDynamicFormGenerationMode,
      I_MAIFDynFmAgtDefinitionBasic.MAIFDynFmAgtDefAssignmentRule,
      I_MAIFDynFmAgtDefinitionBasic.MAIFDynFmAgtDefAssignmentType,
      I_MAIFDynFmAgtDefinitionBasic.MAIFDynFmAgtDefNewVersIsUsed,
      I_MAIFDynFmAgtDefinitionBasic.MAIFDynFormTechnicalEntityType,
      I_MAIFDynFmAgtDefinitionBasic.MAIFDynamicFormDependentAgent,
      I_MAIFDynFmAgtDefinitionBasic.MAIFDynFmDpndcyKeySetupRule,
      I_MAIFDynFmAgtDefinitionBasic.MAIFDynFmAgtDefIsOnlyForHeader,
      I_MAIFDynFmAgtDefinitionBasic.LastChangedByUser,
      I_MAIFDynFmAgtDefinitionBasic.CreatedByUser,
      I_MAIFDynFmAgtDefinitionBasic.CreationDateTime,
      _LastChangeInfo.LastChangeDateTime
}
where
  I_MAIFDynFmAgtDefinitionShadow.MAIFDynamicFormAgent is null

union all

select from I_MAIFDynFmAgtDefinitionShadow

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

      MAIFDynFmAgtDefinitionIsActive,
      MAIFDynamicFormObjectGroup,
      MAIFDynamicFormObjectGroup1,
      MAIFDynamicFormApplication,
      MAIFDynamicFormName,
      MAIFDynamicFormVersion,
      MAIFDynFormInstanceIsRequired,
      MAIFDynamicFormGenerationMode,
      MAIFDynFmAgtDefAssignmentRule,
      MAIFDynFmAgtDefAssignmentType,
      MAIFDynFmAgtDefNewVersIsUsed,
      MAIFDynFormTechnicalEntityType,
      MAIFDynamicFormDependentAgent,
      MAIFDynFmDpndcyKeySetupRule,
      MAIFDynFmAgtDefIsOnlyForHeader,
      LastChangedByUser,
      CreatedByUser,
      CreationDateTime,
      _LastChangeInfo.LastChangeDateTime
}
where
  MAIFCustomizingDataIsDeleted = ''

Learn More