SAP ABAP Table MDPHASES (Markdown Planning: Phase Data for Planned/Actual Comparison)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-PCT (Application Component) Product Catalog
     ⤷ WAKT (Package) Application development R/3 Promotions

Basic Data

Table Category	INTTAB	Structure
Structure	MDPHASES	Table Relationship Diagram
Short Description	Markdown Planning: Phase Data for Planned/Actual Comparison

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	Field string for markdown planning price phases
2	.INCLUDE	☐				0	0	Markdown planning - price phases per material/un
3	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
4	MFCNR	☐	W_MFCNR	MFCNR	CHAR	10	0	Document no. of markdown plan	WMFH
5	POSNR	☐	W_POSNR	NUMC6	NUMC	6	0	Item number
6	UPOSN	☐	W_UPOSN	NUMC6	NUMC	6	0	Sub-item number for item number
7	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
8	MDPRZ	☐	W_MDPRZ	PROZV8	DEC	15	2	Markdown planning: percentage of initial sales price
9	MDWRT	☐	W_MDWRT	WERT	CURR	13	2	Markdown value
10	MDROS	☐	W_MDROS	PROZV8	DEC	15	2	Sales within a price phase as percentage of overall season
11	DATAB	☐	W_DATAB	DATS	DATS	8	0	Starting date of sales price in a price phase
12	VKKPS	☐	VKKPS	VKKPS_MD	CHAR	1	0	Maintenance status of sales prices
13	PSALM	☐	W_PSALM	MENGE	QUAN	13	3	Planned sales quantity in sales unit
14	PSALW	☐	W_PSALW	WERT	CURR	13	2	Planned sales at retail price
15	PSALC	☐	W_PSALC	WERT	CURR	13	2	Planned sales at purchase price
16	PSALP	☐	W_PSALP	WERT	CURR	13	2	Planned sales at delivered price/net/net purchase price
17	PANFM	☐	W_PANFM2	MENGV13	QUAN	13	3	Planned initial stock
18	CUREP	☐	W_WAEEK	WAERS	CUKY	5	0	Purchase price currency	TCURC
19	EPEIN	☐	EPEIN	DEC5	DEC	5	0	Price unit
20	BBPRM	☐	BBPRM	MEINS	UNIT	3	0	Order Price Unit (purchasing)	T006
21	CURVP	☐	W_CURVP	WAERS	CUKY	5	0	Sales price currency	TCURC
22	EKPGR	☐	EKPGR	WERTV6	CURR	11	2	Purchase Price Calculation: (Basic Purchase Price)
23	EKPNN	☐	EKPNN	WERTV6	CURR	11	2	Sales Pricing: Purchase Price (Net/Net)
24	VKPBR	☐	VKPBR	WERTV6	CURR	11	2	Sales price (gross)
25	ENDPR	☐	ENDPR	WERTV6	CURR	11	2	Final price
26	SPANE	☐	W_MDSPANE	WERTV6	CURR	11	2	Margin (net) in Sales Price Calculation
27	SPABR	☐	W_MDSPABR	WERTV6	CURR	11	2	Margin (gross) in Sales Price Calculation
28	SPWRT	☐	W_SPWRT	WERT	CURR	13	2	Gross margin
29	AUFSG	☐	W_MDAUFSG	WERTV6	CURR	11	2	Markup in Sales Price Calculation
30	VSPAN	☐	W_SPANE	WERTV6	CURR	11	2	Net warehouse margin
31	VSPAB	☐	W_SPABR	WERTV6	CURR	11	2	Gross warehouse margin
32	VAUFS	☐	W_AUFSG	WERTV6	CURR	11	2	Warehouse markup
33	VABGP	☐	W_VABGP	PREIS	CURR	11	2	Transfer price, distribution center
34	SPANS	☐	W_SPANS	SPANS	CHAR	1	0	Status of the retail margin displayed
35	MDPER	☐	W_MDPER	INT2	INT2	5	0	Markdown period in calendar days
36	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
37	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
38	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
39	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
40	PRESW	☐	W_PRESW	WERT	CURR	13	2	Planned Remaining Stock (Value)
41	PRESM	☐	W_PRESM2	MENGV13	QUAN	13	3	Planned Remaining Quantity
42	MAHIT	☐	W_MAHIT	WERT	CURR	13	2	Margin Loss
43	PSALA	☐	W_MDWRT	WERT	CURR	13	2	Markdown value
44	EKWVK	☐	W_EKWVK	WERTV6	CURR	11	2	Purchase price in sales price currency and sales unit
45	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
46	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
47	ARTNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
48	MDQTE	☐	W_MDQTE	PROZV8	DEC	15	2	Depreciation Quota
49	PCMV	☐	W_PCMV	WERT	CURR	13	2	Remaining profit margin
50	UPDKZ	☐	UPDKZ_D	UPDKZ	CHAR	1	0	Update indicator
51	SELKZ	☐	SELKZ	SELKZ	CHAR	1	0	Selection flag
52	PMATN	☐	PMATN	MATNR	CHAR	18	0	Pricing Reference Material	*
53	CUOBF	☐	CUOBM	CUOBJ	NUMC	18	0	Internal object number
54	SATNR	☐	SATNR	MATNR	CHAR	18	0	Cross-Plant Configurable Material	*
55	ATTYP	☐	ATTYP	ATTYP	CHAR	2	0	Material Category
56	SPWRT2	☐	W_SPWRT2	WERT	CURR	13	2	Actual Gross Margin
57	MAHIT2	☐	W_MAHIT2	WERT	CURR	13	2	Actual Margin Losses
58	PSALMW	☐	W_PSALMW	MENGE	QUAN	13	3	Planned Weekly Sales Quantity
59	PSALWW	☐	W_PSALWW	WERT	CURR	13	2	Planned Weekly Invoiced Sales at Final Sales Prices
60	UMSMNG	☐	MCW_UMSMNG	MENGV15_3	QUAN	15	3	Sales quantity in base unit of measure
61	ACTMGW	☐	W_ACTMGW	MENG13V	QUAN	13	3	Average Weekly Actual Sales Quantity
62	ABWMNG	☐	W_ABWM	PROZV8	DEC	15	2	Percentage Variance Between Actual and Planned Sales Qty
63	UMSGVO	☐	MCW_UMSGVO	WERTV10	CURR	19	2	Sales at retail
64	ACTUMW	☐	W_ACTUMW	WERT	CURR	13	2	Average Weekly Actual Sales
65	ABWUMS	☐	W_ABWW	PROZV8	DEC	15	2	Percentage Variance Between Actual and Planned Sales
66	BVLMNG	☐	MCW_BVLMNG	MENGV15_3	QUAN	15	3	Order volume quantity Retail
67	WESMNG	☐	MCW_WESMNG	MENGV15_3	QUAN	15	3	Goods receipt (vendor) quantity in BUn

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MDPHASES	BBPRM	T006	MSEHI		C	N
2	MDPHASES	CUREP	TCURC	WAERS		C	N
3	MDPHASES	CURVP	TCURC	WAERS		C	N
4	MDPHASES	MANDT	T000	MANDT		1	N
5	MDPHASES	MFCNR	WMFH	MFCNR		1	N
6	MDPHASES	VKORG	TVKO	VKORG
7	MDPHASES	VRKME	T006	MSEHI		C	N
8	MDPHASES	VTWEG	TVTW	VTWEG

History

Last changed by/on	SAP	20130529
SAP Release Created in	470