SAP ABAP Table KONAV (Structure for Displaying Extended Rebate Arrangements)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ WBON (Package) WWS: Bonus
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ WBON (Package) WWS: Bonus
Basic Data
Table Category | INTTAB | Structure |
Structure | KONAV | Table Relationship Diagram |
Short Description | Structure for Displaying Extended Rebate Arrangements |
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 | Agreements | |||||
2 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
3 | KNUMA | KNUMA | KNUMA | CHAR | 10 | 0 | Agreement (various conditions grouped together) | * | |
4 | VKORG | VKORG | VKORG | CHAR | 4 | 0 | Sales Organization | TVKO | |
5 | VTWEG | VTWEG | VTWEG | CHAR | 2 | 0 | Distribution Channel | TVKOV | |
6 | SPART | SPART | SPART | CHAR | 2 | 0 | Division | TVTA | |
7 | VKBUR | VKBUR | VKBUR | CHAR | 4 | 0 | Sales office | TVKBZ | |
8 | VKGRP | VKGRP | VKGRP | CHAR | 3 | 0 | Sales group | TVBVK | |
9 | BOART | BOART | BOART | CHAR | 4 | 0 | Agreement type | T6B1 | |
10 | ABTYP | BOABTYP | ABTYP | CHAR | 1 | 0 | Category of the rebate agreement | ||
11 | KAPPL | KAPPL | KAPPL | CHAR | 2 | 0 | Application | T681A | |
12 | ERNAM | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
13 | ERDAT | ERDAT | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
14 | ERZET | ERZET | UZEIT | TIMS | 6 | 0 | Entry time | ||
15 | AENAM | AENAM | USNAM | CHAR | 12 | 0 | Name of Person Who Changed Object | ||
16 | AEDAT | AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
17 | AEZET | AEZET | UZEIT | TIMS | 6 | 0 | Time last change was made | ||
18 | BONEM | BONEM | KUNNR | CHAR | 10 | 0 | Rebate recipient | KNA1 | |
19 | WAERS | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
20 | MAXBO | MAXBO | WERTV7 | CURR | 13 | 2 | Maximum rebate (not used) | ||
21 | ABREX | ABREX | CHAR20 | CHAR | 20 | 0 | External description for agreement | ||
22 | EKORG | EKORG | EKORG | CHAR | 4 | 0 | Purchasing organization | T024E | |
23 | BOLIF | BOGEW | LIFNR | CHAR | 10 | 0 | Condition granter | LFA1 | |
24 | ABSPZ | ABSPZ | ABSPZ | CHAR | 1 | 0 | Scope of verification level of rebate agreement | ||
25 | BOSTA | BOSTA | BOSTA | CHAR | 1 | 0 | Status of the agreement | ||
26 | DATAB | ABDATAB | DATUM | DATS | 8 | 0 | Agreement valid-from date | ||
27 | DATBI | ABDATBI | DATUM | DATS | 8 | 0 | Agreement valid-to date | ||
28 | KOBOG | KOBOG | KOBOG | CHAR | 4 | 0 | Condition type/table group for agreements | T6B2 | |
29 | BOTEXT | BOTEXT | TEXT40 | CHAR | 40 | 0 | Description of agreement (e.g. sales deal, promotion) | ||
30 | ZLSCH | DZLSCH | ZLSCH | CHAR | 1 | 0 | Payment method | T042Z | |
31 | VALTG | VALTG | TAGE2 | NUMC | 2 | 0 | Additional value days | ||
32 | VALDT | VALDT | DATUM | DATS | 8 | 0 | Fixed value date | ||
33 | ZTERM | DZTERM | ZTERM | CHAR | 4 | 0 | Terms of payment key | ||
34 | UKNUMA | KNUMA_UEB | KNUMA | CHAR | 10 | 0 | Higher-level agreement | KONA | |
35 | IDENT1 | WFCID1 | WFCID | CHAR | 2 | 0 | Settlement calendar for rebate arrangements | TFACD | |
36 | IDENT2 | WFCID2 | WFCID | CHAR | 2 | 0 | Arrangement calendar for rebate arrangements | TFACD | |
37 | UMNAM | UMNAM | USNAM | CHAR | 12 | 0 | Person responsible for BVol. comparison f. final settlement | ||
38 | UMSDA | UMSDA | DATUM | DATS | 8 | 0 | Date of last business volume comparison for final settlement | ||
39 | UMSAE | UMSAEF | XFELD | CHAR | 1 | 0 | Business volume comparison required for final settlement | ||
40 | EKGRP | EKGRP | EKGRP | CHAR | 3 | 0 | Purchasing group | T024 | |
41 | AKTNR | WAKTION | WAKTION | CHAR | 10 | 0 | Promotion | WAKH | |
42 | ABEIN | ABEIN | ABEIN | CHAR | 1 | 0 | Scope of statem. f. rebate arr. (Purchasing) -no longer used | ||
43 | BUKRS | BUKRS_AB | BUKRS | CHAR | 4 | 0 | Company code for subsequent settlement | T001 | |
44 | VKNUMA | KNUMA_VOR | KNUMA | CHAR | 10 | 0 | Preceding arrangement for automatic renewal | KONA | |
45 | FORZP | FORZP | FORZP | CHAR | 1 | 0 | Subsequent settlement: time of LIS update | ||
46 | FOART | FOART_NA | XFELD | CHAR | 1 | 0 | Subsequent settlement: update type (scale/condition basis) | ||
47 | IDENT3 | WFCID3 | WFCID | CHAR | 2 | 0 | Settlement periods for agreements | TFACD | |
48 | ABPAR | WABPAR | WABPAR | CHAR | 1 | 0 | Indicator for type of settlement partner (vendor/customer) | ||
49 | KFRST | KFRST | KFRST | CHAR | 1 | 0 | Release Status | ||
50 | ANGRP | ANGRP | CHAR2 | CHAR | 2 | 0 | Trigger Group Message Determination | TMAN2 | |
51 | ANBEDNFE | ANBEDNFE | CHAR4 | CHAR | 4 | 0 | Trigger condition, message determination | TMAN3 | |
52 | NAUMF_ENAW | NAUMF_ENAW | CHAR02 | CHAR | 2 | 0 | Default aggregation level "Detailed statement" | TMAB | |
53 | NAUMF_SNAW | NAUMF_SNAW | CHAR02 | CHAR | 2 | 0 | Default aggregation level "Statement of statistical data" | TMAB | |
54 | NAUMF_ANAW | NAUMF_ANAW | CHAR02 | CHAR | 2 | 0 | Default Summarization Level: "Statement of Settlement Docs" | TMAB | |
55 | UMSAEP | UMSAEP | XFELD | CHAR | 1 | 0 | Business volume comparison required for parital settlement | ||
56 | UMNAMP | UMNAMP | USNAM | CHAR | 12 | 0 | Pers. responsible for last BVol. comparison, partial settlm. | ||
57 | UMSDAP | UMSDAP | DATUM | DATS | 8 | 0 | Date of last business vol. comparison for partial settlement | ||
58 | .INCLU--AP | 0 | 0 | Contract Information Rebate | |||||
59 | /BEV1/RBRTT | RANTYP | RANTYP | CHAR | 1 | 0 | Contract Type | ||
60 | /BEV1/RBRTN | RANL | RANL | CHAR | 13 | 0 | Contract Number | ||
61 | /BEV1/RBEWA | SBEWART | SBEWART | CHAR | 4 | 0 | Flow Type | * | |
62 | .INCLU--AP | 0 | 0 | Indicates Enhanced Rebate Settlement | |||||
63 | .INCLUDE | 0 | 0 | Structure for Append Enhanced Rebate | |||||
64 | BON_ENH_VAKEY | BON_ENH_VAKEY | XFELD | CHAR | 1 | 0 | Indicates Enhanced Rebate Settlement | ||
65 | BON_ENH_INDIRECT | BON_ENH_INDIRECT | XFELD | CHAR | 1 | 0 | Indicator for Indirect Settlement Types | ||
66 | BON_ENH_PERIOD_S | BON_ENH_PERIOD_S | XFELD | CHAR | 1 | 0 | Indicates Periodic Settlement | ||
67 | .INCLU--AP | 0 | 0 | Contract Information for Enhanced Rebate | |||||
68 | .INCLUDE | 0 | 0 | Structure for Append Contract Data | |||||
69 | BON_ENH_CTYP | RANTYP | RANTYP | CHAR | 1 | 0 | Contract Type | ||
70 | BON_ENH_CNO | RANL | RANL | CHAR | 13 | 0 | Contract Number | ||
71 | BON_ENH_TTYP | SBEWART | SBEWART | CHAR | 4 | 0 | Flow Type | * |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | KONAV | AKTNR | WAKH | AKTNR | |||
2 | KONAV | ANBEDNFE | TMAN3 | ANBEDNFE | KEY | 1 | CN |
3 | KONAV | ANGRP | TMAN2 | ANGRP | KEY | 1 | CN |
4 | KONAV | BOART | T6B1 | BOART | KEY | 1 | CN |
5 | KONAV | BOLIF | LFA1 | LIFNR | KEY | 1 | CN |
6 | KONAV | BONEM | KNA1 | KUNNR | KEY | 1 | CN |
7 | KONAV | BUKRS | T001 | BUKRS | |||
8 | KONAV | EKGRP | T024 | EKGRP | |||
9 | KONAV | EKORG | T024E | EKORG | KEY | 1 | CN |
10 | KONAV | IDENT1 | TFACD | IDENT | |||
11 | KONAV | IDENT2 | TFACD | IDENT | |||
12 | KONAV | IDENT3 | TFACD | IDENT | |||
13 | KONAV | KAPPL | T681A | KAPPL | REF | 1 | CN |
14 | KONAV | KOBOG | T6B2 | KOBOG | KEY | 1 | CN |
15 | KONAV | MANDT | T000 | MANDT | KEY | 1 | CN |
16 | KONAV | NAUMF_ANAW | TMAB | NAUMF | KEY | ||
17 | KONAV | NAUMF_ENAW | TMAB | NAUMF | KEY | ||
18 | KONAV | NAUMF_SNAW | TMAB | NAUMF | KEY | ||
19 | KONAV | SPART | TVTA | SPART | KEY | 1 | CN |
20 | KONAV | UKNUMA | KONA | KNUMA | REF | C | CN |
21 | KONAV | VKBUR | TVKBZ | VKBUR | KEY | 1 | CN |
22 | KONAV | VKGRP | TVBVK | VKGRP | KEY | 1 | CN |
23 | KONAV | VKNUMA | KONA | KNUMA | C | N | |
24 | KONAV | VKORG | TVKO | VKORG | KEY | 1 | CN |
25 | KONAV | VTWEG | TVKOV | VTWEG | KEY | 1 | CN |
26 | KONAV | WAERS | TCURC | WAERS | KEY | 1 | CN |
27 | KONAV | ZLSCH | T042Z | ZLSCH |
History
Last changed by/on | SAP | 20100310 |
SAP Release Created in |