HRFIO_D_FMMY_D

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.

-- Draft table for entity I_MY_HCM_ESSFAMILYMEMBERTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE HRFIO_D_FMMY_D (
    MANDT,                           -- Client [MANDT]
    HCMPERSONNELNUMBER,              -- Personnel No. [PERSNO]
    HCMSUBTYPE,                      -- Subtype [SUBTY]
    HCMOBJECTIDENTIFICATION,         -- Object ID [OBJPS]
    HCMRECORDISLOCKED,               -- Lock indicator [SPRPS]
    ENDDATE,                         -- End Date [ENDDA]
    STARTDATE,                       -- Start Date [BEGDA]
    HCMSEQUENTIALNUMBER,             -- IT record no. [SEQNR]
    HCMDRAFTSEQUENTIALNUMBER,        -- Sequential Number [HRFIO_PER_DRAFT_SEQ_NUMBER]
    LASTCHANGEDDATE,                 -- Changed On [AEDAT]
    LASTCHANGEDBYUSER,               -- Changed By [AENAM]
    HCMINFOTYPERECORDHASTEXT,        -- Text exists [ITXEX]
    HCMINFOTYPERECORDSCREENCTRL,     -- Screen control [ITBLD]
    HCMSUBTYPETEXT,                  -- Name [SBTTX]
    HCMETAG,                         -- UUID [SYSUUID_C32]
    HCMVALIDITYSTARTDATE,            -- Valid from [HRFIO_PER_VALID_FROM]
    HCMVALIDITYENDDATE,              -- Valid to [HRFIO_PER_VALID_TO]
    HCMDEFAULTDATE,                  -- Current Date [SYDATUM]
    HCMRECORDISSTOREDINDATABASE,     -- Truth Value [ABAP_BOOLEAN]
    HCMVALIDITYSTARTDATEFIELDCTRL,   -- INT1 [INT1]
    HCMINFOTYPEVERSION,              -- abap.char
    HCMCOUNTRYREGIONGROUPING,        -- HCM Local. [MOLGA]
    HCMFAMILYMEMBERTYPECODE,         -- Family Member [FAMSA]
    HCMFAMILYMEMBERLASTNAME,         -- Last Name [PAD_NACHN]
    HCMFAMILYMEMBERBIRTHNAME,        -- Name at Birth [PAD_NAME2]
    HCMFAMILYMEMBERFIRSTNAME,        -- First Name [PAD_VORNA]
    HCMFAMILYMEMBERINITIALS,         -- Initials [INITS]
    HCMFAMILYMEMBEROTHERTITLECODE,   -- Other title [NAMZU]
    HCMFAMILYMEMBERNAMEPREFIXCODE,   -- Name prefix [VORSW]
    HCMFAMMEMBER2NDNAMEPREFIXCODE,   -- Name prefix [VORSW]
    HCMFAMILYMEMBERBIRTHDATE,        -- Date of Birth [FGBDT]
    HCMFAMILYMEMBERPLACEOFBRTHNAME,  -- Birthplace [PAD_GBORT]
    HCMFAMILYMEMBERCNTRYOFBRTHCODE,  -- Country/Region of Birth [HRFIO_COUNTRY_OF_BIRTH_ID]
    HCMFAMILYMEMBERNATIONALITYCODE,  -- Nationality [NATSL]
    HCMFAMILYMEMBER2NDNATLTYCODE,    -- Other nat. [NATS2]
    HCMFAMILYMEMBER3RDNATLTYCODE,    -- 2nd/3rd nat. [NATS3]
    HCMFAMILYMEMBERGENDERCODE,       -- Gender [HRPAD_GENDER]
    HCMFAMILYMEMBERNAMEFORMATCODE,   -- Name Format [KNZNM]
    HCMFAMMBRIDENTIFICATIONCARDID,   -- IC Number [ICNUM]
    HCMFAMMBRPASSPORTNUMBER,         -- Passport Number [P14_PASNR]
    HCMFAMMBRINCOMETAXNUMBER,        -- EE Tax number [P14_TNOEE]
    HCMFAMMBRTAXNUMBER,              -- Tax No Prefix [P14_TXPFX]
    HCMFAMMBRTAXREFNUMBER,           -- Tax Ref. No. [P14_REFNO]
    HCMFAMMBRTAXNOCHECKDIGIT,        -- Check digit [P14_CHKDI]
    HCMFAMMBRVALUEFORWIFECODE,       -- Wife Code [P14_WIFEI]
    HCMFAMMBRSPOUSETAXOFFICECODE,    -- Spouse tax off [P14_STXOF]
    HCMFAMMBRSPOUSEEMPLSTSCODE,      -- Spouse employed [P14_SEMPS]
    HCMFAMMBRJOBTITLETEXT,           -- Job Title [STLTX]
    HCMFAMMBRSPOUSEEMPLOYERNAME,     -- Spouse employer [P14_SPEMR]
    HCMFAMILYMEMBERCOMPLETENAME,     -- Full Name [PAD_CNAME]
    HCMFAMMBRREFPERSNWORKAGREEMENT,  -- Ref.Pers.No. [ERBNR]
    HCMFAMMBRRELSHPTOCHILDCODE,      -- Rel/Child [KDSVH]
    HCMFAMMBRBRTHCERTIFICATENUMBER,  -- Birth cert. Id [P14_BTHID]
    HCMFAMILYMEMBERSCHOOLTYPECODE,   -- Educ/Training [FASAR]
    HCMFAMMBRHASCHILDHANDICAP,       -- Handicap Chld. [P14_HANCH]
    HCMFAMMBRHASCHILDCUSTODY,        -- Child custody [P14_CHCUS]
    HCMFAMMBRMARITALSTATUSCODE,      -- Married [P14_MARST]
    HCMFAMMBRHASHALFCHILDALLOWANCE,  -- Half Child All. [P14_CHHAL]
    HCMFAMMBRCONAME,                 -- c/o [CONAM]
    HCMFAMMBRSTREET,                 -- Street/House [STRAS]
    HCMFAMMBR2NDADDRESSLINE,         -- 2nd add.line [LOCAT]
    HCMFAMMBRPOSTALCODE,             -- P.code/city [PSTLZ_HR]
    HCMFAMMBRCITYNAME,               -- City [ORT01]
    HCMFAMMBRDISTRICTNAME,           -- District [ORT02]
    HCMFAMMBRREGIONCODE,             -- Region [REGIO]
    HCMFAMMBRCOUNTRYCODE,            -- Country/Reg. [LAND1]
    HCMFAMMBRPHONENUMBER,            -- Telephone No. [TELNR]
    HCMFAMMBRCOMMTYPECODE1,          -- Type [COMKY]
    HCMFAMMBRCOMMNUMBER1,            -- Number [COMNR]
    HCMFAMMBRCOMMTYPECODE2,          -- Type [COMKY]
    HCMFAMMBRCOMMNUMBER2,            -- Number [COMNR]
    HCMFAMMBRCOMMTYPECODE3,          -- Type [COMKY]
    HCMFAMMBRCOMMNUMBER3,            -- Number [COMNR]
    HCMFAMMBRCOMMTYPECODE4,          -- Type [COMKY]
    HCMFAMMBRCOMMNUMBER4,            -- Number [COMNR]
    HCMFAMMBRSUBTYPE1ISHIDDEN,       -- Truth Value [ABAP_BOOLEAN]
    HCMFAMMBRSUBTYPE2ISHIDDEN,       -- Truth Value [ABAP_BOOLEAN]
    HCMFAMMBRSUBTYPE8ISHIDDEN,       -- Truth Value [ABAP_BOOLEAN]
    HCMFAMMBRSUBTYPEMY01ISHIDDEN,    -- Truth Value [ABAP_BOOLEAN]
    DRAFTENTITYCREATIONDATETIME,     -- Draft Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Draft Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- Admin. UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,        -- Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                 -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,               -- Draft Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    COMPONENT_TO_BE_CHANGED,         -- abap.strg
    PRIMARY KEY (MANDT, HCMPERSONNELNUMBER, HCMSUBTYPE, HCMOBJECTIDENTIFICATION, HCMRECORDISLOCKED, ENDDATE, STARTDATE, HCMSEQUENTIALNUMBER, HCMDRAFTSEQUENTIALNUMBER)
);