HCMFAB_ASSIGNMNT - Fab Fiori : Database Table for Assignments

Fab Fiori : Database Table for Assignments information is stored in SAP table HCMFAB_ASSIGNMNT.
It is part of development package ODATA_HCMFAB_MYTIMESHEET in software component PA-FIO-TS. This development package consists of objects that can be grouped under "OData service for MyTimesheet App".

Fields for table HCMFAB_ASSIGNMNT

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
.INCLUDE		X		HCMFAB_S_TIMESHEET_ASSIGN_KEY	0
MANDT	Client	X	MANDT	CLNT	6	*
UNAME	User Name	X	UNAME	CHAR	24
ID	Fab Fiori : ID for Assignment	X	HCMFAB_ASSIGNMENT_ID	DEC	11
NAME	Fab Fiori : Domain for Assignment		HCMFAB_TIMESHEET_ASSIGN_DESC	CHAR	60
APPROVER	Personnel Number		PERNR_D	NUMC	16
APPR_NAME				STRG	8
ASSIGN_STATUS	Fab Fiori : Assignment Status		ASSIGNSTATUS	CHAR	2
BEGDA	Date		DATUM	DATS	16
ENDDA	Date		DATUM	DATS	16
AWART	Attendance or Absence Type		AWART	CHAR	8
LSTAR	Activity Type		LSTAR	CHAR	12
ALLDF	Record is for Full Day		ALLDF	CHAR	2
PRAKN	Premium Number		PRAKN	CHAR	4
PRAKZ				CHAR	8
BEMOT	Accounting Indicator		BEMOT	CHAR	4
CATSHOURS	Hours		CATSHOURS	QUAN	3
KOKRS	Controlling Area		KOKRS	CHAR	8
CPR_EXTID	External Project ID		CATS_CPROJECT_EXTID	CHAR	48
CPR_GUID	Project ID (GUID)		CATS_CPROJECT_GUID	CHAR	64
CPR_OBJGEXTID	External ID of Project Subobject		CATS_CPROJECT_EXTOBJID	CHAR	48
CPR_OBJGUID	Object ID		CATS_CPROJECT_OBJGUID	CHAR	64
CPR_OBJTYPE	cProjects Object Type		CATS_CPROJECT_TYPE	CHAR	6
WAERS	Currency Key		WAERS	CUKY	10
ENDUZ	Time in CHAR Format fab		TIMEFAB	CHAR	12
EXTAPPLICATION	External Application of Original Record		CATS_AWTYP	CHAR	10
EXTDOCUMENTNO	Document Number		CATS_AWKEY	CHAR	40
AUFKZ	Extra Pay Indicator		AUFKN	CHAR	2
EXTSYSTEM	External Logical System		CATS_AWSYS	CHAR	20
PEDD	Date		DATUM	DATS	16
AUERU	Partial/Final Confirmation		AUERU_VS	CHAR	2
FUNC_AREA	Functional Area		FKBER	CHAR	32
FUND	Fund		BP_GEBER	CHAR	20
GRANT_NBR	Grant		GM_GRANT_NBR	CHAR	40
LONGTEXT	Long Text		CATSLONGTE	CHAR	2
RNPLNR	Network number		NW_AUFNR	CHAR	24
VERSL	Overtime Compensation Type		VRSCH	CHAR	2
ERUZU	Indicator: Partial confirmation		ERUZU	CHAR	2
TRFGR	Pay Scale Group		TRFGR	CHAR	16
TRFST	Pay Scale Level		HR_TRFST	CHAR	4
WERKS	Plant		WERKS_D	CHAR	8
SEBELP				CHAR	10
SEBELN	Sending purchase order		SEBELN	CHAR	20
PLANS				STRG	8
VTKEN	Previous Day Indicator		VTKEN	CHAR	2
RKOSTL	Receiver Cost Center		EKOSTL	CHAR	20
RAUFNR	Receiver Order		EAUFNR	CHAR	24
RPRZNR	Receiver business process		EPRZNR	CHAR	24
RKSTR	Receiver cost object		EKSTR	CHAR	24
RKDPOS				CHAR	12
RKDAUF	Receiver sales order		EKDAU	CHAR	20
OFMNW	Remaining work		REMNW	QUAN	4
SPRZNR	Sender Business Process		SPRZNR	CHAR	24
SKOSTL	Sender Cost Center		SKOSTL	CHAR	20
S_FUNC_AREA	Sending Functional Area		SFKTBER	CHAR	32
S_FUND	Sender fund		FM_SFONDS	CHAR	20
S_GRANT_NBR	Sender Grant		GM_GRANT_SENDER	CHAR	40
LSTNR	Activity Number		ASNUM	CHAR	36
LTXA1	Operation Short Text		LTXA1	CHAR	80
SPLIT	Split number		CY_SPLIT	INT1	1
BEGUZ	Time in CHAR Format fab		TIMEFAB	CHAR	12
STATKEYFIG	Statistical key figure		STAGR	CHAR	12
TCURR	Transaction Currency		TWAER	CUKY	10
REINR				CHAR	20
MEINH	Unit of Measure for Display		MEINH	UNIT	6
UNIT	Unit of Measurement		MSEHI	UNIT	6
LGART	Wage Type		LGART	CHAR	8
WTART	Tax area work center		HRWRKAR	CHAR	8
CATSAMOUNT	CATS Amount		CATSAMOUNT	CURR	7
PRICE	Price in Transaction Currency		CATSPRICE	CURR	6
RPROJ	Work Breakdown Structure Element (WBS Element)		PS_POSID	CHAR	48
ARBPL	Work Center		ARBPL	CHAR	16
TASKTYPE	Task Type		CATSTASKTYPE	CHAR	8
TASKLEVEL	Task Level		CATSTASKLEVEL	CHAR	16
TASKCOMPONENT	Task component		CATSTASKCOMPONENT	CHAR	16
VORNR	Operation/Activity Number		VORNR	CHAR	8
UVORN	Suboperation		UVORN	CHAR	8
KAPAR	Capacity category		KAPART	CHAR	6
BWGRL	Valuation basis		CATSBWGRL	CURR	7
LONGTEXT_DATA				STRG	8
POSID	Work Breakdown Structure Element (WBS Element)		PS_POSID	CHAR	48
RAUFPL				STRG	8
RAPLZL				STRG	8
PAOBJNR				STRG	8
BUDGET_PD				CHAR	20
SBUDGET_PD				CHAR	20
KAPID				STRG	8
WABLNR	Number of Material Document fab		MBLNRFAB	CHAR	20
OTYPE	Object Type		OTYPE	CHAR	4
ARBID				STRG	8
AUTYP				STRG	8
HRCOSTASG	Cost Accounting Variants		CATSHRCO_FAB	CHAR	2
HRKOSTL	Cost Center Fab		CATSHRKOSTLFAB	CHAR	20
HRLSTAR	Activity Type Fab		CATSHRLSTARFAB	CHAR	12
HRFUND	Fab Master Fund		CATSHRFUNDFAB	CHAR	20
HRFUNC_AREA	Master Functional Area		CATSHRFUNC_AREA_FAB	CHAR	32
HRGRANT_NBR	Master Grant Fab		CATSHRGRANT_NBRFAB	CHAR	40
BUKRS	Company Code		BUKRS	CHAR	8
HRBUDGET_PD				CHAR	20
BEDID	ID of Capacity Requirements Record		BEDID_FAB	NUMC	24
.INCLUDE				CI_CATSDB	0
.INCLU--AP				/PPA/T_CI_CATSDB_APPEND	0
.INCLUDE				/PPA/T_CI_CATSDB	0
/PPA/OBJKT	Object type: order/project/cost ctr/network/attendance		/PPA/T_OBJKT	CHAR	4
/PPA/SICHT	Entry view time/expenses/costs/material/billing suggestion		/PPA/T_SICHT	CHAR	2
/PPA/DAUER	Calculated duration in hours		/PPA/T_DAUER	QUAN	3
/PPA/MENGE	Quantity		/PPA/T_MENGE	DEC	7
/PPA/LSTNR	Service number		LSTNR	CHAR	80	MARA
/PPA/TAXKM	Tax classification material		TAXKM	CHAR	2	*
/PPA/MWSKZ	Tax on sales/purchases code		MWSKZ	CHAR	4	*
/PPA/KKART	Credit Card		/PPA/T_KKART	CHAR	12	/PPA/T_CIT
/PPA/RUECK	Completion confirmation number for the operation		CO_RUECK	NUMC	20
/PPA/ACTVY	Activity		/PPA/T_ACTIVITY	CHAR	60	/PPA/T_CT
/PPA/PLOSP	Location of activity output		/PPA/T_PLOSP	CHAR	30
/PPA/TICNR	Ticket No.		/PPA/T_TICNR	CHAR	40
/PPA/FLID	Billing layout control identification number		/PPA/T_FLID	CHAR	20
/PPA/ANSNR	Reservation (subtype by concurrent employment)		/PPA/THRANSNR	CHAR	8
/PPA/CLIENT	BAPI interface client (SAPGUI, WebDynpro, mobile, external�)		/PPA/T_BAPI_INTFCLIENT	CHAR	6
/PPA/VARIANT	Data Entry Profile		CATSVARIAN	CHAR	16	TCATS
/PPA/AL_ASSIGNED	ProTime: Archive- Item is attached to a CATS document		/PPA/T_AL_ASSIGNED	CHAR	2
/PPA/REF_ATAB_PT	Reference between Att/Abs and Perf.Time		/PPA/T_REF_ATTABS_PTIME	CHAR	24
/PPA/AUTO_ADDED	Automaticly inserted document		/PPA/T_AUTO_ADDED	CHAR	2
/PPA/CC_GROUP_ID	Credit Card Group ID		/PPA/T_CC_GROUP_ID	CHAR	16	/PPA/T_CC_STATUS
/PPA/CC_TRANS_REF	Credit Card Transaction Reference		/PPA/T_CC_TRANS_REF	CHAR	48
/PPA/CC_TRANS_DAT	Credit Card Transaction Date		/PPA/T_CC_TRANS_DAT	DATS	16
/PPA/OBJECT_TYPE	ProTime Core: Object type unique		/PPA/T_OBJECT_TYPE	CHAR	4
/PPA/OBJECT_KEY	ProTime Core: Object key unique		/PPA/T_OBJECT_KEY	CHAR	84
.INCLUDE				/PPA/T_STATOBJ	0
/PPA/RKOSTL	Receiver Cost Center		EKOSTL	CHAR	20	*
/PPA/RPROJ	Receiver WBS Element		EPROJ	NUMC	16	*
/PPA/RAUFNR	Receiver Order		EAUFNR	CHAR	24	*
/PPA/RNPLNR	Network number		NW_AUFNR	CHAR	24	*
/PPA/RAUFPL	Routing number of operations in the order		CO_AUFPL	NUMC	20
/PPA/RAPLZL	General counter for order		CO_APLZL	NUMC	16	*
/PPA/RKDAUF	Receiver sales order		EKDAU	CHAR	20
/PPA/RKDPOS	Item number in receiver sales order		EKDPO	NUMC	12
.INCLUDE				/PPA/T_CI_CATSDB_EXT	0
/PPA/DUMMY	Dummy function in length 1		DUMMY	CHAR	2
.INCLUDE				CI_PRS_CPILS_1	0