SAP ABAP Table OIC_KONV (Conditions (Procedure Data))
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ OIC (Package) MAP Marketing, Accounting and Pricing
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ OIC (Package) MAP Marketing, Accounting and Pricing
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | OIC_KONV | Table Relationship Diagram |
Short Description | Conditions (Procedure Data) |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
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 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | KNUMV | KNUMV | KNUMV | CHAR | 10 | 0 | Number of the document condition | ||
3 | KPOSN | KPOSN | NUM6 | NUMC | 6 | 0 | Condition Item Number | ||
4 | STUNR | STUNR | STUNR | NUMC | 3 | 0 | Level Number | * | |
5 | ZAEHK | DZAEHK | ZAEHK | NUMC | 2 | 0 | Condition counter | ||
6 | KAPPL | KAPPL | KAPPL | CHAR | 2 | 0 | Application | T681A | |
7 | KSCHL | KSCHA | KSCHL | CHAR | 4 | 0 | Condition Type | * | |
8 | KDATU | KDATU | DATUM | DATS | 8 | 0 | Condition pricing date | ||
9 | KRECH | KRECH | KRECH | CHAR | 1 | 0 | Calculation type for condition | ||
10 | KAWRT | KAWRT | WERTV8 | CURR | 15 | 2 | Condition Basis | ||
11 | KBETR | KBETR | WERTV6 | CURR | 11 | 2 | Rate (condition amount or percentage) | ||
12 | WAERS | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
13 | KKURS | KKURS | KKURS | DEC | 9 | 5 | Condition exchange rate for conversion to local currency | ||
14 | KPEIN | KPEIN | KPEIN | DEC | 5 | 0 | Condition pricing unit | ||
15 | KMEIN | KVMEI | MEINS | UNIT | 3 | 0 | Condition unit in the document | T006 | |
16 | KUMZA | KUMZA | UMBSZ | DEC | 5 | 0 | Numerator for converting condition units to base units | ||
17 | KUMNE | KUMNE | UMBSN | DEC | 5 | 0 | Denominator for converting condition units to base units | ||
18 | KNTYP | KNTYP | KNTYP | CHAR | 1 | 0 | Condition Cat.: Frt, Tax, Basic Price=Revenue, Price, Cost | ||
19 | KSTAT | KSTAT | XFELD | CHAR | 1 | 0 | Condition is used for statistics | ||
20 | KNPRS | STFKZ | STFKZ | CHAR | 1 | 0 | Scale type | ||
21 | KRUEK | KRUEK | XFELD | CHAR | 1 | 0 | Condition is Relevant for Accrual (e.g. Freight) | ||
22 | KRELI | KRELI | KRELI | CHAR | 1 | 0 | Condition for invoice list | ||
23 | KHERK | KHERK | KHERK | CHAR | 1 | 0 | Condition Origin | ||
24 | KGRPE | KGRPE | KGRPE | CHAR | 1 | 0 | Group condition | ||
25 | KOUPD | KOUPD | XFELD | CHAR | 1 | 0 | Condition update | ||
26 | KOLNR | KOLNR | KOLNR | NUMC | 2 | 0 | Access Sequence - Access Number | * | |
27 | KNUMH | KNUMH | KNUMB | CHAR | 10 | 0 | Condition record number | ||
28 | KOPOS | KOPOS | NUM02 | NUMC | 2 | 0 | Sequential number of the condition | ||
29 | KVSL1 | KVSL1 | KVSCHL | CHAR | 3 | 0 | Account key | T687 | |
30 | SAKN1 | SAKNR | SAKNR | CHAR | 10 | 0 | G/L Account Number | SKA1 | |
31 | MWSK1 | MWSKZ | MWSKZ | CHAR | 2 | 0 | Tax on sales/purchases code | * | |
32 | KVSL2 | KVSL2 | KVSCHL | CHAR | 3 | 0 | Account key - accruals / provisions | T687 | |
33 | SAKN2 | SAKNR | SAKNR | CHAR | 10 | 0 | G/L Account Number | SKA1 | |
34 | MWSK2 | MWSKZ | MWSKZ | CHAR | 2 | 0 | Tax on sales/purchases code | * | |
35 | LIFNR | LIFNR | LIFNR | CHAR | 10 | 0 | Account Number of Vendor or Creditor | LFA1 | |
36 | KUNNR | KUNNR_KO | KUNNR | CHAR | 10 | 0 | Customer number (rebate recipient) | KNA1 | |
37 | KDIFF | KDIFF | WERTV3 | CURR | 5 | 2 | Rounding-off difference of the condition | ||
38 | KWERT | KWERT | WERTV7 | CURR | 13 | 2 | Condition Value | ||
39 | KSTEU | KSTEU | KSTEU | CHAR | 1 | 0 | Condition control | ||
40 | KINAK | KINAK | KINAK | CHAR | 1 | 0 | Condition is inactive | ||
41 | KOAID | KOAID | KOAID | CHAR | 1 | 0 | Condition class | ||
42 | ZAEKO | DZAEKO | ZAEHK | NUMC | 2 | 0 | Condition counter for (header conditions) | ||
43 | KMXAW | KMXAW | KMXWR | CHAR | 1 | 0 | Indicator for maximum condition base value | ||
44 | KMXWR | KMXWR | KMXWR | CHAR | 1 | 0 | Indicator for maximum condition amount | ||
45 | .INCLUDE | 0 | 0 | IS-Oil Rel.3.0C - Do not append/add fields | |||||
46 | OIKOSTL | OIA_KOSTL | KOSTL | CHAR | 10 | 0 | Cost center for fee expense accounting | * | |
47 | OIACPOL | OIA_ACPOL | OIA_ACPOL | CHAR | 1 | 0 | Fee accounting policy indicator | ||
48 | OIFEEMAN | OIA_FEEMAN | OIA_FEEMAN | CHAR | 1 | 0 | Fee rate indicator | ||
49 | OIKWERT | OIA_KWERT | WERTV7 | CURR | 13 | 2 | Fee detail clearing amount | ||
50 | OIFEEPRT | OIA_FEEPRT | XFELD | CHAR | 1 | 0 | Condition is printed at item level | ||
51 | OIGRNET | OIC_GRNET | OIC_GRNET | CHAR | 1 | 0 | Gross/net pricing indicator | ||
52 | OIGNSTRA | OIC_GNSTRA | OIC_GNSTRA | CHAR | 1 | 0 | Gross/net pricing strategy used | ||
53 | OIGRCHK | OIC_GRCHK | XFELD | CHAR | 1 | 0 | Carry out gross/net unit check | ||
54 | OIINVCYC | OIA_INVCYC | OIA_INVCYC | NUMC | 1 | 0 | Invoice cycle | TOIA10 | |
55 | OIINVCYACT | OIA_INCYCI | KREUZ | CHAR | 1 | 0 | Invoice cycle included indicator active (X/ ) | ||
56 | OIINCYST | OIA_INCYST | KREUZ | CHAR | 1 | 0 | Cond. statistical due to invoicing cycle | ||
57 | OIA_SPLTIV | OIA_SPLTIV | OIA_SPLTIV | CHAR | 1 | 0 | Indicator for split invoice verification | ||
58 | OIA_ZTERM | DZTERM | ZTERM | CHAR | 4 | 0 | Terms of payment key | ||
59 | KFAKTOR | KFAKTOR | FLTP | FLTP | 16 | 16 | Factor for condition base value | ||
60 | KDUPL | KDUPL | KDUPL | CHAR | 1 | 0 | Structure condition | ||
61 | KFAKTOR1 | KFAKTOR1 | FLTP | FLTP | 16 | 16 | Factor for condition basis (period) | ||
62 | .INCLUDE | 0 | 0 | IS-Oil Rel.3.1H - Do not append/add fields | |||||
63 | OILICIN | OIH_LICIN | OIH_LICIN | CHAR | 10 | 0 | Excise tax internal license number | * | |
64 | OILICTP | OIH_LICTP | OIH_LICTP | CHAR | 4 | 0 | License type | * | |
65 | OIREPORT | OIC_REPORT | TRANSA | CHAR | 8 | 0 | Report number | ||
66 | OIDATA | OIC_DATA | GRPNO | NUMC | 3 | 0 | Routine number for data capture | * | |
67 | OIHEAD | OIC_HEAD | GRPNO | NUMC | 3 | 0 | Header format routine for second level analysis report | * | |
68 | OIITEM | OIC_ITEM | GRPNO | NUMC | 3 | 0 | Item routine for second level analysis report | * | |
69 | OIERRHAN | OIC_SECERR | GRPNO | NUMC | 3 | 0 | Error handling routine for second level analysis | * | |
70 | KZBZG | KZBZG | KZBZG | CHAR | 1 | 0 | Indicator: Scale Base Type | ||
71 | KSTBS | KSTBS | WERTV8 | CURR | 15 | 2 | Scale base value of the condition | ||
72 | KONMS | KONMS | MEINS | UNIT | 3 | 0 | Condition scale unit of measure | T006 | |
73 | KONWS | KONWS | WAERS | CUKY | 5 | 0 | Currency Key: Condition Scale | TCURC | |
74 | KAWRT_K | KAWRT | WERTV8 | CURR | 15 | 2 | Condition Basis | ||
75 | KWAEH | KWAEH | WAERS | CUKY | 5 | 0 | Condition currency (for cumulation fields) | * | |
76 | KWERT_K | KWERT | WERTV7 | CURR | 13 | 2 | Condition Value | ||
77 | KFKIV | KFKIV | XFELD | CHAR | 1 | 0 | Condition for Inter-Company Billing | ||
78 | KVARC | KVARC | XFELD | CHAR | 1 | 0 | Condition for Configuration | ||
79 | KMPRS | KMPRS | XFELD | CHAR | 1 | 0 | Condition changed manually | ||
80 | PRSQU | PRSQU1 | PRSQU | CHAR | 1 | 0 | Price source | ||
81 | VARCOND | VARCOND | VARCON | CHAR | 26 | 0 | Variant condition | * | |
82 | STUFE | HISTU | DEC2 | DEC | 2 | 0 | Level (in Multi-Level BOM Explosions) | ||
83 | WEGXX | WEGXX | DEC4 | DEC | 4 | 0 | Path (for Multi-Level BOM Explosions) | ||
84 | KTREL | KTREL | KTREL | CHAR | 1 | 0 | Relevance for account assignment | ||
85 | MDFLG | MDFLG | MDFLG | CHAR | 1 | 0 | Indicator: Matrix maintenance | ||
86 | TXJLV | TXJCD_LEVEL | CHAR1 | CHAR | 1 | 0 | Tax jurisdiction code level | ||
87 | KBFLAG | KBFLAG | KBFLAG | RAW | 2 | 0 | Bit encrypted flags in Pricing | ||
88 | .INCLUDE | 0 | 0 | IS-Oil Rel.4.6B - Do not append/add fields | |||||
89 | OIU_EP | OIU_EP | FLAG | CHAR | 1 | 0 | Exploration and Production condition (PRA) | ||
90 | OIRCONDCL | OIRE_CONDCLA | CHAR1 | CHAR | 1 | 0 | SSR PC: Condition classification |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | OIC_KONV | KAPPL | T681A | KAPPL | REF | 1 | CN |
2 | OIC_KONV | KMEIN | T006 | MSEHI | REF | C | CN |
3 | OIC_KONV | KONMS | T006 | MSEHI | REF | 1 | N |
4 | OIC_KONV | KONWS | TCURC | WAERS | 1 | N | |
5 | OIC_KONV | KUNNR | KNA1 | KUNNR | REF | C | CN |
6 | OIC_KONV | KVSL1 | T687 | KVSL1 | REF | C | CN |
7 | OIC_KONV | KVSL2 | T687 | KVSL1 | REF | C | CN |
8 | OIC_KONV | LIFNR | LFA1 | LIFNR | REF | C | CN |
9 | OIC_KONV | MANDT | T000 | MANDT | KEY | 1 | CN |
10 | OIC_KONV | OIINVCYC | TOIA10 | OIINVCYC | |||
11 | OIC_KONV | SAKN1 | SKA1 | SAKNR | REF | C | CN |
12 | OIC_KONV | SAKN2 | SKA1 | SAKNR | REF | C | CN |
13 | OIC_KONV | WAERS | TCURC | WAERS | REF | C | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |