SAP ABAP View MGV_M_KBLME (Generated view for matchcode ID KBLM -E)

Hierarchy

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

Basic Data

View Type	D	Database View
Database View	MGV_M_KBLME
Short Description	Generated view for matchcode ID KBLM -E
Root table	KBLK	Document Header: Manual Document Entry

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	KBLK	KBLK
2	KBLP
3	MATERIALID

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	KBLK	MANDT	JL	EQ				0	1	KLOEKZ
2	KBLP	MANDT	JR	EQ			AND	0	1	KLOEKZ
3	KBLK	BELNR	JL	EQ				0	1	KLOEKZ
4	KBLP	BELNR	JR	EQ			AND	0	1	KLOEKZ
5	KBLP	MANDT	JL	EQ				0	1	KLOEKZ
6	MATERIALID	MANDT	JR	EQ			AND	0	1	KLOEKZ
7	KBLP	MATNR	JL	EQ				0	1	KLOEKZ
8	MATERIALID	MATNR_INT	JR	EQ			AND	0	1	KLOEKZ
9	KBLK	BLTYP		EQ	'001'		AND	0	3	BLTYP
10	KBLK	BLART		NE	'11'		AND	0	2	BLART
11	KBLP	LOEKZ		EQ	' '		AND	0	1	LOEKZ
12	KBLK	KLOEKZ		EQ	' '			0	1	KLOEKZ

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	KBLK	MANDT		☐	MANDT	☐	Client
2	BLART	KBLK	BLART		☐	KBLART	☐	Doc.type: Manual document entry
3	BLTYP	KBLK	BLTYP		☐	KBLTYP	☐	Earmarked Funds Document Category
4	BELNR	KBLK	BELNR		☐	KBLNR	☐	Document Number for Earmarked Funds
5	FDATK	KBLP	FDATK		☐	KBLFDATK	☐	Costs due on
6	KSTAR	KBLP	KSTAR		☐	KSTAR	☐	Cost Element
7	LOEKZ	KBLP	LOEKZ		☐	KBLLOEKZ	☐	Deletion Indicator
8	MATNR	KBLP	MATNR		☐	MATNR	☐	Material Number
9	LIFNR	KBLP	LIFNR		☐	LIFNR	☐	Account Number of Vendor or Creditor
10	AEDAT	KBLP	AEDAT		☐	KBLAEDAT	☐	Date of Last Change
11	AENDE	KBLP	AENDE		☐	KBLAEN	☐	Last changed by
12	PTEXT	KBLP	PTEXT		☐	SGTXT	☐	Item Text
13	BLPOS	KBLP	BLPOS		☐	KBLPOS	☐	Earmarked Funds: Document Item
14	MATNR_EXT	MATERIALID	MATNR_EXT		☐	MGV_MATNR_EXTERNAL	☑	Material Number
15	MATNR_VERS	MATERIALID	MATNR_VERS		☐	MGV_MATNR_VERSION	☑	Version Number for MATNR Field

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	20140121
SAP Release Created in	600