SAP USA Tables
Are you looking for the right table related to SAP USA Tables to query in an ABAP Program, Class, Function Module and OData API?
There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in USA (IS-HER-CM-US) module.
Top 10 tables in USA
| Table | Description |
|---|---|
| T7PIQ_US_NCAPRC | NCAA Class Descriptions |
| T7PIQ_US_MATCT | SEVIS: EV matriculation code description |
| T7PIQ_US_SEVNOT | SEVIS Notes for comments/Descriptions |
| T7PIQ_US_NCPGMTY | NCAA: Denote Undergraduate Program of Study |
| T7PIQ_US_AWARDT | IPEDS Award level Description |
| T7PIQ_US_RESDSTM | Assign Residence Statuses |
| PIQDB_US_BPSPCHK | Business Partner: Student Sports Checklist |
| PIQDB_US_BPSPORT | Business Partner: Student sports |
| T7PIQ_US_EXPTYT | SEVIS STUDENT EXPENSE TYPE DESCRIPTION |
| T7PIQ_US_NCGTMAP | NCAA Grants Mapping Table |
List of tables in USA
| Table | Description |
|---|---|
| T7PIQ_US_NCAPRC | NCAA Class Descriptions |
| T7PIQ_US_MATCT | SEVIS: EV matriculation code description |
| T7PIQ_US_SEVNOT | SEVIS Notes for comments/Descriptions |
| T7PIQ_US_NCPGMTY | NCAA: Denote Undergraduate Program of Study |
| T7PIQ_US_AWARDT | IPEDS Award level Description |
| T7PIQ_US_RESDSTM | Assign Residence Statuses |
| PIQDB_US_BPSPCHK | Business Partner: Student Sports Checklist |
| PIQDB_US_BPSPORT | Business Partner: Student sports |
| T7PIQ_US_EXPTYT | SEVIS STUDENT EXPENSE TYPE DESCRIPTION |
| T7PIQ_US_NCGTMAP | NCAA Grants Mapping Table |
| T7PIQ_US_SPRTMAP | Mapping table for NCAA Sport Codes |
| T7PIQ_US_NCARAC | NCAA Race Codes |
| PIQDB_US_BPFUND | SEVIS: Student funds data |
| T7PIQ_US_VISACO | Define SEVIS Visa Types |
| T7PIQ_US_STLEVE | Define IPEDS Student Levels |
| T7PIQ_US_ETHT | IPEDS Ethnicity |
| T7PIQ_US_SPRTCDT | NCAA Sports Codes Text Table |
| T7PIQ_US_NCAWPRT | NCAA Sessions Text |
| T7PIQ_US_APPFRM | US IPEDS: Customizing to Map Relavent Prior Reporting Years |
| T7PIQ_US_DEPENT | SEVIS: Dependent code description |
| T7PIQ_US_IPEDSDM | Assign Reports to DMEE Trees |
| T7PIQ_US_NHCIM | NSCH Confidentiality Indicator Mapping Table |
| T7PIQ_US_ACST | Progression: Academic Standing with Good Student Indicator |
| T7PIQ_US_VISACM | SEVIS VISA CODE MAPPING TABLE |
| T7PIQ_US_MATCO | SEVIS: EV matriculation code |
| T7PIQ_US_NCAWPRD | NCAA Sessions |
| T7PIQ_US_SEVNO | Define SEVIS Note Types |
| T7PIQ_US_ETHNIT | US IPEDS: Customizing table for Ethnic group Text |
| T7PIQ_US_SPRTRN | Possible set of Reason for discontinuity from a Sport Type |
| T7PIQ_US_STLEVT | IPEDS Student level Description table |
| T7PIQ_US_PRGCLT | Text Table for Possible set of Progression Results |
| T7PIQ_US_RACM | Map Race Codes |
| T7PIQ_US_HIGHSC | IPEDS High School Completions mapping |
| T7PIQ_US_SPORTM | Assign Sports Type Codes |
| T7PIQ_US_AWARDL | Define IPEDS Award Levels |
| T7PIQ_US_POSCT | SEVIS: EV position code description |
| T7PIQ_US_SPRTCD | NCAA Sports Codes |
| T7PIQ_US_SPORTT | Sports Type text |
| T7PIQ_US_AWARDM | US IPEDS: Customizing table for Mapping Award level |
| T7PIQ_US_PERIOD | US IPEDS: Customizing table for Mapping periods |
| T7PIQ_US_FECIPC | Assign CIP Codes for Fall Enrollment |
| T7PIQ_US_IPEDSDT | IPEDS Report Text |
| T7PIQ_US_DEREGD | Define IPEDS Deregistration Reasons |
| T7PIQ_US_NCARACT | NCAA Race Codes Text Table |
| T7PIQ_US_EDLEVE | Define SEVIS Education Levels |
| T7PIQ_US_FUNDTYT | SEVIS STUDENT FUNDS TYPE DESC |
| T7PIQ_US_SPORTS | Define Sports Types |
| T7PIQ_US_SPRTRNT | Text Table for possible set of Reasons and its description |
| T7PIQ_US_DLT | NSCH Degree Level Description Text Table |
| T7PIQ_US_NHDRT | NSCH Enrollment status text table for deregistered students |
| T7PIQ_US_EST | NSCH Enrollment Status Description for Enrolled Students |
| T7PIQ_US_GRADPT | US IPEDS: Customizing table for Mapping Graduate Program Typ |
| T7PIQ_US_IDOCSTR | Assign SEVIS XML Tag Names to IDOC Tag Names |
| T7PIQ_US_ETHNIC | Define IPEDS Ethnic Groups |
| T7PIQ_US_TRG_TIM | Veterans: Mapping for training time |
| T7PIQ_US_PTINDX | Customizing to map Program Full time and Performance Index |
| T7PIQ_US_SESNMAP | NCAA Sessions Mapping |
| T7PIQ_US_ETH | IPEDS Ethnicity |
| PIQDB_US_BPEXP | SEVIS: Student expense data |
| T7PIQ_US_NCTSMAP | NCAA Test Codes Mapping Table |
| T7PIQ_US_NHDRM | Mapping of NSCH Enrolment Status with deregistration reasons |
| T7PIQ_US_NCRCMAP | NCAA Race Codes Mapping Table |
| T7PIQ_US_EXPTY | Define SEVIS Expense Types . |
| T7PIQ_US_NHDRS | Table to store NSCH Enrollment Status of Deregisted students |
| T7PIQ_US_DEPEND | SEVIS: Dependent code |
| HRT1896 | Table Part Infotype 1896 |
| T7PIQ_US_STCATT | SEVIS STUDENT CATEGORY DESCRIPTION VALUE TABLE |
| HRP1896 | DB Table for Infotype 1896 |
| T7PIQ_US_PRGCLM | Mapping Progression Results with Progression Classification |
| T7PIQ_US_NHESM | Mapping Degree lvl & cut-off credits with NSCH Enroll Status |
| T7PIQ_US_PRCLMAP | NCAA Class Descriptions Mapping Table |
| PMIQ_US_STORDATA | 1098T: Store StudentΓÇÖs form data |
| T7PIQ_US_TSUIMT | Customizing table of active implementations for score upload |
| T7PIQ_US_TYP_TRG | Veterans: type of training |
| T7PIQ_US_VISACT | SEVIS VISA CODE DESCRIPTION |
| T7PIQ_US_FUNDTY | Define SEVIS Fund Types . |
| T7PIQ_US_GRSDER | Assign IPEDS Dereg. Reasons to Standard Dereg. Reasons |
| T7PIQ_US_1098T | 1098T: Value table for tuition statement derivation. |
| T7PIQ_US_NCATSTT | NCAA Test Codes Text Table |
| T7PIQ_US_PRGCL | Set of Progression Results for a Progression Category |
| T7PIQ_US_DLS | NSCH Degree Level Setup Table |
| T7PIQ_US_DEPENM | SEVIS: Dependent code mapping |
| T7PIQ_US_STLEVM | US Reporting Customizing table for Mapping Degree Level |
| T7PIQ_US_MGCMAJ | Define Mod Grp Cat as Major |
| T7PIQ_US_ESS | NSCH Enrollment Status for Enrolled Students |
| T7PIQ_US_STCAT | Define SEVIS Student Categories |
| T7PIQ_US_DEREGDT | IPEDS Deregistration Description |
| T7PIQ_US_DLM | Mapping of NSCH Degree & Graduation Lvl with Core Degree Lvl |
| T7PIQ_US_FIRSTY | Determine First-Year Progress Classification |
| T7PIQ_US_RSTRCT | Customizing table to maintain exclusions for 1098T reporting |
| T7PIQ_US_NCAPRCT | NCAA Class Descriptions Text Table |
| T7PIQ_US_TSUIM | Customizing table of active implementations for score upload |
| T7PIQ_US_IPEDSDL | IPEDS Report Section |
| T7PIQ_US_BPSSNAD | Customizing to Map BP ID Type to SSN & Address for 1098T For |
| T7PIQ_US_SEVNM | SEVIS SPECIFIC NOTES MAPPED |
| T7PIQ_US_PREPYR | US IPEDS: Customizing to Map Relavent Prior Reporting Years |
| T7PIQ_US_CIPCOD | Derive CIP Codes from Module Group Variants |
| T7PIQ_US_ETHNIM | US IPEDS: Customizing table for Mapping Ethnic group |
| T7PIQ_US_POSCO | SEVIS: EV position code |
| T7PIQ_US_NCATST | NCAA Test Codes |
| T7PIQ_US_SEVICO | Assign SEVIS Country Code to Standard Country Code |
| T7PIQ_US_EDLEVT | SEVIS EDUCATION LEVEL TEXT |
| T7PIQ_US_VETE_ST | Veterans: Veterans status |