SAP UPS_LINKS Links to Org. Values Table data and field list

UPS_LINKS is a standard SAP Table which is used to store Links to Org. Values data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The UPS_LINKS table consists of various fields, each holding specific information or linking keys about Links to Org. Values data available in SAP. These include ORGVL (Org. Value for Status and Tracking System), TEILPLAN (Subplan in STS), VERSION (Planning Session/Version), STARTDATE (Field of type DATS)... 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. .

UPS_LINKS table Technical Details:

Delivery Class: C - Customising table, maintenance only by cust
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP UPS_LINKS table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the UPS_LINKS table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
ORGVLOrg. Value for Status and Tracking System UPS_Y_ORGVLCHAR32
TEILPLANSubplan in STS UPS_Y_TEILPLANCHAR8
VERSIONPlanning Session/Version UPS_Y_VERSIONNUMC3
STARTDATEField of type DATS DATSDATS8DATS
DUEDATEField of type DATS DATSDATS8DATS
DUETIMEField of type TIMS TIMSTIMS6TIME
TSTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMPDEC15TZNTSTMPS
TZONETime Zone TIMEZONECHAR6Assigned to domainTZNZONE
PLANLINK Link to Planning0
APPROLINK Link to Approval Layouts0
WORKLIST Link to Worklist (Later)0

Key field Non-key field



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

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

SELECT SINGLE *
FROM UPS_LINKS
INTO CORRESPONDING FIELDS OF WA_UPS_LINKS
WHERE...

How to access SAP table UPS_LINKS

Within an ECC or HANA version of SAP you can also view further information about UPS_LINKS and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).