SAP ASMD Service Master: Basic Data Table
Overview
ASMD is a standard SAP S/4HANA table that stores Service Master: Basic Data data. There are total 39 fields in the ASMD table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table ASMD belongs to External Services (MM-SRV) module and is located in the package Service master (MASB).
In addition, following links provide an overview of foreign key relationships, if any, that link ASMD to other SAP tables and standard CDS views available based on ASMD table in S/4HANA 2020.
Techincal Settings of ASMD
Below are technical details of the table ASMD
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of ASMD Fields
The following table gives you an overview of the fields available in ASMD
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| 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 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for ASMD
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| ASMD | ASTYP | : | T362 |
| ASMD | BKLAS | : | T025 |
| ASMD | BOSGRP | 1: CN | TBOSGRP |
| ASMD | BOSMODEL | 1: CN | COTPL |
| ASMD | FORMELNR | 1: CN | T167F |
| ASMD | IWEIN | : | T006 |
| ASMD | LSTHI | : | ASMD |
| ASMD | MANDT | : | T000 |
| ASMD | MATKL | : | T023 |
| ASMD | MEINS | : | T006 |
| ASMD | MLANG | : | T002 |
| ASMD | MSTAE | : | T141 |
| ASMD | NUMTP | : | TNTP |
| ASMD | PAKNR | : | ESLH |
| ASMD | SPART | : | TSPA |
| ASMD | TAXTARIFFCODE | 1: CN | T604F |