HRP1689 SAP (DB Table for Infotype 1689) Table details

Dictionary Type: Table
Description: DB Table for Infotype 1689




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




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

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

The HRP1689 table consists of various fields, each holding specific information or linking keys about DB Table for Infotype 1689 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 (Deep)


SAP HRP1689 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
SCLASType of Related Object SCLASCHAR2Assigned to domainOTYPE
SOBIDID of Related Object SOBIDCHAR45CHAR45
KOBESCost item KOBESCHAR8T77KBKOBES
PRDIRDirect entry of price PRDIRCHAR1CHAR1_X
PRICEProposed amount PRICECURR15(2) WERT8
WAERSCurrency Key WAERSCUKY5TCURCWAERSFWS
BUNITReference unit BUNITCHAR1BUNIT
BZGMETime Unit PEBZGMEUNIT3T006CUNITMEINS
.INCLU-001 0
KOBES001Cost item KOBESCHAR8T77KBKOBES
PRDIR001Direct entry of price PRDIRCHAR1CHAR1_X
PRICE001Proposed amount PRICECURR15(2) WERT8
WAERS001Currency Key WAERSCUKY5TCURCWAERSFWS
BUNIT001Reference unit BUNITCHAR1BUNIT
BZGME001Time Unit PEBZGMEUNIT3T006CUNITMEINS
.INCLU-002 0
KOBES002Cost item KOBESCHAR8T77KBKOBES
PRDIR002Direct entry of price PRDIRCHAR1CHAR1_X
PRICE002Proposed amount PRICECURR15(2) WERT8
WAERS002Currency Key WAERSCUKY5TCURCWAERSFWS
BUNIT002Reference unit BUNITCHAR1BUNIT
BZGME002Time Unit PEBZGMEUNIT3T006CUNITMEINS
.INCLU-003 0
KOBES003Cost item KOBESCHAR8T77KBKOBES
PRDIR003Direct entry of price PRDIRCHAR1CHAR1_X
PRICE003Proposed amount PRICECURR15(2) WERT8
WAERS003Currency Key WAERSCUKY5TCURCWAERSFWS
BUNIT003Reference unit BUNITCHAR1BUNIT
BZGME003Time Unit PEBZGMEUNIT3T006CUNITMEINS
.INCLU-004 0
KOBES004Cost item KOBESCHAR8T77KBKOBES
PRDIR004Direct entry of price PRDIRCHAR1CHAR1_X
PRICE004Proposed amount PRICECURR15(2) WERT8
WAERS004Currency Key WAERSCUKY5TCURCWAERSFWS
BUNIT004Reference unit BUNITCHAR1BUNIT
BZGME004Time Unit PEBZGMEUNIT3T006CUNITMEINS
.INCLU-005 0
KOBES005Cost item KOBESCHAR8T77KBKOBES
PRDIR005Direct entry of price PRDIRCHAR1CHAR1_X
PRICE005Proposed amount PRICECURR15(2) WERT8
WAERS005Currency Key WAERSCUKY5TCURCWAERSFWS
BUNIT005Reference unit BUNITCHAR1BUNIT
BZGME005Time Unit PEBZGMEUNIT3T006CUNITMEINS
.INCLU-006 0
KOBES006Cost item KOBESCHAR8T77KBKOBES
PRDIR006Direct entry of price PRDIRCHAR1CHAR1_X
PRICE006Proposed amount PRICECURR15(2) WERT8
WAERS006Currency Key WAERSCUKY5TCURCWAERSFWS
BUNIT006Reference unit BUNITCHAR1BUNIT
BZGME006Time Unit PEBZGMEUNIT3T006CUNITMEINS
.INCLU-007 0
KOBES007Cost item KOBESCHAR8T77KBKOBES
PRDIR007Direct entry of price PRDIRCHAR1CHAR1_X
PRICE007Proposed amount PRICECURR15(2) WERT8
WAERS007Currency Key WAERSCUKY5TCURCWAERSFWS
BUNIT007Reference unit BUNITCHAR1BUNIT
BZGME007Time Unit PEBZGMEUNIT3T006CUNITMEINS
.INCLU-008 0
KOBES008Cost item KOBESCHAR8T77KBKOBES
PRDIR008Direct entry of price PRDIRCHAR1CHAR1_X
PRICE008Proposed amount PRICECURR15(2) WERT8
WAERS008Currency Key WAERSCUKY5TCURCWAERSFWS
BUNIT008Reference unit BUNITCHAR1BUNIT
BZGME008Time Unit PEBZGMEUNIT3T006CUNITMEINS

Key field Non-key field



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

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

SELECT SINGLE *
FROM HRP1689
INTO CORRESPONDING FIELDS OF WA_HRP1689
WHERE...

How to access SAP table HRP1689

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