SAP ABAP Table JHTVKO (IS-M/AM: Contract)
Hierarchy
IS-M (Software Component) SAP MEDIA
   IS-M (Application Component) SAP Media
     JAS (Package) Application development R/3 Publishing Advertising System***
Basic Data
Table Category TRANSP    Transparent table 
Transparent table JHTVKO   Table Relationship Diagram
Short Description IS-M/AM: Contract    
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 VTNR ABS_VTNR ABS_VTNR NUMC 6   0   IS-M: Contract Number  
3 .INCLUDE       0   0   IS-M: Organizational Data for a Contract  
4 .INCLUDE       0   0   IS-M: Sales Area  
5 VKORG VKORG VKORG CHAR 4   0   Sales Organization TVKO
6 VTWEG VTWEG VTWEG CHAR 2   0   Distribution Channel TVKOV
7 SPART SPART SPART CHAR 2   0   Division TVTA
8 VKBUR VKBUR VKBUR CHAR 4   0   Sales office TVKBZ
9 VKGRP VKGRP VKGRP CHAR 3   0   Sales group TVBVK
10 XORG_ERG XORG_ERG XFELD CHAR 1   0   IS-M: Contract has Explicitly Assigned Sales Areas  
11 ABINHNR ABINHNR GPNR CHAR 10   0   IS-M/AM: Number of Contract Holder JGTGPNR
12 IHREZ IHREZ TEXT12 CHAR 12   0   Your Reference  
13 KDMI ISM_CP_CNTRCT_HLDR BU_PARTNER CHAR 10   0   IS-M: Contact Person for Contract Holder *
14 XQUASI XQUASI XFELD CHAR 1   0   IS-M: System Contracts Yes/No Indicator  
15 XGE_GESCH XGE_GESCH XFELD CHAR 1   0   IS-M: Barter Deal Indicator  
16 XKUBO XKUBO XFELD CHAR 1   0   IS-M: Indicator Customer Bonus Contract  
17 XTO_BEST XTO_BEST XFELD CHAR 1   0   IS-M: "Confirnation Required" Indicator  
18 XTO_WARN XTO_WARN XFELD CHAR 1   0   IS-M: Advance Warning Indicator  
19 XWARN_GEN XWARN_GEN XFELD CHAR 1   0   IS-M: Generate non-fulfillment warning  
20 XTO_HINW XTO_HINW XFELD CHAR 1   0   IS-M: Generate end note indicator  
21 XHINW_GEN XHINW_GEN XFELD CHAR 1   0   IS-M: Generate validity period end note indicator  
22 XBESTK XBESTK XFELD CHAR 1   0   IS-M: Contract Status (Created/Confirmed)  
23 B_DATUM B_DATUM DATUM DATS 8   0   IS-M: Confirmation Date  
24 XNEUSTAT XNEUSTAT XFELD CHAR 1   0   IS-M: Renewal status (renewed y/n)  
25 E_DATUM ER_DATUM   DATS 8   0   IS-M: Contract Renewal Date  
26 V_NUMMER V_NUMMER SYNUM01 NUMC 1   0   IS-M: Current Number of Advance Warning  
27 V_DATUM V_DATUM DATUM DATS 8   0   IS-M: Advance Warning Date  
28 XENDK XENDK XFELD CHAR 1   0   IS-M: Status of runtime end note  
29 H_DATUM H_DATUM DATUM DATS 8   0   IS-M: Date of End of Validity Period Note (Contract)  
30 XABRSPERR XABRSPERR XFELD CHAR 1   0   IS-M: Settlement Block  
31 ABRECHK ABRECHK ABRECHK CHAR 1   0   IS-M: Settlement Type *
32 XABR XABR XFELD CHAR 1   0   IS-M: Perform Settlement Yes/No Indicator  
33 R_DATUM R_DATUM DATUM DATS 8   0   IS-M: Date of Last Interim/Final Settlement  
34 ABRGNR ABRGNR ABRGNR NUMC 4   0   IS-M/AM: Contract Settlement Number *
35 EABR_NACHL EABR_NACHL SYNUM02 NUMC 2   0   IS-M: Time of Final Settlement After Runtime (in Months)  
36 XLOEVM LOEVM_ISP XFELD CHAR 1   0   Deletion Flag for Master Data in Media Sales & Distribution  
37 XLOEKZ LOEKZ_ISP XFELD CHAR 1   0   Deletion Indicator for Master Data in Media Sales & Dist.  
38 XLFZAEN XLFZAEN XFELD CHAR 1   0   IS-M: Validity Period in Contract Changed  
39 LFZBEG LFZBEG DATUM DATS 8   0   IS-M: Start of Validity Period  
40 LFZEND LFZEND DATUM DATS 8   0   IS-M: End of Validity Period  
41 B_AUSR ABSCHL_BEG ABSCHL_BEG CHAR 1   0   IS-M: Rule for Contract Start TJJV14
42 E_AUSR ABSCHL_END ABSCHL_END CHAR 1   0   IS-M: Rule for Contract End TJJV15
43 XABE XABSCH_ERN XFELD CHAR 1   0   IS-M: Automatic Contract Renewal?  
44 FVTNR ABS_FVTNR ABS_VTNR NUMC 6   0   IS-M: Number of Follow-On Contract JHTVKO
45 VVTNR ABS_VVTNR ABS_VTNR NUMC 6   0   IS-M: Predecessor to Current Contract JHTVKO
46 XNOBEL XNOBEL XFELD CHAR 1   0   IS-M: Do Not Perform Subsequent Debit  
47 XZWABR XZWABR XFELD CHAR 1   0   IS-M: Perform Interim Settlement Automatically  
48 XBEARB XGENEHM XFELD CHAR 1   0   IS-M: Postprocess/Approve Contract  
49 ABS_NACHB ABS_NACHB NATXT CHAR 73   0   IS-M: Post-Editing Reason  
50 XKONZERN XKONZERN XFELD CHAR 1   0   IS-M: Group Contract  
51 XINSKUM XINSKUM XFELD CHAR 1   0   IS-M: Cumulation Rule for Contract Assignments  
52 ABS_TYP1 ABS_TYP ABS_TYP CHAR 1   0   IS-M/AM: Contract Category TJH11
53 XBEST_PR XBEST_PR XFELD CHAR 1   0   IS-M: Apply Best Conditions to Number / Quantity  
54 XPOSAEN XPOSAEN XFELD CHAR 1   0   IS-M: "Contract Item Changed" Indicator  
55 XZIELAEN XZIELAEN XFELD CHAR 1   0   IS-M: "Target Quantities in COA Changed" Indicator  
56 PR_BASIS PR_BASIS PR_BASIS CHAR 1   0   IS-M: Basis for scale access (number/quantity)  
57 MENGE1 ABS_MENGE1 ABS_MENGE QUAN 12   3   IS-M/AM: Agreed Quantity to be Sold  
58 EINH1 AB_MEINH MEINS UNIT 3   0   IS-M: Contract Units of Measurement *
59 AB_ZIEL1 AB_ZIEL1 WERTV8 CURR 15   2   IS-M/AM: Target Quantity for Monetary Contract  
60 AB_WEINH AB_WEINH WAERS CUKY 5   0   IS-M: Currency Key for Contract TCURC
61 RKSCHL KSCHL KSCHL CHAR 4   0   Condition Type *
62 BKSCHL KSCHL KSCHL CHAR 4   0   Condition Type *
63 MENGE2 ABS_MENGE2 ABS_MENGE QUAN 12   3   IS-M/AM: Agreed Quantity to be Sold  
64 EINH2 AB_MEINH MEINS UNIT 3   0   IS-M: Contract Units of Measurement *
65 MEINH AB_MEINH MEINS UNIT 3   0   IS-M: Contract Units of Measurement T006
66 ORIG_MENG1 ABS_MENGE1 ABS_MENGE QUAN 12   3   IS-M/AM: Agreed Quantity to be Sold  
67 ORIG_MENG2 ABS_MENGE2 ABS_MENGE QUAN 12   3   IS-M/AM: Agreed Quantity to be Sold  
68 ORIG_ZIEL1 AB_ZIEL1 WERTV8 CURR 15   2   IS-M/AM: Target Quantity for Monetary Contract  
69 XAB_PREIS XAB_PREIS XFELD CHAR 1   0   IS-M/AM: Basic Price from Contract Indicator  
70 XAB_PRLST XAB_PRLST XFELD CHAR 1   0   IS-M: Do not Overfulfill Contract Indicator  
71 AB_PREIS AB_PREIS WERTV8 CURR 15   2   IS-M: Current Valid Price from Contract  
72 AB_KPREIS AB_KPREIS WERTV8 CURR 15   2   IS-M: Price from Scale  
73 AB_VPREIS AB_VPREIS WERTV8 CURR 15   2   IS-M: Agreed Price from Contract  
74 FMP_KPEIN KPEIN KPEIN DEC 5   0   Condition pricing unit  
75 FMP_KMEIN KMEIN MEINS UNIT 3   0   Condition Unit T006
76 RKNUMV AB_RKNUMV RABATT DEC 5   2   IS-M: Discount from Scale  
77 RABATT AB_RABATT RABATT DEC 5   2   IS-M: Current Valid Contract Discount Rate  
78 VRABATT VRABATT RABATT DEC 5   2   IS-M: Agreed Discount  
79 XRABAEN XRABAEN XFELD CHAR 1   0   IS-M/AM: Discount Changed Manually  
80 XRAB_CH XRAB_CH XFELD CHAR 1   0   IS-M: Current discount change  
81 XRABA XRABATTANP XFELD CHAR 1   0   IS-M/AM: Indicator: Adjust Discount During Contract Period?  
82 XERFUELLT XERFUELLT XFELD CHAR 1   0   IS-M/AM: Contract Fulfilled Yes/No Indicator  
83 XRABAN XRABAN XFELD CHAR 1   0   IS-M: Next discount level characteristic reached  
84 XRABAZW XRABAZW XFELD CHAR 1   0   IS-M/AM: Discount change with next interim settlement  
85 XRABSPERR XRABSPERR XFELD CHAR 1   0   IS-M: Block higher-level discounts indicator  
86 XBRUTTO XBRUTTO XFELD CHAR 1   0   IS-M: Gross Contract Characteristic  
87 BKNUMV AB_BKNUMV RABATT DEC 5   2   IS-M/AM: Bonus from Scale  
88 XVBONUS XVBONUS XFELD CHAR 1   0   IS-M: Advance Bonus Indicator  
89 AKTBONUS AKTBONUS RABATT DEC 5   2   IS-M/AM: Current Valid Contract Bonus  
90 VBONUS VBONUS RABATT DEC 5   2   IS-M: Agreed Bonus  
91 XGUTSCHR XGUTSCHR XFELD CHAR 1   0   IS-M: Do not perform credit memo characteristic  
92 ZTERM DZTERM ZTERM CHAR 4   0   Terms of payment key  
93 FREITEXT ABS_TEXT FREITEXT CHAR 50   0   IS-M: Freely Definable Text  
94 L_FKT_DAT L_FKT_DAT DATUM DATS 8   0   IS-M: Last Actual Billing Date  
95 L_AE_DAT L_AE_DAT DATUM DATS 8   0   IS-M: Last Publication Date  
96 ABS_ZUST ABS_ZUST XUBNAME CHAR 12   0   IS-M: Person Responsible USR02
97 FRD_VTNR FRD_VTNR CHAR15 CHAR 15   0   IS-M: Externally Assigned Contract Number  
98 MM_VTNR MM_VTNR MM_VTNR CHAR 10   0   IS-M: Contract Number for Media-Mix Contract JHTMXK
99 KOFRS ISM_CONKOFRS GRPNO NUMC 3   0   IS-M: Scale Base Formula Provided From the Contract TFRM
100 .INCLUDE       0   0   IS-M/AM: Contract BW Classification  
101 LEVEL_BP JH_BWCOALEVEL_BP JH_BWCOALEVEL_BP CHAR 1   0   IS-M/AM: Contract BW Classification for Contract Holder  
102 LEVEL_BU JH_BWCOALEVEL_BU JH_BWCOALEVEL_BU CHAR 1   0   IS-M/AM: Contract BW Classification for Booking Unit  
103 .INCLUDE       0   0   IS-PAM: Structure Of Totals Fields In COA  
104 SAERBMO SRBMO WERTV8 CURR 15   2   Total sales vol.all acc.assignments qualifying for discount  
105 SAERBMM SRBMM SAEMM QUAN 12   3   IS-M: Total qty all acc.assignments qualifying for discount  
106 SAERBME SRBME SAEME DEC 5   0   IS-M: Total No.All Acc.Assignments Qualifying for Discount  
107 SAEBOMO SBOMO WERTV8 CURR 15   2   IS-M: Total sales vol.all accept.assignments qual.for bonus  
108 SAEBOMM SBOMM SAEMM QUAN 12   3   IS-M: Total quantity of all accpt.assignments qual.for bonus  
109 SAEBOME SBOME SAEME DEC 5   0   IS-M: Total Number All Acc.Assignments Qualifying for Bonus  
110 SAEMRNRMO SMRNRMO WERTV8 CURR 15   2   Total sales vol.all orig.acc.assignments count.towards disc.  
111 SAEMRNRMM SMRNRMM SAEMM QUAN 12   3   Total qty all acc.original assignments count.towards disc.  
112 SAEMRNRME SMRNRME SAEME DEC 5   0   Total No.of All Acc.Original Assignments Count.Towards Disc.  
113 SAEMBNBMO SMBNBMO WERTV8 CURR 15   2   Total sales vol.of all acc.orig.assignments count.twrd bonus  
114 SAEMBNBMM SMBNBMM SAEMM QUAN 12   3   Total qty of all original acc.assignments counting twrd bon.  
115 SAEMBNBME SMBNBME SAEME DEC 5   0   Total No.of All Acc.Original Assignments Count.Twrds Bonus  
116 SAERFRRMO SRFRRMO WERTV8 CURR 15   2   Total sales vol.all acc.assignments qual.for dis.frm othr BU  
117 SAERFRRMM SRFRRMM SAEMM QUAN 12   3   Total qty all acc.assignments qual.for disc.from other BU  
118 SAERFRRME SRFRRME SAEME DEC 5   0   Total No.All Acc.Assignments Qual.for Discount From Other BU  
119 SAEBFRMO SBFRMO WERTV8 CURR 15   2   Total sales vol. all acc.assign. qual.for bonus from othr BU  
120 SAEBFRMM SBFRMM SAEMM QUAN 12   3   Total qty of all accp.assignments qual.for bonus frm othr BU  
121 SAEBFRME SBFRME SAEME DEC 5   0   Total Number of Assignments Qualify.for Bonus From Other BU  
122 SAEFRMO SFRMO WERTV8 CURR 15   2   Total sales vol.of all accepted assignments from other BU  
123 SAEFRMM SFRMM SAEMM QUAN 12   3   IS-M: Total quantity of all accept.assignments from other BU  
124 SAEFRME SFRME SAEME DEC 5   0   IS-M: Total Number of All Accepted Assignments From Other BU  
125 SAEMFRBMO SMFRBMO WERTV8 CURR 15   2   Total sales vol.all acc.assign.count.twrds bonus frm othr BU  
126 SAEMFRBMM SMFRBMM SAEMM QUAN 12   3   Total qty all acc.assignmnts count.twrds bonus from other BU  
127 SAEMFRBME SMFRBME SAEME DEC 5   0   Total No.All Acc.Assignmnts Count.Twrds Bonus From Other BU  
128 SAEVBMO SVBMO WERTV8 CURR 15   2   IS-M: Total sales vol.all acc.assignments from other SA  
129 SAEVBMM SVBMM SAEMM QUAN 12   3   IS-M: Total qty all acc.assignments from other sales area  
130 SAEVBME SVBME SAEME DEC 5   0   IS-M: Total Number of All Accepted Assignments From Other SA  
131 SAEMAMO SMAMO WERTV8 CURR 15   2   IS-M: Total sales volume of all accepted manual assignments  
132 SAEMAMM SMAMM SAEMM QUAN 12   3   IS-M: Total quantity of all manual assignments accepted  
133 SAEMAME SMAME SAEME DEC 5   0   IS-M: Total Number of All Manual Assignments Accepted  
134 SAEMRMO SMRMO WERTV8 CURR 15   2   Total sales vol.from all acc.assignments count.toward disc.  
135 SAEMRMM SMRMM SAEMM QUAN 12   3   Total qty of all acc.assignments counting towards discount  
136 SAEMRME SMRME SAEME DEC 5   0   IS-M: Total No.of All Acc.Assignments Counting Towards Disc.  
137 SAEMBMO SMBMO WERTV8 CURR 15   2   IS-M: Total sales vol.of all acc.assignments count.twd bon.  
138 SAEMBMM SMBMM SAEMM QUAN 12   3   IS-M: Total qty of all accept.assignments counting twrd bon.  
139 SAEMBME SMBME SAEME DEC 5   0   IS-M: Total No.All Accept.Assignments Which Count Twrds Bon.  
140 SFKRBMO SRBMO_FK WERTV8 CURR 15   2   Total sales vol.all billed assignments qualifying for disc.  
141 SFKRBMM SRBMM_FK SAEMM QUAN 12   3   Total qty all billed assignments qualifying for discount  
142 SFKRBME SRBME_FK SAEME DEC 5   0   IS-M: Total No.All Bill.Assignments Qualifying for Discount  
143 SFKBOMO SBOMO_FK WERTV8 CURR 15   2   Total sales vol.all billed assignments qualifying for bonus  
144 SFKBOMM SBOMM_FK SAEMM QUAN 12   3   Total qty of all billed assignments qualifying for bonus  
145 SFKBOME SBOME_FK SAEME DEC 5   0   Total Number of All Billed Assignments Qualifying for Bonus  
146 SFKMRNRMO SMRNRMO_FK WERTV8 CURR 15   2   Total sales vol.all billed orig.assignments count.twrd disc.  
147 SFKMRNRMM SMRNRMM_FK SAEMM QUAN 12   3   Total qty all billed original assignments count.twrd disc.  
148 SFKMRNRME SMRNRME_FK SAEME DEC 5   0   Total No.of All Billed Original Assignments Count.Twrd Disc.  
149 SFKMBNBMO SMBNBMO_FK WERTV8 CURR 15   2   Total sales vol.all bill.original assignments count.twd bon.  
150 SFKMBNBMM SMBNBMM_FK SAEMM QUAN 12   3   Total qty of all billed original assignments count.twrd bon.  
151 SFKMBNBME SMBNBME_FK SAEME DEC 5   0   Total No.of All Billed Original Assignments Count.Twrd Bonus  
152 SFKRFRRMO SRFRRMO_FK WERTV8 CURR 15   2   Total sales vol.all bill.assignm.qual.for disc from other BU  
153 SFKRFRRMM SRFRRMM_FK SAEMM QUAN 12   3   Total qty all billed assignments qual.for disc.from other BU  
154 SFKRFRRME SRFRRME_FK SAEME DEC 5   0   Total No.All Billed Assignments Qual.for Disc.From Other BU  
155 SFKBFRMO SBFRMO_FK WERTV8 CURR 15   2   Total sales vol.all bill.assign.qual.for bonus from other BU  
156 SFKBFRMM SBFRMM_FK SAEMM QUAN 12   3   Total qty all billed assignments qual.for bonus frm other BU  
157 SFKBFRME SBFRME_FK SAEME DEC 5   0   Total No.All Billed Assignments Qual.for Bonus From Other BU  
158 SFKFRMO SFRMO_FK WERTV8 CURR 15   2   Total sales volume of all billed assignments from other BU  
159 SFKFRMM SFRMM_FK SAEMM QUAN 12   3   Total quantity of all billed assignments from other BU  
160 SFKFRME SFRME_FK SAEME DEC 5   0   Total Number of All Billed Assignments From Other BU  
161 SFKMFRBMO SMFRBMO_FK WERTV8 CURR 15   2   Total sales vol.all bill.assign.count.twrd bon.from othr BU  
162 SFKMFRBMM SMFRBMM_FK SAEMM QUAN 12   3   Total qty all billed assignments count.twrd bonus frm oth.BU  
163 SFKMFRBME SMFRBME_FK SAEME DEC 5   0   Total No.of All Bill.Assignments From Othr BU Count.Twrd Bon  
164 SFKVBMO SVBMO_FK WERTV8 CURR 15   2   Total sales vol. from all billed assignments from other SAs  
165 SFKVBMM SVBMM_FK SAEMM QUAN 12   3   Total quantity all billed assignments from other SA  
166 SFKVBME SVBME_FK SAEME DEC 5   0   Total Number of All Billed Assignments From Other SA  
167 SFKMAMO SMAMO_FK WERTV8 CURR 15   2   Total sales volume of all billed manual assignments  
168 SFKMAMM SMAMM_FK SAEMM QUAN 12   3   IS-M: Total quantity of all billed manual assignments  
169 SFKMAME SMAME_FK SAEME DEC 5   0   IS-M: Total Number of All Billed Manual Assignments  
170 SFKMRMO SMRMO_FK WERTV8 CURR 15   2   Total sales vol.all billed assignments count.toward discount  
171 SFKMRMM SMRMM_FK SAEMM QUAN 12   3   Total quantity of all billed assignments counting twrd disc.  
172 SFKMRME SMRME_FK SAEME DEC 5   0   Total Number of All Billed Assignments Counting Toward Disc.  
173 SFKMBMO SMBMO_FK WERTV8 CURR 15   2   Total sales vol.all billed assignments counting twrd bonus  
174 SFKMBMM SMBMM_FK SAEMM QUAN 12   3   Total quantity of all billed assignments counting twrd bon.  
175 SFKMBME SMBME_FK SAEME DEC 5   0   Total Number of All Billed Assignments That Count Twrd Bonus  
176 .INCLUDE       0   0   Created-By Data (Medium Scope)  
177 ERFUSER ERFUSER USNAM CHAR 12   0   Created By  
178 ERFDATE ERFDATE DATUM DATS 8   0   Created On  
179 ERFTIME ERFTIME UZEIT TIMS 6   0   Time Created  
180 AENUSER AENUSER USNAM CHAR 12   0   Last Changed By  
181 AENDATE AENDATE DATUM DATS 8   0   Date of Last Change  
182 AENTIME AENTIME UZEIT TIMS 6   0   Time of Last Change  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 JHTVKO ABINHNR JGTGPNR GPNR REF 1 CN
2 JHTVKO ABS_TYP1 TJH11 ABS_TYP REF 1 CN
3 JHTVKO ABS_ZUST USR02 BNAME KEY 1 CN
4 JHTVKO AB_WEINH TCURC WAERS REF 1 CN
5 JHTVKO B_AUSR TJJV14 B_AUSR REF 1 CN
6 JHTVKO E_AUSR TJJV15 E_AUSR REF 1 CN
7 JHTVKO FMP_KMEIN T006 MSEHI REF C CN
8 JHTVKO FVTNR JHTVKO VTNR REF C C
9 JHTVKO KOFRS TFRM GRPNO REF C CN
10 JHTVKO MANDT T000 MANDT KEY 1 CN
11 JHTVKO MEINH T006 MSEHI REF 1 CN
12 JHTVKO MM_VTNR JHTMXK VTNR REF C CN
13 JHTVKO SPART TVTA SPART REF 1 CN
14 JHTVKO VKBUR TVKBZ VKBUR REF 1 CN
15 JHTVKO VKGRP TVBVK VKGRP REF 1 CN
16 JHTVKO VKORG TVKO VKORG REF 1 CN
17 JHTVKO VTWEG TVKOV VTWEG REF 1 CN
18 JHTVKO VVTNR JHTVKO VTNR    
History
Last changed by/on SAP  20110901 
SAP Release Created in