Model / QM / QINF

QM — Quality Management

QINF

34 fields · 4 key · 13 foreign keys · sourced from leanx.eu

Quality info record — material/vendor-level quality agreement: release status, vendor QM system, source inspection control.

Hover a canonical name to see the legacy SAP field name

Canonical nameConceptDescriptionData elementTypeCheck table
CLI keycliensClientMANDTCLNT 3T000
MAT_NUM keymateria numerusMaterial NumberMATNRCHAR 18MARA
NMR keynumeratorInternal Counter for DB ObjectsQ_COUNTNUMC 6
NOM_USR_CREnomen usor creatusName of User who Created the Q-Info RecordQINFERSTCHAR 12
DIE_TINdies tabula informationisCreate Date of Q-Info RecordQINFERSTDTDATS 8
NOM_USR_MUTnomen usor mutatusName of User who Most Recently Changed the Q-Info RecordQINFAENDCHAR 12
DIE_TIN2dies tabula informationisChange Date of Q-Info RecordQINFAENDDTDATS 8
VEN_RAT_NUM keyvenditor ratio numerusVendor Account NumberELIFNCHAR 10LFA1
OFCofficinaPlantWERKS_DCHAR 4T001W
DIE_EMSdies emissioDate Until Which the Release Is ValidQFREIDATDATS 8
EMS_QNTemissio quantitasRelease Quantity Is ActiveQFREIMGKZCHAR 1
MEN_MATmensura materiaBase Unit of Measure for the MaterialQBSTMEUNIT 3T006
QNT_MATquantitas materiaQuantity Released for the MaterialQFREIMGQUAN 13,3
QNT_MAT2quantitas materiaQuantity Ordered for the MaterialQBSTMGQUAN 13,3
DIE_QNTdies quantitasDate when the Ordered Quantity Was ResetQRSDATDATS 8
CSAcausaBlocking reasonQSPERRGRCHAR 40
LNG_CLVlingua clavisLanguage KeySPRASLANG 1T002
SPERRFKTFunction That Will Be BlockedQSPERRFKTCHAR 2TQ04A
QVVORHQuality Assurance Agreement ExistsQQSVVORHCHAR 1
ISP_TINinspectio tabula informationisInspection Control in the QM Info RecordQNOINSPCHAR 1
VENvenditorVendor's QM systemQSSYS_ISTCHAR 4TQ02B
DIEdiesValidity date of certificationQQSSYSDATDATS 8
ISP_GEN_ORGinspectio genus origoInspection Type for Insp. Lot Origin (Source Inspection)QINFVAR1CHAR 8TQ30
NIS_TXTnota inspectionis textusInspection Characteristic Long Text ExistsQLTEXTKZCHAR 1
LNG_CLV2lingua clavisLanguage KeySPRASLANG 1T002
ISP_STAinspectio statusInspection Lot No. in QINF for Current StatusQPLOSQINFNUMC 12QALS
ISP_STA2inspectio statusInspection Lot No. in QINF for Next StatusQPLOSQINF2NUMC 12QALS
STA_TINstatus tabula informationisStatus Profile Assigned to Quality Info RecordQSTSMAQINFCHAR 8TJ20
OBI_NUM_STAobiectum numerus statusQINF Object Number in Status ManagementQINFOBJNRCHAR 22ONR00
ISP_FNSinspectio fonsNo GR Inspection if Source Inspection Lot ExistsQNOWEABNCHAR 1
TMP_FNS_ISPtempus fons inspectioLot Creation Lead Time (in Days) for Source InspectionQVORLABNINT1 3
GRDgradusRevision LevelREVLVCHAR 2
SGNsignumDeletion FlagQLOEKZCHAR 1
CERTCONTROLControl of Certificate ReceiptQCERTCONTROLCHAR 1

Foreign keys

FieldCheck tableCheck field
LIEFERANTLFA1LIFNR
MATNRMARAMATNR
MET006MSEHI
OBJNRONR00OBJNR
PLOSQALSPRUEFLOS
PLOS2QALSPRUEFLOS
QSSYSFAMTQ02BQSSYSFAM
SPERRFKTTQ04ASPERRFKT
SPRACHET002SPRAS
SPRAST002SPRAS
STSMATJ20STSMA
VARIABNAHMTQ30ART
WERKT001WWERKS

View QINF.yaml in the repository