ERP 6.0: Top 10 requests

	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	/ISDFPS/CHVW_E	34	External Batch Where-Used List
7	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	BSEG	345	Accounting Document Segment
10	FMARCPAR	4	Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

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

	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

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

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