SAP ABAP View V_AVCHANA_PR_GE (Database View for Report RAVCHANA_WBS)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ AIP (Package) IM capital investment prog.(master data, budget, info syst.)

Basic Data

View Type	D	Database View
Database View	V_AVCHANA_PR_GE
Short Description	Database View for Report RAVCHANA_WBS
Root table	PRPS	WBS (Work Breakdown Structure) Element Master Data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	PRPS	PRPS
2	BPGE

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	PRPS	MANDT	JL	EQ				0	0
2	BPGE	MANDT	JR	EQ			AND	0	0
3	PRPS	OBJNR	JL	EQ				0	0
4	BPGE	OBJNR	JR	EQ			AND	0	0
5	BPGE	WRTTP		EQ	'42'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	PRPS	MANDT		☐	MANDT	☐	Client
2	PSPNR	PRPS	PSPNR		☐	PS_POSNR	☐	WBS Element
3	POSID	PRPS	POSID		☐	PS_POSID	☐	Work Breakdown Structure Element (WBS Element)
4	POST1	PRPS	POST1		☐	PS_POST1	☐	PS: Short description (first text line)
5	OBJNR	PRPS	OBJNR		☐	J_OBJNR	☐	Object number
6	PSPHI	PRPS	PSPHI		☐	PS_PSPHI	☐	Current number of the appropriate project
7	POSKI	PRPS	POSKI		☐	PS_POSKI	☐	WBS element short identification
8	ERNAM	PRPS	ERNAM		☐	ERNAM	☐	Name of Person who Created the Object
9	ERDAT	PRPS	ERDAT		☐	ERDAT	☐	Date on which the record was created
10	AENAM	PRPS	AENAM		☐	AENAM	☐	Name of Person Who Changed Object
11	AEDAT	PRPS	AEDAT		☐	UPDAT	☐	Date on which object was last changed
12	VERNR	PRPS	VERNR		☐	PS_VERNR	☐	Number of the responsible person (project manager)
13	VERNA	PRPS	VERNA		☐	PS_VERNA	☐	Name of responsible person (Project manager)
14	ASTNR	PRPS	ASTNR		☐	PS_ASTNR	☐	Applicant number
15	ASTNA	PRPS	ASTNA		☐	PS_ASTNA	☐	Applicant
16	PBUKR	PRPS	PBUKR		☐	PS_PBUKR	☐	Company code for WBS element
17	PGSBR	PRPS	PGSBR		☐	PS_PGSBR	☐	Business area for WBS element
18	PKOKR	PRPS	PKOKR		☐	PS_PKOKR	☐	Controlling area for WBS element
19	PRCTR	PRPS	PRCTR		☐	PRCTR	☐	Profit Center
20	PRART	PRPS	PRART		☐	PS_PRART	☐	Project type
21	STUFE	PRPS	STUFE		☐	PS_STUFE	☐	Level in project hierarchy
22	PLAKZ	PRPS	PLAKZ		☐	PS_PLAKZ	☐	Indicator: Planning element
23	BELKZ	PRPS	BELKZ		☐	PS_BELKZ	☐	Indicator: Account assignment element
24	FAKKZ	PRPS	FAKKZ		☐	PS_FAKKZ	☐	Indicator: Billing element
25	NPFAZ	PRPS	NPFAZ		☐	PS_NPFAR	☐	Relationship of network activity to production order
26	ZUORD	PRPS	ZUORD		☐	PS_ZUORD	☐	Network assignment
27	TRMEQ	PRPS	TRMEQ		☐	PS_TRMEQ	☐	Indicator: WBS dates detailed by activity dates
28	KVEWE	PRPS	KVEWE		☐	KVEWE	☐	Usage of the Condition Table
29	KAPPL	PRPS	KAPPL		☐	KAPPL	☐	Application
30	KALSM	PRPS	KALSM		☐	AUFKALSM	☐	Costing Sheet
31	ZSCHL	PRPS	ZSCHL		☐	AUFZSCHL	☐	Overhead key
32	ABGSL	PRPS	ABGSL		☐	ABGR_SCHL	☐	Results Analysis Key
33	AKOKR	PRPS	AKOKR		☐	PS_AKOKR	☐	Controlling area of requesting cost center
34	AKSTL	PRPS	AKSTL		☐	PS_AKSTL	☐	Requesting cost center
35	FKOKR	PRPS	FKOKR		☐	PS_FKOKR	☐	Controlling area of responsible cost center
36	FKSTL	PRPS	FKSTL		☐	PS_FKSTL	☐	Responsible cost center
37	FABKL	PRPS	FABKL		☐	FABKL	☐	Factory calendar key
38	PSPRI	PRPS	PSPRI		☐	NW_PRIO	☐	Priority
39	EQUNR	PRPS	EQUNR		☐	EQUNR	☐	Equipment Number
40	TPLNR	PRPS	TPLNR		☐	TPLNR	☐	Functional Location
41	PWPOS	PRPS	PWPOS		☐	PS_PWPOS	☐	WBS element currency
42	WERKS	PRPS	WERKS		☐	WERKS_D	☐	Plant
43	TXTSP	PRPS	TXTSP		☐	SPRAS	☐	Language Key
44	SLWID	PRPS	SLWID		☐	SLWID	☐	Key word ID for user-defined fields
45	USR00	PRPS	USR00		☐	USR00PRPS	☐	1st user field for 20 characters - WBS element-
46	USR01	PRPS	USR01		☐	USR01PRPS	☐	2nd user field 20 digits - WBS element
47	USR02	PRPS	USR02		☐	USR02PRPS	☐	3rd user-defined field 10 digits -WBS element
48	USR03	PRPS	USR03		☐	USR03PRPS	☐	4th user-defined field 10 digits -WBS element
49	USR04	PRPS	USR04		☐	USR04PRPS	☐	1st user-defined field for quantity(length 10,3) WBS element
50	USE04	PRPS	USE04		☐	USE04PRPS	☐	1st user defined field for quantity field unit - WBS element
51	USR05	PRPS	USR05		☐	USR05PRPS	☐	2nd use field for quantity (length 10,3) WBS element
52	USE05	PRPS	USE05		☐	USE05PRPS	☐	2nd user defined field for quantity field unit - WBS element
53	USR06	PRPS	USR06		☐	USR06PRPS	☐	1st user field for values (length 10,3) WBS element
54	USE06	PRPS	USE06		☐	USE06PRPS	☐	1st user defined field for value field unit - WBS element
55	USR07	PRPS	USR07		☐	USR07PRPS	☐	2nd user field for values (length 10,3) -WBS element
56	USE07	PRPS	USE07		☐	USE07PRPS	☐	2nd user defined field for value field unit - WBS element
57	USR08	PRPS	USR08		☐	USR08PRPS	☐	1st user field for date -WBS element
58	USR09	PRPS	USR09		☐	USR09PRPS	☐	2nd user field for date -WBS element
59	USR10	PRPS	USR10		☐	USR10PRPS	☐	1st user field for 'Ind. for evaluations' WBS elem.
60	USR11	PRPS	USR11		☐	USR11PRPS	☐	2nd user field for 'Indicator for eval.s' WBS elemnt
61	KOSTL	PRPS	KOSTL		☐	PS_KOSTL	☐	Cost center to which costs are actually posted
62	KTRG	PRPS	KTRG		☐	KSTRG	☐	Cost Object
63	BERST	PRPS	BERST		☐	PS_BERST	☐	Authorization key for project master data
64	BERTR	PRPS	BERTR		☐	PS_BERTR	☐	Authorization key for project dates (WBS)
65	BERKO	PRPS	BERKO		☐	PS_BERKO	☐	Authorization key for costs and revenues
66	BERBU	PRPS	BERBU		☐	PS_BERBU	☐	Authorization key for project budget
67	CLASF	PRPS	CLASF		☐	PS_CLASF	☐	Indicator: WBS element used in project summarization
68	SPSNR	PRPS	SPSNR		☐	PS_SPSNR	☐	Std WBS: Internal project item number (w/exit on ID)
69	SCOPE	PRPS	SCOPE		☐	SCOPE_CV	☐	Object Class
70	XSTAT	PRPS	XSTAT		☐	PS_XSTAT	☐	Statistical WBS element
71	TXJCD	PRPS	TXJCD		☐	TXJCD	☐	Tax Jurisdiction
72	ZSCHM	PRPS	ZSCHM		☐	PS_ZSCHM	☐	Interest Profile for Project/Order Interest Calculation
73	IMPRF	PRPS	IMPRF		☐	IM_PROFIL	☐	Investment measure profile
74	EVGEW	PRPS	EVGEW		☐	EV_WEIGHTD	☐	Aggregation weight for POC (PS progress)
75	AENNR	PRPS	AENNR		☐	AENNR	☐	Change Number
76	SUBPR	PRPS	SUBPR		☐	PS_SUBPR	☐	Sub-project in work breakdown structure
77	POSTU	PRPS	POSTU		☐	PS_POSTU	☐	PS: Short description (1st text line) in all caps
78	PLINT	PRPS	PLINT		☐	PLINT	☐	Indicator for Integrated Planning
79	LOEVM	PRPS	LOEVM		☐	LOEVM	☐	Deletion Indicator
80	KZBWS	PRPS	KZBWS		☐	KZBWS	☐	Valuation of Special Stock
81	FPLNR	PRPS	FPLNR		☐	FPLNR	☐	Billing plan number / invoicing plan number
82	TADAT	PRPS	TADAT		☐	TABGDAT	☐	Technically complete date
83	IZWEK	PRPS	IZWEK		☐	IZWEK	☐	Reason for investment
84	ISIZE	PRPS	ISIZE		☐	IM_SIZECL	☐	Scale of investment objects
85	IUMKZ	PRPS	IUMKZ		☐	AM_UMWKZ	☐	Reason for environmental investment
86	ABUKR	PRPS	ABUKR		☐	IM_ABUKRS	☐	Requesting company code
87	GRPKZ	PRPS	GRPKZ		☐	GRPSPKZ	☐	Indicator: Grouping WBS element
88	PGPRF	PRPS	PGPRF		☐	PGPROFID	☐	Distribution profile
89	LOGSYSTEM	PRPS	LOGSYSTEM		☐	LOGSYSTEM	☐	Logical System
90	PSPNR_LOGS	PRPS	PSPNR_LOGS		☐	NUM08	☐	Numeric field length 8
91	STORT	PRPS	STORT		☐	PS_STORT	☐	Location
92	FUNC_AREA	PRPS	FUNC_AREA		☐	FKBER	☐	Functional Area
93	KLVAR	PRPS	KLVAR		☐	CK_KLVAR	☐	Costing Variant
94	KALNR	PRPS	KALNR		☐	CK_KALNR	☐	Cost Estimate Number for Cost Est. w/o Qty Structure
95	POSID_EDIT	PRPS	POSID_EDIT		☐	PS_POSID_EDIT	☐	Work Breakdown Structure Element (WBS Element) Edited
96	PSPKZ	PRPS	PSPKZ		☐	PL_PSPKZ	☐	Indicator: WBS element for production lot
97	MATNR	PRPS	MATNR		☐	MATNR	☐	Material Number
98	VLPSP	PRPS	VLPSP		☐	PL_PSP_PNR	☐	WBS: Reference work breakdown structure element
99	VLPKZ	PRPS	VLPKZ		☐	PL_VLPKZ	☐	Indicator: Reference WBS element for production lot
100	SORT1	PRPS	SORT1		☐	PL_SORT1	☐	Sort string 1 for production lot
101	SORT2	PRPS	SORT2		☐	PL_SORT2	☐	Sort string 2 for production lot
102	SORT3	PRPS	SORT3		☐	PL_SORT3	☐	Sort string 3 for production lot
103	VNAME	PRPS	VNAME		☐	JV_NAME	☐	Joint venture
104	RECID	PRPS	RECID		☐	JV_RECIND	☐	Recovery Indicator
105	ETYPE	PRPS	ETYPE		☐	JV_ETYPE	☐	Equity type
106	OTYPE	PRPS	OTYPE		☐	JV_OTYPE	☐	Joint Venture Object Type
107	JIBCL	PRPS	JIBCL		☐	JV_JIBCL	☐	JIB/JIBE Class
108	JIBSA	PRPS	JIBSA		☐	JV_JIBSA	☐	JIB/JIBE Subclass A
109	CGPL_GUID16	PRPS	CGPL_GUID16		☐	CGPL_GUID16_R3	☐	Generic project planning: GUID from external R/3 system
110	CGPL_LOGSYS	PRPS	CGPL_LOGSYS		☐	CGPL_LOGSYS	☐	Generic project planning: Log. system for CGPL_GUID16_R3
111	CGPL_OBJTYPE	PRPS	CGPL_OBJTYPE		☐	CGPL_OBJECT_TYPE_R3	☐	Generic project planning: object type from ext. R/3 system
112	ADPSP	PRPS	ADPSP		☐	ADDCOMPARE_CORE	☐	Reference Element PM/PS
113	RFIPPNT	PRPS	RFIPPNT		☐	CN_RPIP	☐	Reference Point for Relationship Between iPPE and PS
114	LEDNR	BPGE	LEDNR		☐	BP_LEDNR	☐	Budget/Planning Ledger
115	POSIT	BPGE	POSIT		☐	BP_POSIT	☐	Internal commitment item (8 chars)
116	TRGKZ	BPGE	TRGKZ		☐	BP_TRGKZ	☐	Object indicator
117	WRTTP	BPGE	WRTTP		☐	CO_WRTTP	☐	Value Type
118	GEBER	BPGE	GEBER		☐	BP_GEBER	☐	Fund
119	VERSN	BPGE	VERSN		☐	BP_VERSION	☐	Planning/budgeting version
120	VORGA	BPGE	VORGA		☐	BP_VORGANG	☐	Budget Type Budgeting/Planning
121	TWAER	BPGE	TWAER		☐	TWAER	☐	Transaction Currency
122	SUBVO	BPGE	SUBVO		☐	BP_SUBVO	☐	Budget Subtype
123	FAREA	BPGE	FAREA		☐	FM_FAREA	☐	Functional Area
124	WTGES	BPGE	WTGES		☐	BP_WGT	☐	Overall value in transaction currency
125	WLGES	BPGE	WLGES		☐	BP_WGL	☐	Total value in ledger currency
126	WTGEV	BPGE	WTGEV		☐	BP_WGTV	☐	Total distributed value in transaction currency
127	WLGEV	BPGE	WLGEV		☐	BP_WGLV	☐	Distributed value total in ledger currency
128	BELTP	BPGE	BELTP		☐	BP_INOUT	☐	Debit type

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

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

History

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