SAP Table IMPR
Investment Program Positions
IMPR (Investment Program Positions) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link IMPR to other SAP tables.
IMPR table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||
| POSNR | Position number | IM_POSNR | NUMC | 8 | 0 | |||||||||
| GJAHR | Approval year of the investment program | IM_GNJHR | NUMC | 4 | 0 | |||||||||
| POSID | Identification for an investment program position | IM_POSID | CHAR | 24 | 0 | |||||||||
| ABJHR | Valid From Fiscal Year | IM_ABJHR | NUMC | 4 | 0 | |||||||||
| BIJHR | Valid to fiscal year | IM_BIJHR | NUMC | 4 | 0 | |||||||||
| PRNAM | Investment program name | IM_PRNAM | IMTP | CHAR | 8 | 0 | ||||||||
| PPRIO | Priority of the appropriation request | IMA_PRIOR | TCN07 | CHAR | 1 | 0 | ||||||||
| IZWEK | Reason for investment | IZWEK | T087I | CHAR | 2 | 0 | ||||||||
| OBJNR | CO object number for inv. prog. position | IM_OBJNR | ONR00 | CHAR | 22 | 0 | ||||||||
| VERNR | Person responsible | IM_VERNR | TCJ04 | NUMC | 8 | 0 | ||||||||
| VERNA | Name of person responsible | IM_VERNA | CHAR | 25 | 0 | |||||||||
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | 0 | |||||||||
| ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | 0 | |||||||||
| AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | 0 | |||||||||
| AEDAT | Date on which object was last changed | UPDAT | DATS | 8 | 0 | |||||||||
| ERGSO | IM: Balance sheet item (credit) | IM_ERGSO | CHAR | 10 | 0 | |||||||||
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 | 0 | ||||||||
| GSBER | Business Area | GSBER | TGSB | CHAR | 4 | 0 | ||||||||
| KOKRS | Controlling Area | KOKRS | TKA01 | CHAR | 4 | 0 | ||||||||
| KOSTL | Cost Center | KOSTL | CSKS | CHAR | 10 | 0 | ||||||||
| WERKS | Plant | WERKS_D | T001W | CHAR | 4 | 0 | ||||||||
| PRCTR | Profit Center | PRCTR | CEPC | CHAR | 10 | 0 | ||||||||
| BEBER | Plant section | BEBER | T357 | CHAR | 3 | 0 | ||||||||
| TPLNR | Functional Location | TPLNR | IFLOT | CHAR | 30 | 0 | ||||||||
| XPLAN | - free - | IM_XPLAN | CHAR | 1 | 0 |
Possible values
|
||||||||
| XBUDG | - free - | IM_XBUDG | CHAR | 1 | 0 |
Possible values
|
||||||||
| PARNR | Parent position number | IM_PARNR | IMPR | NUMC | 8 | 0 | ||||||||
| LEFNR | Position number left brother (in hierarchy) | IM_LEFNR | IMPR | NUMC | 8 | 0 | ||||||||
| XAKTB | Budget distrib. of overall values only from prog.position | IM_XAKTB | CHAR | 1 | 0 |
Possible values
|
||||||||
| LOGSYV | Logical system of the sub-tree of the investment program | IM_LOGSYV | TBDLS | CHAR | 10 | 0 | ||||||||
| RCOMP | Company | RCOMP_D | T880 | CHAR | 6 | 0 | ||||||||
| SIZECL | Scale of investment objects | IM_SIZECL | TAIF5 | CHAR | 2 | 0 | ||||||||
| LAND1 | Country for Which Approp. Request Is Planned | IMA_LAND1 | T005 | CHAR | 3 | 0 | ||||||||
| OWAERS | Object Currency of the Investment Program Item | IM_OWAERS | TCURC | CUKY | 5 | 0 | ||||||||
| USR00 | User field 1 (20 characters) | IMA_USR00 | CHAR | 20 | 0 | |||||||||
| USR01 | User field 2 (20 characters) | IMA_USR01 | CHAR | 20 | 0 | |||||||||
| USR02 | User field 3 (10 characters) | IMA_USR02 | TAIF9 | CHAR | 10 | 0 | ||||||||
| USR03 | User field 4 (10 characters) | IMA_USR03 | TAIF9 | CHAR | 10 | 0 | ||||||||
| USR04 | User field 5 for quantity - IM | IMA_USR04 | QUAN | 13 | 3 | |||||||||
| USE04 | User field 5 for unit for quantity field 5 - IM | IMA_USE04 | T006 | UNIT | 3 | 0 | ||||||||
| USR05 | User field 6 for quantity - IM | IMA_USR05 | QUAN | 13 | 3 | |||||||||
| USE05 | User field 6 for unit of quantity field 6 -IM- | IMA_USE05 | T006 | UNIT | 3 | 0 | ||||||||
| USR06 | User field 7 for values - IM | IMA_USR06 | CURR | 13 | 3 | |||||||||
| USE06 | User field 7 for currency for user field 7 | IMA_USE06 | TCURC | CUKY | 5 | 0 | ||||||||
| USR07 | User field 8 for values - IM | IMA_USR07 | CURR | 13 | 3 | |||||||||
| USE07 | User field 8 for currency for user field 8 | IMA_USE07 | TCURC | CUKY | 5 | 0 | ||||||||
| USR08 | User field 9 as date for IM | IMA_USR08 | DATS | 8 | 0 | |||||||||
| USR09 | User field 10 as date for IM | IMA_USR09 | DATS | 8 | 0 | |||||||||
| USR10 | User field 11 as indicator for IM reports | IMA_USR10 | CHAR | 1 | 0 |
Possible values
|
||||||||
| USR11 | User field 12 as indicator for IM reports | IMA_USR11 | CHAR | 1 | 0 |
Possible values
|
||||||||
| USR12 | User field 13 for period and fiscal year | IMA_USR12 | ACCP | 6 | 0 | |||||||||
| USR13 | User field 14 for period and fiscal year | IMA_USR13 | ACCP | 6 | 0 | |||||||||
| RHIER | Role of Position within Investment Program Hierarchy | IM_RHIER | CHAR | 1 | 0 |
Possible values
|
||||||||
| FERC_IND | Regulatory indicator | FE_IND | FERC_C7 | CHAR | 4 | 0 | ||||||||
IMPR foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| IMPR | BEBER | IMPR | MANDT | T357 | Plant Section | MANDT |
| IMPR | BEBER | IMPR | WERKS | T357 | Plant Section | WERKS |
| IMPR | BEBER | IMPR | BEBER | T357 | Plant Section | BEBER |
| IMPR | BUKRS | IMPR | BUKRS | T001 | Company Codes | BUKRS |
| IMPR | BUKRS | IMPR | MANDT | T001 | Company Codes | MANDT |
| IMPR | FERC_IND | IMPR | MANDT | FERC_C7 | Regulatory indicators | MANDT |
| IMPR | FERC_IND | IMPR | FERC_IND | FERC_C7 | Regulatory indicators | IND |
| IMPR | GSBER | IMPR | MANDT | TGSB | Business Areas | MANDT |
| IMPR | GSBER | IMPR | GSBER | TGSB | Business Areas | GSBER |
| IMPR | IZWEK | IMPR | MANDT | T087I | Reason for investment | MANDT |
| IMPR | IZWEK | IMPR | IZWEK | T087I | Reason for investment | IZWEK |
| IMPR | KOKRS | IMPR | MANDT | TKA01 | Controlling Areas | MANDT |
| IMPR | KOKRS | IMPR | KOKRS | TKA01 | Controlling Areas | KOKRS |
| IMPR | KOSTL | * | CSKS | Cost Center Master Data | DATBI | |
| IMPR | KOSTL | IMPR | MANDT | CSKS | Cost Center Master Data | MANDT |
| IMPR | KOSTL | IMPR | KOKRS | CSKS | Cost Center Master Data | KOKRS |
| IMPR | KOSTL | IMPR | KOSTL | CSKS | Cost Center Master Data | KOSTL |
| IMPR | LAND1 | IMPR | MANDT | T005 | Countries | MANDT |
| IMPR | LAND1 | IMPR | LAND1 | T005 | Countries | LAND1 |
| IMPR | LEFNR | IMPR | MANDT | IMPR | Investment Program Positions | MANDT |
| IMPR | LEFNR | IMPR | LEFNR | IMPR | Investment Program Positions | POSNR |
| IMPR | LOGSYV | IMPR | LOGSYV | TBDLS | Logical system | LOGSYS |
| IMPR | MANDT | IMPR | MANDT | T000 | Clients | MANDT |
| IMPR | OBJNR | IMPR | MANDT | ONR00 | General Object Number | MANDT |
| IMPR | OBJNR | IMPR | OBJNR | ONR00 | General Object Number | OBJNR |
| IMPR | OWAERS | IMPR | MANDT | TCURC | Currency Codes | MANDT |
| IMPR | OWAERS | IMPR | OWAERS | TCURC | Currency Codes | WAERS |
| IMPR | PARNR | IMPR | MANDT | IMPR | Investment Program Positions | MANDT |
| IMPR | PARNR | IMPR | PARNR | IMPR | Investment Program Positions | POSNR |
| IMPR | PPRIO | IMPR | MANDT | TCN07 | Priority | MANDT |
| IMPR | PPRIO | IMPR | PPRIO | TCN07 | Priority | NPRIO |
| IMPR | PRCTR | * | CEPC | Profit Center Master Data Table | DATBI | |
| IMPR | PRCTR | * | CEPC | Profit Center Master Data Table | KOKRS | |
| IMPR | PRCTR | IMPR | MANDT | CEPC | Profit Center Master Data Table | MANDT |
| IMPR | PRCTR | IMPR | PRCTR | CEPC | Profit Center Master Data Table | PRCTR |
| IMPR | PRNAM | IMPR | GJAHR | IMTP | Investment programs | GJAHR |
| IMPR | PRNAM | IMPR | MANDT | IMTP | Investment programs | MANDT |
| IMPR | PRNAM | IMPR | PRNAM | IMTP | Investment programs | PRNAM |
| IMPR | RCOMP | IMPR | MANDT | T880 | Global Company Data (for KONS Ledger) | MANDT |
| IMPR | RCOMP | IMPR | RCOMP | T880 | Global Company Data (for KONS Ledger) | RCOMP |
| IMPR | SIZECL | IMPR | MANDT | TAIF5 | Scale of investment objects | MANDT |
| IMPR | SIZECL | IMPR | SIZECL | TAIF5 | Scale of investment objects | SIZECL |
| IMPR | TPLNR | IMPR | MANDT | IFLOT | Functional Location (Table) | MANDT |
| IMPR | TPLNR | IMPR | TPLNR | IFLOT | Functional Location (Table) | TPLNR |
| IMPR | USE04 | SYST | MANDT | T006 | Units of Measurement | MANDT |
| IMPR | USE04 | IMPR | USE04 | T006 | Units of Measurement | MSEHI |
| IMPR | USE05 | SYST | MANDT | T006 | Units of Measurement | MANDT |
| IMPR | USE05 | IMPR | USE05 | T006 | Units of Measurement | MSEHI |
| IMPR | USE06 | IMPR | USE06 | TCURC | Currency Codes | WAERS |
| IMPR | USE06 | SYST | MANDT | TCURC | Currency Codes | MANDT |
| IMPR | USE07 | SYST | MANDT | TCURC | Currency Codes | MANDT |
| IMPR | USE07 | IMPR | USE07 | TCURC | Currency Codes | WAERS |
| IMPR | USR02 | SY | MANDT | TAIF9 | Value table for user fields | MANDT |
| IMPR | USR02 | '1' | TAIF9 | Value table for user fields | USRNR | |
| IMPR | USR02 | IMPR | USR02 | TAIF9 | Value table for user fields | USR02 |
| IMPR | USR03 | SY | MANDT | TAIF9 | Value table for user fields | MANDT |
| IMPR | USR03 | '2' | TAIF9 | Value table for user fields | USRNR | |
| IMPR | USR03 | IMPR | USR03 | TAIF9 | Value table for user fields | USR02 |
| IMPR | VERNR | IMPR | MANDT | TCJ04 | Person in Responsible for Project | MANDT |
| IMPR | VERNR | IMPR | VERNR | TCJ04 | Person in Responsible for Project | VERNR |
| IMPR | WERKS | IMPR | MANDT | T001W | Plants/Branches | MANDT |
| IMPR | WERKS | IMPR | WERKS | T001W | Plants/Branches | WERKS |
