SAP ABAP Table MCJKOMVB (Billing KOMV LIS communication structure for sales area)
Hierarchy
☛
IS-M (Software Component) SAP MEDIA
⤷ IS-M (Application Component) SAP Media
⤷ JAS (Package) Application development R/3 Publishing Advertising System***
⤷ IS-M (Application Component) SAP Media
⤷ JAS (Package) Application development R/3 Publishing Advertising System***
Basic Data
Table Category | INTTAB | Structure |
Structure | MCJKOMVB | Table Relationship Diagram |
Short Description | Billing KOMV LIS communication structure for sales area |
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 | Update Indicator for Statistics Updating | |||||
2 | SUPKZ | SUPKZ | SUPKZ | CHAR | 1 | 0 | Statistics update indicator (post in/post out) | ||
3 | .INCLUDE | 0 | 0 | Pricing Communications-Condition Record | |||||
4 | .INCLUDE | 0 | 0 | Conditions (Transaction Data) | |||||
5 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
6 | KNUMV | KNUMV | KNUMV | CHAR | 10 | 0 | Number of the document condition | ||
7 | KPOSN | KPOSN | NUM6 | NUMC | 6 | 0 | Condition Item Number | ||
8 | STUNR | STUNR | STUNR | NUMC | 3 | 0 | Level Number | * | |
9 | ZAEHK | DZAEHK | ZAEHK | NUMC | 2 | 0 | Condition counter | ||
10 | KAPPL | KAPPL | KAPPL | CHAR | 2 | 0 | Application | T681A | |
11 | KSCHL | KSCHA | KSCHL | CHAR | 4 | 0 | Condition Type | T685A | |
12 | KDATU | KDATU | DATUM | DATS | 8 | 0 | Condition pricing date | ||
13 | KRECH | KRECH | KRECH | CHAR | 1 | 0 | Calculation type for condition | ||
14 | KAWRT | KAWRT | WERTV8 | CURR | 15 | 2 | Condition Basis | ||
15 | KBETR | KBETR | WERTV6 | CURR | 11 | 2 | Rate (condition amount or percentage) | ||
16 | WAERS | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
17 | KKURS | KKURS | KKURS | DEC | 9 | 5 | Condition exchange rate for conversion to local currency | ||
18 | KPEIN | KPEIN | KPEIN | DEC | 5 | 0 | Condition pricing unit | ||
19 | KMEIN | KVMEI | MEINS | UNIT | 3 | 0 | Condition unit in the document | T006 | |
20 | KUMZA | KUMZA | UMBSZ | DEC | 5 | 0 | Numerator for converting condition units to base units | ||
21 | KUMNE | KUMNE | UMBSN | DEC | 5 | 0 | Denominator for converting condition units to base units | ||
22 | KNTYP | KNTYP | KNTYP | CHAR | 1 | 0 | Condition Cat.: Frt, Tax, Basic Price=Revenue, Price, Cost | ||
23 | KSTAT | KSTAT | XFELD | CHAR | 1 | 0 | Condition is used for statistics | ||
24 | KNPRS | STFKZ | STFKZ | CHAR | 1 | 0 | Scale type | ||
25 | KRUEK | KRUEK | XFELD | CHAR | 1 | 0 | Condition is Relevant for Accrual (e.g. Freight) | ||
26 | KRELI | KRELI | KRELI | CHAR | 1 | 0 | Condition for invoice list | ||
27 | KHERK | KHERK | KHERK | CHAR | 1 | 0 | Condition Origin | ||
28 | KGRPE | KGRPE | KGRPE | CHAR | 1 | 0 | Group condition | ||
29 | KOUPD | KOUPD | XFELD | CHAR | 1 | 0 | Condition update | ||
30 | KOLNR | KOLNR | KOLNR | NUMC | 2 | 0 | Access Sequence - Access Number | * | |
31 | KNUMH | KNUMH | KNUMB | CHAR | 10 | 0 | Condition record number | ||
32 | KOPOS | KOPOS | NUM02 | NUMC | 2 | 0 | Sequential number of the condition | ||
33 | KVSL1 | KVSL1 | KVSCHL | CHAR | 3 | 0 | Account key | T687 | |
34 | SAKN1 | SAKNR | SAKNR | CHAR | 10 | 0 | G/L Account Number | SKA1 | |
35 | MWSK1 | MWSKZ | MWSKZ | CHAR | 2 | 0 | Tax on sales/purchases code | * | |
36 | KVSL2 | KVSL2 | KVSCHL | CHAR | 3 | 0 | Account key - accruals / provisions | T687 | |
37 | SAKN2 | SAKNR_ACCR | SAKNR | CHAR | 10 | 0 | Number of Provision Account | SKA1 | |
38 | MWSK2 | WT_WITHCD | WT_WITHCD | CHAR | 2 | 0 | Withholding tax code | * | |
39 | LIFNR | LIFNR | LIFNR | CHAR | 10 | 0 | Account Number of Vendor or Creditor | LFA1 | |
40 | KUNNR | KUNNR_KO | KUNNR | CHAR | 10 | 0 | Customer number (rebate recipient) | KNA1 | |
41 | KDIFF | KDIFF | WERTV3 | CURR | 5 | 2 | Rounding-off difference of the condition | ||
42 | KWERT | KWERT | WERTV7 | CURR | 13 | 2 | Condition Value | ||
43 | KSTEU | KSTEU | KSTEU | CHAR | 1 | 0 | Condition control | ||
44 | KINAK | KINAK | KINAK | CHAR | 1 | 0 | Condition is inactive | ||
45 | KOAID | KOAID | KOAID | CHAR | 1 | 0 | Condition class | ||
46 | ZAEKO | DZAEKO | ZAEHK | NUMC | 2 | 0 | Condition counter for (header conditions) | ||
47 | KMXAW | KMXAW | KMXWR | CHAR | 1 | 0 | Indicator for maximum condition base value | ||
48 | KMXWR | KMXWR | KMXWR | CHAR | 1 | 0 | Indicator for maximum condition amount | ||
49 | KFAKTOR | KFAKTOR | FLTP | FLTP | 16 | 16 | Factor for condition base value | ||
50 | KDUPL | KDUPL | KDUPL | CHAR | 1 | 0 | Structure condition | ||
51 | KFAKTOR1 | KFAKTOR1 | FLTP | FLTP | 16 | 16 | Factor for condition basis (period) | ||
52 | KZBZG | KZBZG | KZBZG | CHAR | 1 | 0 | Indicator: Scale Base Type | ||
53 | KSTBS | KSTBS | WERTV8 | CURR | 15 | 2 | Scale base value of the condition | ||
54 | KONMS | KONMS | MEINS | UNIT | 3 | 0 | Condition scale unit of measure | T006 | |
55 | KONWS | KONWS | WAERS | CUKY | 5 | 0 | Currency Key: Condition Scale | TCURC | |
56 | KAWRT_K | KAWRT | WERTV8 | CURR | 15 | 2 | Condition Basis | ||
57 | KWAEH | KWAEH | WAERS | CUKY | 5 | 0 | Condition currency (for cumulation fields) | * | |
58 | KWERT_K | KWERT | WERTV7 | CURR | 13 | 2 | Condition Value | ||
59 | KFKIV | KFKIV | XFELD | CHAR | 1 | 0 | Condition for Inter-Company Billing | ||
60 | KVARC | KVARC | XFELD | CHAR | 1 | 0 | Condition for Configuration | ||
61 | KMPRS | KMPRS | XFELD | CHAR | 1 | 0 | Condition changed manually | ||
62 | PRSQU | PRSQU1 | PRSQU | CHAR | 1 | 0 | Price source | ||
63 | VARCOND | VARCOND | VARCON | CHAR | 26 | 0 | Variant condition | * | |
64 | STUFE | HISTU | DEC2 | DEC | 2 | 0 | Level (in Multi-Level BOM Explosions) | ||
65 | WEGXX | WEGXX | DEC4 | DEC | 4 | 0 | Path (for Multi-Level BOM Explosions) | ||
66 | KTREL | KTREL | KTREL | CHAR | 1 | 0 | Relevance for account assignment | ||
67 | MDFLG | MDFLG | MDFLG | CHAR | 1 | 0 | Indicator: Matrix maintenance | ||
68 | TXJLV | TXJCD_LEVEL | CHAR1 | CHAR | 1 | 0 | Tax jurisdiction code level | ||
69 | KBFLAG | KBFLAG | KBFLAG | RAW | 2 | 0 | Bit encrypted flags in Pricing | ||
70 | KOLNR3 | KOLNR3 | KOLNR3 | NUMC | 3 | 0 | Access Sequence - Access Number | * | |
71 | CPF_GUID | CPF_GUID | SYSUUID_C | CHAR | 32 | 0 | Identifier of CPF Formula in Document | ||
72 | .INCLUDE | 0 | 0 | User Structure: Pricing | |||||
73 | DUMMY | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
74 | .INCLUDE | 0 | 0 | Pricing Communication Condition Record, Dynamic | |||||
75 | PRSCH | PRSCH | CHAR4 | CHAR | 4 | 0 | Price levels | ||
76 | KOFRM | KOFRM | KOFRM | NUMC | 3 | 0 | Condition formula for alternative calculation type | ||
77 | STFKZ | STFKZ | STFKZ | CHAR | 1 | 0 | Scale type | ||
78 | KSTBM | KSTBM_AKT | WERT8 | CURR | 15 | 2 | Incremental scale: start of interval | ||
79 | KSTBM_NEXT | KSTBM_NEXT | WERT8 | CURR | 15 | 2 | Increase scale: end of interval | ||
80 | IX_KOMT1 | KOIDX | KOIDX | INT4 | 10 | 0 | Index number for internal tables | ||
81 | IX_GKOMV | KOIDX | KOIDX | INT4 | 10 | 0 | Index number for internal tables | ||
82 | ZAEHK_IND | DZAEHK_IND | ZAEHK | NUMC | 2 | 0 | Condition item index | ||
83 | DRUKZ | DRUKZ | DRUKZ | CHAR | 1 | 0 | Print Indicator | ||
84 | STUNB | STUNB | STUNR | NUMC | 3 | 0 | From reference step (for percentage conditions) | * | |
85 | STUN2 | STUNB | STUNR | NUMC | 3 | 0 | From reference step (for percentage conditions) | * | |
86 | KZWIW | KZWIW | KZWIW | CHAR | 1 | 0 | Condition subtotal | ||
87 | KOFRA | KOFRA | KOFRM | NUMC | 3 | 0 | Condition Formula for Condition Basis | ||
88 | KOFRS | KOFRS | KOFRM | NUMC | 3 | 0 | Formula for scale base value | ||
89 | KMANU | KMANU | KMANU | CHAR | 1 | 0 | Making manual entries | ||
90 | TXPRF | TXPRF | TXPRF | CHAR | 1 | 0 | Rounding rule | ||
91 | KNEGA | KNEGA | KNEGA | CHAR | 1 | 0 | Plus/minus sign of the condition amount | ||
92 | GANZZ | GANZZ | XFELD | CHAR | 1 | 0 | Indicator: Currency Conversion after Multiplication | ||
93 | KOBLI | KOBLI | XFELD | CHAR | 1 | 0 | Condition is mandatory | ||
94 | KAEND_BTR | KAEND_BTR | XFELD | CHAR | 1 | 0 | Condition rate of change for amount/percentage | ||
95 | KAEND_WRT | KAEND_WRT | XFELD | CHAR | 1 | 0 | Scope for changing the value | ||
96 | KAEND_UFK | KAEND_UFK | XFELD | CHAR | 1 | 0 | Scope for changing conversion factors | ||
97 | KAEND_RCH | KAEND_RCH | XFELD | CHAR | 1 | 0 | Condition Rate of Change for Calculation Type | ||
98 | KAEND_LOE | KAEND_LOE | XFELD | CHAR | 1 | 0 | Delete the scope for changing rate | ||
99 | KAEND_MEH | KAEND_MEH | XFELD | CHAR | 1 | 0 | Condition scope of change for unit of measure | ||
100 | KZTERM | KZTERM | XFELD | CHAR | 1 | 0 | Terms of payment ID in the condition | ||
101 | FXMSG | MSGNR | MSGNR | CHAR | 3 | 0 | Message number | * | |
102 | UPDKZ | UPDKZ_D | UPDKZ | CHAR | 1 | 0 | Update indicator | ||
103 | SELKZ | SELKZ | SELKZ | CHAR | 1 | 0 | Selection flag | ||
104 | BOSTA | BOSTA | BOSTA | CHAR | 1 | 0 | Status of the agreement | ||
105 | KSPAE | KSPAE | XFELD | CHAR | 1 | 0 | Rebate was set up retroactively | ||
106 | LOEVM_KO | LOEVM_KO | XFELD | CHAR | 1 | 0 | Deletion indicator for condition item | ||
107 | KNUMA_BO | KNUMA | KNUMA | CHAR | 10 | 0 | Agreement (various conditions grouped together) | KONA | |
108 | BERGL | BERGL | BERGL | CHAR | 1 | 0 | Calculation Base | ||
109 | VHART | VHIART | TRATY | CHAR | 4 | 0 | Shipping material type | TVTY | |
110 | RDIFA | RDIFA | XFELD | CHAR | 1 | 0 | Rounding Difference Clearing | ||
111 | KMENG | KMENG | XFELD | CHAR | 1 | 0 | Quantity conversion | ||
112 | KBUFF | KBUFF | XFELD | CHAR | 1 | 0 | Condition read from buffer | ||
113 | BOSTA_CR | BOSTA_CR | BOSTA_CR | CHAR | 1 | 0 | Condition Record Status (Rebate) | ||
114 | IS_CPF_ENABLED | COND_IS_CPF_ENABLED | IS_CPF_ENABLED | CHAR | 1 | 0 | Condition Enabled for Config. Parameters and Formulas (CPF) |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | MCJKOMVB | KAPPL | T681A | KAPPL | |||
2 | MCJKOMVB | KMEIN | T006 | MSEHI | |||
3 | MCJKOMVB | KNUMA_BO | KONA | KNUMA | |||
4 | MCJKOMVB | KONMS | T006 | MSEHI | REF | 1 | N |
5 | MCJKOMVB | KONWS | TCURC | WAERS | REF | 1 | N |
6 | MCJKOMVB | KSCHL | T685A | KSCHL | |||
7 | MCJKOMVB | KUNNR | KNA1 | KUNNR | |||
8 | MCJKOMVB | KVSL1 | T687 | KVSL1 | |||
9 | MCJKOMVB | KVSL2 | T687 | KVSL1 | |||
10 | MCJKOMVB | LIFNR | LFA1 | LIFNR | |||
11 | MCJKOMVB | MANDT | T000 | MANDT | |||
12 | MCJKOMVB | SAKN1 | SKA1 | SAKNR | |||
13 | MCJKOMVB | SAKN2 | SKA1 | SAKNR | |||
14 | MCJKOMVB | VHART | TVTY | TRATY | REF | C | CN |
15 | MCJKOMVB | WAERS | TCURC | WAERS |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |