EHFNDD_PCHA_ROOT

Transparent Table Application Table
41 Fields 1 CDS Views

Process Control - Root

EHFNDD_PCHA_ROOT is an SAP database table in S/4HANA. Process Control - Root. It contains 41 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ProcCtrlChemicalRoot view from BASIC Process Control Chemical Root

Fields (41)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY db_key /BOBF/CONF_KEY NodeID
datetime_cr /BOBF/DATETIME_CR Created On/At
user_id_cr /BOBF/USER_ID_CR Created By
datetime_ch /BOBF/DATETIME_CH Changed On/At
user_id_ch /BOBF/USER_ID_CH Changed By
bo_key_ref EHFND_BO_REF_BO_DEF_KEY BO Reference – Definition Key of the Business Object
bo_root_key_ref EHFND_BO_REF_ROOT_INST_KEY BO Reference – Instance Key of the ROOT Node
bo_node_key_ref EHFND_BO_REF_NODE_DEF_KEY Definition Key
bo_key_ref_node EHFND_BO_REF_NODE_INST_KEY BO Reference – Instance Key of the Subnode
dta_key_ref EHFND_DTA_BO_REF_BO_DEF_KEY Data BO Reference – Definition Key of the Business Object
dta_root_key_ref EHFND_DTA_BO_REF_ROOT_INST_KEY Data BO Reference – Instance Key of the ROOT Node
dta_node_key_ref EHFND_DTA_BO_REF_NODE_DEF_KEY Data BO Reference – Definition Key of the Subnode
dta_key_ref_node EHFND_DTA_BO_REF_NODE_INST_KEY Data BO Reference – Instance Key of the Subnode
pc_bo_key_ref EHFND_PCBO_REF_BO_DEF_KEY PCBO Reference – Definition Key of the Process Control BO
pc_root_key_ref EHFND_PCBO_REF_ROOT_INST_KEY PCBO Reference – Instance Key of the ROOT Node
variant EHFND_WFF_VARIANT Process Variant
status EHFND_WFF_STATUS Int. PCO Status
status_remark EHFND_WFF_STATUS_REMARK Sts Comment
wf_instance_id SWW_WIID Work Item ID
wf_template_id SWW_TASK Task
wi_count EHFND_WFF_WI_COUNT Tasks
time_total EHFND_WFF_TIME_TOTAL Tot. Cumulated Time
net_total EHFND_WFF_NET_TOTAL Cml. Working Hrs
unit EHFND_WFF_WIS_UNIT Unit
ehsm_component EHFND_EHSM_COMPONENT Component
purpose EHFND_PURPOSE Purpose
fin_timestamp TZNTSTMPS Time Stamp
fin_ti_zo EHFND_PRC_FINISHED_TI_ZO Time Zone
proc_status SWW_WIID Work Item ID
duration TZNTSTMPL Time Stamp
pse_root_key /BOBF/CONF_KEY NodeID
is_recurring EHFND_WFF_IS_RECURRING Recurring Process
material_id EHFND_MAT_ID Product
substance_id EHFND_SUBSTANCE_ID Substance
customer_id EHFND_CUSTOMER_ID Customer
supplier_id EHFND_SUPPLIER_ID Supplier
compliance_check EHFND_CHECK Compl. Req.
proc_status_type SWW_TASK Task
archiving_status /BOFU/ARCHIVING_STATUS_CODE Archiving Stat.
eew_prc_root_d DUMMY Dummy function in length 1

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.

-- Process Control - Root
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDD_PCHA_ROOT (
    MANDT,             -- Client [MANDT]
    DB_KEY,            -- NodeID [/BOBF/CONF_KEY]
    DATETIME_CR,       -- Created On/At [/BOBF/DATETIME_CR]
    USER_ID_CR,        -- Created By [/BOBF/USER_ID_CR]
    DATETIME_CH,       -- Changed On/At [/BOBF/DATETIME_CH]
    USER_ID_CH,        -- Changed By [/BOBF/USER_ID_CH]
    BO_KEY_REF,        -- BO Reference – Definition Key of the Business Object [EHFND_BO_REF_BO_DEF_KEY]
    BO_ROOT_KEY_REF,   -- BO Reference – Instance Key of the ROOT Node [EHFND_BO_REF_ROOT_INST_KEY]
    BO_NODE_KEY_REF,   -- Definition Key [EHFND_BO_REF_NODE_DEF_KEY]
    BO_KEY_REF_NODE,   -- BO Reference – Instance Key of the Subnode [EHFND_BO_REF_NODE_INST_KEY]
    DTA_KEY_REF,       -- Data BO Reference – Definition Key of the Business Object [EHFND_DTA_BO_REF_BO_DEF_KEY]
    DTA_ROOT_KEY_REF,  -- Data BO Reference – Instance Key of the ROOT Node [EHFND_DTA_BO_REF_ROOT_INST_KEY]
    DTA_NODE_KEY_REF,  -- Data BO Reference – Definition Key of the Subnode [EHFND_DTA_BO_REF_NODE_DEF_KEY]
    DTA_KEY_REF_NODE,  -- Data BO Reference – Instance Key of the Subnode [EHFND_DTA_BO_REF_NODE_INST_KEY]
    PC_BO_KEY_REF,     -- PCBO Reference – Definition Key of the Process Control BO [EHFND_PCBO_REF_BO_DEF_KEY]
    PC_ROOT_KEY_REF,   -- PCBO Reference – Instance Key of the ROOT Node [EHFND_PCBO_REF_ROOT_INST_KEY]
    VARIANT,           -- Process Variant [EHFND_WFF_VARIANT]
    STATUS,            -- Int. PCO Status [EHFND_WFF_STATUS]
    STATUS_REMARK,     -- Sts Comment [EHFND_WFF_STATUS_REMARK]
    WF_INSTANCE_ID,    -- Work Item ID [SWW_WIID]
    WF_TEMPLATE_ID,    -- Task [SWW_TASK]
    WI_COUNT,          -- Tasks [EHFND_WFF_WI_COUNT]
    TIME_TOTAL,        -- Tot. Cumulated Time [EHFND_WFF_TIME_TOTAL]
    NET_TOTAL,         -- Cml. Working Hrs [EHFND_WFF_NET_TOTAL]
    UNIT,              -- Unit [EHFND_WFF_WIS_UNIT]
    EHSM_COMPONENT,    -- Component [EHFND_EHSM_COMPONENT]
    PURPOSE,           -- Purpose [EHFND_PURPOSE]
    FIN_TIMESTAMP,     -- Time Stamp [TZNTSTMPS]
    FIN_TI_ZO,         -- Time Zone [EHFND_PRC_FINISHED_TI_ZO]
    PROC_STATUS,       -- Work Item ID [SWW_WIID]
    DURATION,          -- Time Stamp [TZNTSTMPL]
    PSE_ROOT_KEY,      -- NodeID [/BOBF/CONF_KEY]
    IS_RECURRING,      -- Recurring Process [EHFND_WFF_IS_RECURRING]
    MATERIAL_ID,       -- Product [EHFND_MAT_ID]
    SUBSTANCE_ID,      -- Substance [EHFND_SUBSTANCE_ID]
    CUSTOMER_ID,       -- Customer [EHFND_CUSTOMER_ID]
    SUPPLIER_ID,       -- Supplier [EHFND_SUPPLIER_ID]
    COMPLIANCE_CHECK,  -- Compl. Req. [EHFND_CHECK]
    PROC_STATUS_TYPE,  -- Task [SWW_TASK]
    ARCHIVING_STATUS,  -- Archiving Stat. [/BOFU/ARCHIVING_STATUS_CODE]
    EEW_PRC_ROOT_D,    -- Dummy function in length 1 [DUMMY]
    PRIMARY KEY (MANDT, DB_KEY)
);

Learn More