I_MAIFDYNFMAGTDEFCONDITION

CDS View

MAIF Form Agent Definition Condition

I_MAIFDYNFMAGTDEFCONDITION is a CDS View in S/4HANA. MAIF Form Agent Definition Condition. 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 MAIF Dynamic Form Agent Last Change Info
R_MAIFDynFmAgtDefConditionTP view_entity from TRANSACTIONAL MAIF Form Definition Condition - TP 
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY

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

@Metadata.ignorePropagatedAnnotations: true

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

@VDM.viewType: #COMPOSITE

define view entity I_MAIFDynFmAgtDefCondition
  as select from           I_MAIFDynFmAgtDefCndnBasic

    left outer to one join I_MAIFDynFmAgtDefCndnShadow on  I_MAIFDynFmAgtDefCndnShadow.MAIFDynamicFormAgent           = I_MAIFDynFmAgtDefCndnBasic.MAIFDynamicFormAgent
                                                       and I_MAIFDynFmAgtDefCndnShadow.MAIFDynFormAgentDefinitionUUID = I_MAIFDynFmAgtDefCndnBasic.MAIFDynFormAgentDefinitionUUID
                                                       and I_MAIFDynFmAgtDefCndnShadow.MAIFDynFmAgtDefConditionNumber = I_MAIFDynFmAgtDefCndnBasic.MAIFDynFmAgtDefConditionNumber

  association [1..1] to I_MAIFCstmzgDataLastChangeInfo as _LastChangeInfo on  _LastChangeInfo.DatabaseTable     = '/SMFND/C_DFA01B'
                                                                          and _LastChangeInfo.TableChangeLogKey = I_MAIFDynFmAgtDefCndnBasic.TableChangeLogKey
{
  key I_MAIFDynFmAgtDefCndnBasic.MAIFDynamicFormAgent,
  key I_MAIFDynFmAgtDefCndnBasic.MAIFDynFormAgentDefinitionUUID,
  key I_MAIFDynFmAgtDefCndnBasic.MAIFDynFmAgtDefConditionNumber,

      I_MAIFDynFmAgtDefCndnBasic.MAIFDynFmAgtDefCndnCategory,
      I_MAIFDynFmAgtDefCndnBasic.MAIFDynFormTechnicalEntityType,
      I_MAIFDynFmAgtDefCndnBasic.MAIFDynFmTechEntyTypeFieldName,
      I_MAIFDynFmAgtDefCndnBasic.MAIFDynamicFormAttributeName,
      I_MAIFDynFmAgtDefCndnBasic.MAIFDynFmAgtDefMappingType,
      I_MAIFDynFmAgtDefCndnBasic.MAIFDynamicFormAttributeValue,
      I_MAIFDynFmAgtDefCndnBasic.MAIFDynFmAgtDefCndnRangeFrom,
      I_MAIFDynFmAgtDefCndnBasic.MAIFDynFmAgtDefCndnRangeTo,
      I_MAIFDynFmAgtDefCndnBasic.MAIFDynFmAgtDefCndnRangeSign,
      I_MAIFDynFmAgtDefCndnBasic.MAIFDynFmAgtDefCndnRangeOption,
      I_MAIFDynFmAgtDefCndnBasic.MAIFDynFmAgtDefCndnIsActive,
      I_MAIFDynFmAgtDefCndnBasic.LastChangedByUser,
      I_MAIFDynFmAgtDefCndnBasic.CreatedByUser,
      I_MAIFDynFmAgtDefCndnBasic.CreationDateTime,
      _LastChangeInfo.LastChangeDateTime
}
where
  I_MAIFDynFmAgtDefCndnShadow.MAIFDynamicFormAgent is null

union all

select from I_MAIFDynFmAgtDefCndnShadow

association [1..1] to I_MAIFCstmzgDataLastChangeInfo as _LastChangeInfo on  _LastChangeInfo.DatabaseTable     = '/SMFND/YC_DFA01B'
                                                                        and _LastChangeInfo.TableChangeLogKey = I_MAIFDynFmAgtDefCndnShadow.TableChangeLogKey
{
  key MAIFDynamicFormAgent,
  key MAIFDynFormAgentDefinitionUUID,
  key MAIFDynFmAgtDefConditionNumber,

      MAIFDynFmAgtDefCndnCategory,
      MAIFDynFormTechnicalEntityType,
      MAIFDynFmTechEntyTypeFieldName,
      MAIFDynamicFormAttributeName,
      MAIFDynFmAgtDefMappingType,
      MAIFDynamicFormAttributeValue,
      MAIFDynFmAgtDefCndnRangeFrom,
      MAIFDynFmAgtDefCndnRangeTo,
      MAIFDynFmAgtDefCndnRangeSign,
      MAIFDynFmAgtDefCndnRangeOption,
      MAIFDynFmAgtDefCndnIsActive,
      LastChangedByUser,
      CreatedByUser,
      CreationDateTime,
      _LastChangeInfo.LastChangeDateTime
}
where
  MAIFCustomizingDataIsDeleted = ''

Learn More