I_MASTERDATAIMPORTTP_2

CDS View

Master Data Import

I_MASTERDATAIMPORTTP_2 is a CDS View in S/4HANA. Master Data Import. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_MasterDataImportTP_2 view_entity projection CONSUMPTION Master Data Import 
@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
/*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ] }*/
  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_MDCloudUserContactCard 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