SAP UPF_PARAM Planning Functions: Parameterization Table data and field list

UPF_PARAM is a standard SAP Table which is used to store Planning Functions: Parameterization data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The UPF_PARAM table consists of various fields, each holding specific information or linking keys about Planning Functions: Parameterization data available in SAP. These include AREA (Planning Area), PLEVEL (Planning level), METHOD (Planning function), PARAM (Parameter Group)... 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. .

UPF_PARAM 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

Text table = UPF_PARAMT

Text table = UPF_PARAMT

Text table = UPF_PARAMT


SAP UPF_PARAM 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 UPF_PARAM 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 MANDTCLNT3T000MANDT
AREAPlanning Area UPC_Y_AREACHAR8UPC_AREAUPC_AREA
PLEVELPlanning level UPC_Y_PLEVELCHAR8UPC_PLEVELUPC_PLEVEL
METHODPlanning function UPC_Y_METHODCHAR8UPF_PLANFUPC_METHOD
PARAMParameter Group UPC_Y_PARAMCHAR8UPC_PARAM
REFIDUUID in compressed form (22 character UUENCODEd) SYSUUID_22CHAR22SYSUUID_22
VUPDAPlanning Functions: Overwrite Plan Data UPF_Y_VUPDACHAR1XFELD
STORVRetain Values at Sender UPF_Y_STORVALCHAR1XFELD
COUNTERChange counter UPC_Y_COUNTERNUMC3UPC_COUNTER
UNAMEUser Name UNAMECHAR12UNAME
AEDTMChanged on AEDTMDATS8DATUM
ATIMELast changed at AS4TIMETIMS6AS4TIME

Key field Non-key field



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

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

SELECT SINGLE *
FROM UPF_PARAM
INTO CORRESPONDING FIELDS OF WA_UPF_PARAM
WHERE...

How to access SAP table UPF_PARAM

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

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