PIQ_US_NSCH_ITEM SAP (Structure to form DMEE format tree for CM US NSCH Report) Structure details

Dictionary Type: Structure
Description: Structure to form DMEE format tree for CM US NSCH Report




ABAP Code to SELECT data from PIQ_US_NSCH_ITEM
Related tables to PIQ_US_NSCH_ITEM
Access table PIQ_US_NSCH_ITEM




Structure field list including key, data, relationships and ABAP select examples

PIQ_US_NSCH_ITEM is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Structure to form DMEE format tree for CM US NSCH Report" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_PIQ_US_NSCH_ITEM TYPE PIQ_US_NSCH_ITEM.

The PIQ_US_NSCH_ITEM table consists of various fields, each holding specific information or linking keys about Structure to form DMEE format tree for CM US NSCH Report data available in SAP. These include STUDENT_OBJID (Object ID of Student), STUDENTNUMBER (Student Number), PERSIDNO (Identification Number), FIRST_NAME (First Name).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP PIQ_US_NSCH_ITEM structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
ORG_OBJECTIDObject ID PD_OBJID_RNUMC8NUM08PON
STUDENT_OBJIDObject ID of Student PIQST_OBJIDNUMC8Assigned to domainHROBJIDSTUDENT
STUDENTNUMBERStudent Number PIQSTUDENT12CHAR12PIQSTPIQSTUDENT12
PERSIDNOIdentification Number PIQ_PRDNICHAR20CHAR20
FIRST_NAMEFirst Name PAD_VORNACHAR40PAD_VORNM
MIDDLE_NAMEMiddle Name PAD_MIDNMCHAR40PAD_VORNM
LAST_NAMELast Name PAD_NACHNCHAR40PAD_NACHN
INITIALSInitials INITSCHAR10TEXT10
NAME_AT_BIRTHName at Birth PAD_NAME2CHAR40PAD_NACHN
ENROLLMENT_STATUSNSCH Enrollment Status of the student PIQ_US_NSCH_ENROLSTSCHAR1PIQ_US_NSCH_ENROLSTS_DOM
ENROLL_START_DATEDate DATUMDATS8DATUM
STREETStreet AD_STREETCHAR60TEXT60CLSTRTNAME
STR_SUPPL1Street 2 AD_STRSPP1CHAR40TEXT40
CITYCity AD_CITY1CHAR40TEXT40CLCITYNAME
REGIONSTATE (State, Province, County) REGIOCHAR3Assigned to domainREGIO
POSTL_COD1City postal code AD_PSTCD1CHAR10CHAR10
COUNTRYCountry Key LAND1CHAR3Assigned to domainLAND1LND
ANTICIP_GRAD_DATEAnticipated Graduation Date PIQAGD_DATEDATS8DATE
DATE_BIRTHDate of Birth PIQ_GBDATDATS8PDATEGBDAT
TERM_BEGDAStart Date BEGDADATS8DATUM
TERM_ENDDAEnd Date ENDDADATS8DATUM
NSCH_GRAD_LEVELNSCH Graduation Level Indicator PIQ_US_NSCH_GRADLEVELCHAR1CHECKBOX
DATA_BLOCK_INDICATORNSCH Confidentiality Indicator PIQ_US_NSCH_CONFIDCHAR1CHECKBOX
NSCH_DEGREE_LEVELNSCH Degree Level PIQ_US_NSCH_DEGLEVELCHAR1PIQ_US_NSCH_DEGLEVEL_DOM
CQ_OBJIDObject ID HROBJIDNUMC8Assigned to domainHROBJIDPON
QUAL_DESCInternal Qualification (Description) PIQCQ_STEXTCHAR40TEXT40
QUAL_SHORTInternal Qualification PIQCQ_SHORTCHAR12TEXT12
SCHOOL_AWARDING_DEGREEObject Name STEXTCHAR40TEXT40
QUAL_CONFER_DATEDate of Qualification Conferment PIQCONFERQ_DATEDATS8
PROGRAM_OBJECTIDProgram ID PIQSCOBJIDNUMC8Assigned to domainHROBJIDPON
PROGRAM_NAMEProgram PIQAGRSTUDEYCHAR40CHAR40
REGIST_DATEActivity Key Date for Sessional Registration PIQREGPERDATEDATS8DATUM
MAJOR1Object ID OBJEKTIDNUMC8NUM08PON
MAJOR2Object ID OBJEKTIDNUMC8NUM08PON
MAJOR3Object ID OBJEKTIDNUMC8NUM08PON
MAJOR4Object ID OBJEKTIDNUMC8NUM08PON
MINOR1Object ID OBJEKTIDNUMC8NUM08PON
MINOR2Object ID OBJEKTIDNUMC8NUM08PON
MINOR3Object ID OBJEKTIDNUMC8NUM08PON
MINOR4Object ID OBJEKTIDNUMC8NUM08PON
MAJOR1_TXTModule Group (Description) PIQCGSTEXTCHAR40TEXT40
MAJOR2_TXTModule Group (Description) PIQCGSTEXTCHAR40TEXT40
MAJOR3_TXTModule Group (Description) PIQCGSTEXTCHAR40TEXT40
MAJOR4_TXTModule Group (Description) PIQCGSTEXTCHAR40TEXT40
MINOR1_TXTModule Group (Description) PIQCGSTEXTCHAR40TEXT40
MINOR2_TXTModule Group (Description) PIQCGSTEXTCHAR40TEXT40
MINOR3_TXTModule Group (Description) PIQCGSTEXTCHAR40TEXT40
MINOR4_TXTModule Group (Description) PIQCGSTEXTCHAR40TEXT40
CIP_MAJOR1Discipline PIQSMDISZIPCHAR16Assigned to domainPIQSMDISZIP
CIP_MAJOR2Discipline PIQSMDISZIPCHAR16Assigned to domainPIQSMDISZIP
CIP_MAJOR3Discipline PIQSMDISZIPCHAR16Assigned to domainPIQSMDISZIP
CIP_MAJOR4Discipline PIQSMDISZIPCHAR16Assigned to domainPIQSMDISZIP
CIP_MINOR1Discipline PIQSMDISZIPCHAR16Assigned to domainPIQSMDISZIP
CIP_MINOR2Discipline PIQSMDISZIPCHAR16Assigned to domainPIQSMDISZIP
CIP_MINOR3Discipline PIQSMDISZIPCHAR16Assigned to domainPIQSMDISZIP
CIP_MINOR4Discipline PIQSMDISZIPCHAR16Assigned to domainPIQSMDISZIP
CIP_TXT_MAJOR1Discipline (Description) PIQSMDISZIPTCHAR100TEXT100
CIP_TXT_MAJOR2Discipline (Description) PIQSMDISZIPTCHAR100TEXT100
CIP_TXT_MAJOR3Discipline (Description) PIQSMDISZIPTCHAR100TEXT100
CIP_TXT_MAJOR4Discipline (Description) PIQSMDISZIPTCHAR100TEXT100
CIP_TXT_MINOR1Discipline (Description) PIQSMDISZIPTCHAR100TEXT100
CIP_TXT_MINOR2Discipline (Description) PIQSMDISZIPTCHAR100TEXT100
CIP_TXT_MINOR3Discipline (Description) PIQSMDISZIPTCHAR100TEXT100
CIP_TXT_MINOR4Discipline (Description) PIQSMDISZIPTCHAR100TEXT100
CLASSProgression Class Result for a Progression Category. PIQ_US_CLASSCHAR1Assigned to domainPIQ_US_CLASS
FIRST_TIME_FULL_TIMEFirst Time Full Time PIQ_US_UNDERGRAD_FLAGCHAR1PIQ_US_YES_NO_FLAG
DEGREE_SEEKINGDegree Seeking PIQ_US_DEGREE_SEEKINGCHAR1PIQ_US_YES_NO_FLAG
HIGH_SCHOOL_CODEHigh School Code PIQ_US_HIGHSCHOOL_CODENUMC6NUMC06
GENDERGender of Student PIQ_US_GENDERCHAR1PIQ_US_GENDER
RACE_ETHINICITYRace/Ethnicity PIQ_US_RACE_ETHNICITYCHAR2CHAR02
COLLEGE_STUDENT_IDCollege Student Id PIQ_US_COLLEGE_STUD_IDCHAR20PIQ_US_COLLEGE_STUD_ID
STATE_STUDENT_IDState Student Id PIQ_US_STATE_STUD_IDCHAR30PIQ_US_STATE_STUD_ID
EMAIL_IDEmail Address of Student PMIQ_US_EMAILCHAR128PMIQ_US_EMAIL
GOOD_STUDENTGood Student PMIQ_US_GOOD_STUDENTCHAR1PIQ_US_YES_NO_FLAG

Key field Non-key field



How do I retrieve data from SAP structure PIQ_US_NSCH_ITEM using ABAP code?

As PIQ_US_NSCH_ITEM is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on PIQ_US_NSCH_ITEM as there is no data to select.

How to access SAP table PIQ_US_NSCH_ITEM

Within an ECC or HANA version of SAP you can also view further information about PIQ_US_NSCH_ITEM and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!