SAP ABAP Table PIQDB_US_BPSPORT (Business Partner: Student sports)

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	TRANSP	Transparent table
Transparent table	PIQDB_US_BPSPORT	Table Relationship Diagram
Short Description	Business Partner: Student sports

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	PARTNER	☑	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
3	SPORTS_TYPE	☑	PIQ_US_SPORTSTYP	PIQ_US_SPORTSTYP	CHAR	3	0	IPEDS Sports Type	T7PIQ_US_SPORTS
4	BEGIN_YEAR	☑	PIQ_US_SVBYEAR	PIQPERYR	NUMC	4	0	IPEDS: Sports Validity Start Year	T7PIQYEARPRD
5	BEGIN_SESSION	☑	PIQ_US_SVBSESSION	PIQPERID	NUMC	3	0	IPEDS: Sports Validity Start Session	T7PIQYEARPRD
6	END_YEAR	☐	PIQ_US_SVEYEAR	PIQPERYR	NUMC	4	0	IPEDS: Sports Validity End Year	T7PIQYEARPRD
7	END_SESSION	☐	PIQ_US_SVESESSION	PIQPERID	NUMC	3	0	IPEDS: Sports Validity End Session	T7PIQYEARPRD
8	SCHOLARSHIP	☐	PIQ_US_SCHOLARSHIP	CHECKBOX	CHAR	1	0	IPEDS: Scholarship Applicability
9	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
10	ENDDA	☐	ENDDA	DATUM	DATS	8	0	End Date

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PIQDB_US_BPSPORT	BEGIN_SESSION	T7PIQYEARPRD	PERID
2	PIQDB_US_BPSPORT	BEGIN_YEAR	T7PIQYEARPRD	PERYR
3	PIQDB_US_BPSPORT	END_SESSION	T7PIQYEARPRD	PERID
4	PIQDB_US_BPSPORT	END_YEAR	T7PIQYEARPRD	PERYR
5	PIQDB_US_BPSPORT	SPORTS_TYPE	T7PIQ_US_SPORTS	SPORTS_TYPE		1	CN

History

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