P1785_EXP SAP (Infotype 1785 expanded structures) Structure details

Dictionary Type: Structure
Description: Infotype 1785 expanded structures




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




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

P1785_EXP 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 "Infotype 1785 expanded structures" 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_P1785_EXP TYPE P1785_EXP.

The P1785_EXP table consists of various fields, each holding specific information or linking keys about Infotype 1785 expanded structures data available in SAP. These include MANDT (Client), PLVAR (Plan Version), OTYPE (Object Type), OBJID (Object 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 P1785_EXP 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
MANDTClient MANDTCLNT3T000MANDT
PLVARPlan Version PLVARCHAR2T778PPLVARPOP
OTYPEObject Type OTYPECHAR2T778OOTYPEPOT
OBJIDObject ID OBJEKTIDNUMC8NUM08PON
INFTYInfotype INFOTYPCHAR4T778TINFOTYPHRBAS00INFTY
SUBTYSubtype SUBTYPCHAR4Assigned to domainSUBTYP
ISTATPlanning Status ISTAT_DCHAR1T778SISTATPST
PRIOXPriority PRIOXCHAR2CHAR2
BEGDAStart Date BEGDATUMDATS8DATUMBEG
ENDDAEnd Date ENDDATUMDATS8DATUMEND
VARYFVariation Field for File PLOG VARYFCHAR10CHAR10
SEQNRNumber of Infotype Record with Same Key SEQNRNUMC3NUM03
AEDTMChanged on AEDTMDATS8DATUM
UNAMEUser Name USRNAMECHAR12CHAR12
REASNReason REASNCHAR2CHAR2
HISTOHistorical Record Flag HISTOCHAR1CHAR1
ITXNRText Module for Infotype ITXNRNUMC8NUM08
STATUSUCAS: Flag for previous/final results PIQ_GB_UCAS_RESULT_STATUSCHAR1PIQ_GB_UCAS_RESULT_STATUS
MATCH_INDUCAS: Match indicator PIQ_GB_UCAS_MATCH_INDCCHAR1T7PIQ_GB_MATCHPIQ_GB_UCAS_MATCH_INDC
EXTORGIDExternal Organization ID PIQEXTORGIDNUMC8Assigned to domainHROBJIDPONHRPIQ00EXTORG
SUMMER_GCE_A_ASUCAS: No. of Summer GCE A/AS-Levels PIQ_GB_UCAS_GCE_A_ASNUMC1PIQ_GB_UCAS_NO_RESULTS
SUMMER_AUCAS: No. of Summer (revised do not use) PIQ_GB_UCAS_SUMMER_ANUMC1PIQ_GB_UCAS_NO_RESULTS
SUMMER_VCE_A_ASUCAS: No. of Summer VCE AS/A-Levels and Doubles PIQ_GB_UCAS_VCE_A_AS_DBNUMC1PIQ_GB_UCAS_NO_RESULTS
SUMMER_ASUCAS: No. of Summer (revised do not use) PIQ_GB_UCAS_SUMMER_ASNUMC1PIQ_GB_UCAS_NO_RESULTS
WINTER_AUCAS: No. of Winter A-Levels PIQ_GB_UCAS_WINTER_ANUMC1PIQ_GB_UCAS_NO_RESULTS
PREV_SUMMER_RESUCAS: No. of previous (revised do not use) PIQ_GB_UCAS_PREV_RESULTSNUMC1PIQ_GB_UCAS_NO_RESULTS
PREV_SUMMER_AUCAS: No. of previous Summer A-Levels PIQ_GB_UCAS_PREV_ANUMC1PIQ_GB_UCAS_NO_RESULTS
PREV_ASUCAS: No. of previous AS-Levels PIQ_GB_UCAS_PREV_ASNUMC1PIQ_GB_UCAS_NO_RESULTS
HIGHERSCM UCAS: No of Highers (revised do not use) PIQ_GB_UCAS_HIGHERSNUMC1PIQ_GB_UCAS_NO_RESULTS
CSYSCM UCAS: No of CSYS (revised do not use) PIQ_GB_UCAS_CSYSNUMC1PIQ_GB_UCAS_NO_RESULTS
BTEC_FLAGUCAS: BTEC Flag PIQ_GB_UCAS_BTECCHAR1PIQ_GB_UCAS_BTEC
HIG_FLAGUCAS: HSC/IBAC Flag PIQ_GB_UCAS_HHIQ_FLAGCHAR1T7PIQ_GB_HSCPIQ_GB_UCAS_HHIQ_FLAG
IRISH_FLAGUCAS: Irish Leaving Certification Flag PIQ_GB_UCAS_IRISH_FLAGCHAR1PIQ_GB_UCAS_IRISH_FLAG
OTHER_RESULTSUCAS: Other A/AS/Highers/CSYS Flag PIQ_GB_UCAS_OTHER_RESULTSCHAR1PIQ_GB_UCAS_OTHER_RESULTS
REC_ACHIEVMNTUCAS: Record of Achievement PIQ_GB_UCAS_REC_ACHIEVMNTCHAR1PIQ_GB_UCAS_REC_ACHIEVMNT
REG_NUMBERUCAS: BTEC/SQA Scottish Cand. Number PIQ_GB_UCAS_REG_NUMCHAR13PIQ_GB_UCAS_REG_NUM
QEQUCAS: OEQ Flag PIQ_GB_UCAS_QEQCHAR1T7PIQ_GB_QEQPIQ_GB_UCAS_QEQ
SQA_FLAGUCAS: Flag SQA applicant PIQ_GB_UCAS_SQA_FLAGCHAR1PIQ_GB_UCAS_SQA_FLAG
GCEASNCM UCAS: Number of GCE AS level PIQ_GB_UCAS_TR_GCEASNNUMC1PIQ_GB_UCAS_TR_NUM
GCEASTSCM UCAS: Tariff Score for GCE AS Level PIQ_GB_UCAS_TR_GCEASTSNUMC3PIQ_GB_UCAS_TR_SCORE
VCEASNCM UCAS: Number of VCE AS level PIQ_GB_UCAS_TR_VCEASNNUMC1PIQ_GB_UCAS_TR_NUM
VCEASTSCM UCAS: Tariff Score for VCE AS Level PIQ_GB_UCAS_TR_VCEASTSNUMC3PIQ_GB_UCAS_TR_SCORE
GCEANCM UCAS: Number of GCE A level PIQ_GB_UCAS_TR_GCEANNUMC1PIQ_GB_UCAS_TR_NUM
GCEATSCM UCAS: Tariff Score for GCE A Level PIQ_GB_UCAS_TR_GCEATSNUMC3PIQ_GB_UCAS_TR_SCORE
VCEANCM UCAS: Number of VCE A level PIQ_GB_UCAS_TR_VCEANNUMC1PIQ_GB_UCAS_TR_NUM
VCEATSCM UCAS: Tariff Score for VCE A Level PIQ_GB_UCAS_TR_VCEATSNUMC3PIQ_GB_UCAS_TR_SCORE
KSQNCM UCAS: Number of Key Skills PIQ_GB_UCAS_TR_KSQNNUMC1PIQ_GB_UCAS_TR_NUM
KSQTSCM UCAS: Tariff score for Key Skills qualification PIQ_GB_UCAS_TR_KSQTSNUMC3PIQ_GB_UCAS_TR_SCORE
UKSANCM UCAS: Number of 1-unit award Key Skills PIQ_GB_UCAS_TR_UKSANNUMC1PIQ_GB_UCAS_TR_NUM
UKSATSCM UCAS: Tariff score for 1-unit key skills award PIQ_GB_UCAS_TR_UKSATSNUMC3PIQ_GB_UCAS_TR_SCORE
SAHNCM UCAS: Number of Scottish Advanced Higher PIQ_GB_UCAS_TR_SAHNNUMC1PIQ_GB_UCAS_TR_NUM
SAHTSCM UCAS: Tariff score for Scottish Advanced Higher PIQ_GB_UCAS_TR_SAHTSNUMC3PIQ_GB_UCAS_TR_SCORE
SHNCM UCAS: Number of Scottish Higher PIQ_GB_UCAS_TR_SHNNUMC1PIQ_GB_UCAS_TR_NUM
SHTSCM UCAS: Tariff score for Scottish Higher PIQ_GB_UCAS_TR_SHTSNUMC3PIQ_GB_UCAS_TR_SCORE
SI2NCM UCAS: Number of Scottish Intermediate PIQ_GB_UCAS_TR_SI2NNUMC1PIQ_GB_UCAS_TR_NUM
SI2TSCM UCAS: Tariff score for Scottish Intermediate 2 PIQ_GB_UCAS_TR_SI2TSNUMC3PIQ_GB_UCAS_TR_SCORE
SSGCNCM UCAS: Number of Scottish Standard Grade Credit PIQ_GB_UCAS_TR_SSGCNNUMC1PIQ_GB_UCAS_TR_NUM
SSGCTSCM UCAS: Tariff score for Scottish Standard Grade Credit PIQ_GB_UCAS_TR_SSGCTSNUMC3PIQ_GB_UCAS_TR_SCORE
SCSNCM UCAS: Number of Scottish Core Skills PIQ_GB_UCAS_TR_SCSNNUMC1PIQ_GB_UCAS_TR_NUM
SCSTSCM UCAS: Tariff score for Scottish Core Skills PIQ_GB_UCAS_TR_SCSTSNUMC3PIQ_GB_UCAS_TR_SCORE
AEANCM UCAS: Number of Advanced Extension Awards PIQ_GB_UCAS_TR_AEANNUMC1PIQ_GB_UCAS_TR_NUM
AEANTSCM UCAS: Tariff score for Advanced Extension Awards PIQ_GB_UCAS_TR_AEANTSNUMC3PIQ_GB_UCAS_TR_SCORE
TOTALTSCM UCAS: Total Tariff Score PIQ_GB_UCAS_TR_TOTALTSNUMC3PIQ_GB_UCAS_TR_SCORE
CACHENCM UCAS: Number of CACHE qualifications PIQ_GB_UCAS_TR_CACHENNUMC1PIQ_GB_UCAS_TR_NUM
CACHETSCM UCAS: Tariff Score for CACHE qualifications PIQ_GB_UCAS_TR_CACHETSNUMC3PIQ_GB_UCAS_TR_SCORE
BTECNCM UCAS: Number of BTEC National PIQ_GB_UCAS_TR_BTECNNUMC1PIQ_GB_UCAS_TR_NUM
BTECTSCM UCAS: Tariff Score for BTEC National PIQ_GB_UCAS_TR_BTECTSNUMC3PIQ_GB_UCAS_TR_SCORE
IBTSCM UCAS: Tariff Score for International Baccalaureate PIQ_GB_UCAS_TR_IBTSNUMC3PIQ_GB_UCAS_TR_SCORE
ILCTSCM UCAS: Tariff Score for Irish Leaving Certificate PIQ_GB_UCAS_TR_ILCTSNUMC3PIQ_GB_UCAS_TR_SCORE
MDPATSCM UCAS: Tariff Score for Music, Drama, Performing Arts PIQ_GB_UCAS_TR_MDPATSNUMC3PIQ_GB_UCAS_TR_SCORE
TABNRReference Number to Table Part HRTABNRCHAR32Assigned to domainHRTABNR
TABSEQNRSequence Number in Table Part of Table Infotype HRTABSEQNRNUMC6NUM06
T_OTYPEObject Type OTYPECHAR2T778OOTYPEPOT
SUBJECTSchool Subject, Academic Subject, or Qualification PIQSUBJECTNUMC8Assigned to domainHROBJIDHRPIQ00SUBJECT
ORGMARKOriginal Grade PIQORGMARKCHAR10T7PIQ_GB_POINTSPIQORGMARK
QUALITYUCAS: Grade type (Qualification) PIQ_GB_UCAS_GRADE_TYPECHAR4T7PIQ_GB_RESTYPPIQ_GB_UCAS_GRADE_TYPE
GRADE_BANDUCAS: Special paper grade band PIQ_GB_UCAS_GRADE_BANDCHAR4Assigned to domainPIQ_GB_UCAS_GRADE_BAND
GRADE_2UCAS: Grade 2 PIQ_GB_UCAS_GRADECHAR1T7PIQ_GB_POINTSPIQ_GB_UCAS_GRADE
EXAM_BOARDUCAS: Exam Board Code PIQ_GB_UCAS_EX_BOARDCHAR1T7PIQ_GB_EBOARDPIQ_GB_UCAS_EX_BOARD
MARKDATEReference Date for Grade PIQMARKDATEDATS8
EXAM_LEVEL_CODEUCAS Exam Level Code PIQ_GB_EXAM_LEVEL_CODECHAR4T7PIQ_GB_EXLVLCDPIQ_GB_EXAM_LEVEL_CODE
SITTINGUCAS: Sitting PIQ_GB_UCAS_SITTNGCHAR1PIQ_GB_UCAS_SITTNG
LAST_UPDATEDUCAS: Last Updated Date PIQ_GB_UCAS_LAST_UPDATEDDATS8DATS
EXAM_YEARUCAS: Exam Year PIQ_GB_UCAS_EXAM_YEARNUMC4Assigned to domainPIQPERYR

Key field Non-key field



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

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

How to access SAP table P1785_EXP

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