SAP table QCVKEA (Dialog table for certificate profile: Header level)
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDANT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||
| CTYP | Certificate Type | CHAR | 4 | 0 | TQ05 | QZGTYP | |||||
| VORLNR | Certificate Profile ID | CHAR | 12 | 0 | * | QVORLNR | |||||
| VERSION | Version Number of Certificate Profile | CHAR | 6 | 0 | QCVERSION | ||||||
| SORTFELD | Search Field | CHAR | 40 | 0 | QSORTFELD | ||||||
| GUELTIGAB | Field Not Used Field Reserved for SAP | DATS | 8 | 0 | Q_UNUSEDDT | ||||||
| OBJNR | Object number | CHAR | 22 | 0 | ONR00 | J_OBJNR | |||||
| OBTYP | Object Type | CHAR | 3 | 0 | TJ03 | J_OBTYP | |||||
| STSMA | Status Profile | CHAR | 8 | 0 | TJ20 | J_STSMA | |||||
| ERSTELLER | Name of Person Responsible for Creating the Object | CHAR | 12 | 0 | ERNAM | ||||||
| ERSTELDAT | Date on which the record was created | DATS | 8 | 0 | ERDAT | ||||||
| AENDERER | Name of Person Who Changed Object | CHAR | 12 | 0 | AENAM | ||||||
| AENDERDAT | Last Changed On | DATS | 8 | 0 | AEDAT | ||||||
| TDFORM | SAPscript Form Name | CHAR | 16 | 0 | QCTDFORM | ||||||
| KZGUTLOSE | Only Inspection Lots Whose Usage Decision Is OK | CHAR | 1 | 0 | QKZGUTLOSE | ||||||
| MINQKZ | Minimum Quality Score for Good Quality | DEC | 3 | 0 | QKZMIN | ||||||
| KZLASTLOT | Indicator: Last Lot for Batch | CHAR | 1 | 0 | QKZLASTLOT | ||||||
| KZLIEFSCH | Delivery Note Is Contained in Inspection Lot | CHAR | 1 | 0 | QKZLIEFSCH | ||||||
| HERKUNFT | Inspection Lot Origin | CHAR | 2 | 0 | TQ31 | QHERK | |||||
| ART | Inspection Type | CHAR | 8 | 0 | TQ30 | QPART | |||||
| KONSISTENT | Indicator: Certificate Profile is Consistent | CHAR | 1 | 0 | QKZKONSIST | ||||||
| KURZTEXT | Short Text | CHAR | 40 | 0 | QKURZTEXT | ||||||
| LTEXTKZ | Long Text Exists | CHAR | 1 | 0 | QKZLTX | ||||||
| WITHTRANSF | Stock Transfers from Batch Where-Used List | CHAR | 1 | 0 | QCTRANSFER |
|
|||||
| QDI_NOPDF | Do Not Send PDF Document | CHAR | 1 | 0 | QC_QDI_NOPDF | ||||||
| ALSTF | Expansion Level of Batch Where-Used List | NUMC | 2 | 0 | QCALSTF | ||||||
| ADBFORM | PDF-Based Forms: Form Name | CHAR | 30 | 0 | QC_PDF_FORMNAME | ||||||
| QKZ_USEADB | Use PDF-Based Form | CHAR | 1 | 0 | QC_QKZ_USEADB | ||||||
| CHAR_FIELD_CONF | Configuration of Characteristics Field | CHAR | 3 | 0 | TQ68 | QC_CHAR_FIELD_CONF | |||||
| CHANGEDDATETIME | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | DEC | 15 | 0 | TZNTSTMPS | ||||||
| STATUSTEXT | System Status | CHAR | 40 | 0 | CO_STTXT | ||||||
| ANW_STATUS | Field displaying user status | CHAR | 40 | 0 | CO_ASTTX | ||||||
| KZ_ANWSTAT | User status active | CHAR | 1 | 0 | CO_ASTEX | ||||||
| SPRAS | Language for Selecting Language-Dependent Objects | LANG | 1 | 0 | T002 | QCSPRAS | |||||
| SPTXT | Name of Language | CHAR | 16 | 0 | SPTXT | ||||||
| EXIST_SPRAS | Languages in Which Long Texts Exist | LANG | 1 | 0 | QC_LT_EXIST_SPRAS | ||||||
| EXIST_SPTXT | Name of Language | CHAR | 16 | 0 | SPTXT | ||||||
| NOT_EXIST_SPRAS | Languages in Which No Long Texts Exist | LANG | 1 | 0 | QC_LT_NOT_EXIST_SPRAS | ||||||
| NOT_EXIST_SPTXT | Name of Language | CHAR | 16 | 0 | SPTXT | ||||||
| ICON_LTEXT | Carrier field for icons | CHAR | 132 | 0 | ICON_TEXT | ||||||
| CTYP_TEXT | Short Text | CHAR | 40 | 0 | QKURZTEXT | ||||||
| CHAR_FIELD_CONF_TXT | Short Text | CHAR | 40 | 0 | QKURZTEXT | ||||||
| UPSL | Data Base Access | CHAR | 1 | 0 | QUPSL |
QCVKEA foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 QCVKEA | ART | TQ30 | Inspection types | MANDT |
| 0 QCVKEA | ART | TQ30 | Inspection types | ART |
| 1 QCVKEA | CHAR_FIELD_CONF | TQ68 | Definition of Configuration of Characteristics Field | MANDT |
| 0 QCVKEA | HERKUNFT | TQ31 | Inspection Lot Origins | HERKUNFT |
| 1 QCVKEA | MANDANT | T000 | Clients | MANDT |
| 0 QCVKEA | OBJNR | ONR00 | General Object Number | MANDT |
| 1 QCVKEA | OBTYP | TJ03 | Object types | OBTYP |
| 0 QCVKEA | STSMA | TJ20 | Status profiles | MANDT |
| 0 QCVKEA | STSMA | TJ20 | Status profiles | STSMA |