SAP ABAP Table UPS_TP_HIERARCHY (Connection Subplan-Hierarchy)

Hierarchy

☛ SAP_BW (Software Component) SAP Business Warehouse
   ⤷ BW-PLA-BPS (Application Component) Business Planning and Simulation
     ⤷ UPS (Package) Status and Tracking System

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	UPS_TP_HIERARCHY	Table Relationship Diagram
Short Description	Connection Subplan-Hierarchy

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	TEILPLAN	☑	UPS_Y_TEILPLAN		CHAR	8	0	Subplan in STS	UPS_TEILPLAN
3	AREA	☑	UPC_Y_AREA	UPC_AREA	CHAR	8	0	Planning Area	UPC_AREA
4	HIENM	☐	UPC_Y_HIENM	UPC_IOBJNM	CHAR	30	0	Hierarchy
5	HIEVER	☐	UPC_Y_HIEVER	UPC_HIEVER	CHAR	3	0	Hierarchy Version
6	DATETO	☐	UPC_Y_DATETO	UPC_DATUM	DATS	8	0	Valid To
7	CHANM	☐	UPC_Y_CHANM	UPC_IOBJNM	CHAR	30	0	Characteristic
8	GUID	☐	UXP_GUID		CHAR	32	0	GUID
9	HIETYPE	☐			NUMC	2	0
10	.INCLUDE	☐				0	0	Statistical Info
11	COUNTER	☐	UPC_Y_COUNTER	UPC_COUNTER	NUMC	3	0	Change counter
12	UNAME	☐	UNAME	UNAME	CHAR	12	0	User Name
13	AEDTM	☐	AEDTM	DATUM	DATS	8	0	Changed on
14	ATIME	☐	AS4TIME	AS4TIME	TIMS	6	0	Last changed at

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	UPS_TP_HIERARCHY	AREA	UPC_AREA	AREA
2	UPS_TP_HIERARCHY	TEILPLAN	UPS_TEILPLAN	TEILPLAN

History

Last changed by/on	SAP	20130604
SAP Release Created in	3.1A