EHFNDW_FAM_GINFO

Transparent Table Application Table
11 Fields 2 CDS Views

I_CMPLRQRSLT1STAIDTP I_CMPLRQRSLT1STAIDINFOTP

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

CDS Views using this table (2)

ViewTypeJoinVDMDescription
EHFNDV_INVALID_PHRS2008 view union_all Invalid Phrases in CE2008
I_CmplRqRslt1stAidInfoDrft view from BASIC First Aid Measures General Info Draft

Fields (11)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY cmplrqrslt1staidinfouuid ehfnd_fam_geninfo_uuid General Info
cmplrqrsltuuid ehfnd_crr_uuid Compliance Assessment UUID
pcprptysequence ehfnd_property_sequence Sequence
firstaidgeninfoadviceuuid ehfnd_fam_geninfo_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_CMPLRQRSLT1STAIDINFOTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDW_FAM_GINFO (
    MANDT,                      -- Client [mandt]
    CMPLRQRSLT1STAIDINFOUUID,   -- General Info [ehfnd_fam_geninfo_uuid]
    CMPLRQRSLTUUID,             -- Compliance Assessment UUID [ehfnd_crr_uuid]
    PCPRPTYSEQUENCE,            -- Sequence [ehfnd_property_sequence]
    FIRSTAIDGENINFOADVICEUUID,  -- Advice [ehfnd_fam_geninfo_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, CMPLRQRSLT1STAIDINFOUUID)
);

Learn More