The ASMD table in SAP ERP or S/4HANA stores Service Master: Basic Data data. There are total 39 fields in ASMD table. The Service Master: Basic Data table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of ASMD table. It is in Service master (MASB) ABAP package and is part of the External Services (MM-SRV) module.
SAP ASMD Table Fields
Following is the list of fields that are available in SAP ASMD table. The primary key fields of the table are MANDT (Client), ASNUM (Activity Number).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT (3) |
| ASNUM | Activity Number | ASNUM | CHAR (18) | |
| ERDAT | Date on which the record was created | ERDAT | DATS (8) | |
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR (12) | |
| AEDAT | Date of Last Change | AEDAT | DATS (8) | |
| AENAM | Name of person who changed object | AENAM | CHAR (12) | |
| LVORM | Deletion Indicator | LVORM | CHAR (1) | |
| MATKL | Material Group | MATKL_SRV | T023 | CHAR (9) |
| MEINS | Base Unit of Measure | MEINS | T006 | UNIT (3) |
| ASTYP | Service Category | ASTYP | T362 | CHAR (4) |
| PAKNR | Package number | PACKNO | ESLH | NUMC (10) |
| EAN11 | International Article Number (EAN/UPC) | EAN11 | CHAR (18) | |
| NUMTP | Category of International Article Number (EAN) | NUMTP | TNTP | CHAR (2) |
| SPART | Division | SPART | TSPA | CHAR (2) |
| BEGRU | Authorization Group | BEGRU | CHAR (4) | |
| MSTAE | General Purchasing Status for Service | LSTAE | T141 | CHAR (2) |
| MSTDE | Validity Date for “Purchasing” Status | LSTDE | DATS (8) | |
| BKLAS | Valuation Class | BWKLL | T025 | CHAR (4) |
| LSTHI | Hierarchy Service Number | ASNUM_HI | ASMD | CHAR (18) |
| MLANG | Primary language for object texts | MLANG | T002 | LANG (1) |
| LGART | Wage type | LOHNART | CHAR (4) | |
| LBNUM | Short Description of Service Type | LBNUM | CHAR (3) | |
| AUSGB | Edition of Service Type | AUSGB | NUMC (4) | |
| STLVPOS | Standard Service Catalog Item | STLVPOS | CHAR (18) | |
| TAXIM | Tax Indicator for Service (Purchasing) | TAXIS | CHAR (1) | |
| IWUMZ | Numerator for conversion of MEINS into IWEIN | IWUMZ | DEC (5) | |
| IWUMN | Denominator for Conversion (MEINS <-> IWEIN) | IWUMN | DEC (5) | |
| IWEIN | Unit for Work | IWEIN | T006 | UNIT (3) |
| FORMELNR | Formula Number | FORMELNR | T167F | CHAR (10) |
| CHGTEXT | Short Text Change Allowed | CHGTEXT | CHAR (1) | |
| IMAGE_URL | Uniform resource locator | URL | CHAR (132) | |
| USERF1_NUM | User-Defined Field | USERF1_NUM | NUMC (10) | |
| USERF2_NUM | User-Defined Field | USERF2_NUM | QUAN (13) | |
| USERF1_TXT | User-Defined Field | USERF1_TXT | CHAR (40) | |
| USERF2_TXT | User-Defined Field | USERF2_TXT | CHAR (10) | |
| BOSGRP | Subcontractor group | BOSGRP | TBOSGRP | CHAR (4) |
| BOSMODEL | Costing Model | CK_COSTMODEL | COTPL | CHAR (10) |
| /SAPBOQ/MITEM | Main Item | /SAPBOQ/MITEM | CHAR (1) | |
| TAXTARIFFCODE | Tax Tariff Code | J_1B_TAX_TARIFF_CODE | T604F | CHAR (16) |
