SAP ABAP Table T7UNPAD_EGEXPMGT (NPO: Expense Management Table)

Hierarchy

☛ SAP_HRCUN (Software Component) Sub component SAP_HRCUN of SAP_HR
   ⤷ PY-NPO (Application Component) Non Profit Organizations
     ⤷ PBUN (Package) Master Data Non Profit Organizations

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	T7UNPAD_EGEXPMGT	Table Relationship Diagram
Short Description	NPO: Expense Management Table

Delivery and Maintenance

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

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	.INCLUDE	☑				0	0	Keys for HR Master Data
3	PERNR	☑	PERNR_D	PERNR	NUMC	8	0	Personnel Number	*
4	INFTY	☑	INFTY	INFOTYP	CHAR	4	0	Infotype	T582A
5	SUBTY	☑	SUBTY	SUBTY	CHAR	4	0	Subtype
6	OBJPS	☑	OBJPS	OBJPS	CHAR	2	0	Object Identification
7	SPRPS	☑	SPRPS	SPRPS	CHAR	1	0	Lock Indicator for HR Master Data Record
8	ENDDA	☑	ENDDA	DATUM	DATS	8	0	End Date
9	BEGDA	☑	BEGDA	DATUM	DATS	8	0	Start Date
10	SEQNR	☑	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
11	EXMNR	☑	PUN_EGEXPNRR	PUN_EGEXPNRR	NUMC	10	0	Exp. MM: Numberrange No.
12	LFDNR	☑	NRBEL	NRBEL	CHAR	3	0	Document Number
13	EGPYT	☑	PUN_EGPYT	PUN_EGPYT	CHAR	3	0	Education Grant Pay Type
14	EGPAY_DATE	☐	PUN_EGADV_PYDT	DATS	DATS	8	0	EG Paydate
15	.INCLUDE	☐				0	0	HR Master Record: Control Field
16	AEDTM	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
17	UNAME	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
18	HISTO	☐	HISTO	CHAR1	CHAR	1	0	Historical Record Flag
19	ITXEX	☐	ITXEX	XFELD	CHAR	1	0	Text Exists for Infotype
20	REFEX	☐	PRFEX	XFELD	CHAR	1	0	Reference Fields Exist (Primary/Secondary Costs)
21	ORDEX	☐	ORDEX	XFELD	CHAR	1	0	Confirmation Fields Exist
22	ITBLD	☐	ITBLD	CHAR2	CHAR	2	0	Infotype Screen Control
23	PREAS	☐	PREAS	PREAS	CHAR	2	0	Reason for Changing Master Data	T530E
24	FLAG1	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
25	FLAG2	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
26	FLAG3	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
27	FLAG4	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
28	RESE1	☐	NUSED2	NUSED2	CHAR	2	0	Reserved Field/Unused Field of Length 2
29	RESE2	☐	NUSED2	NUSED2	CHAR	2	0	Reserved Field/Unused Field of Length 2
30	GRPVL	☐	PCCE_GPVAL	PCCE_GPVAL	CHAR	4	0	Grouping Value for Personnel Assignments
31	.INCLUDE	☐				0	0	NPO: EG Expenses
32	EXLNR	☐	NRBEL	NRBEL	CHAR	3	0	Document Number
33	EXCOS	☐	PUN_EGEXPCOS	PUN_EGEXPCOS	CHAR	6	0	EG: Expense Type	T7UNPAD_EGCOS
34	EXART	☐	PUN_EGEXPCST	PUN_EGEXPCST	CHAR	1	0	EG: Cost type
35	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	T007A
36	EXAMT	☐	GESBB	GESBE	CURR	10	2	Amount on Individual Receipt
37	EXAMT_E	☐	PUN_EGEXPAMT	GESBE	CURR	10	2	EG: Expense Amount
38	EXDAT	☐	BELDT	REDAT	DATS	8	0	Receipt Date
39	EXEXT	☐	PUN_EGEXPCOST	TEXT40	CHAR	40	0	EG: Expense type text
40	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
41	KURSB	☐	UKURS_CURR	UKURS	DEC	9	5	Exchange Rate
42	FFACT	☐	FFACT_CURR	DEC9	DEC	9	0	Ratio for the "from" currency units
43	TFACT	☐	TFACT_CURR	DEC9	DEC	9	0	Ratio for the "to" currency units
44	PAPER_RECEIPT	☐	PUN_PPRCT	XFELD	CHAR	1	0	Paper Receipt Exists
45	RECEIPT_VALIDATE	☐	PUN_RCTVAL	XFELD	CHAR	1	0	Expense Receipt Checked
46	PAYCURR	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
47	FLAG	☐	XFELD	XFELD	CHAR	1	0	Checkbox
48	PFLAG	☐	XFELD	XFELD	CHAR	1	0	Checkbox
49	ADVFLAG	☐	XFELD	XFELD	CHAR	1	0	Checkbox

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	T7UNPAD_EGEXPMGT	EXCOS	T7UNPAD_EGCOS	EXCOS		1	CN
2	T7UNPAD_EGEXPMGT	INFTY	T582A	INFTY
3	T7UNPAD_EGEXPMGT	MWSKZ	T007A	MWSKZ
4	T7UNPAD_EGEXPMGT	PREAS	T530E	PREAS
5	T7UNPAD_EGEXPMGT	WAERS	TCURC	WAERS

History

Last changed by/on	SAP	20130529
SAP Release Created in	200