SAP ABAP Table QCPRD (QM: Certificates in procurement - dialog fields)

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	INTTAB	Structure
Structure	QCPRD	Table Relationship Diagram
Short Description	QM: Certificates in procurement - dialog fields

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	.INCLUDE	☐				0	0	QM quality certificates in procurement
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	CERTNO	☐	QCCERTNO	QCCERTNO	NUMC	12	0	QM Quality Certificate	*
4	ZGTYP	☐	QZGTYP	QZGTYP	CHAR	4	0	Certificate Type	TQ05
5	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	EKKO
6	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	EKPO
7	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
8	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
9	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCH1
10	LICHN	☐	LICHN	LICHN	CHAR	15	0	Vendor Batch Number
11	LFSNR	☐	LFSNR1	XBLNR1	CHAR	16	0	Number of External Delivery Note
12	LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
13	HERSTELLER	☐	QLIFNR	LIFNR	CHAR	10	0	Number of Manufacturer	LFA1
14	MJAHR	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document
15	MBLNR	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document	MKPF
16	ZEILE	☐	MBLPO	MBLPO	NUMC	4	0	Item in material document	MSEG
17	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
18	STATUS	☐	QCSTATUS	QCSTATUS	CHAR	1	0	Certificate Status
19	REMDAT	☐	QCREMDAT	QCREMDAT	DATS	8	0	Reminder Date
20	ESCDAT	☐	QCESCDAT	QCESCDAT	DATS	8	0	Escalation Date
21	CERTDAT	☐	QCERTDAT	QCERTDAT	DATS	8	0	Date of Certfificate Receipt
22	CERTREC	☐	QCERTREC	QCERTREC	CHAR	12	0	Certificate Receipt Entered By
23	ERSTELLER	☐	QERSTELLER	QAENDERER	CHAR	12	0	Name of User Who Created the Data Record
24	ERSTELDAT	☐	QDATUMERST	DATUM	DATS	8	0	Date on Which the Data Record Was Created
25	ERSTELZEIT	☐	QERSTZEIT	QZEIT	TIMS	6	0	Time Data Record Was Created
26	AENDERER	☐	QAENDERER	QAENDERER	CHAR	12	0	Name of User who Most Recently Changed the Data Record
27	AENDERDAT	☐	QDATUMAEND	DATUM	DATS	8	0	Date on Which Data Record Was Changed
28	AENDERZEIT	☐	QAENZEIT	QZEIT	TIMS	6	0	Time of Last Data Record Change
29	MAKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description
30	NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
31	ZGTYPTEXT	☐	QKURZTEXT	QKURZTEXT	CHAR	40	0	Short Text
32	WERKNAME	☐	NAME1	TEXT30	CHAR	30	0	Name
33	STATUS_TEXT	☐	QCSTATUS_TEXT		CHAR	40	0	Status of Certificate Record
34	QREMIND	☐	QCREMIND	QCREMIND	NUMC	4	0	Reminder Deadline (Days)

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in