EHFNDW_PHSOLU

Transparent Table Application Table
20 Fields 1 CDS Views

I_PHYSICALCHEMICALPROPERTYTP I_PHYSCHMLWTRSLBTYTP

EHFNDW_PHSOLU is an SAP database table in S/4HANA. I_PHYSICALCHEMICALPROPERTYTP I_PHYSCHMLWTRSLBTYTP. It contains 20 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
EHFNDV_INVALID_PHRS2008 view union_all

Fields (20)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY physchmlwtrslbtyuuid ehfnd_solublty_water_uuid Solubility in Water: ID
physchmlprptyuuid ehfnd_physchem_uuid Physical-Chemical Property
creationutcdatetime ehfnd_bo_crea_date_time Created On
createdbyuser ehfnd_bo_crea_uname Created By
lastchangeutcdatetime ehfnd_bo_lchg_date_time Last Changed On
lastchangedbyuser ehfnd_bo_lchg_uname Last Changed By
pcprptylowrlmtoptr ehfnd_operator_lower_limit Operator of Lower Limit
pcphyswtrslbtylowrqty ehfnd_slblty_water_lower_qty Quantity
pcphyswtrslbtylowrqtyastxt ehfnd_slblty_water_lower_qty_c Solubility in Water: Lower Limit (Text)
pcprptyuprlmtoptr ehfnd_operator_upper_limit Operator of Upper Limit
pcphyswtrslbtyuprqty ehfnd_slblty_water_upper_qty Solubility In Water: Upper Limit
pcphyswtrslbtyuprqtyastxt ehfnd_slblty_water_upper_qty_c Solubility In Water: Upper Limit (Text)
physchmlwtrslbtyqtyunit ehfnd_unit_code_meins Unit of Measurement
pcphyswtrslbtymethodphrsuuid ehfnd_slblty_water_meth_p_uuid Method
pcphysnotetext ehfnd_note_1333 Notes
pcphysaddlstatementphrsuuid ehfnd_slblty_water_stmt_p_uuid Additional Statement
pcphysassessmentphrsuuid ehfnd_slblty_water_assm_p_uuid Assessment
activeuuid /bobf/uuid Key
hasactiveentity sdraft_has_active Has active

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.

-- I_PHYSICALCHEMICALPROPERTYTP I_PHYSCHMLWTRSLBTYTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDW_PHSOLU (
    MANDT,                         -- Client [mandt]
    PHYSCHMLWTRSLBTYUUID,          -- Solubility in Water: ID [ehfnd_solublty_water_uuid]
    PHYSCHMLPRPTYUUID,             -- Physical-Chemical Property [ehfnd_physchem_uuid]
    CREATIONUTCDATETIME,           -- Created On [ehfnd_bo_crea_date_time]
    CREATEDBYUSER,                 -- Created By [ehfnd_bo_crea_uname]
    LASTCHANGEUTCDATETIME,         -- Last Changed On [ehfnd_bo_lchg_date_time]
    LASTCHANGEDBYUSER,             -- Last Changed By [ehfnd_bo_lchg_uname]
    PCPRPTYLOWRLMTOPTR,            -- Operator of Lower Limit [ehfnd_operator_lower_limit]
    PCPHYSWTRSLBTYLOWRQTY,         -- Quantity [ehfnd_slblty_water_lower_qty]
    PCPHYSWTRSLBTYLOWRQTYASTXT,    -- Solubility in Water: Lower Limit (Text) [ehfnd_slblty_water_lower_qty_c]
    PCPRPTYUPRLMTOPTR,             -- Operator of Upper Limit [ehfnd_operator_upper_limit]
    PCPHYSWTRSLBTYUPRQTY,          -- Solubility In Water: Upper Limit [ehfnd_slblty_water_upper_qty]
    PCPHYSWTRSLBTYUPRQTYASTXT,     -- Solubility In Water: Upper Limit (Text) [ehfnd_slblty_water_upper_qty_c]
    PHYSCHMLWTRSLBTYQTYUNIT,       -- Unit of Measurement [ehfnd_unit_code_meins]
    PCPHYSWTRSLBTYMETHODPHRSUUID,  -- Method [ehfnd_slblty_water_meth_p_uuid]
    PCPHYSNOTETEXT,                -- Notes [ehfnd_note_1333]
    PCPHYSADDLSTATEMENTPHRSUUID,   -- Additional Statement [ehfnd_slblty_water_stmt_p_uuid]
    PCPHYSASSESSMENTPHRSUUID,      -- Assessment [ehfnd_slblty_water_assm_p_uuid]
    ACTIVEUUID,                    -- Key [/bobf/uuid]
    HASACTIVEENTITY,               -- Has active [sdraft_has_active]
    PRIMARY KEY (MANDT, PHYSCHMLWTRSLBTYUUID)
);

Learn More