COIFT SAP (Interface to Activity Allocation) Table details
Dictionary Type: Table
Description: Interface to Activity Allocation
Description: Interface to Activity Allocation
Table field list including key, data, relationships and ABAP select examples
COIFT is a standard SAP Table which is used to store Interface to Activity Allocation data and is available within R/3 SAP systems depending on the version and release level.
The COIFT table consists of various fields, each holding specific information or linking keys about Interface to Activity Allocation data available in SAP. These include IFTNR (Sequence Number for CO/MM-SRV Interface Tables), PERNR (Personnel Number), INFTY (Infotype), SUBTY (Subtype).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP COIFT table fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
| IFTNR | Sequence Number for CO/MM-SRV Interface Tables | IFTNR | NUMC | 10 | IFTNR | ||||
| PERNR | Personnel Number | PERNR_D | NUMC | 8 | PERNR | PER | |||
| INFTY | Infotype | INFTY | CHAR | 4 | T582A | INFOTYP | ITP | ||
| SUBTY | Subtype | SUBTY | CHAR | 4 | SUBTY | SUB | |||
| OBJPS | Object Identification | OBJPS | CHAR | 2 | OBJPS | OPS | |||
| SPRPS | Lock Indicator for HR Master Data Record | SPRPS | CHAR | 1 | SPRPS | ||||
| ENDDA | End Date | ENDDA | DATS | 8 | DATUM | ||||
| BEGDA | Start Date | BEGDA | DATS | 8 | DATUM | ||||
| SEQNR | Number of Infotype Record with Same Key | SEQNR | NUMC | 3 | NUM03 | ||||
| LGART | Wage Type | LGART | CHAR | 4 | T512W | LGART | |||
| APPID | Assignment of data to an application | APPID | CHAR | 1 | APPID | ||||
| INNAM | User who wrote record to interface | PW_UNAME1 | CHAR | 12 | UNAME | ||||
| INSDT | Date on which record was written to interface | PW_DATUM1 | DATS | 8 | DATUM | ||||
| INTIM | Time at which record was written to interface | PW_UZEIT1 | TIMS | 6 | UZEIT | ||||
| INPGM | Write Record to Interface Report | PW_PGMID1 | CHAR | 40 | PROGNAME | ||||
| UNAME2 | Name of user who initially accessed record | PW_UNAME2 | CHAR | 12 | UNAME | ||||
| DATUM2 | Date on which record was initially accessed | PW_DATUM2 | DATS | 8 | DATUM | ||||
| UZEIT2 | Time at which record was initially accessed | PW_UZEIT2 | TIMS | 6 | UZEIT | ||||
| PGMID2 | Report used to access record initially | PW_PGMID2 | CHAR | 40 | PROGNAME | ||||
| STATU2 | Log status when record was first accessed | PW_STATU2 | CHAR | 1 | PW_STATU | ||||
| UNAME3 | Last user to access record | PW_UNAME3 | CHAR | 12 | UNAME | ||||
| DATUM3 | Date on which record was last accessed | PW_DATUM3 | DATS | 8 | DATUM | ||||
| UZEIT3 | Time at which record was last accessed | PW_UZEIT3 | TIMS | 6 | UZEIT | ||||
| PGMID3 | Last Used to Access Record Program | PW_PGMID3 | CHAR | 40 | PROGNAME | ||||
| STATU3 | Log status when record was last accessed | PW_STATU3 | CHAR | 1 | PW_STATU | ||||
| OUTNA | User who first retrieved the record successfully | PW_UNAME4 | CHAR | 12 | UNAME | ||||
| OUTDT | Date on which record was first retrieved successfully | PW_DATUM4 | DATS | 8 | DATUM | ||||
| OUTTI | Time at which record was first retrieved successfully | PW_UZEIT4 | TIMS | 6 | UZEIT | ||||
| OUTPG | Report first used to retrieve record successfully | PW_PGMID4 | CHAR | 40 | PROGNAME | ||||
| BUDAT | Posting Date | CO_BUDAT | DATS | 8 | DATUM | ||||
| STOKN | Indicator: Document Has Been Reversed | CO_STOKZ | CHAR | 1 | FLAG | ||||
| BELNR | Reference Document Number | CO_REFBN | CHAR | 10 | ALPHA | BELNR | |||
| LBLNI | Reference Organizational Units | AWORG | CHAR | 10 | AWORG | ||||
| BLPOS | Document item | HRAABPOS | NUMC | 3 | NUM3 | ||||
| BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
| GSBER | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
| KOKRS | Controlling Area | KOKRS | CHAR | 4 | TKA01 | CACCD | CAC | ||
| KOSTL | Cost Center | KOSTL | CHAR | 10 | CSKS | ALPHA | KOSTL | KOS | |
| AUFNR | Order Number | AUFNR | CHAR | 12 | AUFK | ALPHA | AUFNR | ANR | |
| KSTRG | Cost Object | KSTRG | CHAR | 12 | CKPH | KSTRG | KTR | ||
| POSNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 | PRPS | KONPR | PS_POSNR | ||
| NPLNR | Network Number for Account Assignment | NPLNR | CHAR | 12 | AUFK | ALPHA | AUFNR | NET | |
| VORNR | Operation/Activity Number | VORNR | CHAR | 4 | NUMCV | VORNR | VGN | ||
| KDAUF | Sales Order Number | KDAUF | CHAR | 10 | VBUK | ALPHA | VBELN | AUN | |
| KDPOS | Item Number in Sales Order | KDPOS | NUMC | 6 | NUM06 | KPO | |||
| PAOBJNR | Profitability Segment Number (CO-PA) | RKEOBJNR | NUMC | 10 | RKEOBJNR | ||||
| PRZNR | Business Process | CO_PRZNR | CHAR | 12 | Assigned to domain | ALPHA | CO_PRZNR | KWP | |
| FISTL | Funds Center | FISTL | CHAR | 16 | FMFCTR | FISTL | FIS | ||
| FIPOS | Commitment Item | FIPOS | CHAR | 14 | FMFPO | FIPOS | FIP | ||
| GEBER | Fund | BP_GEBER | CHAR | 10 | FMFINCODE | BP_GEBER | FIC | ||
| EBELN | Purchasing Document Number | EBELN | CHAR | 10 | EKKO | ALPHA | EBELN | BES | MEKK_C |
| EBELP | Item Number of Purchasing Document | EBELP | NUMC | 5 | EKPO | EBELP | BSP | ||
| LSTNR | Activity Number | ASNUM | CHAR | 18 | ASMD | ALPHA | ASNUM | ASN | |
| LTLST | Activity Type | LSTAR | CHAR | 6 | CSLA | LSTAR | LAR | LART_EMPTY | |
| SBUKR | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
| SGSBR | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
| SKOST | Cost Center | KOSTL | CHAR | 10 | CSKS | ALPHA | KOSTL | KOS | |
| LSTAR | Activity Type | LSTAR | CHAR | 6 | CSLA | LSTAR | LAR | LART_EMPTY | |
| EXBEL | Assignment number | HR_ZUONR | CHAR | 18 | HR_ZUONR | ||||
| MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | T007A | MWSKZ | |||
| OTYPE | Object Type | OTYPE | CHAR | 2 | T778O | OTYPE | POT | ||
| STELL | Job | STELL | NUMC | 8 | T513 | STELL | |||
| POHRS | Number of Hours for Activity Allocation/External Services | POHRS | DEC | 7(2) | PTM_DEC5_2S | ||||
| DART | Service Type (Public Service Germany) | DART | CHAR | 2 | T5D7C | DART | DAR | ||
| UDART | Service Category (Public Service Germany) | UDART | CHAR | 2 | T5D7E | UDART | UDA | ||
| SGTXT | Item Text | SGTXT | CHAR | 50 | TEXT50 | ||||
| TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | Assigned to domain | TXJCD | TXJ | ||
| FIPEX | Commitment Item | FM_FIPEX | CHAR | 24 | Assigned to domain | FM_FIPEX | FPS | ||
| FKBER | Functional Area | FKBER | CHAR | 16 | Assigned to domain | FKBER | FBE | ||
| GRANT_NBR | Grant | GM_GRANT_NBR | CHAR | 20 | ALPHA | GM_GRANT_NBR | GM_GRANT_NBR | GRANTS_GENERIC | |
| SGEBER | Sender fund | FM_SFONDS | CHAR | 10 | Assigned to domain | BP_GEBER | SENDER_FUND | ||
| SFKBER | Sending Functional Area | SFKTBER | CHAR | 16 | Assigned to domain | FKBER | |||
| SGRANT_NBR | Sender Grant | GM_GRANT_SENDER | CHAR | 20 | ALPHA | GM_GRANT_NBR | |||
| SEGMENT | Segment for Segmental Reporting | FB_SEGMENT | CHAR | 10 | Assigned to domain | ALPHA | FB_SEGMENT | ||
| SSEGMENT | Segment for Segmental Reporting | FB_SEGMENT | CHAR | 10 | Assigned to domain | ALPHA | FB_SEGMENT | ||
| BUDGET_PD | FM: Budget Period | FM_BUDGET_PERIOD | CHAR | 10 | Assigned to domain | FM_BUDGET_PERIOD | BUDPER | ||
| SBUDGET_PD | FM: Sender Budget Period | FM_SBUDGET_PERIOD | CHAR | 10 | Assigned to domain | FM_BUDGET_PERIOD | BUDPER |
| Key field | Non-key field |
How do I retrieve data from SAP table COIFT using ABAP code
The following ABAP code Example will allow you to do a basic selection on COIFT to SELECT all data from the tableDATA: WA_COIFT TYPE COIFT.
SELECT SINGLE *
FROM COIFT
INTO CORRESPONDING FIELDS OF WA_COIFT
WHERE...
How to access SAP table COIFT
Within an ECC or HANA version of SAP you can also view further information about COIFT and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects