SAP Table VIQMEL
Generated Table for View
VIQMEL (Generated Table for View) 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 VIQMEL to other SAP tables.
VIQMEL table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||||||||||||||||||||
| QMNUM | Notification No | QMNUM | QMEL | CHAR | 12 | 0 | ||||||||||||||||||||||||||||
| IWERK | Maintenance Planning Plant | IWERK | T399I | CHAR | 4 | 0 | ||||||||||||||||||||||||||||
| ILOAN | Location and account assignment for technical object | ILOAN | ILOA | CHAR | 12 | 0 | ||||||||||||||||||||||||||||
| ILOAI | ILOA Individual | ILOAI | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||
| EQUNR | Equipment Number | EQUNR | EQUI | CHAR | 18 | 0 | ||||||||||||||||||||||||||||
| BAUTL | Assembly | BAUTL | MARA | CHAR | 18 | 0 | ||||||||||||||||||||||||||||
| EBORT | Installation Point for Subitem | EBORT | CHAR | 20 | 0 | |||||||||||||||||||||||||||||
| MSAUS | Breakdown Indicator | MSAUS | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||
| AUSVN | Start of Malfunction (Date) | AUSVN | DATS | 8 | 0 | |||||||||||||||||||||||||||||
| AUSBS | End of Malfunction (Date) | AUSBS | DATS | 8 | 0 | |||||||||||||||||||||||||||||
| AUZTV | Start of Malfunction (Time) | AUZTV | TIMS | 6 | 0 | |||||||||||||||||||||||||||||
| AUZTB | End of Malfunction (Time) | AUZTB | TIMS | 6 | 0 | |||||||||||||||||||||||||||||
| AUSZT | Breakdown Duration | AUSZT | FLTP | 16 | 16 | |||||||||||||||||||||||||||||
| MAUEH | Unit for Breakdown Duration | MAUEH | T006 | UNIT | 3 | 0 | ||||||||||||||||||||||||||||
| BTPLN | Functional Location Affected | BTPLN | IFLOT | CHAR | 30 | 0 | ||||||||||||||||||||||||||||
| BEQUI | Equipment Affected | BEQUI | EQUI | CHAR | 18 | 0 | ||||||||||||||||||||||||||||
| AUSWK | Effect on Operation | AUSWK | T357A | CHAR | 1 | 0 | ||||||||||||||||||||||||||||
| VERFV | Availability Before Malfunction | VERFV | NUMC | 3 | 0 | |||||||||||||||||||||||||||||
| VERFN | Availability After Malfunction | VERFN | NUMC | 3 | 0 | |||||||||||||||||||||||||||||
| VERFM | Availability After Completion of Task | VERFM | NUMC | 3 | 0 | |||||||||||||||||||||||||||||
| ANLZV | System Condition Before Malfunction | ANLZV | T357Z | CHAR | 1 | 0 | ||||||||||||||||||||||||||||
| ANLZN | System Condition After Malfunction | ANLZN | T357Z | CHAR | 1 | 0 | ||||||||||||||||||||||||||||
| ANLZE | System Condition After Completion of Task | ANLZE | T357Z | CHAR | 1 | 0 | ||||||||||||||||||||||||||||
| INSPK | Name of Person Responsible for Technical Inspection | INSPK | CHAR | 12 | 0 | |||||||||||||||||||||||||||||
| DATAN | Date of Technical Inspection | DATAN | DATS | 8 | 0 | |||||||||||||||||||||||||||||
| INGRP | Planner Group for Customer Service and Plant Maintenance | INGRP | T024I | CHAR | 3 | 0 | ||||||||||||||||||||||||||||
| WARPL | Maintenance Plan | WARPL | MPLA | CHAR | 12 | 0 | ||||||||||||||||||||||||||||
| ABNUM | Maintenance Plan Call Number | ABNUM | INT4 | 10 | 0 | |||||||||||||||||||||||||||||
| WAPOS | Maintenance item | WAPOS | CHAR | 16 | 0 | |||||||||||||||||||||||||||||
| SCREENTY | Scenario or Subscreen Category | SCRTP | CHAR | 4 | 0 | |||||||||||||||||||||||||||||
| REVNR | Revision for Plant Maintenance and Customer Service | REVNI | CHAR | 8 | 0 | |||||||||||||||||||||||||||||
| QMART | Notification Type | QMART | TQ80 | CHAR | 2 | 0 | ||||||||||||||||||||||||||||
| QMTXT | Short Text | QMTXT | CHAR | 40 | 0 | |||||||||||||||||||||||||||||
| ARTPR | Priority Type | ARTPR | T356A | CHAR | 2 | 0 | ||||||||||||||||||||||||||||
| PRIOK | Priority | PRIOK | T356 | CHAR | 1 | 0 | ||||||||||||||||||||||||||||
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | 0 | |||||||||||||||||||||||||||||
| ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | 0 | |||||||||||||||||||||||||||||
| AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | 0 | |||||||||||||||||||||||||||||
| AEDAT | Changed On | AEDAT | DATS | 8 | 0 | |||||||||||||||||||||||||||||
| MZEIT | Time of Notification | MZEIT | TIMS | 6 | 0 | |||||||||||||||||||||||||||||
| QMDAT | Date of Notification | QMDAT | DATS | 8 | 0 | |||||||||||||||||||||||||||||
| QMNAM | Name of Person Reporting Notification | QMNAM | CHAR | 12 | 0 | |||||||||||||||||||||||||||||
| STRMN | Required start date | STRMN | DATS | 8 | 0 | |||||||||||||||||||||||||||||
| STRUR | Required Start Time | STRUR | TIMS | 6 | 0 | |||||||||||||||||||||||||||||
| LTRMN | Required End Date | LTRMN | DATS | 8 | 0 | |||||||||||||||||||||||||||||
| LTRUR | Requested End Time | LTRUR | TIMS | 6 | 0 | |||||||||||||||||||||||||||||
| WAERS | Currency Key | WAERS | TCURC | CUKY | 5 | 0 | ||||||||||||||||||||||||||||
| AUFNR | Order Number | AUFNR | AUFK | CHAR | 12 | 0 | ||||||||||||||||||||||||||||
| VERID | Production Version | VERID | MKAL | CHAR | 4 | 0 | ||||||||||||||||||||||||||||
| RM_MATNR | Material number of the production version | RM_MATNR | MKAL | CHAR | 18 | 0 | ||||||||||||||||||||||||||||
| RM_WERKS | Plant of production version | RM_WERKS | MKAL | CHAR | 4 | 0 | ||||||||||||||||||||||||||||
| SA_AUFNR | Run schedule header number | SA_AUFNR | SAFK | CHAR | 12 | 0 | ||||||||||||||||||||||||||||
| MATNR | Material Number | MATNR | MARA | CHAR | 18 | 0 | ||||||||||||||||||||||||||||
| REVLV | Revision Level | REVLV | CHAR | 2 | 0 | |||||||||||||||||||||||||||||
| MATKL | Material Group | MATKL | T023 | CHAR | 9 | 0 | ||||||||||||||||||||||||||||
| PRDHA | Product hierarchy | PRODH_D | T179 | CHAR | 18 | 0 | ||||||||||||||||||||||||||||
| KZKRI | Indicator: Critical part | KZKRI | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||
| KZDKZ | Documentation required indicator | KZDKZ | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||
| KUNUM | Account Number of Customer | QKUNUM | KNA1 | CHAR | 10 | 0 | ||||||||||||||||||||||||||||
| FEKNZ | Error Records Exist | FEKNZ | CHAR | 1 | 0 | |||||||||||||||||||||||||||||
| MAKNZ | Task Records Exist | MAKNZ | CHAR | 1 | 0 | |||||||||||||||||||||||||||||
| OBJNR | Object Number for Status Management | QMOBJNR | ONR00 | CHAR | 22 | 0 | ||||||||||||||||||||||||||||
| QMDAB | Date for Notification Completion | QMDAB | DATS | 8 | 0 | |||||||||||||||||||||||||||||
| QMZAB | Completion Time of Notification | QMZAB | TIMS | 6 | 0 | |||||||||||||||||||||||||||||
| RBNR | Catalog Profile | RBNR | T352B | CHAR | 9 | 0 | ||||||||||||||||||||||||||||
| RBNRI | Origin of Notifications Catalog Profile | RBNRI | CHAR | 1 | 0 | |||||||||||||||||||||||||||||
| INDTX | Object Long Text Available | INDLTX | CHAR | 1 | 0 | |||||||||||||||||||||||||||||
| KZMLA | Primary language indicator for text segment | KZMLA | CHAR | 1 | 0 | |||||||||||||||||||||||||||||
| HERKZ | Origin of Notification | HERKZ | CHAR | 2 | 0 |
Possible values
|
||||||||||||||||||||||||||||
| BEZDT | Notification Reference Date | BEZDT | DATS | 8 | 0 | |||||||||||||||||||||||||||||
| BEZUR | Notification Reference Time | BEZUR_D | TIMS | 6 | 0 | |||||||||||||||||||||||||||||
| LIFNUM | Vendor Account Number | LIFNUM | LFA1 | CHAR | 10 | 0 | ||||||||||||||||||||||||||||
| BUNAME | Author of a Q/PM Notification | BUNAME | CHAR | 12 | 0 | |||||||||||||||||||||||||||||
| VBELN | Sales Order Number | KDAUF | VBUK | CHAR | 10 | 0 | ||||||||||||||||||||||||||||
| BSTNK | Customer purchase order number | BSTKD | CHAR | 35 | 0 | |||||||||||||||||||||||||||||
| BSTDK | Customer purchase order date | BSTDK | DATS | 8 | 0 | |||||||||||||||||||||||||||||
| SPART | Division | SPART | TSPA | CHAR | 2 | 0 | ||||||||||||||||||||||||||||
| VKORG | Sales Organization | VKORG | TVKO | CHAR | 4 | 0 | ||||||||||||||||||||||||||||
| VTWEG | Distribution Channel | VTWEG | TVTW | CHAR | 2 | 0 | ||||||||||||||||||||||||||||
| ADRNR | Addresses: Address Number | CADNR | CHAR | 10 | 0 | |||||||||||||||||||||||||||||
| AEZEIT | Time of Change | AEZEIT | TIMS | 6 | 0 | |||||||||||||||||||||||||||||
| ERZEIT | Time, at Which Record Was Added | ERZEIT | TIMS | 6 | 0 | |||||||||||||||||||||||||||||
| MAWERK | Plant for Material | QMAWERKS | T001W | CHAR | 4 | 0 | ||||||||||||||||||||||||||||
| QMKAT | Catalog Type - Coding | QMKAT | TQ15 | CHAR | 1 | 0 | ||||||||||||||||||||||||||||
| QMGRP | Code Group - Coding | QMGRP | QPGR | CHAR | 8 | 0 | ||||||||||||||||||||||||||||
| QMCOD | Coding | QMCOD | CHAR | 4 | 0 | |||||||||||||||||||||||||||||
| AUSWIRK | Key for a Scenario | QSCENARIO | TQ81 | CHAR | 4 | 0 | ||||||||||||||||||||||||||||
| TEILEV | Usage of Parts | QTEILEV | TQ81V | CHAR | 4 | 0 | ||||||||||||||||||||||||||||
| PRUEFLOS | Inspection Lot Number | QPLOS | QALS | NUMC | 12 | 0 | ||||||||||||||||||||||||||||
| CHARG | Batch Number | CHARG_D | MCH1 | CHAR | 10 | 0 | ||||||||||||||||||||||||||||
| LGORTCHARG | Storage Location of Batch | QLGORTCHAR | T001L | CHAR | 4 | 0 | ||||||||||||||||||||||||||||
| LICHN | Vendor Batch Number | LICHN | CHAR | 15 | 0 | |||||||||||||||||||||||||||||
| HERSTELLER | Number of Manufacturer | QLIFNR | LFA1 | CHAR | 10 | 0 | ||||||||||||||||||||||||||||
| EMATNR | Material Number Corresponding to Manufacturer Part Number | EMATN | MARA | CHAR | 18 | 0 | ||||||||||||||||||||||||||||
| EKORG | Purchasing Organization | EKORG | T024E | CHAR | 4 | 0 | ||||||||||||||||||||||||||||
| BKGRP | Purchasing Group | BKGRP | T024 | CHAR | 3 | 0 | ||||||||||||||||||||||||||||
| LGORTVORG | Storage Location for Inspection Lot Stock | QLGORTVORG | T001L | CHAR | 4 | 0 | ||||||||||||||||||||||||||||
| FERTAUFNR | Order Number (Production Order) | FERTAUFNR | AUFK | CHAR | 12 | 0 | ||||||||||||||||||||||||||||
| FERTAUFPL | Plan Number for Operations in Order (Production Order) | FERTAUFPL | NUMC | 10 | 0 | |||||||||||||||||||||||||||||
| EBELN | Purchasing Document Number | EBELN | EKKO | CHAR | 10 | 0 | ||||||||||||||||||||||||||||
| EBELP | Item Number of Purchasing Document | QEBELP | EKPO | NUMC | 5 | 0 | ||||||||||||||||||||||||||||
| MJAHR | Material Document Year | MJAHR | NUMC | 4 | 0 | |||||||||||||||||||||||||||||
| MBLNR | Number of Material Document | MBLNR | CHAR | 10 | 0 | |||||||||||||||||||||||||||||
| MBLPO | Item in Material Document | QMBLPO | NUMC | 4 | 0 | |||||||||||||||||||||||||||||
| LS_KDAUF | Sales Order Number | KDAUF | VBUK | CHAR | 10 | 0 | ||||||||||||||||||||||||||||
| LS_KDPOS | Item number of the SD document | POSNR | VBUP | NUMC | 6 | 0 | ||||||||||||||||||||||||||||
| LS_VBELN | Delivery | VBELN_VL | VBUK | CHAR | 10 | 0 | ||||||||||||||||||||||||||||
| LS_POSNR | Delivery Item | QPOSNR_VL | VBUP | NUMC | 6 | 0 | ||||||||||||||||||||||||||||
| CROBJTY | Object types of the CIM resource | CR_OBJTY | CHAR | 2 | 0 |
Possible values
|
||||||||||||||||||||||||||||
| ARBPL | Object ID of the Work Center | LGWID | CRID | NUMC | 8 | 0 | ||||||||||||||||||||||||||||
| ARBPLWERK | Plant for Work Center | QARBPWERKS | T001W | CHAR | 4 | 0 | ||||||||||||||||||||||||||||
| FEART | Report Type for Defects Recording | QFEART | TQ86 | CHAR | 8 | 0 | ||||||||||||||||||||||||||||
| PNLKN | Current Node Number from Order Counter APLZL | QLFNKN | NUMC | 8 | 0 | |||||||||||||||||||||||||||||
| MGEIG | Defective Quantity (Internal) | MGEIG | QUAN | 13 | 3 | |||||||||||||||||||||||||||||
| MGFRD | Defective Quantity (External) | MGFRD | QUAN | 13 | 3 | |||||||||||||||||||||||||||||
| MGEIN | Unit of Measure | MGEIN | T006 | UNIT | 3 | 0 | ||||||||||||||||||||||||||||
| BZMNG | General Reference Quantity | QBZMNG | QUAN | 13 | 3 | |||||||||||||||||||||||||||||
| RKMNG | Complaint Quantity | RKMNG | QUAN | 13 | 3 | |||||||||||||||||||||||||||||
| RGMNG | Return Delivery Quantity | RGMNG | QUAN | 13 | 3 | |||||||||||||||||||||||||||||
| RKDAT | Date of Return Delivery | RKDAT | DATS | 8 | 0 | |||||||||||||||||||||||||||||
| COAUFNR | Order Number (QM Order) | COAUFNR | AUFK | CHAR | 12 | 0 | ||||||||||||||||||||||||||||
| QWRNUM | Reference Notification Number | QWRNUM | QMEL | CHAR | 12 | 0 | ||||||||||||||||||||||||||||
| REFNUM | External Reference Number | QMEXTNR | CHAR | 20 | 0 | |||||||||||||||||||||||||||||
| KDMAT | Material Number Used by Customer | MATNR_KU | CHAR | 35 | 0 | |||||||||||||||||||||||||||||
| IDNLF | Material Number Used by Vendor | IDNLF | CHAR | 35 | 0 | |||||||||||||||||||||||||||||
| SERIALNR | Serial Number | GERNR | CHAR | 18 | 0 | |||||||||||||||||||||||||||||
| KZLOESCH | Delete Data Record | KZLOESCH | CHAR | 1 | 0 | |||||||||||||||||||||||||||||
| PRODDAT | Production Date | QPRODDAT | DATS | 8 | 0 | |||||||||||||||||||||||||||||
| DEVICEID | Additional Device Data | DEVICEID | CHAR | 40 | 0 | |||||||||||||||||||||||||||||
| VKBUR | Sales Office | VKBUR | TVKBZ | CHAR | 4 | 0 | ||||||||||||||||||||||||||||
| VKGRP | Sales Group | VKGRP | TVBVK | CHAR | 3 | 0 | ||||||||||||||||||||||||||||
| AUTKZ | Data Record Created with Function 'Create with Copy Model' | QAUTKZ | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||
| BEDID | ID of the capacity requirements record | BEDID | NUMC | 12 | 0 | |||||||||||||||||||||||||||||
| BEDZL | Internal counter | CIM_COUNT | NUMC | 8 | 0 | |||||||||||||||||||||||||||||
| PROFIL_TYP | Object Type | OTYPE | CHAR | 2 | 0 | |||||||||||||||||||||||||||||
| PROFIL_ID | Object ID | OBJEKTID | NUMC | 8 | 0 | |||||||||||||||||||||||||||||
| HANDLE | Globally unique identifier (linked to time segment, etc) | TSEGGUID | CHAR | 22 | 0 | |||||||||||||||||||||||||||||
| TSEGFL | Time segment exists | TSEGEXISTS | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||
| TSEGTP | Template | TSEGTEMPLA | TTSEGTPLH | CHAR | 10 | 0 | ||||||||||||||||||||||||||||
| TZONSO | Time Zone for Notification | TZONSO | TTZZ | CHAR | 6 | 0 | ||||||||||||||||||||||||||||
| TZONID | Origin of Time Zone in Notification | TZONSMID | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||
| FUNKTION | Keys for Function in Action Box | QNFUNKTION | CHAR | 4 | 0 | |||||||||||||||||||||||||||||
| /SAPSMOSS/INSTN | Installation number | /SAPSMOSS/R3INSTN | /SAPSMOSS/INSTN | CHAR | 10 | 0 | ||||||||||||||||||||||||||||
| /SAPSMOSS/MNUMM | SAPNet notification number | /SAPSMOSS/MNUMM | NUMC | 24 | 0 | |||||||||||||||||||||||||||||
| /SAPSMOSS/OSSYS | Operating system and version | /SAPSMOSS/OSSYS | /SAPSMOSS/OSYS | CHAR | 10 | 0 | ||||||||||||||||||||||||||||
| /SAPSMOSS/DBSYS | Database system | /SAPSMOSS/DBSYS | /SAPSMOSS/DBSY | CHAR | 10 | 0 | ||||||||||||||||||||||||||||
| /SAPSMOSS/REL | R/3 Release | /SAPSMOSS/R3REL | /SAPSMOSS/REL | CHAR | 10 | 0 | ||||||||||||||||||||||||||||
| /SAPSMOSS/COMP | Area | /SAPSMOSS/R3COMP | CHAR | 20 | 0 | |||||||||||||||||||||||||||||
| /SAPSMOSS/FRONT | Frontend | /SAPSMOSS/FRONTEND | /SAPSMOSS/FRNT | CHAR | 10 | 0 | ||||||||||||||||||||||||||||
| /SAPSMOSS/SYSTYP | R/3 System type | /SAPSMOSS/R3SYSTYPE | /SAPSMOSS/SYST | CHAR | 1 | 0 | ||||||||||||||||||||||||||||
| /SAPSMOSS/ADDID | Add-on ID | /SAPSMOSS/R3ADDID | /SAPSMOSS/ADDID | CHAR | 10 | 0 | ||||||||||||||||||||||||||||
| /SAPSMOSS/ADDREL | Add-On Release | /SAPSMOSS/R3ADDREL | /SAPSMOSS/ADDRL | CHAR | 10 | 0 | ||||||||||||||||||||||||||||
| /SAPSMOSS/TSTMP | SAPNet time stamp | /SAPSMOSS/NSTSTMP | NUMC | 14 | 0 | |||||||||||||||||||||||||||||
| /SAPSMOSS/STATUS | Status of R/3 notification in SAPNet | /SAPSMOSS/STATUS | /SAPSMOSS/STAT | CHAR | 1 | 0 | ||||||||||||||||||||||||||||
| /SAPSMOSS/ERDAT | Date on which notification was completed at SAP | /SAPSMOSS/ERDAT | DATS | 8 | 0 | |||||||||||||||||||||||||||||
| /SAPSMOSS/ERZEIT | Time when notification was completed at SAP | /SAPSMOSS/ERZEIT | TIMS | 6 | 0 | |||||||||||||||||||||||||||||
| /SAPSMOSS/SYSID | Name of SAP System | SYSYSID | CHAR | 8 | 0 | |||||||||||||||||||||||||||||
| /SAPSMOSS/MANDT | Client ID | SYMANDT | CLNT | 3 | 0 | |||||||||||||||||||||||||||||
| PSP_NR | WBS Element | PS_POSNR | NUMC | 8 | 0 | |||||||||||||||||||||||||||||
| ESTIMATED_COSTS | Estimated Costs for a Claim | PS_COSTS | CURR | 13 | 2 | |||||||||||||||||||||||||||||
| CLAIMED_COSTS | Costs Claimed | COSTS_CLAIM | CURR | 13 | 2 | |||||||||||||||||||||||||||||
| RESULT_COSTS | Costs Accepted | COSTS_RESULT | CURR | 13 | 2 | |||||||||||||||||||||||||||||
| CHANCE | Chance of Completing a Claim | PS_CHANCE | NUMC | 2 | 0 |
Possible values
|
||||||||||||||||||||||||||||
| OPPONENT | Partner Type | PS_OPPONENT | CHAR | 2 | 0 |
Possible values
|
||||||||||||||||||||||||||||
| KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | CK_KALNR | NUMC | 12 | 0 | |||||||||||||||||||||||||||||
| KALVAR | Costing Variant for Postprocessing with Unit Costing | CK_KALVAR | CHAR | 4 | 0 | |||||||||||||||||||||||||||||
| OBJNR_REAL | Object number of real CO account assignment | J_OBJNR_REAL | ONR00 | CHAR | 22 | 0 | ||||||||||||||||||||||||||||
| OBJNR_STAT | Auxiliary account assignment 1 | OBJNR_N1 | ONR00 | CHAR | 22 | 0 | ||||||||||||||||||||||||||||
| PHASE | Notification Processing Phase | QM_PHASE | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||
| /ISDFPS/OBJNR | Object number | J_OBJNR | CHAR | 22 | 0 | |||||||||||||||||||||||||||||
| LOGSYSTEM | Logical System | LOGSYSTEM | CHAR | 10 | 0 | |||||||||||||||||||||||||||||
| /ISDFPS/MEQUI | Master Equipment | /ISDFPS/MEQUI | CHAR | 18 | 0 | |||||||||||||||||||||||||||||
| SHN_OBJTY | Object types of the CIM resource | CR_OBJTY | CHAR | 2 | 0 |
Possible values
|
||||||||||||||||||||||||||||
| SHN_OBJID | Object ID of the resource | CR_OBJID | NUMC | 8 | 0 | |||||||||||||||||||||||||||||
| SHN_FUNCT_LOC | Functional Location | TPLNR | CHAR | 30 | 0 | |||||||||||||||||||||||||||||
| SHN_EQUIPMENT | Equipment Number | EQUNR | CHAR | 18 | 0 | |||||||||||||||||||||||||||||
| SHN_ORIGIN | Origin or Use of Shift Note or Report | COCF_SRN_ORIGIN | NUMC | 2 | 0 |
Possible values
|
||||||||||||||||||||||||||||
| TPLNR | Functional Location | TPLNR | IFLOT | CHAR | 30 | 0 | ||||||||||||||||||||||||||||
| ABCKZ | ABC indicator for technical object | ABCKZ | T370C | CHAR | 1 | 0 | ||||||||||||||||||||||||||||
| EQFNR | Sort field | EQFNR | CHAR | 30 | 0 | |||||||||||||||||||||||||||||
| SWERK | Maintenance plant | SWERK | T001W | CHAR | 4 | 0 | ||||||||||||||||||||||||||||
| STORT | Location of maintenance object | PMLOC | T499S | CHAR | 10 | 0 | ||||||||||||||||||||||||||||
| MSGRP | Room | RAUMNR | CHAR | 8 | 0 | |||||||||||||||||||||||||||||
| BEBER | Plant section | BEBER | T357 | CHAR | 3 | 0 | ||||||||||||||||||||||||||||
| PPSID | Object ID of PP work center | PPSID | CRID | NUMC | 8 | 0 | ||||||||||||||||||||||||||||
| GSBER | Business Area | GSBER | TGSB | CHAR | 4 | 0 | ||||||||||||||||||||||||||||
| KOKRS | Controlling Area | KOKRS | TKA01 | CHAR | 4 | 0 | ||||||||||||||||||||||||||||
| KOSTL | Cost Center | KOSTL | CSKS | CHAR | 10 | 0 | ||||||||||||||||||||||||||||
| PROID | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | PRPS | NUMC | 8 | 0 | ||||||||||||||||||||||||||||
| ANLNR | Main Asset Number | ANLN1 | ANLH | CHAR | 12 | 0 | ||||||||||||||||||||||||||||
| ANLUN | Asset Subnumber | ANLN2 | ANLA | CHAR | 4 | 0 | ||||||||||||||||||||||||||||
| DAUFN | Standing order number | DAUFN | AUFK | CHAR | 12 | 0 | ||||||||||||||||||||||||||||
| KAUFN | Settlement order | ILOM_ORDST | AUFK | CHAR | 12 | 0 | ||||||||||||||||||||||||||||
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 | 0 | ||||||||||||||||||||||||||||
| ABCKZI | Data origin for ABC indicator field | INH_ABCKZI | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||
| EQFNRI | Data origin for sort field | INH_EQFNRI | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||
| SWERKI | Data origin for maintenance plant field | INH_SWERKI | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||
| STORTI | Data origin for location field | INH_STORTI | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||
| MSGRPI | Data origin for room number field | INH_MSGRPI | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||
| BEBERI | Data origin for plant section field | INH_BEBERI | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||
| CR_OBJTY | Object types of the CIM resource | CR_OBJTY | CHAR | 2 | 0 |
Possible values
|
||||||||||||||||||||||||||||
| PPSIDI | Data origin for PP work center field | INH_PPSIDI | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||
| GSBERI | Data origin for business area field | INH_GSBERI | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||
| KOKRSI | Data origin for controlling area field | INH_KOKRSI | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||
| KOSTLI | Data origin for cost center field | INH_KOSTLI | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||
| PROIDI | Data origin for WBS element field | INH_PROIDI | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||
| BUKRSI | Data origin for company code field | INH_BUKRSI | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||
| ANLNRI | Data origin for asset main no./sub-no. fields | INH_ANLNRI | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||
| ANLUNI | Data origin indicator | INHER | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||
| DAUFNI | Data origin of standing order number field | INH_DAUFNI | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||
| AUFNRI | Data origin for settlement order field | INH_AUFNRI | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||
| SPART_ILOA | Division | SPART | TVTA | CHAR | 2 | 0 | ||||||||||||||||||||||||||||
| VTWEG_ILOA | Distribution Channel | VTWEG | TVKOV | CHAR | 2 | 0 | ||||||||||||||||||||||||||||
| SPARTI | Data origin for division field | INH_SPARTI | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||
| VTWEGI | Data origin of distribution channel field | INH_VTWEGI | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||
| VKORGI | Data origin for sales organization field | INH_VKORGI | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||
| VKORG_ILOA | Sales Organization | VKORG | TVKO | CHAR | 4 | 0 | ||||||||||||||||||||||||||||
| ADRNR_ILOA | Address number | AD_ADDRNUM | ADRC | CHAR | 10 | 0 | ||||||||||||||||||||||||||||
| OWNER | Object reference indicator | ILOM_OWNER | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||
| KDAUF | Sales Document | VBELN_VA | VBUK | CHAR | 10 | 0 | ||||||||||||||||||||||||||||
| KDPOS | Sales Document Item | POSNR_VA | VBUP | NUMC | 6 | 0 | ||||||||||||||||||||||||||||
| PLNTY | Task List Type | PLNTY | CHAR | 1 | 0 | |||||||||||||||||||||||||||||
| PLNNR | Key for Task List Group | PLNNR | CHAR | 8 | 0 | |||||||||||||||||||||||||||||
| PLNAL | Group Counter | PLNAL | CHAR | 2 | 0 | |||||||||||||||||||||||||||||
| UII | Unique Item Identifier | UII_CHAR72 | CHAR | 72 | 0 | |||||||||||||||||||||||||||||
| PAMS_PTSTF | Planned Time Stamp (from) | PAMS_PTSTF | DEC | 15 | 0 | |||||||||||||||||||||||||||||
| PAMS_PTSTT | Planned Time Stamp (to) | PAMS_PTSTT | DEC | 15 | 0 | |||||||||||||||||||||||||||||
| PAMS_ATSTF | Actual Start Time | PAMS_ATSTF | DEC | 15 | 0 | |||||||||||||||||||||||||||||
| PAMS_ATSTT | Actual End Time | PAMS_ATSTT | DEC | 15 | 0 | |||||||||||||||||||||||||||||
| PAMS_POOL | PAM Pool | PAMS_POOL | CHAR | 8 | 0 | |||||||||||||||||||||||||||||
| PAMS_KOSTL | Cost Center | KOSTL | CHAR | 10 | 0 | |||||||||||||||||||||||||||||
| PAMS_AUFNR | Order Number | AUFNR | CHAR | 12 | 0 | |||||||||||||||||||||||||||||
| PAMS_PROID | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 | 0 | |||||||||||||||||||||||||||||
| PAMS_KOKRS | Controlling Area | KOKRS | CHAR | 4 | 0 | |||||||||||||||||||||||||||||
VIQMEL foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| VIQMEL | /SAPSMOSS/ADDID | * | /SAPSMOSS/ADDID | Add-On ID | MANDT | |
| VIQMEL | /SAPSMOSS/ADDID | VIQMEL | /SAPSMOSS/ADDID | /SAPSMOSS/ADDID | Add-On ID | R3ADDID |
| VIQMEL | /SAPSMOSS/ADDREL | VIQMEL | /SAPSMOSS/ADDREL | /SAPSMOSS/ADDRL | Add-On Release | R3ADDREL |
| VIQMEL | /SAPSMOSS/ADDREL | * | /SAPSMOSS/ADDRL | Add-On Release | MANDT | |
| VIQMEL | /SAPSMOSS/DBSYS | SYST | MANDT | /SAPSMOSS/DBSY | Databases | MANDT |
| VIQMEL | /SAPSMOSS/DBSYS | VIQMEL | /SAPSMOSS/DBSYS | /SAPSMOSS/DBSY | Databases | DBSYS |
| VIQMEL | /SAPSMOSS/FRONT | SYST | MANDT | /SAPSMOSS/FRNT | Frontend | MANDT |
| VIQMEL | /SAPSMOSS/FRONT | VIQMEL | /SAPSMOSS/FRONT | /SAPSMOSS/FRNT | Frontend | FRONTEND |
| VIQMEL | /SAPSMOSS/INSTN | SYST | MANDT | /SAPSMOSS/INSTN | Table of Installation Numbers | MANDT |
| VIQMEL | /SAPSMOSS/INSTN | VIQMEL | /SAPSMOSS/INSTN | /SAPSMOSS/INSTN | Table of Installation Numbers | R3INSTN |
| VIQMEL | /SAPSMOSS/OSSYS | SYST | MANDT | /SAPSMOSS/OSYS | Operating systems | MANDT |
| VIQMEL | /SAPSMOSS/OSSYS | VIQMEL | /SAPSMOSS/OSSYS | /SAPSMOSS/OSYS | Operating systems | OSSYS |
| VIQMEL | /SAPSMOSS/REL | SYST | MANDT | /SAPSMOSS/REL | SAP release | MANDT |
| VIQMEL | /SAPSMOSS/REL | VIQMEL | /SAPSMOSS/REL | /SAPSMOSS/REL | SAP release | R3REL |
| VIQMEL | /SAPSMOSS/STATUS | VIQMEL | /SAPSMOSS/STATUS | /SAPSMOSS/STAT | Status | STATUS |
| VIQMEL | /SAPSMOSS/SYSTYP | SYST | MANDT | /SAPSMOSS/SYST | System types | MANDT |
| VIQMEL | /SAPSMOSS/SYSTYP | VIQMEL | /SAPSMOSS/SYSTYP | /SAPSMOSS/SYST | System types | R3SYSTYPE |
| VIQMEL | ABCKZ | VIQMEL | MANDT | T370C | ABC indicator for technical objects | MANDT |
| VIQMEL | ABCKZ | VIQMEL | ABCKZ | T370C | ABC indicator for technical objects | ABCKZ |
| VIQMEL | ADRNR_ILOA | * | ADRC | Addresses (Business Address Services) | DATE_FROM | |
| VIQMEL | ADRNR_ILOA | * | ADRC | Addresses (Business Address Services) | NATION | |
| VIQMEL | ADRNR_ILOA | VIQMEL | MANDT | ADRC | Addresses (Business Address Services) | CLIENT |
| VIQMEL | ADRNR_ILOA | VIQMEL | ADRNR_ILOA | ADRC | Addresses (Business Address Services) | ADDRNUMBER |
| VIQMEL | ANLNR | VIQMEL | MANDT | ANLH | Main asset number | MANDT |
| VIQMEL | ANLNR | VIQMEL | BUKRS | ANLH | Main asset number | BUKRS |
| VIQMEL | ANLNR | VIQMEL | ANLNR | ANLH | Main asset number | ANLN1 |
| VIQMEL | ANLUN | VIQMEL | ANLUN | ANLA | Asset Master Record Segment | ANLN2 |
| VIQMEL | ANLUN | VIQMEL | MANDT | ANLA | Asset Master Record Segment | MANDT |
| VIQMEL | ANLUN | VIQMEL | BUKRS | ANLA | Asset Master Record Segment | BUKRS |
| VIQMEL | ANLUN | VIQMEL | ANLNR | ANLA | Asset Master Record Segment | ANLN1 |
| VIQMEL | ANLZE | VIQMEL | ANLZE | T357Z | Syst.Condition | ANLAZ |
| VIQMEL | ANLZE | VIQMEL | MANDT | T357Z | Syst.Condition | MANDT |
| VIQMEL | ANLZN | VIQMEL | MANDT | T357Z | Syst.Condition | MANDT |
| VIQMEL | ANLZN | VIQMEL | ANLZN | T357Z | Syst.Condition | ANLAZ |
| VIQMEL | ANLZV | VIQMEL | MANDT | T357Z | Syst.Condition | MANDT |
| VIQMEL | ANLZV | VIQMEL | ANLZV | T357Z | Syst.Condition | ANLAZ |
| VIQMEL | ARBPL | VIQMEL | ARBPL | CRID | CIM Resource - Entities | OBJID |
| VIQMEL | ARBPL | VIQMEL | MANDT | CRID | CIM Resource - Entities | MANDT |
| VIQMEL | ARBPL | VIQMEL | CROBJTY | CRID | CIM Resource - Entities | OBJTY |
| VIQMEL | ARBPLWERK | VIQMEL | MANDT | T001W | Plants/Branches | MANDT |
| VIQMEL | ARBPLWERK | VIQMEL | ARBPLWERK | T001W | Plants/Branches | WERKS |
| VIQMEL | ARTPR | VIQMEL | MANDT | T356A | Priority type table | MANDT |
| VIQMEL | ARTPR | VIQMEL | ARTPR | T356A | Priority type table | ARTPR |
| VIQMEL | AUFNR | VIQMEL | MANDT | AUFK | Order master data | MANDT |
| VIQMEL | AUFNR | VIQMEL | AUFNR | AUFK | Order master data | AUFNR |
| VIQMEL | AUSWIRK | VIQMEL | MANDT | TQ81 | Notification Scenario | MANDT |
| VIQMEL | AUSWIRK | VIQMEL | AUSWIRK | TQ81 | Notification Scenario | AUSWIRK |
| VIQMEL | AUSWK | VIQMEL | MANDT | T357A | Effect of malfunction on the system | MANDT |
| VIQMEL | AUSWK | VIQMEL | AUSWK | T357A | Effect of malfunction on the system | AUSWK |
| VIQMEL | BAUTL | VIQMEL | MANDT | MARA | General Material Data | MANDT |
| VIQMEL | BAUTL | VIQMEL | BAUTL | MARA | General Material Data | MATNR |
| VIQMEL | BEBER | VIQMEL | MANDT | T357 | Plant Section | MANDT |
| VIQMEL | BEBER | VIQMEL | SWERK | T357 | Plant Section | WERKS |
| VIQMEL | BEBER | VIQMEL | BEBER | T357 | Plant Section | BEBER |
| VIQMEL | BEQUI | VIQMEL | MANDT | EQUI | Equipment master data | MANDT |
| VIQMEL | BEQUI | VIQMEL | BEQUI | EQUI | Equipment master data | EQUNR |
| VIQMEL | BKGRP | VIQMEL | MANDT | T024 | Purchasing Groups | MANDT |
| VIQMEL | BKGRP | VIQMEL | BKGRP | T024 | Purchasing Groups | EKGRP |
| VIQMEL | BTPLN | VIQMEL | MANDT | IFLOT | Functional Location (Table) | MANDT |
| VIQMEL | BTPLN | VIQMEL | BTPLN | IFLOT | Functional Location (Table) | TPLNR |
| VIQMEL | BUKRS | VIQMEL | MANDT | T001 | Company Codes | MANDT |
| VIQMEL | BUKRS | VIQMEL | BUKRS | T001 | Company Codes | BUKRS |
| VIQMEL | CHARG | VIQMEL | MANDT | MCH1 | Batches (if Batch Management Cross-Plant) | MANDT |
| VIQMEL | CHARG | VIQMEL | MATNR | MCH1 | Batches (if Batch Management Cross-Plant) | MATNR |
| VIQMEL | CHARG | VIQMEL | CHARG | MCH1 | Batches (if Batch Management Cross-Plant) | CHARG |
| VIQMEL | COAUFNR | VIQMEL | MANDT | AUFK | Order master data | MANDT |
| VIQMEL | COAUFNR | VIQMEL | COAUFNR | AUFK | Order master data | AUFNR |
| VIQMEL | DAUFN | VIQMEL | MANDT | AUFK | Order master data | MANDT |
| VIQMEL | DAUFN | VIQMEL | DAUFN | AUFK | Order master data | AUFNR |
| VIQMEL | EBELN | VIQMEL | MANDT | EKKO | Purchasing Document Header | MANDT |
| VIQMEL | EBELN | VIQMEL | EBELN | EKKO | Purchasing Document Header | EBELN |
| VIQMEL | EBELP | VIQMEL | EBELN | EKPO | Purchasing Document Item | EBELN |
| VIQMEL | EBELP | VIQMEL | EBELP | EKPO | Purchasing Document Item | EBELP |
| VIQMEL | EBELP | VIQMEL | MANDT | EKPO | Purchasing Document Item | MANDT |
| VIQMEL | EKORG | VIQMEL | MANDT | T024E | Purchasing Organizations | MANDT |
| VIQMEL | EKORG | VIQMEL | EKORG | T024E | Purchasing Organizations | EKORG |
| VIQMEL | EMATNR | VIQMEL | EMATNR | MARA | General Material Data | MATNR |
| VIQMEL | EMATNR | VIQMEL | MANDT | MARA | General Material Data | MANDT |
| VIQMEL | EQUNR | VIQMEL | EQUNR | EQUI | Equipment master data | EQUNR |
| VIQMEL | EQUNR | VIQMEL | MANDT | EQUI | Equipment master data | MANDT |
| VIQMEL | FEART | VIQMEL | MANDT | TQ86 | Report category for defects recording | MANDT |
| VIQMEL | FEART | VIQMEL | FEART | TQ86 | Report category for defects recording | FEART |
| VIQMEL | FERTAUFNR | VIQMEL | FERTAUFNR | AUFK | Order master data | AUFNR |
| VIQMEL | FERTAUFNR | VIQMEL | MANDT | AUFK | Order master data | MANDT |
| VIQMEL | GSBER | VIQMEL | MANDT | TGSB | Business Areas | MANDT |
| VIQMEL | GSBER | VIQMEL | GSBER | TGSB | Business Areas | GSBER |
| VIQMEL | HERSTELLER | VIQMEL | MANDT | LFA1 | Vendor Master (General Section) | MANDT |
| VIQMEL | HERSTELLER | VIQMEL | HERSTELLER | LFA1 | Vendor Master (General Section) | LIFNR |
| VIQMEL | ILOAN | VIQMEL | ILOAN | ILOA | PM Object Location and Account Assignment | ILOAN |
| VIQMEL | ILOAN | VIQMEL | MANDT | ILOA | PM Object Location and Account Assignment | MANDT |
| VIQMEL | INGRP | VIQMEL | INGRP | T024I | Maintenance planner groups | INGRP |
| VIQMEL | INGRP | VIQMEL | MANDT | T024I | Maintenance planner groups | MANDT |
| VIQMEL | INGRP | VIQMEL | IWERK | T024I | Maintenance planner groups | IWERK |
| VIQMEL | IWERK | VIQMEL | MANDT | T399I | Planning plant parameters | MANDT |
| VIQMEL | IWERK | VIQMEL | IWERK | T399I | Planning plant parameters | IWERK |
| VIQMEL | KAUFN | VIQMEL | MANDT | AUFK | Order master data | MANDT |
| VIQMEL | KAUFN | VIQMEL | KAUFN | AUFK | Order master data | AUFNR |
| VIQMEL | KDAUF | VIQMEL | MANDT | VBUK | Sales Document: Header Status and Administrative Data | MANDT |
| VIQMEL | KDAUF | VIQMEL | KDAUF | VBUK | Sales Document: Header Status and Administrative Data | VBELN |
| VIQMEL | KDPOS | VIQMEL | KDAUF | VBUP | Sales Document: Item Status | VBELN |
| VIQMEL | KDPOS | VIQMEL | KDPOS | VBUP | Sales Document: Item Status | POSNR |
| VIQMEL | KDPOS | VIQMEL | MANDT | VBUP | Sales Document: Item Status | MANDT |
| VIQMEL | KOKRS | VIQMEL | MANDT | TKA01 | Controlling Areas | MANDT |
| VIQMEL | KOKRS | VIQMEL | KOKRS | TKA01 | Controlling Areas | KOKRS |
| VIQMEL | KOSTL | VIQMEL | KOSTL | CSKS | Cost Center Master Data | KOSTL |
| VIQMEL | KOSTL | SYST | DATUM | CSKS | Cost Center Master Data | DATBI |
| VIQMEL | KOSTL | VIQMEL | MANDT | CSKS | Cost Center Master Data | MANDT |
| VIQMEL | KOSTL | VIQMEL | KOKRS | CSKS | Cost Center Master Data | KOKRS |
| VIQMEL | KUNUM | VIQMEL | MANDT | KNA1 | General Data in Customer Master | MANDT |
| VIQMEL | KUNUM | VIQMEL | KUNUM | KNA1 | General Data in Customer Master | KUNNR |
| VIQMEL | LGORTCHARG | VIQMEL | MAWERK | T001L | Storage Locations | WERKS |
| VIQMEL | LGORTCHARG | VIQMEL | LGORTCHARG | T001L | Storage Locations | LGORT |
| VIQMEL | LGORTCHARG | VIQMEL | MANDT | T001L | Storage Locations | MANDT |
| VIQMEL | LGORTVORG | VIQMEL | MANDT | T001L | Storage Locations | MANDT |
| VIQMEL | LGORTVORG | VIQMEL | MAWERK | T001L | Storage Locations | WERKS |
| VIQMEL | LGORTVORG | VIQMEL | LGORTVORG | T001L | Storage Locations | LGORT |
| VIQMEL | LIFNUM | VIQMEL | MANDT | LFA1 | Vendor Master (General Section) | MANDT |
| VIQMEL | LIFNUM | VIQMEL | LIFNUM | LFA1 | Vendor Master (General Section) | LIFNR |
| VIQMEL | LS_KDAUF | VIQMEL | LS_KDAUF | VBUK | Sales Document: Header Status and Administrative Data | VBELN |
| VIQMEL | LS_KDAUF | VIQMEL | MANDT | VBUK | Sales Document: Header Status and Administrative Data | MANDT |
| VIQMEL | LS_KDPOS | VIQMEL | MANDT | VBUP | Sales Document: Item Status | MANDT |
| VIQMEL | LS_KDPOS | VIQMEL | LS_KDAUF | VBUP | Sales Document: Item Status | VBELN |
| VIQMEL | LS_KDPOS | VIQMEL | LS_KDPOS | VBUP | Sales Document: Item Status | POSNR |
| VIQMEL | LS_POSNR | VIQMEL | MANDT | VBUP | Sales Document: Item Status | MANDT |
| VIQMEL | LS_POSNR | VIQMEL | LS_VBELN | VBUP | Sales Document: Item Status | VBELN |
| VIQMEL | LS_POSNR | VIQMEL | LS_POSNR | VBUP | Sales Document: Item Status | POSNR |
| VIQMEL | LS_VBELN | VIQMEL | MANDT | VBUK | Sales Document: Header Status and Administrative Data | MANDT |
| VIQMEL | LS_VBELN | VIQMEL | LS_VBELN | VBUK | Sales Document: Header Status and Administrative Data | VBELN |
| VIQMEL | MANDT | VIQMEL | MANDT | T000 | Clients | MANDT |
| VIQMEL | MATKL | VIQMEL | MANDT | T023 | Material Groups | MANDT |
| VIQMEL | MATKL | VIQMEL | MATKL | T023 | Material Groups | MATKL |
| VIQMEL | MATNR | VIQMEL | MANDT | MARA | General Material Data | MANDT |
| VIQMEL | MATNR | VIQMEL | MATNR | MARA | General Material Data | MATNR |
| VIQMEL | MAUEH | VIQMEL | MAUEH | T006 | Units of Measurement | MSEHI |
| VIQMEL | MAUEH | VIQMEL | MANDT | T006 | Units of Measurement | MANDT |
| VIQMEL | MAWERK | VIQMEL | MANDT | T001W | Plants/Branches | MANDT |
| VIQMEL | MAWERK | VIQMEL | MAWERK | T001W | Plants/Branches | WERKS |
| VIQMEL | MGEIN | VIQMEL | MANDT | T006 | Units of Measurement | MANDT |
| VIQMEL | MGEIN | VIQMEL | MGEIN | T006 | Units of Measurement | MSEHI |
| VIQMEL | OBJNR | VIQMEL | MANDT | ONR00 | General Object Number | MANDT |
| VIQMEL | OBJNR | VIQMEL | OBJNR | ONR00 | General Object Number | OBJNR |
| VIQMEL | OBJNR_REAL | VIQMEL | MANDT | ONR00 | General Object Number | MANDT |
| VIQMEL | OBJNR_REAL | VIQMEL | OBJNR_REAL | ONR00 | General Object Number | OBJNR |
| VIQMEL | OBJNR_STAT | VIQMEL | MANDT | ONR00 | General Object Number | MANDT |
| VIQMEL | OBJNR_STAT | VIQMEL | OBJNR_STAT | ONR00 | General Object Number | OBJNR |
| VIQMEL | PPSID | VIQMEL | MANDT | CRID | CIM Resource - Entities | MANDT |
| VIQMEL | PPSID | VIQMEL | CR_OBJTY | CRID | CIM Resource - Entities | OBJTY |
| VIQMEL | PPSID | VIQMEL | PPSID | CRID | CIM Resource - Entities | OBJID |
| VIQMEL | PRDHA | VIQMEL | MANDT | T179 | Materials: Product Hierarchies | MANDT |
| VIQMEL | PRDHA | VIQMEL | PRDHA | T179 | Materials: Product Hierarchies | PRODH |
| VIQMEL | PRIOK | VIQMEL | MANDT | T356 | Priorities | MANDT |
| VIQMEL | PRIOK | VIQMEL | ARTPR | T356 | Priorities | ARTPR |
| VIQMEL | PRIOK | VIQMEL | PRIOK | T356 | Priorities | PRIOK |
| VIQMEL | PROID | VIQMEL | PROID | PRPS | WBS (Work Breakdown Structure) Element Master Data | PSPNR |
| VIQMEL | PROID | VIQMEL | MANDT | PRPS | WBS (Work Breakdown Structure) Element Master Data | MANDT |
| VIQMEL | PRUEFLOS | VIQMEL | MANDT | QALS | Inspection lot record | MANDANT |
| VIQMEL | PRUEFLOS | VIQMEL | PRUEFLOS | QALS | Inspection lot record | PRUEFLOS |
| VIQMEL | QMART | VIQMEL | QMART | TQ80 | Notification Types | QMART |
| VIQMEL | QMART | VIQMEL | MANDT | TQ80 | Notification Types | MANDT |
| VIQMEL | QMGRP | VIQMEL | MANDT | QPGR | Inspection catalog code groups | MANDT |
| VIQMEL | QMGRP | VIQMEL | QMKAT | QPGR | Inspection catalog code groups | KATALOGART |
| VIQMEL | QMGRP | VIQMEL | QMGRP | QPGR | Inspection catalog code groups | CODEGRUPPE |
| VIQMEL | QMKAT | VIQMEL | MANDT | TQ15 | Inspection catalog type index | MANDT |
| VIQMEL | QMKAT | VIQMEL | QMKAT | TQ15 | Inspection catalog type index | KATALOGART |
| VIQMEL | QMNUM | VIQMEL | MANDT | QMEL | Quality Notification | MANDT |
| VIQMEL | QMNUM | VIQMEL | QMNUM | QMEL | Quality Notification | QMNUM |
| VIQMEL | QWRNUM | VIQMEL | MANDT | QMEL | Quality Notification | MANDT |
| VIQMEL | QWRNUM | VIQMEL | QWRNUM | QMEL | Quality Notification | QMNUM |
| VIQMEL | RBNR | VIQMEL | MANDT | T352B | Technical report | MANDT |
| VIQMEL | RBNR | VIQMEL | RBNR | T352B | Technical report | RBNR |
| VIQMEL | RM_MATNR | VIQMEL | MANDT | MKAL | Production Versions of Material | MANDT |
| VIQMEL | RM_MATNR | VIQMEL | RM_MATNR | MKAL | Production Versions of Material | MATNR |
| VIQMEL | RM_MATNR | VIQMEL | RM_WERKS | MKAL | Production Versions of Material | WERKS |
| VIQMEL | RM_MATNR | VIQMEL | VERID | MKAL | Production Versions of Material | VERID |
| VIQMEL | RM_WERKS | VIQMEL | RM_MATNR | MKAL | Production Versions of Material | MATNR |
| VIQMEL | RM_WERKS | VIQMEL | RM_WERKS | MKAL | Production Versions of Material | WERKS |
| VIQMEL | RM_WERKS | VIQMEL | VERID | MKAL | Production Versions of Material | VERID |
| VIQMEL | RM_WERKS | VIQMEL | MANDT | MKAL | Production Versions of Material | MANDT |
| VIQMEL | SA_AUFNR | VIQMEL | SA_AUFNR | SAFK | Run Schedule Master Data | AUFNR |
| VIQMEL | SA_AUFNR | VIQMEL | MANDT | SAFK | Run Schedule Master Data | MANDT |
| VIQMEL | SPART | VIQMEL | MANDT | TSPA | Organizational Unit: Sales Divisions | MANDT |
| VIQMEL | SPART | VIQMEL | SPART | TSPA | Organizational Unit: Sales Divisions | SPART |
| VIQMEL | SPART_ILOA | VIQMEL | MANDT | TVTA | Organizational Unit: Sales Area(s) | MANDT |
| VIQMEL | SPART_ILOA | VIQMEL | VKORG_ILOA | TVTA | Organizational Unit: Sales Area(s) | VKORG |
| VIQMEL | SPART_ILOA | VIQMEL | VTWEG_ILOA | TVTA | Organizational Unit: Sales Area(s) | VTWEG |
| VIQMEL | SPART_ILOA | VIQMEL | SPART_ILOA | TVTA | Organizational Unit: Sales Area(s) | SPART |
| VIQMEL | STORT | VIQMEL | SWERK | T499S | Location | WERKS |
| VIQMEL | STORT | VIQMEL | STORT | T499S | Location | STAND |
| VIQMEL | STORT | VIQMEL | MANDT | T499S | Location | MANDT |
| VIQMEL | SWERK | VIQMEL | MANDT | T001W | Plants/Branches | MANDT |
| VIQMEL | SWERK | VIQMEL | SWERK | T001W | Plants/Branches | WERKS |
| VIQMEL | TEILEV | VIQMEL | MANDT | TQ81V | Usage of parts | MANDT |
| VIQMEL | TEILEV | VIQMEL | TEILEV | TQ81V | Usage of parts | TEILEV |
| VIQMEL | TPLNR | VIQMEL | MANDT | IFLOT | Functional Location (Table) | MANDT |
| VIQMEL | TPLNR | VIQMEL | TPLNR | IFLOT | Functional Location (Table) | TPLNR |
| VIQMEL | TSEGTP | VIQMEL | MANDT | TTSEGTPLH | Time Segment Template Header | CLIENT |
| VIQMEL | TSEGTP | VIQMEL | TSEGTP | TTSEGTPLH | Time Segment Template Header | TEPL |
| VIQMEL | TZONSO | VIQMEL | MANDT | TTZZ | Time zones | CLIENT |
| VIQMEL | TZONSO | VIQMEL | TZONSO | TTZZ | Time zones | TZONE |
| VIQMEL | VBELN | VIQMEL | MANDT | VBUK | Sales Document: Header Status and Administrative Data | MANDT |
| VIQMEL | VBELN | VIQMEL | VBELN | VBUK | Sales Document: Header Status and Administrative Data | VBELN |
| VIQMEL | VERID | VIQMEL | RM_WERKS | MKAL | Production Versions of Material | WERKS |
| VIQMEL | VERID | VIQMEL | VERID | MKAL | Production Versions of Material | VERID |
| VIQMEL | VERID | VIQMEL | MANDT | MKAL | Production Versions of Material | MANDT |
| VIQMEL | VERID | VIQMEL | RM_MATNR | MKAL | Production Versions of Material | MATNR |
| VIQMEL | VKBUR | VIQMEL | MANDT | TVKBZ | Org.Unit: Sales Office: Assignment to Organizational Unit | MANDT |
| VIQMEL | VKBUR | VIQMEL | VKORG | TVKBZ | Org.Unit: Sales Office: Assignment to Organizational Unit | VKORG |
| VIQMEL | VKBUR | VIQMEL | VTWEG | TVKBZ | Org.Unit: Sales Office: Assignment to Organizational Unit | VTWEG |
| VIQMEL | VKBUR | VIQMEL | SPART | TVKBZ | Org.Unit: Sales Office: Assignment to Organizational Unit | SPART |
| VIQMEL | VKBUR | VIQMEL | VKBUR | TVKBZ | Org.Unit: Sales Office: Assignment to Organizational Unit | VKBUR |
| VIQMEL | VKGRP | VIQMEL | MANDT | TVBVK | Organizational Unit: Sales Groups per Sales Office | MANDT |
| VIQMEL | VKGRP | VIQMEL | VKBUR | TVBVK | Organizational Unit: Sales Groups per Sales Office | VKBUR |
| VIQMEL | VKGRP | VIQMEL | VKGRP | TVBVK | Organizational Unit: Sales Groups per Sales Office | VKGRP |
| VIQMEL | VKORG | VIQMEL | MANDT | TVKO | Organizational Unit: Sales Organizations | MANDT |
| VIQMEL | VKORG | VIQMEL | VKORG | TVKO | Organizational Unit: Sales Organizations | VKORG |
| VIQMEL | VKORG_ILOA | VIQMEL | MANDT | TVKO | Organizational Unit: Sales Organizations | MANDT |
| VIQMEL | VKORG_ILOA | VIQMEL | VKORG_ILOA | TVKO | Organizational Unit: Sales Organizations | VKORG |
| VIQMEL | VTWEG | VIQMEL | MANDT | TVTW | Organizational Unit: Distribution Channels | MANDT |
| VIQMEL | VTWEG | VIQMEL | VTWEG | TVTW | Organizational Unit: Distribution Channels | VTWEG |
| VIQMEL | VTWEG_ILOA | VIQMEL | VTWEG_ILOA | TVKOV | Org. Unit: Distribution Channels per Sales Organization | VTWEG |
| VIQMEL | VTWEG_ILOA | VIQMEL | MANDT | TVKOV | Org. Unit: Distribution Channels per Sales Organization | MANDT |
| VIQMEL | VTWEG_ILOA | VIQMEL | VKORG_ILOA | TVKOV | Org. Unit: Distribution Channels per Sales Organization | VKORG |
| VIQMEL | WAERS | VIQMEL | MANDT | TCURC | Currency Codes | MANDT |
| VIQMEL | WAERS | VIQMEL | WAERS | TCURC | Currency Codes | WAERS |
| VIQMEL | WARPL | VIQMEL | MANDT | MPLA | Maintenance plan | MANDT |
| VIQMEL | WARPL | VIQMEL | WARPL | MPLA | Maintenance plan | WARPL |
