HRP1718 SAP (DB Table for Infotype 1718) Table details

Dictionary Type: Table
Description: DB Table for Infotype 1718




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




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

HRP1718 is a standard SAP Table which is used to store DB Table for Infotype 1718 data and is available within R/3 SAP systems depending on the version and release level.

The HRP1718 table consists of various fields, each holding specific information or linking keys about DB Table for Infotype 1718 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: C - Customising table, maintenance only by cust
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)


SAP HRP1718 table 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 HROBJIDNUMC8PLOGIHROBJIDPON
SUBTYSubtype SUBTYPCHAR4Assigned to domainSUBTYP
ISTATPlanning Status ISTAT_DCHAR1T778SISTATPST
BEGDAStart Date BEGDATUMDATS8DATUMBEG
ENDDAEnd Date ENDDATUMDATS8DATUMEND
VARYFVariation Field for File PLOG VARYFCHAR10CHAR10
SEQNRNumber of Infotype Record with Same Key SEQNRNUMC3NUM03
INFTYInfotype INFOTYPCHAR4T778TINFOTYPHRBAS00INFTY
OTJIDConcatenation of Object Type and Object ID OTJIDCHAR10CHAR10
AEDTMChanged on AEDTMDATS8DATUM
UNAMEUser Name USRNAMECHAR12CHAR12
REASNReason REASNCHAR2CHAR2
HISTOHistorical Record Flag HISTOCHAR1CHAR1
ITXNRText Module for Infotype ITXNRNUMC8NUM08
ARBGBName of Employer or Company PIQPE_EMPLOYERCHAR20TEXT20
ORT01Location of Employer or Company PIQPE_ORT01CHAR25TEXT25
LAND1Country Key LAND1CHAR3T005LAND1LND
BRANCIndustry key BRSCHCHAR4T016BRSCH
TAETEPresent or Previous Job PIQPE_ACTIVITYNUMC8T513CTAESL
TAETEBSCHRJob (Description) PIQPE_ACTIVITYDESCCHAR120TEXT120
ANSVXWork Contract Concluded With Employer PIQPE_EMPLOYTYPECHAR2T542CANSVX
INST_PARTNEROffering Institution PIQINST_BUPACHAR10BUT000ALPHABU_PARTNER
CONTACT_PARTNERInternship Contact Person PIQISH_CONTACTCHAR10BUT000ALPHABU_PARTNER
ACAD_YEARAcademic Year PIQPERYRNUMC4T7PIQYEARPIQPERYR
ACAD_SESSIONAcademic Session PIQPERIDNUMC3T7PIQPERIODPIQPERID
ISHREG_IDInternship Registration ID PIQISHREG_IDCHAR32SYSUUID_C32
START_DATEInternship Begin Date PIQISH_BEGDADATS8DATE
END_DATEInternship End Date PIQISH_ENDDADATS8DATE
TEXTInternship Registration (Description) PIQISH_TEXTCHAR60TEXT60
STATUSInternship Registration Status PIQISH_STATUSCHAR4T7PIQISHSTATUSPIQISH_STATUS
CATEGORY1Internship Category 1 PIQISH_CAT1CHAR6T7PIQISHCAT1PIQISH_CAT1
CATEGORY2Internship Category 2 PIQISH_CAT2CHAR6T7PIQISHCAT2PIQISH_CAT2
CATEGORY3Internship Category 3 PIQISH_CAT3CHAR6T7PIQISHCAT3PIQISH_CAT3
CATEGORY4Internship Category 4 PIQISH_CAT4CHAR6T7PIQISHCAT4PIQISH_CAT4
CATEGORY5Internship Category 5 PIQISH_CAT5CHAR6T7PIQISHCAT5PIQISH_CAT5
ATTRIBUTE1Internship Attribute 1 PIQISH_ATTR1CHAR40PIQISH_ATTR
ATTRIBUTE2Internship Attribute 2 PIQISH_ATTR2CHAR40PIQISH_ATTR
ATTRIBUTE3Internship Attribute 3 PIQISH_ATTR3CHAR40PIQISH_ATTR
ATTRIBUTE4Internship Attribute 4 PIQISH_ATTR4CHAR40PIQISH_ATTR
ATTRIBUTE5Internship Attribute 5 PIQISH_ATTR5CHAR40PIQISH_ATTR
GUIDTYPEUnique Identification Type (GUID) PIQCMPR_GUIDTYPECHAR4Assigned to domainPIQGUIDTYPE
GUIDUnique Key (ID) PIQCMPR_GUIDREFCHAR32SYSUUID_C
SC_OBJIDProgram ID PIQSCOBJIDNUMC8Assigned to domainHROBJIDPON
ACLEVELStage PIQLEVELNUMC2Assigned to domainPIQLEVEL
REF_OTYPEObject Type OTYPECHAR2Assigned to domainOTYPEPOT
REF_OBJIDObject ID HROBJIDNUMC8Assigned to domainHROBJIDPON
NOTE_GUIDGUID - Unique Note Identifier PIQNOTE_GUIDCHAR32SYSUUID_C
DURATIONInternship Duration PIQISH_DURATIONNUMC3PIQISH_DUR
UNITInternship Duration Unit PIQISH_UNITCHAR1PIQISH_UNIT
FULLPART_INDUCAS: Full-Time Indicator PIQ_GB_UCAS_FULLPART_TIMECHAR1PIQ_GB_UCAS_FULLPART_TIME

Key field Non-key field



How do I retrieve data from SAP table HRP1718 using ABAP code

The following ABAP code Example will allow you to do a basic selection on HRP1718 to SELECT all data from the table
DATA: WA_HRP1718 TYPE HRP1718.

SELECT SINGLE *
FROM HRP1718
INTO CORRESPONDING FIELDS OF WA_HRP1718
WHERE...

How to access SAP table HRP1718

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