QINF

QM-Info Record for Material and Supplier | #transactional | #language | Component: QM Control in Procurement
Column Name Description
MANDT FK Client
MATNR FK Material Number
ZAEHL Internal Counter for DB Objects
Column Name Description
Column Name Description
📏 Base Unit of Measure for the Material (ME):
FREI_MNG Quantity Released for the Material
BEST_MG Quantity Ordered for the Material
Column Name Description
ERSTELLDAT Create Date of Q-Info Record
AENDERDAT Change Date of Q-Info Record
FREI_DAT Date Until Which the Release Is Valid
DAT_RUECK Date when the Ordered Quantity Was Reset
QSSYSDAT Validity Date of Certification
Column Name Description
FREI_MGKZ Release Quantity Is Active Show values
QVVORH Quality Assurance Agreement Exists Show values
NOINSP Inspection Control in the QM Info Record Show values
LTEXTKZ Inspection Characteristic Long Text Exists Show values
PPAP_IS_REQUIRED Production Part Approval Is Required Show values
PPAP_LEVEL Production Part Approval for Part Submission Warrant Show values
PPAP_STATUS Production Part Approval Status Show values
NOINSPABN No GR Inspection if Source Inspection Lot Exists Show values
LOEKZ Deletion Flag Show values
CERTCONTROL Control of Certificate Receipt Show values
Column Name Description Domain name
ERSTELLER Name of User who Created the Q-Info Record QAENDERER
AENDERER Name of User who Most Recently Changed the Q-Info Record QAENDERER
CHANGEDDATETIME UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
SPERRGRUND Blocking Reason QKURZTEXT
PPAP_ID Production Part Approval Identifier
VORLABN Lot Creation Lead Time (in Days) for Source Inspection QANZAHL1
REVLV Revision Level REVLV
DUMMY_QINF_INCL_EEW_PS Dummy function in length 1 DUMMY
Master Data Relations Join Conditions
Vendor's account number
  • QINF.MANDT == LFA1.MANDT
  • QINF.LIEFERANT == LFA1.LIFNR
Client QINF.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • QINF.MATNR == MARA.MATNR
  • QINF.MANDT == MARA.MANDT
Base Unit of Measure for the Material
  • QINF.MANDT == T006.MANDT
  • QINF.ME == T006.MSEHI
Supplier's QM System
  • QINF.MANDT == TQ02B.MANDT
  • QINF.QSSYSFAM == TQ02B.QSSYSFAM
Function That Will Be Blocked
  • QINF.MANDT == TQ04A.MANDT
  • QINF.SPERRFKT == TQ04A.SPERRFKT
Language Key QINF.SPRACHE == T002.SPRAS
Language Key QINF.SPRAS == T002.SPRAS
Status Profile Assigned to Quality Info Record
  • QINF.MANDT == TJ20.MANDT
  • QINF.STSMA == TJ20.STSMA
Inspection Type for Insp. Lot Origin (Source Inspection)
  • QINF.MANDT == TQ30.MANDT
  • QINF.VARIABNAHM == TQ30.ART
Plant
  • QINF.MANDT == T001W.MANDT
  • QINF.WERK == T001W.WERKS