SAP ABAP Table KONVN (Sales Order: Standard Conditions)
Hierarchy
☛
IS-M (Software Component) SAP MEDIA
⤷ IS-M (Application Component) SAP Media
⤷ JSD (Package) Appl. dev. R/3 Publishing Sales and Distribution System
⤷ IS-M (Application Component) SAP Media
⤷ JSD (Package) Appl. dev. R/3 Publishing Sales and Distribution System
Basic Data
Table Category | INTTAB | Structure |
Structure | KONVN | Table Relationship Diagram |
Short Description | Sales Order: Standard 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 | .INCLUDE | 0 | 0 | Conditions (Transaction Data) | |||||
2 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
3 | KNUMV | KNUMV | KNUMV | CHAR | 10 | 0 | Number of the document condition | ||
4 | KPOSN | KPOSN | NUM6 | NUMC | 6 | 0 | Condition Item Number | ||
5 | STUNR | STUNR | STUNR | NUMC | 3 | 0 | Level Number | * | |
6 | ZAEHK | DZAEHK | ZAEHK | NUMC | 2 | 0 | Condition counter | ||
7 | KAPPL | KAPPL | KAPPL | CHAR | 2 | 0 | Application | T681A | |
8 | KSCHL | KSCHA | KSCHL | CHAR | 4 | 0 | Condition Type | T685A | |
9 | KDATU | KDATU | DATUM | DATS | 8 | 0 | Condition pricing date | ||
10 | KRECH | KRECH | KRECH | CHAR | 1 | 0 | Calculation type for condition | ||
11 | KAWRT | KAWRT | WERTV8 | CURR | 15 | 2 | Condition Basis | ||
12 | KBETR | KBETR | WERTV6 | CURR | 11 | 2 | Rate (condition amount or percentage) | ||
13 | WAERS | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
14 | KKURS | KKURS | KKURS | DEC | 9 | 5 | Condition exchange rate for conversion to local currency | ||
15 | KPEIN | KPEIN | KPEIN | DEC | 5 | 0 | Condition pricing unit | ||
16 | KMEIN | KVMEI | MEINS | UNIT | 3 | 0 | Condition unit in the document | T006 | |
17 | KUMZA | KUMZA | UMBSZ | DEC | 5 | 0 | Numerator for converting condition units to base units | ||
18 | KUMNE | KUMNE | UMBSN | DEC | 5 | 0 | Denominator for converting condition units to base units | ||
19 | KNTYP | KNTYP | KNTYP | CHAR | 1 | 0 | Condition Cat.: Frt, Tax, Basic Price=Revenue, Price, Cost | ||
20 | KSTAT | KSTAT | XFELD | CHAR | 1 | 0 | Condition is used for statistics | ||
21 | KNPRS | STFKZ | STFKZ | CHAR | 1 | 0 | Scale type | ||
22 | KRUEK | KRUEK | XFELD | CHAR | 1 | 0 | Condition is Relevant for Accrual (e.g. Freight) | ||
23 | KRELI | KRELI | KRELI | CHAR | 1 | 0 | Condition for invoice list | ||
24 | KHERK | KHERK | KHERK | CHAR | 1 | 0 | Condition Origin | ||
25 | KGRPE | KGRPE | KGRPE | CHAR | 1 | 0 | Group condition | ||
26 | KOUPD | KOUPD | XFELD | CHAR | 1 | 0 | Condition update | ||
27 | KOLNR | KOLNR | KOLNR | NUMC | 2 | 0 | Access Sequence - Access Number | * | |
28 | KNUMH | KNUMH | KNUMB | CHAR | 10 | 0 | Condition record number | ||
29 | KOPOS | KOPOS | NUM02 | NUMC | 2 | 0 | Sequential number of the condition | ||
30 | KVSL1 | KVSL1 | KVSCHL | CHAR | 3 | 0 | Account key | T687 | |
31 | SAKN1 | SAKNR | SAKNR | CHAR | 10 | 0 | G/L Account Number | SKA1 | |
32 | MWSK1 | MWSKZ | MWSKZ | CHAR | 2 | 0 | Tax on sales/purchases code | * | |
33 | KVSL2 | KVSL2 | KVSCHL | CHAR | 3 | 0 | Account key - accruals / provisions | T687 | |
34 | SAKN2 | SAKNR_ACCR | SAKNR | CHAR | 10 | 0 | Number of Provision Account | SKA1 | |
35 | MWSK2 | WT_WITHCD | WT_WITHCD | CHAR | 2 | 0 | Withholding tax code | * | |
36 | LIFNR | LIFNR | LIFNR | CHAR | 10 | 0 | Account Number of Vendor or Creditor | LFA1 | |
37 | KUNNR | KUNNR_KO | KUNNR | CHAR | 10 | 0 | Customer number (rebate recipient) | KNA1 | |
38 | KDIFF | KDIFF | WERTV3 | CURR | 5 | 2 | Rounding-off difference of the condition | ||
39 | KWERT | KWERT | WERTV7 | CURR | 13 | 2 | Condition Value | ||
40 | KSTEU | KSTEU | KSTEU | CHAR | 1 | 0 | Condition control | ||
41 | KINAK | KINAK | KINAK | CHAR | 1 | 0 | Condition is inactive | ||
42 | KOAID | KOAID | KOAID | CHAR | 1 | 0 | Condition class | ||
43 | ZAEKO | DZAEKO | ZAEHK | NUMC | 2 | 0 | Condition counter for (header conditions) | ||
44 | KMXAW | KMXAW | KMXWR | CHAR | 1 | 0 | Indicator for maximum condition base value | ||
45 | KMXWR | KMXWR | KMXWR | CHAR | 1 | 0 | Indicator for maximum condition amount | ||
46 | KFAKTOR | KFAKTOR | FLTP | FLTP | 16 | 16 | Factor for condition base value | ||
47 | KDUPL | KDUPL | KDUPL | CHAR | 1 | 0 | Structure condition | ||
48 | KFAKTOR1 | KFAKTOR1 | FLTP | FLTP | 16 | 16 | Factor for condition basis (period) | ||
49 | KZBZG | KZBZG | KZBZG | CHAR | 1 | 0 | Indicator: Scale Base Type | ||
50 | KSTBS | KSTBS | WERTV8 | CURR | 15 | 2 | Scale base value of the condition | ||
51 | KONMS | KONMS | MEINS | UNIT | 3 | 0 | Condition scale unit of measure | T006 | |
52 | KONWS | KONWS | WAERS | CUKY | 5 | 0 | Currency Key: Condition Scale | TCURC | |
53 | KAWRT_K | KAWRT | WERTV8 | CURR | 15 | 2 | Condition Basis | ||
54 | KWAEH | KWAEH | WAERS | CUKY | 5 | 0 | Condition currency (for cumulation fields) | * | |
55 | KWERT_K | KWERT | WERTV7 | CURR | 13 | 2 | Condition Value | ||
56 | KFKIV | KFKIV | XFELD | CHAR | 1 | 0 | Condition for Inter-Company Billing | ||
57 | KVARC | KVARC | XFELD | CHAR | 1 | 0 | Condition for Configuration | ||
58 | KMPRS | KMPRS | XFELD | CHAR | 1 | 0 | Condition changed manually | ||
59 | PRSQU | PRSQU1 | PRSQU | CHAR | 1 | 0 | Price source | ||
60 | VARCOND | VARCOND | VARCON | CHAR | 26 | 0 | Variant condition | * | |
61 | STUFE | HISTU | DEC2 | DEC | 2 | 0 | Level (in Multi-Level BOM Explosions) | ||
62 | WEGXX | WEGXX | DEC4 | DEC | 4 | 0 | Path (for Multi-Level BOM Explosions) | ||
63 | KTREL | KTREL | KTREL | CHAR | 1 | 0 | Relevance for account assignment | ||
64 | MDFLG | MDFLG | MDFLG | CHAR | 1 | 0 | Indicator: Matrix maintenance | ||
65 | TXJLV | TXJCD_LEVEL | CHAR1 | CHAR | 1 | 0 | Tax jurisdiction code level | ||
66 | KBFLAG | KBFLAG | KBFLAG | RAW | 2 | 0 | Bit encrypted flags in Pricing | ||
67 | KOLNR3 | KOLNR3 | KOLNR3 | NUMC | 3 | 0 | Access Sequence - Access Number | * | |
68 | CPF_GUID | CPF_GUID | SYSUUID_C | CHAR | 32 | 0 | Identifier of CPF Formula in Document |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | KONVN | KAPPL | T681A | KAPPL | |||
2 | KONVN | KMEIN | T006 | MSEHI | |||
3 | KONVN | KONMS | T006 | MSEHI | REF | 1 | N |
4 | KONVN | KONWS | TCURC | WAERS | REF | 1 | N |
5 | KONVN | KSCHL | T685A | KSCHL | |||
6 | KONVN | KUNNR | KNA1 | KUNNR | |||
7 | KONVN | KVSL1 | T687 | KVSL1 | |||
8 | KONVN | KVSL2 | T687 | KVSL1 | |||
9 | KONVN | LIFNR | LFA1 | LIFNR | |||
10 | KONVN | MANDT | T000 | MANDT | |||
11 | KONVN | SAKN1 | SKA1 | SAKNR | |||
12 | KONVN | SAKN2 | SKA1 | SAKNR | |||
13 | KONVN | WAERS | TCURC | WAERS |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |