HRFIO_D_FMJP_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_JP_HCM_ESSFAMILYMEMBERTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE HRFIO_D_FMJP_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]
    HCMMASTERDATACHANGEREASON,       -- Change Reason [PREAS]
    HCMFAMILYMEMBERTYPECODE,         -- Family Member [FAMSA]
    HCMFAMILYMEMBERKANJILASTNAME,    -- Last Name [PAD_NACHN]
    HCMFAMILYMEMBERKANJIFIRSTNAME,   -- First Name [PAD_VORNA]
    HCMFAMMBRKATAKANALASTNAME,       -- Last name (Katakana) [P22J_PLNMK]
    HCMFAMMBRKATAKANAFIRSTNAME,      -- 1st name Katakana [P22J_PFNMK]
    HCMFAMILYMEMBERLASTNAME,         -- Last Name [PAD_NACHN]
    HCMFAMILYMEMBERFIRSTNAME,        -- First Name [PAD_VORNA]
    HCMFAMILYMEMBERNAMEFORMATCODE,   -- Name Format [KNZNM]
    HCMFAMILYMEMBERGENDERCODE,       -- Gender [HRPAD_GENDER]
    HCMFAMILYMEMBERBIRTHDATE,        -- Date of Birth [FGBDT]
    HCMFAMILYMEMBERCNTRYOFBRTHCODE,  -- Country/Region of Birth [HRFIO_COUNTRY_OF_BIRTH_ID]
    HCMFAMILYMEMBERSTATEOFBRTHCODE,  -- State [GBDEP]
    HCMFAMILYMEMBERPLACEOFBRTHNAME,  -- Birthplace [PAD_GBORT]
    HCMFAMILYMEMBERCHILDTYPECODE,    -- Child Type [KDART]
    HCMFAMILYMEMBERNATIONALITYCODE,  -- Nationality [NATSL]
    HCMFAMMBRDEPTDEDUCTIONCODE,      -- Dependent [P22J_DEPEN]
    HCMFAMMBRAGEGROUPDEDUCTIONCODE,  -- Ded.for age grp. FM [P22J_OLPE2]
    HCMFAMMBRDISABLEDDEDUCTIONCODE,  -- Ded.for disab. FM [P22J_DISA2]
    HCMFAMILYMEMBERISDECEASED,       -- Death flag [P22J_DEATH]
    HCMFAMMBRDEPDNTFORYEARENDADJMT,  -- Ind (dep.for YEA) [P22J_DP5ID]
    HCMFAMMBRFAMILYALLOWANCE,        -- Family all. [P22J_DPFAL]
    HCMFAMMBRDEPDNTHLTHINSUR,        -- Health ins. ind. [P22J_DPHID]
    HCMFAMMBRLIVEWITHDEDUCTION,      -- Ded.for live with [P22J_LIWTH]
    HCMFAMMBRNONRESIDENTCODE,        -- Non-resident [PJP_DEP_NONRE]
    HCMFAMMBRDEPDNTNURSEINSUR,       -- Nursin ins. ind. [P22J_DPNID]
    HCMFAMMBRCASUBTYPE,              -- Subtype [SUBTY]
    HCMFAMMBRCAOBJID,                -- Object ID [OBJPS]
    HCMFAMMBRCASTARTDATE,            -- Start Date [BEGDA]
    HCMFAMMBRCAENDDATE,              -- End Date [ENDDA]
    HCMFAMCASEQNUMBER,               -- IT record no. [SEQNR]
    HCMFAMMBRSUBTYPE,                -- Subtype [SUBTY]
    HCMFAMMBROBJID,                  -- Object ID [OBJPS]
    HCMFAMMBRCHANGEREASONTEXT,       -- Change Reason [P22J_CHGRS]
    HCMFAMMBRDISABILITYDESCTEXT,     -- Disability Content [P22J_CFDPE]
    HCMFAMMBRDISABILITYREASONTEXT,   -- Disability Reason [P22J_RFDPE]
    HCMFAMMBROCCUPATIONTEXT,         -- Job Title [STLTX]
    HCMFAMMBRDEPDNTTOTINCAMOUNT,     -- Income of Depend [P22J_SUPIN]
    HCMFAMMBRPENSIONNUMBER,          -- Insurance no [P22J_SIINR]
    HCMFAMMBRKANJIMIDDLENAME,        -- Mdl name (Kanji) [P22J_MIDKJ]
    HCMFAMMBRKATAKANAMIDDLENAME,     -- Mdl name (Kana) [P22J_MIDKK]
    HCMFAMMBRROMAJIMIDDLENAME,       -- Middle name [PAD_MIDNM]
    HCMFAMMBRTAXISCONFIRMED,         -- Checkbox [P22J_CHECK]
    HCMFAMMBRPHONETYPECODE,          -- Tel Type [PJP_TELTP]
    HCMFAMMBRPHONENUMBER,            -- Telephone No. [TELNR]
    HCMFAMMBRADJUSTDEDUCTTARGET,     -- TRUE [BOOLE_D]
    HCMFAMMBRDEPESTTOTINCAMOUNT,     -- Income of Depend [P22J_SUPIN]
    HCMFAMMBRFACTLIVEHOODTEXT,       -- Live with Indicator [P22J_DP4ID_TXT]
    HCMFAMMBRINSCONFIRMFLAG,         -- SI Stat for Rp. [P22J_SIID2]
    HCMFAMMBROVERSEAEXCEPTIONCODE,   -- Except. [PJP_DPEXP]
    HCMFAMMBRCHANGEREASONCODE,       -- Change Reason [PREAS]
    HCMFAMMBRHASRETIREINCOMEFORRES,  -- Ret. Income Res. [P22J_DPRID]
    CURRENCY,                        -- Currency [WAERS]
    HCMFAMMBRDEPENDENTADDRESSTEXT,   -- Address [P22_UI_ADDR]
    HCMFAMMBROTHEREARNERNAME,        -- Other Earner Name [P22_UI_EARNM]
    HCMFAMMBRSUBTYPE1ISHIDDEN,       -- Truth Value [ABAP_BOOLEAN]
    HCMFAMMBRSUBTYPE2ISHIDDEN,       -- Truth Value [ABAP_BOOLEAN]
    HCMFAMMBRHASFLAG1,               -- Indicator [FLAG]
    HCMFAMMBRHASFLAG2,               -- Indicator [FLAG]
    HCMFAMMBRHASFLAG3,               -- Indicator [FLAG]
    HCMFAMMBRHASFLAG4,               -- Indicator [FLAG]
    HCMFAMMBRHASFLAG5,               -- HI Qualif. Cert [P22_SITODE]
    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)
);