P7404_EXP SAP (Education (Expanded)) Structure details

Dictionary Type: Structure
Description: Education (Expanded)




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




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

P7404_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 "Education (Expanded)" 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_P7404_EXP TYPE P7404_EXP.

The P7404_EXP table consists of various fields, each holding specific information or linking keys about Education (Expanded) 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 P7404_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 SUBTYPCHAR4T778USUBTYP
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
EDUCATION_TYPEEducation Type HRTMC_EDUCATION_TYPENUMC4T77TMC_EDUTYPHRTMC_EDUCATION_TYPE
EDUCATION_FIELDEducation Field HRTMC_EDUCATION_FIELDNUMC4T77TMC_EDUFLDHRTMC_EDUCATION_FIELD
INSTITUTEEducational Institute HRTMC_EDUCATION_INSTITUTECHAR80TEXT80
CITYCity AD_CITY1CHAR40TEXT40CLCITYNAME
REGIONSTATE (State, Province, County) REGIOCHAR3T005SREGIO
COUNTRYCountry Key LAND1CHAR3T005LAND1LND
FIELD_OF_STUDY1Field of Study HRTMC_FIELD_OF_STUDYCHAR80TEXT80
FIELD_OF_STUDY2Field of Study HRTMC_FIELD_OF_STUDYCHAR80TEXT80
FIELD_OF_STUDY3Field of Study HRTMC_FIELD_OF_STUDYCHAR80TEXT80
DEGREEDegree HRTMC_DEGREECHAR80TEXT80
GRADEGrade HRTMC_GRADECHAR4CHAR04
START_DATEStart of Education HRTMC_EDUCATION_START_DATEDATS8DATUM
END_DATEEnd of Education HRTMC_EDUCATION_END_DATEDATS8DATUM
HIGHEST_DEGREEHighest Degree HRTMC_HIGHEST_DEGREECHAR1HRTMC_HIGHEST_DEGREE
DEGREE_LEVELDegree Level HRTMC_DEGREE_LEVELNUMC2T77TMC_DEGREEHRTMC_DEGREE_LEVEL
COMMENT_CLASSDocument class SDOK_CLASSCHAR10Assigned to domainSDOK_CLASS
COMMENT_IDID for documents and relations SDOK_DOCIDCHAR32SDOK_DOCID
TABNRReference Number to Table Part HRTABNRCHAR32Assigned to domainHRTABNR
TABSEQNRSequence Number in Table Part of Table Infotype HRTABSEQNRNUMC6NUM06
DOCUMENT_CLASSDocument class SDOK_CLASSCHAR10Assigned to domainSDOK_CLASS
DOCUMENT_IDID for documents and relations SDOK_DOCIDCHAR32SDOK_DOCID

Key field Non-key field



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

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

How to access SAP table P7404_EXP

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