SAP Table RMXTS_OTPT_TRCO_QMS

QM Results (Stability Study)

RMXTS_OTPT_TRCO_QMS (QM Results (Stability Study)) 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 RMXTS_OTPT_TRCO_QMS to other SAP tables.

RMXTS_OTPT_TRCO_QMS table fields

Field Data element Checktable Datatype Length Decimals
GEN_COL_KEY Generic Column Key RMXTE_OTPT__GEN_COLKEY INT4 10 0
TRIALID Trial Number RMXTE_OTPT_TRIALID CHAR 13 0
TRIALNAME Trial Name RMXTE_TRIALNAME CHAR 60 0
QMNUM Notification No QMNUM CHAR 12 0
STABICON Storage Condition QSTABICON CHAR 8 0
STABICONTXT Description of Storage Condition QSTABICONTXT CHAR 120 0
EINGDT Date of Receipt of Initial Sample for Stability Study QST_EINGDT DATS 8 0
EINLDT Storage Date of Sample for Storage Condition QST_EINLDT DATS 8 0
AUSLDT Date of Removal from Storage of Sample for Storage Condition QST_AUSLDT DATS 8 0
INSPLOT Inspection Lot Number QIBPLOSNR NUMC 12 0
HERKUNFT Inspection Lot Origin QHERK CHAR 2 0
INSPOPER Inspection Lot Operation Number QIBPVORNR CHAR 4 0
TXT_OPER Operation Short Text RMXTE_OTPT_QKURZTEXT CHAR 40 0
INSPCHAR Insp. Lot Charac. No. QIBPMERKNR NUMC 4 0
CHAR_DESCR Inspection Characteristic Description RMXTE_OTPT_QMKKURZTXT CHAR 40 0
INSPSAMPLE Insp. Lot Sample QIBPPROBE NUMC 6 0
LAST_SMPL Last Original Value, Sample or Inspection Point QEIFKZENDE CHAR 1 0
NULL Indicator is not set
X Indicator is set
CLOSED Close Characteristic or Sample QEIFABSCHL CHAR 1 0
NULL Indicator is not set
X Indicator is set
EVALUATED Copy Valuation from External System QEIFBEWE CHAR 1 0
NULL Indicator is not set
X Indicator is set
SMPL_ATTR Attribute of the Results Record (Valid, Invalid,...) QATTRIBUT CHAR 1 0
NULL Result is valid (default)
< The true value is less or equal to; valid result
> The true value is greater or equal to; valid result
? The result was estimated; valid result
* Result considerede an outlier; valid result
/ Invalid result
( Customer attribute '('; valid result
) Customer attribute '('; invalid result
[ Customer attribute '['; valid result
] Customer attribute '['; invalid result
{ Customer attribute '{'; valid result
} Customer attribute '}'; invalid result
~ Result not proven; valid result
# Result not determinable; valid result
U Customer attribute 'U'; valid result
V Customer attribute 'V'; valid result
W Customer attribute 'W'; valid result
X Customer attribute 'X'; invalid result
Y Customer attribute 'Y'; invalid result
Z Customer attribute 'Z'; invalid result
A Formula: Calculation input characteristic is inappropriate
B Formula: Calculation input characteristic does not exist
C Formula: Syntax error
D Formula: Calculation input charac. has an incorrect format
E Formula: Error during values' trans. for calc. input charac.
F Formula: Arithmetic error during formula calculation
G Formula: Not all single results were calculated
H Formula: Error when calculating single units
& Error occurred during results transfer
\ Result is not current; invalid result
SMPL_INVAL Invalid Result QRES_INVAL CHAR 1 0
EVALUATION Inspection Result Valuation QMBEWERTG CHAR 1 0
NULL No valuation
A Accepted
R Rejected
F Failed
ERR_CLASS Defect Class QFEHLKLAS CHAR 2 0
VALID_VALS No. of Valid Values for Char. Results Upload to QM Subsys. QEIFAWERTG CHAR 7 0
NONCONF No. of Nonconforming Units for Char. Confirmation via QM-IDI QEIFAFEEH CHAR 7 0
DEFECTS Number of Defects for Confirmation of Charac. via QM-IDI QEIFAFEHL CHAR 7 0
VALS_ABOVE Number of Values Below the Tolerance Limit (Characteristic) QEIFAWRTU CHAR 7 0
VALS_BELOW Number of Values Above the Tolerance Limit (Characteristic) QEIFAWRTO CHAR 7 0
MEAN_VALUE Mean Value QMEAN_VAL CHAR 22 0
VARIANCE Variance QVARIANCE CHAR 22 0
MAXIMUM Maximum QMAX_VAL CHAR 22 0
MINIMUM Minimum QMIN_VAL CHAR 22 0
START_DATE Inspection Start Date (QM Subsystem Interface) QEIFPRDATV DATS 8 0
START_TIME Inspection Start Time (QM Subsystem Interface) QEIFPRZTV TIMS 6 0
END_DATE Inspection End Date (QM Subsystem Interface) QEIFPRDATB DATS 8 0
END_TIME Inspection End Time (QM Subsystem Interface) QEIFPRZTB TIMS 6 0
INSPECTOR Name of the Inspector QINSPECTOR CHAR 20 0
RES_ORG Data Origin QRES_ORG CHAR 2 0
REMARK Inspection Description for Single Value QRES_REMAR CHAR 40 0
CODE1 Code QCODE CHAR 4 0
CODE_GRP1 Code Group QCODE_GROU CHAR 8 0
CODE2 Code QCODE CHAR 4 0
CODE_GRP2 Code Group QCODE_GROU CHAR 8 0
CODE3 Code QCODE CHAR 4 0
CODE_GRP3 Code Group QCODE_GROU CHAR 8 0
CODE4 Code QCODE CHAR 4 0
CODE_GRP4 Code Group QCODE_GROU CHAR 8 0
CODE5 Code QCODE CHAR 4 0
CODE_GRP5 Code Group QCODE_GROU CHAR 8 0
ORIGINAL_INPUT Original Value Before Input Processing QORIGINAL_INPUT CHAR 25 0
INPPROC_READY Input Processing Successfully Completed QINPPROC_READY CHAR 1 0
NULL Indicator is not set
X Indicator is set
DIFF_DEC_PLACES Different Number of Decimal Places QDIFF_DEC_PLACES INT2 5 0
METHOD Inspection Method QPMETHODE CHAR 8 0
METHOD_TXT Short Text for Inspection Method RMXTE_OTPT_QEIFPMTTXT CHAR 40 0
MEAS_UNIT Unit of Measurement (Internal Code) QMEAS_UNIT CHAR 6 0
MEAS_UNITT Short Text for Unit of Measure QMEASUNITT CHAR 20 0
MSEHT Unit of Measurement Text (Maximum 10 Characters) MSEHT CHAR 10 0
TARGET_VAL Target Value QTARGET_VA CHAR 22 0
UP_TOL_LMT Upper Tolerance Limit QUPTOL_LMT CHAR 22 0
LW_TOL_LMT Lower Tolerance Limit QLWTOL_LMT CHAR 22 0
CODE_TXT1 Short Text for Code (Up to 40 Characters in Length) QTXT_CODE CHAR 40 0
CODE_TXT2 Short Text for Code (Up to 40 Characters in Length) QTXT_CODE CHAR 40 0
CODE_TXT3 Short Text for Code (Up to 40 Characters in Length) QTXT_CODE CHAR 40 0
CODE_TXT4 Short Text for Code (Up to 40 Characters in Length) QTXT_CODE CHAR 40 0
CODE_TXT5 Short Text for Code (Up to 40 Characters in Length) QTXT_CODE CHAR 40 0
PHYNR Physical Sample Number QPHYSPRNR CHAR 12 0
PRARTKTXT Short Text QKURZTEXT CHAR 40 0
KTEXTLOS Inspection Lot in Trial Management RMXTE_KTEXTLOS CHAR 40 0