SAP ABAP Table ENT1027 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	ENT1027	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	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number
3	SPRAS	☑	SPRAS	SPRAS	LANG	1	0	Language Key	T002
4	MTART	☐	MTART	MTART	CHAR	4	0	Material type	T134
5	MBRSH	☐	MBRSH	MBRSH	CHAR	1	0	Industry sector	T137
6	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
7	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
8	LVORM	☐	LVOMA	XFELD	CHAR	1	0	Flag Material for Deletion at Client Level
9	LAEDA	☐	LAEDA	DATUM	DATS	8	0	Date of Last Change
10	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
11	ERSDA	☐	ERSDA	DATUM	DATS	8	0	Created On
12	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
13	VPSTA	☐	VPSTA	PSTAT	CHAR	15	0	Maintenance status of complete material
14	PSTAT	☐	PSTAT_D	PSTAT	CHAR	15	0	Maintenance status
15	MAKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description
16	BREIT	☐	BREIT	MENG13	QUAN	13	3	Width
17	HOEHE	☐	HOEHE	MENG13	QUAN	13	3	Height
18	LAENG	☐	LAENG	MENG13	QUAN	13	3	Length
19	MEABM	☐	MEABM	MEINS	UNIT	3	0	Unit of Dimension for Length/Width/Height	T006
20	BRGEW	☐	BRGEW	MENG13	QUAN	13	3	Gross weight
21	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
22	VOLUM	☐	VOLUM	MENG13	QUAN	13	3	Volume
23	VOLEH	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	T006
24	NTGEW	☐	NTGEW	MENG13	QUAN	13	3	Net weight
25	BISMT	☐	BISMT	BISMT	CHAR	18	0	Old material number
26	GROES	☐	GROES	CHAR32	CHAR	32	0	Size/dimensions
27	LABOR	☐	LABOR	LABOR	CHAR	3	0	Laboratory/design office	T024L
28	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
29	EAN11	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
30	NUMTP	☐	NUMTP	NUMTP	CHAR	2	0	Category of International Article Number (EAN)	TNTP
31	PRDHA	☐	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy	T179
32	BEGRU	☐	BEGRU	BEGRU	CHAR	4	0	Authorization Group
33	EXTWG	☐	EXTWG	EXTWG	CHAR	18	0	External material group	TWEW
34	MSTAE	☐	MSTAE	MMSTA	CHAR	2	0	Cross-Plant Material Status	T141
35	MSTDE	☐	MSTDE	DATUM	DATS	8	0	Date from which the cross-plant material status is valid
36	KOSCH	☐	KOSCH	KOSCH	CHAR	18	0	Product allocation determination procedure	T190S
37	MAKTG	☐	MAKTG	CHAR40	CHAR	40	0	Material description in upper case for matchcodes

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ENT1027	EXTWG	TWEW	EXTWG
2	ENT1027	GEWEI	T006	MSEHI	REF	C	CN
3	ENT1027	KOSCH	T190S	KOSCH
4	ENT1027	LABOR	T024L	LABOR	REF	C	CN
5	ENT1027	MANDT	T000	MANDT	KEY	1	CN
6	ENT1027	MATKL	T023	MATKL	REF	C	CN
7	ENT1027	MBRSH	T137	MBRSH	REF	C	CN
8	ENT1027	MEABM	T006	MSEHI	REF	C	CN
9	ENT1027	MEINS	T006	MSEHI	REF	1	CN
10	ENT1027	MSTAE	T141	MMSTA
11	ENT1027	MTART	T134	MTART	REF	1	CN
12	ENT1027	NUMTP	TNTP	NUMTP	REF	C	CN
13	ENT1027	PRDHA	T179	PRODH	REF	C	CN
14	ENT1027	SPART	TSPA	SPART	REF	C	CN
15	ENT1027	SPRAS	T002	SPRAS	KEY	1	CN
16	ENT1027	VOLEH	T006	MSEHI	REF	C	CN

History

Last changed by/on	SAP	20140121
SAP Release Created in