I_MasterDataImportTP_2

DDL: I_MASTERDATAIMPORTTP_2 Type: view_entity TRANSACTIONAL

Master Data Import

I_MasterDataImportTP_2 is a Transactional CDS View that provides data about "Master Data Import" in SAP S/4HANA. It reads from 1 data source (I_MasterDataImport_2) and exposes 24 fields with key field MasterDataImportUUID. It has 6 associations to related views.

1 data source(s) 24 fields

Data Sources (1)

SourceAliasJoin Type
I_MasterDataImport_2 I_MasterDataImport_2 from

Associations (6)

CardinalityTargetAliasCondition
[0..1] I_MasterDataImportFileTP _ImportFile $projection.MasterDataImportUUID = _ImportFile.MasterDataImportUUID
[0..1] I_MasterDataImportUserVH _ImportUserVH $projection.MasterDataImportCreator = _ImportUserVH.MasterDataImportCreator
[0..1] I_MDImportStatus_2 _ImportStatusVH $projection.MasterDataImportStatus = _ImportStatusVH.MasterDataImportStatus
[0..1] I_MDImportSourceSystemVH _ImportSystemVH $projection.MasterDataImportSourceSystem = _ImportSystemVH.MasterDataImportSourceSystem
[0..1] I_UserContactCard _RequestorContactCard $projection.MasterDataImportCreator = _RequestorContactCard.ContactCardID
[0..*] I_MasterDataImportFileTP _File

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Master Data Import view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY MasterDataImportUUID MasterDataImportUUID
MasterDataImportStatus MasterDataImportStatus
MDImportStatusCriticality _ImportStatusVH MDImportStatusCriticality
MasterDataImportSourceSystem MasterDataImportSourceSystem
MasterDataImportSourceFilter MasterDataImportSourceFilter
MasterDataImportObjectTypeCode MasterDataImportObjectTypeCode
MDChgProcessGoal MDChgProcessGoal
MDImprtIsSkipConflictRecdReqd MDImprtIsSkipConflictRecdReqd
MasterDataImportCreator MasterDataImportCreator
MDImportCreationDateTime MDImportCreationDateTime
MDImportCreationDate
MDImprtNmbrOfRecordsImported MDImprtNmbrOfRecordsImported
MDImportFileTemplateName
MDImportFileTemplateMimeType
MDImportFileTemplateBinary MDImportFileTemplateBinary
MDImportFileIsUploaded
MDImportSourceSystemIsOmitted
MasterDataChangeProcess MasterDataChangeProcess
_File _File
_ImportFile _ImportFile
_ImportUserVH _ImportUserVH
_ImportStatusVH _ImportStatusVH
_ImportSystemVH _ImportSystemVH
_RequestorContactCard _RequestorContactCard 
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@EndUserText.label: 'Master Data Import'
define root view entity I_MasterDataImportTP_2
  as select from I_MasterDataImport_2

  composition [0..*] of I_MasterDataImportFileTP as _File
  association [0..1] to I_MasterDataImportFileTP as _ImportFile           on $projection.MasterDataImportUUID = _ImportFile.MasterDataImportUUID
  association [0..1] to I_MasterDataImportUserVH as _ImportUserVH         on $projection.MasterDataImportCreator = _ImportUserVH.MasterDataImportCreator
  association [0..1] to I_MDImportStatus_2       as _ImportStatusVH       on $projection.MasterDataImportStatus = _ImportStatusVH.MasterDataImportStatus
  association [0..1] to I_MDImportSourceSystemVH as _ImportSystemVH       on $projection.MasterDataImportSourceSystem = _ImportSystemVH.MasterDataImportSourceSystem
  association [0..1] to I_UserContactCard        as _RequestorContactCard on $projection.MasterDataImportCreator = _RequestorContactCard.ContactCardID

{
  key MasterDataImportUUID,
      MasterDataImportStatus,
      _ImportStatusVH.MDImportStatusCriticality,
      MasterDataImportSourceSystem,
      MasterDataImportSourceFilter,
      MasterDataImportObjectTypeCode,
      MDChgProcessGoal,
      MDImprtIsSkipConflictRecdReqd,
      MasterDataImportCreator,
      MDImportCreationDateTime,
      tstmp_to_dats( MDImportCreationDateTime, 'UTC',  $session.client, 'NULL' )            as MDImportCreationDate,
      MDImprtNmbrOfRecordsImported,
      //not persisted fields

      cast( '' as mdc_import_file_name )                                                    as MDImportFileTemplateName,
      cast( '' as w3conttype )                                                              as MDImportFileTemplateMimeType,
      MDImportFileTemplateBinary,
      cast( '' as boolean )                                                                 as MDImportFileIsUploaded,
      cast( case MasterDataImportSourceSystem when '-/-' then 'X' else ' ' end as boolean ) as MDImportSourceSystemIsOmitted,
      MasterDataChangeProcess,

      _File,
      _ImportFile,
      _ImportUserVH,
      _ImportStatusVH,
      _ImportSystemVH,
      _RequestorContactCard
}

Learn More