PIQDB_US_BPSPORT - Business Partner: Student sports
Business Partner: Student sports information is stored in SAP table PIQDB_US_BPSPORT.
It is part of development package PMIQ_US in software component IS-HER-CM-US. This development package consists of objects that can be grouped under "Campus Management USA".
It is part of development package PMIQ_US in software component IS-HER-CM-US. This development package consists of objects that can be grouped under "Campus Management USA".
Fields for table PIQDB_US_BPSPORT
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | * |
| PARTNER | Business Partner Number | X | BU_PARTNER | CHAR | 20 | * |
| SPORTS_TYPE | IPEDS Sports Type | X | PIQ_US_SPORTSTYP | CHAR | 6 | T7PIQ_US_SPORTS |
| BEGIN_YEAR | IPEDS: Sports Validity Start Year | X | PIQ_US_SVBYEAR | NUMC | 8 | T7PIQYEARPRD |
| BEGIN_SESSION | IPEDS: Sports Validity Start Session | X | PIQ_US_SVBSESSION | NUMC | 6 | T7PIQYEARPRD |
| ATHLETIC_ENDDA | End date for a Sport Type | X | PIQ_US_ATHLETIC_ENDDA | DATS | 16 | |
| END_YEAR | IPEDS: Sports Validity End Year | PIQ_US_SVEYEAR | NUMC | 8 | T7PIQYEARPRD | |
| END_SESSION | IPEDS: Sports Validity End Session | PIQ_US_SVESESSION | NUMC | 6 | T7PIQYEARPRD | |
| SCHOLARSHIP | IPEDS: Scholarship Applicability | PIQ_US_SCHOLARSHIP | CHAR | 2 | ||
| BEGDA | Start Date | BEGDA | DATS | 16 | ||
| ENDDA | End Date | ENDDA | DATS | 16 | ||
| ATHLETIC_BEGDA | Begin Date for a Sport Type | PIQ_US_ATHLETIC_BEGDA | DATS | 16 | ||
| ATHLETIC_STATUS | Status in Athletics for a Sport Type. | PIQ_US_SPORTSTA | CHAR | 2 | ||
| REASON | Reason for Discontinuity from a Sport Type | PIQ_US_SPORTRSN | CHAR | 4 | T7PIQ_US_SPRTRN |