SAP ABAP Table RFC_VIQMEL (PM/SM/QM Notifications: I/O Data for Creating Notification)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷
CRM-MSE (Application Component) Mobile Service
⤷
IWOC (Package) Application Development R/3 Work Order Cycle
⤷
⤷
Basic Data
| Table Category | INTTAB | Structure |
| Structure | RFC_VIQMEL |
|
| Short Description | PM/SM/QM Notifications: I/O Data for Creating Notification |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | ||
| Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
| |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|---|---|---|---|---|---|---|---|---|---|
| 1 | |
0 | 0 | PM/SM/QM Notifications: I/O data for creating notification | |||||
| 2 | |
QMART | QMART | CHAR | 2 | 0 | Message Type | * | |
| 3 | |
QMNUM | QMNUM | CHAR | 12 | 0 | Message Number | * | |
| 4 | |
EQUNR | EQUNR | CHAR | 18 | 0 | Equipment Number | * | |
| 5 | |
TPLNR | TPLNR | CHAR | 30 | 0 | Functional Location | * | |
| 6 | |
BAUTL | MATNR | CHAR | 18 | 0 | Assembly | * | |
| 7 | |
GERNR | GERNR | CHAR | 18 | 0 | Serial Number | ||
| 8 | |
MATNR | MATNR | CHAR | 18 | 0 | Material Number | * | |
| 9 | |
QMAWERKS | WERKS | CHAR | 4 | 0 | Plant for Material | * | |
| 10 | |
REVLV | REVLV | CHAR | 2 | 0 | Revision level | ||
| 11 | |
CHARG_D | CHARG | CHAR | 10 | 0 | Batch Number | * | |
| 12 | |
QLGORTCHAR | LGORT | CHAR | 4 | 0 | Storage Location of Batch | * | |
| 13 | |
SPART | SPART | CHAR | 2 | 0 | Division | * | |
| 14 | |
VKORG | VKORG | CHAR | 4 | 0 | Sales Organization | * | |
| 15 | |
VTWEG | VTWEG | CHAR | 2 | 0 | Distribution Channel | * | |
| 16 | |
VKBUR | VKBUR | CHAR | 4 | 0 | Sales office | * | |
| 17 | |
VKGRP | VKGRP | CHAR | 3 | 0 | Sales group | * | |
| 18 | |
KUNUM | KUNNR | CHAR | 10 | 0 | Customer Number | * | |
| 19 | |
PARNR | PARNR | NUMC | 10 | 0 | Number of contact person | ||
| 20 | |
EKORG | EKORG | CHAR | 4 | 0 | Purchasing organization | * | |
| 21 | |
BKGRP | EKGRP | CHAR | 3 | 0 | Purchasing Group | * | |
| 22 | |
LIFNUM | LIFNR | CHAR | 10 | 0 | Vendor Account Number | * | |
| 23 | |
QLIFNR | LIFNR | CHAR | 10 | 0 | Number of Manufacturer | * | |
| 24 | |
QMTXT | TEXT40 | CHAR | 40 | 0 | Short Text | ||
| 25 | |
PRIOK | PRIOK | CHAR | 1 | 0 | Priority | * | |
| 26 | |
STRMN | DATUM | DATS | 8 | 0 | Desired Start Date | ||
| 27 | |
STRUR | UZEIT | TIMS | 6 | 0 | Desired Start Time | ||
| 28 | |
LTRMN | DATUM | DATS | 8 | 0 | Required Finish Date | ||
| 29 | |
LTRUR | UZEIT | TIMS | 6 | 0 | Required End Date-Time | ||
| 30 | |
DEVICEID | DEVICEID | CHAR | 40 | 0 | Additional Device Data | ||
| 31 | |
QPRODDAT | DATUM | DATS | 8 | 0 | Production Date | ||
| 32 | |
SCREENTY | CHAR4 | CHAR | 4 | 0 | SCREEN TYPE: for order-order category (see domain) | ||
| 33 | |
QARBPWERKS | WERKS | CHAR | 4 | 0 | Plant for Work Center | * | |
| 34 | |
LGWID | CR_OBJID | NUMC | 8 | 0 | Object ID of the Work Center | * | |
| 35 | |
CR_OBJTY | CR_OBJTY | CHAR | 2 | 0 | Object types of the CIM resource | ||
| 36 | |
QWRNUM | QMNUM | CHAR | 12 | 0 | Reference Notification Number | * | |
| 37 | |
QMEXTNR | CHAR020 | CHAR | 20 | 0 | External Reference Number | ||
| 38 | |
KDAUF | VBELN | CHAR | 10 | 0 | Sales Order Number | * | |
| 39 | |
KDPOS | NUM06 | NUMC | 6 | 0 | Item number in Sales Order | ||
| 40 | |
BSTKD | BSTKD | CHAR | 35 | 0 | Customer purchase order number | ||
| 41 | |
BSTDK | DATUM | DATS | 8 | 0 | Customer purchase order date | ||
| 42 | |
VBELN_VL | VBELN | CHAR | 10 | 0 | Delivery | * | |
| 43 | |
QPOSNR_VL | POSNR | NUMC | 6 | 0 | Delivery Item | * | |
| 44 | |
MATNR_KU | IDNEX | CHAR | 35 | 0 | Customer Material Number | ||
| 45 | |
EBELN | EBELN | CHAR | 10 | 0 | Purchasing Document Number | * | |
| 46 | |
QEBELP | EBELP | NUMC | 5 | 0 | Item Number of Purchasing Document | * | |
| 47 | |
MJAHR | GJAHR | NUMC | 4 | 0 | Year of material document | ||
| 48 | |
MBLNR | BELNR | CHAR | 10 | 0 | Number of Material Document | ||
| 49 | |
QMBLPO | MBLPO | NUMC | 4 | 0 | Item in Material Document | ||
| 50 | |
IDNLF | IDNEX | CHAR | 35 | 0 | Material Number Used by Vendor | ||
| 51 | |
LICHN | LICHN | CHAR | 15 | 0 | Vendor Batch Number | ||
| 52 | |
EMATN | MATNR | CHAR | 18 | 0 | Material number corresponding to manufacturer part number | * | |
| 53 | |
VERID | VERID | CHAR | 4 | 0 | Production Version | * | |
| 54 | |
RM_MATNR | MATNR | CHAR | 18 | 0 | Material number of the production version | * | |
| 55 | |
RM_WERKS | WERKS | CHAR | 4 | 0 | Plant of production version | * | |
| 56 | |
FERTAUFNR | AUFNR | CHAR | 12 | 0 | Order Number (Production Order) | * | |
| 57 | |
FERTAUFPL | AUFPL | NUMC | 10 | 0 | Plan Number for Operations in Order (Production Order) | ||
| 58 | |
QLFNKN | KNTNR | NUMC | 8 | 0 | Current Node Number from Order Counter APLZL | ||
| 59 | |
IWERK | WERKS | CHAR | 4 | 0 | Maintenance Planning Plant | * | |
| 60 | |
INGRP | INGRP | CHAR | 3 | 0 | Planner Group for Customer Service and Plant Maintenance | * | |
| 61 | |
MSAUS | XFELD | CHAR | 1 | 0 | Breakdown Indicator | ||
| 62 | |
AUSVN | DATUM | DATS | 8 | 0 | Start of Malfunction (Date) | ||
| 63 | |
AUZTV | UHRZT | TIMS | 6 | 0 | Start of Malfunction (Time) | ||
| 64 | |
QMNAM | USNAM | CHAR | 12 | 0 | Name of declarant | ||
| 65 | |
QMDAT | DATUM | DATS | 8 | 0 | Date of Notification | ||
| 66 | |
MZEIT | UHRZT | TIMS | 6 | 0 | Notification Time | ||
| 67 | |
QMKAT | QKATART | CHAR | 1 | 0 | Catalog type - coding | * | |
| 68 | |
QMGRP | QCODEGRP | CHAR | 8 | 0 | Code group - coding | * | |
| 69 | |
QMCOD | QCODE | CHAR | 4 | 0 | Coding | * | |
| 70 | |
QSCENARIO | QSCENARIO | CHAR | 4 | 0 | Key for a Scenario | * | |
| 71 | |
MGEIG | MENGE | QUAN | 13 | 3 | Defective Quantity (Internal) | ||
| 72 | |
MGFRD | MENGE | QUAN | 13 | 3 | Defective Quantity (External) | ||
| 73 | |
QBZMNG | MENGE | QUAN | 13 | 3 | General Reference Quantity | ||
| 74 | |
RKMNG | MENGE | QUAN | 13 | 3 | Complaint Quantity | ||
| 75 | |
RGMNG | MENGE | QUAN | 13 | 3 | Return Delivery Quantity | ||
| 76 | |
RKDAT | DATUM | DATS | 8 | 0 | Date of Return Delivery | ||
| 77 | |
WARPL | WARPL | CHAR | 12 | 0 | Maintenance Plan | * | |
| 78 | |
ABNUM | ABNUM | INT4 | 10 | 0 | Maintenance Plan Call Number | ||
| 79 | |
WAPOS | POSNU | CHAR | 16 | 0 | Maintenance item | ||
| 80 | |
VBELN_VA | VBELN | CHAR | 10 | 0 | Sales Document | * | |
| 81 | |
POSNR_VA | POSNR | NUMC | 6 | 0 | Sales Document Item | * | |
| 82 | |
AUSBS | DATUM | DATS | 8 | 0 | End of Malfunction (Date) | ||
| 83 | |
AUZTB | UHRZT | TIMS | 6 | 0 | End of Malfunction (Time) | ||
| 84 | |
AUSZT | FLTP | FLTP | 16 | 16 | Breakdown Duration | ||
| 85 | |
MAUEH | MEINS | UNIT | 3 | 0 | Unit for Breakdown Duration | * | |
| 86 | |
SWO_OBJTYP | OJ_NAME | CHAR | 10 | 0 | Object Type | * | |
| 87 | |
SWO_TYPEID | SWO_TYPEID | CHAR | 70 | 0 | Object key | ||
| 88 | |
BINRELTYP | BINRELTYP | CHAR | 4 | 0 | Relationship type | * | |
| 89 | |
0 | 0 | OSS-Relevant Attributes/Fields | |||||
| 90 | |
/SAPSMOSS/R3INSTN | /SAPSMOSS/R3INSTN | CHAR | 10 | 0 | Installation number | /SAPSMOSS/INSTN | |
| 91 | |
/SAPSMOSS/MNUMM | /SAPSMOSS/MNUMM | NUMC | 24 | 0 | SAPNet notification number | ||
| 92 | |
/SAPSMOSS/OSSYS | /SAPSMOSS/OSSYS | CHAR | 10 | 0 | Operating system and version | /SAPSMOSS/OSYS | |
| 93 | |
/SAPSMOSS/DBSYS | /SAPSMOSS/DBSYS | CHAR | 10 | 0 | Database system | /SAPSMOSS/DBSY | |
| 94 | |
/SAPSMOSS/R3REL | /SAPSMOSS/R3REL | CHAR | 10 | 0 | R/3 Release | /SAPSMOSS/REL | |
| 95 | |
/SAPSMOSS/R3COMP | /SAPSMOSS/R3COMP | CHAR | 20 | 0 | Area | ||
| 96 | |
/SAPSMOSS/FRONTEND | /SAPSMOSS/FRONTEND | CHAR | 10 | 0 | Frontend | /SAPSMOSS/FRNT | |
| 97 | |
/SAPSMOSS/R3SYSTYPE | /SAPSMOSS/R3SYSTYPE | CHAR | 1 | 0 | R/3 System type | /SAPSMOSS/SYST | |
| 98 | |
/SAPSMOSS/R3ADDID | /SAPSMOSS/R3ADDID | CHAR | 10 | 0 | Add-on ID | /SAPSMOSS/ADDID | |
| 99 | |
/SAPSMOSS/R3ADDREL | /SAPSMOSS/R3ADDREL | CHAR | 10 | 0 | Add-On Release | /SAPSMOSS/ADDRL | |
| 100 | |
/SAPSMOSS/NSTSTMP | TZNTIMESTP | NUMC | 14 | 0 | SAPNet time stamp | ||
| 101 | |
/SAPSMOSS/STATUS | /SAPSMOSS/STATUS | CHAR | 1 | 0 | Status of R/3 notification in SAPNet | /SAPSMOSS/STAT | |
| 102 | |
/SAPSMOSS/ERDAT | DATUM | DATS | 8 | 0 | Date on which notification was completed at SAP | ||
| 103 | |
/SAPSMOSS/ERZEIT | UHRZT | TIMS | 6 | 0 | Time when notification was completed at SAP | ||
| 104 | |
SYSYSID | SYCHAR08 | CHAR | 8 | 0 | Name of SAP System | ||
| 105 | |
SYMANDT | MANDT | CLNT | 3 | 0 | Client ID | * | |
| 106 | |
0 | 0 | Additional Claim Management Data | |||||
| 107 | |
PS_POSNR | PS_POSNR | NUMC | 8 | 0 | WBS Element | * | |
| 108 | |
PS_COSTS | WERTV7 | CURR | 13 | 2 | Estimated Costs for a Claim | ||
| 109 | |
COSTS_CLAIM | WERTV7 | CURR | 13 | 2 | Costs Claimed | ||
| 110 | |
COSTS_RESULT | WERTV7 | CURR | 13 | 2 | Costs Accepted | ||
| 111 | |
PS_CHANCE | PS_CHANCE | NUMC | 2 | 0 | Chance of Completing a Claim | ||
| 112 | |
PS_OPPONENT | OPPONENT | CHAR | 2 | 0 | Partner Type | ||
| 113 | |
KOKRS | CACCD | CHAR | 4 | 0 | Controlling Area | TKA01 | |
| 114 | |
J_OBJNR_REAL | J_OBJNR | CHAR | 22 | 0 | Object number of real CO account assignment | ONR00 | |
| 115 | |
OBJNR_N1 | J_OBJNR | CHAR | 22 | 0 | Auxiliary account assignment 1 | ONR00 | |
| 116 | |
CK_KALVAR | KLVAR | CHAR | 4 | 0 | Costing Variant for Postprocessing with Unit Costing | TCK03 | |
| 117 | |
CK_KALNR | CK_KALNR | NUMC | 12 | 0 | Cost Estimate Number for Cost Est. w/o Qty Structure | * | |
| 118 | |
WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
| 119 | |
PRODH_D | PRODH | CHAR | 18 | 0 | Product Hierarchy | * | |
| 120 | |
CADNR | CADRNR | CHAR | 10 | 0 | Addresses: Address Number | * | |
| 121 | |
BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
| 122 | |
MATKL | MATKL | CHAR | 9 | 0 | Material Group | * | |
| 123 | |
ILOAN | ILOAN | CHAR | 12 | 0 | Location and account assignment for technical object | * | |
| 124 | |
ILOAI | X | CHAR | 1 | 0 | ILOA Individual | ||
| 125 | |
SWERK | WERKS | CHAR | 4 | 0 | Maintenance Plant | * | |
| 126 | |
PMLOC | AP_STAND | CHAR | 10 | 0 | Location of maintenance object | * | |
| 127 | |
RAUMNR | CHAR8 | CHAR | 8 | 0 | Room | ||
| 128 | |
BEBER | BEBER | CHAR | 3 | 0 | Organizational Area | * | |
| 129 | |
PPSID | CR_OBJID | NUMC | 8 | 0 | Object ID of PP work center | * | |
| 130 | |
ABCKZ | ABCKZ | CHAR | 1 | 0 | ABC Indicator for Technical Object | * | |
| 131 | |
EQFNR | CHAR30 | CHAR | 30 | 0 | Sort Field | ||
| 132 | |
GSBER | GSBER | CHAR | 4 | 0 | Business Area | * | |
| 133 | |
KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | * | |
| 134 | |
PS_PSP_PNR | PS_POSNR | NUMC | 8 | 0 | Work Breakdown Structure Element (WBS Element) | * | |
| 135 | |
ANLN1 | ANLN1 | CHAR | 12 | 0 | Main Asset Number | * | |
| 136 | |
ANLN2 | ANLN2 | CHAR | 4 | 0 | Asset Subnumber | * | |
| 137 | |
MGEIN | MEINS | UNIT | 3 | 0 | Unit of Measure | * | |
| 138 | |
0 | 0 | Fields for /ISDFPS/ Enhancements | |||||
| 139 | |
J_OBJNR | J_OBJNR | CHAR | 22 | 0 | Object number | * | |
| 140 | |
LOGSYSTEM | LOGSYS | CHAR | 10 | 0 | Logical System | * | |
| 141 | |
/ISDFPS/MEQUI | EQUNR | CHAR | 18 | 0 | Master Equipment | * | |
| 142 | |
0 | 0 | Logbook fields | |||||
| 143 | |
BTPLN | TPLNR | CHAR | 30 | 0 | Functional Location Affected | * | |
| 144 | |
BEQUI | EQUNR | CHAR | 18 | 0 | Equipment Affected | * | |
| 145 | |
0 | 0 | Customer fields for table RIQS5 | |||||
| 146 | |
PLNTY | PLNTY | CHAR | 1 | 0 | Task List Type | * | |
| 147 | |
PLNNR | PLNNR | CHAR | 8 | 0 | Key for Task List Group | ||
| 148 | |
PLNAL | ALTNR | CHAR | 2 | 0 | Group Counter | ||
| 149 | |
0 | 0 | Technical Object/Work Center + Hierarchy Shift Note | |||||
| 150 | |
CR_OBJTY | CR_OBJTY | CHAR | 2 | 0 | Object types of the CIM resource | ||
| 151 | |
CR_OBJID | CR_OBJID | NUMC | 8 | 0 | Object ID of the resource | * | |
| 152 | |
TPLNR | TPLNR | CHAR | 30 | 0 | Functional Location | * | |
| 153 | |
EQUNR | EQUNR | CHAR | 18 | 0 | Equipment Number | * | |
| 154 | |
COCF_SRN_ORIGIN | COCF_SRN_ORIGIN | NUMC | 2 | 0 | Origin or Use of Shift Note or Report | ||
| 155 | |
0 | 0 | IUID Append | |||||
| 156 | |
UII_CHAR72 | UII_CHAR72 | CHAR | 72 | 0 | Unique Item Identifier | ||
| 157 | |
0 | 0 | Enhancements for PAMS | |||||
| 158 | |
CHAR01 | CHAR1 | CHAR | 1 | 0 | Character Field Length 1 | ||
| 159 | |
PAMS_ATSTF | TZNTSTMPS | DEC | 15 | 0 | Actual Start Time | ||
| 160 | |
PAMS_ATSTT | TZNTSTMPS | DEC | 15 | 0 | Actual End Time | ||
| 161 | |
PAMS_PTSTT | TZNTSTMPS | DEC | 15 | 0 | Planned Time Stamp (to) | ||
| 162 | |
PAMS_PTSTF | TZNTSTMPS | DEC | 15 | 0 | Planned Time Stamp (from) | ||
| 163 | |
0 | 0 | Revision | |||||
| 164 | |
REVNI | REVNI | CHAR | 8 | 0 | Revision of Plant Maintenance and Customer Service | * | |
| 165 | |
0 | 0 | RIQS5 Append for RPLM | |||||
| 166 | |
QPLOS | QPLOS | NUMC | 12 | 0 | Inspection Lot Number | * | |
| 167 | |
INDLTX | CHAR1 | CHAR | 1 | 0 | Object Long Text Available | ||
| 168 | |
KZMLA | CHAR1 | CHAR | 1 | 0 | Primary language indicator for text segment | ||
| 169 | |
QMOBJNR | J_OBJNR | CHAR | 22 | 0 | Object Number for Status Management | * |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
| 1 | RFC_VIQMEL | /SAPSMOSS/ADDID | |
|
|||
| 2 | RFC_VIQMEL | /SAPSMOSS/ADDREL | |
|
|||
| 3 | RFC_VIQMEL | /SAPSMOSS/DBSYS | |
|
REF | 1 | CN |
| 4 | RFC_VIQMEL | /SAPSMOSS/FRONT | |
|
REF | ||
| 5 | RFC_VIQMEL | /SAPSMOSS/INSTN | |
|
REF | 1 | CN |
| 6 | RFC_VIQMEL | /SAPSMOSS/OSSYS | |
|
REF | 1 | CN |
| 7 | RFC_VIQMEL | /SAPSMOSS/REL | |
|
REF | 1 | CN |
| 8 | RFC_VIQMEL | /SAPSMOSS/STATUS | |
|
|||
| 9 | RFC_VIQMEL | /SAPSMOSS/SYSTYP | |
|
REF | 1 | CN |
| 10 | RFC_VIQMEL | KALVAR | |
|
REF | ||
| 11 | RFC_VIQMEL | KOKRS | |
|
REF | C | CN |
| 12 | RFC_VIQMEL | OBJNR_REAL | |
|
REF | ||
| 13 | RFC_VIQMEL | OBJNR_STAT | |
|
REF |
History
| Last changed by/on | SAP | 20130529 |
| SAP Release Created in |