SAP ABAP Table VIQMSML_IFLOS (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure VIQMSML_IFLOS   Table Relationship Diagram
Short Description Generated Table for View    
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 MANDT MANDT MANDT CLNT 3   0   Client T000
2 QMNUM QMNUM QMNUM CHAR 12   0   Message Number  
3 MANUM MANUM NUM4 NUMC 4   0   Sequential Task Number  
4 IWERK IWERK WERKS CHAR 4   0   Maintenance Planning Plant T399I
5 ILOAN ILOAN ILOAN CHAR 12   0   Location and account assignment for technical object ILOA
6 ILOAI ILOAI X CHAR 1   0   ILOA Individual  
7 EQUNR EQUNR EQUNR CHAR 18   0   Equipment Number EQUI
8 BAUTL BAUTL MATNR CHAR 18   0   Assembly MARA
9 EBORT EBORT TEXT20 CHAR 20   0   Installation Point for Subitem  
10 MSAUS MSAUS XFELD CHAR 1   0   Breakdown Indicator  
11 AUSVN AUSVN DATUM DATS 8   0   Start of Malfunction (Date)  
12 AUSBS AUSBS DATUM DATS 8   0   End of Malfunction (Date)  
13 AUZTV AUZTV UHRZT TIMS 6   0   Start of Malfunction (Time)  
14 AUZTB AUZTB UHRZT TIMS 6   0   End of Malfunction (Time)  
15 AUSZT AUSZT FLTP FLTP 16   16   Breakdown Duration  
16 MAUEH MAUEH MEINS UNIT 3   0   Unit for Breakdown Duration T006
17 BTPLN BTPLN TPLNR CHAR 30   0   Functional Location Affected IFLOT
18 BEQUI BEQUI EQUNR CHAR 18   0   Equipment Affected EQUI
19 AUSWK AUSWK AUSWK CHAR 1   0   Effect on Operation T357A
20 VERFV VERFV NUM3 NUMC 3   0   Availability Before Malfunction  
21 VERFN VERFN NUM3 NUMC 3   0   Availability After Malfunction  
22 VERFM VERFM NUM3 NUMC 3   0   Availability After Completion of Task  
23 ANLZV ANLZV ANLAZ CHAR 1   0   System Condition Before Malfunction T357Z
24 ANLZN ANLZN ANLAZ CHAR 1   0   System Condition After Malfunction T357Z
25 ANLZE ANLZE ANLAZ CHAR 1   0   System Condition After Completion of Task T357Z
26 INSPK INSPK USNAM CHAR 12   0   Name of Person Responsible for Technical Inspection  
27 DATAN DATAN DATUM DATS 8   0   Date of Technical Inspection  
28 INGRP INGRP INGRP CHAR 3   0   Planner Group for Customer Service and Plant Maintenance T024I
29 QMART QMART QMART CHAR 2   0   Message Type TQ80
30 QMTXT QMTXT TEXT40 CHAR 40   0   Short Text  
31 ARTPR ARTPR ARTPR CHAR 2   0   Priority Type T356A
32 PRIOK PRIOK PRIOK CHAR 1   0   Priority T356
33 MZEIT MZEIT UHRZT TIMS 6   0   Notification Time  
34 QMDAT QMDAT DATUM DATS 8   0   Date of Notification  
35 QMNAM QMNAM USNAM CHAR 12   0   Name of declarant  
36 STRMN STRMN DATUM DATS 8   0   Desired Start Date  
37 STRUR STRUR UZEIT TIMS 6   0   Desired Start Time  
38 LTRMN LTRMN DATUM DATS 8   0   Required Finish Date  
39 LTRUR LTRUR UZEIT TIMS 6   0   Required End Date-Time  
40 WAERS WAERS WAERS CUKY 5   0   Currency Key TCURC
41 AUFNR AUFNR AUFNR CHAR 12   0   Order Number AUFK
42 MATNR MATNR MATNR CHAR 18   0   Material Number MARA
43 REVLV REVLV REVLV CHAR 2   0   Revision level  
44 KUNUM QKUNUM KUNNR CHAR 10   0   Account Number of Customer KNA1
45 FEKNZ FEKNZ CHAR1 CHAR 1   0   Error Records Exist  
46 MAKNZ MAKNZ CHAR1 CHAR 1   0   Task Records Exist  
47 QMDAB QMDAB DATUM DATS 8   0   Date for Completion of Notification  
48 QMZAB QMZAB UZEIT TIMS 6   0   Completion Time of Notification  
49 RBNR RBNR RBNR CHAR 9   0   Report layout T352B
50 RBNRI RBNRI RBNRI CHAR 1   0   Origin of Notifications Catalog Profile  
51 INDTX INDLTX CHAR1 CHAR 1   0   Object Long Text Available  
52 KZMLA KZMLA CHAR1 CHAR 1   0   Primary language indicator for text segment  
53 OBJNR QMOBJNR J_OBJNR CHAR 22   0   Object Number for Status Management ONR00
54 HERKZ HERKZ HERKZ CHAR 2   0   Origin Indicator for Notification  
55 BEZDT BEZDT DATUM DATS 8   0   Notification Reference Date  
56 BEZUR BEZUR_D UZEIT TIMS 6   0   Notification Reference Time  
57 TPLNR ILOM_STRNO ILOM_STRNO CHAR 40   0   Functional location label  
58 ABCKZ ABCKZ ABCKZ CHAR 1   0   ABC Indicator for Technical Object T370C
59 EQFNR EQFNR CHAR30 CHAR 30   0   Sort Field  
60 SWERK SWERK WERKS CHAR 4   0   Maintenance Plant T001W
61 STORT PMLOC AP_STAND CHAR 10   0   Location of maintenance object T499S
62 MSGRP RAUMNR CHAR8 CHAR 8   0   Room  
63 BEBER BEBER BEBER CHAR 3   0   Organizational Area T357
64 PPSID PPSID CR_OBJID NUMC 8   0   Object ID of PP work center CRID
65 GSBER GSBER GSBER CHAR 4   0   Business Area TGSB
66 KOKRS KOKRS CACCD CHAR 4   0   Controlling Area TKA01
67 KOSTL KOSTL KOSTL CHAR 10   0   Cost Center CSKS
68 PROID PS_PSP_PNR PS_POSNR NUMC 8   0   Work Breakdown Structure Element (WBS Element) PRPS
69 ANLNR ANLN1 ANLN1 CHAR 12   0   Main Asset Number ANLH
70 ANLUN ANLN2 ANLN2 CHAR 4   0   Asset Subnumber ANLA
71 DAUFN DAUFN AUFNR CHAR 12   0   Standing order number AUFK
72 KAUFN ILOM_ORDST AUFNR CHAR 12   0   Settlement order AUFK
73 BUKRS BUKRS BUKRS CHAR 4   0   Company Code T001
74 CR_OBJTY CR_OBJTY CR_OBJTY CHAR 2   0   Object types of the CIM resource  
75 MNKAT MAKAT QKATART CHAR 1   0   Catalog Type - Tasks TQ15
76 MNGRP MAGRP QCODEGRP CHAR 8   0   Code group - Tasks QPGR
77 MNCOD MNCOD QCODE CHAR 4   0   Task code  
78 MNVER QVERSNR QVERSNR CHAR 6   0   Version Number  
79 FOLGEACT QMFOLACT QFOLGEAKTI CHAR 8   0   Follow-Up Action for Task TQ07
80 FOLACTPROT QMFOAPROT QKZ CHAR 1   0   Log for Follow-Up Action  
81 MATXT MATXT TEXT40 CHAR 40   0   Short text for task  
82 PSTER PSTER DATUM DATS 8   0   Planned start date  
83 PETER PETER DATUM DATS 8   0   Planned finish date  
84 OBJNR_M QMOBJNR J_OBJNR CHAR 22   0   Object Number for Status Management ONR00
85 INDTX_M INDLTX CHAR1 CHAR 1   0   Object Long Text Available  
86 KZMLA_M KZMLA CHAR1 CHAR 1   0   Primary language indicator for text segment  
87 PSTUR PSTUR UZEIT TIMS 6   0   Planned Start Time for Task  
88 PETUR PETUR UZEIT TIMS 6   0   Planned finish time for task  
89 ERLNAM QMSMERLNAM USNAM CHAR 12   0   Person who carried out the task  
90 ERLDAT QMSMERLDAT DATUM DATS 8   0   Date on which the task was carried out  
91 WDVDAT QMSMWDVDAT DATUM DATS 8   0   Date on which the task was resubmitted  
92 ERNAM ERNAM USNAM CHAR 12   0   Name of Person who Created the Object  
93 ERDAT ERDAT DATUM DATS 8   0   Date on which the record was created  
94 AENAM AENAM USNAM CHAR 12   0   Name of Person Who Changed Object  
95 AEDAT AEDAT DATUM DATS 8   0   Last Changed On  
96 ADRNR_ILOA AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number ADRC
97 ADRNRI INH_ADRNRI INHER CHAR 1   0   Data origin for address field  
98 FENUM FELFD FELFD NUMC 4   0   Item Number in Item Record QMFE
99 URNUM URNUM NUM4 NUMC 4   0   Sequential Number for Cause  
100 ERZEIT ERZEIT UHRZT TIMS 6   0   Time, at Which Record Was Added  
101 AEZEIT AEZEIT UHRZT TIMS 6   0   Time of Change  
102 QSMNUM QSMNUM NUMC04 NUMC 4   0   Sort number for task  
103 VBELN KDAUF VBELN CHAR 10   0   Sales Order Number VBUK
104 BSTNK BSTKD BSTKD CHAR 35   0   Customer purchase order number  
105 BSTDK BSTDK DATUM DATS 8   0   Customer purchase order date  
106 ARBPL LGWID CR_OBJID NUMC 8   0   Object ID of the Work Center  
107 QMCOD QMCOD QCODE CHAR 4   0   Coding  
108 QMGRP QMGRP QCODEGRP CHAR 8   0   Code group - coding QPGR
109 QMKAT QMKAT QKATART CHAR 1   0   Catalog type - coding TQ15
110 SPART SPART SPART CHAR 2   0   Division TSPA
111 VKORG VKORG VKORG CHAR 4   0   Sales Organization TVKO
112 VTWEG VTWEG VTWEG CHAR 2   0   Distribution Channel TVTW
113 ADRNR CADNR CADRNR CHAR 10   0   Addresses: Address Number  
114 ERLZEIT QMSMERLTIM UZEIT TIMS 6   0   Time at which the task was completed  
115 PARVW QMSM_PARVW PARVW CHAR 2   0   Function of Person Responsible for Task TPAR
116 PARNR QMSM_PARNR I_PARNR CHAR 12   0   Person responsible for the task (partner number)  
117 OWNER ILOM_OWNER ILOM_OWNER CHAR 1   0   Object reference indicator  
118 FEART QFEART QFEART CHAR 8   0   Report Type for Defects Recording TQ86
119 KDAUF VBELN_VA VBELN CHAR 10   0   Sales Document VBUK
120 KDPOS POSNR_VA POSNR NUMC 6   0   Sales Document Item VBUP
121 KZLOESCH KZLOESCH CHAR1 CHAR 1   0   Delete Data Record  
122 VKBUR VKBUR VKBUR CHAR 4   0   Sales office TVKBZ
123 VKGRP VKGRP VKGRP CHAR 3   0   Sales group TVBVK
124 SERIALNR GERNR GERNR CHAR 18   0   Serial Number  
125 DEVICEID DEVICEID DEVICEID CHAR 40   0   Additional Device Data  
126 ALKEY ILOM_ALKEY ILOM_ALKEY CHAR 1   0   Labeling system for functional locations IFLOALT
127 VERSN ILOM_VERSN NUMC3 NUMC 3   0   Version of functional location label  
128 TPLNR_INT TPLNR TPLNR CHAR 30   0   Functional Location IFLOT
129 PHASE QM_PHASE QM_PHASE CHAR 1   0   Notification Processing Phase  
130 UII UII_CHAR72 UII_CHAR72 CHAR 72   0   Unique Item Identifier  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 VIQMSML_IFLOS ABCKZ T370C ABCKZ REF C CN
2 VIQMSML_IFLOS ADRNR_ILOA ADRC ADDRNUMBER REF 1 CN
3 VIQMSML_IFLOS ALKEY IFLOALT ALKEY KEY 1 CN
4 VIQMSML_IFLOS ANLNR ANLH ANLN1 REF C CN
5 VIQMSML_IFLOS ANLUN ANLA ANLN2 REF C CN
6 VIQMSML_IFLOS ANLZE T357Z ANLAZ REF C CN
7 VIQMSML_IFLOS ANLZN T357Z ANLAZ REF C CN
8 VIQMSML_IFLOS ANLZV T357Z ANLAZ REF C CN
9 VIQMSML_IFLOS ARTPR T356A ARTPR REF C CN
10 VIQMSML_IFLOS AUFNR AUFK AUFNR REF C CN
11 VIQMSML_IFLOS AUSWK T357A AUSWK REF C CN
12 VIQMSML_IFLOS BAUTL MARA MATNR REF C CN
13 VIQMSML_IFLOS BEBER T357 BEBER REF C CN
14 VIQMSML_IFLOS BEQUI EQUI EQUNR REF C CN
15 VIQMSML_IFLOS BTPLN IFLOT TPLNR REF C CN
16 VIQMSML_IFLOS BUKRS T001 BUKRS REF C CN
17 VIQMSML_IFLOS DAUFN AUFK AUFNR REF C CN
18 VIQMSML_IFLOS EQUNR EQUI EQUNR REF C CN
19 VIQMSML_IFLOS FEART TQ86 FEART REF C CN
20 VIQMSML_IFLOS FENUM QMFE FENUM    
21 VIQMSML_IFLOS FOLGEACT TQ07 FOLGEAKTI C CN
22 VIQMSML_IFLOS GSBER TGSB GSBER REF C CN
23 VIQMSML_IFLOS ILOAN ILOA ILOAN REF 1 CN
24 VIQMSML_IFLOS INGRP T024I INGRP REF C CN
25 VIQMSML_IFLOS IWERK T399I IWERK REF C CN
26 VIQMSML_IFLOS KAUFN AUFK AUFNR REF C CN
27 VIQMSML_IFLOS KDAUF VBUK VBELN    
28 VIQMSML_IFLOS KDPOS VBUP POSNR    
29 VIQMSML_IFLOS KOKRS TKA01 KOKRS REF C CN
30 VIQMSML_IFLOS KOSTL CSKS KOSTL REF C CN
31 VIQMSML_IFLOS KUNUM KNA1 KUNNR REF C CN
32 VIQMSML_IFLOS MANDT T000 MANDT KEY 1 CN
33 VIQMSML_IFLOS MATNR MARA MATNR REF C CN
34 VIQMSML_IFLOS MAUEH T006 MSEHI REF C CN
35 VIQMSML_IFLOS MNGRP QPGR CODEGRUPPE REF C CN
36 VIQMSML_IFLOS MNKAT TQ15 KATALOGART REF C CN
37 VIQMSML_IFLOS OBJNR ONR00 OBJNR REF C CN
38 VIQMSML_IFLOS OBJNR_M ONR00 OBJNR REF C CN
39 VIQMSML_IFLOS PARVW TPAR PARVW    
40 VIQMSML_IFLOS PPSID CRID OBJID REF C CN
41 VIQMSML_IFLOS PRIOK T356 PRIOK REF C CN
42 VIQMSML_IFLOS PROID PRPS PSPNR C CN
43 VIQMSML_IFLOS QMART TQ80 QMART REF C CN
44 VIQMSML_IFLOS QMGRP QPGR CODEGRUPPE REF C CN
45 VIQMSML_IFLOS QMKAT TQ15 KATALOGART    
46 VIQMSML_IFLOS RBNR T352B RBNR REF C CN
47 VIQMSML_IFLOS SPART TSPA SPART    
48 VIQMSML_IFLOS STORT T499S STAND REF C CN
49 VIQMSML_IFLOS SWERK T001W WERKS REF 1 CN
50 VIQMSML_IFLOS TPLNR_INT IFLOT TPLNR KEY 1 CN
51 VIQMSML_IFLOS VBELN VBUK VBELN    
52 VIQMSML_IFLOS VKBUR TVKBZ VKBUR REF C CN
53 VIQMSML_IFLOS VKGRP TVBVK VKGRP REF C CN
54 VIQMSML_IFLOS VKORG TVKO VKORG    
55 VIQMSML_IFLOS VTWEG TVTW VTWEG    
56 VIQMSML_IFLOS WAERS TCURC WAERS REF C CN
History
Last changed by/on SAP  20130529 
SAP Release Created in