SAP ABAP Table FPEX (Commitment Items)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-FM (Application Component) Funds Management
     ⤷ FMMD_CORE (Package) Funds Management: Master Data Core Objects

Basic Data

Table Category	INTTAB	Structure
Structure	FPEX	Table Relationship Diagram
Short Description	Commitment Items

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	FIPEX	☐	FM_FIPEX	FM_FIPEX	CHAR	24	0	Commitment item	*
2	PNAME	☐	FM_PNAME	TEXT20	CHAR	20	0	Commitment item name
3	TEXT1	☐	FM_BESCHR0	TEXT50	CHAR	50	0	Description
4	TEXT2	☐	FM_BESCHR2	TEXT50	CHAR	50	0	Description 2
5	TEXT3	☐	FM_BESCHR3	TEXT50	CHAR	50	0	Description 3
6	PLEVL	☐	FM_POSLEVL	INT4	INT4	10	0	Level in the commitment item hierarchy
7	FICTR	☐	FM_DFICTR	FISTL	CHAR	16	0	Funds Center (Default Value in a Commitment Item)	*
8	VPTYP	☐	FM_VPTYP	FM_VPTYP	CHAR	2	0	Carryforward item category for commitment item	*
9	SNTYP	☐	FM_COLLTYP	FM_COLLTYP	CHAR	1	0	Collective budget adminstration category
10	SNROL	☐	FM_COLLROL	FM_COLLECT	CHAR	1	0	Use type in collective budget administration
11	STATS	☐	FM_STATPOS	XFELD	CHAR	1	0	Statistical commitment item
12	NDAKZ	☐	FM_NDAB	FM_NDAB	CHAR	1	0	Indicator: NDA Budget
13	AZPKZ	☐	FM_AZPB	FM_AZPB	CHAR	1	0	Indicator: Accrued Budget
14	KRGRP	☐	FM_KRGRP	FM_KRGRP	CHAR	4	0	Criterion category group	*
15	AUGRP	☐	FM_AUTHGRP	CHAR10	CHAR	10	0	Authorization Groups of the Commitment Item
16	NCBUD	☐	FM_NCBUD	XFELD	CHAR	1	0	No Budget for Future Years
17	HIE_ID	☐	FM_PHIE_ID	SEU_ID	NUMC	6	0	Position of a commitment item in the hierarchy
18	.INCLUDE	☐				0	0	Non-Year-Dependent Commitment Item Data Fields
19	PDSCR	☐	FM_BESCHR	TEXT40	CHAR	40	0	Description
20	DATBIS	☐	FM_DATBIS	DATUM	DATS	8	0	FM: Valid to date
21	DATAB	☐	FM_DATAB	DATUM	DATS	8	0	FM: Valid from date
22	ERFNAME	☐	FM_ERFNAME	USNAM	CHAR	12	0	FIFM: Created by
23	ERFDAT	☐	FM_ERFDAT	DATUM	DATS	8	0	FIFM: Entry Date
24	AENNAME	☐	FM_AENNAME	USNAM	CHAR	12	0	FIFM: Name of Last Person to Make a Change
25	AENDAT	☐	FM_AENDAT	DATUM	DATS	8	0	FIFM: Changed on
26	DEAKTIV	☐	FM_DEAKTIV	XFELD	CHAR	1	0	Deactivation Indicator
27	LOEVM	☐	FM_LOEVM	XFELD	CHAR	1	0	Commitment item is flagged for deletion (indicator)
28	POSIT	☐	FM_POSIT	FM_POSIT	CHAR	8	0	Item (Internal Commitment Item Number)
29	KNZAEPO	☐	FM_KNZAEPO	FM_KNZAE	NUMC	1	0	Commitment Item Category
30	.INCLUDE	☐				0	0	Data Structure for Commitment Items in Chart of Cmmt Items
31	KATEG	☐	FM_KATEG	FM_KATEG	NUMC	1	0	Attribute: Can be Posted To
32	FIVOR	☐	FM_FIVOR	FM_FIVOR	NUMC	2	0	Financial transaction
33	POTYP	☐	FM_POTYP	FM_POTYP	NUMC	1	0	Commitment Item Category
34	KRTYP	☐	FM_KRTYP	FM_KRTYP	CHAR	5	0	Commitment item criterion category	FMKRTP
35	FPART	☐	FM_FPART	FM_FPART	CHAR	3	0	Commitment Item Type
36	FIPOS	☐	FIPOS	FIPOS	CHAR	14	0	Commitment Item	*
37	FIPUP	☐	FIPEX_UP	FM_FIPEX	CHAR	24	0	Superior Commitment Item	*
38	.INCLUDE	☐				0	0	Local Authority Add.Fields for Cmmt Items in Chart of CIs
39	HSART	☐	FM_HSART	FM_HSART	CHAR	1	0	Commitment Item Type	FMHSART
40	GKFLG	☐	FM_GKFLG	XFELD	CHAR	1	0	Relevant to total costs
41	.INCLUDE	☐				0	0	Add.Local Authority Fields for Cmmt Items in FM Area/Fisc.Yr
42	DRUCK	☐	FM_DRUCK	XFELD	CHAR	1	0	Not relevant for budget print
43	CFFLG	☐	FM_CFFLG	XFELD	CHAR	1	0	Able to carry forward at fiscal year change
44	CVFLG	☐	FM_CVFLG	XFELD	CHAR	1	0	(Negative) clearing item
45	BEZIRK	☐	FM_BEZIRK	CHAR4	CHAR	4	0	District
46	BSAMT	☐	FM_BSAMT	FISTL	CHAR	16	0	Managed position / clearing lower section	FMFCTR
47	UBFLG	☐	FM_UBFLG	CHAR1	CHAR	1	0	Local authorities: Budget execution account
48	HSFLG	☐	FM_HSFLG	XFELD	CHAR	1	0	Budget balancing concept
49	.INCLUDE	☐				0	0	Assignment of Balance Objects to Budget Structure Elements
50	EFICTR	☐	FM_SDFICTR	FISTL	CHAR	16	0	Balance Funds Center	*
51	EFIPEX1	☐	FM_SDFIPEX	FM_FIPEX	CHAR	24	0	Balance Cmmt Item	*
52	PROZ1	☐	FM_SDPROZ	PRZ32	DEC	5	2	Balance percentage rate
53	EFIPEX2	☐	FM_SDFIPX2	FM_FIPEX	CHAR	24	0	Balance commitment item plan year+1	*
54	PROZ2	☐	FM_SDPROZ2	PRZ32	DEC	5	2	Balance percentage rate plan year+1
55	EFIPEX3	☐	FM_SDFIPX3	FM_FIPEX	CHAR	24	0	Balance commitment item plan year+2	*
56	PROZ3	☐	FM_SDPROZ3	PRZ32	DEC	5	2	Balance percentage rate plan year+2
57	EFIPEX4	☐	FM_SDFIPX4	FM_FIPEX	CHAR	24	0	Balance commitment item plan year+3	*
58	PROZ4	☐	FM_SDPROZ4	PRZ32	DEC	5	2	Balance percentage rate plan year+3
59	EFIPEX5	☐	FM_SDFIPX5	FM_FIPEX	CHAR	24	0	Balance commitment item plan year+4	*
60	PROZ5	☐	FM_SDPROZ5	PRZ32	DEC	5	2	Balance percentage rate plan year+4
61	.INCLUDE	☐				0	0
62	.INCLUDE	☐				0	0	Structure of Substrings of Commitment Item
63	STR_ID	☐	FM_STR_ID	CHAR10	CHAR	10	0	Master Data Subdivision ID	FMMDSTRID
64	CISUB1	☐	FM_CISUB1	CHAR10	CHAR	10	0	Substring 1 of Commitment Item	FMMDCISUB1
65	CISUB2	☐	FM_CISUB2	CHAR10	CHAR	10	0	Substring 2 of Commitment Item	FMMDCISUB2
66	CISUB3	☐	FM_CISUB3	CHAR10	CHAR	10	0	Substring 3 of Commitment Item	FMMDCISUB3
67	CISUB4	☐	FM_CISUB4	CHAR10	CHAR	10	0	Substring 4 of Commitment Item	FMMDCISUB4
68	CISUB5	☐	FM_CISUB5	CHAR10	CHAR	10	0	Substring 5 of Commitment Item	FMMDCISUB5
69	.INCLU--AP	☐				0	0	Partial Structure-Commitment Item with Texts
70	.INCLUDE	☐				0	0	Subtructures of Commitment Item - Text descriptions
71	CISUB1T_SH	☐	FM_CISUB1T_SH	CHAR50	CHAR	50	0	Description 1 of Substring 1 of Commitment Item
72	CISUB1T_LO	☐	FM_CISUB1T_LO	CHAR50	CHAR	50	0	Description 2 of Substring 1 of Commitment Item
73	CISUB2T_SH	☐	FM_CISUB2T_SH	CHAR50	CHAR	50	0	Description 1 of Substring 2 of Commitment Item
74	CISUB2T_LO	☐	FM_CISUB2T_LO	CHAR50	CHAR	50	0	Description 2 of Substring 2 of Commitment Item
75	CISUB3T_SH	☐	FM_CISUB3T_SH	CHAR50	CHAR	50	0	Description 1 of Substring 3 of Commitment Item
76	CISUB3T_LO	☐	FM_CISUB3T_LO	CHAR50	CHAR	50	0	Description 2 of Substring 3 of Commitment Item
77	CISUB4T_SH	☐	FM_CISUB4T_SH	CHAR50	CHAR	50	0	Description 1 of Substring 4 of Commitment Item
78	CISUB4T_LO	☐	FM_CISUB4T_LO	CHAR50	CHAR	50	0	Description 2 of Substring 4 of Commitment Item
79	CISUB5T_SH	☐	FM_CISUB5T_SH	CHAR50	CHAR	50	0	Description 1 of Substring 5 of Commitment Item
80	CISUB5T_LO	☐	FM_CISUB5T_LO	CHAR50	CHAR	50	0	Description 2 of Substring 5 of Commitment Item

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FPEX	BSAMT	FMFCTR	FICTR
2	FPEX	CISUB1	FMMDCISUB1	CISUB1
3	FPEX	CISUB2	FMMDCISUB2	CISUB2
4	FPEX	CISUB3	FMMDCISUB3	CISUB3
5	FPEX	CISUB4	FMMDCISUB4	CISUB4
6	FPEX	CISUB5	FMMDCISUB5	CISUB5
7	FPEX	HSART	FMHSART	HSART	REF	1	CN
8	FPEX	KRTYP	FMKRTP	KRTYP
9	FPEX	STR_ID	FMMDSTRID	STR_ID

History

Last changed by/on	SAP	20130529
SAP Release Created in