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
⤷ 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 |