/1MD/MD______09J SAP (MM At/Rel MATERIAL / MATVALUA) Table details
Dictionary Type: Table
Description: MM At/Rel MATERIAL / MATVALUA
Description: MM At/Rel MATERIAL / MATVALUA
ABAP Code to SELECT data from /1MD/MD______09J
Related tables to /1MD/MD______09J
Access table /1MD/MD______09J
Related tables to /1MD/MD______09J
Access table /1MD/MD______09J
Table field list including key, data, relationships and ABAP select examples
/1MD/MD______09J is a standard SAP Table which is used to store MM At/Rel MATERIAL / MATVALUA data and is available within R/3 SAP systems depending on the version and release level.
The /1MD/MD______09J table consists of various fields, each holding specific information or linking keys about MM At/Rel MATERIAL / MATVALUA data available in SAP. These include USMDKMMMATERIAL (Technical Key), /1MD/MMBWKEY (Valuation Area), /1MD/MMBWTAR (Valuation Type), USMD_ACTIVE (Active/Inactive Data Record).. 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______09J 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/MMBWKEY | Valuation Area | BWKEY | CHAR | 4 | Assigned to domain | BWKEY | BWK | ||
| /1MD/MMBWTAR | Valuation Type | BWTAR_D | CHAR | 10 | Assigned to domain | BWTAR | BWT | ||
| USMD_ACTIVE | Active/Inactive Data Record | USMD_ACTIVE | CHAR | 1 | USMD_ACTIVE | ||||
| USMD_O_MBEWVALUA | Obsolete Data Record | USMD_OBSOLETE | CHAR | 1 | USMD_FLG | ||||
| /1MD/MMBKLAS | Valuation Class | BKLAS | CHAR | 4 | Assigned to domain | BKLAS | |||
| /1MD/MMBWTTY | Valuation Category | BWTTY_D | CHAR | 1 | Assigned to domain | BWTTY | |||
| /1MD/MMEKLAS | Valuation Class for Sales Order Stock | EKLAS | CHAR | 4 | Assigned to domain | BKLAS | |||
| /1MD/MMFZPLD1 | Date from Which Future Planned Price 1 Is Valid | DZPLD1 | DATS | 8 | DATUM | ||||
| /1MD/MMFZPLD2 | Date from Which Future Planned Price 2 Is Valid | DZPLD2 | DATS | 8 | DATUM | ||||
| /1MD/MMFZPLD3 | Date from Which Future Planned Price 3 Is Valid | DZPLD3 | DATS | 8 | DATUM | ||||
| /1MD/MMFZPLP1 | Future Planned Price 1 | DZPLP1 | CURR | 11(2) | WERT11 | ||||
| /1MD/MMFZPLP2 | Future Planned Price 2 | DZPLP2 | CURR | 11(2) | WERT11 | ||||
| /1MD/MMFZPLP3 | Future Planned Price 3 | DZPLP3 | CURR | 11(2) | WERT11 | ||||
| /1MD/MMFZPLPR | Future planned price | DZPLPR | CURR | 11(2) | WERT11 | ||||
| /1MD/MMMBEWLVORM | Deletion flag for all material data of a valuation type | LVOBA | CHAR | 1 | XFELD | ||||
| /1MD/MMMTORG | Origin of the material | J_1BMATORG | CHAR | 1 | J_1BMATORG | ||||
| /1MD/MMMTUSE | Usage of the material | J_1BMATUSE | CHAR | 1 | J_1BMATUSE | ||||
| /1MD/MMOWNPR | Produced in-house | J_1BOWNPRO | CHAR | 1 | XFELD | ||||
| /1MD/MMPEINH | Price Unit | PEINH | DEC | 5 | PACK3 | ||||
| /1MD/MMQKLAS | Valuation Class for Project Stock | QKLAS | CHAR | 4 | Assigned to domain | BKLAS | |||
| /1MD/MMSTPRS | Standard price | STPRS | CURR | 11(2) | WERT11V | ||||
| /1MD/MMSTPRV | Previous price | STPRV | CURR | 11(2) | WERT11V | ||||
| /1MD/MMVERPR | Moving Average Price/Periodic Unit Price | VERPR | CURR | 11(2) | WERT11V | ||||
| /1MD/MMVPRSV | Price control indicator | VPRSV | CHAR | 1 | VPRSV |
| Key field | Non-key field |
How do I retrieve data from SAP table /1MD/MD______09J using ABAP code
The following ABAP code Example will allow you to do a basic selection on /1MD/MD______09J to SELECT all data from the tableDATA: WA_/1MD/MD______09J TYPE /1MD/MD______09J.
SELECT SINGLE *
FROM /1MD/MD______09J
INTO CORRESPONDING FIELDS OF WA_/1MD/MD______09J
WHERE...
How to access SAP table /1MD/MD______09J
Within an ECC or HANA version of SAP you can also view further information about /1MD/MD______09J 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