ASMD is a standard SAP table in SAP ERP (or) S/4HANA which stores Service Master: Basic Data data. There are total 39 fields in ASMD table.This blog post provides key technical details of SAP table ASMD, including its availability across SAP S/4HANA versions and the list of CDS views for ASMD table in SAP.
| SAP HANA Table Type | Column Store |
|---|---|
| Buffering Permission | Buffering not allowed |
| Buffering Type | No buffering |
| Package | Service master (MASB) |
| Technical Component | External Services (MM-SRV) |
SAP ASMD Table Fields
The following is the list of fields that are available in SAP ASMD table. The key fields of the table are highlighted in color.
| Field | Description | Data Element | Domain | Check Table | Data Type |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | MANDT | T000 | CLNT (3) |
| ASNUM | Activity Number | ASNUM | ASNUM | CHAR (18) | |
| ERDAT | Date on which the record was created | ERDAT | DATUM | DATS (8) | |
| ERNAM | Name of Person who Created the Object | ERNAM | USNAM | CHAR (12) | |
| AEDAT | Date of Last Change | AEDAT | DATUM | DATS (8) | |
| AENAM | Name of person who changed object | AENAM | USNAM | CHAR (12) | |
| LVORM | Deletion Indicator | LVORM | XFELD | CHAR (1) | |
| MATKL | Material Group | MATKL_SRV | MATKL | T023 | CHAR (9) |
| MEINS | Base Unit of Measure | MEINS | MEINS | T006 | UNIT (3) |
| ASTYP | Service Category | ASTYP | ASTYP | T362 | CHAR (4) |
| PAKNR | Package number | PACKNO | PACKNO | ESLH | NUMC (10) |
| EAN11 | International Article Number (EAN/UPC) | EAN11 | EAN11 | CHAR (18) | |
| NUMTP | Category of International Article Number (EAN) | NUMTP | NUMTP | TNTP | CHAR (2) |
| SPART | Division | SPART | SPART | TSPA | CHAR (2) |
| BEGRU | Authorization Group | BEGRU | BEGRU | CHAR (4) | |
| MSTAE | General Purchasing Status for Service | LSTAE | MMSTA | T141 | CHAR (2) |
| MSTDE | Validity Date for “Purchasing” Status | LSTDE | DATUM | DATS (8) | |
| BKLAS | Valuation Class | BWKLL | BKLAS | T025 | CHAR (4) |
| LSTHI | Hierarchy Service Number | ASNUM_HI | ASNUM | ASMD | CHAR (18) |
| MLANG | Primary language for object texts | MLANG | SPRAS | T002 | LANG (1) |
| LGART | Wage type | LOHNART | LOART | CHAR (4) | |
| LBNUM | Short Description of Service Type | LBNUM | CHAR3 | CHAR (3) | |
| AUSGB | Edition of Service Type | AUSGB | NUMC4 | NUMC (4) | |
| STLVPOS | Standard Service Catalog Item | STLVPOS | CHAR18 | CHAR (18) | |
| TAXIM | Tax Indicator for Service (Purchasing) | TAXIS | TAXIM1 | CHAR (1) | |
| IWUMZ | Numerator for conversion of MEINS into IWEIN | IWUMZ | UMBSZ | DEC (5) | |
| IWUMN | Denominator for Conversion (MEINS <-> IWEIN) | IWUMN | UMBSN | DEC (5) | |
| IWEIN | Unit for Work | IWEIN | MEINS | T006 | UNIT (3) |
| FORMELNR | Formula Number | FORMELNR | CHAR10 | T167F | CHAR (10) |
| CHGTEXT | Short Text Change Allowed | CHGTEXT | XFELD | CHAR (1) | |
| IMAGE_URL | Uniform resource locator | URL | TEXT132 | CHAR (132) | |
| USERF1_NUM | User-Defined Field | USERF1_NUM | NUMC10 | NUMC (10) | |
| USERF2_NUM | User-Defined Field | USERF2_NUM | MENGE | QUAN (13) | |
| USERF1_TXT | User-Defined Field | USERF1_TXT | TEXT40 | CHAR (40) | |
| USERF2_TXT | User-Defined Field | USERF2_TXT | TEXT10 | CHAR (10) | |
| BOSGRP | Subcontractor group | BOSGRP | BOSGRP | TBOSGRP | CHAR (4) |
| BOSMODEL | Costing Model | CK_COSTMODEL | ABC_TEMPL | COTPL | CHAR (10) |
| /SAPBOQ/MITEM | Main Item | /SAPBOQ/MITEM | XFELD | CHAR (1) | |
| TAXTARIFFCODE | Tax Tariff Code | J_1B_TAX_TARIFF_CODE | STEUC | T604F | CHAR (16) |
Availability
The SAP table ASMD is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.
| SAP S/4HANA Version | Available? |
|---|---|
| 1909 | Yes |
| 2020 | Yes |
| 2021 | Yes |
| 2022 | Yes |
| 2023 | Yes |
CDS Views for ASMD table
The following is the list of ASMD CDS views, which can also be used instead of ASMD table based on your business requirements.
| CDS View | CDS View Type | Description |
|---|---|---|
| I_TRIPSERVICENUMBERVH | BASIC | Service Number Value Help |
