SAP ABAP Table QCVK (Certificate profile header)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ QC (Package) QM quality certificate

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	QCVK	Table Relationship Diagram
Short Description	Certificate profile header

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	MANDANT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	CTYP	☑	QZGTYP	QZGTYP	CHAR	4	0	Certificate Type	TQ05
3	VORLNR	☑	QVORLNR	QVORLNR	CHAR	12	0	Certificate Profile Number
4	VERSION	☑	QCVERSION	QVERSNR	CHAR	6	0	Version Number of Certificate Profile
5	SORTFELD	☐	QSORTFELD	CHAR40	CHAR	40	0	Search Field
6	GUELTIGAB	☐	Q_UNUSEDDT	DATUM	DATS	8	0	Field Not Used Field Reserved for SAP
7	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
8	OBTYP	☐	J_OBTYP	J_OBTYP	CHAR	3	0	Object Category	TJ03
9	STSMA	☐	J_STSMA	J_STSMA	CHAR	8	0	Status Profile	TJ20
10	ERSTELLER	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
11	ERSTELDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
12	AENDERER	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
13	AENDERDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
14	TDFORM	☐	QCTDFORM	TDFORM	CHAR	16	0	Form Name
15	KZGUTLOSE	☐	QKZGUTLOSE	QKZ	CHAR	1	0	Indicator: Only Lots Whose Usage Decision is OK
16	MINQKZ	☐	QKZMIN	QKENNZAHL	DEC	3	0	Minimum Quality Score for Good Quality
17	KZLASTLOT	☐	QKZLASTLOT	QKZ	CHAR	1	0	Indicator: Last Lot for Batch
18	KZLIEFSCH	☐	QKZLIEFSCH	QKZ	CHAR	1	0	Indicator: Delivery Note in Inspection Lot
19	HERKUNFT	☐	QHERK	QHERK	CHAR	2	0	Inspection Lot Origin	TQ31
20	ART	☐	QPART	QPART	CHAR	8	0	Inspection Type	TQ30
21	KONSISTENT	☐	QKZKONSIST	QKZ	CHAR	1	0	Indicator: Certificate Profile is Consistent
22	KURZTEXT	☐	QKURZTEXT	QKURZTEXT	CHAR	40	0	Short Text
23	LTEXTKZ	☐	QKZLTX	QKZ	CHAR	1	0	Long Text Exists
24	WITHTRANSF	☐	QCTRANSFER	QCTRANSFER	CHAR	1	0	Stock Transfers from Batch Where-Used List
25	QDI_NOPDF	☐	QC_QDI_NOPDF	QKZ	CHAR	1	0	Indicator: Do Not Send PDF Document
26	ALSTF	☐	QCALSTF	SEU_LEVEL	NUMC	2	0	Expansion Level of Batch Where-Used List
27	ADBFORM	☐	QC_PDF_FORMNAME	FPNAME	CHAR	30	0	PDF-Based Forms: Form Name
28	QKZ_USEADB	☐	QC_QKZ_USEADB	QKZ	CHAR	1	0	Use Adobe Form
29	CHAR_FIELD_CONF	☐	QC_CHAR_FIELD_CONF	QC_CHAR_FIELD_CONF	CHAR	3	0	Configuration of Characteristics Field	TQ68

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	QCVK	ART	TQ30	ART
2	QCVK	CHAR_FIELD_CONF	TQ68	CHAR_FIELD_CONF
3	QCVK	CTYP	TQ05	ZGTYP	KEY	1	CN
4	QCVK	HERKUNFT	TQ31	HERKUNFT	KEY
5	QCVK	MANDANT	T000	MANDT	KEY	1	CN
6	QCVK	OBJNR	ONR00	OBJNR
7	QCVK	OBTYP	TJ03	OBTYP
8	QCVK	STSMA	TJ20	STSMA

History

Last changed by/on	SAP	20100310
SAP Release Created in