SAP ABAP Table /ISDFPS/V_BI_EQU (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	/ISDFPS/V_BI_EQU	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	B_WERK	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
32	B_LAGER	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
33	B_CHARGE	☐	B_CHARGE	CHARG	CHAR	10	0	Batch Number

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/ISDFPS/V_BI_EQU	ABCKZ	T370C	ABCKZ	REF	C	CN
2	/ISDFPS/V_BI_EQU	ADRNR	ADRC	ADDRNUMBER	REF	1	CN
3	/ISDFPS/V_BI_EQU	ANLNR	ANLH	ANLN1	REF	C	CN
4	/ISDFPS/V_BI_EQU	BEBER	T357	BEBER	REF	C	CN
5	/ISDFPS/V_BI_EQU	BUKRS	T001	BUKRS	REF	C	CN
6	/ISDFPS/V_BI_EQU	B_LAGER	T001L	LGORT
7	/ISDFPS/V_BI_EQU	B_WERK	T001W	WERKS
8	/ISDFPS/V_BI_EQU	CHARGE	MCH1	CHARG
9	/ISDFPS/V_BI_EQU	EQART	T370K	EQART	REF	C	CN
10	/ISDFPS/V_BI_EQU	EQTYP	T370T	EQTYP	REF	1	CN
11	/ISDFPS/V_BI_EQU	INGRP	T024I	INGRP	REF	C	CN
12	/ISDFPS/V_BI_EQU	IWERK	T399I	IWERK
13	/ISDFPS/V_BI_EQU	KOKRS	TKA01	KOKRS	REF	C	CN
14	/ISDFPS/V_BI_EQU	KOSTL	CSKS	KOSTL	REF	C	CN
15	/ISDFPS/V_BI_EQU	LAGER	T001L	LGORT
16	/ISDFPS/V_BI_EQU	MANDT	T000	MANDT	KEY	1	CN
17	/ISDFPS/V_BI_EQU	MATNR	MARA	MATNR
18	/ISDFPS/V_BI_EQU	STORT	T499S	STAND	REF	C	CN
19	/ISDFPS/V_BI_EQU	SWERK	T001W	WERKS	REF	1	CN
20	/ISDFPS/V_BI_EQU	TPLNR	IFLOT	TPLNR	REF	C	CN
21	/ISDFPS/V_BI_EQU	WAERS	TCURC	WAERS	REF	1	CN
22	/ISDFPS/V_BI_EQU	WERK	T001W	WERKS

History

Last changed by/on	SAP	20130529
SAP Release Created in