SAP ABAP Table PIQ_US_BPEXP_UPD (BP: Update Structure for Student Role (Expense))

Hierarchy

☛ IS-PS-CA (Software Component) IS-PUBLIC SECTOR CONTRACT ACCOUNTING
   ⤷ IS-HER-CM-US (Application Component) USA
     ⤷ PMIQ_US (Package) Campus Management USA

Basic Data

Table Category	INTTAB	Structure
Structure	PIQ_US_BPEXP_UPD	Table Relationship Diagram
Short Description	BP: Update Structure for Student Role (Expense)

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	SEVIS: Student expense data
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
4	EXPENSETYPE	☐	PIQ_US_EXPTYPE	CHAR2	CHAR	2	0	SEVIS: Expense Type	T7PIQ_US_EXPTY
5	ACAD_YEAR	☐	PIQPERYR	PIQPERYR	NUMC	4	0	Academic Year	T7PIQYEAR
6	AMOUNT	☐	PIQ_US_EXPAMT	WERT7	CURR	13	2	SEVIS: Student Expense Amount
7	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
8	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
9	ENDDA	☐	ENDDA	DATUM	DATS	8	0	End Date
10	.INCLUDE	☐				0	0	US reporting BDT: Status Information of BP tables
11	.INCLUDE	☐				0	0	CBP: Status information (only CBP data)
12	AKTDB	☐	BU_ACTYP	BU_ACTYP	CHAR	2	0	Activity Type
13	AKTYP	☐	BU_ACTYP	BU_ACTYP	CHAR	2	0	Activity Type
14	XCHNG	☐	BU_XCHNG	XFELD	CHAR	1	0	Indicator: Data has been changed
15	NRRNG	☐	BU_NRRNG	CHAR2	CHAR	2	0	BP Number Range
16	XNREX	☐	NRIND	XFELD	CHAR	1	0	Internal (' ') or external ('X') number range flag
17	VALDT	☐	BU_VALDT	DATUM	DATS	8	0	Initial Date for Business Partner Data
18	.INCLUDE	☐				0	0	Structures for generating change document update programs
19	KZ	☐	CDCHNGIND	CDCHNGIND	CHAR	1	0	Change type (U, I, E, D)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PIQ_US_BPEXP_UPD	ACAD_YEAR	T7PIQYEAR	PERYR	KEY	1	CN
2	PIQ_US_BPEXP_UPD	EXPENSETYPE	T7PIQ_US_EXPTY	EXPENSETYPE		1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in	472