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	BSEG	345	Accounting Document Segment
9	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
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	ORCT	154	Incoming Payment
2	OITM	249	Items
3	OINV	268	A/R Invoice
4	OIVL	77	Whse Journal
5	OINM	101	Whse Journal
6	OVPM	154	Outgoing Payments
7	OPCH	268	A/P Invoice
8	JDT1	110	Journal Entry - Rows
9	OOCR	9	Loading Factors
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	JHTFP	149	2	IS-M/AM: Billing/Settlement Documents - Item	Advertising Management

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	VBELN	IS-M/AM: Billing Document	nvarchar	10	0	Allow NULL?
3	POSNR	IS-M/AM: Item (number) in settlement document	nvarchar	6	0	Allow NULL?
4	VTWEG	Distribution Channel	nvarchar	2	0	Allow NULL?
5	SPART	Division	nvarchar	2	0	Allow NULL?
6	KDGRP	Customer group	nvarchar	2	0	Allow NULL?
7	KONDA	Price group (customer)	nvarchar	2	0	Allow NULL?
8	KAPPL	Application	nvarchar	2	0	Allow NULL?
9	KALSM	Sales and Distribution: Pricing Procedure in Pricing	nvarchar	6	0	Allow NULL?
10	ARKTX	IS-M: Short Text for Document Item (Billing Doc.,Settlement)	nvarchar	40	0	Allow NULL?
11	AUBEL	IS-M/AM: Sales Document Number	nvarchar	10	0	Allow NULL?
12	AUPOS	IS-M: Order Item Number	nvarchar	3	0	Allow NULL?
13	AUGRP	IS-M/AM: Billing Dataset	nvarchar	3	0	Allow NULL?
14	AUETE	IS-M: Schedule Line	nvarchar	6	0	Allow NULL?
15	AVMAUART	IS-M: Sales Document Type	nvarchar	4	0	Allow NULL?
16	AUREF	Sales document was created from reference	char	1	0	Allow NULL?
17	BEINH	IS-M/AM: Booking Unit	nvarchar	10	0	Allow NULL?
18	BEINH_BAS	IS-M: Basic Booking Unit	nvarchar	10	0	Allow NULL?
19	DRERZ	IS-M: Publication	nvarchar	8	0	Allow NULL?
20	PVA	Edition	nvarchar	8	0	Allow NULL?
21	IHKOMP	IS-M: Content component for pricing call	nvarchar	8	0	Allow NULL?
22	INHK_KFM	IS-M: Business Content Component	nvarchar	8	0	Allow NULL?
23	INHK_TECH2	IS-M: Special Publication Content Component	nvarchar	8	0	Allow NULL?
24	AZAFOV	IS-M/AM: Fixed Format Proposal /Ad Dimensions	nvarchar	4	0	Allow NULL?
25	AZAFO	IS-M: Shape Ad Type	nvarchar	4	0	Allow NULL?
26	AZAFA	IS-M: Color Scheme Ad Type	nvarchar	4	0	Allow NULL?
27	AZAGST	IS-M: Design Ad Type	nvarchar	4	0	Allow NULL?
28	TERMINSPEZ	IS-M/AM: Specify Dates for Date Combinations	nvarchar	6	0	Allow NULL?
29	VAVTYP	Issue Variant Type	nvarchar	2	0	Allow NULL?
30	CHIFFRE	IS-M: Box Number Indicator	char	1	0	Allow NULL?
31	ABSRB	IS-M: Current Valid Contract Discount Rate	decimal	5	2
32	ABSBO	IS-M/AM: Current Valid Contract Bonus	decimal	5	2
33	ABSFMPR	IS-M: Current Valid Price from Contract	decimal	15	2
34	GO_PREIS	IS-M: Basic/Local Price	char	1	0	Allow NULL?
35	INSERENT	IS-M: Advertiser	nvarchar	10	0	Allow NULL?
36	STICHW	IS-M: Keyword	nvarchar	40	0	Allow NULL?
37	DIENSTL	IS-M: Service material number	nvarchar	18	0	Allow NULL?
38	DITYP	IS-M: Service Type	nvarchar	4	0	Allow NULL?
39	MATNR	Material Number	nvarchar	18	0	Allow NULL?
40	EAN11	International Article Number (EAN/UPC)	nvarchar	18	0	Allow NULL?
41	FBUDA	Date on which services rendered	nvarchar	8	0	Allow NULL?
42	FSART	IS-M/AM: Billing Method	char	1	0	Allow NULL?
43	KTGRM	Account assignment group for this material	nvarchar	2	0	Allow NULL?
44	KTGRB	IS-M: Booking Unit Account Assignment Group	nvarchar	2	0	Allow NULL?
45	PRSFD	Carry out pricing	char	1	0	Allow NULL?
46	KURSK	Exchange Rate for Price Determination	decimal	9	5
47	PRSDT	Date for pricing and exchange rate	nvarchar	8	0	Allow NULL?
48	SHKZG	IS-M: Debit/Credit indicator	char	1	0	Allow NULL?
49	SMENG	Scale quantity in base unit of measure	decimal	13	3
50	FKIMG	Actual Invoiced Quantity	decimal	13	3
51	MEINS	Base Unit of Measure	nvarchar	3	0	Allow NULL?
52	BRGEW	Gross Weight	decimal	13	3
53	NTGEW	Net Weight	decimal	13	3
54	GEWEI	Weight Unit	nvarchar	3	0	Allow NULL?
55	VGBEL	IS-M: Document Number of Template Document	nvarchar	10	0	Allow NULL?
56	VGPOS	IS-M: Item Number of the Template Business Item	nvarchar	6	0	Allow NULL?
57	VGETE	IS-M: Group/Settlement Number of Template Document	nvarchar	3	0	Allow NULL?
58	VGTYP	IS-M: Preceding Sales Document Category	char	1	0	Allow NULL?
59	VGOBJ	IS-M: Preceding object type	nvarchar	2	0	Allow NULL?
60	VGFKTYP	IS-M: Billing Category for Preceding Billing Document	char	1	0	Allow NULL?
61	VBELV	IS-M: Originating sales document	nvarchar	10	0	Allow NULL?
62	POSNV	IS-M: Originating item	nvarchar	6	0	Allow NULL?
63	VKBUR	Sales Office	nvarchar	4	0	Allow NULL?
64	VKGRP	Sales Group	nvarchar	3	0	Allow NULL?
65	VRKME	Sales unit	nvarchar	3	0	Allow NULL?
66	WERKS	Plant	nvarchar	4	0	Allow NULL?
67	POSAR	IS-M: Order-Publishing-Media - Item Type	nvarchar	2	0	Allow NULL?
68	PRODH	IS-M/AM: Product Hierarchy	nvarchar	18	0	Allow NULL?
69	PSTYV	IS-M: Item Category for Sales Document	nvarchar	4	0	Allow NULL?
70	TAXM1	Tax classification material	char	1	0	Allow NULL?
71	TAXM2	Tax classification 2 for material	char	1	0	Allow NULL?
72	TAXM3	Tax classification 3 for material	char	1	0	Allow NULL?
73	TAXM4	Tax Classification 4 Material	char	1	0	Allow NULL?
74	TAXM5	Tax classification 5 for material	char	1	0	Allow NULL?
75	TAXM6	Tax classification 6 for material	char	1	0	Allow NULL?
76	TAXM7	Tax classification 7 for material	char	1	0	Allow NULL?
77	TAXM8	Tax Classification 8 Material	char	1	0	Allow NULL?
78	TAXM9	Tax Classification 9 Material	char	1	0	Allow NULL?
79	GSBER	Business Area	nvarchar	4	0	Allow NULL?
80	AUFNR	Order Number	nvarchar	12	0	Allow NULL?
81	KOSTL	Cost Center	nvarchar	10	0	Allow NULL?
82	PRCTR	Profit Center	nvarchar	10	0	Allow NULL?
83	RK_AUFNR	Order Number of RK Order for Account Assignment	nvarchar	8	0	Allow NULL?
84	RK_POSNR	Item Number of RK Order for Account Assignment	nvarchar	2	0	Allow NULL?
85	KOSTL_R2	Cost center in R/2	nvarchar	8	0	Allow NULL?
86	STGRB	IS-M: BU Grouping for Statistics	nvarchar	4	0	Allow NULL?
87	STAFO	IS-M: Update group for statistics update	nvarchar	6	0	Allow NULL?
88	SKTOF	Cash discount indicator	char	1	0	Allow NULL?
89	RRREL	IS-M/AM: Revenue Recognition Category	char	1	0	Allow NULL?
90	RRSTA		char	1	0	Allow NULL?
91	CAMPAIGN	IS-M: Marketing Campaign	varbinary	16	0
92	PACKAGE_ID	Package	nvarchar	10	0	Allow NULL?
93	PK_REF_AVM_NR	Order Number for Package Reference Order	nvarchar	10	0	Allow NULL?
94	PK_REF_POS_NR	Item Number of Package Item to be Referenced	nvarchar	3	0	Allow NULL?
95	ERFUSER	Created By	nvarchar	12	0	Allow NULL?
96	ERFDATE	Created On	nvarchar	8	0	Allow NULL?
97	ERFTIME	Time Created	nvarchar	6	0	Allow NULL?
98	AENUSER	Last Changed By	nvarchar	12	0	Allow NULL?
99	AENDATE	Date of Last Change	nvarchar	8	0	Allow NULL?
100	AENTIME	Time of Last Change	nvarchar	6	0	Allow NULL?
101	KUNAG	Business Partner: Sold-to Party	nvarchar	10	0	Allow NULL?
102	ELAND	Country of Destination	nvarchar	3	0	Allow NULL?
103	POSPA	Item number in the partner segment	nvarchar	6	0	Allow NULL?
104	PLTYP_AUFT	Price list type of sales order	nvarchar	2	0	Allow NULL?
105	MPROK	Status manual price change	char	1	0	Allow NULL?
106	KOWRR	Statistical values	char	1	0	Allow NULL?
107	BONBA	Rebate basis 1	decimal	13	2
108	KZWI1	Subtotal 1 from pricing procedure for condition	decimal	13	2
109	KZWI2	Subtotal 2 from pricing procedure for condition	decimal	13	2
110	KZWI3	Subtotal 3 from pricing procedure for condition	decimal	13	2
111	KZWI4	Subtotal 4 from pricing procedure for condition	decimal	13	2
112	KZWI5	Subtotal 5 from pricing procedure for condition	decimal	13	2
113	KZWI6	Subtotal 6 from pricing procedure for condition	decimal	13	2
114	WAVWR	Cost in document currency	decimal	13	2
115	SKFBP	Amount eligible for cash discount in document currency	decimal	13	2
116	BRTWP	IS-M: Gross Value in Document Currency (Item)	decimal	15	2
117	NETWP	Net value of the billing item in document currency	decimal	15	2
118	MWSBP	Tax amount in document currency	decimal	13	2
119	CMPRE		decimal	11	0
120	CMPRE_FLT	Item credit price	float	15	16
121	UVPRS	Incomplete with Regard to Pricing	char	1	0	Allow NULL?
122	UVALL	IS-M: Generally incomplete	char	1	0	Allow NULL?
123	XERLV	IS-M: Revenue Distribution Status	char	1	0	Allow NULL?
124	XPEAB	IS-M: Period end accrual performed indicator	char	1	0	Allow NULL?
125	TXJCD	Tax Jurisdiction	nvarchar	15	0	Allow NULL?
126	UMVKZ	Numerator (factor) for conversion of sales quantity into SKU	decimal	5	0
127	UMVKN	Denominator (Divisor) for Conversion of Sales Qty into SKU	decimal	5	0
128	STCUR	Exchange rate for statistics (Exch.rate at time of creation)	decimal	9	5
129	PAOBJNR	Profitability Segment Number (CO-PA)	nvarchar	10	0	Allow NULL?
130	KOKRS	Controlling Area	nvarchar	4	0	Allow NULL?
131	ZUONR	IS-M: Assignment number in FI document	nvarchar	18	0	Allow NULL?
132	KOUPD	Condition update	char	1	0	Allow NULL?
133	XCNCL	IS-M/AM: Reversal Indicator for Billing Item	char	1	0	Allow NULL?
134	BEDNR	IS-M: Number of Media Sales Agent Contract Requirement	nvarchar	6	0	Allow NULL?
135	PROVTYP	IS-M/AM: Commission Category	char	1	0	Allow NULL?
136	VZUONR	IS-M/AM: Sales Agent Assignment Number (Corrections)	nvarchar	2	0	Allow NULL?
137	BERART	IS-M/AM: Calculation Type for Media Sales Agent Commission	char	1	0	Allow NULL?
138	PBSCHL	IS-M/AM: Commission Key for Media Sales Agent	nvarchar	5	0	Allow NULL?
139	SCBAS	IS-M/AM: Scale Base Value for Commission Key	char	1	0	Allow NULL?
140	VERMART	IS-M: Media Sales Agent Type: General/City/Special Agent	nvarchar	2	0	Allow NULL?
141	PR_BETRAG	IS-M: Sales Agent Share of Commission (in %)	decimal	7	3
142	PBBASIS	IS-M/AM: Commission/Bonus Basis Amount (Percentage Calc.)	decimal	13	2
143	ISPBEDART	IS-M/AM: Requirement Type in Media Sales Agent Contract	nvarchar	2	0	Allow NULL?
144	ALAND	Departure country (country from which the goods are sent)	nvarchar	3	0	Allow NULL?
145	XSTEIG	IS-M: Can be Incremented Indicator	char	1	0	Allow NULL?
146	VKORG_AUFT	IS-M: Sales Organization for Customer Order	nvarchar	4	0	Allow NULL?
147	EPROZ	IS-M: Percentage rate from rev.distributed billing item	decimal	8	5
148	NETWPV	Net value of the billing item in document currency	decimal	15	2
149	KTGRP	Account assignment grouping for edition	nvarchar	2	0	Allow NULL?

Name	Primary	Unique	Type	Columns
JHTFP~0	Yes	Yes	CLUSTERED	POSNR, VBELN, MANDT
JHTFP~A	No	No	NONCLUSTERED	AUGRP, AUPOS, AUBEL

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

149 COLUMNS | 2 INDEXES | ERP 6.0 | JHTFP TABLE

TOP ERP 6.0 | JHTFP COLUMNS

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

149 COLUMNS | 2 INDEXES | ERP 6.0 | JHTFP TABLE

TOPERP 6.0 | JHTFP COLUMNS

TOPERP 6.0 | JHTFP INDEXES

TOP ERP 6.0 | JHTFP COLUMNS

TOP ERP 6.0 | JHTFP INDEXES