IMPR SAP (Investment Program Positions) Table details

Dictionary Type: Table
Description: Investment Program Positions




ABAP Code to SELECT data from IMPR
Related tables to IMPR
Access table IMPR




Table field list including key, data, relationships and ABAP select examples

IMPR is a standard SAP Table which is used to store Investment Program Positions data and is available within R/3 SAP systems 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. .

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

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
POSNRPosition number IM_POSNRNUMC8POSNRIM_POSNR
GJAHRApproval year of the investment program IM_GNJHRNUMC4GJAHRGJAHRGJR
POSIDIdentification for an investment program position IM_POSIDCHAR24POSIDIM_POSIDIMP
ABJHRValid From Fiscal Year IM_ABJHRNUMC4GJAHRGJAHR
BIJHRValid to fiscal year IM_BIJHRNUMC4GJAHRGJAHR
PRNAMInvestment program name IM_PRNAMCHAR8IMTPIM_PRNAMIMT
PPRIOPriority of the appropriation request IMA_PRIORCHAR1TCN07NW_PRIO
IZWEKReason for investment IZWEKCHAR2T087IIZWEK
OBJNRCO object number for inv. prog. position IM_OBJNRCHAR22ONR00J_OBJNR
VERNRPerson responsible IM_VERNRNUMC8TCJ04PS_VERNR
VERNAName of person responsible IM_VERNACHAR25PS_VERNASH_IM_VERNA
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
ERDATDate on Which Record Was Created ERDATDATS8DATUM
AENAMName of Person Who Changed Object AENAMCHAR12USNAM
AEDATDate on which object was last changed UPDATDATS8DATUM
ERGSOIM: Balance sheet item (credit) IM_ERGSOCHAR10ERGSL
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
GSBERBusiness Area GSBERCHAR4TGSBGSBERGSB
KOKRSControlling Area KOKRSCHAR4TKA01CACCDCAC
KOSTLCost Center KOSTLCHAR10CSKSALPHAKOSTLKOS
WERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
PRCTRProfit Center PRCTRCHAR10CEPCALPHAPRCTRPRCPRCTR_EMPTY
BEBERPlant section BEBERCHAR3T357BEBERBBE
TPLNRFunctional Location TPLNRCHAR30IFLOTTPLNRTPLNRIFLIFLM
XPLAN- free - IM_XPLANCHAR1XFELD
XBUDG- free - IM_XBUDGCHAR1XFELD
PARNRParent position number IM_PARNRNUMC8IMPRPOSNRIM_POSNR
LEFNRPosition number left brother (in hierarchy) IM_LEFNRNUMC8IMPRPOSNRIM_POSNR
XAKTBBudget distrib. of overall values only from prog.position IM_XAKTBCHAR1XFELD
LOGSYVLogical system of the sub-tree of the investment program IM_LOGSYVCHAR10TBDLSALPHALOGSYS
RCOMPCompany RCOMP_DCHAR6T880ALPHARCOMPGCC
SIZECLScale of investment objects IM_SIZECLCHAR2TAIF5ALPHASIZECL
LAND1Country for Which Approp. Request Is Planned IMA_LAND1CHAR3T005LAND1
OWAERSObject Currency of the Investment Program Item IM_OWAERSCUKY5TCURCWAERS
USR00User Field 01 (20 characters) IMA_USR00CHAR20USRCHAR20
USR01User field 2 (20 characters) IMA_USR01CHAR20USRCHAR20
USR02User field 3 (10 characters) IMA_USR02CHAR10TAIF9IMA_USRCHAR10
USR03User field 4 (10 characters) IMA_USR03CHAR10TAIF9IMA_USRCHAR10STAIF9_2
USR04User field 5 for quantity - IM IMA_USR04QUAN13(3) USRQUAN13
USE04User field 5 for unit for quantity field 5 - IM IMA_USE04UNIT3T006CUNITMEINS
USR05User field 6 for quantity - IM IMA_USR05QUAN13(3) USRQUAN13
USE05User field 6 for unit of quantity field 6 -IM- IMA_USE05UNIT3T006CUNITMEINS
USR06User field 7 for values - IM IMA_USR06CURR13(3) USRCURR13
USE06User field 7 for currency for user field 7 IMA_USE06CUKY5TCURCWAERS
USR07User field 8 for values - IM IMA_USR07CURR13(3) USRCURR13
USE07User field 8 for currency for user field 8 IMA_USE07CUKY5TCURCWAERS
USR08WB milestone date for IM IMA_USR08DATS8USRDATE
USR09User field 10 as date for IM IMA_USR09DATS8USRDATE
USR10So far so Good indicator for IM reports IMA_USR10CHAR1XFELD
USR11User field 12 as indicator for IM reports IMA_USR11CHAR1XFELD
USR12User field 13 for period and fiscal year IMA_USR12ACCP6USRPER
USR13User field 14 for period and fiscal year IMA_USR13ACCP6USRPER
RHIERRole of Position within Investment Program Hierarchy IM_RHIERCHAR1IM_RHIER
.INCLU--AP 0
FERC_INDRegulatory indicator FE_INDCHAR4FERC_C7ALPHAFE_IND

Key field Non-key field



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).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!