QCERT_TS_CHARACT_PDF SAP (Quality Certificate Data at Characteristics Level PDF) Structure details

Dictionary Type: Structure
Description: Quality Certificate Data at Characteristics Level PDF




ABAP Code to SELECT data from QCERT_TS_CHARACT_PDF
Related tables to QCERT_TS_CHARACT_PDF
Access table QCERT_TS_CHARACT_PDF




Structure field list including key, data, relationships and ABAP select examples

QCERT_TS_CHARACT_PDF is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Quality Certificate Data at Characteristics Level PDF" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_QCERT_TS_CHARACT_PDF TYPE QCERT_TS_CHARACT_PDF.

The QCERT_TS_CHARACT_PDF table consists of various fields, each holding specific information or linking keys about Quality Certificate Data at Characteristics Level PDF data available in SAP. These include MANDANT (Client), CTYP (Certificate Type), VORLNR (Certificate Profile Number), VERSION (Version Number of Certificate Profile).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)


SAP QCERT_TS_CHARACT_PDF structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
QCVME 0
MANDANTClient MANDTCLNT3MANDT
CTYPCertificate Type QZGTYPCHAR4QZGTYPQCT
VORLNRCertificate Profile Number QVORLNRCHAR12QVORLNRQCV
VERSIONVersion Number of Certificate Profile QCVERSIONCHAR6ALPHAQVERSNRQCS
BLOCKNRNumber of Characteristic Block QBLOCKNRNUMC4NUMC4
MERKMALNRConsecutive Characteristic Number QMKNRNUMC4QCMERKNR
SORTNRSort Number QSORTNRNUMC4NUMC4
TEXT_ELEMAssignment of a Characteristic to a Form Text Element QCTEXTELEMCHAR4CHAR4
KATEGORIECharacteristic Category for Certificates QCCHARCATCHAR1QCMERKKAT
ZAEHLERPlant WERKS_DCHAR4WERKSWRKH_T001W_C
MKMNRMaster Inspection Characteristics QMERKNRCHAR8ALPHAQMERKNRPMK
VERSIONMKVersion Number of the Master Inspection Characteristic QVERSNRMKCHAR6ALPHAQVERSNR
CMERKMALIDInternal characteristic ATINNNUMC10ATINNATINN
KZHERKWERTOrigin of the Characteristic Result on the Certificate QKZHERKWTCHAR2QKZHERKWT
KZHERKTEXTOrigin of Characteristic Short Text QKZHERKTXTCHAR2QKZHERKTXT
KZAUSGFMTCharacteristic Output Format QKZAUSGFMTCHAR2QKZAUSGFMT
KZMETHODEOutput Inspection Method QKZMETHODECHAR2QKZMETHODE
KZESELLevel for Result Selection QKZESELCHAR1QKZESEL
KZHERKVGOrigin of Inspection Specifications QKZHERKVGCHAR2QKZHERKVG
KZSTRSKIPOutput Strategy for Skip Characteristics QKZSTRSKIPCHAR2QKZSTRSKIP
MASSEINHSWUnit of Measurement, in Which Quantitative Data Is Stored QMASSEHUNIT3CUNITMEINS
AUSGLENOutput Length QLAENGEINT13QLAENGE
STELLENNumber of Places to the Right of a Decimal Point (Accuracy) QSTELLENINT13QSTELLEN
KZEXPDSIndicator: Exponential Notation QKZEXPDSCHAR1QKZ
KZOFFSPTXAdditional Text When Result Is Outside Specifications QKZOFFSPTXCHAR1QKZOFFSPTX
KZOBLIndicator: Characteristic Required QKZMKOBLCHAR1QKZ
VMSORTNRSort Number in List of Materials for Certificate Profile QCSORTNRNUMC4NUMC4
COLUMNSORTDisplay by Columns QCCOLSORTCHAR1QKZ
COLUMNSNumber of Columns QCCOLUMNSNUMC2NUMC2
UNITNRSORTSort by Term for Inspected Unit QCUNITSORTCHAR1QKZ
CHARACT_ID1Characteristic Description for Quality Data Exchange QCHARACT_ID1CHAR40ALPHAQCHARACT_ID
TQ61_FBNAMName of Function Module RS38L_FNAMCHAR30FUNCNAMELIB
FROM_LOTIndicator: Read Inspection Lots QKZFROMLOTCHAR1QKZ
TQ62_FBNAMName of Function Module RS38L_FNAMCHAR30FUNCNAMELIB
TQ63_FBNAMName of Function Module RS38L_FNAMCHAR30FUNCNAMELIB
TQ64_FBNAMName of Function Module RS38L_FNAMCHAR30FUNCNAMELIB
INCOMPLETEX and Blank QKZCHAR1QKZ
ATNAMCharacteristic Name ATNAMCHAR30ATNAMFEA
VALUESORTNRSort Number QSORTNRNUMC4NUMC4
IPMEDIUMMean Value / Original Values from All Inspection Points QCIPMEDIUMCHAR1QKZ
QCSPEC 0
PRUEFLOSInspection Lot Number QPLOSNUMC12QPLOSQLSQALS
TEILLOSPartial lot number QTLOSNUMC6QTLOSQTL
VORGLFNRCurrent Node Number from Order Counter APLZL QLFNKNNUMC8KNTNR
MATNRMaterial Number MATNRCHAR18MATN1MATNRMATS_MAT1
CHARGBatch Number CHARG_DCHAR10CHARGCHA
PHYSPROBENumber of the Partial Sample QPHYSPROBENUMC6QPROBENR
STATUSVSpecification Record Status QSTATUSCHAR1QSTATUS
STATUSTEXTShort Text QKURZTEXTCHAR40QKURZTEXT
QUANTITATQuantitative Characteristic QKZQUNMKCHAR1QKZ
MESSWERTEMeasured Values Must Be Recorded QKZQUMKCHAR1QKZ
PRUEFKATReference to Characteristic Attribute Required QKZPKATCHAR1QKZ
TOLEROBENUpper Specification Limit QKZTOLOBCHAR1QKZ
TOLERUNTENLower Specification Limit QKZTOLUNCHAR1QKZ
PUMFKZInspection Scope QPUMFKZCHAR1QPUMFKZ
LZEITKZLong-Term Inspection QLZEITKZCHAR1QKZ
ESTUKZRecording Type QESTUKZCHAR1QESTUKZ
DOKUKZDocumentation Required for Inspection Results QDOKUKZCHAR1QDOKUKZ
RZWANGCharacteristic Category QRZWANGCHAR1QRZWANG
SYNCROSynchronization is Active QSYNCROCHAR1QKZ
ZERSTPRFDestructive Inspection QKZDESTROYCHAR1QKZ
FORMELMKCalculated Characteristic QKZFORMELCHAR1QKZFORMEL
STICHPRSampling Procedure is Required QSTICHPRCHAR1QKZ
AUSSLOSCharacteristic Relevant for Qual. Score and Scrap Share QAUSSLOSCHAR1QKZ
BEWFHLZHLRecording the Number of Defects QBFHLZHLCHAR1QKZ
FEHLRECDefects Recording Automatically Called Up QFEHLRECCHAR1QKZ
AENDBELEGCreate Change Documents During Results Recording QKZAENBELCHAR1QKZ
QMTB_WERKSPlant WERKS_DCHAR4WERKSWRKH_T001W_C
PMETHODEInspection Method QPMETHODECHAR8ALPHAQPMETHODEPMT
PMTVERSIONVersion Number of the Inspection Method QVERSNRPMCHAR6ALPHAQVERSNR
PMT_KTEXTShort Text for Inspection Method QTXTMETHODCHAR40QKURZTEXT
PMT_LTXTKZLong Text Exists for the Inspection Method QLTEXTMTCHAR1QKZ
MERKGEWWeighting of the Characteristic QMERKGEWCHAR2QMERKKLAS
WERKSPlant QWERKSCHAR4WERKS
MKMNRMaster Inspection Characteristics QMERKNRCHAR8ALPHAQMERKNRPMK
VERSIONVersion Number of the Master Inspection Characteristic QVERSNRMKCHAR6ALPHAQVERSNR
KURZTEXTShort Text for the Inspection Characteristic QMKKURZTXTCHAR40QKURZTEXT
DUMMY10Text Line for Additional Information QTXT10CHAR10QTXT10
DUMMY20Text Line for Additional Information QTXT20CHAR20QTXT20
DUMMY40Text Line for Additional Information QTXT40CHAR40QTXT40
AUSWMENGE1Assigned Code Group or Selected Set QCGRAUSWCHAR8QCGRAUSW
AUSWMGWRK1Plant of the Assigned Selected Set QWERKAUSWCHAR4WERKSWRK
AUSWMTEXT1Short Text for the Code Group/Selected Set QTXT_GROUPCHAR40QKURZTEXT
TEXT_KAT1Short Text for the Catalog QTXTCATALGCHAR40QKURZTEXT
STELLENNumber of Places to the Right of a Decimal Point (Accuracy) QSTELLENINT13QSTELLEN
MASSEINHSWUnit of Measurement MSEHIUNIT3CUNITMEINS
SOLLWERTTarget Value for a Quantitative Characteristic QSOLLWERTCCHAR16QSOLLWERTC
TOLERANZOBUpper Specification Limit QTOLOBCCHAR16QSOLLWERTC
TOLERANZUNLower Specification Limit QTOLUNCCHAR16QSOLLWERTC
TOLOBFLOATUpper Specification Limit QTOLOBFLTP16(16) QSOLLWERTE
TOLUNFLOATLower Tolerance Limit QTOLUNFLTP16(16) QSOLLWERTE
TOLERWKZTolerance Change Is Active QTOLERWKZCHAR1QKZ
GRENZEOB1First Upper Specification Limit QGRENZO1CCHAR16QSOLLWERTC
GRENZEUN1First Lower Specification Limit QGRENZU1CCHAR16QSOLLWERTC
GRENZEOB2Second Upper Specification Limit QGRENZO2CCHAR16QSOLLWERTC
GRENZEUN2Second Lower Specification Limit QGRENZU2CCHAR16QSOLLWERTC
PLAUSIOBENUpper Plausibility Limit QPLAUSIOBCCHAR16QSOLLWERTC
PLAUSIUNTELower Plausibility Limit QPLAUSIUNCCHAR16QSOLLWERTC
STICHPRVERSampling Procedure in Inspection Characteristic QSTICHVERFCHAR8QSTPRVER
STPRVTEXTShort Text for the Sampling Procedure QTXTSMPPROCHAR40QKURZTEXT
SOLLSTPUMFSample Size that Has to Be Inspected for a Characteristic QGESUMFINT410QANZAHL4
PRUEFUMFQuantity to Be Inspected QPRUEFUMFQUAN13(3) QMENGEPLOS
MENGENEINHBase Unit of Measure for the Sample Unit QPROBEMGEHUNIT3CUNITMEINS
HPZ100% Inspection QHPZCHAR1QKZ
KZATTRFEAttributive Inspection by Nonconforming Units QKZATTRFECHAR1QKZ
KZATTRFZAttributive Inspection by Number of Defects QKZATTRFZCHAR1QKZ
KZVARSVariable Inspection by S-Method QKZVARSCHAR1QKZ
KZCODValuation by Code QKZCODCHAR1QKZ
KZMANManual Valuation QKZMANCHAR1QKZ
KZUMFSMultiple Samples QKZUMFSCHAR1QKZUMFS
KZNULLInspection Against Specification Limits (k = 0) QKZKNULLCHAR1QKZ
ANNAHMEZAcceptance Number QANNAHMEZINT25QINT2NEG
RUECKWEZRejection Number QRUECKWEZINT25QANZAHL2
KFAKTORNIValue Not Initial if Set QNINITIALCHAR1QKZ
KFAKTORK-Factor for a Variable Inspection QKFAKTORCCHAR16QKFAKTORC
ATCODCode for value dependency ATCODCHAR1ATCOD
QCRES 0
LEVEL_RESULTLevel for Result Selection QKZESELCHAR1QKZESEL
PRUEFLOSInspection Lot Number QPLOSNUMC12QPLOSQLSQALS
TEILLOSPartial lot number QTLOSNUMC6QTLOSQTL
VORGLFNRCurrent Node Number from Order Counter APLZL QLFNKNNUMC8KNTNR
MERKNRInspection Characteristic Number QMERKNRPNUMC4QMERKNRP
PROBENRSample Number QPROBENRNUMC6QPROBENRQPO
DETAILERGNumber of the Individual Result QDETAILERGNUMC8QDETAILERG
MATNRMaterial Number MATNRCHAR18MATN1MATNRMATS_MAT1
CHARGBatch Number CHARG_DCHAR10CHARGCHA
MVALUECertificates: Output Field for Mean Value QCOUTMVALCHAR132TDSTXLLINE
ATTRIBUTE_QDIAttribute for Results Record (Greater, Smaller,..) QCATTRIBUTCHAR3QCATTRIBUT
VALUE1_QDIValue or Part of Value Range on Certificate QC_VALUECHAR16QSTATWERTC
VALUE2_QDIValue or Part of Value Range on Certificate QC_VALUECHAR16QSTATWERTC
KZSPECRelationship of Value to Specifications QCKZSPECCHAR2QCKZSPEC
STAT07Inspection with Inspection Points QKZFERTPRFCHAR1QKZ
SLWBEZIdentification for the Inspection Point Field Combination QSLWBEZCHAR3QSLWBEZQBK
STAT13Inspection Point Type QPPKTTYPCHAR1QPPKTTYP
PHYSPROBENumber of the Partial Sample QPHYSPROBENUMC6QPROBENR
STATUSRResults Record Status QBEASTATUSCHAR1QSTATUS
STATUSTEXTShort Text QKURZTEXTCHAR40QKURZTEXT
QUANTITATQuantitative Characteristic QKZQUNMKCHAR1QKZ
MESSWERTEMeasured Values Must Be Recorded QKZQUMKCHAR1QKZ
PRUEFKATReference to Characteristic Attribute Required QKZPKATCHAR1QKZ
TOLEROBENUpper Specification Limit QKZTOLOBCHAR1QKZ
TOLERUNTENLower Specification Limit QKZTOLUNCHAR1QKZ
SOLLPRUEFCheck Target Value QKZSOLLPRCHAR1QKZ
PUMFKZInspection Scope QPUMFKZCHAR1QPUMFKZ
LZEITKZLong-Term Inspection QLZEITKZCHAR1QKZ
ESTUKZRecording Type QESTUKZCHAR1QESTUKZ
DOKUKZDocumentation Required for Inspection Results QDOKUKZCHAR1QDOKUKZ
RZWANGCharacteristic Category QRZWANGCHAR1QRZWANG
SYNCROSynchronization is Active QSYNCROCHAR1QKZ
ZERSTPRFDestructive Inspection QKZDESTROYCHAR1QKZ
FORMELMKCalculated Characteristic QKZFORMELCHAR1QKZFORMEL
STICHPRSampling Procedure is Required QSTICHPRCHAR1QKZ
AUSSLOSCharacteristic Relevant for Qual. Score and Scrap Share QAUSSLOSCHAR1QKZ
BEWFHLZHLRecording the Number of Defects QBFHLZHLCHAR1QKZ
FEHLRECDefects Recording Automatically Called Up QFEHLRECCHAR1QKZ
AENDBELEGCreate Change Documents During Results Recording QKZAENBELCHAR1QKZ
WERKSPlant QWERKSCHAR4WERKS
MKMNRMaster Inspection Characteristics QMERKNRCHAR8ALPHAQMERKNRPMK
VERSIONVersion Number of the Master Inspection Characteristic QVERSNRMKCHAR6ALPHAQVERSNR
KURZTEXTShort Text for the Inspection Characteristic QMKKURZTXTCHAR40QKURZTEXT
ATNAMCharacteristic Name ATNAMCHAR30ATNAMFEA
ATWTBCharacteristic value description ATWTBCHAR30TEXT30
ATTRIBUTAttribute of the Results Record (Valid, Invalid,...) QATTRIBUTCHAR1QATTRIBUT
ATTRTEXTExplanatory short text DDTEXTCHAR60DDTEXT
QERGDATHOrigin of Results Data QERGDATHCHAR2QERGDATH
ERDATHETXTShort Text QKURZTEXTCHAR40QKURZTEXT
MBEWERTGInspection Result Valuation QMBEWERTGCHAR1QEEBEWERTG
MBEWTEXTExplanatory short text DDTEXTCHAR60DDTEXT
PRUEFBEMKTShort Text QKURZTEXTCHAR40QKURZTEXT
PRLTEXTKZInspection Characteristic Long Text Exists QLTEXTKZCHAR1QKZ
LTEXTSPRLanguage Key SPRASLANG1ISOLASPRASSPRH_T002
ANZFEHLEHNumber of Nonconforming Sample Units QANZFEHEH4INT410QANZAHL4
ANTEILEstimated Fraction of Nonconforming Units QANTEILCCHAR16QSOLLWERTC
ANZFEHLERNumber of Defects Found QANZFEHL4INT410QANZAHL4
ANZWERTONumber of Measured Values Above the Tolerance Range QANZWERTO4INT410QANZAHL4
ANZWERTUNumber of Measured Values Below the Tolerance Range QANZWERTU4INT410QANZAHL4
ANZWERTGNumber of Inspected Sample Units QANZWERTG4INT410QANZAHL4
STELLENNumber of Places to the Right of a Decimal Point (Accuracy) QSTELLENINT13QSTELLEN
MASSEINHSWUnit of Measurement MSEHIUNIT3CUNITMEINS
MAXWERTMaximum Value of the Valid Measured Values QMAXWERTCCHAR16QSTATWERTC
MINWERTMinimum Value of the Valid Measured Values QMINWERTCCHAR16QSTATWERTC
MITTELWERTArithmetic Mean of Valid Measured Values QMITTEWRTCCHAR16QSTATWERTC
VARIANZDispersion (Variance) of Valid Measured Values QVARIANZCCHAR16QSTATWERTC
MOMENT3Third Central Moment of Valid Measured Values QMOMENT3CCHAR16QSTATWERTC
MOMENT4Fourth Central Moment of Valid Measured Values QMOMENT4CCHAR16QSTATWERTC
ANTEILOEstimated Fraction Above the Tolerance Range QANTEILOCCHAR16QSTATWERTC
ANTEILUEstimated Fraction Below the Tolerance Range QANTEILUCCHAR16QSTATWERTC
IVARIANZInternal Dispersion of Valid Measured Values QIVARIANZCCHAR16QSTATWERTC
GRUPPE1Code Group QCODEGRPCHAR8QCODEGRPCGP
CODE1Code QCODECHAR4QCODEQCODE
CODEKTXT1Short Text for Code (Up to 40 Characters in Length) QTXT_CODECHAR40QKURZTEXT
STDABWStandard Deviation of Valid Measured Values QSTDAWCCHAR16QSTATWERTC
SPANNWEITERange of Valid Measured Values QSPANNWEICCHAR16QSTATWERTC
FEHLKLASDefect Class QFEHLKLASCHAR2QFEHLKLAS
FEHLKLTEXTShort Text QKURZTEXTCHAR40QKURZTEXT
PPSORTKEYKey Field (Sort Field) for Inspection Point QPPSORTKEYCHAR70QPPSORT
EQUNREquipment Number EQUNRCHAR18ALPHAEQUNREQNEQUI
TPLNRFunctional Location TPLNRCHAR30TPLNRTPLNRIFLIFLM
PHYNRPhysical Sample Number QPHYSPRNRCHAR12ALPHAQPHYSPRNRQPN
STUECKNRCounter for Inspection Unit Number QSTUECKNRNUMC4QZAEHL
SERIALNRSingle-Unit Number for the Unit to Be Inspected QPRUEFLINRCHAR18ALPHAQSERIALNRQPRFNR
MASCHINEGeneral Information QMASCHINECHAR18ALPHAQEQUNR
INSP_POSITIONTest Position QPRPOSNUMC4QPRPOS
GRPTXT1Short Text for Code Group QGRPTEXTCHAR40QKURZTEXT
UNIT_CHARACTMeasurement Unit in Which Quantitative Data Is Maintained QMGEH6CHAR6LUNITMSEC6
UNIT_CHARACT_10Unit of Measurement Text (Maximum 10 Characters) MSEHTCHAR10TEXT10
UNIT_CHARACT_30Unit of Measurement Text (Maximum 30 Characters) MSEHLCHAR30TEXT30
QCTEXT 0
SHORT_TEXTCertificates: Output Field for Characteristic Short Text QCSHORTTXCHAR132TDSTXLLINE
CHAR_COUNTCharacter Field Length = 10 CHAR10CHAR10CHAR10
LOT_COUNTCharacter Field Length = 10 CHAR10CHAR10CHAR10
BATCH_COUNTCharacter Field Length = 10 CHAR10CHAR10CHAR10
LONG_TEXTCharacter 100 CHAR100CHAR100CHAR100

Key field Non-key field



How do I retrieve data from SAP structure QCERT_TS_CHARACT_PDF using ABAP code?

As QCERT_TS_CHARACT_PDF is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on QCERT_TS_CHARACT_PDF as there is no data to select.

How to access SAP table QCERT_TS_CHARACT_PDF

Within an ECC or HANA version of SAP you can also view further information about QCERT_TS_CHARACT_PDF and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!