MARKDOWN SAP (Help structure for markdown planning) Structure details

Dictionary Type: Structure
Description: Help structure for markdown planning




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




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

MARKDOWN 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 "Help structure for markdown planning" 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_MARKDOWN TYPE MARKDOWN.

The MARKDOWN table consists of various fields, each holding specific information or linking keys about Help structure for markdown planning data available in SAP. These include MATKL (Material class (material group)), ARTBZ (Material Description (Short Text)), RETOH (Available stock managed on value basis (Retail on hand)), RETCU (Currency of the available stock managed on value basis).. 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: Not classified


SAP MARKDOWN 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
ARTNRMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
MATKLMaterial class (material group) F_MATKLCHAR9Assigned to domainMATKL
ARTBZMaterial Description (Short Text) MAKTXCHAR40TEXT40
RETOHAvailable stock managed on value basis (Retail on hand) F_RETOHCURR13(2) WERT
RETCUCurrency of the available stock managed on value basis F_RETCUCUKY5Assigned to domainWAERS
UNIOHAvailable stock managed on a quantity basis F_UNIOHQUAN13(3) MENG13V
ORDOHOpen purchase orders F_ORDOHQUAN13(3) MENG13V
UNITAUnit of measure F_UNITAUNIT3Assigned to domainCUNITMEINS
VKORGSales Organization F_VKORGCHAR4Assigned to domainVKORG
VTWEGDistribution channel F_VTWEGCHAR2Assigned to domainVTWEG
MARKDMarkdown percent F_MARKDNUMC3NUMC3
REFPEReference period for actual key figures F_REFPECHAR8CHAR8
REFUMBusiness volume in reference period F_REFUMCURR13(2) WERT
REFMGQuantity sold in reference period F_REFMGQUAN13(3) MENG13V
PLAPEPlanning period F_PLAPECHAR8CHAR8
UMSCUCurrency F_UMSCUCUKY5Assigned to domainWAERS
PLAUMPlanned business volume at sales prices F_PLAUMCURR13(2) WERT
UNITPUnit of measure F_UNITPUNIT3Assigned to domainCUNITMEINS
PLAMGPlanned sales quantity F_PLAMGQUAN13(3) MENG13V
PLRATMarkdown percent F_MARKDNUMC3NUMC3
ACTUMActual Business Volume F_ACTUMCURR13(2) WERT
ACTMGActual quantity sold F_ACTMGQUAN13(3) MENG13V
PRICESales price F_PRICECURR11(2) PREIS
ACTIVPrice activation status F_ACTIVCHAR1CHAR1
DATEFStarting date F_DATEFDATS8DATUM
DATEEEnd date F_DATEEDATS8DATUM
PROFIMarkdown profile F_PROFICHAR10CHAR10
PROMOPromotion number F_PROMOCHAR10CHAR10
SEASOSeason F_SEASOCHAR4CHAR4
STORGPlant group F_STORGNUMC10Assigned to domainCLINT
OFFSTMarkdown periods (days) F_OFFSTNUMC5NUMC5
MARKUMark-up percent F_MARKUNUMC3NUMC3
STOREPlant in markdown plan F_STORECHAR10CHAR10
MARGINMark-up percent F_MARKUNUMC3NUMC3
MARGINVPlanned business volume at sales prices F_PLAUMCURR13(2) WERT
WEEOHRange of coverage F_WEEOHQUAN13(3) MENGV13
SALEAPlanned business volume at sales prices F_PLAUMCURR13(2) WERT
GDRCVGoods receipt quantity per period F_GDRCVQUAN13(3) MENG13V
SVARIName of a selection variant for dyn. reading of info struct. SVARICHAR12Assigned to domainSVARI
SVINFName of info structure to be read SVINFCHAR8Assigned to domainMCINF
SVARITXTDetailed description of selection variant SVVARITXTCHAR60TEXT60
ISTXTInfo structure description ISTXTCHAR30TEXT30
NUMKINumber range in the case of internal number assignment NUMKICHAR2NUMKR
NUMKENumber range in the case of external number assignment NUMKECHAR2NUMKR
ANZWRKNumber of plants for distribution chain F_ANZWRKNUMC6NUMC6
ABWPSALWVariance in percent between rough-cut and detailed planning F_ABWDEC15(2) PROZV8
ABWPSALCVariance in percent between rough-cut and detailed planning F_ABWDEC15(2) PROZV8
ABWSPWRTVariance in percent between rough-cut and detailed planning F_ABWDEC15(2) PROZV8
ABWMAHITVariance in percent between rough-cut and detailed planning F_ABWDEC15(2) PROZV8
ABWPRESWVariance in percent between rough-cut and detailed planning F_ABWDEC15(2) PROZV8
ABWPSALAVariance in percent between rough-cut and detailed planning F_ABWDEC15(2) PROZV8
ABWMDQTEVariance in percent between rough-cut and detailed planning F_ABWDEC15(2) PROZV8
UMSGVOBusiness volume from exception analysis MD_UMSATZCHAR20MD_CHAR20
GRPTXTDescription of the Application Area W_GRPTXTCHAR60DDTEXT
CURVPSales price currency W_CURVPCUKY5Assigned to domainWAERS
VRKMESales unit VRKMEUNIT3Assigned to domainCUNITMEINS
MPRTXDescription BEZEI20CHAR20TEXT20
VKMETXCharacter Field Length = 10 CHAR10CHAR10CHAR10
BEMETXCharacter Field Length = 10 CHAR10CHAR10CHAR10
DATABStarting date of sales price in a price phase W_DATABDATS8DATS
KZ_STOCKQuantity Adjustment Based On Current Stock KZ_STOCKCHAR1FLAG
KZ_BTEQuantity Adjustment by Cus.-Specific Function Module (BTE) KZ_BTECHAR1FLAG

Key field Non-key field



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

As MARKDOWN 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 MARKDOWN as there is no data to select.

How to access SAP table MARKDOWN

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