SAP ABAP Table BAPI1073T12 (Phase 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	BAPI1073T12	Table Relationship Diagram
Short Description	Phase 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	SALES_ORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
3	DISTR_CHANNEL	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
4	VALIDFROM	☐	W_DATAB	DATS	DATS	8	0	Starting date of sales price in a price phase
5	PRICEPERCENTAGE	☐	W_MDPRZ	PROZV8	DEC	15	2	Markdown planning: percentage of initial sales price
6	SALESPERCENTAGE	☐	W_MDROS	PROZV8	DEC	15	2	Sales within a price phase as percentage of overall season
7	MARKDOWN_VALUE	☐	W_MDWRT_BAPI	BAPICURR	DEC	23	4	Markdown Value
8	SALES_CURRENCY	☐	W_CURVP	WAERS	CUKY	5	0	Sales price currency	TCURC
9	SALES_CURRENCY_ISO	☐	W_CURVP_ISO	ISOCD	CHAR	3	0	Currency of sales price in ISO code
10	SALES_UNIT	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
11	SALES_UNIT_ISO	☐	W_VRKME_ISO	ISOCD_UNIT	CHAR	3	0	Sales unit ISO code	*
12	SALES_PRICE	☐	W_ENDPR_BAPI	BAPICURR	DEC	23	4	Final Price
13	PRICE_STATUS	☐	VKKPS	VKKPS_MD	CHAR	1	0	Maintenance status of sales prices
14	PRICE_STATUS_DESCRIPTION	☐	W_TVKST	DDTEXT	CHAR	60	0	Status description for sales price activation
15	INIT_STOCK	☐	W_PANFM2	MENGV13	QUAN	13	3	Planned initial stock
16	PLAN_SALES_QTY	☐	W_PSALM	MENGE	QUAN	13	3	Planned sales quantity in sales unit
17	FINAL_STOCK	☐	W_PRESM2	MENGV13	QUAN	13	3	Planned Remaining Quantity
18	FINAL_STOCK_VALUE	☐	W_PRESW_BAPI	BAPICURR	DEC	23	4	Planned Remaining Stock - Value
19	PURCHASE_CURRENCY	☐	W_WAEEK	WAERS	CUKY	5	0	Purchase price currency	*
20	PURCHASE_CURRENCY_ISO	☐	WAERS_ISO	ISOCD	CHAR	3	0	ISO code currency
21	TURNOVER_PURCH_PRICE	☐	W_PSALC_BAPI	BAPICURR	DEC	23	4	Planned Sales at Purchase Price
22	TURNOVER_SALES_PRICE	☐	W_PSALW_BAPI	BAPICURR	DEC	23	4	Planned Sales at Retail Price
23	MARGIN	☐	W_SPWRT_BAPI	BAPICURR	DEC	23	4	Gross Margin
24	MARGINLOSS	☐	W_MAHIT_BAPI	BAPICURR	DEC	23	4	Margin Loss
25	NET_MARGIN	☐	W_SPANE_BAPI	BAPICURR	DEC	23	4	Margin (net) in Sales Price Calculation
26	GROSS_MARGIN	☐	W_SPABR_BAPI	BAPICURR	DEC	23	4	Margin (gross) in Sales Price Calculation
27	MARKUP	☐	W_AUFSG_BAPI	BAPICURR	DEC	23	4	Markup in Sales Price Calculation
28	MARGIN_STATUS	☐	W_SPANS	SPANS	CHAR	1	0	Status of the retail margin displayed
29	MARGIN_STATUS_DESCRIPTION	☐	W_TSPST	DDTEXT	CHAR	60	0	Description of the Status of the Displayed Gross Margin
30	CREATED_BY	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
31	CREATED_ON	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
32	CHANGED_BY	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
33	CHANGED_ON	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
34	MATERIAL_EXTERNAL	☐	MGV_MATERIAL_EXTERNAL	MATNR_EXT	CHAR	40	0	Long Material Number for MATERIAL Field
35	MATERIAL_GUID	☐	MGV_MATERIAL_GUID	MATNR_EGUID	CHAR	32	0	External GUID for MATERIAL Field
36	MATERIAL_VERSION	☐	MGV_MATERIAL_VERSION	MATNR_VERS	CHAR	10	0	Version Number for MATERIAL Field

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BAPI1073T12	MATERIAL	MARA	MATNR
2	BAPI1073T12	SALES_CURRENCY	TCURC	WAERS
3	BAPI1073T12	SALES_UNIT	T006	MSEHI

History

Last changed by/on	SAP	20110901
SAP Release Created in