/1MD/MD______08K SAP (MM At/Rel MATERIAL / MATMARCFT) Table details
Dictionary Type: Table
Description: MM At/Rel MATERIAL / MATMARCFT
Description: MM At/Rel MATERIAL / MATMARCFT
ABAP Code to SELECT data from /1MD/MD______08K
Related tables to /1MD/MD______08K
Access table /1MD/MD______08K
Related tables to /1MD/MD______08K
Access table /1MD/MD______08K
Table field list including key, data, relationships and ABAP select examples
/1MD/MD______08K is a standard SAP Table which is used to store MM At/Rel MATERIAL / MATMARCFT data and is available within R/3 SAP systems depending on the version and release level.
The /1MD/MD______08K table consists of various fields, each holding specific information or linking keys about MM At/Rel MATERIAL / MATMARCFT data available in SAP. These include USMDKMMMATERIAL (Technical Key), /1MD/MMWERKS (Plant), USMD_ACTIVE (Active/Inactive Data Record), /1MD/MMCASMARCFT (CAS number for pharmaceutical products in foreign trade).. 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: Cannot Be Enhanced
SAP /1MD/MD______08K 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 |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
USMDKMMMATERIAL | Technical Key | USMD_TECH_KEY | INT4 | 10 | /1MD/MD______06H | INT4 | |||
/1MD/MMWERKS | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
USMD_ACTIVE | Active/Inactive Data Record | USMD_ACTIVE | CHAR | 1 | USMD_ACTIVE | ||||
/1MD/MMCASMARCFT | CAS number for pharmaceutical products in foreign trade | CASNR | CHAR | 15 | Assigned to domain | CASNR | |||
/1MD/MMGPNMARCFT | Production statistics: PRODCOM number for foreign trade | GPNUM | CHAR | 9 | Assigned to domain | GPNUM | |||
/1MD/MMHERMARCFT | Region of origin of material (non-preferential origin) | HERKR | CHAR | 3 | Assigned to domain | REGIO | |||
/1MD/MMMOGMARCFT | Common Agricultural Policy: CAP products group-Foreign Trade | MOGRU | CHAR | 6 | Assigned to domain | MOGRU | |||
/1MD/MMMOWMARCFT | CAP: Number of CAP products list | MOWNR | CHAR | 12 | Assigned to domain | MOWNR | |||
/1MD/MMSTAMARCFT | Commodity Code/Import Code Number for Foreign Trade | STAWN | CHAR | 17 | Assigned to domain | STAWN | |||
/1MD/MMSTEMARCFT | Control code for consumption taxes in foreign trade | STEUC | CHAR | 16 | Assigned to domain | STEUC | |||
USMD_O_MARCFRGTR | Obsolete Data Record | USMD_OBSOLETE | CHAR | 1 | USMD_FLG | ||||
/1MD/MMEXPME | Unit of measure for commodity code (foreign trade) | EXPME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
/1MD/MMHERKL | Country of origin of the material | HERKL | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
/1MD/MMINDUS | Material CFOP category | J_1BINDUS3 | CHAR | 2 | ALPHA | J_1BINDUS3 | |||
/1MD/MMITARK | Indicator: Military goods | ITARK | CHAR | 1 | XFELD | ||||
/1MD/MMMTVER | Export/import material group | MTVER | CHAR | 4 | Assigned to domain | MTVER | |||
/1MD/MMPREFE | Preference indicator in export/import | PREFE | CHAR | 1 | PREFE | ||||
/1MD/MMPRENC | Exemption certificate: Indicator for legal control | PRENC | CHAR | 1 | PRENC | ||||
/1MD/MMPREND | Exemption certificate: Issue date of exemption certificate | PREND | DATS | 8 | PREND | ||||
/1MD/MMPRENE | Indicator: Vendor declaration exists | PRENE | CHAR | 1 | PRENE | PNE | |||
/1MD/MMPRENG | Validity date of vendor declaration | PRENG | DATS | 8 | PRENG | PNG | |||
/1MD/MMPRENO | Exemption certificate number for legal control | PRENN | CHAR | 8 | PRENN |
Key field | Non-key field |
How do I retrieve data from SAP table /1MD/MD______08K using ABAP code
The following ABAP code Example will allow you to do a basic selection on /1MD/MD______08K to SELECT all data from the tableDATA: WA_/1MD/MD______08K TYPE /1MD/MD______08K.
SELECT SINGLE *
FROM /1MD/MD______08K
INTO CORRESPONDING FIELDS OF WA_/1MD/MD______08K
WHERE...
How to access SAP table /1MD/MD______08K
Within an ECC or HANA version of SAP you can also view further information about /1MD/MD______08K and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects