SAP ABAP Table BAPI1073T11 (Item Data of a Markdown Plan)

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	BAPI1073T11	Table Relationship Diagram
Short Description	Item Data of a Markdown Plan

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	MATERIAL	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
2	DESCRIPTION	☐	BEZEI40	TEXT40	CHAR	40	0	Description
3	SALES_ORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
4	SALES_ORG_DESCRIPTION	☐	VTXTK	TEXT20	CHAR	20	0	Name
5	DISTR_CHANNEL	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
6	DISTR_CHANNEL_DESCRIPTION	☐	VTXTK	TEXT20	CHAR	20	0	Name
7	CATEGORY	☐	ATTYP	ATTYP	CHAR	2	0	Material Category
8	CATEGORY_DESCRIPTION	☐	W_ATTYPT	CHAR60	CHAR	60	0	Description of material category
9	MAT_GROUP	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
10	CONFIG_MAT	☐	SATNR	MATNR	CHAR	18	0	Cross-Plant Configurable Material	MARA
11	PRICING_REF_MAT	☐	PMATN	MATNR	CHAR	18	0	Pricing Reference Material	MARA
12	SEASON	☐	SAISO	SAISO	CHAR	4	0	Season Category	T6WSP
13	SEASON_DESCRIPTION	☐	BEZEI20	TEXT20	CHAR	20	0	Description
14	YEAR	☐	SAISJ	CJAHR	CHAR	4	0	Season Year
15	VALIDFROM	☐	F_DATFR	DATUM	DATS	8	0	Start date for first price in a markdown plan
16	PRICEMARKDOWNRULE	☐	W_MPRNR	MPRNR	CHAR	10	0	Markdown rule	WMPK
17	PRICEMARKDOWNRULE_DESCRIPTION	☐	BEZEI20	TEXT20	CHAR	20	0	Description
18	PURCHASE_CURRENCY	☐	W_WAEEK	WAERS	CUKY	5	0	Purchase price currency	TCURC
19	PURCHASE_CURRENCY_ISO	☐	WAERS_ISO	ISOCD	CHAR	3	0	ISO code currency
20	PURCHASE_PRICE_UNIT	☐	EPEIN	DEC5	DEC	5	0	Price unit
21	PURCHASE_UNIT	☐	BBPRM	MEINS	UNIT	3	0	Order Price Unit (purchasing)	T006
22	PURCHASE_UNIT_ISO	☐	BBPRM_ISO	ISOCD_UNIT	CHAR	3	0	ISO Code for Purchase Order Price Unit	*
23	PURCHASE_PRICE	☐	W_EKPGR_BAPI	BAPICURR	DEC	23	4	Purchase Price (Basic Price)
24	PURCHASE_PRICE_SALES_CURR_UNIT	☐	W_EKWVK_BAPI	BAPICURR	DEC	23	4	Purchase Price in Sales Price Currency and Sales Unit
25	SALES_CURRENCY	☐	W_CURVP	WAERS	CUKY	5	0	Sales price currency	TCURC
26	SALES_CURRENCY_ISO	☐	W_CURVP_ISO	ISOCD	CHAR	3	0	Currency of sales price in ISO code
27	SALES_UNIT	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
28	SALES_UNIT_ISO	☐	W_VRKME_ISO	ISOCD_UNIT	CHAR	3	0	Sales unit ISO code	*
29	SALES_PRICE	☐	W_ENDPR_BAPI	BAPICURR	DEC	23	4	Final Price
30	PRICE_POINT	☐	F_VKPKZ	FLAG	CHAR	1	0	Indicates whether price point tables should override price
31	INIT_STOCK	☐	W_PANFM	MENGE	QUAN	13	3	Planned initial stock - qty in sales units
32	PLAN_SALES_QTY	☐	W_PSALM	MENGE	QUAN	13	3	Planned sales quantity in sales unit
33	FINAL_STOCK	☐	W_PRESM2	MENGV13	QUAN	13	3	Planned Remaining Quantity
34	FINAL_STOCK_VALUE	☐	W_PRESW_BAPI	BAPICURR	DEC	23	4	Planned Remaining Stock - Value
35	TURNOVER_PURCH_PRICE	☐	W_PSALC_BAPI	BAPICURR	DEC	23	4	Planned Sales at Purchase Price
36	TURNOVER_SALES_PRICE	☐	W_PSALW_BAPI	BAPICURR	DEC	23	4	Planned Sales at Retail Price
37	MARGIN	☐	W_SPWRT_BAPI	BAPICURR	DEC	23	4	Gross Margin
38	MARGINLOSS	☐	W_MAHIT_BAPI	BAPICURR	DEC	23	4	Margin Loss
39	CREATED_BY	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
40	CREATED_ON	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
41	CHANGED_BY	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
42	CHANGED_ON	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
43	CONFIG_MAT_EXTERNAL	☐	MGV_CONFIG_MAT_EXTERNAL	MATNR_EXT	CHAR	40	0	Long material number (future development) for CONFI field
44	CONFIG_MAT_GUID	☐	MGV_CONFIG_MAT_GUID	MATNR_EGUID	CHAR	32	0	External GUID (future development) for CONFIG_MAT field
45	CONFIG_MAT_VERSION	☐	MGV_CONFIG_MAT_VERSION	MATNR_VERS	CHAR	10	0	Version number (future development) for CONFIG_MAT field
46	MATERIAL_EXTERNAL	☐	MGV_MATERIAL_EXTERNAL	MATNR_EXT	CHAR	40	0	Long Material Number for MATERIAL Field
47	MATERIAL_GUID	☐	MGV_MATERIAL_GUID	MATNR_EGUID	CHAR	32	0	External GUID for MATERIAL Field
48	MATERIAL_VERSION	☐	MGV_MATERIAL_VERSION	MATNR_VERS	CHAR	10	0	Version Number for MATERIAL Field
49	PRICING_REF_MAT_EXTERNAL	☐	MGV_PRICING_REF_MAT_EXTERNAL	MATNR_EXT	CHAR	40	0	Long material number (future development) for PRICI field
50	PRICING_REF_MAT_GUID	☐	MGV_PRICING_REF_MAT_GUID	MATNR_EGUID	CHAR	32	0	External GUID (future development) for PRICING_REF_M field
51	PRICING_REF_MAT_VERSION	☐	MGV_PRICING_REF_MAT_VERSION	MATNR_VERS	CHAR	10	0	Version number (future development) for PRICING_REF field

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BAPI1073T11	CONFIG_MAT	MARA	MATNR
2	BAPI1073T11	DISTR_CHANNEL	TVTW	VTWEG
3	BAPI1073T11	MATERIAL	MARA	MATNR
4	BAPI1073T11	PRICEMARKDOWNRULE	WMPK	MPRNR
5	BAPI1073T11	PRICING_REF_MAT	MARA	MATNR
6	BAPI1073T11	PURCHASE_CURRENCY	TCURC	WAERS
7	BAPI1073T11	PURCHASE_UNIT	T006	MSEHI
8	BAPI1073T11	SALES_CURRENCY	TCURC	WAERS
9	BAPI1073T11	SALES_ORG	TVKO	VKORG
10	BAPI1073T11	SALES_UNIT	T006	MSEHI
11	BAPI1073T11	SEASON	T6WSP	SAISO

History

Last changed by/on	SAP	20130529
SAP Release Created in