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
Controlling :: Product Cost Controlling :: Product Cost Planning
1	ERP EHP7	6.0	CKIS	140	1	Items Unit Costing/Itemization Product Costing	Product Cost Planning

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	LEDNR	Ledger for Controlling objects	nvarchar	2	0	Allow NULL?
3	BZOBJ	Reference Object	char	1	0	Allow NULL?
4	KALNR	Cost Estimate Number for Cost Est. w/o Qty Structure	nvarchar	12	0	Allow NULL?
5	KALKA	Costing Type	nvarchar	2	0	Allow NULL?
6	KADKY	Costing Date (Key)	nvarchar	8	0	Allow NULL?
7	TVERS	Costing Version	nvarchar	2	0	Allow NULL?
8	BWVAR	Valuation Variant in Costing	nvarchar	3	0	Allow NULL?
9	KKZMA	Costs Entered Manually in Additive or Automatic Cost Est.	char	1	0	Allow NULL?
10	POSNR	Unit Costing Line Item Number	nvarchar	5	0	Allow NULL?
11	STATP	Item Status	nvarchar	4	0	Allow NULL?
12	STRGP	Item Control (for Internal Use)	nvarchar	4	0	Allow NULL?
13	TYPPS	Item Category	char	1	0	Allow NULL?
14	KSTAR	Cost Element	nvarchar	10	0	Allow NULL?
15	KSTAR_MANUAL	Cost Element Has Been Manually Changed	char	1	0	Allow NULL?
16	HRKFT	Origin Group as Subdivision of Cost Element	nvarchar	4	0	Allow NULL?
17	ELEMT	Cost Component Number of Main Cost Component Split	nvarchar	3	0	Allow NULL?
18	ELEMTNS	Cost Component Number of Auxiliary Cost Component Split	nvarchar	3	0	Allow NULL?
19	FVFLG	Fixed/Variable Indicator	char	1	0	Allow NULL?
20	OPCOD	Formula field for calculations at item level	nvarchar	50	0	Allow NULL?
21	FRLNR	Unit Costing Formula Number	nvarchar	3	0	Allow NULL?
22	BUKRS	Company Code	nvarchar	4	0	Allow NULL?
23	WERKS	Plant	nvarchar	4	0	Allow NULL?
24	MATNR	Material Number	nvarchar	18	0	Allow NULL?
25	PSCHL	Pricing Key	nvarchar	18	0	Allow NULL?
26	KOKRS_HRK	Origin Controlling Area Item	nvarchar	4	0	Allow NULL?
27	EXTNR	Base Planning Object (External Number)	nvarchar	18	0	Allow NULL?
28	GPREIS	Price in Controlling Area Currency	decimal	15	2
29	FPREIS	Fixed Price in Controlling Area Currency	decimal	15	2
30	PEINH	Price Unit of Prices in Controlling Area Currency	decimal	5	0
31	PMEHT	Price Quantity Unit	nvarchar	3	0	Allow NULL?
32	PRICE_MANUAL	Price Entered Manually	char	1	0	Allow NULL?
33	WERTB	Value in Controlling Area Currency	decimal	15	2
34	WERTN	Value in Controlling Area Currency	decimal	15	2
35	WRTFX	Fixed Value in Controlling Area Currency	decimal	15	2
36	WRTFW_KPF	Value in Object Currency	decimal	15	2
37	WRTFW_KFX	Fixed Value in Object Currency	decimal	15	2
38	FWAER_KPF	Object Currency	nvarchar	5	0	Allow NULL?
39	WRTFW_POS	Value in Transaction Currency	decimal	15	2
40	WRTFW_PFX	Fixed Value in Transaction Currency	decimal	15	2
41	FWAER	Transaction Currency	nvarchar	5	0	Allow NULL?
42	MKURS	Average rate	nvarchar	9	0	Allow NULL?
43	FWEHT	Currency unit	nvarchar	4	0	Allow NULL?
44	MENGE	Quantity	decimal	15	3
45	MEEHT	Base Unit of Measure	nvarchar	3	0	Allow NULL?
46	SUMM1	Quantities total for item category S	decimal	15	3
47	SUMM2	Capital Spending Total for Item Category S	decimal	15	2
48	SUMM3	Total of two or more items	decimal	15	2
49	DPREIS	Average price for periods	decimal	15	2
50	PREIS1	Value of Delta Profit in CO Area Currency - Legal View	decimal	15	2
51	PREIS2	Value of Delta Profit in Object Currency - Legal View	decimal	15	2
52	PREIS3	Value of Delta Profit in CO Area Currency - Profit Ctr View	decimal	15	2
53	PREIS4	Value of Delta Profit in Object Currency - Profit Ctr View	decimal	15	2
54	PREIS5	Price Component 5	decimal	15	2
55	PFKT1	Price Component Factor	decimal	5	2
56	PFKT2	Price Component Factor	decimal	5	2
57	PFKT3	Price Component Factor	decimal	5	2
58	PFKT4	Price Component Factor	decimal	5	2
59	PFKT5	Price Component Factor	decimal	5	2
60	ZUABS	Overhead as absolute figure	decimal	15	2
61	ZUFKT	Overhead factor	decimal	5	4
62	PSKNZ	Lot-Size-Independent Indicator	char	1	0	Allow NULL?
63	SBDKZ	Dependent requirements ind. for individual and coll. reqmts	char	1	0	Allow NULL?
64	VTKNZ	Distribution Indicator	char	1	0	Allow NULL?
65	LSTAR	Activity Type	nvarchar	6	0	Allow NULL?
66	ARBID	Object ID	nvarchar	8	0	Allow NULL?
67	KOSTL	Cost Center	nvarchar	10	0	Allow NULL?
68	INFNR	Number of Purchasing Info Record	nvarchar	10	0	Allow NULL?
69	EKORG	Purchasing Organization	nvarchar	4	0	Allow NULL?
70	ESOKZ	Purchasing info record category	char	1	0	Allow NULL?
71	LIFNR	Account Number of Vendor or Creditor	nvarchar	10	0	Allow NULL?
72	EBELN	Purchasing Document Number	nvarchar	10	0	Allow NULL?
73	EBELP	Item Number of Purchasing Document	nvarchar	5	0	Allow NULL?
74	STEUS	Control Key	nvarchar	4	0	Allow NULL?
75	FXPRU	Fixed-Price Co-Product	char	1	0	Allow NULL?
76	STPOS	Equivalence Number with 4 Places	decimal	4	0
77	AFAKT	Costg.: Apportionment Factor for Itemiz. Line in Joint Prod.	float	15	16
78	BWTAR	Valuation Type	nvarchar	10	0	Allow NULL?
79	MKALK	Mixed Costing Indicator	char	1	0	Allow NULL?
80	BTYP	Process Category	nvarchar	4	0	Allow NULL?
81	KALNR_BA	Cost Estimate Number of Procurement Alternative	nvarchar	12	0	Allow NULL?
82	MISCH_VERH	Mixing Ratio	decimal	13	3
83	UMREZ	Numerator for Conversion of Order Unit to Base Unit	decimal	5	0
84	UMREN	Denominator for Conversion of Order Unit to Base Unit	decimal	5	0
85	AUSMG	Scrap Quantity	decimal	15	3
86	AUSMGKO	Component Scrap Quantity	decimal	15	3
87	AUSPROZ	Scrap Factor	decimal	6	3
88	APLZL	Continuous Counter for Differentiating Database Entries	nvarchar	8	0	Allow NULL?
89	VORNR	Operation/Activity Number	nvarchar	4	0	Allow NULL?
90	UVORN	Suboperation	nvarchar	4	0	Allow NULL?
91	STEAS	Target start date of the operation	nvarchar	8	0	Allow NULL?
92	POSNR_EXT	Item Number for External Layout (Unit Costing)	nvarchar	5	0	Allow NULL?
93	POINTER1	Pointer n on Item Number	nvarchar	5	0	Allow NULL?
94	POINTER2	Pointer n on Item Number	nvarchar	5	0	Allow NULL?
95	POINTER3	Pointer n on Item Number	nvarchar	5	0	Allow NULL?
96	OPREIS	Price in Object Currency	decimal	15	2
97	OPREIFX	Fixed Price in Object Currency	decimal	15	2
98	TPREIS	Price in Transaction Currency	decimal	15	2
99	TPREIFX	Fixed Price in Transaction Currency	decimal	15	2
100	PATNR	Partner number for costing	nvarchar	6	0	Allow NULL?
101	VERWS	Reference of KALKTAB Items to a Context	nvarchar	35	0	Allow NULL?
102	PRSKZ	Price Indicator	nvarchar	3	0	Allow NULL?
103	STRAT	Valuation Strategy used for Costing Item	char	1	0	Allow NULL?
104	SUBSTRAT	Substrategy for Material Valuat. with Purchasing Info Record	char	1	0	Allow NULL?
105	TKURS	Exchange Rate for Item Foreign Currency	decimal	9	5
106	SELKZ	Indicator for Relevancy to Costing	char	1	0	Allow NULL?
107	VRGGRP	Transaction Group for Cost Element Itemization	nvarchar	3	0	Allow NULL?
108	KKZMM	Costs Were Entered Manually in an Additive Cost Estimate	char	1	0	Allow NULL?
109	SSEDD	Latest scheduled finish: Execution (date)	nvarchar	8	0	Allow NULL?
110	FEHLKZ	Error Indicator	char	1	0	Allow NULL?
111	NO_CCSPLIT	Do Not Determine Item Value via Cost Component Split	char	1	0	Allow NULL?
112	SCHKZ	Main Cost Component Split for KALKTAB Item Exists	char	1	0	Allow NULL?
113	SCHKZNS	Auxiliary Cost Component Split for KALKTAB Item Exists	char	1	0	Allow NULL?
114	UFIELD_MODE	Indicator to Override Transfer Control	char	1	0	Allow NULL?
115	UKALN	Cost Estimate Number of Transferred Cost Estimate	nvarchar	12	0	Allow NULL?
116	UKALKA	Costing Type of Transferred Cost Estimate	nvarchar	2	0	Allow NULL?
117	UKADKY	Date of Transferred Cost Estimate	nvarchar	8	0	Allow NULL?
118	UTVERS	Costing Version for Transfer	nvarchar	2	0	Allow NULL?
119	UBWVAR	Valuation Variant of Transferred Cost Estimate	nvarchar	3	0	Allow NULL?
120	HKMAT	Material-related origin	char	1	0	Allow NULL?
121	SPOSN	BOM Item Number	nvarchar	4	0	Allow NULL?
122	USTRAT	Transfer Strategy: Search Term 1	char	1	0	Allow NULL?
123	BAUGR	Item Is an Assembly	char	1	0	Allow NULL?
124	ASNUM	Activity Number	nvarchar	18	0	Allow NULL?
125	PEINH_2	Price Unit	decimal	5	0
126	PEINH_3	Price Unit	decimal	5	0
127	PRZNR	Business Process	nvarchar	12	0	Allow NULL?
128	NLAG	Non-Stock Material	char	1	0	Allow NULL?
129	PRCTR	Profit Center	nvarchar	10	0	Allow NULL?
130	GSBER	Business Area	nvarchar	4	0	Allow NULL?
131	PSPNR	Work Breakdown Structure Element (WBS element)	nvarchar	8	0	Allow NULL?
132	PAROB	Partner Object	nvarchar	22	0	Allow NULL?
133	KZANW	'X' = Do Not Calculate Overhead Costs	char	1	0	Allow NULL?
134	KZLB	'X' = Header Material Is Subcontracted	char	1	0	Allow NULL?
135	SUBKEY	CO key subnumber	nvarchar	14	0	Allow NULL?
136	KZWSO	Units of measure usage	char	1	0	Allow NULL?
137	DISST	Low-Level Code	nvarchar	3	0	Allow NULL?
138	CUOBJ	Object Number for Conf. Objects	nvarchar	18	0	Allow NULL?
139	GENTYP	Generation Type of Item	char	1	0	Allow NULL?
140	COMPONENT_ID	Unique Pointer to the Itemization Line (Persistent)	nvarchar	7	0	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

140 COLUMNS | 1 INDEXES | ERP 6.0 | CKIS TABLE

TOP ERP 6.0 | CKIS COLUMNS

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

140 COLUMNS | 1 INDEXES | ERP 6.0 | CKIS TABLE

TOPERP 6.0 | CKIS COLUMNS

TOPERP 6.0 | CKIS INDEXES

TOP ERP 6.0 | CKIS COLUMNS

TOP ERP 6.0 | CKIS INDEXES