HRFIO_D_FMSG_D

Transparent Table Application Table
79 Fields 1 CDS Views

Draft table for entity I_SG_HCM_ESSFAMILYMEMBERTP

HRFIO_D_FMSG_D is an SAP database table in S/4HANA. Draft table for entity I_SG_HCM_ESSFAMILYMEMBERTP. It contains 79 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_SG_HCM_ESSFamMbrDraft view_entity from BASIC My Family Members SG - Draft

Fields (79)

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
hcmfamilymemberbirthname PAD_NAME2 Name at Birth
hcmfamilymemberfirstname PAD_VORNA First Name
hcmfamilymemberinitials INITS Initials
hcmfamilymemberothertitlecode NAMZU Other title
hcmfamilymembernameprefixcode VORSW Name prefix
hcmfammember2ndnameprefixcode VORSW Name prefix
hcmfamilymemberbirthdate FGBDT Date of Birth
hcmfamilymemberplaceofbrthname PAD_GBORT Birthplace
hcmfamilymembercntryofbrthcode HRFIO_COUNTRY_OF_BIRTH_ID Country/Region of Birth
hcmfamilymembernationalitycode NATSL Nationality
hcmfamilymember2ndnatltycode NATS2 Other nat.
hcmfamilymember3rdnatltycode NATS3 2nd/3rd nat.
hcmfamilymembergendercode HRPAD_GENDER Gender
hcmfammbrnationalid PRDNI ID number
hcmfammbrmodifierforpersid PIDMO Pers.ID mod.
hcmfammbrtaxid P25_TAXID Tax ID
hcmfammbrresidencytypecode PMRES Residency typ
hcmfammbrethnicorigincode RACKY Ethnic origin
hcmfammbrschoolstreet STRAS Street/House
hcmfammbrschoolphonenumber TELNR Telephone No.
hcmfammbrschoolhousenumber STRAS Street/House
hcmfammbrschoolcityname ORT01 City
hcmfammbrschoolpostalcode PSTLZ Postal Code
hcmfammbrschoolcountrycode LAND1 Country/Reg.
hcmfammbrschoolregioncode REGIO Region
hcmfammbremployername P25_ERNAM Employer Name
hcmfammbrdesignationname P25_DESGN Designation
hcmfammbrstreet STRAS Street/House
hcmfammbrhousenumber LOCAT 2nd add.line
hcmfammbrcityname ORT01 City
hcmfammbrpostalcode PSTLZ Postal Code
hcmfammbrschoolname P25_SNAME School / Hospital
hcmfammbrspouseemplstscode XFELD Checkbox
hcmfammbrconfinementnumber P25M_CONFN Confinement Number
hcmfammbrbrthcertificatenumber P25M_CLCNO Child Birth Cert. No
hcmfamilymemberchildtypecode P25M_CLDTY Child Type
hcm_fammbrhascclstrtfromyrbrth P25_SCCLB CCL Start from Birth
hcmfammbrhasshrdparentalleave P25_GPSPL Shared Parental Leav
hcmfammbrshrdparentalleavedays P25_QTSPL SPL Quota(days)
hcmfammbrhasccslvalidity P25_FCCSL CCSL validity
hcmfammbrisemergencycontact PAD_EMRGN Emergency Contact
hcmfammbrcountrycode LAND1 Country/Reg.
hcmfammbrregioncode REGIO Region
hcm_fammbrcclentlinyrofbrth P25_SYCCL CCL Quota(days)
hcmfammbrphonenumber TELNR Telephone No.
hcmfammbrincismorethan4000 P25_SPAIM Income > threshold
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_SG_HCM_ESSFAMILYMEMBERTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE HRFIO_D_FMSG_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]
    HCMFAMMBRNATIONALID,             -- ID number [PRDNI]
    HCMFAMMBRMODIFIERFORPERSID,      -- Pers.ID mod. [PIDMO]
    HCMFAMMBRTAXID,                  -- Tax ID [P25_TAXID]
    HCMFAMMBRRESIDENCYTYPECODE,      -- Residency typ [PMRES]
    HCMFAMMBRETHNICORIGINCODE,       -- Ethnic origin [RACKY]
    HCMFAMMBRSCHOOLSTREET,           -- Street/House [STRAS]
    HCMFAMMBRSCHOOLPHONENUMBER,      -- Telephone No. [TELNR]
    HCMFAMMBRSCHOOLHOUSENUMBER,      -- Street/House [STRAS]
    HCMFAMMBRSCHOOLCITYNAME,         -- City [ORT01]
    HCMFAMMBRSCHOOLPOSTALCODE,       -- Postal Code [PSTLZ]
    HCMFAMMBRSCHOOLCOUNTRYCODE,      -- Country/Reg. [LAND1]
    HCMFAMMBRSCHOOLREGIONCODE,       -- Region [REGIO]
    HCMFAMMBREMPLOYERNAME,           -- Employer Name [P25_ERNAM]
    HCMFAMMBRDESIGNATIONNAME,        -- Designation [P25_DESGN]
    HCMFAMMBRSTREET,                 -- Street/House [STRAS]
    HCMFAMMBRHOUSENUMBER,            -- 2nd add.line [LOCAT]
    HCMFAMMBRCITYNAME,               -- City [ORT01]
    HCMFAMMBRPOSTALCODE,             -- Postal Code [PSTLZ]
    HCMFAMMBRSCHOOLNAME,             -- School / Hospital [P25_SNAME]
    HCMFAMMBRSPOUSEEMPLSTSCODE,      -- Checkbox [XFELD]
    HCMFAMMBRCONFINEMENTNUMBER,      -- Confinement Number [P25M_CONFN]
    HCMFAMMBRBRTHCERTIFICATENUMBER,  -- Child Birth Cert. No [P25M_CLCNO]
    HCMFAMILYMEMBERCHILDTYPECODE,    -- Child Type [P25M_CLDTY]
    HCM_FAMMBRHASCCLSTRTFROMYRBRTH,  -- CCL Start from Birth [P25_SCCLB]
    HCMFAMMBRHASSHRDPARENTALLEAVE,   -- Shared Parental Leav [P25_GPSPL]
    HCMFAMMBRSHRDPARENTALLEAVEDAYS,  -- SPL Quota(days) [P25_QTSPL]
    HCMFAMMBRHASCCSLVALIDITY,        -- CCSL validity [P25_FCCSL]
    HCMFAMMBRISEMERGENCYCONTACT,     -- Emergency Contact [PAD_EMRGN]
    HCMFAMMBRCOUNTRYCODE,            -- Country/Reg. [LAND1]
    HCMFAMMBRREGIONCODE,             -- Region [REGIO]
    HCM_FAMMBRCCLENTLINYROFBRTH,     -- CCL Quota(days) [P25_SYCCL]
    HCMFAMMBRPHONENUMBER,            -- Telephone No. [TELNR]
    HCMFAMMBRINCISMORETHAN4000,      -- Income > threshold [P25_SPAIM]
    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