MDPHASES SAP (Markdown Planning: Phase Data for Planned/Actual Comparison) Structure details
Description: Markdown Planning: Phase Data for Planned/Actual Comparison
Structure field list including key, data, relationships and ABAP select examples
MDPHASES 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 "Markdown Planning: Phase Data for Planned/Actual Comparison" 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_MDPHASES TYPE MDPHASES.
The MDPHASES table consists of various fields, each holding specific information or linking keys about Markdown Planning: Phase Data for Planned/Actual Comparison data available in SAP. These include MANDT (Client), MFCNR (Document no. of markdown plan), POSNR (Item number), UPOSN (Sub-item number for item number).. 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 MDPHASES 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 |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
MFCNR | Document no. of markdown plan | W_MFCNR | CHAR | 10 | WMFH | MFCNR | MFE | ||
POSNR | Item number | W_POSNR | NUMC | 6 | NUMC6 | ||||
UPOSN | Sub-item number for item number | W_UPOSN | NUMC | 6 | NUMC6 | ||||
VRKME | Sales unit | VRKME | UNIT | 3 | T006 | CUNIT | MEINS | ||
MDPRZ | Markdown planning: percentage of initial sales price | W_MDPRZ | DEC | 15(2) | PROZV8 | ||||
MDWRT | Markdown value | W_MDWRT | CURR | 13(2) | WERT | ||||
MDROS | Sales within a price phase as percentage of overall season | W_MDROS | DEC | 15(2) | PROZV8 | ||||
DATAB | Starting date of sales price in a price phase | W_DATAB | DATS | 8 | DATS | ||||
VKKPS | Maintenance status of sales prices | VKKPS | CHAR | 1 | VKKPS_MD | ||||
PSALM | Planned sales quantity in sales unit | W_PSALM | QUAN | 13(3) | MENGE | ||||
PSALW | Planned sales at retail price | W_PSALW | CURR | 13(2) | WERT | ||||
PSALC | Planned sales at purchase price | W_PSALC | CURR | 13(2) | WERT | ||||
PSALP | Planned sales at delivered price/net/net purchase price | W_PSALP | CURR | 13(2) | WERT | ||||
PANFM | Planned initial stock | W_PANFM2 | QUAN | 13(3) | MENGV13 | ||||
CUREP | Purchase price currency | W_WAEEK | CUKY | 5 | TCURC | WAERS | |||
EPEIN | Price Unit | EPEIN | DEC | 5 | DEC5 | ||||
BBPRM | Order Price Unit (Purchasing) | BBPRM | UNIT | 3 | T006 | CUNIT | MEINS | ||
CURVP | Sales price currency | W_CURVP | CUKY | 5 | TCURC | WAERS | |||
EKPGR | Purchase Price Calculation: (Basic Purchase Price) | EKPGR | CURR | 11(2) | WERTV6 | ||||
EKPNN | Sales Pricing: Purchase Price (Net/Net) | EKPNN | CURR | 11(2) | WERTV6 | ||||
VKPBR | Sales price (gross) | VKPBR | CURR | 11(2) | WERTV6 | ||||
ENDPR | Final price | ENDPR | CURR | 11(2) | WERTV6 | ||||
SPANE | Margin (net) in Sales Price Calculation | W_MDSPANE | CURR | 11(2) | WERTV6 | ||||
SPABR | Margin (gross) in Sales Price Calculation | W_MDSPABR | CURR | 11(2) | WERTV6 | ||||
SPWRT | Gross margin | W_SPWRT | CURR | 13(2) | WERT | ||||
AUFSG | Markup in Sales Price Calculation | W_MDAUFSG | CURR | 11(2) | WERTV6 | ||||
VSPAN | Net warehouse margin | W_SPANE | CURR | 11(2) | WERTV6 | ||||
VSPAB | Gross warehouse margin | W_SPABR | CURR | 11(2) | WERTV6 | ||||
VAUFS | Warehouse markup | W_AUFSG | CURR | 11(2) | WERTV6 | ||||
VABGP | Transfer price, distribution center | W_VABGP | CURR | 11(2) | PREIS | ||||
SPANS | Status of the retail margin displayed | W_SPANS | CHAR | 1 | SPANS | ||||
MDPER | Markdown period in calendar days | W_MDPER | INT2 | 5 | INT2 | ||||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
AEDAT | Changed On | AEDAT | DATS | 8 | DATUM | ||||
PRESW | Planned Remaining Stock (Value) | W_PRESW | CURR | 13(2) | WERT | ||||
PRESM | Planned Remaining Quantity | W_PRESM2 | QUAN | 13(3) | MENGV13 | ||||
MAHIT | Margin Loss | W_MAHIT | CURR | 13(2) | WERT | ||||
PSALA | Markdown value | W_MDWRT | CURR | 13(2) | WERT | ||||
EKWVK | Purchase price in sales price currency and sales unit | W_EKWVK | CURR | 11(2) | WERTV6 | ||||
VKORG | Sales Organization | VKORG | CHAR | 4 | TVKO | VKORG | VKO | C_VKORG | |
VTWEG | Distribution Channel | VTWEG | CHAR | 2 | TVTW | VTWEG | VTW | C_VTWEG | |
ARTNR | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
MDQTE | Depreciation Quota | W_MDQTE | DEC | 15(2) | PROZV8 | ||||
PCMV | Remaining profit margin | W_PCMV | CURR | 13(2) | WERT | ||||
UPDKZ | Update indicator | UPDKZ_D | CHAR | 1 | UPDKZ | ||||
SELKZ | Selection flag | SELKZ | CHAR | 1 | SELKZ | ||||
PMATN | Pricing Reference Material | PMATN | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | |
CUOBF | Internal object number | CUOBM | NUMC | 18 | CUOBJ | ||||
SATNR | Cross-Plant Configurable Material | SATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | ||
ATTYP | Material Category | ATTYP | CHAR | 2 | ATTYP | MTY | |||
SPWRT2 | Actual Gross Margin | W_SPWRT2 | CURR | 13(2) | WERT | ||||
MAHIT2 | Actual Margin Losses | W_MAHIT2 | CURR | 13(2) | WERT | ||||
PSALMW | Planned Weekly Sales Quantity | W_PSALMW | QUAN | 13(3) | MENGE | ||||
PSALWW | Planned Weekly Invoiced Sales at Final Sales Prices | W_PSALWW | CURR | 13(2) | WERT | ||||
UMSMNG | Sales quantity in base unit of measure | MCW_UMSMNG | QUAN | 15(3) | MENGV15_3 | ||||
ACTMGW | Average Weekly Actual Sales Quantity | W_ACTMGW | QUAN | 13(3) | MENG13V | ||||
ABWMNG | Percentage Variance Between Actual and Planned Sales Qty | W_ABWM | DEC | 15(2) | PROZV8 | ||||
UMSGVO | Sales at retail | MCW_UMSGVO | CURR | 19(2) | WERTV10 | ||||
ACTUMW | Average Weekly Actual Sales | W_ACTUMW | CURR | 13(2) | WERT | ||||
ABWUMS | Percentage Variance Between Actual and Planned Sales | W_ABWW | DEC | 15(2) | PROZV8 | ||||
BVLMNG | Order volume quantity Retail | MCW_BVLMNG | QUAN | 15(3) | MENGV15_3 | ||||
WESMNG | Goods receipt (vendor) quantity in BUn | MCW_WESMNG | QUAN | 15(3) | MENGV15_3 |
Key field | Non-key field |
How do I retrieve data from SAP structure MDPHASES using ABAP code?
As MDPHASES 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 MDPHASES as there is no data to select.How to access SAP table MDPHASES
Within an ECC or HANA version of SAP you can also view further information about MDPHASES 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