SAP table QAICA (Inspection catalog data for download to QM subsystem)

SAP table QAICA has 7 primary key fields being SATZART,KATAB,KATALGART,AUSWMGWRK,AUSWMENGE,CODEGRUPPE,CODE.

Field Description Data Type Length Decimals Checktable Data Element
SATZART Record Types for QM Interface - Subsystems CHAR 3 0 QEIFART
Q40 Inspection lot requirements
Q41 Req. for insp. lot header record
Q42 Char. specifications for subsystem
Q45 Download inspection catalog entries
Q48 Status changes in insp. lot
Q51 Quantative original value record for single unit
Q52 Qualitative orig. value rec. for sing. unit with char. code
Q53 Qualitative orig. value rec. for sing. unit with valuation_
Q54 Quantative original value record for inspection point_
Q55 Qualitative orig. value rec. with char. code for insp. point
Q56 Qualitative orig. value rec. with valuation for insp. point
Q58 Cancel single unit record
Q61 Quantative sample record
Q62 Qualitative sample record with characteristic code
Q63 Qualitative sample record with valuation
Q64 Quantative sample record for inspection point
Q65 Qualitative sample record with char. code for insp. point
Q66 Qualitative sample rec. with valuation for insp. point
Q68 Cancel sample record
Q69 Close sample record
Q71 Quantitative characteristic record
Q72 Qualitative characteristic set with char. code
Q73 Qualitative characteristic set with valuation
Q79 Close character.
Q83 Confirmation for inspection point
Q84 Valuation for inspection point
Q88 Usage Decision for Inspection Lot
Q89 Inspection cancelled for inspection lot
Q90 Insp.lot defects
Q91 Operation defects
Q92 Characteristic / sample defects
Q95 Operation defects with reference to an inspection point
Q96 Characteristic defects with reference to an inspection point
KATAB Catalog Entry Is a Selected Set CHAR 1 0 QKTTAB
KATALGART Catalog Type of Assigned Code Group or Selected Set CHAR 1 0 TQ15 QKATAUSW
AUSWMGWRK Plant of the Assigned Selected Set CHAR 4 0 T001W QWERKAUSW
AUSWMENGE Assigned Code Group or Selected Set CHAR 8 0 QCGRAUSW
CODEGRUPPE Code Group CHAR 8 0 QPGR QCODEGRP
CODE Code CHAR 4 0 QPCD QCODE
KURZTEXT Short Text for Code (up to 40 Characters in Length) CHAR 40 0 QEIFCDKTXT
BEWERTUNG Code Valuation CHAR 1 0 QBEWERTUNG
Not valuated
A Accepted (OK)
R Rejected (not OK)
FEHLKLASSE Defect Class CHAR 2 0 TQ17 QFEHLKLAS
MUSSTEXTKZ Text Must Be Entered when Results Are Confirmed CHAR 1 0 QMUSSTKZ
BB_VORSCH Stock Posting Proposal CHAR 1 0 Q_BB_VOR
QKENNZAHL Quality score for transferring UD codes via QM-IDI NUMC 3 0 QEIFQKZ

QAICA foreign key relationships

Table Field Check Table Check Field
0 QAICA AUSWMGWRK T001W Plants/Branches MANDT
0 QAICA AUSWMGWRK T001W Plants/Branches WERKS
1 QAICA CODE QPCD Inspection catalog codes MANDT
1 QAICA CODE QPCD Inspection catalog codes KATALOGART
1 QAICA CODE QPCD Inspection catalog codes CODEGRUPPE
1 QAICA CODE QPCD Inspection catalog codes CODE
1 QAICA CODE QPCD Inspection catalog codes VERSION
0 QAICA CODEGRUPPE QPGR Inspection catalog code groups MANDT
0 QAICA CODEGRUPPE QPGR Inspection catalog code groups KATALOGART
1 QAICA FEHLKLASSE TQ17 Defect classes MANDT
0 QAICA KATALGART TQ15 Inspection catalog type index KATALOGART