PIQ_NL_ADNLADM SAP (NL Additional Admission Details) Structure details

Dictionary Type: Structure
Description: NL Additional Admission Details




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




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

PIQ_NL_ADNLADM 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 "NL Additional Admission Details" 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_NL_ADNLADM TYPE PIQ_NL_ADNLADM.

The PIQ_NL_ADNLADM table consists of various fields, each holding specific information or linking keys about NL Additional Admission Details data available in SAP. These include PLVAR (Plan Version), ST_OBJID (Object ID of Student), CS_OBJID (Object ID of Study Object (CS)), SC_OBJID (Program ID).. 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_NL_ADNLADM 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
PLVARPlan Version PLVARCHAR2Assigned to domainPLVARPOP
ST_OBJIDObject ID of Student PIQSTUDENTNUMC8Assigned to domainHROBJIDSTUDENT
CS_OBJIDObject ID of Study Object (CS) PIQCSOBJIDNUMC8Assigned to domainHROBJID
SC_OBJIDProgram ID PIQSCOBJIDNUMC8Assigned to domainHROBJIDPON
BEGDAValid-From Date PIQ_BEGDADATS8DATUM
ENDDAValid-To Date PIQ_ENDDADATS8DATUM
ISTATAdmission Application Status PIQADMSTATECHAR1PIQADMSTATE
SEQNRNumber of Infotype Record with Same Key SEQNRNUMC3NUM03
CHOICE_NOProgram Choice PIQCHOICE_NONUMC2T7PIQCHOICESPIQCHOICE_NO
ADM_AYEARAcademic Year PIQPERYRNUMC4T7PIQYEARPRDPIQPERYR
ADM_PERIDAcademic Session PIQPERIDNUMC3T7PIQYEARPRDPIQPERID
ADM_ACLEVELStage PIQLEVELNUMC2T7PIQLEVELPIQLEVEL
ADM_PROGCLASSProgress Classification PIQPROGCLASSCHAR4T7PIQPROGCLASSPIQPROGCLASS
ADM_PARTTIndicator: Part-Time Study PIQPARTTCHAR1XFELD
ADM_CATEGAdmission Category PIQADM_CATEGCHAR2T7PIQADMCATEGPIQADM_CATEG
ADM_ENRCATEGRegistration Type PIQENRCATEGCHAR2T7PIQENRCATEGPIQENRCATEG
ADM_CODEAdmission Code PIQADMCODECHAR12CHAR12
ADM_PERCTCompleted Length of Study PIQPERCTNUMC3PIQPERCT
ADM_QMNUMNotification No QMNUMCHAR12Assigned to domainALPHAQMNUMIQM
ADM_STATUS_SUPStatus Supplement PIQADMSTSUPCHAR4PIQPROCESSSTSUP
ADM_DECDecision Date of Rejection or Admission PIQADM_DECDATS8DATS
ADM_RECPTDate of Admission Application Receipt PIQADM_RECPTDATS8DATS
ADM_WITH_DECLDate of Withdrawal or Declination PIQADM_WITH_DECLDATS8DATS
ADM_GUIDUnique Key (GUID) of the Admission PIQADM_GUIDCHAR32SYSUUID_C
COKEYCorrespondence key COKEY_KKCHAR36COKEY_KK
BRINNUMBERBRIN Number PIQ_NL_BRINNUMBERCHAR4PIQ_NL_BRINNUMBER
BRINSEQUENCEBRIN Sequence Number PIQ_NL_BRINSEQUENCENUMC2NUMC2
LOCATIONLocation PIQ_NL_LOCATIONCHAR24CHAR24
ENROLLFORMCODEEnrollment Form Code PIQ_NL_ENROLLFORMCODECHAR1Assigned to domainPIQ_NL_ENROLLFORMCODE
ENROLLMOMENTCODEEnrollment Moment Code PIQ_NL_ENROLLMOMENTCODECHAR12CHAR12
FIRSTYEARFirst Year Check PIQ_NL_FIRSTYEARCHAR1FUNC
COMPREQSTATUSComplementary Requirements Status PIQ_NL_COMPREQSTATUSCHAR1Assigned to domainPIQ_NL_COMPREQSTATUS
ACTIVITIESSTATUSActivity Status PIQ_NL_ACTIVITIESSTATUSCHAR1Assigned to domainPIQ_NL_ACTIVITIESSTATUS
LANGTESTLanguage Test PIQ_NL_LANGTESTCHAR1Assigned to domainPIQ_NL_LANGTEST
LOTTERYLottery PIQ_NL_LOTTERYCHAR1Assigned to domainPIQ_NL_LOTTERY
LOTTERYSEQUENCELottery Sequence Number PIQ_NL_LOTTERYSEQUENCENUMC3NUMC3
LOTTERYDRAWLottery Draw PIQ_NL_LOTTERYDRAWCHAR1Assigned to domainPIQ_NL_LOTTERYDRAW
IBGSTATUSIBG Status PIQ_NL_IBGSTATUSCHAR1Assigned to domainPIQ_NL_IBGSTATUS
PLACEISSUEDATEPlacement Issue Date PIQ_NL_PLACEISSUEDATEDATS8DATS
LOTTERYRESULTLottery Results PIQ_NL_LOTTERYRESULTCHAR1Assigned to domainPIQ_NL_LOTTERYRESULT
REASONFORRESEVEReason for Reservation PIQ_NL_REASONCHAR1Assigned to domainPIQ_NL_REASON
REASONFORREJECTReason for Rejection PIQ_NL_REASONREJECTCHAR1Assigned to domainPIQ_NL_REASONREJECT
REASONFORTERMINReason for Termination PIQ_NL_TERMINATIONCHAR1Assigned to domainPIQ_NL_TERMINATION
INTERVIEWCheckbox PIQ_NL_CHECKCHAR1FLAG
MOTIVATIONCheckbox PIQ_NL_CHECKCHAR1FLAG
EXPERIENCECheckbox PIQ_NL_CHECKCHAR1FLAG
INTERNATIONALEXPCheckbox PIQ_NL_CHECKCHAR1FLAG
WORKEXPCheckbox PIQ_NL_CHECKCHAR1FLAG
OTHERCheckbox PIQ_NL_CHECKCHAR1FLAG
DELAYEDENROLLCheckbox PIQ_NL_CHECKCHAR1FLAG
ENROLLHIGHYEARCheckbox PIQ_NL_CHECKCHAR1FLAG
DEFRAYMENTCODECheckbox PIQ_NL_CHECKCHAR1FLAG
DEFICIENCYSTATUSDeficiency status PIQ_NL_DEFICIENCYSTATUSCHAR1Assigned to domainPIQ_NL_DEFICIENCYSTATUS
REQFORRESTITRequest for Restitution PIQ_NL_REASONRESTITUTECHAR1PIQ_NL_REASONRESTITUTE
FULLTPARTTForm of Education Code PIQ_NL_FULLTPARTTCHAR1PIQ_NL_FULLTPARTT
ENRSTARTDATEDate PIQ_NL_DATEDATS8DATS
EDUPHASECODEEducation Phase Code PIQ_NL_EDUPHASECODECHAR1T7PIQ_NL_EDUPHACHAR1
FIRSTYEARACCCheckbox PIQ_NL_CHECKCHAR1FLAG
UNENDESDATEDate PIQ_NL_DATEDATS8DATS
MSG34SENTCheckbox PIQ_NL_CHECKCHAR1FLAG
REQUESTGRANTEDRequest Granted for Deregistration PIQ_NL_REQUESTGRANTEDCHAR1PIQ_NL_REQUESTGRANTED
TABNRReference Number to Table Part HRTABNRCHAR32Assigned to domainHRTABNR
DEREG_DECDATEDecision Date PIQ_NL_DECDATEDATS8DATS
REGNUMRegistration Number PIQ_NL_REGNUMBERCHAR20CHAR20
REGNUM_OLDRegistration Number PIQ_NL_REGNUMBERCHAR20CHAR20

Key field Non-key field



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

As PIQ_NL_ADNLADM 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_NL_ADNLADM as there is no data to select.

How to access SAP table PIQ_NL_ADNLADM

Within an ECC or HANA version of SAP you can also view further information about PIQ_NL_ADNLADM 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!