SAP ABAP Table VIQMAML_IFLOS (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure VIQMAML_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 AKNUM NUM4 NUMC 4   0   Consecutive Number of Activity  
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 ADRNR_ILOA AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number ADRC
76 ADRNRI INH_ADRNRI INHER CHAR 1   0   Data origin for address field  
77 VBELN KDAUF VBELN CHAR 10   0   Sales Order Number VBUK
78 BSTNK BSTKD BSTKD CHAR 35   0   Customer purchase order number  
79 BSTDK BSTDK DATUM DATS 8   0   Customer purchase order date  
80 ARBPL LGWID CR_OBJID NUMC 8   0   Object ID of the Work Center  
81 QMCOD QMCOD QCODE CHAR 4   0   Coding  
82 QMGRP QMGRP QCODEGRP CHAR 8   0   Code group - coding QPGR
83 QMKAT QMKAT QKATART CHAR 1   0   Catalog type - coding TQ15
84 SPART SPART SPART CHAR 2   0   Division TSPA
85 VKORG VKORG VKORG CHAR 4   0   Sales Organization TVKO
86 VTWEG VTWEG VTWEG CHAR 2   0   Distribution Channel TVTW
87 ADRNR CADNR CADRNR CHAR 10   0   Addresses: Address Number  
88 OWNER ILOM_OWNER ILOM_OWNER CHAR 1   0   Object reference indicator  
89 FEART QFEART QFEART CHAR 8   0   Report Type for Defects Recording TQ86
90 KDAUF VBELN_VA VBELN CHAR 10   0   Sales Document VBUK
91 KDPOS POSNR_VA POSNR NUMC 6   0   Sales Document Item VBUP
92 FENUM FELFD FELFD NUMC 4   0   Item Number in Item Record QMFE
93 URNUM URNUM NUM4 NUMC 4   0   Sequential Number for Cause  
94 MNKAT MFKAT QKATART CHAR 1   0   Catalog Type - Actions TQ15
95 MNGRP MFGRP QCODEGRP CHAR 8   0   Code group - Activities QPGR
96 MNCOD MFCOD QCODE CHAR 4   0   Action Code  
97 MNVER QVERSNR QVERSNR CHAR 6   0   Version Number  
98 MATXT MFTEXT TEXT40 CHAR 40   0   Action Text  
99 ERNAM ERNAM USNAM CHAR 12   0   Name of Person who Created the Object  
100 ERDAT ERDAT DATUM DATS 8   0   Date on which the record was created  
101 AENAM AENAM USNAM CHAR 12   0   Name of Person Who Changed Object  
102 AEDAT AEDAT DATUM DATS 8   0   Last Changed On  
103 MAKLS MAKLS KLASSE CHAR 18   0   Task Class  
104 KLAKZ KLAKZ CHAR1 CHAR 1   0   Indicator: Classification exists  
105 PSTER PSTERMA DATUM DATS 8   0   Start Date  
106 PETER PETERMA DATUM DATS 8   0   End Date  
107 INDTX_M INDLTX CHAR1 CHAR 1   0   Object Long Text Available  
108 KZMLA_M KZMLA CHAR1 CHAR 1   0   Primary language indicator for text segment  
109 MNGFA MNGFA NUMC3 NUMC 3   0   Quantity factor for actions  
110 PSTUR PSTURMA UZEIT TIMS 6   0   Start Time of Activity  
111 PETUR PETURMA UZEIT TIMS 6   0   End Time of Activity  
112 ERZEIT ERZEIT UHRZT TIMS 6   0   Time, at Which Record Was Added  
113 AEZEIT AEZEIT UHRZT TIMS 6   0   Time of Change  
114 KZLOESCH KZLOESCH CHAR1 CHAR 1   0   Delete Data Record  
115 QMANUM QMANUM NUMC04 NUMC 4   0   Sort Number for Activity  
116 VKBUR VKBUR VKBUR CHAR 4   0   Sales office TVKBZ
117 VKGRP VKGRP VKGRP CHAR 3   0   Sales group TVBVK
118 SERIALNR GERNR GERNR CHAR 18   0   Serial Number  
119 DEVICEID DEVICEID DEVICEID CHAR 40   0   Additional Device Data  
120 ALKEY ILOM_ALKEY ILOM_ALKEY CHAR 1   0   Labeling system for functional locations IFLOALT
121 VERSN ILOM_VERSN NUMC3 NUMC 3   0   Version of functional location label  
122 TPLNR_INT TPLNR TPLNR CHAR 30   0   Functional Location IFLOT
123 PHASE QM_PHASE QM_PHASE CHAR 1   0   Notification Processing Phase  
124 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 VIQMAML_IFLOS ABCKZ T370C ABCKZ REF C CN
2 VIQMAML_IFLOS ADRNR_ILOA ADRC ADDRNUMBER REF 1 CN
3 VIQMAML_IFLOS ALKEY IFLOALT ALKEY KEY 1 CN
4 VIQMAML_IFLOS ANLNR ANLH ANLN1 REF C CN
5 VIQMAML_IFLOS ANLUN ANLA ANLN2 REF C CN
6 VIQMAML_IFLOS ANLZE T357Z ANLAZ REF C CN
7 VIQMAML_IFLOS ANLZN T357Z ANLAZ REF C CN
8 VIQMAML_IFLOS ANLZV T357Z ANLAZ REF C CN
9 VIQMAML_IFLOS ARTPR T356A ARTPR REF C CN
10 VIQMAML_IFLOS AUFNR AUFK AUFNR REF C CN
11 VIQMAML_IFLOS AUSWK T357A AUSWK REF C CN
12 VIQMAML_IFLOS BAUTL MARA MATNR REF C CN
13 VIQMAML_IFLOS BEBER T357 BEBER REF C CN
14 VIQMAML_IFLOS BEQUI EQUI EQUNR REF C CN
15 VIQMAML_IFLOS BTPLN IFLOT TPLNR REF C CN
16 VIQMAML_IFLOS BUKRS T001 BUKRS REF C CN
17 VIQMAML_IFLOS DAUFN AUFK AUFNR REF C CN
18 VIQMAML_IFLOS EQUNR EQUI EQUNR REF C CN
19 VIQMAML_IFLOS FEART TQ86 FEART REF C CN
20 VIQMAML_IFLOS FENUM QMFE FENUM REF C CN
21 VIQMAML_IFLOS GSBER TGSB GSBER REF C CN
22 VIQMAML_IFLOS ILOAN ILOA ILOAN REF 1 CN
23 VIQMAML_IFLOS INGRP T024I INGRP REF C CN
24 VIQMAML_IFLOS IWERK T399I IWERK REF C CN
25 VIQMAML_IFLOS KAUFN AUFK AUFNR REF C CN
26 VIQMAML_IFLOS KDAUF VBUK VBELN    
27 VIQMAML_IFLOS KDPOS VBUP POSNR    
28 VIQMAML_IFLOS KOKRS TKA01 KOKRS REF C CN
29 VIQMAML_IFLOS KOSTL CSKS KOSTL REF C CN
30 VIQMAML_IFLOS KUNUM KNA1 KUNNR REF C CN
31 VIQMAML_IFLOS MANDT T000 MANDT KEY 1 CN
32 VIQMAML_IFLOS MATNR MARA MATNR REF C CN
33 VIQMAML_IFLOS MAUEH T006 MSEHI REF C CN
34 VIQMAML_IFLOS MNGRP QPGR CODEGRUPPE REF C CN
35 VIQMAML_IFLOS MNKAT TQ15 KATALOGART REF C CN
36 VIQMAML_IFLOS OBJNR ONR00 OBJNR REF C CN
37 VIQMAML_IFLOS PPSID CRID OBJID REF C CN
38 VIQMAML_IFLOS PRIOK T356 PRIOK REF C CN
39 VIQMAML_IFLOS PROID PRPS PSPNR C CN
40 VIQMAML_IFLOS QMART TQ80 QMART REF C CN
41 VIQMAML_IFLOS QMGRP QPGR CODEGRUPPE REF C CN
42 VIQMAML_IFLOS QMKAT TQ15 KATALOGART    
43 VIQMAML_IFLOS RBNR T352B RBNR REF C CN
44 VIQMAML_IFLOS SPART TSPA SPART    
45 VIQMAML_IFLOS STORT T499S STAND REF C CN
46 VIQMAML_IFLOS SWERK T001W WERKS REF 1 CN
47 VIQMAML_IFLOS TPLNR_INT IFLOT TPLNR KEY 1 CN
48 VIQMAML_IFLOS VBELN VBUK VBELN    
49 VIQMAML_IFLOS VKBUR TVKBZ VKBUR REF C CN
50 VIQMAML_IFLOS VKGRP TVBVK VKGRP REF C CN
51 VIQMAML_IFLOS VKORG TVKO VKORG    
52 VIQMAML_IFLOS VTWEG TVTW VTWEG    
53 VIQMAML_IFLOS WAERS TCURC WAERS REF C CN
History
Last changed by/on SAP  20130529 
SAP Release Created in