I_MKT_ImportHeader

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_MKT_ImportHeader.
-- 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_MKT_ImportHeader AS
SELECT
  cast(Persistence.db_key as cuan_key_ext) AS ImportHeaderUUID,
  Persistence.object_type AS ImportHeaderObjectType,
  Persistence.object_sub_type AS ImportHeaderObjectSubType,
  Persistence.import_mode AS ImportHeaderImportMode,
  Persistence.file_name AS ImportHeaderFileName,
  Persistence.timestamp AS ImportHeaderUTCDateTime,
  Persistence.source_system_type AS ImportHeaderSourceSystemType,
  Persistence.source_system_id AS ImportHeaderSourceSystem,
  Persistence.commentary AS ImportHeaderCommentary,
  Persistence.imported_records_count AS NmbrOfImprtHdrImportedRecords,
  Persistence.failed_records_count AS NmbrOfImprtHeaderFailedRecords,
  Persistence.status AS ImportHeaderStatus,
  Persistence.ref_message_id AS ImportHeaderRefMessageUUID,
  Persistence.service_name AS ImportHeaderServiceName,
  Persistence.total_records_count AS NmbrOfImportHeaderRecords,
  Persistence.staging_area AS ImportHeaderHasStagingArea,
  Persistence.force_sync_processing AS SynchronousImportIsForced,
  Persistence.username AS ImportHeaderUserName,
  Persistence.crea_date_time AS ImprtHeaderCreationUTCDateTime,
  Persistence.crea_uname AS ImportHeaderCreatedByUser,
  Persistence.lchg_date_time AS ImprtHdrLastChangedUTCDateTime,
  Persistence.lchg_uname AS ImportHeaderLastChangedByUser,
  tstmp_to_dats(cast(Persistence.crea_date_time as timestamp),abap_user_timezone($session.user,$session.client,'NULL'),$session.client,'NULL') AS ImportHeaderCreationDate
FROM hpa_d_import_hdr AS Persistence
LEFT OUTER JOIN I_MKT_ImportMode AS _MKT_ImportMode ON ImportHeaderImportMode = _MKT_ImportMode.ImportHeaderImportMode  -- association [0..1]
LEFT OUTER JOIN I_MKT_SourceSystemType AS _MKT_SourceSystemType ON ImportHeaderSourceSystemType = _MKT_SourceSystemType.ImportHeaderSourceSystemType  -- association [0..1]
LEFT OUTER JOIN I_MKT_ImportStatus AS _MKT_ImportStatus ON ImportHeaderStatus = _MKT_ImportStatus.ImportHeaderStatus  -- association [0..1]
;