SAP ABAP Table RIPASP (Inv.program drilldowns: Structure for data transfer)

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	RIPASP	Table Relationship Diagram
Short Description	Inv.program drilldowns: Structure for data transfer

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	.INCLUDE	☐				0	0	Investment Program Drilldown: Selection fields
2	PRNAM	☐	IM_PRNAM	IM_PRNAM	CHAR	8	0	Investment program name	IMTP
3	AB_POSNR	☐	IM_ABPOSNR	IM_POSNR	NUMC	8	0	Cap. inv. program: Number of point of entry position	IMPR
4	GNJHR	☐	IM_GNJHR	GJAHR	NUMC	4	0	Approval year of the investment program
5	ACTFY	☐	IM_ACTFY	GJAHR	NUMC	4	0	From fiscal year for selection of actual values
6	ACTFP	☐	IM_ACTFP	IM_ACTPER	NUMC	3	0	From period for selection of actual values
7	ACTTY	☐	IM_ACTTY	GJAHR	NUMC	4	0	To fiscal year for selection of actual values
8	ACTTP	☐	IM_ACTTP	IM_ACTPER	NUMC	3	0	To period for selection of actual values
9	STATSEL	☐	IM_STATSEL	SELID	CHAR	7	0	Status selection profile (measures/approp. requests)	TJ48
10	REPCUR	☐	IM_REPCUR	WAERS	CUKY	5	0	Report Currency	TCURC
11	.INCLUDE	☐				0	0	Inv. prog. drilldowns: Characteristics specifiying key figs.
12	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
13	WRTTP	☐	CO_WRTTP	CO_WRTTP	CHAR	2	0	Value Type
14	VERSN	☐	IM_PVERSN	COVERSI	CHAR	3	0	Version	TAIF2
15	VALUTYP	☐	VALUTYP	VALUTYP	NUMC	1	0	Valuation View
16	IPPOS	☐	IM_IPPOS	IM_IPPOS	CHAR	10	0	Budget Category in Investment Program	TAI08
17	TRGKZ	☐	IM_TRGKZ	BP_TRGKZ	CHAR	1	0	Indicator: Capital investment program new / old
18	VORGA	☐	J_VORGANG	J_VORGANG	CHAR	4	0	Business Transaction	*
19	USERVAL	☐	IM_USERVAL	IM_USERVAL	CHAR	4	0	Identification for user value field IM
20	.INCLUDE	☐				0	0	Investment program drilldowns: Key figures
21	WGP	☐	IM_WGP	WERTV8	CURR	15	2	Overall Value in Reporting Currency
22	WGPV	☐	IM_WGPV	WERTV8	CURR	15	2	Distributable Overall Value in Reporting Currency
23	WJP	☐	IM_WJP	WERTV8	CURR	15	2	Annual Value in Reporting Currency
24	WJPV	☐	IM_WJPV	WERTV8	CURR	15	2	Distributable Annual Value in Reporting Currency
25	EWGP	☐	IM_EWGP	WERTV8	CURR	15	2	Total Expected Value in Reporting Currency
26	EWJP	☐	IM_EWJP	WERTV8	CURR	15	2	Annual Expected Value in Reporting Currency
27	KAPWRT	☐	IMA_KAPWRT	WERTV8	CURR	15	2	Net present value of app. request variant in CO area curr.
28	IZFUS	☐	IMA_IZFUS	DECV3_2	DEC	5	2	Internal rate of return from preinvestment analysis
29	AMORT	☐	IMA_AMORT	IMA_AMORT	DEC	7	3	Payback period for appropriation requests
30	.INCLUDE	☐				0	0	Inv. Prog. Drilldowns: Characteristics for Master Data
31	HIEOBJ	☐	IM_HIEOBJ	IM_HIEOBJ	CHAR	30	0	Inv. programs: Hierarchy object (report formatting)
32	POSNR	☐	IM_POSNR	IM_POSNR	NUMC	8	0	Position number	IMPR
33	LEAF_POSNR	☐	IM_POSNRLF	IM_POSNR	NUMC	8	0	Position number of an end node of an investment program	IMPR
34	REQ_POSNR	☐	IMA_POSNR	IMA_POSNR	CHAR	12	0	Internal number for appropriation request	IMAK
35	MEASURE	☐	IM_MEASURE	J_OBJNREXT	CHAR	22	0	Measure (for an investment program or an approp. request
36	PS_POSID	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
37	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
38	CONGR	☐	IM_CONGR	FC_CONGR	CHAR	18	0	Consolidation group	TF180
39	RCOMP	☐	RCOMP_D	RCOMP	CHAR	6	0	Company	T880
40	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
41	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
42	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
43	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
44	KOSTL	☐	IMA_AKOSTL	KOSTL	CHAR	10	0	Requesting cost center	CSKS
45	VKOSTL	☐	IMA_VKOSTL	KOSTL	CHAR	10	0	Responsible cost center	CSKS
46	FKBER	☐	FKBER	FKBER	CHAR	16	0	Functional Area	TFKB
47	ASPART	☐	IMA_ASPART	SPART	CHAR	2	0	Requesting Division	TSPA
48	AMATKL	☐	IMA_AMATKL	MATKL	CHAR	9	0	Requesting material group	T023
49	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
50	STORT	☐	IMA_STORT	AP_STAND	CHAR	10	0	Planned location of appropriation request	T499S
51	BEBER	☐	BEBER	BEBER	CHAR	3	0	Organizational Area	T357
52	TPLNR	☐	IM_TPLNR	TPLNR	CHAR	30	0	Functional location	IFLOT
53	LAND1	☐	IMA_LAND1	LAND1	CHAR	3	0	Country for Which Approp. Request Is Planned	T005
54	VERNR	☐	IM_VERNR	PS_VERNR	NUMC	8	0	Person responsible	TCJ04
55	PARVW	☐	PARVW	PARVW	CHAR	2	0	Partner Role	TPAR
56	PARNR	☐	I_PARNR	I_PARNR	CHAR	12	0	Partner
57	ERGSO	☐	IM_ERGSO	ERGSL	CHAR	10	0	IM: Balance sheet item (credit)
58	IZWEK	☐	IZWEK	IZWEK	CHAR	2	0	Reason for investment	T087I
59	UMWKZ	☐	IMA_UMWKZ	AM_UMWKZ	CHAR	5	0	Reason for environmental investment	T087K
60	PPRIO	☐	IM_PRIOR	NW_PRIO	CHAR	1	0	Priority	TCN07
61	STATUS_REQ	☐	IMA_STATUS	J_ISTATEXT	CHAR	5	0	Main system status of an appropriation request
62	STATUS	☐	IM_STATUS	J_ISTATEXT	CHAR	5	0	Main system status of measure
63	OBART	☐	J_OBART_LD	J_OBART_LD	CHAR	2	0	Object Type
64	SIZECL	☐	IM_SIZECL	SIZECL	CHAR	2	0	Scale of investment objects	TAIF5
65	XGNJ	☐	IM_XGNJ	IM_XGNJ	CHAR	1	0	Ind: Assignment new in approv. year/or copied from prev.year
66	ORG_GNJHR	☐	IMA_GJAHR	GJAHR	NUMC	4	0	Approval year for appropriation request
67	CHARAC_REQ	☐	IMA_REQ_CH	IMA_REQ_CH	NUMC	1	0	Assignment of measures to appropriation request
68	MEAS_REQ	☐	IM_MEAS_AS	IM_MEAS_AS	NUMC	1	0	Assignment of measure to an appropriation request
69	USR00	☐	IMA_USR00	USRCHAR20	CHAR	20	0	User field 1 (20 characters)
70	USR01	☐	IMA_USR01	USRCHAR20	CHAR	20	0	User field 2 (20 characters)
71	USR02	☐	IMA_USR02	IMA_USRCHAR10	CHAR	10	0	User field 3 (10 characters)	TAIF9
72	USR03	☐	IMA_USR03	IMA_USRCHAR10	CHAR	10	0	User field 4 (10 characters)	TAIF9
73	USR10	☐	IMA_USR10	XFELD	CHAR	1	0	User field 11 as indicator for IM reports
74	USR11	☐	IMA_USR11	XFELD	CHAR	1	0	User field 12 as indicator for IM reports
75	USR12	☐	IMA_USR12	USRPER	ACCP	6	0	User field 13 for period and fiscal year
76	USR13	☐	IMA_USR13	USRPER	ACCP	6	0	User field 14 for period and fiscal year
77	OWAERS	☐	OWAER	WAERS	CUKY	5	0	Currency Key	*
78	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RIPASP	AB_POSNR	IMPR	POSNR	REF	C	CN
2	RIPASP	AMATKL	T023	MATKL	REF	C	CN
3	RIPASP	ASPART	TSPA	SPART	REF	C	CN
4	RIPASP	AUFNR	AUFK	AUFNR		C	CN
5	RIPASP	BEBER	T357	BEBER	REF	C	CN
6	RIPASP	BUKRS	T001	BUKRS	REF	C	CN
7	RIPASP	CONGR	TF180	CONGR	REF	C	CN
8	RIPASP	FKBER	TFKB	FKBER		C	CN
9	RIPASP	GSBER	TGSB	GSBER	REF	1	CN
10	RIPASP	IPPOS	TAI08	IPPOS	REF	C	CN
11	RIPASP	IZWEK	T087I	IZWEK	REF	1	CN
12	RIPASP	KOKRS	TKA01	KOKRS	REF	1	CN
13	RIPASP	KOSTL	CSKS	KOSTL	REF	C	CN
14	RIPASP	LAND1	T005	LAND1	REF	C	CN
15	RIPASP	LEAF_POSNR	IMPR	POSNR	REF	C	CN
16	RIPASP	PARVW	TPAR	PARVW	REF	C	CN
17	RIPASP	POSNR	IMPR	POSNR	KEY	1	CN
18	RIPASP	PPRIO	TCN07	NPRIO
19	RIPASP	PRCTR	CEPC	PRCTR	REF	C	CN
20	RIPASP	PRNAM	IMTP	PRNAM	KEY	1	CN
21	RIPASP	RCOMP	T880	RCOMP	REF	C	CN
22	RIPASP	REPCUR	TCURC	WAERS
23	RIPASP	REQ_POSNR	IMAK	POSNR	REF	C	CN
24	RIPASP	SIZECL	TAIF5	SIZECL	REF	C	CN
25	RIPASP	STATSEL	TJ48	SELID	REF	C	CN
26	RIPASP	STORT	T499S	STAND	REF	C	CN
27	RIPASP	TPLNR	IFLOT	TPLNR		C	CN
28	RIPASP	UMWKZ	T087K	UMWKZ	REF	C	CN
29	RIPASP	USR02	TAIF9	USR02	REF	C	CN
30	RIPASP	USR03	TAIF9	USR02	REF	C	CN
31	RIPASP	VERNR	TCJ04	VERNR	REF	C	CN
32	RIPASP	VERSN	TAIF2	VERSI	REF	C	CN
33	RIPASP	VKOSTL	CSKS	KOSTL	REF	C	CN
34	RIPASP	WERKS	T001W	WERKS	REF	C	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in