MLKEY SAP (Material ledger data display: Selection fields) Structure details

Dictionary Type: Structure
Description: Material ledger data display: Selection fields




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




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

MLKEY is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Material ledger data display: Selection fields" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_MLKEY TYPE MLKEY.

The MLKEY table consists of various fields, each holding specific information or linking keys about Material ledger data display: Selection fields data available in SAP. These include BWKEY (Valuation Area), BUKRS (Company Code), WERKS (Plant), BWTAR (Valuation Type).. 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:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)


SAP MLKEY structure 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
MATNRMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
BWKEYValuation Area BWKEYCHAR4Assigned to domainBWKEYBWK
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
WERKSPlant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
BWTARValuation Type BWTAR_DCHAR10Assigned to domainBWTARBWT
VBELNSales and Distribution Document Number VBELNCHAR10Assigned to domainALPHAVBELNAUN
POSNRItem number of the SD document POSNRNUMC6Assigned to domainPOSNR
PSPNRWork Breakdown Structure Element (WBS Element) PS_PSP_PNRNUMC8Assigned to domainKONPRPS_POSNR
BDATJPosting Date YYYY BDATJNUMC4GJAHRGJAHRBDTJ
POPERPosting period POPERNUMC3POPERPOPR
BUKRS_ML_ACTIVECompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
BUKRS_ML_ACTIVE_NOT_PRODUCTIVECompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
BUKRS_ML_PRODUCTIVECompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
WERKS_ML_ACTIVEPlant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
WERKS_ML_ACTIVE_NOT_PRODUCTIVEPlant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
WERKS_ML_PRODUCTIVEPlant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
STATUSMaterial ledger period status CK_MLSTATNUMC2CK_MLSTAT
CURTPCurrency Type and Valuation View CURTPCHAR2CURTP
WAERSCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10Assigned to domainALPHALIFNRLIFKRED_C
BUKRS_CCS_ACTIVECompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
WERKS_CCS_ACTIVEPlant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
CKM3_VIEWDisplay Material Price Analysis: View Selection CKML_CKM3_VIEWCHAR2CKML_CKM3_VIEW
SOBKZSpecial Stock Indicator SOBKZCHAR1Assigned to domainSOBKZ
.INCLU--AP 0
KALNRCost Estimate Number for Cost Est. w/o Qty Structure CK_KALNRNUMC12Assigned to domainCK_KALNRKNR
RUN_IDNumber of Costing Runs for Material Ledger CKML_RUN_IDNUMC12Assigned to domainCKML_RUN_ID
IS_AGGRCheckbox XFELDCHAR1XFELD
UNTPERValue Structure Type CK_UNTPERNUMC3CK_UNTPER
XVNBRevaluation of Consumption Completed CKML_XVNBCHAR1CKML_STATUS_FLAG
XWIPWIP Price Determination Completed CKML_XWIPCHAR1CKML_STATUS_FLAG
XOBJWIPWIP Calculated in Cost Object Controlling CKML_XOBJWIPCHAR1CKML_STATUS_FLAG
XCKMMML- Price Determination Control was Changed: (CKMM) CKML_XCKMMCHAR1XFELD
XCLEANALL ML-Relevant Postings for the Period Were Reversed CKML_XCLEANCHAR1XFELD

Key field Non-key field



How do I retrieve data from SAP structure MLKEY using ABAP code?

As MLKEY is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on MLKEY as there is no data to select.

How to access SAP table MLKEY

Within an ECC or HANA version of SAP you can also view further information about MLKEY 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!