I_MasterDataImportTP_2

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

CREATE VIEW I_MasterDataImportTP_2 AS
SELECT
  MasterDataImportUUID,
  MasterDataImportStatus,
  _ImportStatusVH.MDImportStatusCriticality AS MDImportStatusCriticality,
  MasterDataImportSourceSystem,
  MasterDataImportSourceFilter,
  MasterDataImportObjectTypeCode,
  MDChgProcessGoal,
  MDImprtIsSkipConflictRecdReqd,
  MasterDataImportCreator,
  MDImportCreationDateTime,
  tstmp_to_dats( MDImportCreationDateTime, 'UTC', $session.client, 'NULL' ) AS MDImportCreationDate,
  MDImprtNmbrOfRecordsImported,
  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
FROM I_MasterDataImport_2
LEFT OUTER JOIN I_MasterDataImportFileTP AS _ImportFile ON MasterDataImportUUID = _ImportFile.MasterDataImportUUID  -- association [0..1]
LEFT OUTER JOIN I_MasterDataImportUserVH AS _ImportUserVH ON MasterDataImportCreator = _ImportUserVH.MasterDataImportCreator  -- association [0..1]
LEFT OUTER JOIN I_MDImportStatus_2 AS _ImportStatusVH ON MasterDataImportStatus = _ImportStatusVH.MasterDataImportStatus  -- association [0..1]
LEFT OUTER JOIN I_MDImportSourceSystemVH AS _ImportSystemVH ON MasterDataImportSourceSystem = _ImportSystemVH.MasterDataImportSourceSystem  -- association [0..1]
LEFT OUTER JOIN I_MDCloudUserContactCard AS _RequestorContactCard ON MasterDataImportCreator = _RequestorContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_MasterDataImportFileTP AS _File ON /* condition not available in parsed metadata */  -- association [0..*]
;