QAIVC_O1 SAP (Insp. Lot Operation Header Data for Download to QM Subsystem) Structure details
Description: Insp. Lot Operation Header Data for Download to QM Subsystem
Structure field list including key, data, relationships and ABAP select examples
QAIVC_O1 is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Insp. Lot Operation Header Data for Download to QM Subsystem" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_QAIVC_O1 TYPE QAIVC_O1.
The QAIVC_O1 table consists of various fields, each holding specific information or linking keys about Insp. Lot Operation Header Data for Download to QM Subsystem data available in SAP. These include PRUEFLOS (Inspection Lot Number), PLNFL (Sequence), VORNR (Operation/Activity Number), WERK (Plant).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)
SAP QAIVC_O1 structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
SATZART | Record Types for QM Interface - Subsystems | QEIFART | CHAR | 3 | QEIFART | ||||
PRUEFLOS | Inspection Lot Number | QPLOS | NUMC | 12 | QALS | QPLOS | QLS | QALS | |
PLNFL | Sequence | PLNFOLGE | CHAR | 6 | ALPHA | PLNFOLGE | |||
VORNR | Operation/Activity Number | VORNR | CHAR | 4 | NUMCV | VORNR | VGN | ||
WERK | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
ART | Inspection Type | QPART | CHAR | 8 | TQ30 | QPART | QLA | ||
HERKUNFT | Inspection Lot Origin | QHERK | CHAR | 2 | Assigned to domain | QHERK | QHK | ||
ENTSTEHDAT | Date Inspection Lot Was Created for QM Subsystem Interface | QEIFENTST | DATS | 8 | DATUM | ||||
ERSTELLER | Name of User Who Created the Data Record | QERSTELLER | CHAR | 12 | QAENDERER | ||||
AENDERER | Name of User who Most Recently Changed the Data Record | QAENDERER | CHAR | 12 | QAENDERER | ||||
AENDERDAT | Date Inspection Lot Was Last Changed | QEIFAEDAT | DATS | 8 | DATUM | ||||
KZVESUBSYS | Indicator: Should Usage Decision Be Made in Subsystem | QEIFVESUBS | CHAR | 1 | QKZ | ||||
VKATART | Catalog | QKATART | CHAR | 1 | TQ15 | QKATART | QKT | ||
VWERKS | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
VAUSWAHLMG | Selected Set of the Usage Decision | QVMENGE | CHAR | 8 | QPAM | QAUSWAHLMG | |||
PLNTY | Task List Type | PLNTY | CHAR | 1 | TCA01 | PLNTY | PTY | H_TCA01 | |
PLNNR | Key for Task List Group | PLNNR | CHAR | 8 | ALPHA | PLNNR | PLN | PLKS | |
PPLVERW | Task list usage | PLN_VERWE | CHAR | 3 | T411 | PLN_VERWE | H_T411 | ||
PLNAL | Group Counter | PLNAL | CHAR | 2 | ALPHA | ALTNR | PAL | ||
ZAEHL | Continuous Counter for Differentiating Database Entries | QEIFZAEHL | NUMC | 8 | CIM_COUNT | ||||
PLANKTEXT | Task list description | PLANTEXT | CHAR | 40 | TEXT40 | ||||
DATUV | Valid-From Date for Insp. Plan Header (QM Subsys. Interface) | QEIFDATUV | DATS | 8 | DATUM | ||||
PASTRTERM | Inspection Start Date (QM Subsystem Interface) | QEIFSTARTP | DATS | 8 | DATUM | ||||
PAENDTERM | End of Inspection Date (QM Subsystem Interface) | QEIFENDPR | DATS | 8 | DATUM | ||||
KUNNR | Account Number of Customer | EKUNN | CHAR | 10 | KNA1 | ALPHA | KUNNR | KUN | |
NAME1KUN | Name of Customer for QM Subsystem Interface | QEIFNAM1KU | CHAR | 35 | NAME | ||||
LIFNR | Vendor Account Number | ELIFN | CHAR | 10 | LFA1 | ALPHA | LIFNR | LIF | KRED_C |
NAME1LIF | Name of Vendor for QM Subsystem Interface | QEIFNAM1LI | CHAR | 35 | NAME | ||||
HERSTELLER | Number of Manufacturer | QLIFNR | CHAR | 10 | LFA1 | ALPHA | LIFNR | LIF | |
NAME1HER | Name of Manufacturer for QM Subsystem Interface | QEIFNAM1HE | CHAR | 35 | NAME | ||||
MATNR | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
KTEXTMAT | Material short text | QKTEXTMAT | CHAR | 40 | QKURZTEXT | ||||
KTEXTLOS | Short Text | QKURZTEXT | CHAR | 40 | QKURZTEXT | ||||
CHARG | Batch Number | CHARG_D | CHAR | 10 | MCH1 | CHARG | CHA | ||
LAGORTCHRG | Storage Location | LGORT_D | CHAR | 4 | T001L | LGORT | LAG | ||
LICHN | Vendor Batch Number | LICHN | CHAR | 15 | LICHN | ||||
IDNLF | Material number used by vendor | IDNLF22 | CHAR | 22 | IDNEX22 | ||||
KDMAT | Material belonging to the customer | KDMAT22 | CHAR | 22 | IDNEX22 | ||||
POSTX | Customer description of material | KDPTX | CHAR | 40 | TEXT40 | ||||
WERKVORG | Plant Where Stock for Inspection Lot Is Held | QWERKVORG | CHAR | 4 | T001W | WERKS | |||
LAGORTVORG | Storage Location for Inspection Lot Stock | QLGORTVORG | CHAR | 4 | T001L | LGORT | |||
LOSMENGE | Lot Quantity as Character String for QM Subsystem Interface | QEIFLOSMG | CHAR | 17 | CHAR17 | ||||
MENGENEINH | Base Unit of Measure for the Inspection Lot | QEIFMASS | UNIT | 3 | T006 | CUNIT | MEINS | ||
GESSTICHPR | Sample Size for Interface Between QM and Subsystem | QEIFGSTICH | CHAR | 17 | CHAR17 | ||||
EINHPROBE | Sample Unit of Measure | QEIFMASSPR | UNIT | 3 | T006 | CUNIT | MEINS | ||
EBELN | Purchasing Document Number | EBELN | CHAR | 10 | EKKO | ALPHA | EBELN | BES | MEKK_C |
EBELP | Item Number of Purchasing Document | EBELP | NUMC | 5 | EKPO | EBELP | BSP | ||
MJAHR | Material Document Year | MJAHR | NUMC | 4 | GJAHR | GJAHR | MJA | ||
MBLNR | Number of Material Document | MBLNR | CHAR | 10 | ALPHA | BELNR | MBN | ||
ZEILE | Item in Material Document | MBLPO | NUMC | 4 | MBLPO | POS | |||
BUDAT | Posting Date in Document for QM Interface - Subsystem | QEIFBUDAT | DATS | 8 | DATUM | ||||
AUFNR | Order Number | AUFNR | CHAR | 12 | AUFK | ALPHA | AUFNR | ANR | |
KDAUF | Sales Order Number | KDAUF | CHAR | 10 | VBUK | ALPHA | VBELN | AUN | |
KDPOS | Item Number in Sales Order | KDPOS | NUMC | 6 | NUM06 | KPO | |||
VORKTXT | Operation short text | LTXA1 | CHAR | 40 | TEXT40 | ||||
PRPLATZ | Work Center | QPRPLATZ | CHAR | 8 | ARBPL | QAP | |||
PRPLATZWRK | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
PRPLATZTXT | Short Text | QKURZTEXT | CHAR | 40 | QKURZTEXT | ||||
SUBSYS | Subsystem Identifier for QM Subsystem Interface | QEIFSUBSYS | CHAR | 6 | QISUB | QEIFSUBSYS | |||
QKZPRZEIT | Interval = Time (Time-Related) | QKZPRZEIT | CHAR | 1 | QKZ | ||||
QKZPRMENG | Creation Cycle = Quantity (Quantity-Reference) | QKZPRMENG | CHAR | 1 | QKZ | ||||
QKZPRFREI | Interval Without Reference to Time or Quantity | QKZPRFREI | CHAR | 1 | QKZ | ||||
QRASTZEHT | Time Unit | QRASTZEHT | UNIT | 3 | T006 | CUNIT | MEINS | ||
QRASTZFAK | Time Factor | QEIFRASTZF | NUMC | 6 | NUM6 | ||||
QRASTMENG | Quantity Between Two Inspections | QEIFRASTMG | CHAR | 17 | CHAR17 | ||||
QRASTEREH | Grid Unit of Measure | QRASTEREH | UNIT | 3 | T006 | CUNIT | MEINS | ||
KZUSERC1 | Field Active | QKZUSRAKT | CHAR | 1 | QKZUSRAKT | ||||
SWUSERC1 | Keyword for User Field | QUSRSLW | CHAR | 20 | QUSRSLW | ||||
KZUSERC2 | Field Active | QKZUSRAKT | CHAR | 1 | QKZUSRAKT | ||||
SWUSERC2 | Keyword for User Field | QUSRSLW | CHAR | 20 | QUSRSLW | ||||
KZUSERN1 | Field Active | QKZUSRAKT | CHAR | 1 | QKZUSRAKT | ||||
SWUSERN1 | Keyword for User Field | QUSRSLW | CHAR | 20 | QUSRSLW | ||||
KZUSERN2 | Field Active | QKZUSRAKT | CHAR | 1 | QKZUSRAKT | ||||
SWUSERN2 | Keyword for User Field | QUSRSLW | CHAR | 20 | QUSRSLW | ||||
KZUSERD1 | Field Active | QKZUSRAKT | CHAR | 1 | QKZUSRAKT | ||||
SWUSERD1 | Keyword for User Field | QUSRSLW | CHAR | 20 | QUSRSLW | ||||
KZUSERT1 | Field Active | QKZUSRAKT | CHAR | 1 | QKZUSRAKT | ||||
SWUSERT1 | Keyword for User Field | QUSRSLW | CHAR | 20 | QUSRSLW | ||||
TEILLOSPFL | Partial Lot Assignment Required for an Insp. Point | QEIFTLPFL | CHAR | 1 | QKZ | ||||
CHARGPFL | Batch management requirement indicator | XCHPF | CHAR | 1 | XFELD | ||||
KOSTL | Cost Center | KOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
KZKORRTRAN | Correction Transfer Was Carried Out | QEIFKORRTR | CHAR | 1 | QKZ | ||||
PRUEFSTAT | Status of Inspection for QM Subsystem | QEIFSTAINS | CHAR | 1 | QEIFSTAINS | ||||
EINHVORG | Unit of Measure for Activity/Operation | VORME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
RUECKMPP | X and Blank | QKZ | CHAR | 1 | QKZ |
Key field | Non-key field |
How do I retrieve data from SAP structure QAIVC_O1 using ABAP code?
As QAIVC_O1 is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on QAIVC_O1 as there is no data to select.How to access SAP table QAIVC_O1
Within an ECC or HANA version of SAP you can also view further information about QAIVC_O1 and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects