SAP Table ASMD
Service Master: Basic Data
ASMD (Service Master: Basic Data) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link ASMD to other SAP tables.
ASMD table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||
|
ASNUM
Activity Number
|
ASNUM |
CHAR
|
18 | 0 | ||||||||
|
ERDAT
Date on Which Record Was Created
|
ERDAT |
DATS
|
8 | 0 | ||||||||
|
ERNAM
Name of Person who Created the Object
|
ERNAM |
CHAR
|
12 | 0 | ||||||||
|
AEDAT
Changed On
|
AEDAT |
DATS
|
8 | 0 | ||||||||
|
AENAM
Name of Person Who Changed Object
|
AENAM |
CHAR
|
12 | 0 | ||||||||
|
LVORM
Deletion Indicator
|
LVORM |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
MATKL
Material Group
|
MATKL_SRV | T023 |
CHAR
|
9 | 0 | |||||||
|
MEINS
Base Unit of Measure
|
MEINS | T006 |
UNIT
|
3 | 0 | |||||||
|
ASTYP
Service Category
|
ASTYP | T362 |
CHAR
|
4 | 0 | |||||||
|
PAKNR
Package number
|
PACKNO | ESLH |
NUMC
|
10 | 0 | |||||||
|
EAN11
International Article Number (EAN/UPC)
|
EAN11 |
CHAR
|
18 | 0 | ||||||||
|
NUMTP
Category of International Article Number (EAN)
|
NUMTP | TNTP |
CHAR
|
2 | 0 | |||||||
|
SPART
Division
|
SPART | TSPA |
CHAR
|
2 | 0 | |||||||
|
BEGRU
Authorization Group
|
BEGRU |
CHAR
|
4 | 0 | ||||||||
|
MSTAE
General Purchasing Status for Service
|
LSTAE | T141 |
CHAR
|
2 | 0 | |||||||
|
MSTDE
Validity Date for "Purchasing" Status
|
LSTDE |
DATS
|
8 | 0 | ||||||||
|
BKLAS
Valuation Class
|
BWKLL | T025 |
CHAR
|
4 | 0 | |||||||
|
LSTHI
Hierarchy Service Number
|
ASNUM_HI | ASMD |
CHAR
|
18 | 0 | |||||||
|
MLANG
Primary language for object texts
|
MLANG | T002 |
LANG
|
1 | 0 | |||||||
|
LGART
Wage Type
|
LOHNART |
CHAR
|
4 | 0 | ||||||||
|
LBNUM
Short Description of Service Type
|
LBNUM |
CHAR
|
3 | 0 | ||||||||
|
AUSGB
Edition of Service Type
|
AUSGB |
NUMC
|
4 | 0 | ||||||||
|
STLVPOS
Standard Service Catalog Item
|
STLVPOS |
CHAR
|
18 | 0 | ||||||||
|
TAXIM
Tax Indicator for Service (Purchasing)
|
TAXIS |
CHAR
|
1 | 0 | ||||||||
|
IWUMZ
Numerator for conversion of MEINS into IWEIN
|
IWUMZ |
DEC
|
5 | 0 | ||||||||
|
IWUMN
Denominator for Conversion (MEINS <-> IWEIN)
|
IWUMN |
DEC
|
5 | 0 | ||||||||
|
IWEIN
Unit for Work
|
IWEIN | T006 |
UNIT
|
3 | 0 | |||||||
|
FORMELNR
Formula Number
|
FORMELNR | T167F |
CHAR
|
10 | 0 | |||||||
|
CHGTEXT
Short Text Change Allowed
|
CHGTEXT |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
IMAGE_URL
Uniform Resource Locator
|
URL |
CHAR
|
132 | 0 | ||||||||
|
TAXTARIFFCODE
Tax Tariff Code
|
J_1B_TAX_TARIFF_CODE | T604F |
CHAR
|
16 | 0 | |||||||
ASMD foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| ASMD | ASTYP | ASMD | MANDT |
T362
Service Categories
|
MANDT |
| ASMD | ASTYP | ASMD | ASTYP |
T362
Service Categories
|
ASTYP |
| ASMD | BKLAS | ASMD | MANDT |
T025
Valuation Classes
|
MANDT |
| ASMD | BKLAS | ASMD | BKLAS |
T025
Valuation Classes
|
BKLAS |
| ASMD | FORMELNR | ASMD | MANDT |
T167F
Formulas for Service Lines
|
MANDT |
| ASMD | FORMELNR | ASMD | FORMELNR |
T167F
Formulas for Service Lines
|
FORMELNR |
| ASMD | IWEIN | ASMD | MANDT |
T006
Units of Measurement
|
MANDT |
| ASMD | IWEIN | ASMD | IWEIN |
T006
Units of Measurement
|
MSEHI |
| ASMD | LSTHI | ASMD | MANDT |
ASMD
Service Master: Basic Data
|
MANDT |
| ASMD | LSTHI | ASMD | LSTHI |
ASMD
Service Master: Basic Data
|
ASNUM |
| ASMD | MANDT | ASMD | MANDT |
T000
Clients
|
MANDT |
| ASMD | MATKL | ASMD | MATKL |
T023
Material Groups
|
MATKL |
| ASMD | MATKL | ASMD | MANDT |
T023
Material Groups
|
MANDT |
| ASMD | MEINS | ASMD | MANDT |
T006
Units of Measurement
|
MANDT |
| ASMD | MEINS | ASMD | MEINS |
T006
Units of Measurement
|
MSEHI |
| ASMD | MLANG | ASMD | MLANG |
T002
Language Keys (Component BC-I18)
|
SPRAS |
| ASMD | MSTAE | ASMD | MANDT |
T141
Material Status from Materials Management/PPC View
|
MANDT |
| ASMD | MSTAE | ASMD | MSTAE |
T141
Material Status from Materials Management/PPC View
|
MMSTA |
| ASMD | NUMTP | ASMD | MANDT |
TNTP
International Article Number (EAN) Categories
|
MANDT |
| ASMD | NUMTP | ASMD | NUMTP |
TNTP
International Article Number (EAN) Categories
|
NUMTP |
| ASMD | PAKNR | ASMD | MANDT |
ESLH
Service Package Header Data
|
MANDT |
| ASMD | PAKNR | ASMD | PAKNR |
ESLH
Service Package Header Data
|
PACKNO |
| ASMD | SPART | ASMD | MANDT |
TSPA
Organizational Unit: Sales Divisions
|
MANDT |
| ASMD | SPART | ASMD | SPART |
TSPA
Organizational Unit: Sales Divisions
|
SPART |
| ASMD | TAXTARIFFCODE | ASMD | TAXTARIFFCODE |
T604F
Import Processing: Control Code
|
STEUC |
| ASMD | TAXTARIFFCODE | SYST | MANDT |
T604F
Import Processing: Control Code
|
MANDT |
| ASMD | TAXTARIFFCODE | 'BR' |
T604F
Import Processing: Control Code
|
LAND1 |