SE11 ABAP Dictionary SE11 MLAN

Data SE16 SE16
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

Dictionary Fields Fields

(13 dari 13 kolom)
# 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.