SAP ABAP Table WRF_PPW_PPDCALCITEM_STY (PPW: Structure for Pricing Items)
Hierarchy
☛
EA-RETAIL (Software Component) SAP Enterprise Extension Retail
⤷ LO-MD-PPW (Application Component) Price Planning Workbench
⤷ WRF_PPW_DDIC (Package) Price Planning Workbench - DDIC
⤷ LO-MD-PPW (Application Component) Price Planning Workbench
⤷ WRF_PPW_DDIC (Package) Price Planning Workbench - DDIC
Basic Data
Table Category | INTTAB | Structure |
Structure | WRF_PPW_PPDCALCITEM_STY | Table Relationship Diagram |
Short Description | PPW: Structure for Pricing Items |
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 | GUID_CALC | WRF_PPW_GUID | RAW | 16 | 0 | Unique, Generated Key | |||
2 | .INCLUDE | 0 | 0 | Sales price calculation: key fields in a price calculation | |||||
3 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | * | |
4 | VRKME | W_VRKME_VKP | MEINS | UNIT | 3 | 0 | Sales Unit | * | |
5 | EAN11 | EAN11 | EAN11 | CHAR | 18 | 0 | International Article Number (EAN/UPC) | ||
6 | VKORG | VKORG | VKORG | CHAR | 4 | 0 | Sales Organization | * | |
7 | VTWEG | VTWEG | VTWEG | CHAR | 2 | 0 | Distribution Channel | * | |
8 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | * | |
9 | PLTYP | PLTYP | PLTYP | CHAR | 2 | 0 | Price list type | * | |
10 | BGINT | CLINT | CLINT | NUMC | 10 | 0 | Internal Class Number | * | |
11 | .INCLUDE | 0 | 0 | PPW: Structure to Display Pricing Item Data | |||||
12 | VKKAB | VKKAB | DATUM | DATS | 8 | 0 | Sales conditions valid from | ||
13 | VKKBI | VKKBI | DATUM | DATS | 8 | 0 | Sales conditions valid to | ||
14 | VKKAM | VKKAM | DATUM | DATS | 8 | 0 | Key date for sales price conditions | ||
15 | VRKPE | VRKPE | DEC5 | DEC | 5 | 0 | Sales price unit | ||
16 | VLGWK | VLGWK | WERKS | CHAR | 4 | 0 | Sales Pricing: Reference Plant | * | |
17 | EKORG | EKORG | EKORG | CHAR | 4 | 0 | Purchasing organization | * | |
18 | HWAER | HWAER | WAERS | CUKY | 5 | 0 | Local Currency | * | |
19 | LIFNR | LIFNR | LIFNR | CHAR | 10 | 0 | Account Number of Vendor or Creditor | * | |
20 | INFNR | INFNR | INFNR | CHAR | 10 | 0 | Number of purchasing info record | * | |
21 | KURST | KURST | KURST | CHAR | 4 | 0 | Exchange Rate Type | * | |
22 | WAERS | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
23 | EKPGR | EKPGR | WERTV6 | CURR | 11 | 2 | Purchase Price Calculation: (Basic Purchase Price) | ||
24 | KWAER | KAWAER | WAERS | CUKY | 5 | 0 | Sales Pricing: Pricing Currency | * | |
25 | EKPNN | EKPNN | WERTV6 | CURR | 11 | 2 | Sales Pricing: Purchase Price (Net/Net) | ||
26 | AUFSG | AUFSG | WERTV6 | CURR | 11 | 2 | Actual Markup in Sales Price Calculation | ||
27 | PAUFS | PAUFS | WERTV6 | CURR | 11 | 2 | Planned markup | ||
28 | PENDP | PENDP | WERTV6 | CURR | 11 | 2 | SP calculation: Planned sales pr. w/o price point rounding | ||
29 | VKPNE | VKPNE | WERTV6 | CURR | 11 | 2 | Sales price (net) | ||
30 | VKPBR | VKPBR | WERTV6 | CURR | 11 | 2 | Sales price (gross) | ||
31 | VWAER | VWAER | WAERS | CUKY | 5 | 0 | Sales currency | * | |
32 | ENDPR | ENDPR | WERTV6 | CURR | 11 | 2 | Final price | ||
33 | KALEB | KALEB | KALEB | CHAR | 2 | 0 | Sales Pricing: Pricing level | ||
34 | SPANE | SPANE | WERTV6 | CURR | 11 | 2 | Margin (net) in sales price calculation | ||
35 | SPABR | SPABR | WERTV6 | CURR | 11 | 2 | Margin (gross) in sales price calculation | ||
36 | ENDPA | ENDPA | WERTV6 | CURR | 11 | 2 | Current Final Price | ||
37 | KALEA | WRF_RPC_KALEA | KALEB | CHAR | 2 | 0 | Pricing Level of Current Final Price | ||
38 | SPANA | SPANA | WERTV6 | CURR | 11 | 2 | Current margin (net) | ||
39 | SPABA | SPABA | WERTV6 | CURR | 11 | 2 | Current margin (gross) | ||
40 | ROTPR | ROTPR | WERTV6 | CURR | 11 | 2 | Reduced-from price | ||
41 | MITPR | MITPR | WERTV6 | CURR | 11 | 2 | Cash price | ||
42 | EMPPR | EMPPR | WERTV6 | CURR | 11 | 2 | Recommended price | ||
43 | VORPR | W_VORPR | WERTV6 | CURR | 11 | 2 | Sales Pricing: Suggested Price | ||
44 | VKP01 | WRF_RPC_VKP01 | WERTV6 | CURR | 11 | 2 | Variable Sales Price 1 | ||
45 | VKP02 | WRF_RPC_VKP02 | WERTV6 | CURR | 11 | 2 | Variable Sales Price 2 | ||
46 | VKP03 | WRF_RPC_VKP03 | WERTV6 | CURR | 11 | 2 | Variable Sales Price 3 | ||
47 | PROZ1 | WRF_RPC_PROZ1 | WERTV6 | CURR | 11 | 2 | SP Calculation: Variable Percentage 1 | ||
48 | PROZ2 | WRF_RPC_PROZ2 | WERTV6 | CURR | 11 | 2 | SP Calculation: Variable Percentage 2 | ||
49 | MPROZ | MPROZ | WERTV6 | CURR | 11 | 2 | Pricing: Price Change in Percent | ||
50 | LOEVM | LOEVM | XFELD | CHAR | 1 | 0 | Deletion Indicator | ||
51 | EKERV | EKERV_M | EKERV | CHAR | 2 | 0 | Purchase price determination sequence | * | |
52 | EKERA | EKERA | EKERA | CHAR | 1 | 0 | Purchase price determination type | ||
53 | VKERV | EKERV_V | EKERV | CHAR | 2 | 0 | Sales price determination sequence | * | |
54 | VKERA | VKERA | VKERA | CHAR | 1 | 0 | Sales price determination type | ||
55 | EPTYP | EPTYP | EPTYP | CHAR | 2 | 0 | Price Point Category | ||
56 | RKTYP | WRF_RPC_RKTYP | WRF_RPC_RKTYP | CHAR | 1 | 0 | Price Point Groups: Ranking Type | ||
57 | EPRGR | EPRGR | EPRGR | CHAR | 6 | 0 | Price point group | TWPK | |
58 | PVGRD | PV_GRUND | PV_GRUND | CHAR | 4 | 0 | Reason for retail price change | TWBN | |
59 | ENDNE | WRF_PPW_ENDNE | WERTV6 | CURR | 11 | 2 | Final Price (Net) | ||
60 | ENDBR | WRF_PPW_ENDBR | WERTV6 | CURR | 11 | 2 | Final Price (Gross) | ||
61 | ENDPA_PROMO | WRF_PPW_ENDPA_PROMO | WERTV6 | CURR | 11 | 2 | Current Promotion Sales Price | ||
62 | ENDNA | WRF_PPW_ENDNA | WERTV6 | CURR | 11 | 2 | Current Final Price (Net) | ||
63 | ENDBA | WRF_PPW_ENDBA | WERTV6 | CURR | 11 | 2 | Current Final Price (Gross) | ||
64 | MABSO | WRF_PPW_MABSO | WERTV6 | CURR | 11 | 2 | Absolute Price Change in Relation to Current Final Price | ||
65 | NABSO | WRF_PPW_NABSO | WERTV6 | CURR | 11 | 2 | Absolute Net Price Change in Relation to Current Final Price | ||
66 | INIAM | W_INIAM | DATUM | DATS | 8 | 0 | Sales price calculations: key date for initial price | ||
67 | INIPR | WRF_PPW_INIPR | WERTV6 | CURR | 11 | 2 | Original Price | ||
68 | IPROZ | WRF_PPW_IPROZ | WERTV6 | CURR | 11 | 2 | Percentage Price Change in Relation to Original Price | ||
69 | IABSO | WRF_PPW_IABSO | WERTV6 | CURR | 11 | 2 | Absolute Price Change in Relation to Original Price | ||
70 | EPROZ | WRF_PPW_EPROZ | WERTV6 | CURR | 11 | 2 | Percentage Price Change (Compared to Last Final Price) | ||
71 | EABSO | WRF_PPW_EABSO | WERTV6 | CURR | 11 | 2 | Absolute Price Change (Compared to Last Final Price) | ||
72 | PPROZ | WRF_PPW_PPROZ | WERTV6 | CURR | 11 | 2 | Percentage Price Change (Compared to Planned Final Price) | ||
73 | PABSO | WRF_PPW_PABSO | WERTV6 | CURR | 11 | 2 | Absolute Price Change (Comp. to Last Final Price) | ||
74 | NWLEV | WRF_PPW_NWLEV | XFELD | CHAR | 1 | 0 | Flag: New Pricing Level | ||
75 | ENDPA_PROMO_CHECKED | XFELD | XFELD | CHAR | 1 | 0 | Checkbox | ||
76 | DEC_POS | WAERST | WAERS | CUKY | 5 | 0 | Technical currency (3 decimal places) | * | |
77 | RECAL | WRF_PPW_RECAL | FLAG | CHAR | 1 | 0 | Indicator: Redetermine Prices | ||
78 | ROUND | WRF_PPW_ROUND | FLAG | CHAR | 1 | 0 | Rounding Category | ||
79 | DECPL | NUM02 | NUM02 | NUMC | 2 | 0 | ABAB Dictionary: Two-Digit Numeric Field | ||
80 | BONKZ | W_BONKZ_KALP | XFELD | CHAR | 1 | 0 | Sales Pricing: Indicator - Is Final Price Net or Gross Price | ||
81 | NEPGR | NEPGR | XFELD | CHAR | 1 | 0 | Indicator: No Price Point Group | ||
82 | PMATN | PMATN | MATNR | CHAR | 18 | 0 | Pricing Reference Material | * | |
83 | SATNR | WSTR_SATNR | MATNR | CHAR | 18 | 0 | Material Number of the Generic Material | * | |
84 | KBELN | KBELN | KBELN | CHAR | 10 | 0 | Number of pricing document | * | |
85 | KBELP | KBELP | KBELP | NUMC | 5 | 0 | Item Number of Pricing Document | * | |
86 | KBELN_COPY | KBELN | KBELN | CHAR | 10 | 0 | Number of pricing document | * | |
87 | KBELP_COPY | KBELP | KBELP | NUMC | 5 | 0 | Item Number of Pricing Document | * | |
88 | KNUMH_V | KNUMH_V | KNUMB | CHAR | 10 | 0 | Number of the sales price condition record | ||
89 | BPSTA | BPSTA | BPSTA | CHAR | 1 | 0 | Pricing: Status of Item in Pricing Document | ||
90 | SUBRC | SUBRC | EK08R_RC | NUMC | 2 | 0 | Subroutines for return code | ||
91 | HERKU | W_HERKU | W_ARCH | CHAR | 1 | 0 | Origin of Pricing Document |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | WRF_PPW_PPDCALCITEM_STY | EPRGR | TWPK | EPRGR | |||
2 | WRF_PPW_PPDCALCITEM_STY | PVGRD | TWBN | PV_GRUND |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 111 |