SAP ABAP Table WVKP_XWKBP_STY (Structure for xwkbp)
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 | WVKP_XWKBP_STY | Table Relationship Diagram |
Short Description | Structure for xwkbp |
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 | Generated Table for View | |||||
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 | 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 | EVPAU | EVPAU | WERTV6 | CURR | 11 | 2 | Planned markup for determining the retail price | ||
59 | CKNUM | CKNUM | KNUMV | CHAR | 10 | 0 | Sales Price: Key for Transaction Conditions in Master Conds. | ||
60 | VWAER | VWAER | WAERS | CUKY | 5 | 0 | Sales currency | TCURC | |
61 | EVWRS | VWAER | WAERS | CUKY | 5 | 0 | Sales currency | TCURC | |
62 | EGKAL | EGKAL | EGKAL | CHAR | 1 | 0 | Data held when basic purchase price changes | ||
63 | INIPR | ENDPR | WERTV6 | CURR | 11 | 2 | Final price | ||
64 | KNUMH_V | KNUMH_V | KNUMB | CHAR | 10 | 0 | Number of the sales price condition record | ||
65 | EKERV | EKERV_M | EKERV | CHAR | 2 | 0 | Purchase price determination sequence | * | |
66 | BWERA | BWERA | BWERA | CHAR | 1 | 0 | Source determination type | ||
67 | EKERA | EKERA | EKERA | CHAR | 1 | 0 | Purchase price determination type | ||
68 | EFNAM | EFNAM | FUNCNAME | CHAR | 30 | 0 | Name of the Function Module in PP Determination Type C | * | |
69 | VKERV | EKERV_V | EKERV | CHAR | 2 | 0 | Sales price determination sequence | * | |
70 | VKERA | VKERA | VKERA | CHAR | 1 | 0 | Sales price determination type | ||
71 | LIFEL | LIFELD | LIFELD | CHAR | 5 | 0 | Sales Pricing: List Field for Determining Sales Price | * | |
72 | ECKKZ | ECKKZ | XFELD | CHAR | 1 | 0 | SP calc.: price point rounding for suggested final price | ||
73 | FAMNR | WPF_FAMNR | CHAR10 | CHAR | 10 | 0 | Identification Number for Price Family | ||
74 | GRP01 | WPF_GROUP | CHAR10 | CHAR | 10 | 0 | Number of a Family Group in a Price Family | ||
75 | FMTYP | WPF_FMTYP | WPF_FMTYP | CHAR | 2 | 0 | Type of Family Member | ||
76 | SMATN | WPF_SMATN | MATNR | CHAR | 18 | 0 | Master Material of a Price Family | * | |
77 | FCHAL | WPF_FCHAL | WPF_MODKZ | CHAR | 1 | 0 | Price Change Allowed (_=No, 1=Group, 2=Group and Article) | ||
78 | FHIDE | WPF_FHIDE | XFELD | CHAR | 1 | 0 | Pricing Item Hidden for Family Member (X = Yes) | ||
79 | EPRGR | EPRGR | EPRGR | CHAR | 6 | 0 | Price point group | * | |
80 | EPRG2 | EPRG2 | EPRGR | CHAR | 6 | 0 | Price point group for retail price | * | |
81 | NEPGR | NEPGR | XFELD | CHAR | 1 | 0 | Indicator: No Price Point Group | ||
82 | NEPG2 | NEPGR | XFELD | CHAR | 1 | 0 | Indicator: No Price Point Group | ||
83 | ERNAM | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
84 | ERDAT | ERDAT | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
85 | KBART | KBART | KBART | CHAR | 4 | 0 | Pricing document type | ||
86 | AENAM | AENAM | USNAM | CHAR | 12 | 0 | Name of Person Who Changed Object | ||
87 | AEDAT | AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
88 | BGINT | CLINT | CLINT | NUMC | 10 | 0 | Internal Class Number | * | |
89 | STPLGR | WRF_STPLGR | WRF_STPLGR | CHAR | 1 | 0 | Status of Plant Group | ||
90 | UPDKZ | CDCHNGIND | CDCHNGIND | CHAR | 1 | 0 | Change type (U, I, E, D) | ||
91 | SELKZ | SYMARKY | SYCHAR01 | CHAR | 1 | 0 | Line Letter | ||
92 | BPSTA_ALT | SYMARKY | SYCHAR01 | CHAR | 1 | 0 | Line Letter | ||
93 | FILGR | W_FILGR | KLASSE | CHAR | 18 | 0 | Plant grouping, sales promotion |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | WVKP_XWKBP_STY | EKALS | T683 | KALSM | REF | 1 | N |
2 | WVKP_XWKBP_STY | EKORG | T024E | EKORG | KEY | 1 | CN |
3 | WVKP_XWKBP_STY | EVWRS | TCURC | WAERS | |||
4 | WVKP_XWKBP_STY | HWAER | TCURC | WAERS | REF | 1 | N |
5 | WVKP_XWKBP_STY | KBELN | WKBK | KBELN | KEY | 1 | N |
6 | WVKP_XWKBP_STY | KWAER | TCURC | WAERS | REF | 1 | N |
7 | WVKP_XWKBP_STY | LIFNR | LFA1 | LIFNR | KEY | 1 | CN |
8 | WVKP_XWKBP_STY | LTSNR | WYT1 | LTSNR | REF | C | CN |
9 | WVKP_XWKBP_STY | MANDT | T000 | MANDT | KEY | 1 | N |
10 | WVKP_XWKBP_STY | MATKL | T023 | MATKL | REF | 1 | CN |
11 | WVKP_XWKBP_STY | MATNR | MARA | MATNR | REF | 1 | CN |
12 | WVKP_XWKBP_STY | PLTYP | T189 | PLTYP | |||
13 | WVKP_XWKBP_STY | VKALS | T683 | KALSM | REF | 1 | N |
14 | WVKP_XWKBP_STY | VKORG | TVKO | VKORG | KEY | 1 | CN |
15 | WVKP_XWKBP_STY | VRKME | T006 | MSEHI | REF | C | CN |
16 | WVKP_XWKBP_STY | VTWEG | TVTW | VTWEG | KEY | 1 | CN |
17 | WVKP_XWKBP_STY | VWAER | TCURC | WAERS | |||
18 | WVKP_XWKBP_STY | WAERS | TCURC | WAERS | REF | 1 | N |
19 | WVKP_XWKBP_STY | WERKS | T001W | WERKS | KEY | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 605 |