SAP ABAP Table IMPR (Investment Program Positions)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ AIP (Package) IM capital investment prog.(master data, budget, info syst.)

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	IMPR	Table Relationship Diagram
Short Description	Investment Program Positions

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	POSNR	☑	IM_POSNR	IM_POSNR	NUMC	8	0	Position number
3	GJAHR	☐	IM_GNJHR	GJAHR	NUMC	4	0	Approval year of the investment program
4	POSID	☐	IM_POSID	IM_POSID	CHAR	24	0	Identification for an investment program position
5	ABJHR	☐	IM_ABJHR	GJAHR	NUMC	4	0	Valid From Fiscal Year
6	BIJHR	☐	IM_BIJHR	GJAHR	NUMC	4	0	Valid to fiscal year
7	PRNAM	☐	IM_PRNAM	IM_PRNAM	CHAR	8	0	Investment program name	IMTP
8	PPRIO	☐	IMA_PRIOR	NW_PRIO	CHAR	1	0	Priority of the appropriation request	TCN07
9	IZWEK	☐	IZWEK	IZWEK	CHAR	2	0	Reason for investment	T087I
10	OBJNR	☐	IM_OBJNR	J_OBJNR	CHAR	22	0	CO object number for inv. prog. position	ONR00
11	VERNR	☐	IM_VERNR	PS_VERNR	NUMC	8	0	Person responsible	TCJ04
12	VERNA	☐	IM_VERNA	PS_VERNA	CHAR	25	0	Name of person responsible
13	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
14	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
15	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
16	AEDAT	☐	UPDAT	DATUM	DATS	8	0	Date on which object was last changed
17	ERGSO	☐	IM_ERGSO	ERGSL	CHAR	10	0	IM: Balance sheet item (credit)
18	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
19	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
20	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
21	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
22	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
23	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
24	BEBER	☐	BEBER	BEBER	CHAR	3	0	Organizational Area	T357
25	TPLNR	☐	TPLNR	TPLNR	CHAR	30	0	Functional Location	IFLOT
26	XPLAN	☐	IM_XPLAN	XFELD	CHAR	1	0	- free -
27	XBUDG	☐	IM_XBUDG	XFELD	CHAR	1	0	- free -
28	PARNR	☐	IM_PARNR	IM_POSNR	NUMC	8	0	Parent position number	IMPR
29	LEFNR	☐	IM_LEFNR	IM_POSNR	NUMC	8	0	Position number left brother (in hierarchy)	IMPR
30	XAKTB	☐	IM_XAKTB	XFELD	CHAR	1	0	Budget distrib. of overall values only from prog.position
31	LOGSYV	☐	IM_LOGSYV	LOGSYS	CHAR	10	0	Logical system of the sub-tree of the investment program	TBDLS
32	RCOMP	☐	RCOMP_D	RCOMP	CHAR	6	0	Company	T880
33	SIZECL	☐	IM_SIZECL	SIZECL	CHAR	2	0	Scale of investment objects	TAIF5
34	LAND1	☐	IMA_LAND1	LAND1	CHAR	3	0	Country for Which Approp. Request Is Planned	T005
35	OWAERS	☐	IM_OWAERS	WAERS	CUKY	5	0	Object Currency of the Investment Program Item	TCURC
36	.INCLUDE	☐				0	0	Structure for include for user fields -IM-
37	USR00	☐	IMA_USR00	USRCHAR20	CHAR	20	0	User field 1 (20 characters)
38	USR01	☐	IMA_USR01	USRCHAR20	CHAR	20	0	User field 2 (20 characters)
39	USR02	☐	IMA_USR02	IMA_USRCHAR10	CHAR	10	0	User field 3 (10 characters)	TAIF9
40	USR03	☐	IMA_USR03	IMA_USRCHAR10	CHAR	10	0	User field 4 (10 characters)	TAIF9
41	USR04	☐	IMA_USR04	USRQUAN13	QUAN	13	3	User field 5 for quantity - IM
42	USE04	☐	IMA_USE04	MEINS	UNIT	3	0	User field 5 for unit for quantity field 5 - IM	T006
43	USR05	☐	IMA_USR05	USRQUAN13	QUAN	13	3	User field 6 for quantity - IM
44	USE05	☐	IMA_USE05	MEINS	UNIT	3	0	User field 6 for unit of quantity field 6 -IM-	T006
45	USR06	☐	IMA_USR06	USRCURR13	CURR	13	3	User field 7 for values - IM
46	USE06	☐	IMA_USE06	WAERS	CUKY	5	0	User field 7 for currency for user field 7	TCURC
47	USR07	☐	IMA_USR07	USRCURR13	CURR	13	3	User field 8 for values - IM
48	USE07	☐	IMA_USE07	WAERS	CUKY	5	0	User field 8 for currency for user field 8	TCURC
49	USR08	☐	IMA_USR08	USRDATE	DATS	8	0	User field 9 as date for IM
50	USR09	☐	IMA_USR09	USRDATE	DATS	8	0	User field 10 as date for IM
51	USR10	☐	IMA_USR10	XFELD	CHAR	1	0	User field 11 as indicator for IM reports
52	USR11	☐	IMA_USR11	XFELD	CHAR	1	0	User field 12 as indicator for IM reports
53	USR12	☐	IMA_USR12	USRPER	ACCP	6	0	User field 13 for period and fiscal year
54	USR13	☐	IMA_USR13	USRPER	ACCP	6	0	User field 14 for period and fiscal year
55	RHIER	☐	IM_RHIER	IM_RHIER	CHAR	1	0	Role of Position within Investment Program Hierarchy
56	.INCLU--AP	☐				0	0	Append structure for Regulatory Reporting
57	FERC_IND	☐	FE_IND	FE_IND	CHAR	4	0	Regulatory indicator	FERC_C7

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	IMPR	BEBER	T357	BEBER	REF	C	CN
2	IMPR	BUKRS	T001	BUKRS	REF	C	CN
3	IMPR	FERC_IND	FERC_C7	IND	REF
4	IMPR	GSBER	TGSB	GSBER	REF	C	CN
5	IMPR	IZWEK	T087I	IZWEK	REF	1	CN
6	IMPR	KOKRS	TKA01	KOKRS	REF	C	CN
7	IMPR	KOSTL	CSKS	KOSTL
8	IMPR	LAND1	T005	LAND1	KEY
9	IMPR	LEFNR	IMPR	POSNR
10	IMPR	LOGSYV	TBDLS	LOGSYS		C	CN
11	IMPR	MANDT	T000	MANDT	KEY	1	CN
12	IMPR	OBJNR	ONR00	OBJNR	KEY	1	C
13	IMPR	OWAERS	TCURC	WAERS
14	IMPR	PARNR	IMPR	POSNR
15	IMPR	PPRIO	TCN07	NPRIO	REF	1	CN
16	IMPR	PRCTR	CEPC	PRCTR	REF	C	CN
17	IMPR	PRNAM	IMTP	PRNAM	REF	1	CN
18	IMPR	RCOMP	T880	RCOMP
19	IMPR	SIZECL	TAIF5	SIZECL	KEY
20	IMPR	TPLNR	IFLOT	TPLNR	REF	C	CN
21	IMPR	USE04	T006	MSEHI
22	IMPR	USE05	T006	MSEHI
23	IMPR	USE06	TCURC	WAERS
24	IMPR	USE07	TCURC	WAERS
25	IMPR	USR02	TAIF9	USR02	REF	1	CN
26	IMPR	USR03	TAIF9	USR02	REF	1	CN
27	IMPR	VERNR	TCJ04	VERNR	REF	C	CN
28	IMPR	WERKS	T001W	WERKS	REF	C	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in