SAP ABAP View V_INVST_PR (Relevant fields for investments from PRPS and PROJ)
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_INVST_PR  
Short Description Relevant fields for investments from PRPS and PROJ    
Root table PRPS   WBS (Work Breakdown Structure) Element Master Data 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 PRPS PRPS
2 PROJ  
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 PROJ MANDT JR EQ AND 0 0
3 PRPS PSPHI JL EQ 0 0
4 PROJ PSPNR JR EQ 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 VERNR PRPS VERNR   PS_VERNR Number of the responsible person (project manager)
7 PBUKR PRPS PBUKR   PS_PBUKR Company code for WBS element
8 PGSBR PRPS PGSBR   PS_PGSBR Business area for WBS element
9 PKOKR PRPS PKOKR   PS_PKOKR Controlling area for WBS element
10 PRCTR PRPS PRCTR   PRCTR Profit Center
11 PRART PRPS PRART   PS_PRART Project type
12 STUFE PRPS STUFE   PS_STUFE Level in project hierarchy
13 AKOKR PRPS AKOKR   PS_AKOKR Controlling area of requesting cost center
14 AKSTL PRPS AKSTL   PS_AKSTL Requesting cost center
15 WERKS PRPS WERKS   WERKS_D Plant
16 SCOPE PRPS SCOPE   SCOPE_CV Object Class
17 XSTAT PRPS XSTAT   PS_XSTAT Statistical WBS element
18 PROJ_PSPNR PROJ PSPNR   PS_INTNR Current number for project or project item
19 PSPID PROJ PSPID   PS_PSPID Project definition
20 PROJ_POST1 PROJ POST1   PS_POST1 PS: Short description (first text line)
21 PLFAZ PROJ PLFAZ   PS_PLFAZ Project planned start date
22 PLSEZ PROJ PLSEZ   PS_PLSEZ Project planned finish date
                 
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