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	OVPM	154	Outgoing Payments
6	OINM	101	Whse Journal
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
Production Planning and Control :: Basic Data :: Work Center
1	ERP EHP7	6.0	KAKO	76	5	Capacity Header Segment	Work Center

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	KAPID	Capacity ID	nvarchar	8	0	Allow NULL?
3	AZMAX	Number of individual capacities	smallint	5	0
4	AZNOR	Number of individual capacities	smallint	5	0
5	BASNE	Denominator of the base capacity	decimal	5	0
6	BASZL	Numerator for base capacity	decimal	5	0
7	BEGZT	Start time in seconds (internal)	int	10	0	Allow NULL?
8	BRGRU	Authorization Group	nvarchar	4	0	Allow NULL?
9	ENDZT	Finish time in seconds (internal)	int	10	0	Allow NULL?
10	KALID	Factory calendar ID	nvarchar	2	0	Allow NULL?
11	KAPAR	Capacity category	nvarchar	3	0	Allow NULL?
12	MEINS	Base Unit of Measurement for Capacity	nvarchar	3	0	Allow NULL?
13	MOSID	Grouping for Shift Definitions and Shift Sequences	nvarchar	2	0	Allow NULL?
14	NAME	Capacity name	nvarchar	8	0	Allow NULL?
15	NGRAD	Capacity utilization rate (percent)	nvarchar	3	0	Allow NULL?
16	PAUSE	Cumulative break time in seconds (internal)	int	10	0	Allow NULL?
17	PLANR	Capacity planner group	nvarchar	3	0	Allow NULL?
18	POOLK	Indicator for pooled capacity	char	1	0	Allow NULL?
19	REFAN	Denominator relationship: No. of indiv. capacities reference	tinyint	3	0
20	REFAZ	Numerator relationships: No. of indiv. capacities reference	tinyint	3	0
21	REFID	Capacity ID	nvarchar	8	0	Allow NULL?
22	SUPPK	Available capacity limits	char	1	0	Allow NULL?
23	VERSA	Active version of available capacity	nvarchar	2	0	Allow NULL?
24	WERKS	Plant	nvarchar	4	0	Allow NULL?
25	KAPIE	Capacity ID	nvarchar	8	0	Allow NULL?
26	KAPTER	Indicator: Capacity relevant to finite scheduling	char	1	0	Allow NULL?
27	KAPAVO	Indicator: Several operations can use capacity	char	1	0	Allow NULL?
28	UEBERLAST	Overload	nvarchar	3	0	Allow NULL?
29	KAPLPL	Indicator: Capacity excluded from long-term planning	char	1	0	Allow NULL?
30	KAPEH	Unit of measure of capacity	nvarchar	3	0	Allow NULL?
31	MEHR	Has individual capacities	char	1	0	Allow NULL?
32	ANG_UNIT	Unit for available capacity	nvarchar	3	0	Allow NULL?
33	ANG_MIN	Minimum capacity in volume unit or unit of measure	decimal	13	3
34	ANG_MAX	Maximum capacity in volume unit or unit of measure	decimal	13	3
35	TYPE	Resource Type	nvarchar	2	0	Allow NULL?
36	RESTYPE	Resource Category	char	1	0	Allow NULL?
37	CAPACITY_A	Capacity of Bucket Resource	decimal	13	3
38	CAPACITY_A_UNIT	Unit of Measurement for the Capacity of a Bucket Resource	nvarchar	3	0	Allow NULL?
39	NUM_OF_PERIODS	Number of Periods to Which the Capacity Refers	nvarchar	3	0	Allow NULL?
40	PERIOD	Period Type	nvarchar	2	0	Allow NULL?
41	BUFFERTIME	Resource-Dependent Time Buffer	int	10	0	Allow NULL?
42	BUFFERTIME_UNIT	Unit of Measurement for Time Buffer	nvarchar	3	0	Allow NULL?
43	IS_BOTTLENECK	This Resource is a Bottleneck Resource	char	1	0	Allow NULL?
44	UNDERLOAD	Minimum Capacity Load for the Resource	nvarchar	3	0	Allow NULL?
45	OVERLAP_BUCKETS	Activities can Overlap into Another Period	char	1	0	Allow NULL?
46	START_ON_GRID	Activities can Only Begin at the Start of the Bucket	char	1	0	Allow NULL?
47	MIN_OVERLAP	Maximum Overlap of Activities	int	10	0	Allow NULL?
48	MIN_OVERLAP_UNIT	Unit of Measurement for Maximum Overlap of Two Activities	nvarchar	3	0	Allow NULL?
49	LOSS_FACTOR	Loss Factor in Percent when Deriving Bucket Capacity	nvarchar	3	0	Allow NULL?
50	SORT	Freely Selectable Character Sequence for Sorting Resources	nvarchar	30	0	Allow NULL?
51	SYNC_START	Synchronization of Activities when Overlapping Occurs	char	1	0	Allow NULL?
52	DEFINE_BUCKETS	Definition of the Bucket Capacity of a Mixed Resource	char	1	0	Allow NULL?
53	LC_DAYS_MINUS	Validity of Available Capacity (In Past)	nvarchar	4	0	Allow NULL?
54	LC_DAYS_PLUS	Validity of Available Resource Capacity (In the Future)	nvarchar	4	0	Allow NULL?
55	STORAGE_CAPABLE	Resource has Storage Characteristics	char	1	0	Allow NULL?
56	MIN_STORAGE	Minimum Production Quantity	decimal	15	3
57	MAX_STORAGE	Maximum Stock Level	decimal	15	3
58	STORAGE_UNIT	Stock Unit	nvarchar	3	0	Allow NULL?
59	DIM_STORAGE	Dimension of Storage Characteristic of a Resource	nvarchar	6	0	Allow NULL?
60	STORAGE_TO_ZERO	Handling of Remaining Fill Level	char	1	0	Allow NULL?
61	SNPLC	Resource is not Relevant to SNP	char	1	0	Allow NULL?
62	UTIL_BUCKET	Utilization Rate for Bucket-Oriented Capacity [%]	decimal	6	3
63	CAMPAIGN_PPDS	Resource is Campaign-Relevant	char	1	0	Allow NULL?
64	CAMPAIGN_SNP	Cross-Period Lot Sizes	char	1	0	Allow NULL?
65	TSTREAM_EXTERNAL	Capacity Data for Time Stream Originates in External System	char	1	0	Allow NULL?
66	FINITY_LEVEL	Finiteness Level of Resource	nvarchar	4	0	Allow NULL?
67	BR_QUANT	Number of Units of Measure for Base Rate	decimal	13	3
68	BR_QUNIT	Unit of Measure for Production Rate	nvarchar	3	0	Allow NULL?
69	BR_TIME	Number of Time Units for Production Rate	decimal	5	2
70	BR_TUNIT	Time Unit of Production Rate	nvarchar	3	0	Allow NULL?
71	RITT_FLG	/SAPAPO/RITT_FLG	char	1	0	Allow NULL?
72	MDRMODEL	Defintion Name for the Product-Dependent Rate	nvarchar	40	0	Allow NULL?
73	PP_DEF_BUCKETS	Definition of PP/DS Bucket Capacity	char	1	0	Allow NULL?
74	PP_BUCKET_SCHEMA	PP/DS Bucket Schema	nvarchar	2	0	Allow NULL?
75	PP_BUCKET_FACT	Factor: Relation. of Avl. Bucket Cap. to Avl. Time-Cont Cap.	nvarchar	3	0	Allow NULL?
76	MIX_PLAN_TYPE	Finite Capacity of a Mixed Resource	char	1	0	Allow NULL?

Name	Primary	Unique	Type	Columns
KAKO~0	Yes	Yes	CLUSTERED	KAPID, MANDT
KAKO~A	No	No	NONCLUSTERED	KAPAR, NAME, WERKS, MANDT
KAKO~B	No	No	NONCLUSTERED	KAPAR, MANDT
KAKO~C	No	No	NONCLUSTERED	KAPIE, MANDT
KAKO~P	No	No	NONCLUSTERED	PLANR, MANDT

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

76 COLUMNS | 5 INDEXES | ERP 6.0 | KAKO TABLE

TOP ERP 6.0 | KAKO COLUMNS

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

76 COLUMNS | 5 INDEXES | ERP 6.0 | KAKO TABLE

TOPERP 6.0 | KAKO COLUMNS

TOPERP 6.0 | KAKO INDEXES

TOP ERP 6.0 | KAKO COLUMNS

TOP ERP 6.0 | KAKO INDEXES