HRFIO_D_FMTW_D

Transparent Table Application Table
62 Fields 1 CDS Views

Draft table for entity I_TW_HCM_ESSFAMILYMEMBERTP

HRFIO_D_FMTW_D is an SAP database table in S/4HANA. Draft table for entity I_TW_HCM_ESSFAMILYMEMBERTP. It contains 62 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_TW_HCM_ESSFamMbrDraft view_entity from BASIC My Family Members TW - Draft

Fields (62)

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
hcmfamilymemberlastname PAD_NACHN Last Name
hcmfamilymembernameformatcode KNZNM Name Format
hcmfamilymemberfirstname PAD_VORNA First Name
hcmfamilymemberbirthdate FGBDT Date of Birth
hcmfamilymemberplaceofbrthname PAD_GBORT Birthplace
hcmfamilymembernationalitycode NATSL Nationality
hcmfammbridnumber PTW_IDNUM ID Number
hcmfammbridnumbercheckerror PTW_IDCHK ID no. error
hcmfammbrhasnhifamily PTW_NHIFA NHI for family
hcmfammbrrelationshipcode PTW_FAREL Relationship
hcmfammbrnhistatuscode PTW_NHIST NHI status
hcmfammbrnhistatusreasoncode PTW_NHISR Status reason
hcmfammbrisnhiexemptbylaw PTW_NHIEX NHI exempt by law
hcmfammbrexemptionreasoncode PTW_EXRSN Exempt reason
hcmfammbrdisabilitygrade PTW_DISAB Disability grade
hcmfammbrislistedonreport PTW_LISTR Listed on report
hcmfammbrpostalcode PSTLZ_HR P.code/city
hcmfammbrcountrycode LAND1 Country/Reg.
hcmfammbrregioncode REGIO Region
hcmfammbrcountycode COUNC County Code
hcmfammbrvillagename PTW_VILLA Village
hcmfammbrneighborhoodname PTW_NEIGH Neighborhood
hcmfammbrtownname PTW_TOWN Town
hcmfammbrfulladdresstext PTW_ADRTW Full address
hcmfammbrphonenumber TELNR Telephone No.
hcmfamilymembergendercode HRPAD_GENDER Gender
hcmfammbrnhicontributefrom PTW_VAFRM Start Month of NHI
hcmfammbrnhicntrbtfromdate PTW_VADAT Premium from
hcmfammbrstartmonthofnhicntrbt PTW_VAFRM Start Month of NHI
hcmfammbrchinesename ALNAM Alternate Name
hcmfammbrsubtype1ishidden ABAP_BOOLEAN Truth Value
hcmfammbrsubtype2ishidden 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_TW_HCM_ESSFAMILYMEMBERTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE HRFIO_D_FMTW_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]
    HCMFAMILYMEMBERNAMEFORMATCODE,   -- Name Format [KNZNM]
    HCMFAMILYMEMBERFIRSTNAME,        -- First Name [PAD_VORNA]
    HCMFAMILYMEMBERBIRTHDATE,        -- Date of Birth [FGBDT]
    HCMFAMILYMEMBERPLACEOFBRTHNAME,  -- Birthplace [PAD_GBORT]
    HCMFAMILYMEMBERNATIONALITYCODE,  -- Nationality [NATSL]
    HCMFAMMBRIDNUMBER,               -- ID Number [PTW_IDNUM]
    HCMFAMMBRIDNUMBERCHECKERROR,     -- ID no. error [PTW_IDCHK]
    HCMFAMMBRHASNHIFAMILY,           -- NHI for family [PTW_NHIFA]
    HCMFAMMBRRELATIONSHIPCODE,       -- Relationship [PTW_FAREL]
    HCMFAMMBRNHISTATUSCODE,          -- NHI status [PTW_NHIST]
    HCMFAMMBRNHISTATUSREASONCODE,    -- Status reason [PTW_NHISR]
    HCMFAMMBRISNHIEXEMPTBYLAW,       -- NHI exempt by law [PTW_NHIEX]
    HCMFAMMBREXEMPTIONREASONCODE,    -- Exempt reason [PTW_EXRSN]
    HCMFAMMBRDISABILITYGRADE,        -- Disability grade [PTW_DISAB]
    HCMFAMMBRISLISTEDONREPORT,       -- Listed on report [PTW_LISTR]
    HCMFAMMBRPOSTALCODE,             -- P.code/city [PSTLZ_HR]
    HCMFAMMBRCOUNTRYCODE,            -- Country/Reg. [LAND1]
    HCMFAMMBRREGIONCODE,             -- Region [REGIO]
    HCMFAMMBRCOUNTYCODE,             -- County Code [COUNC]
    HCMFAMMBRVILLAGENAME,            -- Village [PTW_VILLA]
    HCMFAMMBRNEIGHBORHOODNAME,       -- Neighborhood [PTW_NEIGH]
    HCMFAMMBRTOWNNAME,               -- Town [PTW_TOWN]
    HCMFAMMBRFULLADDRESSTEXT,        -- Full address [PTW_ADRTW]
    HCMFAMMBRPHONENUMBER,            -- Telephone No. [TELNR]
    HCMFAMILYMEMBERGENDERCODE,       -- Gender [HRPAD_GENDER]
    HCMFAMMBRNHICONTRIBUTEFROM,      -- Start Month of NHI [PTW_VAFRM]
    HCMFAMMBRNHICNTRBTFROMDATE,      -- Premium from [PTW_VADAT]
    HCMFAMMBRSTARTMONTHOFNHICNTRBT,  -- Start Month of NHI [PTW_VAFRM]
    HCMFAMMBRCHINESENAME,            -- Alternate Name [ALNAM]
    HCMFAMMBRSUBTYPE1ISHIDDEN,       -- Truth Value [ABAP_BOOLEAN]
    HCMFAMMBRSUBTYPE2ISHIDDEN,       -- 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