HRFIO_D_FMKW_D

Transparent Table Application Table
103 Fields 1 CDS Views

Draft table for entity I_KW_HCM_ESSFAMILYMEMBERTP

HRFIO_D_FMKW_D is an SAP database table in S/4HANA. Draft table for entity I_KW_HCM_ESSFAMILYMEMBERTP. It contains 103 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_KW_HCM_ESSFamMbrDraft view_entity from BASIC My Family Members KW - Draft

Fields (103)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY hcmpersonnelnumber PERSNO Personnel No.
KEY hcmsubtype SUBTY Subtype
KEY hcmobjectidentification OBJPS Object ID
KEY hcmrecordislocked SPRPS Lock indicator
KEY enddate ENDDA End Date
KEY startdate BEGDA Start Date
KEY hcmsequentialnumber SEQNR IT record no.
KEY hcmdraftsequentialnumber HRFIO_PER_DRAFT_SEQ_NUMBER Sequential Number
lastchangeddate AEDAT Changed On
lastchangedbyuser AENAM Changed By
hcminfotyperecordhastext ITXEX Text exists
hcminfotyperecordscreenctrl ITBLD Screen control
hcmsubtypetext SBTTX Name
hcmetag SYSUUID_C32 UUID
hcmvaliditystartdate HRFIO_PER_VALID_FROM Valid from
hcmvalidityenddate HRFIO_PER_VALID_TO Valid to
hcmdefaultdate SYDATUM Current Date
hcmrecordisstoredindatabase ABAP_BOOLEAN Truth Value
hcmvaliditystartdatefieldctrl INT1 INT1
hcminfotypeversion abap.char
hcmcountryregiongrouping MOLGA HCM Local.
hcmfamilymembertypecode FAMSA Family Member
hcmfamilymemberbirthdate FGBDT Date of Birth
hcmfamilymembercntryofbrthcode HRFIO_COUNTRY_OF_BIRTH_ID Country/Region of Birth
hcmfamilymembernationalitycode NATSL Nationality
hcmfamilymembergendercode HRPAD_GENDER Gender
hcmfamilymemberfirstname PAD_VORNA First Name
hcmfamilymemberlastname PAD_NACHN Last Name
hcmfamilymemberplaceofbrthname PAD_GBORT Birthplace
hcmfamilymemberstateofbrthcode GBDEP State
hcmfammbrrefpersnworkagreement ERBNR Ref.Pers.No.
hcmfamilymemberbirthname PAD_NAME2 Name at Birth
hcmfamilymember2ndname PAD_NACH2 Second name
hcmfamilymembercompletename PAD_CNAME Full Name
hcminfotype INFOTYP Infotype
hcmnameeditingformatcode PNAFO Format
hcmfamilymembernameformatcode KNZNM Name Format
hcmfamilymemberinitials INITS Initials
hcmfamilymembernameprefixcode VORSW Name prefix
hcmfammember2ndnameprefixcode VORSW Name prefix
hcmfamilymemberothertitlecode NAMZU Other title
hcmfammbrrelshptochildcode KDSVH Rel/Child
hcmfammbrallwncauthzncode KDBSL Authoriztn
hcmfammbraddressofchildcode KDUTB Child
hcmfammbrchildallwncentlmnt KDGBR CA Entitle.
hcmfamilymemberchildtypecode KDART Child Type
hcmfamilymemberchildbonuscode KDZUG Child Bonuses
hcmfammbrchildallowancecode KDZUL Child Allowance
hcmfammbrsicknesscertauthzn KDVBE Sick.Cert.Auth.
hcmfamilymemberauthznnmbrcode ERMNR Authority No.
hcmfammbrsoclinsurnmbr1stprt AUSVL SI Number
hcmfammbrsoclinsurnmbr2ndprt AUSVG SI Number
hcmfammembereducationenddate FASDT Confirm. to
hcmfamilymemberschooltypecode FASAR Educ/Training
hcmfammbreducinstitutename FASIN Institute
hcmfamilymemberemployercode EGAGA ER Address
hcmfamilymember2ndnatltycode NATS2 Other nat.
hcmfamilymember3rdnatltycode NATS3 2nd/3rd nat.
hcmfamilymembertitlecode TITEL Title
hcmfammbrisemergencycontact PAD_EMRGN Emergency Contact
hcmfammbrarabicfirstname PKW_ARFNM Arabic First Name
hcmfammbrarabicsecondname PKW_ARSNM Arabic Second Name
hcmfammbrarabicthirdname PKW_ARTNM Arabic Third Name
hcmfammbrarabiclastname PKW_ARLNM Arabic Last Name
hcmfammbrunifiednumber PKW_VSNUM Unified Number
hcmfammbrunifiednumberexpdate PKW_VIEXP Unified Expiry Date
hcmfammbrresidencevisanumber PKW_IQNUM Visa Number
hcmfammbrresidencevisaexpdate PKW_IQEXP R. Visa Expiry Date
hcmfammbrcivilid PKW_DLNUM Civil ID
hcmfammbrcivilidexpdate PKW_DLEXP Civil ID Exp.
hcmfammbrunifiednumberissuedte PKW_VSISS Issue Date
hcmfammbrresidencevisaissuedte PKW_IQISS Issue Date
hcmfammbrcivilidissuedate PKW_DLISS Issue Date
hcmfammbrpassportnumber PKW_PSNUM Passport Number
hcmfammbrpassportissuedate PKW_PSISS Issue Date
hcmfammbrpassportexpdate PKW_PSEXP Passport Exp.
hcmfammbrdocumenttypecode PKW_DCTTP Document Type
hcmfammbrkwidnumber PKW_IDNUM ID Number
hcmfammbridissuedate PKW_IDISS ID Issue Date
hcmfammbridexpdate PKW_IDEXP ID Expiry Date
hcmfammbrsubtype10ishidden ABAP_BOOLEAN Truth Value
hcmfammbrsubtype11ishidden ABAP_BOOLEAN Truth Value
hcmfammbrsubtype12ishidden ABAP_BOOLEAN Truth Value
hcmfammbrsubtype13ishidden ABAP_BOOLEAN Truth Value
hcmfammbrsubtype14ishidden ABAP_BOOLEAN Truth Value
hcmfammbrsubtype15ishidden ABAP_BOOLEAN Truth Value
hcmfammbrsubtype2ishidden ABAP_BOOLEAN Truth Value
hcmfammbrsubtype3ishidden ABAP_BOOLEAN Truth Value
hcmfammbrsubtype4ishidden ABAP_BOOLEAN Truth Value
hcmfammbrsubtype5ishidden ABAP_BOOLEAN Truth Value
hcmfammbrsubtype6ishidden ABAP_BOOLEAN Truth Value
hcmfammbrsubtype7ishidden ABAP_BOOLEAN Truth Value
hcmfammbrsubtype8ishidden ABAP_BOOLEAN Truth Value
hcmfammbrsubtype9ishidden ABAP_BOOLEAN Truth Value
hcmfammbrsubtypekw01ishidden ABAP_BOOLEAN Truth Value
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Draft Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Draft Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID Admin. UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Draft Changes
component_to_be_changed abap.strg

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_KW_HCM_ESSFAMILYMEMBERTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE HRFIO_D_FMKW_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]
    HCMFAMILYMEMBERBIRTHDATE,        -- Date of Birth [FGBDT]
    HCMFAMILYMEMBERCNTRYOFBRTHCODE,  -- Country/Region of Birth [HRFIO_COUNTRY_OF_BIRTH_ID]
    HCMFAMILYMEMBERNATIONALITYCODE,  -- Nationality [NATSL]
    HCMFAMILYMEMBERGENDERCODE,       -- Gender [HRPAD_GENDER]
    HCMFAMILYMEMBERFIRSTNAME,        -- First Name [PAD_VORNA]
    HCMFAMILYMEMBERLASTNAME,         -- Last Name [PAD_NACHN]
    HCMFAMILYMEMBERPLACEOFBRTHNAME,  -- Birthplace [PAD_GBORT]
    HCMFAMILYMEMBERSTATEOFBRTHCODE,  -- State [GBDEP]
    HCMFAMMBRREFPERSNWORKAGREEMENT,  -- Ref.Pers.No. [ERBNR]
    HCMFAMILYMEMBERBIRTHNAME,        -- Name at Birth [PAD_NAME2]
    HCMFAMILYMEMBER2NDNAME,          -- Second name [PAD_NACH2]
    HCMFAMILYMEMBERCOMPLETENAME,     -- Full Name [PAD_CNAME]
    HCMINFOTYPE,                     -- Infotype [INFOTYP]
    HCMNAMEEDITINGFORMATCODE,        -- Format [PNAFO]
    HCMFAMILYMEMBERNAMEFORMATCODE,   -- Name Format [KNZNM]
    HCMFAMILYMEMBERINITIALS,         -- Initials [INITS]
    HCMFAMILYMEMBERNAMEPREFIXCODE,   -- Name prefix [VORSW]
    HCMFAMMEMBER2NDNAMEPREFIXCODE,   -- Name prefix [VORSW]
    HCMFAMILYMEMBEROTHERTITLECODE,   -- Other title [NAMZU]
    HCMFAMMBRRELSHPTOCHILDCODE,      -- Rel/Child [KDSVH]
    HCMFAMMBRALLWNCAUTHZNCODE,       -- Authoriztn [KDBSL]
    HCMFAMMBRADDRESSOFCHILDCODE,     -- Child [KDUTB]
    HCMFAMMBRCHILDALLWNCENTLMNT,     -- CA Entitle. [KDGBR]
    HCMFAMILYMEMBERCHILDTYPECODE,    -- Child Type [KDART]
    HCMFAMILYMEMBERCHILDBONUSCODE,   -- Child Bonuses [KDZUG]
    HCMFAMMBRCHILDALLOWANCECODE,     -- Child Allowance [KDZUL]
    HCMFAMMBRSICKNESSCERTAUTHZN,     -- Sick.Cert.Auth. [KDVBE]
    HCMFAMILYMEMBERAUTHZNNMBRCODE,   -- Authority No. [ERMNR]
    HCMFAMMBRSOCLINSURNMBR1STPRT,    -- SI Number [AUSVL]
    HCMFAMMBRSOCLINSURNMBR2NDPRT,    -- SI Number [AUSVG]
    HCMFAMMEMBEREDUCATIONENDDATE,    -- Confirm. to [FASDT]
    HCMFAMILYMEMBERSCHOOLTYPECODE,   -- Educ/Training [FASAR]
    HCMFAMMBREDUCINSTITUTENAME,      -- Institute [FASIN]
    HCMFAMILYMEMBEREMPLOYERCODE,     -- ER Address [EGAGA]
    HCMFAMILYMEMBER2NDNATLTYCODE,    -- Other nat. [NATS2]
    HCMFAMILYMEMBER3RDNATLTYCODE,    -- 2nd/3rd nat. [NATS3]
    HCMFAMILYMEMBERTITLECODE,        -- Title [TITEL]
    HCMFAMMBRISEMERGENCYCONTACT,     -- Emergency Contact [PAD_EMRGN]
    HCMFAMMBRARABICFIRSTNAME,        -- Arabic First Name [PKW_ARFNM]
    HCMFAMMBRARABICSECONDNAME,       -- Arabic Second Name [PKW_ARSNM]
    HCMFAMMBRARABICTHIRDNAME,        -- Arabic Third Name [PKW_ARTNM]
    HCMFAMMBRARABICLASTNAME,         -- Arabic Last Name [PKW_ARLNM]
    HCMFAMMBRUNIFIEDNUMBER,          -- Unified Number [PKW_VSNUM]
    HCMFAMMBRUNIFIEDNUMBEREXPDATE,   -- Unified Expiry Date [PKW_VIEXP]
    HCMFAMMBRRESIDENCEVISANUMBER,    -- Visa Number [PKW_IQNUM]
    HCMFAMMBRRESIDENCEVISAEXPDATE,   -- R. Visa Expiry Date [PKW_IQEXP]
    HCMFAMMBRCIVILID,                -- Civil ID [PKW_DLNUM]
    HCMFAMMBRCIVILIDEXPDATE,         -- Civil ID Exp. [PKW_DLEXP]
    HCMFAMMBRUNIFIEDNUMBERISSUEDTE,  -- Issue Date [PKW_VSISS]
    HCMFAMMBRRESIDENCEVISAISSUEDTE,  -- Issue Date [PKW_IQISS]
    HCMFAMMBRCIVILIDISSUEDATE,       -- Issue Date [PKW_DLISS]
    HCMFAMMBRPASSPORTNUMBER,         -- Passport Number [PKW_PSNUM]
    HCMFAMMBRPASSPORTISSUEDATE,      -- Issue Date [PKW_PSISS]
    HCMFAMMBRPASSPORTEXPDATE,        -- Passport Exp. [PKW_PSEXP]
    HCMFAMMBRDOCUMENTTYPECODE,       -- Document Type [PKW_DCTTP]
    HCMFAMMBRKWIDNUMBER,             -- ID Number [PKW_IDNUM]
    HCMFAMMBRIDISSUEDATE,            -- ID Issue Date [PKW_IDISS]
    HCMFAMMBRIDEXPDATE,              -- ID Expiry Date [PKW_IDEXP]
    HCMFAMMBRSUBTYPE10ISHIDDEN,      -- Truth Value [ABAP_BOOLEAN]
    HCMFAMMBRSUBTYPE11ISHIDDEN,      -- Truth Value [ABAP_BOOLEAN]
    HCMFAMMBRSUBTYPE12ISHIDDEN,      -- Truth Value [ABAP_BOOLEAN]
    HCMFAMMBRSUBTYPE13ISHIDDEN,      -- Truth Value [ABAP_BOOLEAN]
    HCMFAMMBRSUBTYPE14ISHIDDEN,      -- Truth Value [ABAP_BOOLEAN]
    HCMFAMMBRSUBTYPE15ISHIDDEN,      -- Truth Value [ABAP_BOOLEAN]
    HCMFAMMBRSUBTYPE2ISHIDDEN,       -- Truth Value [ABAP_BOOLEAN]
    HCMFAMMBRSUBTYPE3ISHIDDEN,       -- Truth Value [ABAP_BOOLEAN]
    HCMFAMMBRSUBTYPE4ISHIDDEN,       -- Truth Value [ABAP_BOOLEAN]
    HCMFAMMBRSUBTYPE5ISHIDDEN,       -- Truth Value [ABAP_BOOLEAN]
    HCMFAMMBRSUBTYPE6ISHIDDEN,       -- Truth Value [ABAP_BOOLEAN]
    HCMFAMMBRSUBTYPE7ISHIDDEN,       -- Truth Value [ABAP_BOOLEAN]
    HCMFAMMBRSUBTYPE8ISHIDDEN,       -- Truth Value [ABAP_BOOLEAN]
    HCMFAMMBRSUBTYPE9ISHIDDEN,       -- Truth Value [ABAP_BOOLEAN]
    HCMFAMMBRSUBTYPEKW01ISHIDDEN,    -- 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)
);

Learn More