COIFT

Interface to Activity Allocation | #transactional | Component: Personnel Time Management
Column Name Description
MANDT FK Client
IFTNR Sequence Number for CO/MM-SRV Interface Tables
Column Name Description
Column Name Description
Column Name Description
ENDDA End Date
BEGDA Start Date
INSDT Date on which record was written to interface
INTIM Time at which record was written to interface
DATUM2 Date on which record was initially accessed
UZEIT2 Time at which record was initially accessed
DATUM3 Date on which record was last accessed
UZEIT3 Time at which record was last accessed
OUTDT Date on which record was first retrieved successfully
OUTTI Time at which record was first retrieved successfully
BUDAT Posting Date
Column Name Description
APPID Assignment of data to an application Show values
STATU2 Log status when record was first accessed Show values
STATU3 Log status when record was last accessed Show values
STOKN Indicator: Document was reversed Show values
Column Name Description Domain name
PERNR Personnel Number PERNR
SUBTY Subtype SUBTY
OBJPS Object Identification OBJPS
SPRPS Lock Indicator for HR Master Data Record SPRPS
SEQNR Number of Infotype Record With Same Key NUM03
INNAM User who wrote record to interface UNAME
INPGM Write Record to Interface Report PROGNAME
UNAME2 Name of user who initially accessed record UNAME
PGMID2 Report used to access record initially PROGNAME
UNAME3 Last user to access record UNAME
PGMID3 Last Used to Access Record Program PROGNAME
OUTNA User who first retrieved the record successfully UNAME
OUTPG Report first used to retrieve record successfully PROGNAME
BELNR Reference Document Number BELNR
LBLNI Reference Organizational Units AWORG
BLPOS Document item NUM3
VORNR Operation/Activity Number VORNR
KDPOS Item number in Sales Order NUM06
PAOBJNR Profitability Segment Number (CO-PA) RKEOBJNR
PRZNR Business Process CO_PRZNR
EXBEL Assignment number HR_ZUONR
POHRS Number of Hours for Activity Allocation/External Services PTM_DEC5_2S
SGTXT Item Text TEXT50
TXJCD Tax Jurisdiction TXJCD
FIPEX Commitment Item FM_FIPEX
FKBER Functional Area FKBER
GRANT_NBR Grant GM_GRANT_NBR
SGEBER Sender fund BP_GEBER
SFKBER Sending Functional Area FKBER
SGRANT_NBR Sender Grant GM_GRANT_NBR
SEGMENT Segment for Segmental Reporting FB_SEGMENT
SSEGMENT Segment for Segmental Reporting FB_SEGMENT
BUDGET_PD Budget Period FM_BUDGET_PERIOD
SBUDGET_PD FM: Sender Budget Period FM_BUDGET_PERIOD
Master Data Relations Join Conditions
Order Number
  • Order Number
  • Client
  • COIFT.AUFNR == AUFK.AUFNR
  • COIFT.MANDT == AUFK.MANDT
Company Code
  • COIFT.MANDT == T001.MANDT
  • COIFT.BUKRS == T001.BUKRS
Service Type (Public Service Germany)
  • ?
  • Service Type (Public Service Germany)
  • ?
  • COIFT.MANDT == T5D7C.MANDT
  • COIFT.[column in domain "DAKAT"] == T5D7C.DAKAT
  • COIFT.DART == T5D7C.DART
  • COIFT.[column in domain "ENDDA"] == T5D7C.ENDDA
Commitment Item
  • Commitment Item
  • ?
  • ?
  • COIFT.MANDT == FMFPO.MANDT
  • COIFT.FIPOS == FMFPO.FIPOS
  • COIFT.[column in domain "FIKRS"] == FMFPO.FIKRS
  • COIFT.[column in domain "FM_DATBIS"] == FMFPO.DATBIS
Funds Center
  • Funds Center
  • ?
  • Client
  • ?
  • COIFT.FISTL == FMFCTR.FICTR
  • COIFT.[column in domain "FM_DATBIS"] == FMFCTR.DATBIS
  • COIFT.MANDT == FMFCTR.MANDT
  • COIFT.[column in domain "FIKRS"] == FMFCTR.FIKRS
Fund
  • ?
  • Fund
  • Client
Business Area
  • COIFT.MANDT == TGSB.MANDT
  • COIFT.GSBER == TGSB.GSBER
Infotype
  • COIFT.MANDT == T582A.MANDT
  • COIFT.INFTY == T582A.INFTY
Controlling Area
  • COIFT.MANDT == TKA01.MANDT
  • COIFT.KOKRS == TKA01.KOKRS
Cost Center
  • ?
  • Cost Center
  • Controlling Area
  • COIFT.MANDT == CSKS.MANDT
  • COIFT.[column in domain "DATBI"] == CSKS.DATBI
  • COIFT.KOSTL == CSKS.KOSTL
  • COIFT.KOKRS == CSKS.KOKRS
Cost Object
  • Cost Object
  • ?
  • Client
  • COIFT.KSTRG == CKPH.KSTRG
  • COIFT.[column in domain "DATBI"] == CKPH.DATBI
  • COIFT.MANDT == CKPH.MANDT
Wage Type
  • ?
  • ?
  • Client
  • Wage Type
  • COIFT.[column in domain "MOLGA"] == T512W.MOLGA
  • COIFT.[column in domain "ENDDA"] == T512W.ENDDA
  • COIFT.MANDT == T512W.MANDT
  • COIFT.LGART == T512W.LGART
Activity Type
  • Controlling Area
  • Activity Type
  • ?
  • COIFT.MANDT == CSLA.MANDT
  • COIFT.KOKRS == CSLA.KOKRS
  • COIFT.LSTAR == CSLA.LSTAR
  • COIFT.[column in domain "DATBI"] == CSLA.DATBI
Activity Number
  • COIFT.MANDT == ASMD.MANDT
  • COIFT.LSTNR == ASMD.ASNUM
Activity Type
  • Controlling Area
  • Activity Type
  • ?
  • COIFT.MANDT == CSLA.MANDT
  • COIFT.KOKRS == CSLA.KOKRS
  • COIFT.LTLST == CSLA.LSTAR
  • COIFT.[column in domain "DATBI"] == CSLA.DATBI
Client COIFT.MANDT == T000.MANDT
Tax on sales/purchases code
  • ?
  • Tax on sales/purchases code
  • COIFT.MANDT == T007A.MANDT
  • COIFT.[column in domain "KALSM_D"] == T007A.KALSM
  • COIFT.MWSKZ == T007A.MWSKZ
Network Number for Account Assignment
  • Network Number for Account Assignment
  • Client
  • COIFT.NPLNR == AUFK.AUFNR
  • COIFT.MANDT == AUFK.MANDT
Object Type
  • COIFT.MANDT == T778O.MANDT
  • COIFT.OTYPE == T778O.OTYPE
Company Code
  • COIFT.MANDT == T001.MANDT
  • COIFT.SBUKR == T001.BUKRS
Business Area
  • COIFT.MANDT == TGSB.MANDT
  • COIFT.SGSBR == TGSB.GSBER
Cost Center
  • ?
  • Cost Center
  • Controlling Area
  • COIFT.MANDT == CSKS.MANDT
  • COIFT.[column in domain "DATBI"] == CSKS.DATBI
  • COIFT.SKOST == CSKS.KOSTL
  • COIFT.KOKRS == CSKS.KOKRS
Service Category (Public Service Germany)
  • ?
  • ?
  • Service Type (Public Service Germany)
  • Service Category (Public Service Germany)
  • COIFT.MANDT == T5D7E.MANDT
  • COIFT.[column in domain "ENDDA"] == T5D7E.ENDDA
  • COIFT.[column in domain "DAKAT"] == T5D7E.DAKAT
  • COIFT.DART == T5D7E.DART
  • COIFT.UDART == T5D7E.UDART
Other Relations | to Master Data Relations ↑ Join Conditions
Job
  • Job
  • Client
  • ?
  • COIFT.STELL == T513.STELL
  • COIFT.MANDT == T513.MANDT
  • COIFT.[column in domain "ENDDA"] == T513.ENDDA