SAP ABAP Table /ISDFPS/V_BI_EQI (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure /ISDFPS/V_BI_EQI   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 DATETO DATBI DATUM DATS 8   0   Valid To Date  
4 DATEFROM DATAB DATUM DATS 8   0   Valid-From Date  
5 EQART EQART EQART CHAR 10   0   Type of Technical Object T370K
6 INVNR INVNR INVNR_ANLA CHAR 25   0   Inventory number  
7 IWERK IWERK WERKS CHAR 4   0   Maintenance Planning Plant T399I
8 INGRP INGRP INGRP CHAR 3   0   Planner Group for Customer Service and Plant Maintenance T024I
9 ABCKZ ABCKZ ABCKZ CHAR 1   0   ABC Indicator for Technical Object T370C
10 KOKRS KOKRS CACCD CHAR 4   0   Controlling Area TKA01
11 KOSTL KOSTL KOSTL CHAR 10   0   Cost Center CSKS
12 TPLNR TPLNR TPLNR CHAR 30   0   Functional Location IFLOT
13 SWERK SWERK WERKS CHAR 4   0   Maintenance Plant T001W
14 STORT PMLOC AP_STAND CHAR 10   0   Location of maintenance object T499S
15 BEBER BEBER BEBER CHAR 3   0   Organizational Area T357
16 MSGRP RAUMNR CHAR8 CHAR 8   0   Room  
17 ADRNR AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number ADRC
18 BUKRS BUKRS BUKRS CHAR 4   0   Company Code T001
19 ANLNR ANLN1 ANLN1 CHAR 12   0   Main Asset Number ANLH
20 MATNR MATNR MATNR CHAR 18   0   Material Number MARA
21 WERK WERKS_D WERKS CHAR 4   0   Plant T001W
22 ANSWT ANSWT WERT CURR 13   2   Acquisition Value  
23 WAERS WAERS WAERS CUKY 5   0   Currency Key TCURC
24 ANSDT ANDTI DATUM DATS 8   0   Acquisition date  
25 ERDAT ERDAT DATUM DATS 8   0   Date on which the record was created  
26 AEDAT AEDAT DATUM DATS 8   0   Last Changed On  
27 INBDT ILOM_DATAB DATUM DATS 8   0   Start-up Date of the Technical Object  
28 LAGER LGORT_D LGORT CHAR 4   0   Storage location T001L
29 CHARGE CHARG_D CHARG CHAR 10   0   Batch Number MCH1
30 EQTYP EQTYP EQTYP CHAR 1   0   Equipment Category T370T
31 HEQUI HEQUI EQUNR CHAR 18   0   Superordinate Equipment EQUI
32 ILOAN ILOAN ILOAN CHAR 12   0   Location and account assignment for technical object ILOA
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 /ISDFPS/V_BI_EQI ABCKZ T370C ABCKZ REF C CN
2 /ISDFPS/V_BI_EQI ADRNR ADRC ADDRNUMBER REF 1 CN
3 /ISDFPS/V_BI_EQI ANLNR ANLH ANLN1 REF C CN
4 /ISDFPS/V_BI_EQI BEBER T357 BEBER REF C CN
5 /ISDFPS/V_BI_EQI BUKRS T001 BUKRS REF C CN
6 /ISDFPS/V_BI_EQI CHARGE MCH1 CHARG    
7 /ISDFPS/V_BI_EQI EQART T370K EQART REF C CN
8 /ISDFPS/V_BI_EQI EQTYP T370T EQTYP REF 1 CN
9 /ISDFPS/V_BI_EQI HEQUI EQUI EQUNR REF C CN
10 /ISDFPS/V_BI_EQI ILOAN ILOA ILOAN KEY 1 CN
11 /ISDFPS/V_BI_EQI INGRP T024I INGRP REF C CN
12 /ISDFPS/V_BI_EQI IWERK T399I IWERK    
13 /ISDFPS/V_BI_EQI KOKRS TKA01 KOKRS REF C CN
14 /ISDFPS/V_BI_EQI KOSTL CSKS KOSTL REF C CN
15 /ISDFPS/V_BI_EQI LAGER T001L LGORT    
16 /ISDFPS/V_BI_EQI MANDT T000 MANDT KEY 1 CN
17 /ISDFPS/V_BI_EQI MATNR MARA MATNR    
18 /ISDFPS/V_BI_EQI STORT T499S STAND REF C CN
19 /ISDFPS/V_BI_EQI SWERK T001W WERKS REF 1 CN
20 /ISDFPS/V_BI_EQI TPLNR IFLOT TPLNR REF C CN
21 /ISDFPS/V_BI_EQI WAERS TCURC WAERS REF 1 CN
22 /ISDFPS/V_BI_EQI WERK T001W WERKS    
History
Last changed by/on SAP  20130529 
SAP Release Created in