SAP ABAP Table WKBP (Pricing document: item)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ WVKP (Package) IS-R: Sales pricing
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ WVKP (Package) IS-R: Sales pricing
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | WKBP | Table Relationship Diagram |
Short Description | Pricing document: item |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
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 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | KBELN | KBELN | KBELN | CHAR | 10 | 0 | Number of pricing document | WKBK | |
3 | KBELP | KBELP | KBELP | NUMC | 5 | 0 | Item Number of Pricing Document | ||
4 | .INCLUDE | 0 | 0 | Data part of table WKBP (pricing document: item) | |||||
5 | EKKAB | EKKAB | DATUM | DATS | 8 | 0 | Purchase price conditions valid from | ||
6 | EKKBI | EKKBI | DATUM | DATS | 8 | 0 | Purchase price conditions valid to | ||
7 | VKKAB | VKKAB | DATUM | DATS | 8 | 0 | Sales conditions valid from | ||
8 | VKKBI | VKKBI | DATUM | DATS | 8 | 0 | Sales conditions valid to | ||
9 | EKNUM | EKNUM | KNUMV | CHAR | 10 | 0 | SP: Key for Transaction Conditions in Purchase Pricing | ||
10 | VKNUM | VKNUM | KNUMV | CHAR | 10 | 0 | SP: Key for Transaction Conditions in Purchase Pricing | ||
11 | EKAPP | KAPPL | KAPPL | CHAR | 2 | 0 | Application | * | |
12 | EKALS | EKALS | KALSM | CHAR | 6 | 0 | Sales Pricing: Purchase Price Calculation Schema | T683 | |
13 | VKALS | VKALS | KALSM | CHAR | 6 | 0 | Sales Pricing: Sales Price Calculation Schema | T683 | |
14 | MATKL | MATKL | MATKL | CHAR | 9 | 0 | Material Group | T023 | |
15 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | MARA | |
16 | VRKPE | VRKPE | DEC5 | DEC | 5 | 0 | Sales price unit | ||
17 | VRKME | VRKME | MEINS | UNIT | 3 | 0 | Sales unit | T006 | |
18 | EAN11 | EAN11 | EAN11 | CHAR | 18 | 0 | International Article Number (EAN/UPC) | ||
19 | VKORG | VKORG | VKORG | CHAR | 4 | 0 | Sales Organization | TVKO | |
20 | VTWEG | VTWEG | VTWEG | CHAR | 2 | 0 | Distribution Channel | TVTW | |
21 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | T001W | |
22 | EKORG | EKORG | EKORG | CHAR | 4 | 0 | Purchasing organization | T024E | |
23 | HWAER | HWAER | WAERS | CUKY | 5 | 0 | Local Currency | TCURC | |
24 | LIFNR | LIFNR | LIFNR | CHAR | 10 | 0 | Account Number of Vendor or Creditor | LFA1 | |
25 | LTSNR | LTSNR | LTSNR | CHAR | 6 | 0 | Vendor Subrange | WYT1 | |
26 | WAERS | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
27 | EKPGR | EKPGR | WERTV6 | CURR | 11 | 2 | Purchase Price Calculation: (Basic Purchase Price) | ||
28 | EKPNN | EKPNN | WERTV6 | CURR | 11 | 2 | Sales Pricing: Purchase Price (Net/Net) | ||
29 | AUFSG | AUFSG | WERTV6 | CURR | 11 | 2 | Actual Markup in Sales Price Calculation | ||
30 | PAUFS | PAUFS | WERTV6 | CURR | 11 | 2 | Planned markup | ||
31 | PENDP | PENDP | WERTV6 | CURR | 11 | 2 | SP calculation: Planned sales pr. w/o price point rounding | ||
32 | VKPNE | VKPNE | WERTV6 | CURR | 11 | 2 | Sales price (net) | ||
33 | VKPBR | VKPBR | WERTV6 | CURR | 11 | 2 | Sales price (gross) | ||
34 | KWAER | KAWAER | WAERS | CUKY | 5 | 0 | Sales Pricing: Pricing Currency | TCURC | |
35 | ENDPR | ENDPR | WERTV6 | CURR | 11 | 2 | Final price | ||
36 | SPANE | SPANE | WERTV6 | CURR | 11 | 2 | Margin (net) in sales price calculation | ||
37 | SPABR | SPABR | WERTV6 | CURR | 11 | 2 | Margin (gross) in sales price calculation | ||
38 | ENDPA | ENDPA | WERTV6 | CURR | 11 | 2 | Current Final Price | ||
39 | SPANA | SPANA | WERTV6 | CURR | 11 | 2 | Current margin (net) | ||
40 | SPABA | SPABA | WERTV6 | CURR | 11 | 2 | Current margin (gross) | ||
41 | ROTPR | ROTPR | WERTV6 | CURR | 11 | 2 | Reduced-from price | ||
42 | MITPR | MITPR | WERTV6 | CURR | 11 | 2 | Cash price | ||
43 | EMPPR | EMPPR | WERTV6 | CURR | 11 | 2 | Recommended price | ||
44 | VORPR | W_VORPR | WERTV6 | CURR | 11 | 2 | Sales Pricing: Suggested Price | ||
45 | VKP01 | VKPZW | WERTV6 | CURR | 11 | 2 | Variable sales price | ||
46 | VKP02 | VKPZW | WERTV6 | CURR | 11 | 2 | Variable sales price | ||
47 | VKP03 | VKPZW | WERTV6 | CURR | 11 | 2 | Variable sales price | ||
48 | PROZ1 | W_PROZ | WERTV6 | CURR | 11 | 2 | Sales Price Calculation: (general) percentage-based factor | ||
49 | PROZ2 | W_PROZ | WERTV6 | CURR | 11 | 2 | Sales Price Calculation: (general) percentage-based factor | ||
50 | EVAUF | EVAUF | WERTV6 | CURR | 11 | 2 | Sales Pricing: Markup for Determining the Retail Price | ||
51 | EVPRS | EVPRS | WERTV6 | CURR | 11 | 2 | Sales Pricing: Retail Price | ||
52 | EVSPA | EVSPA | WERTV6 | CURR | 11 | 2 | Sales Pricing: Retail Price Margin | ||
53 | BPSTA | BPSTA | BPSTA | CHAR | 1 | 0 | Pricing: Status of Item in Pricing Document | ||
54 | PLTYP | PLTYP | PLTYP | CHAR | 2 | 0 | Price list type | T189 | |
55 | VKABA | VKKAB | DATUM | DATS | 8 | 0 | Sales conditions valid from | ||
56 | VKBIA | VKKBI | DATUM | DATS | 8 | 0 | Sales conditions valid to | ||
57 | INFWK | INFWK | XFELD | CHAR | 1 | 0 | Info record at plant level | ||
58 | ESOKZ | ESOKZ | ESOKZ | CHAR | 1 | 0 | Purchasing info record category | ||
59 | EVPAU | EVPAU | WERTV6 | CURR | 11 | 2 | Planned markup for determining the retail price | ||
60 | CKNUM | CKNUM | KNUMV | CHAR | 10 | 0 | Sales Price: Key for Transaction Conditions in Master Conds. | ||
61 | VWAER | VWAER | WAERS | CUKY | 5 | 0 | Sales currency | TCURC | |
62 | EVWRS | VWAER | WAERS | CUKY | 5 | 0 | Sales currency | TCURC | |
63 | EGKAL | EGKAL | EGKAL | CHAR | 1 | 0 | Data held when basic purchase price changes | ||
64 | INIPR | ENDPR | WERTV6 | CURR | 11 | 2 | Final price | ||
65 | KNUMH_V | KNUMH_V | KNUMB | CHAR | 10 | 0 | Number of the sales price condition record | ||
66 | EKERV | EKERV_M | EKERV | CHAR | 2 | 0 | Purchase price determination sequence | * | |
67 | BWERA | BWERA | BWERA | CHAR | 1 | 0 | Source determination type | ||
68 | EKERA | EKERA | EKERA | CHAR | 1 | 0 | Purchase price determination type | ||
69 | EFNAM | EFNAM | FUNCNAME | CHAR | 30 | 0 | Name of the Function Module in PP Determination Type C | * | |
70 | VKERV | EKERV_V | EKERV | CHAR | 2 | 0 | Sales price determination sequence | * | |
71 | VKERA | VKERA | VKERA | CHAR | 1 | 0 | Sales price determination type | ||
72 | LIFEL | LIFELD | LIFELD | CHAR | 5 | 0 | Sales Pricing: List Field for Determining Sales Price | * | |
73 | ECKKZ | ECKKZ | XFELD | CHAR | 1 | 0 | SP calc.: price point rounding for suggested final price | ||
74 | PVGRD | PV_GRUND | PV_GRUND | CHAR | 4 | 0 | Reason for retail price change | * | |
75 | FAMNR | WPF_FAMNR | CHAR10 | CHAR | 10 | 0 | Identification Number for Price Family | ||
76 | GRP01 | WPF_GROUP | CHAR10 | CHAR | 10 | 0 | Number of a Family Group in a Price Family | ||
77 | FMTYP | WPF_FMTYP | WPF_FMTYP | CHAR | 2 | 0 | Type of Family Member | ||
78 | SMATN | WPF_SMATN | MATNR | CHAR | 18 | 0 | Master Material of a Price Family | * | |
79 | FCHAL | WPF_FCHAL | WPF_MODKZ | CHAR | 1 | 0 | Price Change Allowed (_=No, 1=Group, 2=Group and Article) | ||
80 | FHIDE | WPF_FHIDE | XFELD | CHAR | 1 | 0 | Pricing Item Hidden for Family Member (X = Yes) | ||
81 | EPRGR | EPRGR | EPRGR | CHAR | 6 | 0 | Price point group | * | |
82 | EPRG2 | EPRG2 | EPRGR | CHAR | 6 | 0 | Price point group for retail price | * | |
83 | NEPGR | NEPGR | XFELD | CHAR | 1 | 0 | Indicator: No Price Point Group | ||
84 | NEPG2 | NEPGR | XFELD | CHAR | 1 | 0 | Indicator: No Price Point Group | ||
85 | .INCLUDE | 0 | 0 | Include for Table WKBP | |||||
86 | INIAM | W_INIAM | DATUM | DATS | 8 | 0 | Sales price calculations: key date for initial price | ||
87 | EPTYP | EPTYP | EPTYP | CHAR | 2 | 0 | Price Point Category | ||
88 | EPTY2 | EPTYP | EPTYP | CHAR | 2 | 0 | Price Point Category | ||
89 | RKTYP | WRF_RPC_RKTYP | WRF_RPC_RKTYP | CHAR | 1 | 0 | Price Point Groups: Ranking Type | ||
90 | RKTY2 | WRF_RPC_RKTYP | WRF_RPC_RKTYP | CHAR | 1 | 0 | Price Point Groups: Ranking Type | ||
91 | BGINT | CLINT | CLINT | NUMC | 10 | 0 | Internal Class Number | * | |
92 | STPLGR | WRF_STPLGR | WRF_STPLGR | CHAR | 1 | 0 | Status of Plant Group | ||
93 | VLGWK | VLGWK | WERKS | CHAR | 4 | 0 | Sales Pricing: Reference Plant | * | |
94 | KALEB | KALEB | KALEB | CHAR | 2 | 0 | Sales Pricing: Pricing level | ||
95 | VKSCH | W_VKSCH_KALP | KSCHL | CHAR | 4 | 0 | Sales Pricing: Condition Type for the Sales Price | * | |
96 | VKOTABN | W_VKOTABN_KALP | KOTABNR | NUMC | 3 | 0 | Sales Pricing: Condition Table for the Sales Price | * | |
97 | KALEA | KALEA | KALEB | CHAR | 2 | 0 | Pricing Level of Current Final Price | ||
98 | VKSCA | W_VKSCA_KALP | KSCHL | CHAR | 4 | 0 | SP Calculation: Condition Type for Current Sales Price | * | |
99 | VKOTABA | W_VKOTABA_KALP | KOTABNR | NUMC | 3 | 0 | Sales Pricing: Condition Table for the Current Sales Price | * |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | WKBP | EKALS | T683 | KALSM | REF | 1 | N |
2 | WKBP | EKORG | T024E | EKORG | KEY | 1 | CN |
3 | WKBP | EVWRS | TCURC | WAERS | |||
4 | WKBP | HWAER | TCURC | WAERS | REF | 1 | N |
5 | WKBP | KBELN | WKBK | KBELN | KEY | 1 | N |
6 | WKBP | KWAER | TCURC | WAERS | REF | 1 | N |
7 | WKBP | LIFNR | LFA1 | LIFNR | KEY | 1 | CN |
8 | WKBP | LTSNR | WYT1 | LTSNR | REF | C | CN |
9 | WKBP | MANDT | T000 | MANDT | KEY | 1 | N |
10 | WKBP | MATKL | T023 | MATKL | REF | 1 | CN |
11 | WKBP | MATNR | MARA | MATNR | REF | 1 | CN |
12 | WKBP | PLTYP | T189 | PLTYP | |||
13 | WKBP | VKALS | T683 | KALSM | REF | 1 | N |
14 | WKBP | VKORG | TVKO | VKORG | KEY | 1 | CN |
15 | WKBP | VRKME | T006 | MSEHI | REF | C | CN |
16 | WKBP | VTWEG | TVTW | VTWEG | KEY | 1 | CN |
17 | WKBP | VWAER | TCURC | WAERS | |||
18 | WKBP | WAERS | TCURC | WAERS | REF | 1 | N |
19 | WKBP | WERKS | T001W | WERKS | KEY | 1 | CN |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in |