EHFNDV_PHPARTSZ

15 Fields 1 CDS Views

Generated Table for View

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PhysChmlParticleSize view from BASIC Particle Size

Fields (15)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY physchmlparticlesizeuuid EHFND_PART_SIZE_UUID Particle Size: ID
physchmlprptyuuid EHFND_PHYSCHEM_UUID Physical-Chemical Property
creationutcdatetime TIMESTAMPL Time Stamp
createdbyuser UNAME User Name
lastchangeutcdatetime TIMESTAMPL Time Stamp
lastchangedbyuser UNAME User Name
physchmlparticlesizelowrqty EHFND_PART_SIZE_LOWER_QTY Particle Size
physchmlparticlesizelowrqtytxt EHFND_PART_SIZE_LOWER_QTY_CH Particle Size: Lower Limit (as Text)
physchmlparticlesizeuprqty EHFND_PART_SIZE_UPPER_QTY Particle Size: Upper Limit
physchmlparticlesizeuprqtytxt EHFND_PART_SIZE_UPPER_QTY_CH Particle Size: Upper Limit (as Text)
physchmlparticlesizeqtyunit EHFND_UNIT_CODE_MEINS Unit of Measurement
pcprptylowrlmtoptr EHFND_OPERATOR_LOWER_LIMIT Operator of Lower Limit
pcprptyuprlmtoptr EHFND_OPERATOR_UPPER_LIMIT Operator of Upper Limit
pcphysnotetext EHFND_NOTE_1333 Notes

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_PHPARTSZ (
    MANDT,                           -- Client [MANDT]
    PHYSCHMLPARTICLESIZEUUID,        -- Particle Size: ID [EHFND_PART_SIZE_UUID]
    PHYSCHMLPRPTYUUID,               -- Physical-Chemical Property [EHFND_PHYSCHEM_UUID]
    CREATIONUTCDATETIME,             -- Time Stamp [TIMESTAMPL]
    CREATEDBYUSER,                   -- User Name [UNAME]
    LASTCHANGEUTCDATETIME,           -- Time Stamp [TIMESTAMPL]
    LASTCHANGEDBYUSER,               -- User Name [UNAME]
    PHYSCHMLPARTICLESIZELOWRQTY,     -- Particle Size [EHFND_PART_SIZE_LOWER_QTY]
    PHYSCHMLPARTICLESIZELOWRQTYTXT,  -- Particle Size: Lower Limit (as Text) [EHFND_PART_SIZE_LOWER_QTY_CH]
    PHYSCHMLPARTICLESIZEUPRQTY,      -- Particle Size: Upper Limit [EHFND_PART_SIZE_UPPER_QTY]
    PHYSCHMLPARTICLESIZEUPRQTYTXT,   -- Particle Size: Upper Limit (as Text) [EHFND_PART_SIZE_UPPER_QTY_CH]
    PHYSCHMLPARTICLESIZEQTYUNIT,     -- Unit of Measurement [EHFND_UNIT_CODE_MEINS]
    PCPRPTYLOWRLMTOPTR,              -- Operator of Lower Limit [EHFND_OPERATOR_LOWER_LIMIT]
    PCPRPTYUPRLMTOPTR,               -- Operator of Upper Limit [EHFND_OPERATOR_UPPER_LIMIT]
    PCPHYSNOTETEXT,                  -- Notes [EHFND_NOTE_1333]
    PRIMARY KEY (MANDT, PHYSCHMLPARTICLESIZEUUID)
);

Learn More