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	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	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

	Product	Version	Table	Columns	Indexes	Description	Module
Incentive and Commission Management ICM
1	ERP EHP7	6.0	YHITEC_DOCRE	81	3	Commission Document, Remuneration and Liability	Incentive and Commission Management ICM

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	*	MANDT	Allow NULL?
2	POST_YEAR	Assignment Year of Commission Case/Document	nvarchar	4	0	NUMC	(N'0000')	No		CACSPSTYEAR	Allow NULL?
3	DOC_ID	Document Identification	nvarchar	10	0	CHAR	(N' ')	No		CACSDOCID	Allow NULL?
4	REMUN_POS	ID of Remuneration Row for Referenced Document	nvarchar	4	0	CHAR	(N' ')	No		CACSREMUNPOS	Allow NULL?
5	INCENTIVE_BASIS	Bonus Basis Value	decimal	15	2	CURR	((0))	Yes		INCENTIVE_BASIS_VALUE_CUM
6	COMM_BASIS_VALUE	Commission Basis Value	decimal	15	2	CURR	((0))	Yes		CACS_CRM_COMMBAS_VALUE_CUM
7	GUID	Transaction GUID	nvarchar	32	0	CHAR	(N' ')	Yes		CACS_CRM_PROZESS_GUID_32	Allow NULL?
8	ITEM_GUID	Transaction GUID	nvarchar	32	0	CHAR	(N' ')	Yes		CACS_CRM_PROZESS_GUID_32	Allow NULL?
9	CURRENCY	Currency	nvarchar	5	0	CUKY	(N' ')	Yes	*	CACS_CRM_CURRENCY	Allow NULL?
10	COMM_TRI_DATE	Date of Commission Run Start	nvarchar	8	0	DATS	(N'00000000')	Yes		CACS_CRM_COMMISS_TRIGGER_DATE	Allow NULL?
11	ORDER_QTY	Purchase Order Quantity	decimal	13	3	QUAN	((0))	Yes		CACS_CRM_QTY_ORDER
12	HITEC_COUNTRY	Country Key	nvarchar	3	0	CHAR	(N' ')	Yes	*	LAND1	Allow NULL?
13	CATEGORY_ID	Category ID	nvarchar	20	0	CHAR	(N' ')	Yes		CACS_COM_CATEGORY_ID	Allow NULL?
14	PRODUCT_ID	Product ID	nvarchar	40	0	CHAR	(N' ')	Yes		CACS_COM_PRODUCT_ID	Allow NULL?
15	FLG_COMPL	Indicator: Document Part Created by Complete Update	char	1	0	CHAR	(N' ')	Yes		CACSFLGCOMPL	Allow NULL?
16	FLG_REVERSED	Indicator: Row/Object/Subobject is Invalid or Reversed	char	1	0	CHAR	(N' ')	Yes		CACSFLGREV	Allow NULL?
17	STATUS_POS	Status of Object/Subobject	char	1	0	CHAR	(N' ')	Yes	TCACS_VALSTAT2	CACSSTATUSPOS	Allow NULL?
18	STATUS_WORK	Processing Status of an Object Item	char	1	0	CHAR	(N' ')	Yes	TCACS_VALSTAT2	CACSSTATUSPOSWORK	Allow NULL?
19	PART_POS	Position of Participation in a Commission Case	nvarchar	4	0	CHAR	(N' ')	Yes		CACSPARTID	Allow NULL?
20	INV_POS	Participant Position in a Participation	nvarchar	4	0	CHAR	(N' ')	Yes		CACSINVPOS	Allow NULL?
21	CTRTBU_ID	Commission Contract Number	nvarchar	20	0	CHAR	(N' ')	Yes		CACS_CTRTBU_ID	Allow NULL?
22	BUCAGR_ID	Agreement Number	nvarchar	12	0	CHAR	(N' ')	Yes		CACS_BUCAGR_ID	Allow NULL?
23	CLAIM_OBJTYPE	Entitlement Object Type	char	1	0	CHAR	(N' ')	Yes		CACSCLAIMOBJTYPE	Allow NULL?
24	CLAIM_OBJID	ID of Entitlement Object Acc. to Entitlement Object Type	nvarchar	30	0	CHAR	(N' ')	Yes		CACSCLAIMOBJID	Allow NULL?
25	REM_IMP_YEAR	Year Commission Case Reported	nvarchar	4	0	NUMC	(N'0000')	Yes		CACSIMPYEAR	Allow NULL?
26	REM_CASE_ID	Identification of a Case Resulting in Remuneration	nvarchar	10	0	CHAR	(N' ')	Yes		CACSREMCASEID	Allow NULL?
27	REM_CASE_VERS	Commission Case Version	nvarchar	6	0	NUMC	(N'000000')	Yes		CACSCASEVERS	Allow NULL?
28	POW_OBJ_TYPE	Subobject Type Where Activity Originates	nvarchar	5	0	CHAR	(N' ')	Yes	*	CACSPOWOBJ	Allow NULL?
29	POW_OBJ_ID	Identification of Subobject of Activity Provided	nvarchar	12	0	CHAR	(N' ')	Yes		CACSPOWOBJID	Allow NULL?
30	ACTIVITY	Activity Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	CACSACT	Allow NULL?
31	ACT_POS	Identification of an Activity Line	nvarchar	4	0	CHAR	(N' ')	Yes		CACSACTPOS	Allow NULL?
32	ACTGRP	Role	nvarchar	4	0	CHAR	(N' ')	Yes	TCACS_ACTGRP	CACSACTGRP	Allow NULL?
33	REM_OBJ_TYPE	Remunerating Subobject Type	nvarchar	5	0	CHAR	(N' ')	Yes	*	CACSREMOBJ	Allow NULL?
34	REM_OBJ_ID	Identification of Subobject Resulting in Remuneration	nvarchar	12	0	CHAR	(N' ')	Yes		CACSREMOBJID	Allow NULL?
35	VALUE	Valuation Type	nvarchar	4	0	CHAR	(N' ')	Yes	TCACS_VAL	CACSVAL	Allow NULL?
36	VALUE_TYPE	Valuation Result Category	char	1	0	NUMC	(N'0')	Yes		CACSVALTYPE	Allow NULL?
37	VALUE_POS	Valuation Row Identification	nvarchar	4	0	CHAR	(N' ')	Yes		CACSVALUEPOS	Allow NULL?
38	REMVAL_LEDAMNT	Remuneration Value in Commission Model Currency	decimal	15	2	CURR	((0))	Yes		CACSREMVALAMNT
39	REMVAL_QUAN	Remuneration Value (Volume)	decimal	11	2	QUAN	((0))	Yes		CACSREMVALQUAN
40	VALUE_UNIT	Valuation Unit	nvarchar	3	0	UNIT	(N' ')	Yes	*	CACSEVALUNIT	Allow NULL?
41	ROLE	Participant Role	nvarchar	3	0	CHAR	(N' ')	Yes	TCACS_ROLE	CACSROLE	Allow NULL?
42	ROLE_REMUSHAR	Share of Remuneration (in Percent)	decimal	10	5	DEC	((0))	Yes		CACSREMUSHARE
43	CONSTELL	Constellation of Participants	nvarchar	4	0	CHAR	(N' ')	Yes		CACSCONS	Allow NULL?
44	DIST_TYPE	Remuneration Participation Category	char	1	0	CHAR	(N' ')	Yes		CACSDISTTYPE	Allow NULL?
45	CON_CURR	Contract Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	CACSCONCURR	Allow NULL?
46	LED_CURR	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	CACSLEDCURR	Allow NULL?
47	ALLOCATION	Offsetting Selectn (Excess/Sub-Threshold Earnings, Advances)	char	1	0	CHAR	(N' ')	Yes		CACSALLOC	Allow NULL?
48	REMUNERATION	Remuneration Type	nvarchar	4	0	CHAR	(N' ')	Yes	TCACS_REM	CACSREM	Allow NULL?
49	REM_VERSION	Version of Master Data or Customizing Object	nvarchar	6	0	NUMC	(N'000000')	Yes		CACSVERSION	Allow NULL?
50	REM_RATE	Remuneration Record (For Example, Percentage)	decimal	8	3	DEC	((0))	Yes		CACSREMRATE
51	REM_CONAMNT	Remuneration Entitlement, Amount in Contract Currency	decimal	15	2	CURR	((0))	Yes		CACSREMUCONAMNT
52	DUE_CONAMNT	Remuneration Amount Ready for Disbursement in Contr Currency	decimal	15	2	CURR	((0))	Yes		CACSDUECONAMNT
53	REM_LEDAMNT	Remunerat. Entitlement, Amount in Commission Model Currency	decimal	15	2	CURR	((0))	Yes		CACSREMULEDAMNT
54	DUE_LEDAMNT	Disbursable Partial Remuner.Amount in Comm. Model Currency	decimal	15	2	CURR	((0))	Yes		CACSDUELEDAMNT
55	REM_UNIT	Remuneration Unit	nvarchar	3	0	UNIT	(N' ')	Yes	*	CACSREMUUNIT	Allow NULL?
56	REM_QUAN	Remuneration Entitlement as Quantity	decimal	11	2	QUAN	((0))	Yes		CACSREMUQUAN
57	DUE_QUAN	Remuneration Quantity Ready for Disbursement	decimal	11	2	QUAN	((0))	Yes		CACSDUEQUAN
58	OFFSET_END_DATE	End of Offsetting	nvarchar	8	0	DATS	(N'00000000')	Yes		CACSOFFSEDAT	Allow NULL?
59	OFFSET_RULE_ID	Offsetting Type	nvarchar	4	0	CHAR	(N' ')	Yes	TCACS_OFFS	CACSOFFSETRULE	Allow NULL?
60	OFFSET_CONAMNT	Remaining Offset Amount in Contract Currency	decimal	15	2	CURR	((0))	Yes		CACSOFFSCONAMNT
61	OFFSET_LEDAMNT	Offsetting/Secondary Liability Amt Remaining in ComModCurr.	decimal	15	2	CURR	((0))	Yes		CACSOFFSLEDAMNT
62	OFFSET_QUAN	Offsetting/Remaining Secondary Liability Quantity	decimal	11	2	QUAN	((0))	Yes		CACSOFFSQUAN
63	RESP_BEGIN_DATE	Liability Start	nvarchar	8	0	DATS	(N'00000000')	Yes		CACSRESPBDAT	Allow NULL?
64	RESP_END_DATE	Liability End	nvarchar	8	0	DATS	(N'00000000')	Yes		CACSRESPEDAT	Allow NULL?
65	RESP_RULE_ID	Liability Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	CACSRESPRULE	Allow NULL?
66	RESP_CONAMNT	Remaining Liability Amount in Contract Currency	decimal	15	2	CURR	((0))	Yes		CACSRESPCONAMNT
67	RESP_LEDAMNT	Remaining Liability Value in Commission Model Currency	decimal	15	2	CURR	((0))	Yes		CACSRESPLEDAMNT
68	RESP_QUAN	Remaining liability Quantity	decimal	11	2	QUAN	((0))	Yes		CACSRESPQUAN
69	RESPVAL_LEDAMNT	Remaining Liability Value in Commission Model Currency	decimal	15	2	CURR	((0))	Yes		CACSRESPVALAMNT
70	RESPVAL_QUAN	Remaining Liability Value (Quantity)	decimal	11	2	QUAN	((0))	Yes		CACSRESPVALQUAN
71	STATUS_RESP	Liability Status	char	1	0	CHAR	(N' ')	Yes		CACSSTATUSRESP	Allow NULL?
72	RESP_RUPT_BEGIN	Date of Interruption Start	nvarchar	14	0	NUMC	(N'00000000000000')	Yes		CACSRUPTDATE_B	Allow NULL?
73	RESP_RUPT_END	Date of Required End of Interruption	nvarchar	14	0	NUMC	(N'00000000000000')	Yes		CACSRUPTDATE_E	Allow NULL?
74	CORRBY_DOC_ID	Document Used to Correct This Row	nvarchar	10	0	CHAR	(N' ')	Yes		CACSCORRBYDOCID	Allow NULL?
75	CORRBY_PST_YEAR	Assignment Year Document Used for Correcting Row	nvarchar	4	0	NUMC	(N'0000')	Yes		CACSCORRBYPSTYEAR	Allow NULL?
76	CORRBY_PST_DATE	Posting Date in Commission Case/Comm Doc. (Acknowledgement)	nvarchar	8	0	DATS	(N'00000000')	Yes		CACSPSTDAT	Allow NULL?
77	CORRTO_DOC_ID	ID of Corrected Document	nvarchar	10	0	CHAR	(N' ')	Yes		CACSCORRTODOCID	Allow NULL?
78	CORRTO_PST_YEAR	Assignment Year Document That Corrected This Row	nvarchar	4	0	NUMC	(N'0000')	Yes		CACSCORRTOPSTYEAR	Allow NULL?
79	CORRTO_REMUN_POS	ID of Remuneration Row in Corrected Document	nvarchar	4	0	CHAR	(N' ')	Yes		CACSCORRTOREMUNPOS	Allow NULL?
80	FLG_CORR	Indicator: Document Part Created by a Correction	char	1	0	CHAR	(N' ')	Yes		CACSFLGCORR	Allow NULL?
81	SETTLE_GROUP	Settlement Item Grouping in Document	nvarchar	4	0	CHAR	(N' ')	Yes		CACSSETTLEGROUP	Allow NULL?

Name	Primary	Unique	Type	Columns
YHITEC_DOCRE~0	Yes	Yes	CLUSTERED	MANDT, POST_YEAR, DOC_ID, REMUN_POS
YHITEC_DOCRE~CTR	No	No	NONCLUSTERED	MANDT, CTRTBU_ID, REMUNERATION
YHITEC_DOCRE~REV	No	No	NONCLUSTERED	MANDT, CORRBY_PST_YEAR, CORRBY_DOC_ID

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

81 COLUMNS | 3 INDEXES | ERP 6.0 | YHITEC_DOCRE TABLE

TOP ERP 6.0 | YHITEC_DOCRE COLUMNS

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

81 COLUMNS | 3 INDEXES | ERP 6.0 | YHITEC_DOCRE TABLE

TOPERP 6.0 | YHITEC_DOCRE COLUMNS

TOPERP 6.0 | YHITEC_DOCRE INDEXES

TOP ERP 6.0 | YHITEC_DOCRE COLUMNS

TOP ERP 6.0 | YHITEC_DOCRE INDEXES