SAP ABAP View MGV_QCPR (Selection QCPR with material version, see: http://material)
Hierarchy
ECC-DIMP (Software Component) DIMP
   LO-MD-MM (Application Component) Material Master
     MGV_MATNR (Package) Material number conversion (long mat. no.)
Basic Data
View Type D Database View 
Database View MGV_QCPR  
Short Description Selection QCPR with material version, see: http://material    
Root table QCPR   QM quality certificates in procurement 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 QCPR QCPR
2 MATERIALID  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 QCPR MANDT JL EQ 0 0
2 MATERIALID MANDT JR EQ AND 0 0
3 QCPR MATNR JL EQ 0 0
4 MATERIALID MATNR_INT JR EQ 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 * QCPR *    
2 MANDT QCPR MANDT   MANDT Client
3 CERTNO QCPR CERTNO   QCCERTNO QM Quality Certificate
4 ZGTYP QCPR ZGTYP   QZGTYP Certificate Type
5 EBELN QCPR EBELN   EBELN Purchasing Document Number
6 EBELP QCPR EBELP   EBELP Item Number of Purchasing Document
7 MATNR QCPR MATNR   MATNR Material Number
8 WERKS QCPR WERKS   WERKS_D Plant
9 CHARG QCPR CHARG   CHARG_D Batch Number
10 LICHN QCPR LICHN   LICHN Vendor Batch Number
11 LFSNR QCPR LFSNR   LFSNR1 Number of External Delivery Note
12 LIFNR QCPR LIFNR   ELIFN Vendor's account number
13 HERSTELLER QCPR HERSTELLER   QLIFNR Number of Manufacturer
14 MJAHR QCPR MJAHR   MJAHR Year of material document
15 MBLNR QCPR MBLNR   MBLNR Number of Material Document
16 ZEILE QCPR ZEILE   MBLPO Item in material document
17 BUDAT QCPR BUDAT   BUDAT Posting Date in the Document
18 STATUS QCPR STATUS   QCSTATUS Certificate Status
19 REMDAT QCPR REMDAT   QCREMDAT Reminder Date
20 ESCDAT QCPR ESCDAT   QCESCDAT Escalation Date
21 CERTDAT QCPR CERTDAT   QCERTDAT Date of Certfificate Receipt
22 CERTREC QCPR CERTREC   QCERTREC Certificate Receipt Entered By
23 ERSTELLER QCPR ERSTELLER   QERSTELLER Name of User Who Created the Data Record
24 ERSTELDAT QCPR ERSTELDAT   QDATUMERST Date on Which the Data Record Was Created
25 ERSTELZEIT QCPR ERSTELZEIT   QERSTZEIT Time Data Record Was Created
26 AENDERER QCPR AENDERER   QAENDERER Name of User who Most Recently Changed the Data Record
27 AENDERDAT QCPR AENDERDAT   QDATUMAEND Date on Which Data Record Was Changed
28 AENDERZEIT QCPR AENDERZEIT   QAENZEIT Time of Last Data Record Change
29 MATNR_EXT MATERIALID MATNR_EXT   MATNR_EXT External Long Material Number
30 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  20050409 
SAP Release Created in