SAP ABAP Table IMPR_FILE (Transfer structure for cap. investment programs)

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	INTTAB	Structure
Structure	IMPR_FILE	Table Relationship Diagram
Short Description	Transfer structure for cap. investment programs

Delivery and Maintenance

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

History

Last changed by/on	SAP	20110901
SAP Release Created in