EHFNDV_PHVISD

22 Fields 1 CDS Views

Generated Table for View

EHFNDV_PHVISD is an SAP database table in S/4HANA. Generated Table for View. It contains 22 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PhysChmlViscosityDyn view from BASIC Dynamic Viscosity

Fields (22)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY physchmlviscositydynuuid EHFND_VISCOS_DYN_UUID Dynamic Viscosity: ID
physchmlprptyuuid EHFND_PHYSCHEM_UUID Physical-Chemical Property
creationutcdatetime TIMESTAMPL Time Stamp
createdbyuser UNAME User Name
lastchangeutcdatetime TIMESTAMPL Time Stamp
lastchangedbyuser UNAME User Name
physchmlviscositydynqtyunit EHFND_UNIT_CODE_MEINS Unit of Measurement
pcphysdynvscty20lowrqtyoptr EHFND_OPERATOR_LOWER_LIMIT Operator of Lower Limit
pcphysdynvscty20lowrqty EHFND_VISCOS_D20C_LOWER_QTY Dynamic Viscosity at 20°C (68 °F)
pcphysdynvscty20lowrqtytxt EHFND_VISCOS_D20C_LOWER_QTY_CH Dynamic Viscosity: Low. Lmt at 20 °C Tx
pcphysdynvscty20uprqtyoptr EHFND_OPERATOR_UPPER_LIMIT Operator of Upper Limit
pcphysdynvscty20uprqty EHFND_VISCOS_D20C_UPPER_QTY Dynamic Viscosity: Upper Limit at 20 °C
pcphysdynvscty20uprqtytxt EHFND_VISCOS_D20C_UPPER_QTY_CH Dynamic Viscosity: Upp. Lmt at 20 °C Tx
pcphysnotetext EHFND_NOTE_1333 Notes
pcphysaddlstatementphrsuuid EHFND_ADD_STMNT_PHRASE_UUID Additional Statement
pcphysdynvscty23lowrqtyoptr EHFND_OPERATOR_LOWER_LIMIT Operator of Lower Limit
pcphysdynvscty23lowrqty EHFND_VISCOS_D23C_LOWER_QTY Dynamic Viscosity at 23 °C (73.4 °F)
pcphysdynvscty23lowrqtytxt EHFND_VISCOS_D23C_LOWER_QTY_CH Dynamic Viscosity: Low. Lmt at 23 °C Tx
pcphysdynvscty23uprqtyoptr EHFND_OPERATOR_UPPER_LIMIT Operator of Upper Limit
pcphysdynvscty23uprqty EHFND_VISCOS_D23C_UPPER_QTY Dynamic Viscosity: Upper Limit at 23 °C
pcphysdynvscty23uprqtytxt EHFND_VISCOS_D23C_UPPER_QTY_CH Dynamic Viscosity: Upp. Lmt at 23 °C Tx

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.

-- Generated Table for View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDV_PHVISD (
    MANDT,                        -- Client [MANDT]
    PHYSCHMLVISCOSITYDYNUUID,     -- Dynamic Viscosity: ID [EHFND_VISCOS_DYN_UUID]
    PHYSCHMLPRPTYUUID,            -- Physical-Chemical Property [EHFND_PHYSCHEM_UUID]
    CREATIONUTCDATETIME,          -- Time Stamp [TIMESTAMPL]
    CREATEDBYUSER,                -- User Name [UNAME]
    LASTCHANGEUTCDATETIME,        -- Time Stamp [TIMESTAMPL]
    LASTCHANGEDBYUSER,            -- User Name [UNAME]
    PHYSCHMLVISCOSITYDYNQTYUNIT,  -- Unit of Measurement [EHFND_UNIT_CODE_MEINS]
    PCPHYSDYNVSCTY20LOWRQTYOPTR,  -- Operator of Lower Limit [EHFND_OPERATOR_LOWER_LIMIT]
    PCPHYSDYNVSCTY20LOWRQTY,      -- Dynamic Viscosity at 20°C (68 °F) [EHFND_VISCOS_D20C_LOWER_QTY]
    PCPHYSDYNVSCTY20LOWRQTYTXT,   -- Dynamic Viscosity: Low. Lmt at 20 °C Tx [EHFND_VISCOS_D20C_LOWER_QTY_CH]
    PCPHYSDYNVSCTY20UPRQTYOPTR,   -- Operator of Upper Limit [EHFND_OPERATOR_UPPER_LIMIT]
    PCPHYSDYNVSCTY20UPRQTY,       -- Dynamic Viscosity: Upper Limit at 20 °C [EHFND_VISCOS_D20C_UPPER_QTY]
    PCPHYSDYNVSCTY20UPRQTYTXT,    -- Dynamic Viscosity: Upp. Lmt at 20 °C Tx [EHFND_VISCOS_D20C_UPPER_QTY_CH]
    PCPHYSNOTETEXT,               -- Notes [EHFND_NOTE_1333]
    PCPHYSADDLSTATEMENTPHRSUUID,  -- Additional Statement [EHFND_ADD_STMNT_PHRASE_UUID]
    PCPHYSDYNVSCTY23LOWRQTYOPTR,  -- Operator of Lower Limit [EHFND_OPERATOR_LOWER_LIMIT]
    PCPHYSDYNVSCTY23LOWRQTY,      -- Dynamic Viscosity at 23 °C (73.4 °F) [EHFND_VISCOS_D23C_LOWER_QTY]
    PCPHYSDYNVSCTY23LOWRQTYTXT,   -- Dynamic Viscosity: Low. Lmt at 23 °C Tx [EHFND_VISCOS_D23C_LOWER_QTY_CH]
    PCPHYSDYNVSCTY23UPRQTYOPTR,   -- Operator of Upper Limit [EHFND_OPERATOR_UPPER_LIMIT]
    PCPHYSDYNVSCTY23UPRQTY,       -- Dynamic Viscosity: Upper Limit at 23 °C [EHFND_VISCOS_D23C_UPPER_QTY]
    PCPHYSDYNVSCTY23UPRQTYTXT,    -- Dynamic Viscosity: Upp. Lmt at 23 °C Tx [EHFND_VISCOS_D23C_UPPER_QTY_CH]
    PRIMARY KEY (MANDT, PHYSCHMLVISCOSITYDYNUUID)
);

Learn More