HRFIO_D_ASR_FVH

Transparent Table Application Table

Field valuehelp entity

HRFIO_D_ASR_FVH is an SAP database table in S/4HANA. Field valuehelp entity. It contains 22 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_HCMProcFldValHelp view_entity from BASIC F4 help

Fields (22)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY process_id ASR_PROCESS Process
KEY process_guid SCMG_CASE_GUID Case Key
KEY workitem_id SWW_WIID Work Item ID
KEY fieldkey CHAR255 Char255
KEY fieldname HRASR_FIELDNAME Field Name
form_scenario ASR_SCENARIO Scenario
form_scenario_stage ASR_SCENARIO_STAGE Scenario Step
form_scenario_version ASR_SCENARIO_VERSION ScenarioVersion
fieldcontroltype HRFIO_ASR_CONTROLTYPE control type
objectkey ASR_OBJECT_KEY Object Key
personnelnumber PERNR_D Personnel No.
filterstring1 HRFIO_ASR_FILTERSTRING Filter String
filterstring1val HRASR_FIELDVALUE Field Value
user_event ASR_FORM_OPERATION Operation
filterstring2 HRFIO_ASR_FILTERSTRING Filter String
filterstring2val HRASR_FIELDVALUE Field Value
filterstring3 HRFIO_ASR_FILTERSTRING Filter String
filterstring3val HRASR_FIELDVALUE Field Value
filterstring4 HRFIO_ASR_FILTERSTRING Filter String
filterstring4val HRASR_FIELDVALUE Field Value
fieldvalue HRASR_FIELDVALUE Field Value

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.

-- Field valuehelp entity
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE HRFIO_D_ASR_FVH (
    MANDT,                  -- Client [MANDT]
    PROCESS_ID,             -- Process [ASR_PROCESS]
    PROCESS_GUID,           -- Case Key [SCMG_CASE_GUID]
    WORKITEM_ID,            -- Work Item ID [SWW_WIID]
    FIELDKEY,               -- Char255 [CHAR255]
    FIELDNAME,              -- Field Name [HRASR_FIELDNAME]
    FORM_SCENARIO,          -- Scenario [ASR_SCENARIO]
    FORM_SCENARIO_STAGE,    -- Scenario Step [ASR_SCENARIO_STAGE]
    FORM_SCENARIO_VERSION,  -- ScenarioVersion [ASR_SCENARIO_VERSION]
    FIELDCONTROLTYPE,       -- control type [HRFIO_ASR_CONTROLTYPE]
    OBJECTKEY,              -- Object Key [ASR_OBJECT_KEY]
    PERSONNELNUMBER,        -- Personnel No. [PERNR_D]
    FILTERSTRING1,          -- Filter String [HRFIO_ASR_FILTERSTRING]
    FILTERSTRING1VAL,       -- Field Value [HRASR_FIELDVALUE]
    USER_EVENT,             -- Operation [ASR_FORM_OPERATION]
    FILTERSTRING2,          -- Filter String [HRFIO_ASR_FILTERSTRING]
    FILTERSTRING2VAL,       -- Field Value [HRASR_FIELDVALUE]
    FILTERSTRING3,          -- Filter String [HRFIO_ASR_FILTERSTRING]
    FILTERSTRING3VAL,       -- Field Value [HRASR_FIELDVALUE]
    FILTERSTRING4,          -- Filter String [HRFIO_ASR_FILTERSTRING]
    FILTERSTRING4VAL,       -- Field Value [HRASR_FIELDVALUE]
    FIELDVALUE,             -- Field Value [HRASR_FIELDVALUE]
    PRIMARY KEY (MANDT, PROCESS_ID, PROCESS_GUID, WORKITEM_ID, FIELDKEY, FIELDNAME)
);