I_MasterDataImportTP

DDL: I_MASTERDATAIMPORTTP SQL: IMDIMPORTTP Type: view TRANSACTIONAL
26 Fields 2 Data Sources 2 Associations

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.

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 Load Name
MasterDataImportStatus mdc_import masterdataimportstatus Status
MasterDataImportObjectTypeCode mdc_import masterdataimportobjecttypecode Bus. Obj. Type
MasterDataImportCreator mdc_import masterdataimportcreator Import Creator
MDImportCreationDateTime mdc_import mdimportcreationdatetime Creation Date Time
MasterDataImportWorklist mdc_import masterdataimportworklist Worklist GUID
MasterDataImportSeparatorSign mdc_import masterdataimportseparatorsign Separator
MasterDataImportEscapeSign mdc_import masterdataimportescapesign Escape Sign
MasterDataChangeProcess mdc_import masterdatachangeprocess Process ID
MDChgProcessGoal mdc_import mdchgprocessgoal Process Goal
MDImprtIsSkipConflictRecdReqd mdc_import mdimprtisskipconflictrecdreqd Skip Records
MasterDataImportSourceSystem mdc_worklist source_system Source System
MasterDataImportSourceFilter mdc_worklist source_filter Source Filtering
MasterDataImportLastAction mdc_import masterdataimportlastaction Action
MasterDataImportActnStatus mdc_import masterdataimportactnstatus Master Data Import last triggered Action Status
SystemMessageIdentification mdc_import systemmessageidentification Message ID
SystemMessageType mdc_import systemmessagetype Message type
SystemMessageNumber mdc_import systemmessagenumber Message Number
SystemMessageVariable1 mdc_import systemmessagevariable1 Variable 1
SystemMessageVariable2 mdc_import systemmessagevariable2 Variable 2
SystemMessageVariable3 mdc_import systemmessagevariable3 Variable 3
SystemMessageVariable4 mdc_import systemmessagevariable4 Variable 4
SystemMessageText mdc_import systemmessagetext Message Text
_Statistic _Statistic
_CloudBasedSwitch _CloudBasedSwitch

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_MasterDataImportTP.
-- 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: IMDIMPORTTP

CREATE VIEW I_MasterDataImportTP AS
SELECT
  cast ( mdc_import.masterdataimportuuid as sysuuid_x ) AS MasterDataImportUUID,
  mdc_import.masterdataimportdescription AS MasterDataImportDescription,
  mdc_import.masterdataimportstatus AS MasterDataImportStatus,
  mdc_import.masterdataimportobjecttypecode AS MasterDataImportObjectTypeCode,
  mdc_import.masterdataimportcreator AS MasterDataImportCreator,
  mdc_import.mdimportcreationdatetime AS MDImportCreationDateTime,
  mdc_import.masterdataimportworklist AS MasterDataImportWorklist,
  mdc_import.masterdataimportseparatorsign AS MasterDataImportSeparatorSign,
  mdc_import.masterdataimportescapesign AS MasterDataImportEscapeSign,
  mdc_import.masterdatachangeprocess AS MasterDataChangeProcess,
  mdc_import.mdchgprocessgoal AS MDChgProcessGoal,
  mdc_import.mdimprtisskipconflictrecdreqd AS MDImprtIsSkipConflictRecdReqd,
  mdc_worklist.source_system AS MasterDataImportSourceSystem,
  mdc_worklist.source_filter AS MasterDataImportSourceFilter,
  mdc_import.masterdataimportlastaction AS MasterDataImportLastAction,
  mdc_import.masterdataimportactnstatus AS MasterDataImportActnStatus,
  mdc_import.systemmessageidentification AS SystemMessageIdentification,
  mdc_import.systemmessagetype AS SystemMessageType,
  mdc_import.systemmessagenumber AS SystemMessageNumber,
  mdc_import.systemmessagevariable1 AS SystemMessageVariable1,
  mdc_import.systemmessagevariable2 AS SystemMessageVariable2,
  mdc_import.systemmessagevariable3 AS SystemMessageVariable3,
  mdc_import.systemmessagevariable4 AS SystemMessageVariable4,
  mdc_import.systemmessagetext AS SystemMessageText
FROM mdc_import
LEFT OUTER JOIN mdc_worklist ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MasterDataImportStatisticTP AS _Statistic ON _Statistic.MasterDataImportUUID = MasterDataImportUUID  -- association [0..1]
LEFT OUTER JOIN I_MDChgProcRAPBasedSwitch AS _CloudBasedSwitch ON _CloudBasedSwitch.MDChgProcessSrceObjectTypeCode = mdc_import.masterdataimportobjecttypecode  -- association [0..1]
;

Learn More