I_QualityInfoRecdInProcmt

Products with or without Quality Info Records In Procurement | view: IQLTYINFORECPROC | TRAN | Extraction: Not supported | Component: Quality Planning
Tables used: QINF, MARA, TQ08, LFA1, MARC
Column Name Description
Material FK Material Number
QltyInProcmtIntID Quality Info Record in Procurement Internal ID
Column Name Description
Column Name Description
📏 Base Unit of Measure for the Material (BaseUnit):
ReleasedQuantity Quantity Released for the Material
OrderedQuantity Quantity Ordered for the Material
Column Name Description
QltyInProcmtReleaseValidTo Date Until Which the Release Is Valid
QltyInProcmtResetOnDate Date when the Ordered Quantity Was Reset
QltyInProcmtCertfnValidTo Validity Date of Certification
SuplrQltyInProcmtCertfnValidTo Validity Date of Certification
CreationDate Create Date of Q-Info Record
LastChangeDate Change Date of Q-Info Record
Column Name Description
QltyInProcmtRelQtyIsActive Release Quantity Is Active Show values
QltyInProcmtInspControl Inspection Control in the QM Info Record Show values
QltyInProcmtHasLongText Inspection Characteristic Long Text Exists Show values
QltyInProcmtNoFurtherInsp Source Inspection Instead of Goods Receipt Inspection Show values
IsDeleted Deletion Flag Show values
QltyInProcmtCertificateCtrl Control of Certificate Receipt Show values
QltyInProcmtHasAssuranceAgrmt Quality Assurance Agreement Exists Show values
HasNoQltyInfoRec Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') Show values
MaterialHasQualityInfoRecord With Quality Info Records Show values
ProdnPieceApprovalIsRequired Production Part Approval Is Required Show values
ProductionPieceApprovalLevel Production Part Approval for Part Submission Warrant Show values
ProductionPieceApprovalStatus Production Part Approval Status Show values
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
Column Name Description Domain name
MaterialRevisionLevel Revision Level REVLV
BlockReason Blocking Reason QKURZTEXT
QltyInProcmtLotCrtnLeadTime Lot Creation Lead Time (in Days) for Source Inspection QANZAHL1
CreatedByUser Name of User who Created the Q-Info Record QAENDERER
LastChangedByUser Name of User who Most Recently Changed the Q-Info Record QAENDERER
ChangedDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
LinkedSAPObjectKey null
DocumentInfoRecordDocType Document Type for QM Documents DOKAR
ProductionPieceApproval Production Part Approval Identifier
AuthorizationGroup Authorization Group BRGRU
Master Data Relations Join Conditions
Base Unit of Measure for the Material
  • Base Unit of Measure for the Material
  • Client
  • I_QUALITYINFORECDINPROCMT.BASEUNIT == T006.MSEHI
  • I_QUALITYINFORECDINPROCMT.MANDT == T006.MANDT
Inspection Type for Insp. Lot Origin (Source Inspection)
  • Inspection Type for Insp. Lot Origin (Source Inspection)
  • Client
  • I_QUALITYINFORECDINPROCMT.INSPECTIONLOTTYPE == TQ30.ART
  • I_QUALITYINFORECDINPROCMT.MANDT == TQ30.MANDT
Language Key I_QUALITYINFORECDINPROCMT.LANGUAGE == T002.SPRAS
Material Number
  • Material Number
  • Client
  • I_QUALITYINFORECDINPROCMT.MATERIAL == MARA.MATNR
  • I_QUALITYINFORECDINPROCMT.MANDT == MARA.MANDT
Material Authorization Group for Activities in QM
  • Material Authorization Group for Activities in QM
  • Client
  • I_QUALITYINFORECDINPROCMT.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH
  • I_QUALITYINFORECDINPROCMT.MANDT == TQ01B.MANDT
Plant
  • Plant
  • Client
  • I_QUALITYINFORECDINPROCMT.PLANT == T001W.WERKS
  • I_QUALITYINFORECDINPROCMT.MANDT == T001W.MANDT
Function That Will Be Blocked
  • Client
  • Function That Will Be Blocked
  • I_QUALITYINFORECDINPROCMT.MANDT == TQ04A.MANDT
  • I_QUALITYINFORECDINPROCMT.PROCUREMENTBLOCK == TQ04A.SPERRFKT
Supplier's QM System
  • Supplier's QM System
  • Client
  • I_QUALITYINFORECDINPROCMT.QUALITYMANAGEMENTSYSTEM == TQ02B.QSSYSFAM
  • I_QUALITYINFORECDINPROCMT.MANDT == TQ02B.MANDT
Control key for QM in procurement
  • Control Key for Quality Management in Procurement
  • Client
  • I_QUALITYINFORECDINPROCMT.QUALITYMGMTCTRLKEY == TQ08.QM_PUR
  • I_QUALITYINFORECDINPROCMT.MANDT == TQ08.MANDT
Status Profile Assigned to Quality Info Record
  • Status Profile Assigned to Quality Info Record
  • Client
  • I_QUALITYINFORECDINPROCMT.STATUSPROFILE == TJ20.STSMA
  • I_QUALITYINFORECDINPROCMT.MANDT == TJ20.MANDT
Supplier's QM System
  • Supplier's QM System
  • Client
  • I_QUALITYINFORECDINPROCMT.SUPLRQUALITYMANAGEMENTSYSTEM == TQ02B.QSSYSFAM
  • I_QUALITYINFORECDINPROCMT.MANDT == TQ02B.MANDT
Vendor's account number
  • Vendor's account number
  • Client
  • I_QUALITYINFORECDINPROCMT.SUPPLIER == LFA1.LIFNR
  • I_QUALITYINFORECDINPROCMT.MANDT == LFA1.MANDT
Function That Will Be Blocked
  • Client
  • Function That Will Be Blocked
  • I_QUALITYINFORECDINPROCMT.MANDT == TQ04A.MANDT
  • I_QUALITYINFORECDINPROCMT.SUPPLIERPROCUREMENTBLOCK == TQ04A.SPERRFKT