HPA_D_ED_ROOT

Transparent Table Application Table
17 Fields 4 CDS Views

Export Definition

HPA_D_ED_ROOT is an SAP database table in S/4HANA. Export Definition. It contains 17 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
cuan_crp_expdef_at_usage view_entity from Attribute Usage in Export Definition
CUAN_EXP_DEF_ATTRIBUTES view_entity inner Attributes of Export Definition
CUAN_EXP_DEF_SEARCH_UI view_entity from Export Definitions
CUAN_TG_WITH_NAMES_SEARCH view_entity left_outer AT_SEARCH_TARGET_GROUP_WITH_NAMES

Fields (17)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY db_key /BOBF/CONF_KEY NodeID
definition_id HPA_V_EXPORT_DEFINITION_ID Export Def. ID
name HPA_V_ED_ID_TEXT ExportDef.Descr
application_id GSEG_V_APPL_ID Application ID
profile_id GSEG_V_PR_ID Segmentation Profile
comm_area_id HPA_COMM_AREA_ID Comm. Area ID
ref_org_struc HPA_REF_ORG_STRUC Source Organization
crea_date_time TIMESTAMPL Time Stamp
crea_uname UNAME User Name
lchg_date_time TIMESTAMPL Time Stamp
lchg_uname UNAME User Name
hpa_e_export_definition DUMMY Dummy function in length 1
usage HPA_ED_USAGE_FOR Usage For
export_obj_header HPA_ADD_OBJECT_HEADER Add ID and Name
field_separator HPA_V_ED_CSVSEP Field Sep.
multi_val_separator HPA_V_ED_CSVINTSEP Field Sep. MV

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.

-- Export Definition
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE HPA_D_ED_ROOT (
    MANDT,                    -- Client [MANDT]
    DB_KEY,                   -- NodeID [/BOBF/CONF_KEY]
    DEFINITION_ID,            -- Export Def. ID [HPA_V_EXPORT_DEFINITION_ID]
    NAME,                     -- ExportDef.Descr [HPA_V_ED_ID_TEXT]
    APPLICATION_ID,           -- Application ID [GSEG_V_APPL_ID]
    PROFILE_ID,               -- Segmentation Profile [GSEG_V_PR_ID]
    COMM_AREA_ID,             -- Comm. Area ID [HPA_COMM_AREA_ID]
    REF_ORG_STRUC,            -- Source Organization [HPA_REF_ORG_STRUC]
    CREA_DATE_TIME,           -- Time Stamp [TIMESTAMPL]
    CREA_UNAME,               -- User Name [UNAME]
    LCHG_DATE_TIME,           -- Time Stamp [TIMESTAMPL]
    LCHG_UNAME,               -- User Name [UNAME]
    HPA_E_EXPORT_DEFINITION,  -- Dummy function in length 1 [DUMMY]
    USAGE,                    -- Usage For [HPA_ED_USAGE_FOR]
    EXPORT_OBJ_HEADER,        -- Add ID and Name [HPA_ADD_OBJECT_HEADER]
    FIELD_SEPARATOR,          -- Field Sep. [HPA_V_ED_CSVSEP]
    MULTI_VAL_SEPARATOR,      -- Field Sep. MV [HPA_V_ED_CSVINTSEP]
    PRIMARY KEY (MANDT, DB_KEY)
);

Learn More