SAP ABAP Table MGV_QPRN (Generated Table for View MGV_QPRN)
Basic Data
Table Category VIEW    General view structure 
General view structure MGV_QPRN   Table Relationship Diagram
Short Description Generated Table for View MGV_QPRN    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type
Length Decimal
Places
Short Description Check
table
1 MANDT MANDT MANDT CLNT 3   0   Client T000
2 PN_NR QPZNR NUMC12 NUMC 12   0   Sample-Drawing Number  
3 PLOS QLOT_LATE QPLOS NUMC 12   0   Current or Last Inspection Lot for the Sample QALS
4 MATNR MATNR MATNR CHAR 18   0   Material Number MARA
5 WERKS WERKS_D WERKS CHAR 4   0   Plant T001W
6 REVLV REVLV REVLV CHAR 2   0   Revision level  
7 CHARG CHARG_D CHARG CHAR 10   0   Batch Number MCH1
8 KUNNR QKUNWE KUNNR CHAR 10   0   Customer (Ship-To Party) KNA1
9 LIFNR ELIFN LIFNR CHAR 10   0   Vendor's account number LFA1
10 HRSTL QLIFNR LIFNR CHAR 10   0   Number of Manufacturer LFA1
11 MBLNR MBLNR BELNR CHAR 10   0   Number of Material Document  
12 ZEILE MBLPO MBLPO NUMC 4   0   Item in material document  
13 MJAHR MJAHR GJAHR NUMC 4   0   Year of material document  
14 AUFNR AUFNR AUFNR CHAR 12   0   Order Number AUFK
15 VERID VERID VERID CHAR 4   0   Production Version MKAL
16 SA_AUFNR SA_AUFNR SA_AUFNR CHAR 12   0   Run schedule header number SAFK
17 ANLNA QPRS_ANL QAENDERER CHAR 12   0   User who Created the Physical Sample  
18 ANLDT QPRS_ANLDT DATUM DATS 8   0   Creation Date of Physical Sample  
19 ANLZT QPRS_ANLZT QZEIT TIMS 6   0   Time at Which the Physical Sample Was Created  
20 QMATAUTH QMATAUTH QMATAUTH CHAR 6   0   Material authorization group for activities in QM  
21 KZQUIT QKZQUIT QKZ CHAR 1   0   Confirmation Required for Physical-Sample Drawing  
22 SIG_IL_SDR SIG_IL_SDR SIG_IL_SDR CHAR 1   0   Digital Signature for Confirmation of Phys.-Sample Drawing  
23 FRGNA QPRS_FRG QAENDERER CHAR 12   0   User who Released the Physical Sample  
24 FRGDT QPRS_FRGDT DATUM DATS 8   0   Physical Sample Release Date  
25 FRGZT QPRS_FRGZT QZEIT TIMS 6   0   Time of Physical Sample Release  
26 PZTXT QPZ_TEXT TEXT40 CHAR 40   0   Comments on the Physical-Sample Drawing  
27 QMNUM QMNUM QMNUM CHAR 12   0   Message Number QMEL
28 MATNR_EXT MATNR_EXT MATNR_EXT CHAR 40   0   External Long Material Number  
29 MATNR_VERS MATNR_VERS MATNR_VERS CHAR 10   0   Material Version Number  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 MGV_QPRN AUFNR AUFK AUFNR    
2 MGV_QPRN CHARG MCH1 CHARG    
3 MGV_QPRN HRSTL LFA1 LIFNR    
4 MGV_QPRN KUNNR KNA1 KUNNR    
5 MGV_QPRN LIFNR LFA1 LIFNR    
6 MGV_QPRN MANDT T000 MANDT KEY 1 CN
7 MGV_QPRN MATNR MARA MATNR    
8 MGV_QPRN PLOS QALS PRUEFLOS    
9 MGV_QPRN QMNUM QMEL QMNUM REF C CN
10 MGV_QPRN SA_AUFNR SAFK AUFNR    
11 MGV_QPRN VERID MKAL VERID REF C CN
12 MGV_QPRN WERKS T001W WERKS    
History
Last changed by/on SAP  20050301 
SAP Release Created in