SAP ABAP Table PSHLP_TREX_ACTY_USERFIELDS_ST (PSHLP:User fields of Activity)

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_USERFIELDS_ST	Table Relationship Diagram
Short Description	PSHLP:User fields of Activity

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	.INCLUDE	☐				0	0	DB structure of the user fields of the operation
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	AUFPL	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
4	APLZL	☐	CO_APLZL	CO_APLZL	NUMC	8	0	General counter for order	AFVC
5	.INCLUDE	☐				0	0	Include structure of the user fields of the operation
6	SLWID	☐	SLWID	SLWID	CHAR	7	0	Key word ID for user-defined fields	TCN00
7	USR00	☐	USRCHAR20	USRCHAR20	CHAR	20	0	User field with 20 characters
8	USR01	☐	USRCHAR20	USRCHAR20	CHAR	20	0	User field with 20 characters
9	USR02	☐	USRCHAR10	USRCHAR10	CHAR	10	0	User field with 10 characters
10	USR03	☐	USRCHAR10	USRCHAR10	CHAR	10	0	User field with 10 characters
11	USR04	☐	USRQUAN13	USRQUAN13	QUAN	13	3	User field for quantity (length 10.3)
12	USE04	☐	USRUNIT	MEINS	UNIT	3	0	User field: Unit for quantity fields	T006
13	USR05	☐	USRQUAN13	USRQUAN13	QUAN	13	3	User field for quantity (length 10.3)
14	USE05	☐	USRUNIT	MEINS	UNIT	3	0	User field: Unit for quantity fields	T006
15	USR06	☐	USRCURR13	USRCURR13	CURR	13	3	User-defined field for values (length 10,3)
16	USE06	☐	USRCUKY	WAERS	CUKY	5	0	User field: Unit for value fields	TCURC
17	USR07	☐	USRCURR13	USRCURR13	CURR	13	3	User-defined field for values (length 10,3)
18	USE07	☐	USRCUKY	WAERS	CUKY	5	0	User field: Unit for value fields	TCURC
19	USR08	☐	USRDATE	USRDATE	DATS	8	0	User field for date
20	USR09	☐	USRDATE	USRDATE	DATS	8	0	User field for date
21	USR10	☐	USRFLAG	FLAG	CHAR	1	0	User-defined field: Indicator for reports
22	USR11	☐	USRFLAG	FLAG	CHAR	1	0	User-defined field: Indicator for reports
23	.INCLUDE	☐				0	0	JV data: (GJV_DATA_2),jv_oco
24	.INCLUDE	☐				0	0	JV data: (vname,recid,etype),jv_otype,jv_jibcl,jv_jibsa
25	.INCLUDE	☐				0	0	General assignments of application objects
26	VNAME	☐	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	T8JV
27	RECID	☐	JV_RECIND	JV_RECIND	CHAR	2	0	Recovery Indicator	T8JJ
28	ETYPE	☐	JV_ETYPE	JV_ETYPE	CHAR	3	0	Equity type	T8JG
29	JV_OTYPE	☐	JV_OTYPE	JV_OTYPE	CHAR	4	0	Joint Venture Object Type
30	JV_JIBCL	☐	JV_JIBCL	JV_JIBCL	CHAR	3	0	JIB/JIBE Class	T8J6A
31	JV_JIBSA	☐	JV_JIBSA	JV_JIBSA	CHAR	5	0	JIB/JIBE Subclass A	T8J6C
32	JV_OCO	☐	JV_OR_CO	JV_OR_COB	CHAR	1	0	JV original cost object
33	.INCLUDE	☐				0	0
34	SPARAMETER1	☐	SPARAMETER		CHAR	4	0	Scheduling Parameters for External Scheduling	TSCHEDULEPARAM1
35	SPARAMETER2	☐	SPARAMETER		CHAR	4	0	Scheduling Parameters for External Scheduling	TSCHEDULEPARAM2
36	SPARAMETER3	☐	SPARAMETER		CHAR	4	0	Scheduling Parameters for External Scheduling	TSCHEDULEPARAM3
37	.INCLU--AP	☐				0	0	AFVUI APPEND for Operation Account Assignment
38	ILART_OP	☐	ILA	ILART	CHAR	3	0	Maintenance activity type	*
39	.INCLU--AP	☐				0	0	Append structure for Regulatory Reporting
40	FERC_IND	☐	FE_IND	FE_IND	CHAR	4	0	Regulatory indicator	FERC_C7
41	.INCLUDE	☐				0	0	TREX Administration Data
42	LOAD_UNAME	☐	LOAD_UNAME	UNAME	CHAR	12	0	User Who Loaded Data in TREX-Based Cache
43	LOAD_DATE	☐	LOAD_DATE		DATS	8	0	Date on Which Data Was Cached in TREX-Based Cache
44	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_USERFIELDS_ST	APLZL	AFVC	APLZL	KEY	1	1
2	PSHLP_TREX_ACTY_USERFIELDS_ST	ETYPE	T8JG	ETYPE
3	PSHLP_TREX_ACTY_USERFIELDS_ST	FERC_IND	FERC_C7	IND	REF
4	PSHLP_TREX_ACTY_USERFIELDS_ST	JV_JIBCL	T8J6A	CLASS
5	PSHLP_TREX_ACTY_USERFIELDS_ST	JV_JIBSA	T8J6C	SUBCLASS	KEY	1	CN
6	PSHLP_TREX_ACTY_USERFIELDS_ST	MANDT	T000	MANDT
7	PSHLP_TREX_ACTY_USERFIELDS_ST	RECID	T8JJ	RECID	REF
8	PSHLP_TREX_ACTY_USERFIELDS_ST	SLWID	TCN00	SLWID
9	PSHLP_TREX_ACTY_USERFIELDS_ST	SPARAMETER1	TSCHEDULEPARAM1	SPARAMETER
10	PSHLP_TREX_ACTY_USERFIELDS_ST	SPARAMETER2	TSCHEDULEPARAM2	SPARAMETER
11	PSHLP_TREX_ACTY_USERFIELDS_ST	SPARAMETER3	TSCHEDULEPARAM3	SPARAMETER
12	PSHLP_TREX_ACTY_USERFIELDS_ST	USE04	T006	MSEHI
13	PSHLP_TREX_ACTY_USERFIELDS_ST	USE05	T006	MSEHI
14	PSHLP_TREX_ACTY_USERFIELDS_ST	USE06	TCURC	WAERS
15	PSHLP_TREX_ACTY_USERFIELDS_ST	USE07	TCURC	WAERS
16	PSHLP_TREX_ACTY_USERFIELDS_ST	VNAME	T8JV	VNAME

History

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