SAP Table QCVKEA

Dialog table for certificate profile: Header level

QCVKEA (Dialog table for certificate profile: Header level) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link QCVKEA to other SAP tables.

Source: QCVKEA (Dialog table for certificate profile: Header level)

QCVKEA table fields

Field Data element Checktable Datatype Length Decimals
MANDANT Client MANDT T000 CLNT 3 0
CTYP Certificate Type QZGTYP TQ05 CHAR 4 0
VORLNR Certificate Profile Number QVORLNR CHAR 12 0
VERSION Version Number of Certificate Profile QCVERSION CHAR 6 0
SORTFELD Search Field QSORTFELD CHAR 40 0
GUELTIGAB Field Not Used Field Reserved for SAP Q_UNUSEDDT DATS 8 0
OBJNR Object number J_OBJNR ONR00 CHAR 22 0
OBTYP Object Category J_OBTYP TJ03 CHAR 3 0
STSMA Status Profile J_STSMA TJ20 CHAR 8 0
ERSTELLER Name of Person who Created the Object ERNAM CHAR 12 0
ERSTELDAT Date on Which Record Was Created ERDAT DATS 8 0
AENDERER Name of Person Who Changed Object AENAM CHAR 12 0
AENDERDAT Changed On AEDAT DATS 8 0
TDFORM Form Name QCTDFORM CHAR 16 0
KZGUTLOSE Indicator: Only Lots Whose Usage Decision is OK QKZGUTLOSE CHAR 1 0
NULL Indicator is not set
X Indicator is set
MINQKZ Minimum Quality Score for Good Quality QKZMIN DEC 3 0
KZLASTLOT Indicator: Last Lot for Batch QKZLASTLOT CHAR 1 0
NULL Indicator is not set
X Indicator is set
KZLIEFSCH Indicator: Delivery Note in Inspection Lot QKZLIEFSCH CHAR 1 0
NULL Indicator is not set
X Indicator is set
HERKUNFT Inspection Lot Origin QHERK TQ31 CHAR 2 0
ART Inspection Type QPART TQ30 CHAR 8 0
KONSISTENT Indicator: Certificate Profile is Consistent QKZKONSIST CHAR 1 0
NULL Indicator is not set
X Indicator is set
KURZTEXT Short Text QKURZTEXT CHAR 40 0
LTEXTKZ Long Text Exists QKZLTX CHAR 1 0
NULL Indicator is not set
X Indicator is set
WITHTRANSF Stock Transfers from Batch Where-Used List QCTRANSFER CHAR 1 0
X Transfer Postings
1 Transfer Postings and Stock Transport Orders
QDI_NOPDF Indicator: Do Not Send PDF Document QC_QDI_NOPDF CHAR 1 0
NULL Indicator is not set
X Indicator is set
ALSTF Expansion Level of Batch Where-Used List QCALSTF NUMC 2 0
ADBFORM PDF-Based Forms: Form Name QC_PDF_FORMNAME CHAR 30 0
QKZ_USEADB Use Adobe Form QC_QKZ_USEADB CHAR 1 0
NULL Indicator is not set
X Indicator is set
CHAR_FIELD_CONF Configuration of Characteristics Field QC_CHAR_FIELD_CONF TQ68 CHAR 3 0
STATUSTEXT System Status CO_STTXT CHAR 40 0
ANW_STATUS Field displaying user status CO_ASTTX CHAR 40 0
KZ_ANWSTAT User status active CO_ASTEX CHAR 1 0
X
NULL
SPRAS Language for Selecting Language-Dependent Objects QCSPRAS T002 LANG 1 0
SPTXT Name of Language SPTXT CHAR 16 0
EXIST_SPRAS Languages in Which Long Texts Exist QC_LT_EXIST_SPRAS LANG 1 0
EXIST_SPTXT Name of Language SPTXT CHAR 16 0
NOT_EXIST_SPRAS Languages in Which No Long Texts Exist QC_LT_NOT_EXIST_SPRAS LANG 1 0
NOT_EXIST_SPTXT Name of Language SPTXT CHAR 16 0
ICON_LTEXT Carrier field for icons ICON_TEXT CHAR 132 0
CTYP_TEXT Short Text QKURZTEXT CHAR 40 0
CHAR_FIELD_CONF_TXT Short Text QKURZTEXT CHAR 40 0

QCVKEA foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
QCVKEA ART QCVKEA MANDANT TQ30 Inspection types MANDT
QCVKEA ART QCVKEA ART TQ30 Inspection types ART
QCVKEA CHAR_FIELD_CONF QCVKEA MANDANT TQ68 Definition of Configuration of Characteristics Field MANDT
QCVKEA CHAR_FIELD_CONF QCVKEA CHAR_FIELD_CONF TQ68 Definition of Configuration of Characteristics Field CHAR_FIELD_CONF
QCVKEA CTYP QCVKEA MANDANT TQ05 QM certificate categories for procurement MANDT
QCVKEA CTYP QCVKEA CTYP TQ05 QM certificate categories for procurement ZGTYP
QCVKEA HERKUNFT QCVKEA HERKUNFT TQ31 Inspection Lot Origins HERKUNFT
QCVKEA MANDANT QCVKEA MANDANT T000 Clients MANDT
QCVKEA OBJNR QCVKEA MANDANT ONR00 General Object Number MANDT
QCVKEA OBJNR QCVKEA OBJNR ONR00 General Object Number OBJNR
QCVKEA OBTYP QCVKEA OBTYP TJ03 Object types OBTYP
QCVKEA SPRAS QCVKEA SPRAS T002 Language Keys (Component BC-I18) SPRAS
QCVKEA STSMA QCVKEA MANDANT TJ20 Status profiles MANDT
QCVKEA STSMA QCVKEA STSMA TJ20 Status profiles STSMA