SAP ABAP View MGV_T023 (Selection T023 with material version, see: http://material)

Hierarchy

☛ ECC-DIMP (Software Component) DIMP
   ⤷ LO-MD-MM (Application Component) Material Master
     ⤷ MGV_MATNR (Package) Material number conversion (long mat. no.)

Basic Data

View Type	D	Database View
Database View	MGV_T023
Short Description	Selection T023 with material version, see: http://material
Root table	T023	Material Groups

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	T023	T023
2	MATERIALID
3	T023T

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	T023	MANDT	JL	EQ				0	0
2	T023T	MANDT	JR	EQ			AND	0	0
3	T023	MANDT	JL	EQ				0	0
4	MATERIALID	MANDT	JR	EQ			AND	0	0
5	T023	WWGDA	JL	EQ				0	0
6	MATERIALID	MATNR_INT	JR	EQ			AND	0	0
7	T023	WWGPA	JL	EQ				0	0
8	MATERIALID	MATNR_INT	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	*	T023	*		☐		☐
2	MANDT	T023	MANDT		☐	MANDT	☐	Client
3	MATKL	T023	MATKL		☐	MATKL	☐	Material Group
4	SPART	T023	SPART		☐	SPART	☐	Division
5	LREF3	T023	LREF3		☐	LREF3	☐	Material group-related supply relat. between plants /DEACT.
6	WWGDA	T023	WWGDA		☐	WWGDA	☐	Material group reference material
7	WWGPA	T023	WWGPA		☐	WWGPA	☐	Material group material
8	ABTNR	T023	ABTNR		☐	ABTNR	☐	Department number
9	BEGRU	T023	BEGRU		☐	BEGRU	☐	Authorization Group
10	GEWEI	T023	GEWEI		☐	GEWEI_V	☐	Default unit of weight in the material master
11	J_1BNBM	T023	J_1BNBM		☐	J_1BNBMCO1	☐	Brazilian NCM Code
12	BKLAS	T023	BKLAS		☐	BKLAS	☐	Valuation Class
13	EKWSL	T023	EKWSL		☐	EKWSL	☐	Purchasing Value Key
14	ANLKL	T023	ANLKL		☐	MEVAK	☐	Default: Asset Class for Creation of Asset
15	DEF_SCHDSC	T023	DEF_SCHDSC		☐	EXP_SCHDSC	☐	Event Scenario
16	PRICE_GROUP	T023	PRICE_GROUP		☐	PRICE_GROUP	☐	Price Level Group
17	MATNR_EXT	MATERIALID	MATNR_EXT		☐	MATNR_EXT	☐	External Long Material Number
18	MATNR_VERS	MATERIALID	MATNR_VERS		☐	MATNR_VERS	☐	Material Version Number
19	WGBEZ	T023T	WGBEZ		☐	WGBEZ	☐	Material Group Description

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