HRFIO_ASSIGNMENT

Transparent Table Application Table
100 Fields 1 CDS Views

My Timesheet V4: Database Table for Assignment Details

HRFIO_ASSIGNMENT is an SAP database table in S/4HANA. My Timesheet V4: Database Table for Assignment Details. It contains 100 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_HCMTimeShtAssgmt view_entity from BASIC HCM Timesheet Assignment

Fields (100)

KeyField Data ElementDescription DomainTypeLength
uname uname User Name
name hrfio_timesheet_assign_desc Assignment
begda datum Date
endda datum Date
approver pernr_d Personnel No.
appr_name abap.char
admin_assgmt boole_d TRUE
assign_status boole_d TRUE
favorite boole_d TRUE
lstar lstar Activity Type
alldf alldf Full-day
vtken vtken Previous day
catshours catshours Hours
catsquantity catsnumber Number (unit)
waers waers Currency
beguz catsbeguz Start time
enduz catsenduz End time
catsamount catsamount Amount
price catsprice Price
tcurr twaer Trans. Currency
reinr reinr Trip Number
meinh meinh Unit of Measure
unit msehi Internal UoM
longtext catslongte Long text
awart awart Att./abs. type
prakn prakn Premium no.
prakz prakz Premium ID
bemot bemot AcctIndicator
percent abap.char Percentage
kokrs kokrs CO Area
cpr_extid cats_cproject_extid Project
cpr_guid cats_cproject_guid Project
cpr_objgextid cats_cproject_extobjid Subobject
cpr_objguid cats_cproject_objguid Subobject
cpr_objtype cats_cproject_type Object Type
extapplication cats_awtyp Ext.appl.
extdocumentno cats_awkey Document no.
aufkz aufkn Extra pay ID
extsystem cats_awsys Logical system
pedd co_pedd Forecast finish
aueru aueru_vs Final Confirmtn
func_area efktber Receiving Func. Area
fund bp_geber Fund
grant_nbr gm_grant_nbr Grant
rnplnr nw_aufnr Network
versl vrsch OT comp. type
eruzu eruzu Part. con.
trfgr trfgr Pay Scale Group
trfst hr_trfst PS level
werks werks_d Plant
sebelp sebelp Send. PO item
sebeln sebeln Sending order
plans plans Position
rkostl ekostl Rec. CCtr
raufnr eaufnr Rec. order
rprznr eprznr Rec.bus.process
rkstr ekstr Cost object
rkdpos ekdpo RecSalOrd. item
rkdauf ekdau Rec. sales ord.
ofmnw remnw Remaining work
sprznr sprznr Send.Bus.Proc.
skostl skostl Send. CCtr
s_func_area sfktber Sender Fnc.Area
s_fund fm_sfonds Sender Fund
s_grant_nbr gm_grant_sender Sender Grant
lstnr asnum Activity number
ltxa1 catsshortt Short Text
split cy_split Split number
statkeyfig stagr Stat. key fig.
lgart lgart Wage Type
wtart hrwrkar Tax area
rproj ps_posid WBS Element
arbpl arbpl Work Center
tasktype catstasktype Task Type
tasklevel catstasklevel Task level
taskcomponent catstaskcomponent Task component
vornr vornr Activity
uvorn uvorn Suboperation
kapar kapart Capacity cat.
bwgrl catsbwgrl Valuation basis
posid ps_posid WBS Element
raufpl co_aufpl Plan No.f.Oper.
raplzl co_aplzl Counter
paobjnr rkeobjnr Profit. segment
budget_pd fm_ebudget_period Rec BudPer
sbudget_pd fm_sbudget_period Sender BudPer
kapid kapid Capacity ID
wablnr mblnrhrfio Material Doc.
otype otype Object type
arbid objektid Object ID
autyp auftyp Order category
hrcostasg catshrco_hrfio Cost acc. var.
hrkostl catshrkostlhrfio Cost center
hrlstar catshrlstarhrfio Activity type
hrfund catshrfundhrfio Master Fund
hrfunc_area catshrfunc_area_hrfio MasterFunc.Area
hrgrant_nbr catshrgrant_nbrhrfio Master Grant
bukrs bukrs Company Code
hrbudget_pd catshr_budget_period MasterBP
bedid bedid_hrfio Id number

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.

-- My Timesheet V4: Database Table for Assignment Details
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE HRFIO_ASSIGNMENT (
    UNAME,           -- User Name [uname]
    NAME,            -- Assignment [hrfio_timesheet_assign_desc]
    BEGDA,           -- Date [datum]
    ENDDA,           -- Date [datum]
    APPROVER,        -- Personnel No. [pernr_d]
    APPR_NAME,       -- abap.char
    ADMIN_ASSGMT,    -- TRUE [boole_d]
    ASSIGN_STATUS,   -- TRUE [boole_d]
    FAVORITE,        -- TRUE [boole_d]
    LSTAR,           -- Activity Type [lstar]
    ALLDF,           -- Full-day [alldf]
    VTKEN,           -- Previous day [vtken]
    CATSHOURS,       -- Hours [catshours]
    CATSQUANTITY,    -- Number (unit) [catsnumber]
    WAERS,           -- Currency [waers]
    BEGUZ,           -- Start time [catsbeguz]
    ENDUZ,           -- End time [catsenduz]
    CATSAMOUNT,      -- Amount [catsamount]
    PRICE,           -- Price [catsprice]
    TCURR,           -- Trans. Currency [twaer]
    REINR,           -- Trip Number [reinr]
    MEINH,           -- Unit of Measure [meinh]
    UNIT,            -- Internal UoM [msehi]
    LONGTEXT,        -- Long text [catslongte]
    AWART,           -- Att./abs. type [awart]
    PRAKN,           -- Premium no. [prakn]
    PRAKZ,           -- Premium ID [prakz]
    BEMOT,           -- AcctIndicator [bemot]
    PERCENT,         -- Percentage [abap.char]
    KOKRS,           -- CO Area [kokrs]
    CPR_EXTID,       -- Project [cats_cproject_extid]
    CPR_GUID,        -- Project [cats_cproject_guid]
    CPR_OBJGEXTID,   -- Subobject [cats_cproject_extobjid]
    CPR_OBJGUID,     -- Subobject [cats_cproject_objguid]
    CPR_OBJTYPE,     -- Object Type [cats_cproject_type]
    EXTAPPLICATION,  -- Ext.appl. [cats_awtyp]
    EXTDOCUMENTNO,   -- Document no. [cats_awkey]
    AUFKZ,           -- Extra pay ID [aufkn]
    EXTSYSTEM,       -- Logical system [cats_awsys]
    PEDD,            -- Forecast finish [co_pedd]
    AUERU,           -- Final Confirmtn [aueru_vs]
    FUNC_AREA,       -- Receiving Func. Area [efktber]
    FUND,            -- Fund [bp_geber]
    GRANT_NBR,       -- Grant [gm_grant_nbr]
    RNPLNR,          -- Network [nw_aufnr]
    VERSL,           -- OT comp. type [vrsch]
    ERUZU,           -- Part. con. [eruzu]
    TRFGR,           -- Pay Scale Group [trfgr]
    TRFST,           -- PS level [hr_trfst]
    WERKS,           -- Plant [werks_d]
    SEBELP,          -- Send. PO item [sebelp]
    SEBELN,          -- Sending order [sebeln]
    PLANS,           -- Position [plans]
    RKOSTL,          -- Rec. CCtr [ekostl]
    RAUFNR,          -- Rec. order [eaufnr]
    RPRZNR,          -- Rec.bus.process [eprznr]
    RKSTR,           -- Cost object [ekstr]
    RKDPOS,          -- RecSalOrd. item [ekdpo]
    RKDAUF,          -- Rec. sales ord. [ekdau]
    OFMNW,           -- Remaining work [remnw]
    SPRZNR,          -- Send.Bus.Proc. [sprznr]
    SKOSTL,          -- Send. CCtr [skostl]
    S_FUNC_AREA,     -- Sender Fnc.Area [sfktber]
    S_FUND,          -- Sender Fund [fm_sfonds]
    S_GRANT_NBR,     -- Sender Grant [gm_grant_sender]
    LSTNR,           -- Activity number [asnum]
    LTXA1,           -- Short Text [catsshortt]
    SPLIT,           -- Split number [cy_split]
    STATKEYFIG,      -- Stat. key fig. [stagr]
    LGART,           -- Wage Type [lgart]
    WTART,           -- Tax area [hrwrkar]
    RPROJ,           -- WBS Element [ps_posid]
    ARBPL,           -- Work Center [arbpl]
    TASKTYPE,        -- Task Type [catstasktype]
    TASKLEVEL,       -- Task level [catstasklevel]
    TASKCOMPONENT,   -- Task component [catstaskcomponent]
    VORNR,           -- Activity [vornr]
    UVORN,           -- Suboperation [uvorn]
    KAPAR,           -- Capacity cat. [kapart]
    BWGRL,           -- Valuation basis [catsbwgrl]
    POSID,           -- WBS Element [ps_posid]
    RAUFPL,          -- Plan No.f.Oper. [co_aufpl]
    RAPLZL,          -- Counter [co_aplzl]
    PAOBJNR,         -- Profit. segment [rkeobjnr]
    BUDGET_PD,       -- Rec BudPer [fm_ebudget_period]
    SBUDGET_PD,      -- Sender BudPer [fm_sbudget_period]
    KAPID,           -- Capacity ID [kapid]
    WABLNR,          -- Material Doc. [mblnrhrfio]
    OTYPE,           -- Object type [otype]
    ARBID,           -- Object ID [objektid]
    AUTYP,           -- Order category [auftyp]
    HRCOSTASG,       -- Cost acc. var. [catshrco_hrfio]
    HRKOSTL,         -- Cost center [catshrkostlhrfio]
    HRLSTAR,         -- Activity type [catshrlstarhrfio]
    HRFUND,          -- Master Fund [catshrfundhrfio]
    HRFUNC_AREA,     -- MasterFunc.Area [catshrfunc_area_hrfio]
    HRGRANT_NBR,     -- Master Grant [catshrgrant_nbrhrfio]
    BUKRS,           -- Company Code [bukrs]
    HRBUDGET_PD,     -- MasterBP [catshr_budget_period]
    BEDID            -- Id number [bedid_hrfio]
);

Learn More