SAP ABAP Table PSHLP_TREX_ACTY_REL_ST (Activity relationships structure for TREX)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ PS (Application Component) Project System
     ⤷ PS_HLP_CACHE (Package) Handling Large Projects:-Cache

Basic Data

Table Category	INTTAB	Structure
Structure	PSHLP_TREX_ACTY_REL_ST	Table Relationship Diagram
Short Description	Activity relationships structure for TREX

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	AUFPL_VOR	☐	AUFPL_VOR	MDNUM	NUMC	10	0	No. identifying the network to which the predecessor belongs
2	APLZL_VOR	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
3	AUFPL_NCH	☐	AUFPL_NCH	MDNUM	NUMC	10	0	No. identifying the network to which the successor belongs
4	APLZL_NCH	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
5	AOBAR	☐	AOBAR	AOBAR	CHAR	2	0	Type of relationship
6	MIMAX	☐	DAUMIMAX	XFELD	CHAR	1	0	Indicates whether maximum time interval will be considered
7	.INCLUDE	☐				0	0	Network relationships (Include structure)
8	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
9	ZEINH	☐	AOBDAUEH	MEINS	UNIT	3	0	Unit for the time interval between relationships	T006
10	DAUER	☐	AOBDAUER	AOBDAUER	QUAN	5	1	Time interval between relationships
11	DAUKZ	☐	AOBDAUKZ	AOBDAUKZ	CHAR	1	0	Indicator for the duration of the relationship
12	VORNC	☐	VORG_NACH	XFELD	CHAR	1	0	Indicator: maintained after successor
13	NCVOR	☐	NACH_VORG	XFELD	CHAR	1	0	Indicates whether data after predecessor is maintained
14	LOEKZ	☐	LOLOE	XFELD	CHAR	1	0	Indicates whether an object is logically deleted.
15	KALID	☐	WFCID	WFCID	CHAR	2	0	Factory Calendar	TFACD
16	PRZNT	☐	AOB_PRZNT	AOB_PRZNT	NUMC	3	0	% used to calc. time interval between predecessor/successor
17	PROVG	☐	AOB_PROVG	AOB_PROVG	CHAR	1	0	Key for defining time intervals in a relationship
18	ARBID	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
19	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
20	FSABD	☐	FSABD	DATUM	DATS	8	0	Earliest start date for the relationship
21	FSABZ	☐	FSABZ	ATIME	TIMS	6	0	Earliest start time for the relationship
22	SSABD	☐	SSABD	DATUM	DATS	8	0	Latest start date of the relationship
23	SSABZ	☐	SSABZ	ATIME	TIMS	6	0	Latest start time of the relationship
24	FEABD	☐	FEABD	DATUM	DATS	8	0	Earliest finish date for the relationship
25	FEABZ	☐	FEABZ	ATIME	TIMS	6	0	Earliest finish time for the relationship
26	SEABD	☐	SEABD	DATUM	DATS	8	0	Latest finish date of the relationship
27	SEABZ	☐	SEABZ	ATIME	TIMS	6	0	Latest finish time of the relationship
28	DAUTM	☐	DAUTM	CX_DAUERS	INT4	10	0	Relationship duration (in seconds) as result of scheduling
29	AUCRE	☐	CN_AUCRE	XFELD	CHAR	1	0	Ind.: Relationship automatically generated
30	DAUERMAX	☐	AOBDAUERM	AOBDAUER	QUAN	5	1	Maximum time interval for relationship
31	AENNR	☐	AENNR	AENNR	CHAR	12	0	Change Number	*
32	ACTIVE	☐	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
33	DISPLAY	☐	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
34	.INCLUDE	☐				0	0	Additional Fields for Networks
35	VORNR	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
36	LTXA1	☐	LTXA1	TEXT40	CHAR	40	0	Operation short text
37	NCHKZ	☐	NCHKZ	XFELD	CHAR	1	0	Indicator: Activity is successor to selected activity
38	VORN1	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
39	LTXN1	☐	LTXA1	TEXT40	CHAR	40	0	Operation short text
40	VORN2	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
41	LTXN2	☐	LTXA1	TEXT40	CHAR	40	0	Operation short text
42	KTXN1	☐	NETZTEXT	TEXT40	CHAR	40	0	Short description of the network
43	KTXN2	☐	NETZTEXT	TEXT40	CHAR	40	0	Short description of the network
44	AOBTX	☐	AOBTX	TEXT20	CHAR	20	0	Short text for the type of relationship
45	KALTX	☐	KALTX	TEXT20	CHAR	20	0	Description of the factory calendar
46	NETZPLAN	☐	NETZPLAN	NETZPLAN	CHAR	12	0	Network number
47	NETZPL_VOR	☐	NETZPLAN	NETZPLAN	CHAR	12	0	Network number
48	NETZPL_NCH	☐	NETZPLAN	NETZPLAN	CHAR	12	0	Network number
49	VORG_DUMY1	☐	VORG_DUMY1	VORNR	CHAR	4	0	Number for general costs element or work element
50	VORG_DUMY2	☐	VORG_DUMY2	VORNR	CHAR	4	0	Number for general costs element or work element
51	VORG_DUMY3	☐	VORG_DUMY3	VORNR	CHAR	4	0	Key word for external processing element
52	INDBT	☐	TABIX_D	TABIX	INT4	10	0	Field defined as in SY-TABIX
53	ARBPL	☐	ARBPL	ARBPL	CHAR	8	0	Work center
54	FLG_LOCK	☐	FLG_LOCK	XFELD	CHAR	1	0	Indicates whether this relationship is locked in data base
55	INDBT_VOR1	☐	TABIX_D	TABIX	INT4	10	0	Field defined as in SY-TABIX
56	INDBT_VOR2	☐	TABIX_D	TABIX	INT4	10	0	Field defined as in SY-TABIX
57	AUFPL_CURRENT_PARENT	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
58	APLZL_CURRENT_PARENT	☐	CO_APLZL	CO_APLZL	NUMC	8	0	General counter for order	*
59	.INCLUDE	☐				0	0	TREX Administration Data
60	LOAD_UNAME	☐	LOAD_UNAME	UNAME	CHAR	12	0	User Who Loaded Data in TREX-Based Cache
61	LOAD_DATE	☐	LOAD_DATE		DATS	8	0	Date on Which Data Was Cached in TREX-Based Cache
62	EXPIRY_DATE	☐	PS_EXPIRY_DATE		DATS	8	0	Date from Which Cached Data Is Invalid

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PSHLP_TREX_ACTY_REL_ST	KALID	TFACD	IDENT	REF	C	CN
2	PSHLP_TREX_ACTY_REL_ST	OBJNR	ONR00	OBJNR	REF	1	1
3	PSHLP_TREX_ACTY_REL_ST	WERKS	T001W	WERKS	REF	1	CN
4	PSHLP_TREX_ACTY_REL_ST	ZEINH	T006	MSEHI	REF	C	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in	606