I_MasterDataImport_2

DDL: I_MASTERDATAIMPORT_2 SQL: IMDIMPORT2 Type: view BASIC

Master Data Import

I_MasterDataImport_2 is a Basic CDS View that provides data about "Master Data Import" in SAP S/4HANA. It reads from 1 data source (mdc_import_rap) and exposes 13 fields with key field MasterDataImportUUID.

Data Sources (1)

SourceAliasJoin Type
mdc_import_rap mdc_import_rap from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IMDIMPORT2 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Master Data Import view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY MasterDataImportUUID guid UUID 22 char.
MasterDataImportDescription description Well Code Des.
MasterDataImportStatus status Workflow Status
MasterDataImportSourceSystem source_system Source System
MasterDataImportSourceFilter source_filter Source Filtering
MasterDataImportObjectTypeCode object_type_code Type Code
MDChgProcessGoal process_goal Process Goal
MDImprtIsSkipConflictRecdReqd skip_conflict_recd_reqd Skip Records
MasterDataImportCreator created_by Version Created By
MDImportCreationDateTime created_on Variant created on
MDImportFileTemplateBinary file_template File Content
MasterDataChangeProcess process_id Process Instance ID
MDImprtNmbrOfRecordsImported number_of_records_imported Nmbr of rec imported

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_MasterDataImport_2.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IMDIMPORT2

CREATE VIEW I_MasterDataImport_2 AS
SELECT
  guid AS MasterDataImportUUID,
  description AS MasterDataImportDescription,
  status AS MasterDataImportStatus,
  source_system AS MasterDataImportSourceSystem,
  source_filter AS MasterDataImportSourceFilter,
  object_type_code AS MasterDataImportObjectTypeCode,
  process_goal AS MDChgProcessGoal,
  skip_conflict_recd_reqd AS MDImprtIsSkipConflictRecdReqd,
  created_by AS MasterDataImportCreator,
  created_on AS MDImportCreationDateTime,
  file_template AS MDImportFileTemplateBinary,
  process_id AS MasterDataChangeProcess,
  number_of_records_imported AS MDImprtNmbrOfRecordsImported
FROM mdc_import_rap
;