SAP ABAP Table PSHLP_TREX_WBS_ST (WBS 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_WBS_ST	Table Relationship Diagram
Short Description	WBS 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	PSPNR	☐	PS_POSNR	PS_POSNR	NUMC	8	0	WBS Element	*
2	POSID	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
3	POST1	☐	PS_POST1	TEXT40	CHAR	40	0	PS: Short description (first text line)
4	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
5	PSPHI	☐	PS_PSPHI	PS_PSPNR	NUMC	8	0	Current number of the appropriate project	*
6	.INCLUDE	☐				0	0	PS: Data portion of WBS element master data Include
7	POSKI	☐	PS_POSKI	PS_PROKI	CHAR	16	0	WBS element short identification
8	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
9	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
10	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
11	AEDAT	☐	UPDAT	DATUM	DATS	8	0	Date on which object was last changed
12	VERNR	☐	PS_VERNR	PS_VERNR	NUMC	8	0	Number of the responsible person (project manager)	TCJ04
13	VERNA	☐	PS_VERNA	PS_VERNA	CHAR	25	0	Name of responsible person (Project manager)
14	ASTNR	☐	PS_ASTNR	PS_ASTNR	NUMC	8	0	Applicant number	TCJ05
15	ASTNA	☐	PS_ASTNA	PS_ASTNA	CHAR	25	0	Applicant
16	PBUKR	☐	PS_PBUKR	BUKRS	CHAR	4	0	Company code for WBS element	T001
17	PGSBR	☐	PS_PGSBR	GSBER	CHAR	4	0	Business area for WBS element	TGSB
18	PKOKR	☐	PS_PKOKR	CACCD	CHAR	4	0	Controlling area for WBS element	TKA01
19	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
20	PRART	☐	PS_PRART	PS_PRART	CHAR	2	0	Project type	TCJ1
21	STUFE	☐	PS_STUFE	INT1	INT1	3	0	Level in project hierarchy
22	PLAKZ	☐	PS_PLAKZ	XFELD	CHAR	1	0	Indicator: Planning element
23	BELKZ	☐	PS_BELKZ	XFELD	CHAR	1	0	Indicator: Account assignment element
24	FAKKZ	☐	PS_FAKKZ	XFELD	CHAR	1	0	Indicator: Billing element
25	NPFAZ	☐	PS_NPFAR	XFELD	CHAR	1	0	Relationship of network activity to production order
26	ZUORD	☐	PS_ZUORD	PS_ZUORD	NUMC	1	0	Network assignment
27	TRMEQ	☐	PS_TRMEQ	X	CHAR	1	0	Indicator: WBS dates detailed by activity dates
28	KVEWE	☐	KVEWE	KVEWE	CHAR	1	0	Usage of the Condition Table	T681V
29	KAPPL	☐	KAPPL	KAPPL	CHAR	2	0	Application	T681A
30	KALSM	☐	AUFKALSM	KALSM	CHAR	6	0	Costing Sheet	T683
31	ZSCHL	☐	AUFZSCHL	CHAR6	CHAR	6	0	Overhead key
32	ABGSL	☐	ABGR_SCHL	ABGR_SCHL	CHAR	6	0	Results Analysis Key	TKKAA
33	AKOKR	☐	PS_AKOKR	CACCD	CHAR	4	0	Controlling area of requesting cost center	TKA01
34	AKSTL	☐	PS_AKSTL	KOSTL	CHAR	10	0	Requesting cost center	CSKS
35	FKOKR	☐	PS_FKOKR	CACCD	CHAR	4	0	Controlling area of responsible cost center	TKA01
36	FKSTL	☐	PS_FKSTL	KOSTL	CHAR	10	0	Responsible cost center	CSKS
37	FABKL	☐	FABKL	WFCID	CHAR	2	0	Factory calendar key	TFACD
38	PSPRI	☐	NW_PRIO	NW_PRIO	CHAR	1	0	Priority	TCN07
39	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	EQUI
40	TPLNR	☐	TPLNR	TPLNR	CHAR	30	0	Functional Location	IFLOT
41	PWPOS	☐	PS_PWPOS	WAERS	CUKY	5	0	WBS element currency	TCURC
42	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
43	TXTSP	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
44	SLWID	☐	SLWID	SLWID	CHAR	7	0	Key word ID for user-defined fields	TCN00
45	USR00	☐	USR00PRPS	USRCHAR20	CHAR	20	0	1st user field for 20 characters - WBS element-
46	USR01	☐	USR01PRPS	USRCHAR20	CHAR	20	0	2nd user field 20 digits - WBS element
47	USR02	☐	USR02PRPS	USRCHAR10	CHAR	10	0	3rd user-defined field 10 digits -WBS element
48	USR03	☐	USR03PRPS	USRCHAR10	CHAR	10	0	4th user-defined field 10 digits -WBS element
49	USR04	☐	USR04PRPS	USRQUAN13	QUAN	13	3	1st user-defined field for quantity(length 10,3) WBS element
50	USE04	☐	USE04PRPS	MEINS	UNIT	3	0	1st user defined field for quantity field unit - WBS element	T006
51	USR05	☐	USR05PRPS	USRQUAN13	QUAN	13	3	2nd use field for quantity (length 10,3) WBS element
52	USE05	☐	USE05PRPS	MEINS	UNIT	3	0	2nd user defined field for quantity field unit - WBS element	T006
53	USR06	☐	USR06PRPS	USRCURR13	CURR	13	3	1st user field for values (length 10,3) WBS element
54	USE06	☐	USE06PRPS	WAERS	CUKY	5	0	1st user defined field for value field unit - WBS element	TCURC
55	USR07	☐	USR07PRPS	USRCURR13	CURR	13	3	2nd user field for values (length 10,3) -WBS element
56	USE07	☐	USE07PRPS	WAERS	CUKY	5	0	2nd user defined field for value field unit - WBS element	TCURC
57	USR08	☐	USR08PRPS	USRDATE	DATS	8	0	1st user field for date -WBS element
58	USR09	☐	USR09PRPS	USRDATE	DATS	8	0	2nd user field for date -WBS element
59	USR10	☐	USR10PRPS	FLAG	CHAR	1	0	1st user field for 'Ind. for evaluations' WBS elem.
60	USR11	☐	USR11PRPS	FLAG	CHAR	1	0	2nd user field for 'Indicator for eval.s' WBS elemnt
61	KOSTL	☐	PS_KOSTL	KOSTL	CHAR	10	0	Cost center to which costs are actually posted	CSKS
62	KTRG	☐	KSTRG	KSTRG	CHAR	12	0	Cost Object	CKPH
63	BERST	☐	PS_BERST	CHAR16	CHAR	16	0	Authorization key for project master data
64	BERTR	☐	PS_BERTR	CHAR16	CHAR	16	0	Authorization key for project dates (WBS)
65	BERKO	☐	PS_BERKO	CHAR16	CHAR	16	0	Authorization key for costs and revenues
66	BERBU	☐	PS_BERBU	CHAR16	CHAR	16	0	Authorization key for project budget
67	CLASF	☐	PS_CLASF	XFELD	CHAR	1	0	Indicator: WBS element used in project summarization
68	SPSNR	☐	PS_SPSNR	PS_SPSNR	NUMC	8	0	Std WBS: Internal project item number (w/exit on ID)	PRPSS
69	SCOPE	☐	SCOPE_CV	SCOPE_CV	CHAR	2	0	Object Class
70	XSTAT	☐	PS_XSTAT	XFELD	CHAR	1	0	Statistical WBS element
71	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
72	ZSCHM	☐	PS_ZSCHM	PS_ZSCHM	CHAR	7	0	Interest Profile for Project/Order Interest Calculation	TPI01
73	IMPRF	☐	IM_PROFIL	IM_PROFIL	CHAR	6	0	Investment measure profile	TAPRF
74	EVGEW	☐	EV_WEIGHTD	DEC8	DEC	8	0	Aggregation weight for POC (PS progress)
75	AENNR	☐	AENNR	AENNR	CHAR	12	0	Change Number	AENR
76	SUBPR	☐	PS_SUBPR	PS_SUBPR	CHAR	12	0	Sub-project in work breakdown structure	PRTP
77	POSTU	☐	PS_POSTU	CHAR40	CHAR	40	0	PS: Short description (1st text line) in all caps
78	PLINT	☐	PLINT	XFELD	CHAR	1	0	Indicator for Integrated Planning
79	LOEVM	☐	LOEVM	XFELD	CHAR	1	0	Deletion Indicator
80	KZBWS	☐	KZBWS	KZBWS	CHAR	1	0	Valuation of Special Stock
81	FPLNR	☐	FPLNR	FPLNR	CHAR	10	0	Billing plan number / invoicing plan number	*
82	TADAT	☐	TABGDAT	DATUM	DATS	8	0	Technically complete date
83	IZWEK	☐	IZWEK	IZWEK	CHAR	2	0	Reason for investment	T087I
84	ISIZE	☐	IM_SIZECL	SIZECL	CHAR	2	0	Scale of investment objects	TAIF5
85	IUMKZ	☐	AM_UMWKZ	AM_UMWKZ	CHAR	5	0	Reason for environmental investment	T087K
86	ABUKR	☐	IM_ABUKRS	BUKRS	CHAR	4	0	Requesting company code	T001
87	GRPKZ	☐	GRPSPKZ	GRPSPKZ	CHAR	1	0	Indicator: Grouping WBS element
88	PGPRF	☐	PGPROFID	PGPROFID	CHAR	6	0	Distribution profile	TPGPRF
89	LOGSYSTEM	☐	LOGSYSTEM	LOGSYS	CHAR	10	0	Logical System	*
90	PSPNR_LOGS	☐	NUM08	NUM08	NUMC	8	0	Numeric field length 8
91	STORT	☐	PS_STORT	AP_STAND	CHAR	10	0	Location	T499S
92	FUNC_AREA	☐	FKBER	FKBER	CHAR	16	0	Functional Area	TFKB
93	KLVAR	☐	CK_KLVAR	KLVAR	CHAR	4	0	Costing Variant	*
94	KALNR	☐	CK_KALNR	CK_KALNR	NUMC	12	0	Cost Estimate Number for Cost Est. w/o Qty Structure	*
95	POSID_EDIT	☐	PS_POSID_EDIT	PS_POSID_EDIT	CHAR	24	0	Work Breakdown Structure Element (WBS Element) Edited
96	.INCLUDE	☐				0	0	PLP: Data Part - Include Production Lot Master Data
97	PSPKZ	☐	PL_PSPKZ	XFELD	CHAR	1	0	Indicator: WBS element for production lot
98	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
99	VLPSP	☐	PL_PSP_PNR	PS_POSNR	NUMC	8	0	WBS: Reference work breakdown structure element	*
100	VLPKZ	☐	PL_VLPKZ	XFELD	CHAR	1	0	Indicator: Reference WBS element for production lot
101	SORT1	☐	PL_SORT1	CHAR10	CHAR	10	0	Sort string 1 for production lot
102	SORT2	☐	PL_SORT2	CHAR10	CHAR	10	0	Sort string 2 for production lot
103	SORT3	☐	PL_SORT3	CHAR10	CHAR	10	0	Sort string 3 for production lot
104	.INCLUDE	☐				0	0	JV data: (vname,recid,etype),otype,jibcl,jibsa
105	.INCLUDE	☐				0	0	General assignments of application objects
106	VNAME	☐	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	T8JV
107	RECID	☐	JV_RECIND	JV_RECIND	CHAR	2	0	Recovery Indicator	T8JJ
108	ETYPE	☐	JV_ETYPE	JV_ETYPE	CHAR	3	0	Equity type	T8JG
109	OTYPE	☐	JV_OTYPE	JV_OTYPE	CHAR	4	0	Joint Venture Object Type
110	JIBCL	☐	JV_JIBCL	JV_JIBCL	CHAR	3	0	JIB/JIBE Class	T8J6A
111	JIBSA	☐	JV_JIBSA	JV_JIBSA	CHAR	5	0	JIB/JIBE Subclass A	T8J6C
112	.INCLUDE	☐				0	0	Generic Project Planning: Assignment to WBS Element
113	CGPL_GUID16	☐	CGPL_GUID16_R3	SYSUUID	RAW	16	0	Generic project planning: GUID from external R/3 system
114	CGPL_LOGSYS	☐	CGPL_LOGSYS	LOGSYS	CHAR	10	0	Generic project planning: Log. system for CGPL_GUID16_R3	*
115	CGPL_OBJTYPE	☐	CGPL_OBJECT_TYPE_R3	CHAR3	CHAR	3	0	Generic project planning: object type from ext. R/3 system
116	ADPSP	☐	ADDCOMPARE_CORE	ADDCOMPARE_CORE	CHAR	40	0	Reference Element PM/PS	*
117	RFIPPNT	☐	CN_RPIP	CN_RFPNT	CHAR	20	0	Reference Point for Relationship Between iPPE and PS	TCNRPIP
118	.INCLUDE	☐				0	0
119	.INCLUDE	☐				0	0	TREX Administration Data
120	LOAD_UNAME	☐	LOAD_UNAME	UNAME	CHAR	12	0	User Who Loaded Data in TREX-Based Cache
121	LOAD_DATE	☐	LOAD_DATE		DATS	8	0	Date on Which Data Was Cached in TREX-Based Cache
122	EXPIRY_DATE	☐	PS_EXPIRY_DATE		DATS	8	0	Date from Which Cached Data Is Invalid
123	PRPS_STATUS	☐	ACTCMB_DELE	ACTCMB_DOM	INT1	3	0	Status Combination

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PSHLP_TREX_WBS_ST	ABGSL	TKKAA	ABGSL	KEY	C	CN
2	PSHLP_TREX_WBS_ST	ABUKR	T001	BUKRS		1	CN
3	PSHLP_TREX_WBS_ST	AENNR	AENR	AENNR	REF	C	CN
4	PSHLP_TREX_WBS_ST	AKOKR	TKA01	KOKRS	REF	C	CN
5	PSHLP_TREX_WBS_ST	AKSTL	CSKS	KOSTL	REF	C	CN
6	PSHLP_TREX_WBS_ST	ASTNR	TCJ05	ASTNR	REF	C	CN
7	PSHLP_TREX_WBS_ST	EQUNR	EQUI	EQUNR	REF	C	CN
8	PSHLP_TREX_WBS_ST	ETYPE	T8JG	ETYPE
9	PSHLP_TREX_WBS_ST	FABKL	TFACD	IDENT	REF	1	CN
10	PSHLP_TREX_WBS_ST	FKOKR	TKA01	KOKRS	REF	C	CN
11	PSHLP_TREX_WBS_ST	FKSTL	CSKS	KOSTL	REF	C	CN
12	PSHLP_TREX_WBS_ST	FUNC_AREA	TFKB	FKBER
13	PSHLP_TREX_WBS_ST	IMPRF	TAPRF	IVPRO	REF	C	CN
14	PSHLP_TREX_WBS_ST	ISIZE	TAIF5	SIZECL		1	CN
15	PSHLP_TREX_WBS_ST	IUMKZ	T087K	UMWKZ		1	CN
16	PSHLP_TREX_WBS_ST	IZWEK	T087I	IZWEK		1	CN
17	PSHLP_TREX_WBS_ST	JIBCL	T8J6A	CLASS
18	PSHLP_TREX_WBS_ST	JIBSA	T8J6C	SUBCLASS	KEY	1	CN
19	PSHLP_TREX_WBS_ST	KALSM	T683	KALSM	REF	C	CN
20	PSHLP_TREX_WBS_ST	KAPPL	T681A	KAPPL	REF	C	CN
21	PSHLP_TREX_WBS_ST	KOSTL	CSKS	KOSTL	REF	C	CN
22	PSHLP_TREX_WBS_ST	KTRG	CKPH	KSTRG	REF	C	CN
23	PSHLP_TREX_WBS_ST	KVEWE	T681V	KVEWE	REF	C	CN
24	PSHLP_TREX_WBS_ST	PBUKR	T001	BUKRS	REF	C	CN
25	PSHLP_TREX_WBS_ST	PGPRF	TPGPRF	PROFID		1	CN
26	PSHLP_TREX_WBS_ST	PGSBR	TGSB	GSBER	REF	C	CN
27	PSHLP_TREX_WBS_ST	PKOKR	TKA01	KOKRS	REF	C	CN
28	PSHLP_TREX_WBS_ST	PRART	TCJ1	PRART	REF	C	CN
29	PSHLP_TREX_WBS_ST	PRCTR	CEPC	PRCTR	REF	C	CN
30	PSHLP_TREX_WBS_ST	PSPRI	TCN07	NPRIO	REF	C	CN
31	PSHLP_TREX_WBS_ST	PWPOS	TCURC	WAERS	REF	C	CN
32	PSHLP_TREX_WBS_ST	RECID	T8JJ	RECID	REF
33	PSHLP_TREX_WBS_ST	RFIPPNT	TCNRPIP	RFPNT		C	CN
34	PSHLP_TREX_WBS_ST	SLWID	TCN00	SLWID	REF	C	CN
35	PSHLP_TREX_WBS_ST	SPSNR	PRPSS	PSPNR	REF	C	C
36	PSHLP_TREX_WBS_ST	STORT	T499S	STAND		1	CN
37	PSHLP_TREX_WBS_ST	SUBPR	PRTP	SUBPR	REF	C	CN
38	PSHLP_TREX_WBS_ST	TPLNR	IFLOT	TPLNR	REF	C	CN
39	PSHLP_TREX_WBS_ST	TXJCD	TTXJ	TXJCD	REF	C	CN
40	PSHLP_TREX_WBS_ST	TXTSP	T002	SPRAS	REF	C	CN
41	PSHLP_TREX_WBS_ST	USE04	T006	MSEHI	REF	C	CN
42	PSHLP_TREX_WBS_ST	USE05	T006	MSEHI	REF	C	CN
43	PSHLP_TREX_WBS_ST	USE06	TCURC	WAERS	REF	C	CN
44	PSHLP_TREX_WBS_ST	USE07	TCURC	WAERS	REF	C	CN
45	PSHLP_TREX_WBS_ST	VERNR	TCJ04	VERNR	REF	C	CN
46	PSHLP_TREX_WBS_ST	VNAME	T8JV	VNAME
47	PSHLP_TREX_WBS_ST	WERKS	T001W	WERKS	REF	1	CN
48	PSHLP_TREX_WBS_ST	ZSCHM	TPI01	ZSCHM	REF	C	CN

History

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