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	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

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	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

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	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

	Product	Version	Table	Columns	Indexes	Description	Module
Industry Specific :: SAP Media :: Advertising Management
1	ERP EHP7	6.0	JHTVAABK	114	1	IS-M/AM: Contract Settlement Header Data	Advertising Management

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	JHTVKO	ABS_VTNR	Allow NULL?
3	ABRGNR	IS-M/AM: Contract Settlement Number	nvarchar	4	0	NUMC	(N'0000')	No		ABRGNR	Allow NULL?
4	VKORG	Sales Organization	nvarchar	4	0	CHAR	(N' ')	Yes	TVKO	VKORG	Allow NULL?
5	VTWEG	Distribution Channel	nvarchar	2	0	CHAR	(N' ')	Yes	TVKOV	VTWEG	Allow NULL?
6	SPART	Division	nvarchar	2	0	CHAR	(N' ')	Yes	TVTA	SPART	Allow NULL?
7	VKBUR	Sales Office	nvarchar	4	0	CHAR	(N' ')	Yes	TVKBZ	VKBUR	Allow NULL?
8	VKGRP	Sales Group	nvarchar	3	0	CHAR	(N' ')	Yes	TVBVK	VKGRP	Allow NULL?
9	ABRECHK	IS-M: Settlement Type	char	1	0	CHAR	(N' ')	Yes	TJH15	ABRECHK	Allow NULL?
10	JHABRDAT	IS-M: Contract Settlement Date	nvarchar	8	0	DATS	(N'00000000')	Yes		JHABRDAT	Allow NULL?
11	R_DATUM	IS-M: Date of Last Interim/Final Settlement	nvarchar	8	0	DATS	(N'00000000')	Yes		R_DATUM	Allow NULL?
12	ABS_TYP1	IS-M/AM: Contract Category	char	1	0	CHAR	(N' ')	Yes	TJH11	ABS_TYP	Allow NULL?
13	XBEST_PR	IS-M: Apply Best Conditions to Number / Quantity	char	1	0	CHAR	(N' ')	Yes		XBEST_PR	Allow NULL?
14	MENGE1	IS-M/AM: Agreed Quantity to be Sold	decimal	12	3	QUAN	((0))	Yes		ABS_MENGE1
15	EINH1	IS-M: Contract Units of Measurement	nvarchar	3	0	UNIT	(N' ')	Yes	*	AB_MEINH	Allow NULL?
16	AB_ZIEL1	IS-M/AM: Target Quantity for Monetary Contract	decimal	15	2	CURR	((0))	Yes		AB_ZIEL1
17	AB_WEINH	IS-M: Currency Key for Contract	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	AB_WEINH	Allow NULL?
18	MENGE2	IS-M/AM: Agreed Quantity to be Sold	decimal	12	3	QUAN	((0))	Yes		ABS_MENGE2
19	EINH2	IS-M: Contract Units of Measurement	nvarchar	3	0	UNIT	(N' ')	Yes	*	AB_MEINH	Allow NULL?
20	PR_BASIS	IS-M: Basis for scale access (number/quantity)	char	1	0	CHAR	(N' ')	Yes		PR_BASIS	Allow NULL?
21	AB_PREIS	IS-M: Current Valid Price from Contract	decimal	15	2	CURR	((0))	Yes		AB_PREIS
22	AB_KPREIS	IS-M: Price from Scale	decimal	15	2	CURR	((0))	Yes		AB_KPREIS
23	AB_VPREIS	IS-M: Agreed Price from Contract	decimal	15	2	CURR	((0))	Yes		AB_VPREIS
24	RKNUMV	IS-M: Discount from Scale	decimal	5	2	DEC	((0))	Yes		AB_RKNUMV
25	RABATT	IS-M: Current Valid Contract Discount Rate	decimal	5	2	DEC	((0))	Yes		AB_RABATT
26	VRABATT	IS-M: Agreed Discount	decimal	5	2	DEC	((0))	Yes		VRABATT
27	BKNUMV	IS-M/AM: Bonus from Scale	decimal	5	2	DEC	((0))	Yes		AB_BKNUMV
28	AKTBONUS	IS-M/AM: Current Valid Contract Bonus	decimal	5	2	DEC	((0))	Yes		AKTBONUS
29	VBONUS	IS-M: Agreed Bonus	decimal	5	2	DEC	((0))	Yes		VBONUS
30	FREITEXT	IS-M: Freely Definable Text	nvarchar	50	0	CHAR	(N' ')	Yes		ABS_TEXT	Allow NULL?
31	MNGABRM	IS-M: Quantity for settlement	decimal	12	3	QUAN	((0))	Yes		MNGABRM
32	MEINHABRM	IS-M: Contract Units of Measurement	nvarchar	3	0	UNIT	(N' ')	Yes	*	AB_MEINH	Allow NULL?
33	UMSABRM	IS-M: Sales Volume for Contract Settlement	decimal	15	2	CURR	((0))	Yes		UMSABRM
34	WEINHABRM	IS-M: Currency Key for Contract	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	AB_WEINH	Allow NULL?
35	FAKSP	Block	nvarchar	2	0	CHAR	(N' ')	Yes	TVFS	FAKSP	Allow NULL?
36	DATEAAFS	IS-M/AM: Billing Block Date for Contract Settlement	nvarchar	8	0	DATS	(N'00000000')	Yes		DATEAAFS	Allow NULL?
37	SAERBMO	Total sales vol.all acc.assignments qualifying for discount	decimal	15	2	CURR	((0))	Yes		SRBMO
38	SAERBMM	IS-M: Total qty all acc.assignments qualifying for discount	decimal	12	3	QUAN	((0))	Yes		SRBMM
39	SAERBME	IS-M: Total No.All Acc.Assignments Qualifying for Discount	decimal	5	0	DEC	((0))	Yes		SRBME
40	SAEBOMO	IS-M: Total sales vol.all accept.assignments qual.for bonus	decimal	15	2	CURR	((0))	Yes		SBOMO
41	SAEBOMM	IS-M: Total quantity of all accpt.assignments qual.for bonus	decimal	12	3	QUAN	((0))	Yes		SBOMM
42	SAEBOME	IS-M: Total Number All Acc.Assignments Qualifying for Bonus	decimal	5	0	DEC	((0))	Yes		SBOME
43	SAEMRNRMO	Total sales vol.all orig.acc.assignments count.towards disc.	decimal	15	2	CURR	((0))	Yes		SMRNRMO
44	SAEMRNRMM	Total qty all acc.original assignments count.towards disc.	decimal	12	3	QUAN	((0))	Yes		SMRNRMM
45	SAEMRNRME	Total No.of All Acc.Original Assignments Count.Towards Disc.	decimal	5	0	DEC	((0))	Yes		SMRNRME
46	SAEMBNBMO	Total sales vol.of all acc.orig.assignments count.twrd bonus	decimal	15	2	CURR	((0))	Yes		SMBNBMO
47	SAEMBNBMM	Total qty of all original acc.assignments counting twrd bon.	decimal	12	3	QUAN	((0))	Yes		SMBNBMM
48	SAEMBNBME	Total No.of All Acc.Original Assignments Count.Twrds Bonus	decimal	5	0	DEC	((0))	Yes		SMBNBME
49	SAERFRRMO	Total sales vol.all acc.assignments qual.for dis.frm othr BU	decimal	15	2	CURR	((0))	Yes		SRFRRMO
50	SAERFRRMM	Total qty all acc.assignments qual.for disc.from other BU	decimal	12	3	QUAN	((0))	Yes		SRFRRMM
51	SAERFRRME	Total No.All Acc.Assignments Qual.for Discount From Other BU	decimal	5	0	DEC	((0))	Yes		SRFRRME
52	SAEBFRMO	Total sales vol. all acc.assign. qual.for bonus from othr BU	decimal	15	2	CURR	((0))	Yes		SBFRMO
53	SAEBFRMM	Total qty of all accp.assignments qual.for bonus frm othr BU	decimal	12	3	QUAN	((0))	Yes		SBFRMM
54	SAEBFRME	Total Number of Assignments Qualify.for Bonus From Other BU	decimal	5	0	DEC	((0))	Yes		SBFRME
55	SAEFRMO	Total sales vol.of all accepted assignments from other BU	decimal	15	2	CURR	((0))	Yes		SFRMO
56	SAEFRMM	IS-M: Total quantity of all accept.assignments from other BU	decimal	12	3	QUAN	((0))	Yes		SFRMM
57	SAEFRME	IS-M: Total Number of All Accepted Assignments From Other BU	decimal	5	0	DEC	((0))	Yes		SFRME
58	SAEMFRBMO	Total sales vol.all acc.assign.count.twrds bonus frm othr BU	decimal	15	2	CURR	((0))	Yes		SMFRBMO
59	SAEMFRBMM	Total qty all acc.assignmnts count.twrds bonus from other BU	decimal	12	3	QUAN	((0))	Yes		SMFRBMM
60	SAEMFRBME	Total No.All Acc.Assignmnts Count.Twrds Bonus From Other BU	decimal	5	0	DEC	((0))	Yes		SMFRBME
61	SAEVBMO	IS-M: Total sales vol.all acc.assignments from other SA	decimal	15	2	CURR	((0))	Yes		SVBMO
62	SAEVBMM	IS-M: Total qty all acc.assignments from other sales area	decimal	12	3	QUAN	((0))	Yes		SVBMM
63	SAEVBME	IS-M: Total Number of All Accepted Assignments From Other SA	decimal	5	0	DEC	((0))	Yes		SVBME
64	SAEMAMO	IS-M: Total sales volume of all accepted manual assignments	decimal	15	2	CURR	((0))	Yes		SMAMO
65	SAEMAMM	IS-M: Total quantity of all manual assignments accepted	decimal	12	3	QUAN	((0))	Yes		SMAMM
66	SAEMAME	IS-M: Total Number of All Manual Assignments Accepted	decimal	5	0	DEC	((0))	Yes		SMAME
67	SAEMRMO	Total sales vol.from all acc.assignments count.toward disc.	decimal	15	2	CURR	((0))	Yes		SMRMO
68	SAEMRMM	Total qty of all acc.assignments counting towards discount	decimal	12	3	QUAN	((0))	Yes		SMRMM
69	SAEMRME	IS-M: Total No.of All Acc.Assignments Counting Towards Disc.	decimal	5	0	DEC	((0))	Yes		SMRME
70	SAEMBMO	IS-M: Total sales vol.of all acc.assignments count.twd bon.	decimal	15	2	CURR	((0))	Yes		SMBMO
71	SAEMBMM	IS-M: Total qty of all accept.assignments counting twrd bon.	decimal	12	3	QUAN	((0))	Yes		SMBMM
72	SAEMBME	IS-M: Total No.All Accept.Assignments Which Count Twrds Bon.	decimal	5	0	DEC	((0))	Yes		SMBME
73	SFKRBMO	Total sales vol.all billed assignments qualifying for disc.	decimal	15	2	CURR	((0))	Yes		SRBMO_FK
74	SFKRBMM	Total qty all billed assignments qualifying for discount	decimal	12	3	QUAN	((0))	Yes		SRBMM_FK
75	SFKRBME	IS-M: Total No.All Bill.Assignments Qualifying for Discount	decimal	5	0	DEC	((0))	Yes		SRBME_FK
76	SFKBOMO	Total sales vol.all billed assignments qualifying for bonus	decimal	15	2	CURR	((0))	Yes		SBOMO_FK
77	SFKBOMM	Total qty of all billed assignments qualifying for bonus	decimal	12	3	QUAN	((0))	Yes		SBOMM_FK
78	SFKBOME	Total Number of All Billed Assignments Qualifying for Bonus	decimal	5	0	DEC	((0))	Yes		SBOME_FK
79	SFKMRNRMO	Total sales vol.all billed orig.assignments count.twrd disc.	decimal	15	2	CURR	((0))	Yes		SMRNRMO_FK
80	SFKMRNRMM	Total qty all billed original assignments count.twrd disc.	decimal	12	3	QUAN	((0))	Yes		SMRNRMM_FK
81	SFKMRNRME	Total No.of All Billed Original Assignments Count.Twrd Disc.	decimal	5	0	DEC	((0))	Yes		SMRNRME_FK
82	SFKMBNBMO	Total sales vol.all bill.original assignments count.twd bon.	decimal	15	2	CURR	((0))	Yes		SMBNBMO_FK
83	SFKMBNBMM	Total qty of all billed original assignments count.twrd bon.	decimal	12	3	QUAN	((0))	Yes		SMBNBMM_FK
84	SFKMBNBME	Total No.of All Billed Original Assignments Count.Twrd Bonus	decimal	5	0	DEC	((0))	Yes		SMBNBME_FK
85	SFKRFRRMO	Total sales vol.all bill.assignm.qual.for disc from other BU	decimal	15	2	CURR	((0))	Yes		SRFRRMO_FK
86	SFKRFRRMM	Total qty all billed assignments qual.for disc.from other BU	decimal	12	3	QUAN	((0))	Yes		SRFRRMM_FK
87	SFKRFRRME	Total No.All Billed Assignments Qual.for Disc.From Other BU	decimal	5	0	DEC	((0))	Yes		SRFRRME_FK
88	SFKBFRMO	Total sales vol.all bill.assign.qual.for bonus from other BU	decimal	15	2	CURR	((0))	Yes		SBFRMO_FK
89	SFKBFRMM	Total qty all billed assignments qual.for bonus frm other BU	decimal	12	3	QUAN	((0))	Yes		SBFRMM_FK
90	SFKBFRME	Total No.All Billed Assignments Qual.for Bonus From Other BU	decimal	5	0	DEC	((0))	Yes		SBFRME_FK
91	SFKFRMO	Total sales volume of all billed assignments from other BU	decimal	15	2	CURR	((0))	Yes		SFRMO_FK
92	SFKFRMM	Total quantity of all billed assignments from other BU	decimal	12	3	QUAN	((0))	Yes		SFRMM_FK
93	SFKFRME	Total Number of All Billed Assignments From Other BU	decimal	5	0	DEC	((0))	Yes		SFRME_FK
94	SFKMFRBMO	Total sales vol.all bill.assign.count.twrd bon.from othr BU	decimal	15	2	CURR	((0))	Yes		SMFRBMO_FK
95	SFKMFRBMM	Total qty all billed assignments count.twrd bonus frm oth.BU	decimal	12	3	QUAN	((0))	Yes		SMFRBMM_FK
96	SFKMFRBME	Total No.of All Bill.Assignments From Othr BU Count.Twrd Bon	decimal	5	0	DEC	((0))	Yes		SMFRBME_FK
97	SFKVBMO	Total sales vol. from all billed assignments from other SAs	decimal	15	2	CURR	((0))	Yes		SVBMO_FK
98	SFKVBMM	Total quantity all billed assignments from other SA	decimal	12	3	QUAN	((0))	Yes		SVBMM_FK
99	SFKVBME	Total Number of All Billed Assignments From Other SA	decimal	5	0	DEC	((0))	Yes		SVBME_FK
100	SFKMAMO	Total sales volume of all billed manual assignments	decimal	15	2	CURR	((0))	Yes		SMAMO_FK
101	SFKMAMM	IS-M: Total quantity of all billed manual assignments	decimal	12	3	QUAN	((0))	Yes		SMAMM_FK
102	SFKMAME	IS-M: Total Number of All Billed Manual Assignments	decimal	5	0	DEC	((0))	Yes		SMAME_FK
103	SFKMRMO	Total sales vol.all billed assignments count.toward discount	decimal	15	2	CURR	((0))	Yes		SMRMO_FK
104	SFKMRMM	Total quantity of all billed assignments counting twrd disc.	decimal	12	3	QUAN	((0))	Yes		SMRMM_FK
105	SFKMRME	Total Number of All Billed Assignments Counting Toward Disc.	decimal	5	0	DEC	((0))	Yes		SMRME_FK
106	SFKMBMO	Total sales vol.all billed assignments counting twrd bonus	decimal	15	2	CURR	((0))	Yes		SMBMO_FK
107	SFKMBMM	Total quantity of all billed assignments counting twrd bon.	decimal	12	3	QUAN	((0))	Yes		SMBMM_FK
108	SFKMBME	Total Number of All Billed Assignments That Count Twrd Bonus	decimal	5	0	DEC	((0))	Yes		SMBME_FK
109	ERFUSER	Created By	nvarchar	12	0	CHAR	(N' ')	Yes		ERFUSER	Allow NULL?
110	ERFDATE	Created On	nvarchar	8	0	DATS	(N'00000000')	Yes		ERFDATE	Allow NULL?
111	ERFTIME	Time Created	nvarchar	6	0	TIMS	(N'000000')	Yes		ERFTIME	Allow NULL?
112	AENUSER	Last Changed By	nvarchar	12	0	CHAR	(N' ')	Yes		AENUSER	Allow NULL?
113	AENDATE	Date of Last Change	nvarchar	8	0	DATS	(N'00000000')	Yes		AENDATE	Allow NULL?
114	AENTIME	Time of Last Change	nvarchar	6	0	TIMS	(N'000000')	Yes		AENTIME	Allow NULL?

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

114 COLUMNS | 1 INDEXES | ERP 6.0 | JHTVAABK TABLE

TOP ERP 6.0 | JHTVAABK COLUMNS

TOP ERP 6.0 | JHTVAABK 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

114 COLUMNS | 1 INDEXES | ERP 6.0 | JHTVAABK TABLE

TOPERP 6.0 | JHTVAABK COLUMNS

TOPERP 6.0 | JHTVAABK INDEXES

TOP ERP 6.0 | JHTVAABK COLUMNS

TOP ERP 6.0 | JHTVAABK INDEXES