HRFIO_D_PDQA_D

Transparent Table Application Table
108 Fields 1 CDS Views

Draft table for entity I_QA_HCM_ESSPERSONALDATATP

HRFIO_D_PDQA_D is an SAP database table in S/4HANA. Draft table for entity I_QA_HCM_ESSPERSONALDATATP. It contains 108 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_QA_HCM_ESSPerDataDraft view_entity from BASIC My Personal Data QA - Draft

Fields (108)

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.
hcmemployeeinitials INITS Initials
hcmemployeelastname PAD_NACHN Last Name
hcmemployeesecondname PAD_NACH2 Second name
hcmemployeefirstname PAD_VORNA First Name
hcmemployeecompletename PAD_CNAME Full Name
hcmemployeetitlecode TITEL Title
hcmemployeesecondtitlecode TITL2 Second title
hcmemployeeothertitlecode NAMZU Other title
hcmemployeenameprefix VORSW Name prefix
hcmemployeesecondnameprefix VORS2 N.prefix 2
hcmemployeenickname PAD_RUFNM Nickname
hcmemployeemiddlename PAD_MIDNM Middle name
hcminfotype INFOTYP Infotype
hcmnameeditingformatcode PNAFO Format
hcmemployeenameformat KNZNM Name Format
hcmemployeeformofaddresskey HRFIO_FORMOFADDRESS_ID Title
hcmemployeegender HRPAD_GENDER Gender
hcmemployeebirthdate GEBDAT Date of birth
hcmemployeecountryofbirth HRFIO_COUNTRY_OF_BIRTH_ID Country/Region of Birth
hcmemployeestateofbirth GBDEP State
hcmemployeeplaceofbirth PAD_GBORT Birthplace
hcmemployeenationality NATSL Nationality
hcmemployeesecondnationality HRFIO_SECONDNATIONALITY_ID Second Nationality
hcmemployeethirdnationality HRFIO_THIRDNATIONALITY_ID Third Nationality
hcmemployeecommlanguage PAD_SPRAS Communication L
hcmemplreligiousdenomination KONFE Religion
hcmemployeemaritalstatus FAMST Marital stat.
hcmemplcurmaritalstsvaldfrmdte FAMDT Since
hcmemployeenumberofchildren ANZKD No.of children
hcmemployeehasnameconnection NACON Name connection
hcmemplpersidentifiermodifier PIDMO Pers.ID mod.
hcmemployeepersonnelidnumber PRDNI ID number
hcmemployeepassportbirthdate GBPAS Birth date
hcmemployeekatakanafirstname P22J_PFNMK 1st name Katakana
hcmemployeekatakanalastname P22J_PLNMK Last name (Katakana)
hcmemployeeromajifirstname P22J_PFNMR 1st Name Romaji
hcmemployeeromajilastname P22J_PLNMR Last Name Romaji
hcmemployeekatakanabirthname P22J_PNBIK Name of Birth (Katk)
hcmemployeeromajibirthname P22J_PNBIR Name of Birth (Rom.)
hcmemployeekatakananickname P22J_PNCKK Koseki Katakana
hcmemployeeromajinickname P22J_PNCKR Koseki Romaji
hcmemployeeyearofbirth GBJHR Year of birth
hcmemployeemonthofbirth GBMON Month of Birth
hcmemployeedayofbirth GBTAG Date of birth
hcmemployeesearchlastname NACHNMC Last Name
hcmemployeesearchfirstname VORNAMC First Name
hcmemployeebirthnameaffixcode NAMZ2 Title 2
hcmpersdataarabicfirstname PQA_ARFNM Arabic First Name
hcmpersdataarabicsecondname PQA_ARSNM Arabic Second Name
hcmpersdataarabicthirdname PQA_ARTNM Arabic Third Name
hcmpersdataarabiclastname PQA_ARLNM Arabic Last Name
hcmpersdataknownastxt PQA_RUFNM Known As
hcmpersdataenglishfirstname PQA_VORNA First Name
hcmpersdatasecondenglishname PQA_NACH2 Second Name
hcmpersdatathirdenglishname PQA_MIDNM Third Name
hcmpersdatalastenglishname PQA_NACHN Last Name
hcmpersdatagendercode PQA_GESCH Gender
hcmpersdatabloodgroup PQA_BLGRP Blood Group
hcmpersdatasponsorid PQA_SPONR Sponsor ID
hcmpersdatasponsorshipnumber PQA_SPOSP Sponsorship Number
hcmpersdataprofessioncode PQA_JOBPV Profession
hcmpersdatapassportprofession PQA_JOBPP Passport Profession
hcmpersdatajobonresidentpermit PQA_JOBRP Job Resident Permit
hcmpersdataactualjobtxt PQA_JOBAC Actual Job
hcmpersdatalegalreportingprof PQA_SAVPC Profession LR
hcmpersdatapassportprofcode PQA_SAPPC Passport Profession
hcmpersdataqahomeairportcode PQA_HOMAP Home Airport
hcmpersdatacountryentrancedate PQA_CYETD Ctry/Reg. Entrance
hcmpersdataportofentrytext PQA_EPORT Port of Entry
hcmpersdataisfamilyresidesinqa PQA_FRESI Family in QA
hcmpersdataisexcludelegalrpt PQA_EXCLE Exclude from Rep.
hcmpersdataentrydate PQA_ENTRD Date of Entry
hcmpersdatahasnocompanyhousing PQA_NOCPH No Com. Housing
hcmpersdatabirthcertnumber PQA_BIRCT Birth Certificate
hcmpersdataacademicdegreecode PQA_ADCDG Academic Degree
hcmpersdataprofileclasscode PQA_PROCL Profile Cl.
hcmpersdataspecializationtext PQA_SPECL Specialization
hcmpersdataedulevellegalrpttxt PQA_EDUST Education Level
hcmpersdatahiringtestscoreval PQA_ENSCR Hiring Test Score
hcmpersdatacoaccommodation PQA_ACMTY Company Accomm
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_QA_HCM_ESSPERSONALDATATP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE HRFIO_D_PDQA_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]
    HCMEMPLOYEEINITIALS,             -- Initials [INITS]
    HCMEMPLOYEELASTNAME,             -- Last Name [PAD_NACHN]
    HCMEMPLOYEESECONDNAME,           -- Second name [PAD_NACH2]
    HCMEMPLOYEEFIRSTNAME,            -- First Name [PAD_VORNA]
    HCMEMPLOYEECOMPLETENAME,         -- Full Name [PAD_CNAME]
    HCMEMPLOYEETITLECODE,            -- Title [TITEL]
    HCMEMPLOYEESECONDTITLECODE,      -- Second title [TITL2]
    HCMEMPLOYEEOTHERTITLECODE,       -- Other title [NAMZU]
    HCMEMPLOYEENAMEPREFIX,           -- Name prefix [VORSW]
    HCMEMPLOYEESECONDNAMEPREFIX,     -- N.prefix 2 [VORS2]
    HCMEMPLOYEENICKNAME,             -- Nickname [PAD_RUFNM]
    HCMEMPLOYEEMIDDLENAME,           -- Middle name [PAD_MIDNM]
    HCMINFOTYPE,                     -- Infotype [INFOTYP]
    HCMNAMEEDITINGFORMATCODE,        -- Format [PNAFO]
    HCMEMPLOYEENAMEFORMAT,           -- Name Format [KNZNM]
    HCMEMPLOYEEFORMOFADDRESSKEY,     -- Title [HRFIO_FORMOFADDRESS_ID]
    HCMEMPLOYEEGENDER,               -- Gender [HRPAD_GENDER]
    HCMEMPLOYEEBIRTHDATE,            -- Date of birth [GEBDAT]
    HCMEMPLOYEECOUNTRYOFBIRTH,       -- Country/Region of Birth [HRFIO_COUNTRY_OF_BIRTH_ID]
    HCMEMPLOYEESTATEOFBIRTH,         -- State [GBDEP]
    HCMEMPLOYEEPLACEOFBIRTH,         -- Birthplace [PAD_GBORT]
    HCMEMPLOYEENATIONALITY,          -- Nationality [NATSL]
    HCMEMPLOYEESECONDNATIONALITY,    -- Second Nationality [HRFIO_SECONDNATIONALITY_ID]
    HCMEMPLOYEETHIRDNATIONALITY,     -- Third Nationality [HRFIO_THIRDNATIONALITY_ID]
    HCMEMPLOYEECOMMLANGUAGE,         -- Communication L [PAD_SPRAS]
    HCMEMPLRELIGIOUSDENOMINATION,    -- Religion [KONFE]
    HCMEMPLOYEEMARITALSTATUS,        -- Marital stat. [FAMST]
    HCMEMPLCURMARITALSTSVALDFRMDTE,  -- Since [FAMDT]
    HCMEMPLOYEENUMBEROFCHILDREN,     -- No.of children [ANZKD]
    HCMEMPLOYEEHASNAMECONNECTION,    -- Name connection [NACON]
    HCMEMPLPERSIDENTIFIERMODIFIER,   -- Pers.ID mod. [PIDMO]
    HCMEMPLOYEEPERSONNELIDNUMBER,    -- ID number [PRDNI]
    HCMEMPLOYEEPASSPORTBIRTHDATE,    -- Birth date [GBPAS]
    HCMEMPLOYEEKATAKANAFIRSTNAME,    -- 1st name Katakana [P22J_PFNMK]
    HCMEMPLOYEEKATAKANALASTNAME,     -- Last name (Katakana) [P22J_PLNMK]
    HCMEMPLOYEEROMAJIFIRSTNAME,      -- 1st Name Romaji [P22J_PFNMR]
    HCMEMPLOYEEROMAJILASTNAME,       -- Last Name Romaji [P22J_PLNMR]
    HCMEMPLOYEEKATAKANABIRTHNAME,    -- Name of Birth (Katk) [P22J_PNBIK]
    HCMEMPLOYEEROMAJIBIRTHNAME,      -- Name of Birth (Rom.) [P22J_PNBIR]
    HCMEMPLOYEEKATAKANANICKNAME,     -- Koseki Katakana [P22J_PNCKK]
    HCMEMPLOYEEROMAJINICKNAME,       -- Koseki Romaji [P22J_PNCKR]
    HCMEMPLOYEEYEAROFBIRTH,          -- Year of birth [GBJHR]
    HCMEMPLOYEEMONTHOFBIRTH,         -- Month of Birth [GBMON]
    HCMEMPLOYEEDAYOFBIRTH,           -- Date of birth [GBTAG]
    HCMEMPLOYEESEARCHLASTNAME,       -- Last Name [NACHNMC]
    HCMEMPLOYEESEARCHFIRSTNAME,      -- First Name [VORNAMC]
    HCMEMPLOYEEBIRTHNAMEAFFIXCODE,   -- Title 2 [NAMZ2]
    HCMPERSDATAARABICFIRSTNAME,      -- Arabic First Name [PQA_ARFNM]
    HCMPERSDATAARABICSECONDNAME,     -- Arabic Second Name [PQA_ARSNM]
    HCMPERSDATAARABICTHIRDNAME,      -- Arabic Third Name [PQA_ARTNM]
    HCMPERSDATAARABICLASTNAME,       -- Arabic Last Name [PQA_ARLNM]
    HCMPERSDATAKNOWNASTXT,           -- Known As [PQA_RUFNM]
    HCMPERSDATAENGLISHFIRSTNAME,     -- First Name [PQA_VORNA]
    HCMPERSDATASECONDENGLISHNAME,    -- Second Name [PQA_NACH2]
    HCMPERSDATATHIRDENGLISHNAME,     -- Third Name [PQA_MIDNM]
    HCMPERSDATALASTENGLISHNAME,      -- Last Name [PQA_NACHN]
    HCMPERSDATAGENDERCODE,           -- Gender [PQA_GESCH]
    HCMPERSDATABLOODGROUP,           -- Blood Group [PQA_BLGRP]
    HCMPERSDATASPONSORID,            -- Sponsor ID [PQA_SPONR]
    HCMPERSDATASPONSORSHIPNUMBER,    -- Sponsorship Number [PQA_SPOSP]
    HCMPERSDATAPROFESSIONCODE,       -- Profession [PQA_JOBPV]
    HCMPERSDATAPASSPORTPROFESSION,   -- Passport Profession [PQA_JOBPP]
    HCMPERSDATAJOBONRESIDENTPERMIT,  -- Job Resident Permit [PQA_JOBRP]
    HCMPERSDATAACTUALJOBTXT,         -- Actual Job [PQA_JOBAC]
    HCMPERSDATALEGALREPORTINGPROF,   -- Profession LR [PQA_SAVPC]
    HCMPERSDATAPASSPORTPROFCODE,     -- Passport Profession [PQA_SAPPC]
    HCMPERSDATAQAHOMEAIRPORTCODE,    -- Home Airport [PQA_HOMAP]
    HCMPERSDATACOUNTRYENTRANCEDATE,  -- Ctry/Reg. Entrance [PQA_CYETD]
    HCMPERSDATAPORTOFENTRYTEXT,      -- Port of Entry [PQA_EPORT]
    HCMPERSDATAISFAMILYRESIDESINQA,  -- Family in QA [PQA_FRESI]
    HCMPERSDATAISEXCLUDELEGALRPT,    -- Exclude from Rep. [PQA_EXCLE]
    HCMPERSDATAENTRYDATE,            -- Date of Entry [PQA_ENTRD]
    HCMPERSDATAHASNOCOMPANYHOUSING,  -- No Com. Housing [PQA_NOCPH]
    HCMPERSDATABIRTHCERTNUMBER,      -- Birth Certificate [PQA_BIRCT]
    HCMPERSDATAACADEMICDEGREECODE,   -- Academic Degree [PQA_ADCDG]
    HCMPERSDATAPROFILECLASSCODE,     -- Profile Cl. [PQA_PROCL]
    HCMPERSDATASPECIALIZATIONTEXT,   -- Specialization [PQA_SPECL]
    HCMPERSDATAEDULEVELLEGALRPTTXT,  -- Education Level [PQA_EDUST]
    HCMPERSDATAHIRINGTESTSCOREVAL,   -- Hiring Test Score [PQA_ENSCR]
    HCMPERSDATACOACCOMMODATION,      -- Company Accomm [PQA_ACMTY]
    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