SAP table ASMD (Service Master: Basic Data)
SAP table ASMD has 2 primary key fields being MANDT,ASNUM.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| ASNUM | Activity Number | CHAR | 18 | 0 | ASNUM | ||
| ERDAT | Date on which the record was created | DATS | 8 | 0 | ERDAT | ||
| ERNAM | Name of Person Responsible for Creating the Object | CHAR | 12 | 0 | ERNAM | ||
| AEDAT | Last Changed On | DATS | 8 | 0 | AEDAT | ||
| AENAM | Name of Person Who Changed Object | CHAR | 12 | 0 | AENAM | ||
| LVORM | Deletion Indicator | CHAR | 1 | 0 | LVORM | ||
| MATKL | Material Group | CHAR | 9 | 0 | T023 | MATKL_SRV | |
| MEINS | Base Unit of Measure | UNIT | 3 | 0 | T006 | MEINS | |
| ASTYP | Service Category | CHAR | 4 | 0 | T362 | ASTYP | |
| PAKNR | Package number | NUMC | 10 | 0 | ESLH | PACKNO | |
| EAN11 | International Article Number (EAN/UPC) | CHAR | 18 | 0 | EAN11 | ||
| NUMTP | Category of International Article Number (EAN) | CHAR | 2 | 0 | TNTP | NUMTP | |
| SPART | Division | CHAR | 2 | 0 | TSPA | SPART | |
| BEGRU | Authorization Group | CHAR | 4 | 0 | BEGRU | ||
| MSTAE | General Purchasing Status for Service | CHAR | 2 | 0 | T141 | LSTAE | |
| MSTDE | Validity Date for "Purchasing" Status | DATS | 8 | 0 | LSTDE | ||
| BKLAS | Valuation Class | CHAR | 4 | 0 | T025 | BWKLL | |
| LSTHI | Hierarchy Service Number | CHAR | 18 | 0 | ASMD | ASNUM_HI | |
| MLANG | Primary language for object texts | LANG | 1 | 0 | T002 | MLANG | |
| LGART | Wage type | CHAR | 4 | 0 | LOHNART | ||
| LBNUM | Short Description of Service Type | CHAR | 3 | 0 | LBNUM | ||
| AUSGB | Edition of Service Type | NUMC | 4 | 0 | AUSGB | ||
| STLVPOS | Standard Service Catalog Item | CHAR | 18 | 0 | STLVPOS | ||
| TAXIM | Tax Indicator for Service (Purchasing) | CHAR | 1 | 0 | TAXIS | ||
| IWUMZ | Numerator for conversion of MEINS into IWEIN | DEC | 5 | 0 | IWUMZ | ||
| IWUMN | Denominator for Conversion (MEINS <-> IWEIN) | DEC | 5 | 0 | IWUMN | ||
| IWEIN | Unit for Work | UNIT | 3 | 0 | T006 | IWEIN | |
| FORMELNR | Formula Number | CHAR | 10 | 0 | T167F | FORMELNR | |
| CHGTEXT | Short Text Change Allowed | CHAR | 1 | 0 | CHGTEXT | ||
| IMAGE_URL | Uniform resource locator | CHAR | 132 | 0 | URL | ||
| USERF1_NUM | User-Defined Field | NUMC | 10 | 0 | USERF1_NUM | ||
| USERF2_NUM | User-Defined Field | QUAN | 13 | 3 | USERF2_NUM | ||
| USERF1_TXT | User-Defined Field | CHAR | 40 | 0 | USERF1_TXT | ||
| USERF2_TXT | User-Defined Field | CHAR | 10 | 0 | USERF2_TXT | ||
| BOSGRP | Subcontractor group | CHAR | 4 | 0 | TBOSGRP | BOSGRP | |
| BOSMODEL | Costing Model | CHAR | 10 | 0 | COTPL | CK_COSTMODEL | |
| /SAPBOQ/MITEM | Main Item | CHAR | 1 | 0 | /SAPBOQ/MITEM | ||
| TAXTARIFFCODE | Tax Tariff Code | CHAR | 16 | 0 | T604F | J_1B_TAX_TARIFF_CODE |
ASMD foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 ASMD | ASTYP | T362 | Service Categories | MANDT |
| 1 ASMD | BKLAS | T025 | Valuation Classes | MANDT |
| 1 ASMD | BKLAS | T025 | Valuation Classes | BKLAS |
| 0 ASMD | BOSGRP | TBOSGRP | Service Line: Subcontractor Group | MANDT |
| 1 ASMD | BOSMODEL | COTPL | CO-ABC Template Master Data | MANDT |
| 1 ASMD | BOSMODEL | COTPL | CO-ABC Template Master Data | KOKRS |
| 1 ASMD | BOSMODEL | COTPL | CO-ABC Template Master Data | TEMPLATE |
| 0 ASMD | FORMELNR | T167F | Formulas for Service Lines | FORMELNR |
| 1 ASMD | IWEIN | T006 | Units of Measurement | MANDT |
| 1 ASMD | IWEIN | T006 | Units of Measurement | MSEHI |
| 0 ASMD | MANDT | T000 | Clients | MANDT |
| 1 ASMD | MATKL | T023 | Material Groups | MATKL |
| 0 ASMD | MEINS | T006 | Units of Measurement | MANDT |
| 0 ASMD | MEINS | T006 | Units of Measurement | MSEHI |
| 1 ASMD | MLANG | T002 | Language Keys (Component BC-I18) | SPRAS |
| 0 ASMD | MSTAE | T141 | Material Status from Materials Management/PPC View | MANDT |
| 0 ASMD | MSTAE | T141 | Material Status from Materials Management/PPC View | MMSTA |
| 1 ASMD | NUMTP | TNTP | International Article Number (EAN) Categories | MANDT |
| 1 ASMD | NUMTP | TNTP | International Article Number (EAN) Categories | NUMTP |
| 0 ASMD | PAKNR | ESLH | Service Package Header Data | PACKNO |
| 1 ASMD | SPART | TSPA | Organizational Unit: Sales Divisions | MANDT |
| 1 ASMD | SPART | TSPA | Organizational Unit: Sales Divisions | SPART |
| 0 ASMD | TAXTARIFFCODE | T604F | Import Processing: Control Code | MANDT |
| 0 ASMD | TAXTARIFFCODE | T604F | Import Processing: Control Code | LAND1 |