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

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

90 COLUMNS | 3 INDEXES | ERP 6.0 | YTEL05_DOCRE TABLE

TOP ERP 6.0 | YTEL05_DOCRE COLUMNS

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

90 COLUMNS | 3 INDEXES | ERP 6.0 | YTEL05_DOCRE TABLE

TOPERP 6.0 | YTEL05_DOCRE COLUMNS

TOPERP 6.0 | YTEL05_DOCRE INDEXES

TOP ERP 6.0 | YTEL05_DOCRE COLUMNS

TOP ERP 6.0 | YTEL05_DOCRE INDEXES