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