SAP ABAP Table QCPR (QM quality certificates in procurement)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ QM-CA (Application Component) Quality Certificates
     ⤷ QCPR (Package) QM quality certificates in procurement

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	QCPR	Table Relationship Diagram
Short Description	QM quality certificates in procurement

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	QCPR	CHARG	MCH1	CHARG	REF	C	CN
2	QCPR	EBELN	EKKO	EBELN		C	CN
3	QCPR	EBELP	EKPO	EBELP		C	CN
4	QCPR	HERSTELLER	LFA1	LIFNR	REF	C	CN
5	QCPR	LIFNR	LFA1	LIFNR	REF	C	CN
6	QCPR	MANDT	T000	MANDT	KEY	1	CN
7	QCPR	MATNR	MARA	MATNR		C	CN
8	QCPR	MBLNR	MKPF	MBLNR
9	QCPR	WERKS	T001W	WERKS	REF	C	CN
10	QCPR	ZEILE	MSEG	ZEILE
11	QCPR	ZGTYP	TQ05	ZGTYP		C	CN

History

Last changed by/on	SAP	20050409
SAP Release Created in