	Table	Columns	Description
1	TJKWE	15	IS-M/SD: WBZ, Order Data for Inbound Processing
2	RSADMINC	96	Customizing Table General BW
3	BBP_PD_XML	8	Table for Persistent Class CL_XML_PPF_BBP
4	/OTX/RM_TELIB	24	Enterprise Library Server Settings
5	UMV_TR125	9	Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	INV1	265	A/R Invoice - Rows
6	OJDT	100	Journal Entry
7	OPCH	386	A/P Invoice
8	OVTG	52	Tax Definition
9	OPOR	386	Purchase Order
10	JDT1	124	Journal Entry - Rows

	Table	Columns	Description
1	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OVPM	154	Outgoing Payments
5	OIVL	77	Whse Journal
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

177 COLUMNS | 2 INDEXES | ERP 6.0 | JHTVKO TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Industry Specific :: SAP Media :: Advertising Management
1	ERP EHP7	6.0	JHTVKO	177	2	IS-M/AM: Contract	Advertising Management

SQL: selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, VTNR, VKORG, VTWEG, SPART, VKBUR, VKGRP, XORG_ERG, ABINHNR, IHREZ, KDMI, XQUASI, XGE_GESCH, XKUBO, XTO_BEST, XTO_WARN, XWARN_GEN, XTO_HINW, XHINW_GEN, XBESTK, B_DATUM, XNEUSTAT, E_DATUM, V_NUMMER, V_DATUM, XENDK, H_DATUM, XABRSPERR, ABRECHK, XABR, R_DATUM, ABRGNR, EABR_NACHL, XLOEVM, XLOEKZ, XLFZAEN, LFZBEG, LFZEND, B_AUSR, E_AUSR, XABE, FVTNR, VVTNR, XNOBEL, XZWABR, XBEARB, ABS_NACHB, XKONZERN, XINSKUM, ABS_TYP1, XBEST_PR, XPOSAEN, XZIELAEN, PR_BASIS, MENGE1, EINH1, AB_ZIEL1, AB_WEINH, RKSCHL, BKSCHL, MENGE2, EINH2, MEINH, ORIG_MENG1, ORIG_MENG2, ORIG_ZIEL1, XAB_PREIS, XAB_PRLST, AB_PREIS, AB_KPREIS, AB_VPREIS, FMP_KPEIN, FMP_KMEIN, RKNUMV, RABATT, VRABATT, XRABAEN, XRAB_CH, XRABA, XERFUELLT, XRABAN, XRABAZW, XRABSPERR, XBRUTTO, BKNUMV, XVBONUS, AKTBONUS, VBONUS, XGUTSCHR, ZTERM, FREITEXT, L_FKT_DAT, L_AE_DAT, ABS_ZUST, FRD_VTNR, MM_VTNR, KOFRS, LEVEL_BP, LEVEL_BU, SAERBMO, SAERBMM, SAERBME, SAEBOMO, SAEBOMM, SAEBOME, SAEMRNRMO, SAEMRNRMM, SAEMRNRME, SAEMBNBMO, SAEMBNBMM, SAEMBNBME, SAERFRRMO, SAERFRRMM, SAERFRRME, SAEBFRMO, SAEBFRMM, SAEBFRME, SAEFRMO, SAEFRMM, SAEFRME, SAEMFRBMO, SAEMFRBMM, SAEMFRBME, SAEVBMO, SAEVBMM, SAEVBME, SAEMAMO, SAEMAMM, SAEMAME, SAEMRMO, SAEMRMM, SAEMRME, SAEMBMO, SAEMBMM, SAEMBME, SFKRBMO, SFKRBMM, SFKRBME, SFKBOMO, SFKBOMM, SFKBOME, SFKMRNRMO, SFKMRNRMM, SFKMRNRME, SFKMBNBMO, SFKMBNBMM, SFKMBNBME, SFKRFRRMO, SFKRFRRMM, SFKRFRRME, SFKBFRMO, SFKBFRMM, SFKBFRME, SFKFRMO, SFKFRMM, SFKFRME, SFKMFRBMO, SFKMFRBMM, SFKMFRBME, SFKVBMO, SFKVBMM, SFKVBME, SFKMAMO, SFKMAMM, SFKMAME, SFKMRMO, SFKMRMM, SFKMRME, SFKMBMO, SFKMBMM, SFKMBME, ERFUSER, ERFDATE, ERFTIME, AENUSER, AENDATE, AENTIME FROM JHTVKO

TOP ERP 6.0 | JHTVKO COLUMNS

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

TOP ERP 6.0 | JHTVKO INDEXES

Name	Primary	Unique	Type	Columns
JHTVKO~0	Yes	Yes	CLUSTERED	VTNR, MANDT
JHTVKO~MMX	No	No	NONCLUSTERED	MM_VTNR

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

177 COLUMNS | 2 INDEXES | ERP 6.0 | JHTVKO TABLE

TOP ERP 6.0 | JHTVKO COLUMNS

TOP ERP 6.0 | JHTVKO INDEXES

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

177 COLUMNS | 2 INDEXES | ERP 6.0 | JHTVKO TABLE

TOPERP 6.0 | JHTVKO COLUMNS

TOPERP 6.0 | JHTVKO INDEXES

TOP ERP 6.0 | JHTVKO COLUMNS

TOP ERP 6.0 | JHTVKO INDEXES