SAP ABAP Table CALP_VB (Structure for Updating Sales Price Conditions)
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
⤷
⤷
⤷
Basic Data
| Table Category | INTTAB | Structure |
| Structure | CALP_VB |
|
| Short Description | Structure for Updating Sales Price Conditions |
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 | |
0 | 0 | Sales price calculation: key fields in a price calculation | |||||
| 2 | |
MATNR | MATNR | CHAR | 18 | 0 | Material Number | MARA | |
| 3 | |
W_VRKME_VKP | MEINS | UNIT | 3 | 0 | Sales Unit | T006 | |
| 4 | |
EAN11 | EAN11 | CHAR | 18 | 0 | International Article Number (EAN/UPC) | ||
| 5 | |
VKORG | VKORG | CHAR | 4 | 0 | Sales Organization | TVKO | |
| 6 | |
VTWEG | VTWEG | CHAR | 2 | 0 | Distribution Channel | TVTW | |
| 7 | |
WERKS_D | WERKS | CHAR | 4 | 0 | Plant | T001W | |
| 8 | |
PLTYP | PLTYP | CHAR | 2 | 0 | Price list type | T189 | |
| 9 | |
CLINT | CLINT | NUMC | 10 | 0 | Internal Class Number | KLAH | |
| 10 | |
VKKAB | DATUM | DATS | 8 | 0 | Sales conditions valid from | ||
| 11 | |
VKKBI | DATUM | DATS | 8 | 0 | Sales conditions valid to | ||
| 12 | |
MATKL | MATKL | CHAR | 9 | 0 | Material Group | * | |
| 13 | |
WGRU_HIE1 | KLASSE | CHAR | 18 | 0 | Material group hierarchy 1 | ||
| 14 | |
WGRU_HIE2 | KLASSE | CHAR | 18 | 0 | Material group hierarchy 2 | ||
| 15 | |
MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | * | |
| 16 | |
ATTYP | ATTYP | CHAR | 2 | 0 | Material Category | ||
| 17 | |
SATNR | MATNR | CHAR | 18 | 0 | Cross-Plant Configurable Material | * | |
| 18 | |
PMATN | MATNR | CHAR | 18 | 0 | Pricing Reference Material | * | |
| 19 | |
EKORG | EKORG | CHAR | 4 | 0 | Purchasing organization | * | |
| 20 | |
LIFNR | LIFNR | CHAR | 10 | 0 | Account Number of Vendor or Creditor | * | |
| 21 | |
LTSNR | LTSNR | CHAR | 6 | 0 | Vendor Subrange | * | |
| 22 | |
BSTME | MEINS | UNIT | 3 | 0 | Order unit | * | |
| 23 | |
ESOKZ | ESOKZ | CHAR | 1 | 0 | Purchasing info record category | ||
| 24 | |
KUNNR | KUNNR | CHAR | 10 | 0 | Customer Number | * | |
| 25 | |
SPART | SPART | CHAR | 2 | 0 | Division | * | |
| 26 | |
WAKTION | WAKTION | CHAR | 10 | 0 | Promotion | * | |
| 27 | |
VWAER | WAERS | CUKY | 5 | 0 | Sales currency | * | |
| 28 | |
KALEB | KALEB | CHAR | 2 | 0 | Sales Pricing: Pricing level | ||
| 29 | |
KBETR | WERTV6 | CURR | 11 | 2 | Rate (condition amount or percentage) | ||
| 30 | |
WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
| 31 | |
KPEIN | KPEIN | DEC | 5 | 0 | Condition pricing unit | ||
| 32 | |
KMEIN | MEINS | UNIT | 3 | 0 | Condition Unit | * | |
| 33 | |
LOEVM_KO | XFELD | CHAR | 1 | 0 | Deletion indicator for condition item | ||
| 34 | |
KAPPL | KAPPL | CHAR | 2 | 0 | Application | * | |
| 35 | |
KSCHL | KSCHL | CHAR | 4 | 0 | Condition Type | * | |
| 36 | |
KOTABNR | KOTABNR | NUMC | 3 | 0 | Condition table | * | |
| 37 | |
KNUMH | KNUMB | CHAR | 10 | 0 | Condition record number | ||
| 38 | |
BPSTA | BPSTA | CHAR | 1 | 0 | Pricing: Status of Item in Pricing Document | ||
| 39 | |
W_SUBRC | EK08R_RC | NUMC | 2 | 0 | Subroutines for return code | ||
| 40 | |
CMPGN_ID_R3 | CMPGN_ID_R3 | CHAR | 10 | 0 | Campaign ID | ||
| 41 | |
0 | 0 | Promotion Discounts at Material Level | |||||
| 42 | |
0 | 0 | Material Hierarchy Data | |||||
| 43 | |
WAKT_HIER_CNT | WAKT_HIERCNT | CHAR | 2 | 0 | Hierarchy | ||
| 44 | |
WAKT_STRUC_NODE | WAKT_NODES | CHAR | 18 | 0 | Hierarchy Node | ||
| 45 | |
SAISO | SAISO | CHAR | 4 | 0 | Season Category | T6WSP | |
| 46 | |
SAISJ | CJAHR | CHAR | 4 | 0 | Season Year |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
| 1 | CALP_VB | BGINT | |
|
|||
| 2 | CALP_VB | MATNR | |
|
|||
| 3 | CALP_VB | PLTYP | |
|
|||
| 4 | CALP_VB | SAISO | |
|
|||
| 5 | CALP_VB | VKORG | |
|
|||
| 6 | CALP_VB | VRKME | |
|
|||
| 7 | CALP_VB | VTWEG | |
|
|||
| 8 | CALP_VB | WERKS | |
|
History
| Last changed by/on | SAP | 20130529 |
| SAP Release Created in | 470 |