EHFNDW_FAM_INHL

Transparent Table Application Table
11 Fields 2 CDS Views

I_CMPLRQRSLT1STAIDTP I_CMPLRQRSLT1STAIDINHALETP

EHFNDW_FAM_INHL is an SAP database table in S/4HANA. I_CMPLRQRSLT1STAIDTP I_CMPLRQRSLT1STAIDINHALETP. It contains 11 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
EHFNDV_INVALID_PHRS2008 view union_all
I_CmplRqRslt1stAidInhaleDrft view from BASIC First Aid Measures Inhalation Draft

Fields (11)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY cmplrqrslt1staidinhaleuuid ehfnd_fam_inhale_uuid Inhalation
cmplrqrsltuuid ehfnd_crr_uuid Compliance Assessment UUID
pcprptysequence ehfnd_property_sequence Sequence
firstaidinhalationadviceuuid ehfnd_fam_inhale_advice_uuid Advice
creationdatetime /bobf/creationdatetime Created On
createdbyuser /bobf/createdbyuser Created By
lastchangedatetime /bobf/lastchangedatetime Last Changed On
lastchangedbyuser /bobf/lastchangedbyuser Last Changed By
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_CMPLRQRSLT1STAIDTP I_CMPLRQRSLT1STAIDINHALETP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDW_FAM_INHL (
    MANDT,                         -- Client [mandt]
    CMPLRQRSLT1STAIDINHALEUUID,    -- Inhalation [ehfnd_fam_inhale_uuid]
    CMPLRQRSLTUUID,                -- Compliance Assessment UUID [ehfnd_crr_uuid]
    PCPRPTYSEQUENCE,               -- Sequence [ehfnd_property_sequence]
    FIRSTAIDINHALATIONADVICEUUID,  -- Advice [ehfnd_fam_inhale_advice_uuid]
    CREATIONDATETIME,              -- Created On [/bobf/creationdatetime]
    CREATEDBYUSER,                 -- Created By [/bobf/createdbyuser]
    LASTCHANGEDATETIME,            -- Last Changed On [/bobf/lastchangedatetime]
    LASTCHANGEDBYUSER,             -- Last Changed By [/bobf/lastchangedbyuser]
    ACTIVEUUID,                    -- Key [/bobf/uuid]
    HASACTIVEENTITY,               -- Has active [sdraft_has_active]
    PRIMARY KEY (MANDT, CMPLRQRSLT1STAIDINHALEUUID)
);

Learn More