SAP ABAP View V_EQUI_SER (Equipment (View) Look up equipment for serial number)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM (Application Component) Customer Relationship Management
     CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       IEQM (Package) Application Develoment R/3 Equipment Management
Basic Data
View Type D Database View 
Database View V_EQUI_SER  
Short Description Equipment (View) Look up equipment for serial number    
Root table EQUZ   Equipment time segment 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 EQUZ EQUZ
2 EQKT  
3 ILOA  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 EQKT MANDT JL EQ 0 0
2 EQUZ MANDT JR EQ AND 0 0
3 EQKT EQUNR JL EQ 0 0
4 EQUZ EQUNR JR EQ AND 0 0
5 ILOA MANDT JL EQ 0 0
6 EQUZ MANDT JR EQ AND 0 0
7 ILOA ILOAN JL EQ 0 0
8 EQUZ ILOAN JR EQ 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT EQUZ MANDT   MANDT Client
2 EQUNR EQUZ EQUNR   EQUNR Equipment Number
3 DATBI EQUZ DATBI   DATBI Valid To Date
4 EQLFN EQUZ EQLFN   EQLFN Consecutive numbering of EquipUsagePeriods on same day
5 SPRAS EQKT SPRAS   SPRAS Language Key
6 EQUZN EQUZ EQUZN   EQNNR Number of next EquipUsagePeriod on same day
7 ERDAZ EQUZ ERDAT   ERDAT Date on which the record was created
8 ERNAZ EQUZ ERNAM   ERNAM Name of Person who Created the Object
9 AEDAZ EQUZ AEDAT   AEDAT Last Changed On
10 AENAZ EQUZ AENAM   AENAM Name of Person Who Changed Object
11 TIMBI EQUZ TIMBI   TIMBI Equipment usage period time stamp
12 ESTAI EQUZ ESTAI   RESERVE_CHAR_001 SAP Development Reserve: Format CHAR, Length 1
13 ESTAE EQUZ ESTAE   RESERVE_CHAR_004 SAP Development reserve: Format CHAR, length 4
14 STNAM EQUZ STNAM   RESERVE_CHAR_012 SAP Development Reserve: Format CHAR, Length 12
15 LVORZ EQUZ LVORM   RESERVE_CHAR_001 SAP Development Reserve: Format CHAR, Length 1
16 DATAB EQUZ DATAB   DATAB Valid-From Date
17 IWERK EQUZ IWERK   IWERK Maintenance Planning Plant
18 IWERKI EQUZ IWERKI   INHER Data origin indicator
19 SUBMT EQUZ SUBMT   SUBMT Construction Type Material of the Object
20 MAPAR EQUZ MAPAR   MAPAR Manufacturer part number
21 HEQUI EQUZ HEQUI   HEQUI Superordinate Equipment
22 HEQNR EQUZ HEQNR   HEQNR Equipment position at InstallLoc (Superior Equip./FunctLoc)
23 INGRP EQUZ INGRP   INGRP Planner Group for Customer Service and Plant Maintenance
24 INGRPI EQUZ INGRPI   INHER Data origin indicator
25 PM_OBJTY EQUZ PM_OBJTY   PM_OBJTY Object Type of CIM Resources for Work Center
26 GEWRK EQUZ GEWRK   LGWID Object ID of the Work Center
27 GEWRKI EQUZ GEWRKI   INHER Data origin indicator
28 TIDNR EQUZ TIDNR   TIDNR Technical identification number
29 TIDNRI EQUZ TIDNRI   INHER Data origin indicator
30 ILOAN EQUZ ILOAN   ILOAN Location and account assignment for technical object
31 KUND1 EQUZ KUND1   KUND1 Customer No.
32 KUND2 EQUZ KUND2   KUND2 End customer number
33 KUND3 EQUZ KUND3   KUND3 Operator
34 LIZNR EQUZ LIZNR   LIZNR Equipment license number
35 RBNR EQUZ RBNR   RBNR Report layout
36 EZDAT EQUZ EZDAT   EQDAT Date
37 EZBER EQUZ EZBER   EQBER Text for Notes
38 EZNUM EQUZ EZNUM   EQNUM Numerical Field
39 RBNR_I EQUZ RBNR_I   INHER Data origin indicator
40 IBLNR EQUZ IBLNR   IBLNR Physical inventory document
41 BLDAT EQUZ BLDAT   BLDAT Document Date in Document
42 EQKTX EQKT EQKTX   KTX01 Description of technical object
43 KZLTX EQKT KZLTX   KZLTA Long Text Indicator
44 TXASP EQKT TXASP   KZMLA Primary language indicator for text segment
45 EQKTU EQKT EQKTU   EQKTU Equipment description in capital letters
46 TPLNR ILOA TPLNR   TPLNR Functional Location
47 ABCKZ ILOA ABCKZ   ABCKZ ABC Indicator for Technical Object
48 ABCKZI ILOA ABCKZI   INH_ABCKZI Data origin for ABC indicator field
49 EQFNR ILOA EQFNR   EQFNR Sort Field
50 EQFNRI ILOA EQFNRI   INH_EQFNRI Data origin for sort field
51 SWERK ILOA SWERK   SWERK Maintenance Plant
52 SWERKI ILOA SWERKI   INH_SWERKI Data origin for maintenance plant field
53 STORT ILOA STORT   PMLOC Location of maintenance object
54 STORTI ILOA STORTI   INH_STORTI Data origin for location field
55 MSGRP ILOA MSGRP   RAUMNR Room
56 MSGRPI ILOA MSGRPI   INH_MSGRPI Data origin for room number field
57 BEBER ILOA BEBER   BEBER Organizational Area
58 BEBERI ILOA BEBERI   INH_BEBERI Data origin for company area field
59 CR_OBJTY ILOA CR_OBJTY   CR_OBJTY Object types of the CIM resource
60 PPSID ILOA PPSID   PPSID Object ID of PP work center
61 PPSIDI ILOA PPSIDI   INH_PPSIDI Data origin for PP work center field
62 GSBER ILOA GSBER   GSBER Business Area
63 GSBERI ILOA GSBERI   INH_GSBERI Data origin for business area field
64 KOKRS ILOA KOKRS   KOKRS Controlling Area
65 KOKRSI ILOA KOKRSI   INH_KOKRSI Data origin for controlling area field
66 KOSTL ILOA KOSTL   KOSTL Cost Center
67 KOSTLI ILOA KOSTLI   INH_KOSTLI Data origin for cost center field
68 PROID ILOA PROID   PS_PSP_PNR Work Breakdown Structure Element (WBS Element)
69 PROIDI ILOA PROIDI   INH_PROIDI Data origin for WBS element field
70 BUKRS ILOA BUKRS   BUKRS Company Code
71 BUKRSI ILOA BUKRSI   INH_BUKRSI Data origin for company code field
72 ANLNR ILOA ANLNR   ANLN1 Main Asset Number
73 ANLNRI ILOA ANLNRI   INH_ANLNRI Data origin for asset main no./sub-no. fields
74 ANLUN ILOA ANLUN   ANLN2 Asset Subnumber
75 ANLUNI ILOA ANLUNI   INHER Data origin indicator
76 DAUFN ILOA DAUFN   DAUFN Standing order number
77 DAUFNI ILOA DAUFNI   INH_DAUFNI Data origin of standing order number field
78 AUFNR ILOA AUFNR   ILOM_ORDST Settlement order
79 AUFNRI ILOA AUFNRI   INH_AUFNRI Data origin for settlement order field
80 TPLNRI ILOA TPLNRI   INH_TPLNRI Data origin for functional location field
81 VKORG ILOA VKORG   VKORG Sales Organization
82 VKORGI ILOA VKORGI   INH_VKORGI Data origin for sales organization field
83 VTWEG ILOA VTWEG   VTWEG Distribution Channel
84 VTWEGI ILOA VTWEGI   INH_VTWEGI Data origin of distribution channel field
85 SPART ILOA SPART   SPART Division
86 SPARTI ILOA SPARTI   INH_SPARTI Data origin for division field
87 ADRNR ILOA ADRNR   AD_ADDRNUM Address number
88 ADRNRI ILOA ADRNRI   INH_ADRNRI Data origin for address field
89 OWNER ILOA OWNER   ILOM_OWNER Object reference indicator
                 
Maintenance Status
Access
  read only
  read and change
  Time-dependent views: like U, validity data like ' '
  read, change, delete and insert
Delivery Class      
Data Browser/Table View Maintenance    Display/Maintenance Allowed with Restrictions  
History
Last changed by/on SAP  20130529 
SAP Release Created in