SAP ABAP Table /ISDFPS/FDP_EQUI_STATUS (Line Structure of Equipment Status)

Hierarchy

☛ EA-DFPS (Software Component) SAP Enterprise Extension Defense Forces & Public Security
   ⤷ IS-DFS-OF-FDP (Application Component) Structures Workbench
     ⤷ /ISDFPS/FDP (Package) Armed Forces and Deployment Planning

Basic Data

Table Category	INTTAB	Structure
Structure	/ISDFPS/FDP_EQUI_STATUS	Table Relationship Diagram
Short Description	Line Structure of Equipment Status

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	MAKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description
2	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
3	STSMA	☐	J_STSMA	J_STSMA	CHAR	8	0	Status Profile	*
4	PROTXT	☐	/ISDFPS/STATUS_SCHEMA_TXT	TEXT30	CHAR	30	0	Description of Status Structure
5	ESTAT	☐	J_ESTAT	J_ESTAT	CHAR	5	0	User Status	*
6	STATXT	☐	/ISDFPS/STATUS_TXT	TEXT30	CHAR	30	0	Description of User Status of Technical Object
7	EQUTXT	☐	KTX01	TEXT40	CHAR	40	0	Description of technical object
8	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
9	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	*
10	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
11	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
12	EQASP	☐	EQASP	SPRAS	LANG	1	0	Language in which the piece of equipment was entered	T002
13	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
14	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
15	BEGRU	☐	IAUTG	IAUTG	CHAR	4	0	Authorization Group for Technical Object	T370B
16	EQTYP	☐	EQTYP	EQTYP	CHAR	1	0	Equipment Category	T370T
17	EQART	☐	EQART	EQART	CHAR	10	0	Type of Technical Object	T370K
18	LVORM	☐	LVORM	XFELD	CHAR	1	0	Deletion Indicator
19	INVNR	☐	INVNR	INVNR_ANLA	CHAR	25	0	Inventory number
20	GROES	☐	GROSS	GROES	CHAR	18	0	Size/dimension
21	BRGEW	☐	OBJ_WEIGHT	MENG13	QUAN	13	3	Weight of object
22	GEWEI	☐	WEIGHT_UNIT	MEINS	UNIT	3	0	Unit of weight	T006
23	ANSDT	☐	ANDTI	DATUM	DATS	8	0	Acquisition date
24	ANSWT	☐	ANSWT	WERT	CURR	13	2	Acquisition Value
25	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
26	ELIEF	☐	ELIEF	LIFNR	CHAR	10	0	Vendor number	LFA1
27	GWLEN	☐	GWLEN	DATUM	DATS	8	0	Date on which the warranty ends
28	GWLDT	☐	GWLDT	DATUM	DATS	8	0	Guarantee date
29	WDBWT	☐	WDBWT	WERT	CURR	13	2	Equipment replacement value
30	HERST	☐	HERST	TEXT30	CHAR	30	0	Manufacturer of asset
31	HERLD	☐	HERLD	LAND1	CHAR	3	0	Country of manufacture	T005
32	HZEIN	☐	HZEIN	HZEIN	CHAR	30	0	Manufacturer drawing number
33	SERGE	☐	SERGE	CHAR30	CHAR	30	0	Manufacturer serial number
34	TYPBZ	☐	TYPBZ	TYPBZ	CHAR	20	0	Manufacturer model number
35	BAUJJ	☐	BAUJJ	CJAHR	CHAR	4	0	Year of construction
36	BAUMM	☐	BAUMM	BAUMM	CHAR	2	0	Month of construction
37	APLKZ	☐	APLKZ	APLKZ	CHAR	1	0	Indicator: Task List Exists
38	AULDT	☐	AULDT	DATUM	DATS	8	0	First delivery date of the equipment
39	INBDT	☐	ILOM_DATAB	DATUM	DATS	8	0	Start-up Date of the Technical Object
40	EQLFN	☐	EQLFN	NUM03	NUMC	3	0	Consecutive numbering of EquipUsagePeriods on same day
41	GWLDV	☐	GWLDV	DATUM	DATS	8	0	Warranty date for Sales and Distribution
42	EQDAT	☐	EQDAT	DATUM	DATS	8	0	Date
43	EQBER	☐	EQBER	CHAR30	CHAR	30	0	Text for Notes
44	EQNUM	☐	EQNUM	NUM9	NUMC	9	0	Numerical Field
45	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
46	EQSNR	☐	EQSNR	EQSNR	CHAR	18	0	EQSE Number	EQSE
47	CUOBJ	☐	CUOBJ	CUOBJ	NUMC	18	0	Configuration (internal object number)
48	KRFKZ	☐	KRFKZ	X	CHAR	1	0	Referenced Configuration
49	KMATN	☐	KMATN	MATNR	CHAR	18	0	Configurable Material	MARA
50	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
51	SERNR	☐	GERNR	GERNR	CHAR	18	0	Serial Number
52	CHARGE	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCH1
53	KUNDE	☐	KUNDSE	KUNNR	CHAR	10	0	Customer to Whom Serial Number was Delivered	KNA1
54	WARPL	☐	WARPL	WARPL	CHAR	12	0	Maintenance Plan	MPLA
55	IMRC_POINT	☐	IMRC_POINT	IMRC_POINT	CHAR	12	0	Measuring Point	IMPTT
56	REVLV	☐	REVLV	REVLV	CHAR	2	0	Revision level
57	MGANR	☐	MGANR	MGANR	CHAR	20	0	Master warranty number	BGMK
58	BEGRUI	☐	INH_BEGRUI	INHER	CHAR	1	0	Data origin for authorization group field
59	S_EQUI	☐	EQUIP_KNZ	X	CHAR	1	0	Equipment
60	S_SERIAL	☐	KZKSD	X	CHAR	1	0	Serial data when maintaining equipment
61	S_KONFI	☐	KONFKNZ	XFELD	CHAR	1	0	Configuration supported
62	S_SALE	☐	SDKNZ	XFELD	CHAR	1	0	Sales equipment
63	S_FHM	☐	FHMKZ	XFLAG	CHAR	1	0	Equip. category relevant to production resources and tools
64	S_ELSE	☐	ELSE_KNZ	X	CHAR	1	0	Indicator: Other Data Active
65	S_ISU	☐	ISU_KNZ	X	CHAR	1	0	IS-U data
66	S_EQBS	☐	KZEQBS	KZEQBS	CHAR	1	0	EQSI Exists
67	S_FLEET	☐	FLEET_KNZ	X	CHAR	1	0	Indicator: Fleet object active
68	BSTVP	☐	BSTVP	BSTVP	CHAR	1	0	Stock Check for Serial Numbers
69	SPARTE	☐	SPARTE	SPART	CHAR	2	0	Division	TSPA
70	HANDLE	☐	TSEGGUID	SYSUUID_22	CHAR	22	0	Globally unique identifier (linked to time segment, etc)
71	TSEGTP	☐	TSEGTEMPLA	TSEGTEMPLA	CHAR	10	0	Template	*
72	EMATN	☐	EMATN	MATNR	CHAR	18	0	Material number corresponding to manufacturer part number	*
73	ACT_CHANGE_AA	☐	AAPM_ACT_CHANGE_AA	AAPM_ACT	CHAR	1	0	Change Equipment Master when Changing Asset
74	.INCLUDE	☐				0	0	Data Part EQBS & BSINF
75	LBBSA	☐	LBBSA	LBBSA	CHAR	2	0	Stock Type of Goods Movement (Primary Posting)	T156C
76	B_WERK	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
77	B_LAGER	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
78	B_CHARGE	☐	B_CHARGE	CHARG	CHAR	10	0	Batch Number	*
79	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	*
80	KUNNR	☐	B_KUNNR	KUNNR	CHAR	10	0	Customer account number	*
81	LIFNR	☐	B_LIFNR	LIFNR	CHAR	10	0	Account number of the vendor	*
82	KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	*
83	KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
84	PS_PSP_PNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
85	.INCLUDE	☐				0	0	Identification Fields for a Fleet Object
86	FLEET_NUM	☐	FLEET_NUM	FLEET_NUM	CHAR	18	0	Identification number for fleet object
87	FLEET_VIN	☐	FLEET_VIN	FLEET_VIN	CHAR	30	0	Manufacturer Vehicle Identification Number for Fleet Object
88	CHASSIS_NUM	☐	CHASSIS_NUM	CHASSIS_NUM	CHAR	30	0	Chassis number
89	LICENSE_NUM	☐	LICENSE_NUM	LICENSE_NUM	CHAR	15	0	License plate number
90	EXPIRY_DATE	☐	EXPIRY_DATE	DATUM	DATS	8	0	Validity end date
91	.INCLUDE	☐				0	0	Fleet Attributes
92	FLEET_HGT	☐	FLEET_HGT	MENG13	QUAN	13	3	Maximum fleet object height
93	FLEET_WID	☐	FLEET_WID	MENG13	QUAN	13	3	Width of fleet object
94	FLEET_LEN	☐	FLEET_LEN	MENG13	QUAN	13	3	Maximum fleet object length
95	DIM_UNIT	☐	DIM_UNIT	MEINS	UNIT	3	0	Unit of length	T006
96	PRI_CALC	☐	PRI_CALC	PRI_CALC	CHAR	1	0	Indicator to determine the calculation method f. consumption	T370CLC
97	REPLA_DATE	☐	REPLA_DATE	DATUM	DATS	8	0	Date on which the object should be replaced
98	REPLA_ODOM	☐	REPLA_ODOM	FLTP_INOUT	CHAR	22	0	Odometer reading at replacement
99	REPLA_OPH	☐	REPLA_OPH	FLTP_INOUT	CHAR	22	0	Hour meter reading at replacement
100	NUM_AXLE	☐	NUM_AXLE	NUM2	NUMC	2	0	Number of Axles in Fleet Object
101	MAX_OCCUPANTS	☐	MAX_OCCUPANTS	NUM4	NUMC	4	0	Maximum number of occupants
102	CARD_NUM	☐	CARD_NUM	CHAR30	CHAR	30	0	Fuel card number
103	KEY_NUM	☐	KEY_NUM	CHAR20	CHAR	20	0	Key number of vehicle
104	FLEET_USE	☐	FLEET_USE	FLEET_USE	CHAR	1	0	Usage indicator	T370USG
105	ENGINE_TYPE	☐	ENGINE_TYPE	ENGINE_TYPE	CHAR	10	0	Engine type	T370ENG
106	ENGINE_POWER	☐	ENGINE_POWER	MENG13	QUAN	13	3	Power at specific number of revolutions per minute
107	UNIT_POWER	☐	UNIT_POWER	MEINS	UNIT	3	0	Power unit	T006
108	REVOLUTIONS	☐	REVOLUTIONS	NUM7	NUMC	7	0	Revolutions per minute
109	ENGINE_CYL	☐	ENGINE_CYL	NUM2	NUMC	2	0	Number of cylinders
110	ENGINE_CAP	☐	ENGINE_CAP	MENG13	QUAN	13	3	Engine capacity
111	UNIT_CAP	☐	UNIT_CAP	MEINS	UNIT	3	0	Unit for engine capacity measurement	T006
112	ENGINE_SNR	☐	ENGINE_SNR	CHAR30	CHAR	30	0	Engine serial number of manufacturer
113	FUEL_PRI	☐	FUEL_PRI	FLUID_TYPE	CHAR	12	0	Consumable Type of Primary Fuel	T370FLD
114	FUEL_SEC	☐	FUEL_SEC	FLUID_TYPE	CHAR	12	0	Consumable type of secondary fuel	T370FLD
115	OIL_TYPE	☐	FLTOIL_TYPE	FLUID_TYPE	CHAR	12	0	Consumable type of oil	T370FLD
116	GROSS_WGT	☐	GROSS_WGT	MENG13	QUAN	13	3	Total Weight Allowed
117	LOAD_WGT	☐	LOAD_WGT	MENG13	QUAN	13	3	Maximum load weight
118	WGT_UNIT	☐	WEIGHT_UNIT	MEINS	UNIT	3	0	Unit of weight	*
119	LOAD_HGT	☐	LOAD_HGT	MENG13	QUAN	13	3	Load height
120	LOAD_WID	☐	LOAD_WID	MENG13	QUAN	13	3	Load width
121	LOAD_LEN	☐	LOAD_LEN	MENG13	QUAN	13	3	Load length
122	LOAD_DIM_UNIT	☐	LOAD_DIM_UNIT	MEINS	UNIT	3	0	Unit for freight dimensions	T006
123	LOAD_VOL	☐	LOAD_VOL	MENG13	QUAN	13	3	Load volume
124	VOL_UNIT	☐	VOL_UNIT	MEINS	UNIT	3	0	Volume unit	T006
125	NO_COMPART	☐	NO_COMPART	NUM2	NUMC	2	0	NUmber of compartments
126	SPEED_MAX	☐	SPEED_MAX	MENG9	QUAN	9	3	Maximum Fleet Object Speed
127	SPEED_UNIT	☐	SPEED_UNIT	MEINS	UNIT	3	0	Speed Unit	T006
128	CONSUMP_TOL	☐	CONSUMP_TOL	CHAR1	CHAR	1	0	Indicator Consumption Recording: Permitted Tolerances
129	CONSUMP_MOVE	☐	CONSUMP_MOVE	CHAR1	CHAR	1	0	Indicator Consumption Recording: Material Movement
130	.INCLUDE	☐				0	0
131	.INCLU--AP	☐				0	0	Extension of Fleet Master for DSD
132	.INCLUDE	☐				0	0	Extension of Fleet Master for DSD
133	/DSD/RP_EIGEN	☐	/BEV1/RPEIGEN	/BEV1/RPEIGEN	CHAR	1	0	Indicator for Own (X) or External Vehicle
134	/DSD/RP_AHLAST	☐	/BEV1/RPAHLAST	MENG13	QUAN	13	3	Trailer Load
135	/DSD/RP_AHLAST_U	☐	WEIGHT_UNIT	MEINS	UNIT	3	0	Unit of weight	T006
136	/DSD/RP_VARKAP	☐	/BEV1/RPVARKAP	/BEV1/RPVARKAP	QUAN	7	2	Free Capacity Field with Variable Unit of Measure
137	/DSD/RP_KAPUNIT	☐	/BEV1/RPKAPUNIT	MEINS	UNIT	3	0	Unit of Measure for Var. Capacity Field	T006
138	/BEV1/LULEINH	☐	/BEV1/LULEINH	/BEV1/LULEINH	NUMC	8	0	Loading Units
139	.INCLUDE	☐				0	0	Extension of Fleet Master with VSO Fleet Type
140	/VSO/M_VSO_FTYPE	☐	/VSO/M_VSO_FLT_TYPE	/VSO/M_VSO_FLT_TYPE	CHAR	10	0	Vehicle Type for Vehicle Space Optimation	/VSO/B_FLEET
141	SELECTION	☐	FC_CHBOX	CHAR1_X	CHAR	1	0	Checkbox
142	OBJID	☐	HROBJID	HROBJID	NUMC	8	0	Object ID	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/ISDFPS/FDP_EQUI_STATUS	/DSD/RP_AHLAST_U	T006	MSEHI
2	/ISDFPS/FDP_EQUI_STATUS	/DSD/RP_KAPUNIT	T006	MSEHI
3	/ISDFPS/FDP_EQUI_STATUS	/VSO/M_VSO_FTYPE	/VSO/B_FLEET	VSO_FTYPE
4	/ISDFPS/FDP_EQUI_STATUS	BEGRU	T370B	BEGRU	REF	C	CN
5	/ISDFPS/FDP_EQUI_STATUS	CHARGE	MCH1	CHARG
6	/ISDFPS/FDP_EQUI_STATUS	DIM_UNIT	T006	MSEHI	KEY	1	CN
7	/ISDFPS/FDP_EQUI_STATUS	ELIEF	LFA1	LIFNR	REF	1	CN
8	/ISDFPS/FDP_EQUI_STATUS	ENGINE_TYPE	T370ENG	ENGINE_TYPE	KEY	1	CN
9	/ISDFPS/FDP_EQUI_STATUS	EQART	T370K	EQART	REF	C	CN
10	/ISDFPS/FDP_EQUI_STATUS	EQASP	T002	SPRAS	KEY	1	CN
11	/ISDFPS/FDP_EQUI_STATUS	EQSNR	EQSE	EQSNR	KEY	1	C
12	/ISDFPS/FDP_EQUI_STATUS	EQTYP	T370T	EQTYP	REF	1	CN
13	/ISDFPS/FDP_EQUI_STATUS	FLEET_USE	T370USG	FLEET_USE	KEY	1	CN
14	/ISDFPS/FDP_EQUI_STATUS	FUEL_PRI	T370FLD	FLUID_TYPE	KEY	1	CN
15	/ISDFPS/FDP_EQUI_STATUS	FUEL_SEC	T370FLD	FLUID_TYPE	KEY	1	CN
16	/ISDFPS/FDP_EQUI_STATUS	GEWEI	T006	MSEHI	REF	1	CN
17	/ISDFPS/FDP_EQUI_STATUS	HERLD	T005	LAND1	REF	1	CN
18	/ISDFPS/FDP_EQUI_STATUS	IMRC_POINT	IMPTT	POINT
19	/ISDFPS/FDP_EQUI_STATUS	KMATN	MARA	MATNR	REF	1	CN
20	/ISDFPS/FDP_EQUI_STATUS	KUNDE	KNA1	KUNNR
21	/ISDFPS/FDP_EQUI_STATUS	LBBSA	T156C	LBBSA
22	/ISDFPS/FDP_EQUI_STATUS	LOAD_DIM_UNIT	T006	MSEHI	KEY	1	CN
23	/ISDFPS/FDP_EQUI_STATUS	MANDT	T000	MANDT	KEY	1	CN
24	/ISDFPS/FDP_EQUI_STATUS	MATNR	MARA	MATNR
25	/ISDFPS/FDP_EQUI_STATUS	MGANR	BGMK	MGANR
26	/ISDFPS/FDP_EQUI_STATUS	OIL_TYPE	T370FLD	FLUID_TYPE	KEY	1	CN
27	/ISDFPS/FDP_EQUI_STATUS	PRI_CALC	T370CLC	CALC_KEY	KEY	1	CN
28	/ISDFPS/FDP_EQUI_STATUS	SPARTE	TSPA	SPART	KEY	1	CN
29	/ISDFPS/FDP_EQUI_STATUS	SPEED_UNIT	T006	MSEHI	KEY	1	CN
30	/ISDFPS/FDP_EQUI_STATUS	UNIT_CAP	T006	MSEHI	KEY	1	CN
31	/ISDFPS/FDP_EQUI_STATUS	UNIT_POWER	T006	MSEHI	KEY	1	CN
32	/ISDFPS/FDP_EQUI_STATUS	VOL_UNIT	T006	MSEHI	KEY	1	CN
33	/ISDFPS/FDP_EQUI_STATUS	WAERS	TCURC	WAERS	REF	1	CN
34	/ISDFPS/FDP_EQUI_STATUS	WARPL	MPLA	WARPL

History

Last changed by/on	SAP	20130529
SAP Release Created in	46C0