SAP ABAP Table V_EQUI_EQBSIFLOS (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure V_EQUI_EQBSIFLOS   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 EQUNR EQUNR EQUNR CHAR 18   0   Equipment Number *
3 ERDAT ERDAT DATUM DATS 8   0   Date on which the record was created  
4 ERNAM ERNAM USNAM CHAR 12   0   Name of Person who Created the Object  
5 EQASP EQASP SPRAS LANG 1   0   Language in which the piece of equipment was entered T002
6 AEDAT AEDAT DATUM DATS 8   0   Last Changed On  
7 AENAM AENAM USNAM CHAR 12   0   Name of Person Who Changed Object  
8 BEGRU IAUTG IAUTG CHAR 4   0   Authorization Group for Technical Object T370B
9 EQTYP EQTYP EQTYP CHAR 1   0   Equipment Category T370T
10 EQART EQART EQART CHAR 10   0   Type of Technical Object T370K
11 LVORM RESERVE_CHAR_001 CHAR1 CHAR 1   0   SAP Development Reserve: Format CHAR, Length 1  
12 INVNR INVNR INVNR_ANLA CHAR 25   0   Inventory number  
13 GROES GROSS GROES CHAR 18   0   Size/dimension  
14 BRGEW OBJ_WEIGHT MENG13 QUAN 13   3   Weight of object  
15 GEWEI WEIGHT_UNIT MEINS UNIT 3   0   Unit of weight T006
16 ANSDT ANDTI DATUM DATS 8   0   Acquisition date  
17 ANSWT ANSWT WERT CURR 13   2   Acquisition Value  
18 WAERS WAERS WAERS CUKY 5   0   Currency Key TCURC
19 ELIEF ELIEF LIFNR CHAR 10   0   Vendor number LFA1
20 GWLEN GWLEN DATUM DATS 8   0   Date on which the warranty ends  
21 GWLDT GWLDT DATUM DATS 8   0   Guarantee date  
22 WDBWT WDBWT WERT CURR 13   2   Equipment replacement value  
23 HERST HERST TEXT30 CHAR 30   0   Manufacturer of asset  
24 HERLD HERLD LAND1 CHAR 3   0   Country of manufacture T005
25 HZEIN HZEIN HZEIN CHAR 30   0   Manufacturer drawing number  
26 SERGE SERGE CHAR30 CHAR 30   0   Manufacturer serial number  
27 TYPBZ TYPBZ TYPBZ CHAR 20   0   Manufacturer model number  
28 BAUJJ BAUJJ CJAHR CHAR 4   0   Year of construction  
29 BAUMM BAUMM BAUMM CHAR 2   0   Month of construction  
30 APLKZ APLKZ APLKZ CHAR 1   0   Indicator: Task List Exists  
31 AULDT AULDT DATUM DATS 8   0   First delivery date of the equipment  
32 INBDT ILOM_DATAB DATUM DATS 8   0   Start-up Date of the Technical Object  
33 GERNR GERNR GERNR CHAR 18   0   Serial Number  
34 GWLDV GWLDV DATUM DATS 8   0   Warranty date for Sales and Distribution  
35 EQDAT EQDAT DATUM DATS 8   0   Date  
36 EQBER EQBER CHAR30 CHAR 30   0   Text for Notes  
37 EQNUM EQNUM NUM9 NUMC 9   0   Numerical Field  
38 OBJNR J_OBJNR J_OBJNR CHAR 22   0   Object number *
39 EQSNR EQSNR EQSNR CHAR 18   0   EQSE Number EQSE
40 CUOBJ CUOBJ CUOBJ NUMC 18   0   Configuration (internal object number)  
41 KRFKZ KRFKZ X CHAR 1   0   Referenced Configuration  
42 KMATN KMATN MATNR CHAR 18   0   Configurable Material MARA
43 MATNR MATNR MATNR CHAR 18   0   Material Number MARA
44 SERNR GERNR GERNR CHAR 18   0   Serial Number  
45 WERK WERKS_D WERKS CHAR 4   0   Plant T001W
46 LAGER LGORT_D LGORT CHAR 4   0   Storage location T001L
47 CHARGE CHARG_D CHARG CHAR 10   0   Batch Number MCH1
48 KUNDE KUNDSE KUNNR CHAR 10   0   Customer to Whom Serial Number was Delivered KNA1
49 WARPL WARPL WARPL CHAR 12   0   Maintenance Plan MPLA
50 IMRC_POINT IMRC_POINT IMRC_POINT CHAR 12   0   Measuring Point IMPTT
51 REVLV REVLV REVLV CHAR 2   0   Revision level  
52 MGANR MGANR MGANR CHAR 20   0   Master warranty number BGMK
53 BEGRUI INH_BEGRUI INHER CHAR 1   0   Data origin for authorization group field  
54 S_EQUI EQUIP_KNZ X CHAR 1   0   Equipment  
55 S_SERIAL KZKSD X CHAR 1   0   Serial data when maintaining equipment  
56 S_KONFI KONFKNZ XFELD CHAR 1   0   Configuration supported  
57 S_SALE SDKNZ XFELD CHAR 1   0   Sales equipment  
58 S_FHM FHMKZ XFLAG CHAR 1   0   Equip. category relevant to production resources and tools  
59 S_ELSE ELSE_KNZ X CHAR 1   0   Indicator: Other Data Active  
60 S_ISU ISU_KNZ X CHAR 1   0   IS-U data  
61 S_EQBS KZEQBS KZEQBS CHAR 1   0   EQSI Exists  
62 S_FLEET FLEET_KNZ X CHAR 1   0   Indicator: Fleet object active  
63 BSTVP BSTVP BSTVP CHAR 1   0   Stock Check for Serial Numbers  
64 SPARTE SPARTE SPART CHAR 2   0   Division TSPA
65 HANDLE ITOBTMP_TSEGGUID SYSUUID_22 CHAR 22   0   SAP Development Reserve: Integration of Date Segment (Key)  
66 TSEGTP ITOBTMP_TSEGTEMPLA TSEGTEMPLA CHAR 10   0   SAP Development Reserve: Integration Date Segment (Template) *
67 EMATN EMATN MATNR CHAR 18   0   Material number corresponding to manufacturer part number *
68 ACT_CHANGE_AA AAPM_ACT_CHANGE_AA AAPM_ACT CHAR 1   0   Change Equipment Master when Changing Asset  
69 S_CC CCC_KNZ X CHAR 1   0   Configuration Control Data  
70 DATLWB DATLWB DATS DATS 8   0   Date of Last Goods Movement  
71 UII UII_CHAR72 UII_CHAR72 CHAR 72   0   Unique Item Identifier  
72 IUID_TYPE IUID_TYPE IUID_TYPE CHAR 10   0   Structure Type of UII TIUID_TYPE
73 UII_PLANT UII_PLANT WERKS CHAR 4   0   Plant Responsible for UII *
74 EQEXT_ACTIVE /ISDFPS/DE_LM_DB_EQEXT_ACTIVE XFELD CHAR 1   0   Backpack Table /isdfps/lmeqext Active  
75 EQUI_SRTYPE COCF_SR_SRTYPE   CHAR 10   0   Shift Report Type COCF_CU_SRTYPE
76 EQUI_SNTYPE COCF_SN_SNTYPE QMART CHAR 2   0   Shift Note Type TQ80
77 EQLB_DUTY DIACL_DUTY XFLAG CHAR 1   0   Logbook Duty  
78 EQLB_HIDE DIACL_HIDE XFLAG CHAR 1   0   Hide Logbook Display  
79 DATBI DATBI DATUM DATS 8   0   Valid To Date  
80 EQLFN EQLFN NUM03 NUMC 3   0   Consecutive numbering of EquipUsagePeriods on same day  
81 EQUZN EQNNR NUM03 NUMC 3   0   Number of next EquipUsagePeriod on same day  
82 TIMBI TIMBI ZEITBI TIMS 6   0   Equipment usage period time stamp  
83 ESTAI RESERVE_CHAR_001 CHAR1 CHAR 1   0   SAP Development Reserve: Format CHAR, Length 1  
84 ESTAE RESERVE_CHAR_004 CHAR4 CHAR 4   0   SAP Development reserve: Format CHAR, length 4  
85 STNAM RESERVE_CHAR_012 CHAR12 CHAR 12   0   SAP Development Reserve: Format CHAR, Length 12  
86 DATAB DATAB DATUM DATS 8   0   Valid-From Date  
87 IWERK IWERK WERKS CHAR 4   0   Maintenance Planning Plant T399I
88 IWERKI INHER INHER CHAR 1   0   Data origin indicator  
89 SUBMT SUBMT MATNR CHAR 18   0   Construction Type Material of the Object MARA
90 MAPAR MAPAR MAPAR CHAR 30   0   Manufacturer part number  
91 HEQUI HEQUI EQUNR CHAR 18   0   Superordinate Equipment EQUI
92 HEQNR HEQNR CHAR4 CHAR 4   0   Equipment position at InstallLoc (Superior Equip./FunctLoc)  
93 INGRP INGRP INGRP CHAR 3   0   Planner Group for Customer Service and Plant Maintenance T024I
94 INGRPI INHER INHER CHAR 1   0   Data origin indicator  
95 PM_OBJTY PM_OBJTY CR_OBJTY CHAR 2   0   Object Type of CIM Resources for Work Center  
96 GEWRK LGWID CR_OBJID NUMC 8   0   Object ID of the Work Center CRID
97 GEWRKI INHER INHER CHAR 1   0   Data origin indicator  
98 TIDNR TIDNR TIDNR CHAR 25   0   Technical identification number  
99 TIDNRI INHER INHER CHAR 1   0   Data origin indicator  
100 ILOAN ILOAN ILOAN CHAR 12   0   Location and account assignment for technical object ILOA
101 KUND1 KUND1 KUNNR CHAR 10   0   Customer No. KNA1
102 KUND2 KUND2 KUNNR CHAR 10   0   End customer number KNA1
103 KUND3 KUND3 KUNNR CHAR 10   0   Operator KNA1
104 LIZNR LIZNR CHAR20 CHAR 20   0   Equipment license number  
105 RBNR RBNR RBNR CHAR 9   0   Report layout T352B
106 EZDAT EQDAT DATUM DATS 8   0   Date  
107 EZBER EQBER CHAR30 CHAR 30   0   Text for Notes  
108 EZNUM EQNUM NUM9 NUMC 9   0   Numerical Field  
109 RBNR_I INHER INHER CHAR 1   0   Data origin indicator  
110 IBLNR IBLNR BELNR CHAR 10   0   Physical inventory document  
111 BLDAT BLDAT DATUM DATS 8   0   Document Date in Document  
112 PVS_FOCUS PVS_GUID_CCC SYSUUID RAW 16   0   Internal Identification for PVS Objects  
113 PPEGUID PVS_GUID_CCC SYSUUID RAW 16   0   Internal Identification for PVS Objects  
114 TECHS TECHS TECHS CHAR 12   0   Parameter Variant/Standard Variant  
115 FUNCID CCC_FUNCID CHAR40 CHAR 40   0   Function Identifier  
116 FRCFIT CCC_FRCFIT XCHAR CHAR 1   0   Indicator: Forced Installation/Dismantling  
117 FRCRMV CCC_FRCRMV XCHAR CHAR 1   0   Force Dismantling Flag  
118 SPRAS SPRAS SPRAS LANG 1   0   Language Key T002
119 EQKTX KTX01 TEXT40 CHAR 40   0   Description of technical object  
120 KZLTX KZLTA XFELD CHAR 1   0   Long Text Indicator  
121 TXASP KZMLA CHAR1 CHAR 1   0   Primary language indicator for text segment  
122 EQKTU EQKTU CHAR40 CHAR 40   0   Equipment description in capital letters  
123 ABCKZ ABCKZ ABCKZ CHAR 1   0   ABC Indicator for Technical Object T370C
124 ABCKZI INH_ABCKZI INHER CHAR 1   0   Data origin for ABC indicator field  
125 EQFNR EQFNR CHAR30 CHAR 30   0   Sort Field  
126 EQFNRI INH_EQFNRI INHER CHAR 1   0   Data origin for sort field  
127 SWERK SWERK WERKS CHAR 4   0   Maintenance Plant T001W
128 SWERKI INH_SWERKI INHER CHAR 1   0   Data origin for maintenance plant field  
129 STORT PMLOC AP_STAND CHAR 10   0   Location of maintenance object T499S
130 STORTI INH_STORTI INHER CHAR 1   0   Data origin for location field  
131 MSGRP RAUMNR CHAR8 CHAR 8   0   Room  
132 MSGRPI INH_MSGRPI INHER CHAR 1   0   Data origin for room number field  
133 BEBER BEBER BEBER CHAR 3   0   Organizational Area T357
134 BEBERI INH_BEBERI INHER CHAR 1   0   Data origin for company area field  
135 CR_OBJTY CR_OBJTY CR_OBJTY CHAR 2   0   Object types of the CIM resource  
136 PPSID PPSID CR_OBJID NUMC 8   0   Object ID of PP work center CRID
137 PPSIDI INH_PPSIDI INHER CHAR 1   0   Data origin for PP work center field  
138 GSBER GSBER GSBER CHAR 4   0   Business Area TGSB
139 GSBERI INH_GSBERI INHER CHAR 1   0   Data origin for business area field  
140 KOKRS KOKRS CACCD CHAR 4   0   Controlling Area TKA01
141 KOKRSI INH_KOKRSI INHER CHAR 1   0   Data origin for controlling area field  
142 KOSTL KOSTL KOSTL CHAR 10   0   Cost Center CSKS
143 KOSTLI INH_KOSTLI INHER CHAR 1   0   Data origin for cost center field  
144 PROID PS_PSP_PNR PS_POSNR NUMC 8   0   Work Breakdown Structure Element (WBS Element) PRPS
145 PROIDI INH_PROIDI INHER CHAR 1   0   Data origin for WBS element field  
146 BUKRS BUKRS BUKRS CHAR 4   0   Company Code T001
147 BUKRSI INH_BUKRSI INHER CHAR 1   0   Data origin for company code field  
148 ANLNR ANLN1 ANLN1 CHAR 12   0   Main Asset Number ANLH
149 ANLNRI INH_ANLNRI INHER CHAR 1   0   Data origin for asset main no./sub-no. fields  
150 ANLUN ANLN2 ANLN2 CHAR 4   0   Asset Subnumber ANLA
151 ANLUNI INHER INHER CHAR 1   0   Data origin indicator  
152 DAUFN DAUFN AUFNR CHAR 12   0   Standing order number AUFK
153 DAUFNI INH_DAUFNI INHER CHAR 1   0   Data origin of standing order number field  
154 AUFNR ILOM_ORDST AUFNR CHAR 12   0   Settlement order AUFK
155 AUFNRI INH_AUFNRI INHER CHAR 1   0   Data origin for settlement order field  
156 TPLNRI INH_TPLNRI INHER CHAR 1   0   Data origin for functional location field  
157 VKORG VKORG VKORG CHAR 4   0   Sales Organization TVKO
158 VKORGI INH_VKORGI INHER CHAR 1   0   Data origin for sales organization field  
159 VTWEG VTWEG VTWEG CHAR 2   0   Distribution Channel TVKOV
160 VTWEGI INH_VTWEGI INHER CHAR 1   0   Data origin of distribution channel field  
161 SPART SPART SPART CHAR 2   0   Division TVTA
162 SPARTI INH_SPARTI INHER CHAR 1   0   Data origin for division field  
163 ADRNR AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number ADRC
164 ADRNRI INH_ADRNRI INHER CHAR 1   0   Data origin for address field  
165 OWNER ILOM_OWNER ILOM_OWNER CHAR 1   0   Object reference indicator  
166 VKBUR VKBUR VKBUR CHAR 4   0   Sales office TVKBZ
167 VKGRP VKGRP VKGRP CHAR 3   0   Sales group TVBVK
168 LBBSA LBBSA LBBSA CHAR 2   0   Stock Type of Goods Movement (Primary Posting) T156C
169 B_WERK WERKS_D WERKS CHAR 4   0   Plant T001W
170 B_LAGER LGORT_D LGORT CHAR 4   0   Storage location T001L
171 B_CHARGE B_CHARGE CHARG CHAR 10   0   Batch Number *
172 SOBKZ SOBKZ SOBKZ CHAR 1   0   Special Stock Indicator T148
173 KUNNR B_KUNNR KUNNR CHAR 10   0   Customer account number KNA1
174 LIFNR B_LIFNR LIFNR CHAR 10   0   Account number of the vendor LFA1
175 KDAUF KDAUF VBELN CHAR 10   0   Sales Order Number VBUK
176 KDPOS KDPOS NUM06 NUMC 6   0   Item number in Sales Order  
177 PS_PSP_PNR PS_PSP_PNR PS_POSNR NUMC 8   0   Work Breakdown Structure Element (WBS Element) *
178 LVORZ RESERVE_CHAR_001 CHAR1 CHAR 1   0   SAP Development Reserve: Format CHAR, Length 1  
179 ERNAZ ERNAM USNAM CHAR 12   0   Name of Person who Created the Object  
180 ERDAZ ERDAT DATUM DATS 8   0   Date on which the record was created  
181 AENAZ AENAM USNAM CHAR 12   0   Name of Person Who Changed Object  
182 AEDAZ AEDAT DATUM DATS 8   0   Last Changed On  
183 TPLNR ILOM_STRNO ILOM_STRNO CHAR 40   0   Functional location label  
184 ALKEY ILOM_ALKEY ILOM_ALKEY CHAR 1   0   Labeling system for functional locations IFLOALT
185 VERSN ILOM_VERSN NUMC3 NUMC 3   0   Version of functional location label  
186 TPLNR_INT TPLNR TPLNR CHAR 30   0   Functional Location IFLOT
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 V_EQUI_EQBSIFLOS ABCKZ T370C ABCKZ REF C CN
2 V_EQUI_EQBSIFLOS ADRNR ADRC ADDRNUMBER REF 1 CN
3 V_EQUI_EQBSIFLOS ALKEY IFLOALT ALKEY KEY 1 CN
4 V_EQUI_EQBSIFLOS ANLNR ANLH ANLN1 REF C CN
5 V_EQUI_EQBSIFLOS ANLUN ANLA ANLN2 REF C CN
6 V_EQUI_EQBSIFLOS AUFNR AUFK AUFNR REF C CN
7 V_EQUI_EQBSIFLOS BEBER T357 BEBER REF C CN
8 V_EQUI_EQBSIFLOS BEGRU T370B BEGRU REF C CN
9 V_EQUI_EQBSIFLOS BUKRS T001 BUKRS REF C CN
10 V_EQUI_EQBSIFLOS B_LAGER T001L LGORT    
11 V_EQUI_EQBSIFLOS B_WERK T001W WERKS    
12 V_EQUI_EQBSIFLOS CHARGE MCH1 CHARG    
13 V_EQUI_EQBSIFLOS DAUFN AUFK AUFNR REF C CN
14 V_EQUI_EQBSIFLOS ELIEF LFA1 LIFNR REF 1 CN
15 V_EQUI_EQBSIFLOS EQART T370K EQART REF C CN
16 V_EQUI_EQBSIFLOS EQASP T002 SPRAS KEY 1 CN
17 V_EQUI_EQBSIFLOS EQSNR EQSE EQSNR KEY 1 C
18 V_EQUI_EQBSIFLOS EQTYP T370T EQTYP REF 1 CN
19 V_EQUI_EQBSIFLOS EQUI_SNTYPE TQ80 QMART KEY 1 CN
20 V_EQUI_EQBSIFLOS EQUI_SRTYPE COCF_CU_SRTYPE SRTYPE KEY 1 CN
21 V_EQUI_EQBSIFLOS GEWEI T006 MSEHI REF 1 CN
22 V_EQUI_EQBSIFLOS GEWRK CRID OBJID REF C CN
23 V_EQUI_EQBSIFLOS GSBER TGSB GSBER REF C CN
24 V_EQUI_EQBSIFLOS HEQUI EQUI EQUNR REF C CN
25 V_EQUI_EQBSIFLOS HERLD T005 LAND1 REF 1 CN
26 V_EQUI_EQBSIFLOS ILOAN ILOA ILOAN KEY 1 CN
27 V_EQUI_EQBSIFLOS IMRC_POINT IMPTT POINT    
28 V_EQUI_EQBSIFLOS INGRP T024I INGRP REF C CN
29 V_EQUI_EQBSIFLOS IUID_TYPE TIUID_TYPE IUID_TYPE    
30 V_EQUI_EQBSIFLOS IWERK T399I IWERK    
31 V_EQUI_EQBSIFLOS KDAUF VBUK VBELN    
32 V_EQUI_EQBSIFLOS KMATN MARA MATNR REF 1 CN
33 V_EQUI_EQBSIFLOS KOKRS TKA01 KOKRS REF C CN
34 V_EQUI_EQBSIFLOS KOSTL CSKS KOSTL REF C CN
35 V_EQUI_EQBSIFLOS KUND1 KNA1 KUNNR KEY 1 CN
36 V_EQUI_EQBSIFLOS KUND2 KNA1 KUNNR KEY 1 CN
37 V_EQUI_EQBSIFLOS KUND3 KNA1 KUNNR KEY 1 CN
38 V_EQUI_EQBSIFLOS KUNDE KNA1 KUNNR    
39 V_EQUI_EQBSIFLOS KUNNR KNA1 KUNNR    
40 V_EQUI_EQBSIFLOS LAGER T001L LGORT    
41 V_EQUI_EQBSIFLOS LBBSA T156C LBBSA    
42 V_EQUI_EQBSIFLOS LIFNR LFA1 LIFNR    
43 V_EQUI_EQBSIFLOS MANDT T000 MANDT KEY 1 CN
44 V_EQUI_EQBSIFLOS MATNR MARA MATNR    
45 V_EQUI_EQBSIFLOS MGANR BGMK MGANR    
46 V_EQUI_EQBSIFLOS PPSID CRID OBJID REF C CN
47 V_EQUI_EQBSIFLOS PROID PRPS PSPNR C CN
48 V_EQUI_EQBSIFLOS RBNR T352B RBNR REF C CN
49 V_EQUI_EQBSIFLOS SOBKZ T148 SOBKZ    
50 V_EQUI_EQBSIFLOS SPART TVTA SPART REF 1 CN
51 V_EQUI_EQBSIFLOS SPARTE TSPA SPART KEY 1 CN
52 V_EQUI_EQBSIFLOS SPRAS T002 SPRAS KEY 1 CN
53 V_EQUI_EQBSIFLOS STORT T499S STAND REF C CN
54 V_EQUI_EQBSIFLOS SUBMT MARA MATNR REF 1 CN
55 V_EQUI_EQBSIFLOS SWERK T001W WERKS REF 1 CN
56 V_EQUI_EQBSIFLOS TPLNR_INT IFLOT TPLNR KEY 1 CN
57 V_EQUI_EQBSIFLOS VKBUR TVKBZ VKBUR REF 1 CN
58 V_EQUI_EQBSIFLOS VKGRP TVBVK VKGRP REF 1 CN
59 V_EQUI_EQBSIFLOS VKORG TVKO VKORG REF 1 CN
60 V_EQUI_EQBSIFLOS VTWEG TVKOV VTWEG REF 1 CN
61 V_EQUI_EQBSIFLOS WAERS TCURC WAERS REF 1 CN
62 V_EQUI_EQBSIFLOS WARPL MPLA WARPL    
63 V_EQUI_EQBSIFLOS WERK T001W WERKS    
History
Last changed by/on SAP  20130529 
SAP Release Created in