HRFIO_D_PDES_D

Transparent Table Application Table
54 Fields 1 CDS Views

Draft table for entity I_ES_HCM_ESSPERSONALDATAROOTTP

HRFIO_D_PDES_D is an SAP database table in S/4HANA. Draft table for entity I_ES_HCM_ESSPERSONALDATAROOTTP. It contains 54 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_ES_HCM_ESSPerDataDraft view_entity from BASIC My Personal Data ES - Draft

Fields (54)

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
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.
hcmemployeeformofaddresskey HRFIO_FORMOFADDRESS_ID Title
hcmemployeenameformat KNZNM Name Format
hcmemployeelastname PAD_NACHN Last Name
hcmemployeebirthname PAD_NAME2 Name at Birth
hcmemployeefirstname PAD_VORNA First Name
hcmemployeeinitials INITS Initials
hcmemployeenameprefix VORSW Name prefix
hcmemployeesecondnameprefix VORS2 N.prefix 2
hcmemployeetitlecode TITEL Title
hcmspainemployeedocumentnumber PES_UI_0002_PRDNI Document number
hcmemployeedocumenttype PES_IDTYPE Document type
hcmemployeebirthdate GEBDAT Date of birth
hcmemployeeplaceofbirth PAD_GBORT Birthplace
hcmemployeecountryofbirth HRFIO_COUNTRY_OF_BIRTH_ID Country/Region of Birth
hcmemployeestateofbirth GBDEP State
hcmemployeecommlanguage PAD_SPRAS Communication L
hcmemployeenationality NATSL Nationality
hcmemployeemaritalstatus FAMST Marital stat.
hcmemplcurmaritalstsvaldfrmdte FAMDT Since
hcmemployeenumberofchildren ANZKD No.of children
hcmemployeesecondname PAD_NACH2 Second name
hcmemployeesecondtitlecode TITL2 Second title
hcmemployeesecondnationality HRFIO_SECONDNATIONALITY_ID Second Nationality
hcmemployeethirdnationality HRFIO_THIRDNATIONALITY_ID Third Nationality
hcmemplreligiousdenomination KONFE Religion
hcmemployeeothertitlecode NAMZU Other title
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_ES_HCM_ESSPERSONALDATAROOTTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE HRFIO_D_PDES_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]
    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]
    HCMEMPLOYEEFORMOFADDRESSKEY,     -- Title [HRFIO_FORMOFADDRESS_ID]
    HCMEMPLOYEENAMEFORMAT,           -- Name Format [KNZNM]
    HCMEMPLOYEELASTNAME,             -- Last Name [PAD_NACHN]
    HCMEMPLOYEEBIRTHNAME,            -- Name at Birth [PAD_NAME2]
    HCMEMPLOYEEFIRSTNAME,            -- First Name [PAD_VORNA]
    HCMEMPLOYEEINITIALS,             -- Initials [INITS]
    HCMEMPLOYEENAMEPREFIX,           -- Name prefix [VORSW]
    HCMEMPLOYEESECONDNAMEPREFIX,     -- N.prefix 2 [VORS2]
    HCMEMPLOYEETITLECODE,            -- Title [TITEL]
    HCMSPAINEMPLOYEEDOCUMENTNUMBER,  -- Document number [PES_UI_0002_PRDNI]
    HCMEMPLOYEEDOCUMENTTYPE,         -- Document type [PES_IDTYPE]
    HCMEMPLOYEEBIRTHDATE,            -- Date of birth [GEBDAT]
    HCMEMPLOYEEPLACEOFBIRTH,         -- Birthplace [PAD_GBORT]
    HCMEMPLOYEECOUNTRYOFBIRTH,       -- Country/Region of Birth [HRFIO_COUNTRY_OF_BIRTH_ID]
    HCMEMPLOYEESTATEOFBIRTH,         -- State [GBDEP]
    HCMEMPLOYEECOMMLANGUAGE,         -- Communication L [PAD_SPRAS]
    HCMEMPLOYEENATIONALITY,          -- Nationality [NATSL]
    HCMEMPLOYEEMARITALSTATUS,        -- Marital stat. [FAMST]
    HCMEMPLCURMARITALSTSVALDFRMDTE,  -- Since [FAMDT]
    HCMEMPLOYEENUMBEROFCHILDREN,     -- No.of children [ANZKD]
    HCMEMPLOYEESECONDNAME,           -- Second name [PAD_NACH2]
    HCMEMPLOYEESECONDTITLECODE,      -- Second title [TITL2]
    HCMEMPLOYEESECONDNATIONALITY,    -- Second Nationality [HRFIO_SECONDNATIONALITY_ID]
    HCMEMPLOYEETHIRDNATIONALITY,     -- Third Nationality [HRFIO_THIRDNATIONALITY_ID]
    HCMEMPLRELIGIOUSDENOMINATION,    -- Religion [KONFE]
    HCMEMPLOYEEOTHERTITLECODE,       -- Other title [NAMZU]
    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