HRFIO_D_FMOM_D
Draft table for entity I_OM_HCM_ESSFAMILYMEMBERTP
HRFIO_D_FMOM_D is an SAP database table in S/4HANA. Draft table for entity I_OM_HCM_ESSFAMILYMEMBERTP. It contains 119 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| R_OM_HCM_ESSFamMbrDraft | view_entity | from | BASIC | My Family Members OM - Draft |
Fields (119)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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 | ||||
| hcmfammbrpassportnumber | POM_PSPRT | Passport Number | ||||
| hcmfammbrpassportissuedate | POM_PSISS | Issue Date | ||||
| hcmfammbrpassportexpirydate | POM_PSEXP | Expire Date | ||||
| hcmfammbromvisanumber | POM_VISAN | Visa Number | ||||
| hcmfammbrvisaissuedate | POM_VSISS | Issue Date | ||||
| hcmfammbrvisaexpirydate | POM_VIEXP | Expiry Date | ||||
| hcmfammbrdocumenttypecode1 | POM_DCTTP | Document Type | ||||
| hcmfammbrdocumentnumber1 | POM_DCTNM | Number | ||||
| hcmfammbrdocnmbr1issuedate | POM_DOTIS | Document Issue Date | ||||
| hcmfammbrdocnmbr1expirydate | POM_DOTEX | Document Expiry Date | ||||
| hcmfammbrdocumenttypecode2 | POM_DCTTP | Document Type | ||||
| hcmfammbrdocumentnumber2 | POM_DCTNM | Number | ||||
| hcmfammbrdocnmbr2issuedate | POM_DOTIS | Document Issue Date | ||||
| hcmfammbrdocnmbr2expirydate | POM_DOTEX | Document Expiry Date | ||||
| hcmfammbrdocumenttypecode3 | POM_DCTTP | Document Type | ||||
| hcmfammbrdocumentnumber3 | POM_DCTNM | Number | ||||
| hcmfammbrdocnmbr3issuedate | POM_DOTIS | Document Issue Date | ||||
| hcmfammbrdocnmbr3expirydate | POM_DOTEX | Document Expiry Date | ||||
| hcmfammbrdocumenttypecode4 | POM_DCTTP | Document Type | ||||
| hcmfammbrdocumentnumber4 | POM_DCTNM | Number | ||||
| hcmfammbrdocnmbr4issuedate | POM_DOTIS | Document Issue Date | ||||
| hcmfammbrdocnmbr4expirydate | POM_DOTEX | Document Expiry Date | ||||
| hcmfammbrdocumenttypecode5 | POM_DCTTP | Document Type | ||||
| hcmfammbrdocumentnumber5 | POM_DCTNM | Number | ||||
| hcmfammbrdocnmbr5issuedate | POM_DOTIS | Document Issue Date | ||||
| hcmfammbrdocnmbr5expirydate | POM_DOTEX | Document Expiry Date | ||||
| hcmfammbrdocumenttypecode6 | POM_DCTTP | Document Type | ||||
| hcmfammbrdocumentnumber6 | POM_DCTNM | Number | ||||
| hcmfammbrdocnmbr6issuedate | POM_DOTIS | Document Issue Date | ||||
| hcmfammbrdocnmbr6expirydate | POM_DOTEX | Document Expiry Date | ||||
| hcmfammbrarabicfirstname | POM_ARFNM | First Name | ||||
| hcmfammbrarabicsecondname | POM_ARSNM | Second Name | ||||
| hcmfammbrarabicthirdname | POM_ARTNM | Third Name | ||||
| hcmfammbrarabiclastname | POM_ARLNM | Last Name | ||||
| hcmfammbriselgblforhlthins | POM_HICNT | Health Ins Cont | ||||
| hcmfammbrhlthinsprimpaidbycode | POM_HIPPB | Health Ins paid by | ||||
| 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 | ||||
| hcmfammbrsubtypeom01ishidden | ABAP_BOOLEAN | Truth Value | ||||
| hcmfammbrsubtypeom02ishidden | 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_OM_HCM_ESSFAMILYMEMBERTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE HRFIO_D_FMOM_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]
HCMFAMMBRPASSPORTNUMBER, -- Passport Number [POM_PSPRT]
HCMFAMMBRPASSPORTISSUEDATE, -- Issue Date [POM_PSISS]
HCMFAMMBRPASSPORTEXPIRYDATE, -- Expire Date [POM_PSEXP]
HCMFAMMBROMVISANUMBER, -- Visa Number [POM_VISAN]
HCMFAMMBRVISAISSUEDATE, -- Issue Date [POM_VSISS]
HCMFAMMBRVISAEXPIRYDATE, -- Expiry Date [POM_VIEXP]
HCMFAMMBRDOCUMENTTYPECODE1, -- Document Type [POM_DCTTP]
HCMFAMMBRDOCUMENTNUMBER1, -- Number [POM_DCTNM]
HCMFAMMBRDOCNMBR1ISSUEDATE, -- Document Issue Date [POM_DOTIS]
HCMFAMMBRDOCNMBR1EXPIRYDATE, -- Document Expiry Date [POM_DOTEX]
HCMFAMMBRDOCUMENTTYPECODE2, -- Document Type [POM_DCTTP]
HCMFAMMBRDOCUMENTNUMBER2, -- Number [POM_DCTNM]
HCMFAMMBRDOCNMBR2ISSUEDATE, -- Document Issue Date [POM_DOTIS]
HCMFAMMBRDOCNMBR2EXPIRYDATE, -- Document Expiry Date [POM_DOTEX]
HCMFAMMBRDOCUMENTTYPECODE3, -- Document Type [POM_DCTTP]
HCMFAMMBRDOCUMENTNUMBER3, -- Number [POM_DCTNM]
HCMFAMMBRDOCNMBR3ISSUEDATE, -- Document Issue Date [POM_DOTIS]
HCMFAMMBRDOCNMBR3EXPIRYDATE, -- Document Expiry Date [POM_DOTEX]
HCMFAMMBRDOCUMENTTYPECODE4, -- Document Type [POM_DCTTP]
HCMFAMMBRDOCUMENTNUMBER4, -- Number [POM_DCTNM]
HCMFAMMBRDOCNMBR4ISSUEDATE, -- Document Issue Date [POM_DOTIS]
HCMFAMMBRDOCNMBR4EXPIRYDATE, -- Document Expiry Date [POM_DOTEX]
HCMFAMMBRDOCUMENTTYPECODE5, -- Document Type [POM_DCTTP]
HCMFAMMBRDOCUMENTNUMBER5, -- Number [POM_DCTNM]
HCMFAMMBRDOCNMBR5ISSUEDATE, -- Document Issue Date [POM_DOTIS]
HCMFAMMBRDOCNMBR5EXPIRYDATE, -- Document Expiry Date [POM_DOTEX]
HCMFAMMBRDOCUMENTTYPECODE6, -- Document Type [POM_DCTTP]
HCMFAMMBRDOCUMENTNUMBER6, -- Number [POM_DCTNM]
HCMFAMMBRDOCNMBR6ISSUEDATE, -- Document Issue Date [POM_DOTIS]
HCMFAMMBRDOCNMBR6EXPIRYDATE, -- Document Expiry Date [POM_DOTEX]
HCMFAMMBRARABICFIRSTNAME, -- First Name [POM_ARFNM]
HCMFAMMBRARABICSECONDNAME, -- Second Name [POM_ARSNM]
HCMFAMMBRARABICTHIRDNAME, -- Third Name [POM_ARTNM]
HCMFAMMBRARABICLASTNAME, -- Last Name [POM_ARLNM]
HCMFAMMBRISELGBLFORHLTHINS, -- Health Ins Cont [POM_HICNT]
HCMFAMMBRHLTHINSPRIMPAIDBYCODE, -- Health Ins paid by [POM_HIPPB]
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]
HCMFAMMBRSUBTYPEOM01ISHIDDEN, -- Truth Value [ABAP_BOOLEAN]
HCMFAMMBRSUBTYPEOM02ISHIDDEN, -- 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
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA