SAP ABAP Table COIFT (Interface to Activity Allocation)

Hierarchy

☛ SAP_HRRXX (Software Component) Sub component SAP_HRRXX of SAP_HR
   ⤷ PT (Application Component) Personnel Time Management
     ⤷ PTIM (Package) HR Time Management Application Development

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	COIFT	Table Relationship Diagram
Short Description	Interface to Activity Allocation

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	IFTNR	☑	IFTNR	IFTNR	NUMC	10	0	Sequence Number for CO/MM-SRV Interface Tables
3	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
4	INFTY	☐	INFTY	INFOTYP	CHAR	4	0	Infotype	T582A
5	SUBTY	☐	SUBTY	SUBTY	CHAR	4	0	Subtype
6	OBJPS	☐	OBJPS	OBJPS	CHAR	2	0	Object Identification
7	SPRPS	☐	SPRPS	SPRPS	CHAR	1	0	Lock Indicator for HR Master Data Record
8	ENDDA	☐	ENDDA	DATUM	DATS	8	0	End Date
9	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
10	SEQNR	☐	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
11	LGART	☐	LGART	LGART	CHAR	4	0	Wage Type	T512W
12	APPID	☐	APPID	APPID	CHAR	1	0	Assignment of data to an application
13	INNAM	☐	PW_UNAME1	UNAME	CHAR	12	0	User who wrote record to interface
14	INSDT	☐	PW_DATUM1	DATUM	DATS	8	0	Date on which record was written to interface
15	INTIM	☐	PW_UZEIT1	UZEIT	TIMS	6	0	Time at which record was written to interface
16	INPGM	☐	PW_PGMID1	PROGNAME	CHAR	40	0	Write Record to Interface Report
17	UNAME2	☐	PW_UNAME2	UNAME	CHAR	12	0	Name of user who initially accessed record
18	DATUM2	☐	PW_DATUM2	DATUM	DATS	8	0	Date on which record was initially accessed
19	UZEIT2	☐	PW_UZEIT2	UZEIT	TIMS	6	0	Time at which record was initially accessed
20	PGMID2	☐	PW_PGMID2	PROGNAME	CHAR	40	0	Report used to access record initially
21	STATU2	☐	PW_STATU2	PW_STATU	CHAR	1	0	Log status when record was first accessed
22	UNAME3	☐	PW_UNAME3	UNAME	CHAR	12	0	Last user to access record
23	DATUM3	☐	PW_DATUM3	DATUM	DATS	8	0	Date on which record was last accessed
24	UZEIT3	☐	PW_UZEIT3	UZEIT	TIMS	6	0	Time at which record was last accessed
25	PGMID3	☐	PW_PGMID3	PROGNAME	CHAR	40	0	Last Used to Access Record Program
26	STATU3	☐	PW_STATU3	PW_STATU	CHAR	1	0	Log status when record was last accessed
27	OUTNA	☐	PW_UNAME4	UNAME	CHAR	12	0	User who first retrieved the record successfully
28	OUTDT	☐	PW_DATUM4	DATUM	DATS	8	0	Date on which record was first retrieved successfully
29	OUTTI	☐	PW_UZEIT4	UZEIT	TIMS	6	0	Time at which record was first retrieved successfully
30	OUTPG	☐	PW_PGMID4	PROGNAME	CHAR	40	0	Report first used to retrieve record successfully
31	BUDAT	☐	CO_BUDAT	DATUM	DATS	8	0	Posting Date
32	STOKN	☐	CO_STOKZ	FLAG	CHAR	1	0	Indicator: Document Has Been Reversed
33	BELNR	☐	CO_REFBN	BELNR	CHAR	10	0	Reference Document Number
34	LBLNI	☐	AWORG	AWORG	CHAR	10	0	Reference organisational units
35	BLPOS	☐	HRAABPOS	NUM3	NUMC	3	0	Document item
36	.INCLUDE	☐				0	0	Assignment Values for HR Objects
37	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
38	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
39	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
40	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
41	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
42	KSTRG	☐	KSTRG	KSTRG	CHAR	12	0	Cost Object	CKPH
43	POSNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	PRPS
44	NPLNR	☐	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	AUFK
45	VORNR	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
46	KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
47	KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
48	PAOBJNR	☐	RKEOBJNR	RKEOBJNR	NUMC	10	0	Profitability Segment Number (CO-PA)
49	PRZNR	☐	CO_PRZNR	CO_PRZNR	CHAR	12	0	Business Process	*
50	FISTL	☐	FISTL	FISTL	CHAR	16	0	Funds Center	FMFCTR
51	FIPOS	☐	FIPOS	FIPOS	CHAR	14	0	Commitment Item	FMFPO
52	GEBER	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	FMFINCODE
53	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	EKKO
54	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	EKPO
55	LSTNR	☐	ASNUM	ASNUM	CHAR	18	0	Activity Number	ASMD
56	LTLST	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	CSLA
57	SBUKR	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
58	SGSBR	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
59	SKOST	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
60	LSTAR	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	CSLA
61	EXBEL	☐	HR_ZUONR	HR_ZUONR	CHAR	18	0	Assignment number
62	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	T007A
63	OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	T778O
64	STELL	☐	STELL	STELL	NUMC	8	0	Job	T513
65	POHRS	☐	POHRS	PTM_DEC5_2S	DEC	7	2	Number of Hours for Activity Allocation/External Services
66	DART	☐	DART	DART	CHAR	2	0	Service Type (Public Service Germany)	T5D7C
67	UDART	☐	UDART	UDART	CHAR	2	0	Service Category (Public Service Germany)	T5D7E
68	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
69	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
70	FIPEX	☐	FM_FIPEX	FM_FIPEX	CHAR	24	0	Commitment item	*
71	FKBER	☐	FKBER	FKBER	CHAR	16	0	Functional Area	*
72	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
73	SGEBER	☐	FM_SFONDS	BP_GEBER	CHAR	10	0	Sender fund	*
74	SFKBER	☐	SFKTBER	FKBER	CHAR	16	0	Sending Functional Area	*
75	SGRANT_NBR	☐	GM_GRANT_SENDER	GM_GRANT_NBR	CHAR	20	0	Sender Grant
76	SEGMENT	☐	FB_SEGMENT	FB_SEGMENT	CHAR	10	0	Segment for Segmental Reporting	*
77	SSEGMENT	☐	FB_SEGMENT	FB_SEGMENT	CHAR	10	0	Segment for Segmental Reporting	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	COIFT	AUFNR	AUFK	AUFNR	KEY	1	CN
2	COIFT	BUKRS	T001	BUKRS	KEY	1	CN
3	COIFT	DART	T5D7C	DART
4	COIFT	EBELN	EKKO	EBELN	KEY	1	CN
5	COIFT	EBELP	EKPO	EBELP	KEY	1	CN
6	COIFT	FIPOS	FMFPO	FIPOS	KEY	1	CN
7	COIFT	FISTL	FMFCTR	FICTR	KEY	1	CN
8	COIFT	GEBER	FMFINCODE	FINCODE	KEY	1	CN
9	COIFT	GSBER	TGSB	GSBER	KEY	1	CN
10	COIFT	INFTY	T582A	INFTY
11	COIFT	KDAUF	VBUK	VBELN	KEY	1	CN
12	COIFT	KOKRS	TKA01	KOKRS	KEY	1	CN
13	COIFT	KOSTL	CSKS	KOSTL	KEY	1	CN
14	COIFT	KSTRG	CKPH	KSTRG	KEY	1	CN
15	COIFT	LGART	T512W	LGART	KEY	1	CN
16	COIFT	LSTAR	CSLA	LSTAR	KEY	1	CN
17	COIFT	LSTNR	ASMD	ASNUM
18	COIFT	LTLST	CSLA	LSTAR
19	COIFT	MANDT	T000	MANDT	KEY	1	CN
20	COIFT	MWSKZ	T007A	MWSKZ	KEY	1	CN
21	COIFT	NPLNR	AUFK	AUFNR	KEY	1	CN
22	COIFT	OTYPE	T778O	OTYPE	KEY	1	CN
23	COIFT	POSNR	PRPS	PSPNR	KEY	1	CN
24	COIFT	SBUKR	T001	BUKRS	KEY	1	CN
25	COIFT	SGSBR	TGSB	GSBER	KEY	1	CN
26	COIFT	SKOST	CSKS	KOSTL	KEY	1	CN
27	COIFT	STELL	T513	STELL	KEY	1	CN
28	COIFT	UDART	T5D7E	UDART

History

Last changed by/on	SAP	20130529
SAP Release Created in