SAP Table QAICA

Inspection catalog data for download to QM subsystem

QAICA (Inspection catalog data for download to QM subsystem) 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 QAICA to other SAP tables.

Source: QAICA (Inspection catalog data for download to QM subsystem)

QAICA table fields

Field

Data element

Checktable

Datatype

Length

Decimals

SATZART

Record Types for QM Interface - Subsystems

QEIFART

CHAR

Possible values

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

QKTTAB

CHAR

KATALGART

Catalog Type of Assigned Code Group or Selected Set

QKATAUSW

TQ15

CHAR

AUSWMGWRK

Plant of the Assigned Selected Set

QWERKAUSW

T001W

CHAR

AUSWMENGE

Assigned Code Group or Selected Set

QCGRAUSW

CHAR

CODEGRUPPE

Code Group

QCODEGRP

QPGR

CHAR

CODE

Code

QCODE

QPCD

CHAR

KURZTEXT

Short Text for Code (up to 40 Characters in Length)

QEIFCDKTXT

CHAR

BEWERTUNG

Code Valuation

QBEWERTUNG

CHAR

Possible values

NULL	Not valuated
A	Accepted (OK)
R	Rejected (not OK)

FEHLKLASSE

Defect Class

QFEHLKLAS

TQ17

CHAR

MUSSTEXTKZ

Text Must Be Entered when Results Are Confirmed

QMUSSTKZ

CHAR

Possible values

NULL	Indicator is not set
X	Indicator is set

BB_VORSCH

Stock Posting Proposal

Q_BB_VOR

CHAR

Possible values

NULL	Indicator is not set
X	Indicator is set

QKENNZAHL

Quality score for transferring UD codes via QM-IDI

QEIFQKZ

NUMC

QAICA foreign key relationships

Table	Field	Foreign key table	Foreign key field	Check table		Check field
QAICA	AUSWMGWRK	SYST	MANDT	T001W	Plants/Branches	MANDT
QAICA	AUSWMGWRK	QAICA	AUSWMGWRK	T001W	Plants/Branches	WERKS
QAICA	CODE	SYST	MANDT	QPCD	Inspection catalog codes	MANDT
QAICA	CODE	QAICA	KATALGART	QPCD	Inspection catalog codes	KATALOGART
QAICA	CODE	QAICA	CODEGRUPPE	QPCD	Inspection catalog codes	CODEGRUPPE
QAICA	CODE	QAICA	CODE	QPCD	Inspection catalog codes	CODE
QAICA	CODE	*		QPCD	Inspection catalog codes	VERSION
QAICA	CODEGRUPPE	SYST	MANDT	QPGR	Inspection catalog code groups	MANDT
QAICA	CODEGRUPPE	QAICA	KATALGART	QPGR	Inspection catalog code groups	KATALOGART
QAICA	CODEGRUPPE	QAICA	CODEGRUPPE	QPGR	Inspection catalog code groups	CODEGRUPPE
QAICA	FEHLKLASSE	SYST	MANDT	TQ17	Defect classes	MANDT
QAICA	FEHLKLASSE	QAICA	FEHLKLASSE	TQ17	Defect classes	FEHLKLASSE
QAICA	KATALGART	SYST	MANDT	TQ15	Inspection catalog type index	MANDT
QAICA	KATALGART	QAICA	KATALGART	TQ15	Inspection catalog type index	KATALOGART