SAP ABAP View MGV_V_PICPS (PIC View: MPN FFF-Class View (PICHD+PICPS))
Hierarchy
ECC-DIMP (Software Component) DIMP
   LO-MD-MM (Application Component) Material Master
     MGV_MATNR_LAMA (Package) LAMA: Material number conversion (long mat. no.)
Basic Data
View Type D Database View 
Database View MGV_V_PICPS  
Short Description PIC View: MPN FFF-Class View (PICHD+PICPS)    
Root table PICHD   Parts Interchangeability Header Data (Sus+MPN) 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 PICHD PICHD
2 PICPS  
3 MATERIALID  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 PICHD MANDT JL EQ 0 0
2 PICPS MANDT JR EQ AND 0 0
3 PICHD PICKEY JL EQ 0 0
4 PICPS PICKEY JR EQ AND 0 0
5 PICPS MANDT JL EQ 0 0
6 MATERIALID MANDT JR EQ AND 0 0
7 PICPS MATNR JL EQ 0 0
8 MATERIALID MATNR_INT JR EQ 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT PICHD MANDT   MANDT Client
2 PICNUM PICHD PICNUM   PIC_PICNUM Parts Interchangeability Group Number
3 PICKEY PICHD PICKEY   PIC_PICKEY Part Interchangeability Object Key (GUID)
4 PICCAT PICHD PICCAT   PIC_PICCAT Interchangeable parts category
5 PICPOS PICPS PICPOS   PIC_PICPOS Item Number of Parts Interchangeability Member
6 COUNTER PICPS COUNTER   PIC_COUNTER Parts Interchangeability Counter (ECM)
7 MATNR PICPS MATNR   MATNR Material Number
8 LOEKZ PICPS LOEKZ   PIC_LOEKZ Parts Interchangeability Member Marked for Deletion
9 SEQNR PICPS SEQNR   PIC_SEQNR Sequence number of interchangeable part
10 DATFR PICPS DATFR   PIC_DATFR Valid from date of an interchangeable part
11 INTTYPE PICPS INTTYPE   PIC_INTTYPE Replacement Type
12 PICCODE PICPS PICCODE   PIC_PICCODE Cause of part exchange
13 HERDAT PICHD ERDAT   PIC_ERDAT Date on Which Record Was Created
14 HERNAM PICHD ERNAM   PIC_ERNAM Name of person who created the object
15 HAEDAT PICHD AEDAT   PIC_AEDAT Last Changed On
16 HAENAM PICHD AENAM   PIC_AENAM Name of person who changed object
17 ERDAT PICPS ERDAT   PIC_ERDAT Date on Which Record Was Created
18 ERNAM PICPS ERNAM   PIC_ERNAM Name of person who created the object
19 AEDAT PICPS AEDAT   PIC_AEDAT Last Changed On
20 AENAM PICPS AENAM   PIC_AENAM Name of person who changed object
21 MATNR_EXT MATERIALID MATNR_EXT   MATNR_EXT External Long Material Number
22 MATNR_VERS MATERIALID MATNR_VERS   MATNR_VERS Material Version Number
                 
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  20070918 
SAP Release Created in 600