SAP ABAP Table MGV_QCPR (Generated Table for View MGV_QCPR)

Basic Data

Table Category	VIEW	General view structure
General view structure	MGV_QCPR	Table Relationship Diagram
Short Description	Generated Table for View MGV_QCPR

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	CERTNO	☑	QCCERTNO	QCCERTNO	NUMC	12	0	QM Quality Certificate
3	ZGTYP	☐	QZGTYP	QZGTYP	CHAR	4	0	Certificate Type	TQ05
4	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	EKKO
5	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	EKPO
6	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
7	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
8	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCH1
9	LICHN	☐	LICHN	LICHN	CHAR	15	0	Vendor Batch Number
10	LFSNR	☐	LFSNR1	XBLNR1	CHAR	16	0	Number of External Delivery Note
11	LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
12	HERSTELLER	☐	QLIFNR	LIFNR	CHAR	10	0	Number of Manufacturer	LFA1
13	MJAHR	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document
14	MBLNR	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document	MKPF
15	ZEILE	☐	MBLPO	MBLPO	NUMC	4	0	Item in material document	MSEG
16	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
17	STATUS	☐	QCSTATUS	QCSTATUS	CHAR	1	0	Certificate Status
18	REMDAT	☐	QCREMDAT	QCREMDAT	DATS	8	0	Reminder Date
19	ESCDAT	☐	QCESCDAT	QCESCDAT	DATS	8	0	Escalation Date
20	CERTDAT	☐	QCERTDAT	QCERTDAT	DATS	8	0	Date of Certfificate Receipt
21	CERTREC	☐	QCERTREC	QCERTREC	CHAR	12	0	Certificate Receipt Entered By
22	ERSTELLER	☐	QERSTELLER	QAENDERER	CHAR	12	0	Name of User Who Created the Data Record
23	ERSTELDAT	☐	QDATUMERST	DATUM	DATS	8	0	Date on Which the Data Record Was Created
24	ERSTELZEIT	☐	QERSTZEIT	QZEIT	TIMS	6	0	Time Data Record Was Created
25	AENDERER	☐	QAENDERER	QAENDERER	CHAR	12	0	Name of User who Most Recently Changed the Data Record
26	AENDERDAT	☐	QDATUMAEND	DATUM	DATS	8	0	Date on Which Data Record Was Changed
27	AENDERZEIT	☐	QAENZEIT	QZEIT	TIMS	6	0	Time of Last Data Record Change
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_QCPR	CHARG	MCH1	CHARG	REF	C	CN
2	MGV_QCPR	EBELN	EKKO	EBELN		C	CN
3	MGV_QCPR	EBELP	EKPO	EBELP		C	CN
4	MGV_QCPR	HERSTELLER	LFA1	LIFNR	REF	C	CN
5	MGV_QCPR	LIFNR	LFA1	LIFNR	REF	C	CN
6	MGV_QCPR	MANDT	T000	MANDT	KEY	1	CN
7	MGV_QCPR	MATNR	MARA	MATNR		C	CN
8	MGV_QCPR	MBLNR	MKPF	MBLNR
9	MGV_QCPR	WERKS	T001W	WERKS	REF	C	CN
10	MGV_QCPR	ZEILE	MSEG	ZEILE
11	MGV_QCPR	ZGTYP	TQ05	ZGTYP		C	CN

History

Last changed by/on	SAP	20050409
SAP Release Created in