SE11 ABAP Dictionary SE11 MLAN

Popular:

VBAK VBAP MARA MAKT BKPF BSEG BVOR EKKO EKPO KNA1 LFA1 LIKP VBRK

MLAN

Tax Classification for Material

SAP SAP Transparent Table 13 Fields

Primary Key:

MANDT MATNR ALAND

#	Field Name	Key	Field Label	Type	Length	Dec	Check Table	Short Description
1	MANDT	KEY	Client	CLNT	3	-	T000	Client
2	MATNR	KEY	Material	CHAR	18	-	MARA	Material Number
3	ALAND	KEY	Country	CHAR	3	-	-	Departure country (country from which the goods are sent)
4	TAXM1	-	Tax class.	CHAR	1	-	-	Tax classification material
5	TAXM2	-	Tax class.	CHAR	1	-	-	Tax classification material
6	TAXM3	-	Tax class.	CHAR	1	-	-	Tax classification material
7	TAXM4	-	Tax class.	CHAR	1	-	-	Tax classification material
8	TAXM5	-	Tax class.	CHAR	1	-	-	Tax classification material
9	TAXM6	-	Tax class.	CHAR	1	-	-	Tax classification material
10	TAXM7	-	Tax class.	CHAR	1	-	-	Tax classification material
11	TAXM8	-	Tax class.	CHAR	1	-	-	Tax classification material
12	TAXM9	-	Tax class.	CHAR	1	-	-	Tax classification material
13	TAXIM	-	Tax ind.	CHAR	1	-	-	Tax indicator for material (Purchasing)

Related References & SQL

Diagram ERD, T-Code standar, tabel terkait, dan contoh query untuk MLAN.

Interactive ERD Diagrams

SAP MM - Master Data Relation → SAP SD - Links to MM Tables →

Standard T-Codes

SE11 SE16

Related Tables

MARA MAKT MARM MARC MBEW MVKE T179 STXH

ANSI SQL Query

SELECT a.MATNR,
       a.ALAND,
       a.TAXM1,
       a.TAXM2,
       a.TAXM3,
       a.TAXM4,
       a.TAXM5
FROM MLAN AS a
WHERE a.MATNR = 'FG-100'
  AND a.ALAND = '0001';

ABAP OpenSQL (7.40+)

SELECT a~matnr,
       a~aland,
       a~taxm1,
       a~taxm2,
       a~taxm3,
       a~taxm4,
       a~taxm5
  FROM mlan AS a
  WHERE a~matnr = 'fg-100'
  and a~aland = '0001'
  INTO TABLE @DATA(lt_mlan)
  UP TO 100 ROWS.

SE11 ABAP Dictionary SE11 MLAN

MLAN

Dictionary Fields Fields

Related References & SQL