SAP ABAP Table PSBWERB_NAE (Extract Structure: Inheritance Data for Activity Elements)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ PS-IS (Application Component) Information System
     ⤷ KAP8_45B (Package) Export Projects to BW (from Release 4.5B)

Basic Data

Table Category	INTTAB	Structure
Structure	PSBWERB_NAE	Table Relationship Diagram
Short Description	Extract Structure: Inheritance Data for Activity Elements

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	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
2	VORNR	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
3	ELEMENT	☐	CN_ELEMENT	VORNR	CHAR	4	0	Activity element number (work/external/general costs)
4	.INCLUDE	☐				0	0	Master data inheritance fields, Project System
5	POSID	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
6	PSPID	☐	PS_PSPID	PS_PSPID	CHAR	24	0	Project definition
7	POSKI	☐	PS_POSKI	PS_PROKI	CHAR	16	0	WBS element short identification
8	VERNR	☐	PS_VERNR	PS_VERNR	NUMC	8	0	Number of the responsible person (project manager)	TCJ04
9	VERNA	☐	PS_VERNA	PS_VERNA	CHAR	25	0	Name of responsible person (Project manager)
10	ASTNR	☐	PS_ASTNR	PS_ASTNR	NUMC	8	0	Applicant number	TCJ05
11	ASTNA	☐	PS_ASTNA	PS_ASTNA	CHAR	25	0	Applicant
12	PBUKR	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
13	PGSBR	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
14	PKOKR	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
15	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
16	PRART	☐	PS_PRART	PS_PRART	CHAR	2	0	Project type	TCJ1
17	AKOKR	☐	PS_AKOKR	CACCD	CHAR	4	0	Controlling area of requesting cost center	TKA01
18	AKSTL	☐	PS_AKSTL	KOSTL	CHAR	10	0	Requesting cost center	*
19	FKOKR	☐	PS_FKOKR	CACCD	CHAR	4	0	Controlling area of responsible cost center	TKA01
20	FKSTL	☐	PS_FKSTL	KOSTL	CHAR	10	0	Responsible cost center	*
21	PWPOS	☐	OWAER	WAERS	CUKY	5	0	Currency Key	*
22	SCOPE	☐	SCOPE_CV	SCOPE_CV	CHAR	2	0	Object Class
23	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
24	USR00	☐	USR00PRPS	USRCHAR20	CHAR	20	0	1st user field for 20 characters - WBS element-
25	USR01	☐	USR01PRPS	USRCHAR20	CHAR	20	0	2nd user field 20 digits - WBS element
26	USR02	☐	USR02PRPS	USRCHAR10	CHAR	10	0	3rd user-defined field 10 digits -WBS element
27	USR03	☐	USR03PRPS	USRCHAR10	CHAR	10	0	4th user-defined field 10 digits -WBS element
28	USR08	☐	USR08PRPS	USRDATE	DATS	8	0	1st user field for date -WBS element
29	USR09	☐	USR09PRPS	USRDATE	DATS	8	0	2nd user field for date -WBS element
30	USR10	☐	USR10PRPS	FLAG	CHAR	1	0	1st user field for 'Ind. for evaluations' WBS elem.
31	USR11	☐	USR11PRPS	FLAG	CHAR	1	0	2nd user field for 'Indicator for eval.s' WBS elemnt
32	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
33	IZWEK	☐	IZWEK	IZWEK	CHAR	2	0	Reason for investment	T087I
34	ISIZE	☐	IM_SIZECL	SIZECL	CHAR	2	0	Scale of investment objects	TAIF5
35	IUMKZ	☐	AM_UMWKZ	AM_UMWKZ	CHAR	5	0	Reason for environmental investment	T087K
36	STORT	☐	PS_STORT	AP_STAND	CHAR	10	0	Location	T499S
37	GUID	☐	SYSUUID_X	SYSUUID	RAW	16	0	UUID in X form (binary)
38	CPR_GUID	☐	CGPL_GUID16_R3	SYSUUID	RAW	16	0	Generic project planning: GUID from external R/3 system

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PSBWERB_NAE	AKOKR	TKA01	KOKRS
2	PSBWERB_NAE	ASTNR	TCJ05	ASTNR	REF	C	CN
3	PSBWERB_NAE	FKOKR	TKA01	KOKRS
4	PSBWERB_NAE	ISIZE	TAIF5	SIZECL
5	PSBWERB_NAE	IUMKZ	T087K	UMWKZ	REF	1	CN
6	PSBWERB_NAE	IZWEK	T087I	IZWEK
7	PSBWERB_NAE	PBUKR	T001	BUKRS
8	PSBWERB_NAE	PGSBR	TGSB	GSBER
9	PSBWERB_NAE	PKOKR	TKA01	KOKRS
10	PSBWERB_NAE	PRART	TCJ1	PRART
11	PSBWERB_NAE	PRCTR	CEPC	PRCTR	REF	C	CN
12	PSBWERB_NAE	STORT	T499S	STAND
13	PSBWERB_NAE	VERNR	TCJ04	VERNR
14	PSBWERB_NAE	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20130529
SAP Release Created in