SAP ABAP Table MDITEMS (BTE Markdown Planning: Item Data)

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	MDITEMS	Table Relationship Diagram
Short Description	BTE Markdown Planning: Item Data

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	ARTNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
2	MAKTX	☐	BEZEI40	TEXT40	CHAR	40	0	Description
3	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
4	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
5	ATTYP	☐	ATTYP	ATTYP	CHAR	2	0	Material Category
6	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
7	SATNR	☐	SATNR	MATNR	CHAR	18	0	Cross-Plant Configurable Material	MARA
8	PMATN	☐	PMATN	MATNR	CHAR	18	0	Pricing Reference Material	MARA
9	SAISO	☐	SAISO	SAISO	CHAR	4	0	Season Category	T6WSP
10	SAISJ	☐	SAISJ	CJAHR	CHAR	4	0	Season Year
11	DATAB	☐	F_DATFR	DATUM	DATS	8	0	Start date for first price in a markdown plan
12	MPRNR	☐	W_MPRNR	MPRNR	CHAR	10	0	Markdown rule	WMPK
13	CUREP	☐	W_WAEEK	WAERS	CUKY	5	0	Purchase price currency	TCURC
14	EPEIN	☐	EPEIN	DEC5	DEC	5	0	Price unit
15	BBPRM	☐	BBPRM	MEINS	UNIT	3	0	Order Price Unit (purchasing)	T006
16	EKPGR	☐	EKPGR	WERTV6	CURR	11	2	Purchase Price Calculation: (Basic Purchase Price)
17	EKWVK	☐	W_EKWVK	WERTV6	CURR	11	2	Purchase price in sales price currency and sales unit
18	CURVP	☐	W_CURVP	WAERS	CUKY	5	0	Sales price currency	TCURC
19	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
20	ENDPR	☐	ENDPR	WERTV6	CURR	11	2	Final price
21	VKPKZ	☐	F_VKPKZ	FLAG	CHAR	1	0	Indicates whether price point tables should override price
22	PANFM	☐	W_PANFM2	MENGV13	QUAN	13	3	Planned initial stock
23	PSALM	☐	W_PSALM	MENGE	QUAN	13	3	Planned sales quantity in sales unit
24	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
25	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
26	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
27	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
28	UPDKZ	☐	UPDKZ_D	UPDKZ	CHAR	1	0	Update indicator
29	MESSAGE	☐	MD_MESSAGE_TEXT		CHAR	70	0	Message Text

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MDITEMS	ARTNR	MARA	MATNR
2	MDITEMS	BBPRM	T006	MSEHI
3	MDITEMS	CUREP	TCURC	WAERS
4	MDITEMS	CURVP	TCURC	WAERS
5	MDITEMS	MPRNR	WMPK	MPRNR
6	MDITEMS	PMATN	MARA	MATNR
7	MDITEMS	SAISO	T6WSP	SAISO
8	MDITEMS	SATNR	MARA	MATNR
9	MDITEMS	VKORG	TVKO	VKORG
10	MDITEMS	VRKME	T006	MSEHI
11	MDITEMS	VTWEG	TVTW	VTWEG

History

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