HRFIO_D_FMAE_D
Draft table for entity I_AE_HCM_ESSFAMILYMEMBERTP
HRFIO_D_FMAE_D is an SAP database table in S/4HANA. Draft table for entity I_AE_HCM_ESSFAMILYMEMBERTP. It contains 100 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| R_AE_HCM_ESSFamMbrDraft | view_entity | from | BASIC | My Family Members AE - Draft |
Fields (100)
| 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 | ||||
| hcmfamilymemberlastname | PAD_NACHN | Last Name | ||||
| hcmfamilymemberbirthname | PAD_NAME2 | Name at Birth | ||||
| hcmfamilymemberfirstname | PAD_VORNA | First Name | ||||
| hcmfamilymember2ndname | PAD_NACH2 | Second 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 | ||||
| hcmfammbrisemployed | PAE_EMPLM | Employed | ||||
| hcmfammbremployername | PAE_EMPLR | Employer Name | ||||
| hcmfammbremploymentdate | PAE_EMPDT | Employment Date | ||||
| hcmfammbrhasacmdtnentlmnt | PAE_ACCEN | Accom. Entitlement | ||||
| hcmfammbrislvepassageapplbl | PAE_LPAPD | Leave Passage | ||||
| hcmfammbrlegalnomineecode | PAE_LEGNO | Legal Nominee | ||||
| hcmfammbrarabicfirstname | PAE_ARFNM | Arabic First Name | ||||
| hcmfammbrarabicsecondname | PAE_ARSNM | Arabic Second Name | ||||
| hcmfammbrarabicthirdname | PAE_ARTNM | Arabic Third Name | ||||
| hcmfammbrarabiclastname | PAE_ARLNM | Arabic Last Name | ||||
| hcmfammbracademicdegree | PAE_ADCDG | Academic Degree | ||||
| hcmfammbrspecialization | PAE_SPECL | Specialization | ||||
| hcmfammbrspousepersnoinsameco | PAE_SPOID | Spouse ID | ||||
| hcmfammbrpassportnumber | PAE_PSPRT | Passport Number | ||||
| hcmfammbrpassportissuedate | PAE_PSISS | Issue Date | ||||
| hcmfammbrpassportexpirydate | PAE_PSEXP | Expire Date | ||||
| hcmfammbraevisanumber | PAE_VISAN | Visa Number | ||||
| hcmfammbrvisaissuedate | PAE_VSISS | Issue Date | ||||
| hcmfammbrvisaexpirydate | PAE_VIEXP | Expire Date | ||||
| hcmfammbrdocumenttypecode | PAE_DCTTP | Document Type | ||||
| hcmfammbrdocumentnumber1 | PAE_DCTNM | Number | ||||
| hcmfammbrdocumentissuedate | PAE_DOTIS | Document Issue Date | ||||
| hcmfammbrdocumentexpirydate | PAE_DOTEX | Document Expiry Date | ||||
| hcmfammbr2nddocumenttypecode | PAE_DCTTP | Document Type | ||||
| hcmfammbr2nddocumentnumber | PAE_DCTNM | Number | ||||
| hcmfammbr2nddocumentissuedate | PAE_DOTIS | Document Issue Date | ||||
| hcmfammbr2nddocumentexpirydate | PAE_DOTEX | Document Expiry Date | ||||
| hcmfammbr3rddocumenttypecode | PAE_DCTTP | Document Type | ||||
| hcmfammbr3rddocumentnumber | PAE_DCTNM | Number | ||||
| hcmfammbr3rddocumentissuedate | PAE_DOTIS | Document Issue Date | ||||
| hcmfammbr3rddocumentexpirydate | PAE_DOTEX | Document Expiry Date | ||||
| hcmfammbr4thdocumenttypecode | PAE_DCTTP | Document Type | ||||
| hcmfammbr4thdocumentnumber | PAE_DCTNM | Number | ||||
| hcmfammbr4thdocumentissuedate | PAE_DOTIS | Document Issue Date | ||||
| hcmfammbr4thdocumentexpirydate | PAE_DOTEX | Document Expiry Date | ||||
| hcmfammbr5thdocumenttypecode | PAE_DCTTP | Document Type | ||||
| hcmfammbr5thdocumentnumber | PAE_DCTNM | Number | ||||
| hcmfammbr5thdocumentissuedate | PAE_DOTIS | Document Issue Date | ||||
| hcmfammbr5thdocumentexpirydate | PAE_DOTEX | Document Expiry Date | ||||
| hcmfammbr6thdocumenttypecode | PAE_DCTTP | Document Type | ||||
| hcmfammbr6thdocumentnumber | PAE_DCTNM | Number | ||||
| hcmfammbr6thdocumentissuedate | PAE_DOTIS | Document Issue Date | ||||
| hcmfammbr6thdocumentexpirydate | PAE_DOTEX | Document Expiry Date | ||||
| hcmfammbr7thdocumenttypecode | PAE_DCTTP | Document Type | ||||
| hcmfammbr7thdocumentnumber | PAE_DCTNM | Number | ||||
| hcmfammbr7thdocumentissuedate | PAE_DOTIS | Document Issue Date | ||||
| hcmfammbr7thdocumentexpirydate | PAE_DOTEX | Document Expiry Date | ||||
| hcmfammbr8thdocumenttypecode | PAE_DCTTP | Document Type | ||||
| hcmfammbr8thdocumentnumber | PAE_DCTNM | Number | ||||
| hcmfammbr8thdocumentissuedate | PAE_DOTIS | Document Issue Date | ||||
| hcmfammbr8thdocumentexpirydate | PAE_DOTEX | Document Expiry Date | ||||
| hcmfammbrsubtype2ishidden | ABAP_BOOLEAN | Truth Value | ||||
| hcmfammbrsubtypeae01ishidden | ABAP_BOOLEAN | Truth Value | ||||
| hcmfammbrsubtypeae02ishidden | ABAP_BOOLEAN | Truth Value | ||||
| hcmfammbrsubtypeae04ishidden | 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_AE_HCM_ESSFAMILYMEMBERTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE HRFIO_D_FMAE_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]
HCMFAMILYMEMBER2NDNAME, -- Second name [PAD_NACH2]
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]
HCMFAMMBRISEMPLOYED, -- Employed [PAE_EMPLM]
HCMFAMMBREMPLOYERNAME, -- Employer Name [PAE_EMPLR]
HCMFAMMBREMPLOYMENTDATE, -- Employment Date [PAE_EMPDT]
HCMFAMMBRHASACMDTNENTLMNT, -- Accom. Entitlement [PAE_ACCEN]
HCMFAMMBRISLVEPASSAGEAPPLBL, -- Leave Passage [PAE_LPAPD]
HCMFAMMBRLEGALNOMINEECODE, -- Legal Nominee [PAE_LEGNO]
HCMFAMMBRARABICFIRSTNAME, -- Arabic First Name [PAE_ARFNM]
HCMFAMMBRARABICSECONDNAME, -- Arabic Second Name [PAE_ARSNM]
HCMFAMMBRARABICTHIRDNAME, -- Arabic Third Name [PAE_ARTNM]
HCMFAMMBRARABICLASTNAME, -- Arabic Last Name [PAE_ARLNM]
HCMFAMMBRACADEMICDEGREE, -- Academic Degree [PAE_ADCDG]
HCMFAMMBRSPECIALIZATION, -- Specialization [PAE_SPECL]
HCMFAMMBRSPOUSEPERSNOINSAMECO, -- Spouse ID [PAE_SPOID]
HCMFAMMBRPASSPORTNUMBER, -- Passport Number [PAE_PSPRT]
HCMFAMMBRPASSPORTISSUEDATE, -- Issue Date [PAE_PSISS]
HCMFAMMBRPASSPORTEXPIRYDATE, -- Expire Date [PAE_PSEXP]
HCMFAMMBRAEVISANUMBER, -- Visa Number [PAE_VISAN]
HCMFAMMBRVISAISSUEDATE, -- Issue Date [PAE_VSISS]
HCMFAMMBRVISAEXPIRYDATE, -- Expire Date [PAE_VIEXP]
HCMFAMMBRDOCUMENTTYPECODE, -- Document Type [PAE_DCTTP]
HCMFAMMBRDOCUMENTNUMBER1, -- Number [PAE_DCTNM]
HCMFAMMBRDOCUMENTISSUEDATE, -- Document Issue Date [PAE_DOTIS]
HCMFAMMBRDOCUMENTEXPIRYDATE, -- Document Expiry Date [PAE_DOTEX]
HCMFAMMBR2NDDOCUMENTTYPECODE, -- Document Type [PAE_DCTTP]
HCMFAMMBR2NDDOCUMENTNUMBER, -- Number [PAE_DCTNM]
HCMFAMMBR2NDDOCUMENTISSUEDATE, -- Document Issue Date [PAE_DOTIS]
HCMFAMMBR2NDDOCUMENTEXPIRYDATE, -- Document Expiry Date [PAE_DOTEX]
HCMFAMMBR3RDDOCUMENTTYPECODE, -- Document Type [PAE_DCTTP]
HCMFAMMBR3RDDOCUMENTNUMBER, -- Number [PAE_DCTNM]
HCMFAMMBR3RDDOCUMENTISSUEDATE, -- Document Issue Date [PAE_DOTIS]
HCMFAMMBR3RDDOCUMENTEXPIRYDATE, -- Document Expiry Date [PAE_DOTEX]
HCMFAMMBR4THDOCUMENTTYPECODE, -- Document Type [PAE_DCTTP]
HCMFAMMBR4THDOCUMENTNUMBER, -- Number [PAE_DCTNM]
HCMFAMMBR4THDOCUMENTISSUEDATE, -- Document Issue Date [PAE_DOTIS]
HCMFAMMBR4THDOCUMENTEXPIRYDATE, -- Document Expiry Date [PAE_DOTEX]
HCMFAMMBR5THDOCUMENTTYPECODE, -- Document Type [PAE_DCTTP]
HCMFAMMBR5THDOCUMENTNUMBER, -- Number [PAE_DCTNM]
HCMFAMMBR5THDOCUMENTISSUEDATE, -- Document Issue Date [PAE_DOTIS]
HCMFAMMBR5THDOCUMENTEXPIRYDATE, -- Document Expiry Date [PAE_DOTEX]
HCMFAMMBR6THDOCUMENTTYPECODE, -- Document Type [PAE_DCTTP]
HCMFAMMBR6THDOCUMENTNUMBER, -- Number [PAE_DCTNM]
HCMFAMMBR6THDOCUMENTISSUEDATE, -- Document Issue Date [PAE_DOTIS]
HCMFAMMBR6THDOCUMENTEXPIRYDATE, -- Document Expiry Date [PAE_DOTEX]
HCMFAMMBR7THDOCUMENTTYPECODE, -- Document Type [PAE_DCTTP]
HCMFAMMBR7THDOCUMENTNUMBER, -- Number [PAE_DCTNM]
HCMFAMMBR7THDOCUMENTISSUEDATE, -- Document Issue Date [PAE_DOTIS]
HCMFAMMBR7THDOCUMENTEXPIRYDATE, -- Document Expiry Date [PAE_DOTEX]
HCMFAMMBR8THDOCUMENTTYPECODE, -- Document Type [PAE_DCTTP]
HCMFAMMBR8THDOCUMENTNUMBER, -- Number [PAE_DCTNM]
HCMFAMMBR8THDOCUMENTISSUEDATE, -- Document Issue Date [PAE_DOTIS]
HCMFAMMBR8THDOCUMENTEXPIRYDATE, -- Document Expiry Date [PAE_DOTEX]
HCMFAMMBRSUBTYPE2ISHIDDEN, -- Truth Value [ABAP_BOOLEAN]
HCMFAMMBRSUBTYPEAE01ISHIDDEN, -- Truth Value [ABAP_BOOLEAN]
HCMFAMMBRSUBTYPEAE02ISHIDDEN, -- Truth Value [ABAP_BOOLEAN]
HCMFAMMBRSUBTYPEAE04ISHIDDEN, -- 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