SAP ABAP View /ISDFPS/V_EPAREF (Database View for Selection of MCs)
Hierarchy
EA-DFPS (Software Component) SAP Enterprise Extension Defense Forces & Public Security
   IS-DFS-OF-MPA (Application Component) Logistical Requirements
     /ISDFPS/CPPEMPA (Package) Material Packages
Basic Data
View Type D Database View 
Database View /ISDFPS/V_EPAREF  
Short Description Database View for Selection of MCs    
Root table PNODID   iPPE Node: Identification 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 PNODID PNODID
2 PNODTX  
3 CPNTYPE  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 PNODID MANDT JL EQ 0 0
2 PNODTX MANDT JR EQ AND 0 0
3 PNODID PNGUID JL EQ 0 0
4 PNODTX PNGUID JR EQ AND 0 0
5 CPNTYPE MANDT JL EQ 0 0
6 PNODID MANDT JR EQ AND 0 0
7 CPNTYPE PNTYPE JL EQ 0 0
8 PNODID PNTYPE JR EQ AND 0 0
9 PNODID APPLOBJ_TYPE EQ 'MPO' OR 0 0
10 PNODID APPLOBJ_TYPE EQ 'MPA' AND 0 0
11 PNODID PNTYPE NE 'S_DFMPO' AND 0 0
12 PNODID PNTYPE NE 'S_DFMPOV' AND 0 0
13 PNODID PNTYPE NE 'S_DFSSP' AND 0 0
14 CPNTYPE REF_PNTYPE EQ 'S_DFMC' OR 0 0
15 CPNTYPE REF_PNTYPE EQ '' OR 0 0
16 CPNTYPE REF_PNTYPE EQ 'S_DFEPA' 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT PNODID MANDT   MANDT Client
2 PNGUID PNODID PNGUID   PVS_PNGUID Internal Number of iPPE Node
3 PNTXCNT PNODTX PNTXCNT   PVS_TXTCOUNT Counter for Text Tables
4 SPRAS PNODTX SPRAS   SPRAS Language Key
5 PNAME PNODID PNAME   PVS_PNODE iPPE Node Description
6 PNTEXT PNODTX PNTEXT   PVS_PNODETX Short Text for iPPE Node
7 PNTYPE PNODID PNTYPE   PVS_PNODE_TYPE iPPE Node Type
8 APPLOBJ_TYPE PNODID APPLOBJ_TYPE   PPE_APPLOBJ_TYPE iPPE Application Object Type
9 PNTEXT_UP PNODTX PNTEXT_UP   PVS_PNODETXUP PVS Node Short Text in Upper Case
                 
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 470