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	YCRM01_DOCRE	99	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_BAS	Bonus Basis Value	decimal	15	2	CURR	((0))	Yes		INCENTIVE_BASIS_VALUE_CUM
6	COMM_BAS_VAL	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	ZZSALESVALUE	Sales Value	decimal	15	2	CURR	((0))	Yes		ZZSALESVALUE
12	ZZCUSTOMER	Customer (YTEL05)	nvarchar	12	0	CHAR	(N' ')	Yes		ZZCUSTOMER	Allow NULL?
13	ZACHV	Achievement	decimal	17	3	DEC	((0))	Yes		ZCRMT_00003_ZACHV
14	ZCMBASV	Total Commission Val	decimal	17	2	CURR	((0))	Yes		ZCRMT_00003_ZCMBASV
15	ZDOCVALUE	Billing Document Value	decimal	17	2	CURR	((0))	Yes		ZCRMT_00003_ZDOCVALUE
16	ZINCTPY	Calculated Incentive	decimal	17	2	CURR	((0))	Yes		ZCRMT_00003_ZINCTPY
17	ZORDERVAL	Incoming Orders Value	decimal	17	2	CURR	((0))	Yes		ZCRMT_00003_ZORDERVAL
18	ZPRDSALES	Product Sales	decimal	17	2	CURR	((0))	Yes		ZCRMT_00003_ZPRDSALES
19	ZRTNVALUE	Returns Value	decimal	17	2	CURR	((0))	Yes		ZCRMT_00003_ZRTNVALUE
20	ZSRVSALES	Service Sales	decimal	17	2	CURR	((0))	Yes		ZCRMT_00003_ZSRVSALES
21	ZTGINCT	Target Incentive	decimal	17	2	CURR	((0))	Yes		ZCRMT_00003_ZTGINCT
22	ZZQUAN	Quantity	decimal	6	2	QUAN	((0))	Yes		ZZANZ
23	VRKME	Sales unit	nvarchar	3	0	UNIT	(N' ')	Yes	*	VRKME	Allow NULL?
24	CURR_YR_TO_DATE	Current Year YTD Sales	decimal	15	2	CURR	((0))	Yes		ZCURRYRDATE
25	PREV_YR_TO_DATE	Previous Year YTD Sales	decimal	15	2	CURR	((0))	Yes		ZPREVYRDATE
26	EXO_MONTHLY	Monthly Sales of E Revenue	decimal	15	2	CURR	((0))	Yes		ZEXOMONTHLY
27	SUP_MONTHLY	Monthly Sales of S Revenue	decimal	15	2	CURR	((0))	Yes		ZSUPMONTHLY
28	EXO_QTR_PLAN	Quarterly Plan of E Revenue	decimal	15	2	CURR	((0))	Yes		ZEXOQTRPLAN
29	SUP_QTR_ACTUAL	Quarterly Sales of S Revenue	decimal	15	2	CURR	((0))	Yes		ZSUPQTRACT
30	EXO_QTR_ACTUAL	Quarterly Sales of E Revenue	decimal	15	2	CURR	((0))	Yes		ZEXOQTRACT
31	SUP_QTR_PLAN	Quarterly Plan of S Revenue	decimal	15	2	CURR	((0))	Yes		ZSUPQTRPLAN
32	FLG_COMPL	Indicator: Document Part Created by Complete Update	char	1	0	CHAR	(N' ')	Yes		CACSFLGCOMPL	Allow NULL?
33	FLG_REVERSED	Indicator: Row/Object/Subobject is Invalid or Reversed	char	1	0	CHAR	(N' ')	Yes		CACSFLGREV	Allow NULL?
34	STATUS_POS	Status of Object/Subobject	char	1	0	CHAR	(N' ')	Yes	TCACS_VALSTAT2	CACSSTATUSPOS	Allow NULL?
35	STATUS_WORK	Object Processing Status (Replica)	char	1	0	CHAR	(N' ')	Yes		CACSSTATUSWORKP	Allow NULL?
36	PART_POS	Position of Participation in a Commission Case	nvarchar	4	0	CHAR	(N' ')	Yes		CACSPARTID	Allow NULL?
37	INV_POS	Participant Position in a Participation	nvarchar	4	0	CHAR	(N' ')	Yes		CACSINVPOS	Allow NULL?
38	CTRTBU_ID	Commission Contract Number	nvarchar	20	0	CHAR	(N' ')	Yes		CACS_CTRTBU_ID	Allow NULL?
39	BUCAGR_ID	Agreement Number	nvarchar	12	0	CHAR	(N' ')	Yes		CACS_BUCAGR_ID	Allow NULL?
40	CLAIM_OBJTYPE	Entitlement Object Type	char	1	0	CHAR	(N' ')	Yes		CACSCLAIMOBJTYPE	Allow NULL?
41	CLAIM_OBJID	ID of Entitlement Object Acc. to Entitlement Object Type	nvarchar	30	0	CHAR	(N' ')	Yes		CACSCLAIMOBJID	Allow NULL?
42	REM_IMP_YEAR	Year Commission Case Reported	nvarchar	4	0	NUMC	(N'0000')	Yes		CACSIMPYEAR	Allow NULL?
43	REM_CASE_ID	Identification of a Case Resulting in Remuneration	nvarchar	10	0	CHAR	(N' ')	Yes		CACSREMCASEID	Allow NULL?
44	REM_CASE_VERS	Commission Case Version	nvarchar	6	0	NUMC	(N'000000')	Yes		CACSCASEVERS	Allow NULL?
45	POW_OBJ_TYPE	Subobject Type Where Activity Originates	nvarchar	5	0	CHAR	(N' ')	Yes	*	CACSPOWOBJ	Allow NULL?
46	POW_OBJ_ID	Identification of Subobject of Activity Provided	nvarchar	12	0	CHAR	(N' ')	Yes		CACSPOWOBJID	Allow NULL?
47	ACTIVITY	Activity Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	CACSACT	Allow NULL?
48	ACT_POS	Identification of an Activity Line	nvarchar	4	0	CHAR	(N' ')	Yes		CACSACTPOS	Allow NULL?
49	ACTGRP	Role	nvarchar	4	0	CHAR	(N' ')	Yes	TCACS_ACTGRP	CACSACTGRP	Allow NULL?
50	REM_OBJ_TYPE	Remunerating Subobject Type	nvarchar	5	0	CHAR	(N' ')	Yes	*	CACSREMOBJ	Allow NULL?
51	REM_OBJ_ID	Identification of Subobject Resulting in Remuneration	nvarchar	12	0	CHAR	(N' ')	Yes		CACSREMOBJID	Allow NULL?
52	VALUE	Valuation Type	nvarchar	4	0	CHAR	(N' ')	Yes	TCACS_VAL	CACSVAL	Allow NULL?
53	VALUE_TYPE	Valuation Result Category	char	1	0	NUMC	(N'0')	Yes		CACSVALTYPE	Allow NULL?
54	VALUE_POS	Valuation Row Identification	nvarchar	4	0	CHAR	(N' ')	Yes		CACSVALUEPOS	Allow NULL?
55	REMVAL_LEDAMNT	Remuneration Value in Commission Model Currency	decimal	15	2	CURR	((0))	Yes		CACSREMVALAMNT
56	REMVAL_QUAN	Remuneration Value (Volume)	decimal	11	2	QUAN	((0))	Yes		CACSREMVALQUAN
57	VALUE_UNIT	Valuation Unit	nvarchar	3	0	UNIT	(N' ')	Yes	*	CACSEVALUNIT	Allow NULL?
58	ROLE	Participant Role	nvarchar	3	0	CHAR	(N' ')	Yes	TCACS_ROLE	CACSROLE	Allow NULL?
59	ROLE_REMUSHAR	Share of Remuneration (in Percent)	decimal	10	5	DEC	((0))	Yes		CACSREMUSHARE
60	CONSTELL	Constellation of Participants	nvarchar	4	0	CHAR	(N' ')	Yes		CACSCONS	Allow NULL?
61	DIST_TYPE	Remuneration Participation Category	char	1	0	CHAR	(N' ')	Yes		CACSDISTTYPE	Allow NULL?
62	CON_CURR	Contract Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	CACSCONCURR	Allow NULL?
63	LED_CURR	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	CACSLEDCURR	Allow NULL?
64	ALLOCATION	Offsetting Selectn (Excess/Sub-Threshold Earnings, Advances)	char	1	0	CHAR	(N' ')	Yes		CACSALLOC	Allow NULL?
65	REMUNERATION	Remuneration Type	nvarchar	4	0	CHAR	(N' ')	Yes	TCACS_REM	CACSREM	Allow NULL?
66	REM_VERSION	Version of Master Data or Customizing Object	nvarchar	6	0	NUMC	(N'000000')	Yes		CACSVERSION	Allow NULL?
67	REM_RATE	Remuneration Record (For Example, Percentage)	decimal	8	3	DEC	((0))	Yes		CACSREMRATE
68	REM_CONAMNT	Remuneration Entitlement, Amount in Contract Currency	decimal	15	2	CURR	((0))	Yes		CACSREMUCONAMNT
69	DUE_CONAMNT	Remuneration Amount Ready for Disbursement in Contr Currency	decimal	15	2	CURR	((0))	Yes		CACSDUECONAMNT
70	REM_LEDAMNT	Remunerat. Entitlement, Amount in Commission Model Currency	decimal	15	2	CURR	((0))	Yes		CACSREMULEDAMNT
71	DUE_LEDAMNT	Disbursable Partial Remuner.Amount in Comm. Model Currency	decimal	15	2	CURR	((0))	Yes		CACSDUELEDAMNT
72	REM_UNIT	Remuneration Unit	nvarchar	3	0	UNIT	(N' ')	Yes	*	CACSREMUUNIT	Allow NULL?
73	REM_QUAN	Remuneration Entitlement as Quantity	decimal	11	2	QUAN	((0))	Yes		CACSREMUQUAN
74	DUE_QUAN	Remuneration Quantity Ready for Disbursement	decimal	11	2	QUAN	((0))	Yes		CACSDUEQUAN
75	OFFSET_END_DATE	End of Offsetting	nvarchar	8	0	DATS	(N'00000000')	Yes		CACSOFFSEDAT	Allow NULL?
76	OFFSET_RULE_ID	Offsetting Type	nvarchar	4	0	CHAR	(N' ')	Yes	TCACS_OFFS	CACSOFFSETRULE	Allow NULL?
77	OFFSET_CONAMNT	Remaining Offset Amount in Contract Currency	decimal	15	2	CURR	((0))	Yes		CACSOFFSCONAMNT
78	OFFSET_LEDAMNT	Offsetting/Secondary Liability Amt Remaining in ComModCurr.	decimal	15	2	CURR	((0))	Yes		CACSOFFSLEDAMNT
79	OFFSET_QUAN	Offsetting/Remaining Secondary Liability Quantity	decimal	11	2	QUAN	((0))	Yes		CACSOFFSQUAN
80	RESP_BEGIN_DATE	Liability Start	nvarchar	8	0	DATS	(N'00000000')	Yes		CACSRESPBDAT	Allow NULL?
81	RESP_END_DATE	Liability End	nvarchar	8	0	DATS	(N'00000000')	Yes		CACSRESPEDAT	Allow NULL?
82	RESP_RULE_ID	Liability Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	CACSRESPRULE	Allow NULL?
83	RESP_CONAMNT	Remaining Liability Amount in Contract Currency	decimal	15	2	CURR	((0))	Yes		CACSRESPCONAMNT
84	RESP_LEDAMNT	Remaining Liability Value in Commission Model Currency	decimal	15	2	CURR	((0))	Yes		CACSRESPLEDAMNT
85	RESP_QUAN	Remaining liability Quantity	decimal	11	2	QUAN	((0))	Yes		CACSRESPQUAN
86	RESPVAL_LEDAMNT	Remaining Liability Value in Commission Model Currency	decimal	15	2	CURR	((0))	Yes		CACSRESPVALAMNT
87	RESPVAL_QUAN	Remaining Liability Value (Quantity)	decimal	11	2	QUAN	((0))	Yes		CACSRESPVALQUAN
88	STATUS_RESP	Liability Status	char	1	0	CHAR	(N' ')	Yes		CACSSTATUSRESP	Allow NULL?
89	RESP_RUPT_BEGIN	Date of Interruption Start	nvarchar	14	0	NUMC	(N'00000000000000')	Yes		CACSRUPTDATE_B	Allow NULL?
90	RESP_RUPT_END	Date of Required End of Interruption	nvarchar	14	0	NUMC	(N'00000000000000')	Yes		CACSRUPTDATE_E	Allow NULL?
91	CORRBY_DOC_ID	Document Used to Correct This Row	nvarchar	10	0	CHAR	(N' ')	Yes		CACSCORRBYDOCID	Allow NULL?
92	CORRBY_PST_YEAR	Assignment Year Document Used for Correcting Row	nvarchar	4	0	NUMC	(N'0000')	Yes		CACSCORRBYPSTYEAR	Allow NULL?
93	CORRBY_PST_DATE	Posting Date in Commission Case/Comm Doc. (Acknowledgement)	nvarchar	8	0	DATS	(N'00000000')	Yes		CACSPSTDAT	Allow NULL?
94	CORRTO_DOC_ID	ID of Corrected Document	nvarchar	10	0	CHAR	(N' ')	Yes		CACSCORRTODOCID	Allow NULL?
95	CORRTO_PST_YEAR	Assignment Year Document That Corrected This Row	nvarchar	4	0	NUMC	(N'0000')	Yes		CACSCORRTOPSTYEAR	Allow NULL?
96	CORRTO_REMUN_POS	ID of Remuneration Row in Corrected Document	nvarchar	4	0	CHAR	(N' ')	Yes		CACSCORRTOREMUNPOS	Allow NULL?
97	FLG_CORR	Indicator: Document Part Created by a Correction	char	1	0	CHAR	(N' ')	Yes		CACSFLGCORR	Allow NULL?
98	SETTLE_GROUP	Settlement Item Grouping in Document	nvarchar	4	0	CHAR	(N' ')	Yes		CACSSETTLEGROUP	Allow NULL?
99	UPD_TIMESTAMP	Last Change of Objects	nvarchar	14	0	NUMC	(N'00000000000000')	Yes		CACSUPDTSTMP	Allow NULL?

Name	Primary	Unique	Type	Columns
YCRM01_DOCRE~0	Yes	Yes	CLUSTERED	MANDT, POST_YEAR, DOC_ID, REMUN_POS
YCRM01_DOCRE~CTR	No	No	NONCLUSTERED	MANDT, CTRTBU_ID, REMUNERATION
YCRM01_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

99 COLUMNS | 3 INDEXES | ERP 6.0 | YCRM01_DOCRE TABLE

TOP ERP 6.0 | YCRM01_DOCRE COLUMNS

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

99 COLUMNS | 3 INDEXES | ERP 6.0 | YCRM01_DOCRE TABLE

TOPERP 6.0 | YCRM01_DOCRE COLUMNS

TOPERP 6.0 | YCRM01_DOCRE INDEXES

TOP ERP 6.0 | YCRM01_DOCRE COLUMNS

TOP ERP 6.0 | YCRM01_DOCRE INDEXES