I_MasterDataImportTP
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)
| Source | Alias | Join Type |
|---|---|---|
| mdc_import | mdc_import | from |
| mdc_worklist | mdc_worklist | left_outer |
Associations (2)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | I_MasterDataImportStatisticTP | _Statistic | _Statistic.MasterDataImportUUID = $projection.MasterDataImportUUID |
| [0..1] | I_MDChgProcRAPBasedSwitch | _CloudBasedSwitch | _CloudBasedSwitch.MDChgProcessSrceObjectTypeCode = mdc_import.masterdataimportobjecttypecode |
Annotations (17)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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 = ' '
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MDCHGPROCRAPBASEDSWITCH",
"MDC_IMPORT",
"MDC_WORKLIST"
],
"ASSOCIATED":
[
"I_MASTERDATAIMPORTSTATISTICTP",
"I_MDCHGPROCRAPBASEDSWITCH"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA