SAP IMPR Investment Program Positions Table data and field list

IMPR is a standard SAP Table which is used to store Investment Program Positions data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The IMPR table consists of various fields, each holding specific information or linking keys about Investment Program Positions data available in SAP. These include POSNR (Position number), GJAHR (Approval year of the investment program), POSID (Identification for an investment program position), ABJHR (Valid From Fiscal Year)... 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. .

IMPR table Technical Details:

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)

Text table = IMPU

SAP IMPR table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the IMPR table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
MANDT	Client	MANDT	CLNT	3	T000		MANDT
POSNR	Position number	IM_POSNR	NUMC	8		POSNR	IM_POSNR
GJAHR	Approval year of the investment program	IM_GNJHR	NUMC	4		GJAHR	GJAHR	GJR
POSID	Identification for an investment program position	IM_POSID	CHAR	24		POSID	IM_POSID	IMP
ABJHR	Valid From Fiscal Year	IM_ABJHR	NUMC	4		GJAHR	GJAHR
BIJHR	Valid to fiscal year	IM_BIJHR	NUMC	4		GJAHR	GJAHR
PRNAM	Investment program name	IM_PRNAM	CHAR	8	IMTP		IM_PRNAM	IMT
PPRIO	Priority of the appropriation request	IMA_PRIOR	CHAR	1	TCN07		NW_PRIO
IZWEK	Reason for investment	IZWEK	CHAR	2	T087I		IZWEK
OBJNR	CO object number for inv. prog. position	IM_OBJNR	CHAR	22	ONR00		J_OBJNR
VERNR	Person responsible	IM_VERNR	NUMC	8	TCJ04		PS_VERNR
VERNA	Name of person responsible	IM_VERNA	CHAR	25			PS_VERNA		SH_IM_VERNA
ERNAM	Name of Person who Created the Object	ERNAM	CHAR	12			USNAM
ERDAT	Date on Which Record Was Created	ERDAT	DATS	8			DATUM
AENAM	Name of Person Who Changed Object	AENAM	CHAR	12			USNAM
AEDAT	Date on which object was last changed	UPDAT	DATS	8			DATUM
ERGSO	IM: Balance sheet item (credit)	IM_ERGSO	CHAR	10			ERGSL
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
WERKS	Plant	WERKS_D	CHAR	4	T001W		WERKS	WRK	H_T001W_C
PRCTR	Profit Center	PRCTR	CHAR	10	CEPC	ALPHA	PRCTR	PRC	PRCTR_EMPTY
BEBER	Plant section	BEBER	CHAR	3	T357		BEBER	BBE
TPLNR	Functional Location	TPLNR	CHAR	30	IFLOT	TPLNR	TPLNR	IFL	IFLM
XPLAN	- free -	IM_XPLAN	CHAR	1			XFELD
XBUDG	- free -	IM_XBUDG	CHAR	1			XFELD
PARNR	Parent position number	IM_PARNR	NUMC	8	IMPR	POSNR	IM_POSNR
LEFNR	Position number left brother (in hierarchy)	IM_LEFNR	NUMC	8	IMPR	POSNR	IM_POSNR
XAKTB	Budget distrib. of overall values only from prog.position	IM_XAKTB	CHAR	1			XFELD
LOGSYV	Logical system of the sub-tree of the investment program	IM_LOGSYV	CHAR	10	TBDLS	ALPHA	LOGSYS
RCOMP	Company	RCOMP_D	CHAR	6	T880	ALPHA	RCOMP	GCC
SIZECL	Scale of investment objects	IM_SIZECL	CHAR	2	TAIF5	ALPHA	SIZECL
LAND1	Country for Which Approp. Request Is Planned	IMA_LAND1	CHAR	3	T005		LAND1
OWAERS	Object Currency of the Investment Program Item	IM_OWAERS	CUKY	5	TCURC		WAERS
USR00	User Field 01 (20 characters)	IMA_USR00	CHAR	20			USRCHAR20
USR01	User field 2 (20 characters)	IMA_USR01	CHAR	20			USRCHAR20
USR02	User field 3 (10 characters)	IMA_USR02	CHAR	10	TAIF9		IMA_USRCHAR10
USR03	User field 4 (10 characters)	IMA_USR03	CHAR	10	TAIF9		IMA_USRCHAR10		STAIF9_2
USR04	User field 5 for quantity - IM	IMA_USR04	QUAN	13(3)			USRQUAN13
USE04	User field 5 for unit for quantity field 5 - IM	IMA_USE04	UNIT	3	T006	CUNIT	MEINS
USR05	User field 6 for quantity - IM	IMA_USR05	QUAN	13(3)			USRQUAN13
USE05	User field 6 for unit of quantity field 6 -IM-	IMA_USE05	UNIT	3	T006	CUNIT	MEINS
USR06	User field 7 for values - IM	IMA_USR06	CURR	13(3)			USRCURR13
USE06	User field 7 for currency for user field 7	IMA_USE06	CUKY	5	TCURC		WAERS
USR07	User field 8 for values - IM	IMA_USR07	CURR	13(3)			USRCURR13
USE07	User field 8 for currency for user field 8	IMA_USE07	CUKY	5	TCURC		WAERS
USR08	WB milestone date for IM	IMA_USR08	DATS	8			USRDATE
USR09	User field 10 as date for IM	IMA_USR09	DATS	8			USRDATE
USR10	So far so Good indicator for IM reports	IMA_USR10	CHAR	1			XFELD
USR11	User field 12 as indicator for IM reports	IMA_USR11	CHAR	1			XFELD
USR12	User field 13 for period and fiscal year	IMA_USR12	ACCP	6			USRPER
USR13	User field 14 for period and fiscal year	IMA_USR13	ACCP	6			USRPER
RHIER	Role of Position within Investment Program Hierarchy	IM_RHIER	CHAR	1			IM_RHIER
.INCLU--AP				0
FERC_IND	Regulatory indicator	FE_IND	CHAR	4	FERC_C7	ALPHA	FE_IND

Key field

Non-key field

< IMPORT_CHECKLIST_DATA_OUT_DOC - Proxy Structure (Generated) IMPR_FILE - Transfer structure for cap. investment programs >

How do I retrieve data from SAP table IMPR using ABAP code

The following ABAP code Example will allow you to do a basic selection on IMPR to SELECT all data from the table
DATA: WA_IMPR TYPE IMPR.

SELECT SINGLE *
FROM IMPR
INTO CORRESPONDING FIELDS OF WA_IMPR
WHERE...

How to access SAP table IMPR

Within an ECC or HANA version of SAP you can also view further information about IMPR and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).

Related SAP tables and the relationships to IMPR

    STREENODE - Description of a Hierarchy Node
        RAIPATTR - Attributes for item, measure or appropriation req.
    PRPS - PSP (project structure plan) element master data
    IMAK - Appropriation requests - general data
        RIMAKPGES - Appropriation request: Percentage distribution (t)
        RAIPWI - Key figs for preinvestment analysis per plan ver.
        RAIPPASC - Data for partner determination procedure
        AUFKV_REQ - Order for appropriation request
        PROJ_REQ - Project definition for appropriation request
            PRPS_REQ - WBS element for appropriation request
        RIPASW - Values for Reporting for Programs
        BPGE_IM - Budgeting/planning: total values
        BPJA_IM - Budgeting/planning: annual values
        RAIMACT - Actual values
        IMTP - Investment programs
            IMPR - Investment Program Positions
                AUFKV - Table Generated for View AUFKV
                PROJ - Project definition

    ARKOPF - Archiving run header data
        VSKOPF - Version: Header - general data for a
    VBUP - Sales Document: Item Status
    CKIP1 - Periodic Values for Unit Costing Item
    COSP1 - CO Object: Cost Totals for External Postings
        COVP11 - CO object: Line items with doc. header (by period)
            COEPD11 - CO object: Unvaluated ln. item settlement w/status
                COEPBR11 - CO Object: Valuated Line Item Settlement
        COVJ11 - CO object: Line items with doc header (by year)
        COVO1 - CO Object: Open Items for Line Items (w/o doc.Hdr)
    COSPD1 - CO object: External cost totals - calculated
    COSPP - Transfer of Order in the COSP Table to the Project
    COKS1 - CO Object: Control Data for Secondary Planning
    VBKDPO - Sales document: Business item data (POSNR > 0)
    HEAD13 - SAPscript: Text Header
        LINE13 - SAPscript: Text Lines
    COSS1 - CO Object: Cost Totals for Internal Postings
        COVP12 - CO object: Line items with doc. header (by period)
            COEPD12 - CO object: Unvaluated ln. item settlement w/status
                COEPBR12 - CO Object: Valuated Line Item Settlement
        COVJ12 - CO object: Line items with doc header (by year)
        COVO12 - CO object: Fxd price agreement commitment ln items
    COSSD1 - CO object: Internal cost totals - calculated
    COSSP - Transfer of the Order COSS Table to the Project
    FPLA - Billing plan
    COKR1 - CO Object: Control Data for Statistical Key Figs
        HEAD14 - SAPscript: Text Header
            LINE14 - SAPscript: Text Lines
    COSR1 - CO Object: Statistical Key Figure Totals
        COVPR1 - CO object: Stat. key figure line items by period
        COVJR1 - CO object: Line items stat. key figures (by year)
    COSL1 - CO Object: Activity Type Totals
        COVPL1 - CO object: Activity type line items by period
        COVJL1 - CO object: Line items for acty types (by year)
    COSLD - CO object: Activity type sums - calculated
    FPLT - Billing Plan: Dates
    COSB1 - CO Object: Total Variances/Results Analyses
        COVPB1 - CO object: Variance/accrual line items by period
    COSBD1 - CO object: Sums of variance/accrual - calculated
    ANIA1 - Depr. simulation for invest. projects
        ANIB1 - Invest. projects: Depr. simulation analysis report
    ANLI1 - Link table for capital investment measure -> AuC
    FMSU1 - FM totals records for financial data
        COVFP1 - CO object: Financial data line items with doc. hdr
    TPI031 - CO Objects: Date of Last Interest Run
    EKKO - Purchasing Document Header
    PSDYVB - LDB PSJ: Dummy structure under VBAP
    EKPO - Purchasing Document Item
        EKET - Scheduling Agreement Schedule Lines
        EKKN - Account Assignment in Purchasing Document
        EKBE - Purchasing Document History
    EBAN - Purchase requisition
        EBKN - Purchase Requisition Account Assignment
    FPLAPS - Billing plan for PSP network plan
        FPLTPS - Billing plan for PSP/network (dates)
    LIKP - SD Document: Delivery Header Data
        LIPS - SD document: Delivery: Item data
    PSDYVK - LDB PSJ: Dummy structure under VBAK
    PSMERK - Characteristics for summarization wo.classificatn
    DRAD - Document-object link
    PRPS_R - Project Hierarchy Reporting Structure
        PRTE - Scheduling Data for Project Item
        PSMLST - Milestone I/O Table
        PSTX - PS Texts (Header)
    RSTHIE - BRST structure of the hierarchy table
        PLAF - Planned order
        PSMERK_PRPS - Characteristics for Summarization for WBS Elements
    KBED04 - Capacity Requirement Recs for Planned Orders (LDB)
    RESB04 - Reservation/dependent reqs for plan order (LDB)
        PSDYPR - LDB PSJ: Dummy structure under PRPS_R
    AUFK - Order master data
        AFKO - Order Header Data PP Orders
            AFPO - Order Item
            AFFL - Work order sequence
                ACT01 - Activity for LDB 01
    PSDYRH - LDB PSJ: Dummy structure under RSTHIE
    AFAB01 - Network Relationship (for LDB) - 01
    MLSTD - Milestone I/O Table
    PSTX1 - PS Texts (Header) for Activity (1)
    AFFH01 - Order PRT Data (for LDB) - 01
    KBED01 - Capacity Requirement Records (for LDB) - 01
        KBEZ - Additional data for table KBED (for ind.req/split)
            KPER - Additional data for KBEZ (person split in days)
        AFRU02 - Order Confirmations (for LDB) -02
    RESB01 - Reservation/Dependent Requirement for LDB-01
        PSDYOK - LDB PSJ: Dummy structure under RESB01
    PROJ - Project definition
    AFRU01 - Order Confirmations (for LDB) - 01
    PSMERK_ACT - Charactersitics for Summarization for Activity
    PSDYNV - LDB PSJ: Dummy structure under ACT01
        AFIH - Maintenance order header
        PSDYNP - LDB PSJ: Dummy structure under AUFK
    IMTP - Investment programs
        IMPR - Investment Program Positions
            PSDYIP - LDB PSJ: Dummy structure under IMPR
        PSDYPG - LDB PSJ: Dummy structure under IMTP
    PEGOB - Peg (master data of the CO object)
    PSDYPD - LDB PSJ: Dummy structure under PROJ
    PEGQTY - Assigned pegging object quantities
    PSDYPEG - LDB PSJ: Dummy Structure Under PEGOB
    ELM_PS - Additional data for hierarchy nodes (LDB PSJ)
        JSTO - Status object information
            PSTAT - Condensed status display
            JCDO - Change Documents for Status Object (Table JSTO)
            JEST - Individual Status per Object
                JCDS - Change docs. for system/user status (table JEST)
        ONR00 - General Object Number
            RPSCO1 - Summarization Table for Project Reporting
    VBAK - Sales Document: Header Data
            RPSQT - Summarization table for project reporting (quants)
            EV_PARAM - Object parameters for earned value analysis
            EV_POC - Earned value analysis: percentage of completion
            EV_VAL - Earned value analysis: earned value
            COBRA - Settlement Rule for Order Settlement
                COBRB - Distribution rules for sett. rule for order sett.
            BPHI1 - Cross-hierarchy data Control
            BPTR1 - Object Data Control
                BPGE1 - Totals record total value Control
                    BPVG1 - Table Generated for View BPVG1
    VBUK - Sales Doc.: Header Status and Administrative Data
                    BKHS1 - Header - Unit Costing (Control + Totals)
                        HEAD10 - SAPscript: Text Header
                            LINE10 - SAPscript: Text Lines
                        BKHT1 - Texts for CKHS
                        BKIS1 - Individual calculation/verification item gen.
                            BKIT1 - Texts for CKIS
                        BKIP1 - Periodic Values for Unit Costing Item
                BPJA1 - Totals record for total year value Control
                    BPVJ1 - Table Generated for View BPVJ1
                    BKHS2 - Header - Unit Costing (Control + Totals)
    VBKD - Sales Document: Business Data
    HEAD20 - SAPscript: Text Header
        LINE20 - SAPscript: Text Lines
    BKHT2 - Texts for CKHS
    BKIS2 - Individual calculation/verification item gen.
        BKIT2 - Texts for CKIS
    BKIP2 - Periodic Values for Unit Costing Item
                BPPE1 - Totals Record for Period Values Control
                    BPVP1 - Table Generated for View BPVP1
                BPIG1 - Budget Object Index (Overall Budget)
                BPIJ1 - Budget Object Index (Annual Budget)
    VBAP - Sales Document: Item Data
            COKA1 - CO Object: Cost Element Control Data
            COKP1 - CO Object: Primary Planning Control Data
                HEAD11 - SAPscript: Text Header
                    LINE11 - SAPscript: Text Lines
                CKHS1 - Header - Unit Costing (Control + Totals)
                    CKHT1 - Texts for CKHS
                    HEAD12 - SAPscript: Text Header
                        LINE12 - SAPscript: Text Lines
                    CKIS1 - Individual calculation/verification item gen.
                        CKIT1 - Texts for CKIS