I_MasterDataImportTP

DDL: I_MASTERDATAIMPORTTP SQL: IMDIMPORTTP Type: view TRANSACTIONAL Package: MDC_LOAD

Master Data Import

I_MasterDataImportTP is a Transactional CDS View that provides data about "Master Data Import" in SAP S/4HANA. It reads from 2 data sources (mdc_import, mdc_worklist) and exposes 26 fields with key field MasterDataImportUUID. It has 2 associations to related views. Part of development package MDC_LOAD.

Data Sources (2)

SourceAliasJoin Type
mdc_import mdc_import from
mdc_worklist mdc_worklist left_outer

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_MasterDataImportStatisticTP _Statistic _Statistic.MasterDataImportUUID = $projection.MasterDataImportUUID
[0..1] I_MDChgProcRAPBasedSwitch _CloudBasedSwitch _CloudBasedSwitch.MDChgProcessSrceObjectTypeCode = mdc_import.masterdataimportobjecttypecode

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName IMDIMPORTTP view
EndUserText.label Master Data Import view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
ObjectModel.compositionRoot true view
ObjectModel.writeActivePersistence MDC_IMPORT view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.sapObjectNodeType.name MasterDataImport view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY MasterDataImportUUID
MasterDataImportDescription mdc_import masterdataimportdescription
MasterDataImportStatus mdc_import masterdataimportstatus
MasterDataImportObjectTypeCode mdc_import masterdataimportobjecttypecode
MasterDataImportCreator mdc_import masterdataimportcreator
MDImportCreationDateTime mdc_import mdimportcreationdatetime
MasterDataImportWorklist mdc_import masterdataimportworklist
MasterDataImportSeparatorSign mdc_import masterdataimportseparatorsign
MasterDataImportEscapeSign mdc_import masterdataimportescapesign
MasterDataChangeProcess mdc_import masterdatachangeprocess
MDChgProcessGoal mdc_import mdchgprocessgoal
MDImprtIsSkipConflictRecdReqd mdc_import mdimprtisskipconflictrecdreqd
MasterDataImportSourceSystem mdc_worklist source_system
MasterDataImportSourceFilter mdc_worklist source_filter
MasterDataImportLastAction mdc_import masterdataimportlastaction
MasterDataImportActnStatus mdc_import masterdataimportactnstatus
SystemMessageIdentification mdc_import systemmessageidentification
SystemMessageType mdc_import systemmessagetype
SystemMessageNumber mdc_import systemmessagenumber
SystemMessageVariable1 mdc_import systemmessagevariable1
SystemMessageVariable2 mdc_import systemmessagevariable2
SystemMessageVariable3 mdc_import systemmessagevariable3
SystemMessageVariable4 mdc_import systemmessagevariable4
SystemMessageText mdc_import systemmessagetext
_Statistic _Statistic
_CloudBasedSwitch _CloudBasedSwitch
@AbapCatalog.sqlViewName: 'IMDIMPORTTP'

@EndUserText.label: 'Master Data Import'

@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK

@ObjectModel.compositionRoot: true
@ObjectModel.writeActivePersistence: 'MDC_IMPORT'
@ObjectModel.transactionalProcessingEnabled: true
@ObjectModel.createEnabled: true
@ObjectModel.updateEnabled: true
@ObjectModel.deleteEnabled: true
@ObjectModel.sapObjectNodeType.name: 'MasterDataImport'

@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L

@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API

///*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ]  } */

define view I_MasterDataImportTP
  as select from    mdc_import
    left outer join mdc_worklist as mdc_worklist on mdc_worklist.worklist_guid = mdc_import.masterdataimportworklist
  association [0..1] to I_MasterDataImportStatisticTP as _Statistic        on _Statistic.MasterDataImportUUID = $projection.MasterDataImportUUID
  association [0..1] to I_MDChgProcRAPBasedSwitch     as _CloudBasedSwitch on _CloudBasedSwitch.MDChgProcessSrceObjectTypeCode = mdc_import.masterdataimportobjecttypecode
{
      // key

      @Consumption.filter.hidden: true
      @ObjectModel.readOnly:true
      //  key masterdataimportuuid           as MasterDataImportUUID,

  key cast ( mdc_import.masterdataimportuuid as sysuuid_x ) as MasterDataImportUUID, //this cast is for downport compatibility

      // data

      @Consumption.filter.hidden: true
      mdc_import.masterdataimportdescription                as MasterDataImportDescription,
      @Consumption.filter.selectionType: #SINGLE
      @Consumption.filter.multipleSelections: true
      mdc_import.masterdataimportstatus                     as MasterDataImportStatus,
      @Consumption.filter.hidden: true
      mdc_import.masterdataimportobjecttypecode             as MasterDataImportObjectTypeCode,
      @Consumption.filter.selectionType: #SINGLE
      @Consumption.filter.multipleSelections: true
      mdc_import.masterdataimportcreator                    as MasterDataImportCreator,
      @Consumption.filter.selectionType: #RANGE
      mdc_import.mdimportcreationdatetime                   as MDImportCreationDateTime,
      @Consumption.filter.hidden: true
      mdc_import.masterdataimportworklist                   as MasterDataImportWorklist,
      @Consumption.filter.hidden: true
      @UI.selectionField.exclude: true
      mdc_import.masterdataimportseparatorsign              as MasterDataImportSeparatorSign,
      @Consumption.filter.hidden: true
      mdc_import.masterdataimportescapesign                 as MasterDataImportEscapeSign,
      @Consumption.filter.hidden: true
      mdc_import.masterdatachangeprocess                    as MasterDataChangeProcess,
      @Consumption.filter.hidden: true
      mdc_import.mdchgprocessgoal                           as MDChgProcessGoal,
      @Consumption.filter.hidden: true
      mdc_import.mdimprtisskipconflictrecdreqd              as MDImprtIsSkipConflictRecdReqd,
      mdc_worklist.source_system                            as MasterDataImportSourceSystem,
      @Consumption.filter.hidden: true
      mdc_worklist.source_filter                            as MasterDataImportSourceFilter,
      @Consumption.filter.hidden: true
      mdc_import.masterdataimportlastaction                 as MasterDataImportLastAction,
      @Consumption.filter.hidden: true
      mdc_import.masterdataimportactnstatus                 as MasterDataImportActnStatus,
      @Consumption.filter.hidden: true
      mdc_import.systemmessageidentification                as SystemMessageIdentification,
      @Consumption.filter.hidden: true
      mdc_import.systemmessagetype                          as SystemMessageType,
      @Consumption.filter.hidden: true
      mdc_import.systemmessagenumber                        as SystemMessageNumber,
      @Consumption.filter.hidden: true
      mdc_import.systemmessagevariable1                     as SystemMessageVariable1,
      @Consumption.filter.hidden: true
      mdc_import.systemmessagevariable2                     as SystemMessageVariable2,
      @Consumption.filter.hidden: true
      mdc_import.systemmessagevariable3                     as SystemMessageVariable3,
      @Consumption.filter.hidden: true
      mdc_import.systemmessagevariable4                     as SystemMessageVariable4,
      @Consumption.filter.hidden: true
      mdc_import.systemmessagetext                          as SystemMessageText,

      // associations

      @ObjectModel.association.type: #TO_COMPOSITION_CHILD
      _Statistic,
      _CloudBasedSwitch
}
where
  _CloudBasedSwitch.MDChgProcRAPBsdSwitchIsActive = ' '