SAP UPF_YS_TECHF Planning: Technical Error Table data and field list

UPF_YS_TECHF 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 "Planning: Technical Error" 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_UPF_YS_TECHF TYPE UPF_YS_TECHF.

The UPF_YS_TECHF table consists of various fields, each holding specific information or linking keys about Planning: Technical Error data available in SAP. These include REVAL (Planning: Revaluation Percentage Rate), DSTRB (Planning: Distribution Factor), PRSTR (Forecast Strategy), ALPHX (Basic value smoothing using alpha factor)... 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_YS_TECHF structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP UPF_YS_TECHF structure 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_YS_TECHF 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
RATIOPlanning: Key figure UPF_Y_RATIOCHAR30Assigned to domainFDNAME
REVALPlanning: Revaluation Percentage Rate UPF_Y_REVALDEC7(3)
DSTRBPlanning: Distribution Factor UPF_Y_DSTRBDEC6(3)
PRSTRForecast Strategy UPF_Y_PRSTRCHAR2UPF_D_PRSTR
ALPHXBasic value smoothing using alpha factor ALPHADEC3(2) GLATT
BETAXTrend value smoothing using the beta factor BETA1DEC3(2) GLATT
GAMMXSeasonal index smoothing using gamma factor GAMMADEC3(2) GLATT
PERANNumber of historical periods PERANDEC3PERAN
GEWGRWeighting group GEWGRCHAR2Assigned to domainGEWGR
PERIONumber of periods per seasonal cycle PERIODEC3PERAN
KURSTExchange Rate Type KURST_CURRCHAR4TCURVKURST
TRATIOPlanning: Target Key Figure UPF_Y_TRATIOCHAR30Assigned to domainFDNAME
FRATIOPlanning: Source Key Figure UPF_Y_FRATIOCHAR30Assigned to domainFDNAME
TCURRPlanning: Target Currency UPF_Y_TCURRCUKY5TCURCWAERS
TCDIMPlanning: Characteristic Target Currency UPF_Y_TCDIMCHAR30Assigned to domainFDNAME
CDATEPlanning: Conversion Date UPF_Y_CDATEDATS8DATS
ACTDTPlanning: Currency Translation with Current Date UPF_Y_ACTDTCHAR1XFELD
TIMRFTime Reference Field for Currency Translation UPC_Y_TIMEREFCHAR1UPC_TIMEREF
TQUANPlanning: Target Unit UPF_Y_TQUANUNIT3T006CUNITMEINS
TQDIMPlanning: Characteristic Target Unit UPF_Y_TQDIMCHAR30Assigned to domainFDNAME
VAR_NUMBERNumeric Value for Variables UPC_Y_VAR_NUMBERDEC31(9) UPC_VAR_NUMBER
STRATForecast Strategy UPF_Y_FC_STRCHAR2UPF_D_FC_STR
TDAMPTrand Dampening is Active UPF_Y_FC_TDAMPCHAR1UPF_D_BOOL
TDAMPFACTrend Dampening Factor UPF_Y_TREND_DAMPENINGDEC4(3)
OUTLOutlier Correction UPF_Y_OUTLIER_CORRECTIONCHAR1UPF_D_BOOL
SIGFACSigma Factor for Outlier Correction UPF_Y_SIGMA_FACTORDEC4(3)
MAORDOrder of Moving Average (Time Frame Length) UPF_Y_MA_ORDERDEC2
NONNEGATIVESet Negative Forecast Values to Zero UPF_Y_FC_NONNEGATIVECHAR1UPF_D_BOOL
DISREGIgnore Initial Zeros UPF_Y_DISREGCHAR1XFELD
STATLog Statistical Key Figures UPF_Y_FC_STATISTICSCHAR1UPF_D_BOOL
ALPHASmoothing Factor Alpha (Basic Value) UPF_E_ALPHADEC4(3) UPF_D_SMOOTH
BETASmoothing Factor Beta (Trend Value) UPF_E_BETADEC4(3) UPF_D_SMOOTH
GAMMASmoothing Factor Gamma (Seasonal Component) UPF_E_GAMMADEC4(3) UPF_D_SMOOTH
NO_OPTManual Entry of Smoothing Factors UPF_Y_FC_NO_OPTCHAR1UPF_D_BOOL
OPTOptimization of Smoothing Factors UPF_Y_FC_OPTCHAR1UPF_D_BOOL
OPTVAROptimization Variable UPF_Y_FC_OPT_VARIABLECHAR5UPF_D_FC_OPT_VARIABLE
ALPHA_FLower Limit Alpha for Optimization UPF_Y_ALPHA_FROMDEC4(3) UPF_D_SMOOTH
ALPHA_TUpper Limit Alpha for Optimization UPF_Y_ALPHA_TODEC4(3) UPF_D_SMOOTH
ALPHA_SStepsize Alpha for Optimization UPF_Y_ALPHA_STEPSIZEDEC4(3) UPF_D_SMOOTH
BETA_FLower Limit Beta for Optimization UPF_Y_BETA_FROMDEC4(3) UPF_D_SMOOTH
BETA_TUpper Limit Beta for Optimization UPF_Y_BETA_TODEC4(3) UPF_D_SMOOTH
BETA_SStepsize Beta for Optimization UPF_Y_BETA_STEPSIZEDEC4(3) UPF_D_SMOOTH
GAMMA_FLower Limit Gamma for Optimization UPF_Y_GAMMA_FROMDEC4(3) UPF_D_SMOOTH
GAMMA_TUpper Limit Gamma for Optimization UPF_Y_GAMMA_TODEC4(3) UPF_D_SMOOTH
GAMMA_SStepsize Gamma for Optimization UPF_Y_GAMMA_STEPSIZEDEC4(3) UPF_D_SMOOTH

Key field Non-key field



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

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

How to access SAP table UPF_YS_TECHF

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

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