ASMD SAP (Service Master: Basic Data) Table details

Dictionary Type: Table
Description: Service Master: Basic Data




ABAP Code to SELECT data from ASMD
Related tables to ASMD
Access table ASMD




Table field list including key, data, relationships and ABAP select examples

ASMD is a standard SAP Table which is used to store Service Master: Basic Data data and is available within R/3 SAP systems depending on the version and release level.

The ASMD table consists of various fields, each holding specific information or linking keys about Service Master: Basic Data data available in SAP. These include ASNUM (Activity Number), ERDAT (Date on Which Record Was Created), ERNAM (Name of Person who Created the Object), AEDAT (Changed On).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

Text table = ASMDT


SAP ASMD table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
ASNUMActivity Number ASNUMCHAR18ALPHAASNUMASN
ERDATDate on Which Record Was Created ERDATDATS8DATUM
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
AEDATChanged On AEDATDATS8DATUM
AENAMName of Person Who Changed Object AENAMCHAR12USNAM
LVORMDeletion Indicator LVORMCHAR1XFELD
MATKLMaterial Group MATKL_SRVCHAR9T023MATKLMKLWBWG
MEINSBase Unit of Measure MEINSUNIT3T006CUNITMEINS
ASTYPService Category ASTYPCHAR4T362ASTYPASY
PAKNRPackage number PACKNONUMC10ESLHPACKNO
EAN11International Article Number (EAN/UPC) EAN11CHAR18EAN11EAN11EAN
NUMTPCategory of International Article Number (EAN) NUMTPCHAR2TNTPNUMTP
SPARTDivision SPARTCHAR2TSPASPARTSPAC_SPART
BEGRUAuthorization Group BEGRUCHAR4BEGRU
MSTAEGeneral Purchasing Status for Service LSTAECHAR2T141MMSTA
MSTDEValidity Date for 'Purchasing' Status LSTDEDATS8DATUM
BKLASValuation Class BWKLLCHAR4T025BKLAS
LSTHIHierarchy Service Number ASNUM_HICHAR18ASMDALPHAASNUM
MLANGPrimary language for object texts MLANGLANG1T002ISOLASPRAS
LGARTWage Type LOHNARTCHAR4LOART
LBNUMShort Description of Service Type LBNUMCHAR3CHAR3LBR
AUSGBEdition of Service Type AUSGBNUMC4NUMC4AGB
STLVPOSStandard Service Catalog Item STLVPOSCHAR18CHAR18
TAXIMTax Indicator for Service (Purchasing) TAXISCHAR1Assigned to domainTAXIM1
IWUMZNumerator for conversion of MEINS into IWEIN IWUMZDEC5UMBSZ
IWUMNDenominator for Conversion (MEINS <-> IWEIN) IWUMNDEC5UMBSN
IWEINUnit for Work IWEINUNIT3T006CUNITMEINS
FORMELNRFormula Number FORMELNRCHAR10T167FCHAR10
CHGTEXTShort Text Change Allowed CHGTEXTCHAR1XFELD
IMAGE_URLUniform Resource Locator URLCHAR132TEXT132
.INCLU--AP 0
USERF1_NUMUser-Defined Field USERF1_NUMNUMC10NUMC10
USERF2_NUMUser-Defined Field USERF2_NUMQUAN13(3) MENGE
USERF1_TXTUser-Defined Field USERF1_TXTCHAR40TEXT40
USERF2_TXTUser-Defined Field USERF2_TXTCHAR10TEXT10
BOSGRPSubcontractor group BOSGRPCHAR4TBOSGRPBOSGRP
BOSMODELCosting Model CK_COSTMODELCHAR10COTPLABC_TEMPLCK_COSTMODEL
/SAPBOQ/MITEMMain Item /SAPBOQ/MITEMCHAR1XFELD
.INCLU--AP 0
TAXTARIFFCODETax Tariff Code J_1B_TAX_TARIFF_CODECHAR16T604FSTEUC

Key field Non-key field



How do I retrieve data from SAP table ASMD using ABAP code

The following ABAP code Example will allow you to do a basic selection on ASMD to SELECT all data from the table
DATA: WA_ASMD TYPE ASMD.

SELECT SINGLE *
FROM ASMD
INTO CORRESPONDING FIELDS OF WA_ASMD
WHERE...

How to access SAP table ASMD

Within an ECC or HANA version of SAP you can also view further information about ASMD and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!