SAP ABAP Table IFMFIPEXK (FIFM: Stammdatenreporting Finanzposition(Kommunen))

Hierarchy

☛ EA-PS (Software Component) SAP Enterprise Extension Public Services
   ⤷ PSM-FM-IS (Application Component) Information system
     ⤷ FMKO (Package) FM: Reporting for German Local Authorities

Basic Data

Table Category	INTTAB	Structure
Structure	IFMFIPEXK	Table Relationship Diagram
Short Description	FIFM: Stammdatenreporting Finanzposition(Kommunen)

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	FIKRS	☐	FIKRS	FIKRS	CHAR	4	0	Financial Management Area	*
2	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
3	FIPEX	☐	FM_FIPEX	FM_FIPEX	CHAR	24	0	Commitment item	*
4	PNAME	☐	FM_PNAME	TEXT20	CHAR	20	0	Commitment item name
5	PLEVL	☐	FM_POSLEVL	INT4	INT4	10	0	Level in the commitment item hierarchy
6	TEXT1	☐	FM_BESCHR0	TEXT50	CHAR	50	0	Description
7	TEXT2	☐	FM_BESCHR2	TEXT50	CHAR	50	0	Description 2
8	TEXT3	☐	FM_BESCHR3	TEXT50	CHAR	50	0	Description 3
9	VARNT	☐	FM_VARNT	FM_VARNT	CHAR	3	0	Commitment Item Hierarchy Variant	*
10	VARNT_TXT	☐	FM_BEZEICH	TEXT20	CHAR	20	0	Name
11	FICTR	☐	FM_FICTR	FISTL	CHAR	16	0	Funds Center	*
12	AUGRP	☐	FM_AUTHGRP	CHAR10	CHAR	10	0	Authorization Groups of the Commitment Item
13	VPTYP	☐	FM_VPTYP	FM_VPTYP	CHAR	2	0	Carryforward item category for commitment item	*
14	SNTYP	☐	FM_COLLTYP	FM_COLLTYP	CHAR	1	0	Collective budget adminstration category
15	SNROL	☐	FM_COLLROL	FM_COLLECT	CHAR	1	0	Use type in collective budget administration
16	STATS	☐	FM_STATPOS	XFELD	CHAR	1	0	Statistical commitment item
17	NCBUD	☐	FM_NCBUD	XFELD	CHAR	1	0	No Budget for Future Years
18	NDAKZ	☐	FM_NDAB	FM_NDAB	CHAR	1	0	Indicator: NDA Budget
19	AZPKZ	☐	FM_AZPB	FM_AZPB	CHAR	1	0	Indicator: Accrued Budget
20	HIE_ID	☐	FM_PHIE_ID	SEU_ID	NUMC	6	0	Position of a commitment item in the hierarchy
21	.INCLUDE	☐				0	0	Data Structure for Commitment Items in Chart of Cmmt Items
22	KATEG	☐	FM_KATEG	FM_KATEG	NUMC	1	0	Attribute: Can be Posted To
23	FIVOR	☐	FM_FIVOR	FM_FIVOR	NUMC	2	0	Financial transaction
24	POTYP	☐	FM_POTYP	FM_POTYP	NUMC	1	0	Commitment Item Category
25	KRTYP	☐	FM_KRTYP	FM_KRTYP	CHAR	5	0	Commitment item criterion category	FMKRTP
26	FPART	☐	FM_FPART	FM_FPART	CHAR	3	0	Commitment Item Type
27	FIPOS	☐	FIPOS	FIPOS	CHAR	14	0	Commitment Item	*
28	FIPUP	☐	FIPEX_UP	FM_FIPEX	CHAR	24	0	Superior Commitment Item	*
29	.INCLUDE	☐				0	0	Local Authority Add.Fields for Cmmt Items in Chart of CIs
30	HSART	☐	FM_HSART	FM_HSART	CHAR	1	0	Commitment Item Type	FMHSART
31	GKFLG	☐	FM_GKFLG	XFELD	CHAR	1	0	Relevant to total costs
32	.INCLUDE	☐				0	0	Add.Local Authority Fields for Cmmt Items in FM Area/Fisc.Yr
33	DRUCK	☐	FM_DRUCK	XFELD	CHAR	1	0	Not relevant for budget print
34	CFFLG	☐	FM_CFFLG	XFELD	CHAR	1	0	Able to carry forward at fiscal year change
35	CVFLG	☐	FM_CVFLG	XFELD	CHAR	1	0	(Negative) clearing item
36	BEZIRK	☐	FM_BEZIRK	CHAR4	CHAR	4	0	District
37	BSAMT	☐	FM_BSAMT	FISTL	CHAR	16	0	Managed position / clearing lower section	FMFCTR
38	UBFLG	☐	FM_UBFLG	CHAR1	CHAR	1	0	Local authorities: Budget execution account
39	HSFLG	☐	FM_HSFLG	XFELD	CHAR	1	0	Budget balancing concept
40	.INCLUDE	☐				0	0	Assignment of Balance Objects to Budget Structure Elements
41	EFICTR	☐	FM_SDFICTR	FISTL	CHAR	16	0	Balance Funds Center	*
42	EFIPEX1	☐	FM_SDFIPEX	FM_FIPEX	CHAR	24	0	Balance Cmmt Item	*
43	PROZ1	☐	FM_SDPROZ	PRZ32	DEC	5	2	Balance percentage rate
44	EFIPEX2	☐	FM_SDFIPX2	FM_FIPEX	CHAR	24	0	Balance commitment item plan year+1	*
45	PROZ2	☐	FM_SDPROZ2	PRZ32	DEC	5	2	Balance percentage rate plan year+1
46	EFIPEX3	☐	FM_SDFIPX3	FM_FIPEX	CHAR	24	0	Balance commitment item plan year+2	*
47	PROZ3	☐	FM_SDPROZ3	PRZ32	DEC	5	2	Balance percentage rate plan year+2
48	EFIPEX4	☐	FM_SDFIPX4	FM_FIPEX	CHAR	24	0	Balance commitment item plan year+3	*
49	PROZ4	☐	FM_SDPROZ4	PRZ32	DEC	5	2	Balance percentage rate plan year+3
50	EFIPEX5	☐	FM_SDFIPX5	FM_FIPEX	CHAR	24	0	Balance commitment item plan year+4	*
51	PROZ5	☐	FM_SDPROZ5	PRZ32	DEC	5	2	Balance percentage rate plan year+4

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	IFMFIPEXK	BSAMT	FMFCTR	FICTR
2	IFMFIPEXK	HSART	FMHSART	HSART	REF	1	CN
3	IFMFIPEXK	KRTYP	FMKRTP	KRTYP

History

Last changed by/on	SAP	20130529
SAP Release Created in