I_MasterDataImportFileTP

DDL: I_MASTERDATAIMPORTFILETP Type: view_entity TRANSACTIONAL Package: MDC_LOAD
11 Fields 1 Data Sources 1 Associations

Master Data Import File

I_MasterDataImportFileTP is a Transactional CDS View that provides data about "Master Data Import File" in SAP S/4HANA. It reads from 1 data source (I_MasterDataImportFile) and exposes 11 fields with key field MasterDataImportFileUUID. It has 1 association to related views. Part of development package MDC_LOAD.

Data Sources (1)

SourceAliasJoin Type
I_MasterDataImportFile I_MasterDataImportFile from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_MDCloudUserContactCard _RequestorContactCard $projection.MasterDataImportFileCreatedBy = _RequestorContactCard.ContactCardID

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 File view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY MasterDataImportFileUUID MasterDataImportFileUUID UUID 22 char.
MasterDataImportUUID MasterDataImportUUID NodeID
MasterDataLoadUUID MasterDataLoadUUID GUID
MasterDataImportFileType MasterDataImportFileType Worklist Type
MasterDataImportFileMimeType MasterDataImportFileMimeType MIME type
MasterDataImportFileName MasterDataImportFileName Zone name
MasterDataImportFileCrtnDteTme MasterDataImportFileCrtnDteTme Variant created on
MasterDataImportFileCreatedBy MasterDataImportFileCreatedBy Version Created By
MDImportFileContentBinary MDImportFileContentBinary Trusted Site Content
_Import _Import
_RequestorContactCard _RequestorContactCard

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_MasterDataImportFileTP.
-- 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.

CREATE VIEW I_MasterDataImportFileTP AS
SELECT
  MasterDataImportFileUUID,
  MasterDataImportUUID,
  MasterDataLoadUUID,
  MasterDataImportFileType,
  MasterDataImportFileMimeType,
  MasterDataImportFileName,
  MasterDataImportFileCrtnDteTme,
  MasterDataImportFileCreatedBy,
  MDImportFileContentBinary
FROM I_MasterDataImportFile
LEFT OUTER JOIN I_MDCloudUserContactCard AS _RequestorContactCard ON MasterDataImportFileCreatedBy = _RequestorContactCard.ContactCardID  -- association [0..1]
;

Learn More