SAP UPC_STEPS Relations between Characteristics of a Planning Area Table data and field list

UPC_STEPS is a standard SAP Table which is used to store Relations between Characteristics of a Planning Area data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The UPC_STEPS table consists of various fields, each holding specific information or linking keys about Relations between Characteristics of a Planning Area data available in SAP. These include AREA (Planning Area), STEP (Number of the Characteristic Relationship), MTYPE (Type of Characteristic Relationship), DERIVE (Derivation: X = Yes)... 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. .

UPC_STEPS 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 UPC_STEPS 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 UPC_STEPS 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
MANDT	Client	MANDT	CLNT	3	T000		MANDT
AREA	Planning Area	UPC_Y_AREA	CHAR	8	UPC_AREA		UPC_AREA
STEP	Number of the Characteristic Relationship	UPC_Y_STEP	NUMC	2			UPC_STEP
MTYPE	Type of Characteristic Relationship	UPC_Y_MTYPE	CHAR	1			UPC_MTYPE
DERIVE	Derivation: X = Yes	UPC_Y_DERIVE	CHAR	1			XFELD
HIENM	Hierarchy	UPC_Y_HIENM	CHAR	30			UPC_IOBJNM
HIEVER	Hierarchy Version	UPC_Y_HIEVER	CHAR	3			UPC_HIEVER
DATETO	Valid To	UPC_Y_DATETO	DATS	8			UPC_DATUM
CHANM	Characteristic	UPC_Y_CHANM	CHAR	30			UPC_IOBJNM
REFID	UUID in compressed form (22 character UUENCODEd)	SYSUUID_22	CHAR	22			SYSUUID_22
FBDER	FM Derivation	UPC_Y_FBDER	CHAR	30	Assigned to domain		FUNCNAME
FBCOM	FM Combination Proposal	UPC_Y_FBCOM	CHAR	30	Assigned to domain		FUNCNAME
FBVER	FM Combination Check	UPC_Y_FBVER	CHAR	30	Assigned to domain		FUNCNAME
COUNTER	Change counter	UPC_Y_COUNTER	NUMC	3			UPC_COUNTER
UNAME	User Name	UNAME	CHAR	12			UNAME
AEDTM	Changed on	AEDTM	DATS	8			DATUM
ATIME	Last changed at	AS4TIME	TIMS	6			AS4TIME

Key field

Non-key field

< UPC_STATISTIC3 - Statistic for Executing Planning Functions UPC_TRACE_DATA - Trace Data >

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

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

SELECT SINGLE *
FROM UPC_STEPS
INTO CORRESPONDING FIELDS OF WA_UPC_STEPS
WHERE...

How to access SAP table UPC_STEPS

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

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