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	YTEL01_DOCRE	95	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	ZZMODELL	Module-Description	nvarchar	12	0	CHAR	(N' ')	Yes		ZZMODELL	Allow NULL?
6	ZZME	Unit (Referenz to ZZANZ)	nvarchar	3	0	UNIT	(N' ')	Yes		ZZME	Allow NULL?
7	ZZYTEL01_MODELL	YTEL01 - Model of Mobile Phone	nvarchar	30	0	CHAR	(N' ')	Yes		ZYTEL01_MODELL	Allow NULL?
8	ZZANZ	Quantity	decimal	6	2	QUAN	((0))	Yes		ZZANZ
9	ZZYTEL01_CLASS	YTEL01 - Class of Mobile Phone	nvarchar	10	0	CHAR	(N' ')	Yes		ZYTEL01_CLASS	Allow NULL?
10	ZZYTEL01_PIECES	YTEL01 - Sold Units	nvarchar	2	0	CHAR	(N' ')	Yes		ZYTEL01_PIECES	Allow NULL?
11	ZZSPARTE	Branch	nvarchar	2	0	CHAR	(N' ')	Yes		ZZSPARTE	Allow NULL?
12	ZZYTEL01_RATEPL	YTEL01 - Rate Plan	nvarchar	10	0	CHAR	(N' ')	Yes		ZYTEL01_RATEPL	Allow NULL?
13	ZZSTOPS	Stopmark for formula	nvarchar	2	0	CHAR	(N' ')	Yes		ZZSTOPS	Allow NULL?
14	ZZYTEL01_ROAMIN	YTEL01 - Roaming	char	1	0	CHAR	(N' ')	Yes		ZYTEL01_ROAMIN	Allow NULL?
15	ZZAUFMENG	Order-Quantity	decimal	6	2	QUAN	((0))	Yes		ZZAUFMENG
16	ZZLASTKZ	Debit note	decimal	8	0	DEC	((0))	Yes		ZZLASTKZ
17	ZZYTEL01_ADDSER	YTEL01 - Additional Service	nvarchar	5	0	CHAR	(N' ')	Yes		ZYTEL01_ADDSER	Allow NULL?
18	ZZVERTTYP	Agreement category	nvarchar	12	0	CHAR	(N' ')	Yes		ZZVERTTYP	Allow NULL?
19	ZZUMSATZ	Total Revenue	decimal	13	2	CURR	((0))	Yes		ZZUMSATZ
20	ZZWAERS	Currency key	nvarchar	5	0	CUKY	(N' ')	Yes		ZZWAERS	Allow NULL?
21	ZTS_PRODUCT	YTEL01 - Product	nvarchar	25	0	CHAR	(N' ')	Yes		ZTS_PRODUCT	Allow NULL?
22	ZTS_EPP_L3	Strategic focused product sets	char	1	0	CHAR	(N' ')	Yes		ZTS_EPP_L3	Allow NULL?
23	ZTS_CLIENT	YTEL01 - Client	nvarchar	20	0	CHAR	(N' ')	Yes		ZTS_CLIENT	Allow NULL?
24	ZTS_MANAGER_R	YTEL01 - Manager Contract (Reporting)	nvarchar	20	0	CHAR	(N' ')	Yes		ZTS_MANAGER_R	Allow NULL?
25	ZTS_SUPPORT_R	YTEL01 - Support Rep. Contract Number (Reporting)	nvarchar	20	0	CHAR	(N' ')	Yes		ZTS_SUPPORT_R	Allow NULL?
26	ZTS_REP_R	YTEL01 - Contract of representative	nvarchar	20	0	CHAR	(N' ')	Yes		ZTS_REP_R	Allow NULL?
27	ZTS_PERFORM	Performance [%]	nvarchar	6	0	CHAR	(N' ')	Yes		ZTS_PERFORM	Allow NULL?
28	ZTS_ADJVALTOT	Total Adjusted Value	nvarchar	25	0	CHAR	(N' ')	Yes		ZTS_ADJVALTOT	Allow NULL?
29	FLG_COMPL	Indicator: Document Part Created by Complete Update	char	1	0	CHAR	(N' ')	Yes		CACSFLGCOMPL	Allow NULL?
30	FLG_REVERSED	Indicator: Row/Object/Subobject is Invalid or Reversed	char	1	0	CHAR	(N' ')	Yes		CACSFLGREV	Allow NULL?
31	STATUS_POS	Status of Object/Subobject	char	1	0	CHAR	(N' ')	Yes	TCACS_VALSTAT2	CACSSTATUSPOS	Allow NULL?
32	STATUS_WORK	Object Processing Status (Replica)	char	1	0	CHAR	(N' ')	Yes		CACSSTATUSWORKP	Allow NULL?
33	PART_POS	Position of Participation in a Commission Case	nvarchar	4	0	CHAR	(N' ')	Yes		CACSPARTID	Allow NULL?
34	INV_POS	Participant Position in a Participation	nvarchar	4	0	CHAR	(N' ')	Yes		CACSINVPOS	Allow NULL?
35	CTRTBU_ID	Commission Contract Number	nvarchar	20	0	CHAR	(N' ')	Yes		CACS_CTRTBU_ID	Allow NULL?
36	BUCAGR_ID	Agreement Number	nvarchar	12	0	CHAR	(N' ')	Yes		CACS_BUCAGR_ID	Allow NULL?
37	CLAIM_OBJTYPE	Entitlement Object Type	char	1	0	CHAR	(N' ')	Yes		CACSCLAIMOBJTYPE	Allow NULL?
38	CLAIM_OBJID	ID of Entitlement Object Acc. to Entitlement Object Type	nvarchar	30	0	CHAR	(N' ')	Yes		CACSCLAIMOBJID	Allow NULL?
39	REM_IMP_YEAR	Year Commission Case Reported	nvarchar	4	0	NUMC	(N'0000')	Yes		CACSIMPYEAR	Allow NULL?
40	REM_CASE_ID	Identification of a Case Resulting in Remuneration	nvarchar	10	0	CHAR	(N' ')	Yes		CACSREMCASEID	Allow NULL?
41	REM_CASE_VERS	Commission Case Version	nvarchar	6	0	NUMC	(N'000000')	Yes		CACSCASEVERS	Allow NULL?
42	POW_OBJ_TYPE	Subobject Type Where Activity Originates	nvarchar	5	0	CHAR	(N' ')	Yes	*	CACSPOWOBJ	Allow NULL?
43	POW_OBJ_ID	Identification of Subobject of Activity Provided	nvarchar	12	0	CHAR	(N' ')	Yes		CACSPOWOBJID	Allow NULL?
44	ACTIVITY	Activity Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	CACSACT	Allow NULL?
45	ACT_POS	Identification of an Activity Line	nvarchar	4	0	CHAR	(N' ')	Yes		CACSACTPOS	Allow NULL?
46	ACTGRP	Role	nvarchar	4	0	CHAR	(N' ')	Yes	TCACS_ACTGRP	CACSACTGRP	Allow NULL?
47	REM_OBJ_TYPE	Remunerating Subobject Type	nvarchar	5	0	CHAR	(N' ')	Yes	*	CACSREMOBJ	Allow NULL?
48	REM_OBJ_ID	Identification of Subobject Resulting in Remuneration	nvarchar	12	0	CHAR	(N' ')	Yes		CACSREMOBJID	Allow NULL?
49	VALUE	Valuation Type	nvarchar	4	0	CHAR	(N' ')	Yes	TCACS_VAL	CACSVAL	Allow NULL?
50	VALUE_TYPE	Valuation Result Category	char	1	0	NUMC	(N'0')	Yes		CACSVALTYPE	Allow NULL?
51	VALUE_POS	Valuation Row Identification	nvarchar	4	0	CHAR	(N' ')	Yes		CACSVALUEPOS	Allow NULL?
52	REMVAL_LEDAMNT	Remuneration Value in Commission Model Currency	decimal	15	2	CURR	((0))	Yes		CACSREMVALAMNT
53	REMVAL_QUAN	Remuneration Value (Volume)	decimal	11	2	QUAN	((0))	Yes		CACSREMVALQUAN
54	VALUE_UNIT	Valuation Unit	nvarchar	3	0	UNIT	(N' ')	Yes	*	CACSEVALUNIT	Allow NULL?
55	ROLE	Participant Role	nvarchar	3	0	CHAR	(N' ')	Yes	TCACS_ROLE	CACSROLE	Allow NULL?
56	ROLE_REMUSHAR	Share of Remuneration (in Percent)	decimal	10	5	DEC	((0))	Yes		CACSREMUSHARE
57	CONSTELL	Constellation of Participants	nvarchar	4	0	CHAR	(N' ')	Yes		CACSCONS	Allow NULL?
58	DIST_TYPE	Remuneration Participation Category	char	1	0	CHAR	(N' ')	Yes		CACSDISTTYPE	Allow NULL?
59	CON_CURR	Contract Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	CACSCONCURR	Allow NULL?
60	LED_CURR	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	CACSLEDCURR	Allow NULL?
61	ALLOCATION	Offsetting Selectn (Excess/Sub-Threshold Earnings, Advances)	char	1	0	CHAR	(N' ')	Yes		CACSALLOC	Allow NULL?
62	REMUNERATION	Remuneration Type	nvarchar	4	0	CHAR	(N' ')	Yes	TCACS_REM	CACSREM	Allow NULL?
63	REM_VERSION	Version of Master Data or Customizing Object	nvarchar	6	0	NUMC	(N'000000')	Yes		CACSVERSION	Allow NULL?
64	REM_RATE	Remuneration Record (For Example, Percentage)	decimal	8	3	DEC	((0))	Yes		CACSREMRATE
65	REM_CONAMNT	Remuneration Entitlement, Amount in Contract Currency	decimal	15	2	CURR	((0))	Yes		CACSREMUCONAMNT
66	DUE_CONAMNT	Remuneration Amount Ready for Disbursement in Contr Currency	decimal	15	2	CURR	((0))	Yes		CACSDUECONAMNT
67	REM_LEDAMNT	Remunerat. Entitlement, Amount in Commission Model Currency	decimal	15	2	CURR	((0))	Yes		CACSREMULEDAMNT
68	DUE_LEDAMNT	Disbursable Partial Remuner.Amount in Comm. Model Currency	decimal	15	2	CURR	((0))	Yes		CACSDUELEDAMNT
69	REM_UNIT	Remuneration Unit	nvarchar	3	0	UNIT	(N' ')	Yes	*	CACSREMUUNIT	Allow NULL?
70	REM_QUAN	Remuneration Entitlement as Quantity	decimal	11	2	QUAN	((0))	Yes		CACSREMUQUAN
71	DUE_QUAN	Remuneration Quantity Ready for Disbursement	decimal	11	2	QUAN	((0))	Yes		CACSDUEQUAN
72	OFFSET_END_DATE	End of Offsetting	nvarchar	8	0	DATS	(N'00000000')	Yes		CACSOFFSEDAT	Allow NULL?
73	OFFSET_RULE_ID	Offsetting Type	nvarchar	4	0	CHAR	(N' ')	Yes	TCACS_OFFS	CACSOFFSETRULE	Allow NULL?
74	OFFSET_CONAMNT	Remaining Offset Amount in Contract Currency	decimal	15	2	CURR	((0))	Yes		CACSOFFSCONAMNT
75	OFFSET_LEDAMNT	Offsetting/Secondary Liability Amt Remaining in ComModCurr.	decimal	15	2	CURR	((0))	Yes		CACSOFFSLEDAMNT
76	OFFSET_QUAN	Offsetting/Remaining Secondary Liability Quantity	decimal	11	2	QUAN	((0))	Yes		CACSOFFSQUAN
77	RESP_BEGIN_DATE	Liability Start	nvarchar	8	0	DATS	(N'00000000')	Yes		CACSRESPBDAT	Allow NULL?
78	RESP_END_DATE	Liability End	nvarchar	8	0	DATS	(N'00000000')	Yes		CACSRESPEDAT	Allow NULL?
79	RESP_RULE_ID	Liability Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	CACSRESPRULE	Allow NULL?
80	RESP_CONAMNT	Remaining Liability Amount in Contract Currency	decimal	15	2	CURR	((0))	Yes		CACSRESPCONAMNT
81	RESP_LEDAMNT	Remaining Liability Value in Commission Model Currency	decimal	15	2	CURR	((0))	Yes		CACSRESPLEDAMNT
82	RESP_QUAN	Remaining liability Quantity	decimal	11	2	QUAN	((0))	Yes		CACSRESPQUAN
83	RESPVAL_LEDAMNT	Remaining Liability Value in Commission Model Currency	decimal	15	2	CURR	((0))	Yes		CACSRESPVALAMNT
84	RESPVAL_QUAN	Remaining Liability Value (Quantity)	decimal	11	2	QUAN	((0))	Yes		CACSRESPVALQUAN
85	STATUS_RESP	Liability Status	char	1	0	CHAR	(N' ')	Yes		CACSSTATUSRESP	Allow NULL?
86	RESP_RUPT_BEGIN	Date of Interruption Start	nvarchar	14	0	NUMC	(N'00000000000000')	Yes		CACSRUPTDATE_B	Allow NULL?
87	RESP_RUPT_END	Date of Required End of Interruption	nvarchar	14	0	NUMC	(N'00000000000000')	Yes		CACSRUPTDATE_E	Allow NULL?
88	CORRBY_DOC_ID	Document Used to Correct This Row	nvarchar	10	0	CHAR	(N' ')	Yes		CACSCORRBYDOCID	Allow NULL?
89	CORRBY_PST_YEAR	Assignment Year Document Used for Correcting Row	nvarchar	4	0	NUMC	(N'0000')	Yes		CACSCORRBYPSTYEAR	Allow NULL?
90	CORRBY_PST_DATE	Posting Date in Commission Case/Comm Doc. (Acknowledgement)	nvarchar	8	0	DATS	(N'00000000')	Yes		CACSPSTDAT	Allow NULL?
91	CORRTO_DOC_ID	ID of Corrected Document	nvarchar	10	0	CHAR	(N' ')	Yes		CACSCORRTODOCID	Allow NULL?
92	CORRTO_PST_YEAR	Assignment Year Document That Corrected This Row	nvarchar	4	0	NUMC	(N'0000')	Yes		CACSCORRTOPSTYEAR	Allow NULL?
93	CORRTO_REMUN_POS	ID of Remuneration Row in Corrected Document	nvarchar	4	0	CHAR	(N' ')	Yes		CACSCORRTOREMUNPOS	Allow NULL?
94	FLG_CORR	Indicator: Document Part Created by a Correction	char	1	0	CHAR	(N' ')	Yes		CACSFLGCORR	Allow NULL?
95	SETTLE_GROUP	Settlement Item Grouping in Document	nvarchar	4	0	CHAR	(N' ')	Yes		CACSSETTLEGROUP	Allow NULL?

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

95 COLUMNS | 3 INDEXES | ERP 6.0 | YTEL01_DOCRE TABLE

TOP ERP 6.0 | YTEL01_DOCRE COLUMNS

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

95 COLUMNS | 3 INDEXES | ERP 6.0 | YTEL01_DOCRE TABLE

TOPERP 6.0 | YTEL01_DOCRE COLUMNS

TOPERP 6.0 | YTEL01_DOCRE INDEXES

TOP ERP 6.0 | YTEL01_DOCRE COLUMNS

TOP ERP 6.0 | YTEL01_DOCRE INDEXES