HPA_D_IMPORT_HDR

Transparent Table Application Table
29 Fields 3 CDS Views

Import Header - #GENERATED#

HPA_D_IMPORT_HDR is an SAP database table in S/4HANA. Import Header - #GENERATED#. It contains 29 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
HPA_IH_SEARCH view_entity from Import header search
I_MKT_ImportHeader view_entity from BASIC Marketing: Import Header
IBC_IMPORT_HEADER_UI view_entity from Import header UI

Fields (29)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY db_key /BOBF/CONF_KEY NodeID
object_type HPA_GENERIC_OBJECT_TYPE Object Type
object_sub_type HPA_GENERIC_OBJECT_SUB_TYPE Object Subtype
import_mode HPA_IMPORT_MODE Import Mode
file_name SDOK_FILNM Component name
timestamp TIMESTAMPL Time Stamp
source_system_type HPA_SOURCE_SYSTEM_TYPE Source System
source_system_id HPA_SOURCE_SYST_ID Source Sys. ID
commentary HPA_COMMENT Comment
imported_records_count HPA_IMPORTED_RECORDS_COUNT Number of Records
_dataaging DATA_TEMPERATURE Data Aging
failed_records_count HPA_FAILED_RECORDS_COUNT Number of F. Records
status HPA_ERROR_STATUS Err. Stat.
ref_message_id GUID_32 GUID 16
expected_packages_count HPA_EXPECTED_PACKAGES_COUNT No of Exp Packages
received_packages_count HPA_RECEIVED_PACKAGES_COUNT No of Exp Packages
service_name HPA_SERVICE_NAME Serv. Name
total_records_count HPA_TOTAL_RECORDS_COUNT Number of Records
staging_area BOOLE_D TRUE
force_sync_processing BOOLE_D TRUE
transaction_id EPP_TRANSACTION_ID Transaction
connection_id EPP_CONNECTION_ID Connection ID
connection_counter HPA_CONNECTION_COUNTER Conn. counter
username XUBNAME User
crea_date_time TIMESTAMPL Time Stamp
crea_uname UNAME User Name
lchg_date_time TIMESTAMPL Time Stamp
lchg_uname UNAME User Name

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Import Header - #GENERATED#
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE HPA_D_IMPORT_HDR (
    MANDT,                    -- Client [MANDT]
    DB_KEY,                   -- NodeID [/BOBF/CONF_KEY]
    OBJECT_TYPE,              -- Object Type [HPA_GENERIC_OBJECT_TYPE]
    OBJECT_SUB_TYPE,          -- Object Subtype [HPA_GENERIC_OBJECT_SUB_TYPE]
    IMPORT_MODE,              -- Import Mode [HPA_IMPORT_MODE]
    FILE_NAME,                -- Component name [SDOK_FILNM]
    TIMESTAMP,                -- Time Stamp [TIMESTAMPL]
    SOURCE_SYSTEM_TYPE,       -- Source System [HPA_SOURCE_SYSTEM_TYPE]
    SOURCE_SYSTEM_ID,         -- Source Sys. ID [HPA_SOURCE_SYST_ID]
    COMMENTARY,               -- Comment [HPA_COMMENT]
    IMPORTED_RECORDS_COUNT,   -- Number of Records [HPA_IMPORTED_RECORDS_COUNT]
    _DATAAGING,               -- Data Aging [DATA_TEMPERATURE]
    FAILED_RECORDS_COUNT,     -- Number of F. Records [HPA_FAILED_RECORDS_COUNT]
    STATUS,                   -- Err. Stat. [HPA_ERROR_STATUS]
    REF_MESSAGE_ID,           -- GUID 16 [GUID_32]
    EXPECTED_PACKAGES_COUNT,  -- No of Exp Packages [HPA_EXPECTED_PACKAGES_COUNT]
    RECEIVED_PACKAGES_COUNT,  -- No of Exp Packages [HPA_RECEIVED_PACKAGES_COUNT]
    SERVICE_NAME,             -- Serv. Name [HPA_SERVICE_NAME]
    TOTAL_RECORDS_COUNT,      -- Number of Records [HPA_TOTAL_RECORDS_COUNT]
    STAGING_AREA,             -- TRUE [BOOLE_D]
    FORCE_SYNC_PROCESSING,    -- TRUE [BOOLE_D]
    TRANSACTION_ID,           -- Transaction [EPP_TRANSACTION_ID]
    CONNECTION_ID,            -- Connection ID [EPP_CONNECTION_ID]
    CONNECTION_COUNTER,       -- Conn. counter [HPA_CONNECTION_COUNTER]
    USERNAME,                 -- User [XUBNAME]
    CREA_DATE_TIME,           -- Time Stamp [TIMESTAMPL]
    CREA_UNAME,               -- User Name [UNAME]
    LCHG_DATE_TIME,           -- Time Stamp [TIMESTAMPL]
    LCHG_UNAME,               -- User Name [UNAME]
    PRIMARY KEY (MANDT, DB_KEY)
);

Learn More