SAP ABAP Table CACS00_V_XDOCRE (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	CACS00_V_XDOCRE	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components


	Field	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	MANDT	MANDT	CLNT	3	0	Client
2	POST_YEAR	CACSPSTYEAR	KJAHR	NUMC	4	0	Assignment Year of Commission Case/Document
3	DOC_ID	CACSDOCID	CACSOBJID10	CHAR	10	0	Document Identification
4	REMUN_POS	CACSREMUNPOS	CACSDOCLINE	CHAR	4	0	ID of Remuneration Row for Referenced Document
5	VALUE_POS	CACSVALUEPOS	CACSDOCLINE	CHAR	4	0	Valuation Row Identification
6	TRI_OBJ_TYPE	CACSTRIOBJ	CACSOBTYID	CHAR	5	0	Triggering Subobject Type
7	TRI_OBJ_ID_EXT	CACSTRIOBJIDEXT	CACSOBJID36	CHAR	36	0	External Identification of Triggering Subobject
8	PART_POS	CACSPARTID	CACSDOCLINE	CHAR	4	0	Position of Participation in a Commission Case
9	INV_POS	CACSINVPOS	CACSDOCLINE	CHAR	4	0	Participant Position in a Participation
10	ROLETYPE	CACSCLAIMTYPE	CACSCLAIMTYPEDO	CHAR	1	0	Entitlement Category	TCACS_CLT
11	CLAIM_OBJTYPE	CACSCLAIMOBJTYPE	CACSCLAIMOBJTYPE	CHAR	1	0	Entitlement Object Type
12	CLAIM_OBJID	CACSCLAIMOBJID	CACSOBJID30NOCONV	CHAR	30	0	ID of Entitlement Object Acc. to Entitlement Object Type
13	INV_POS_REL	CACSINVPOS	CACSDOCLINE	CHAR	4	0	Participant Position in a Participation
14	ACT_POS	CACSACTPOS	CACSDOCLINE	CHAR	4	0	Identification of an Activity Line
15	KNW_TIMESTAMP	CACSKNOWTSTMP	CACSTIMESTAMP	NUMC	14	0	Calculation Time Stamp
16	CLC_TIMESTAMP	CACSCALCTSTMP	CACSTIMESTAMP	NUMC	14	0	Effective Time Stamp (Effective Status)
17	FLG_REVERSOR	CACSFLGREVR	FLAG	CHAR	1	0	Ind.: Object Reverses Other Object
18	DOC_TYPE	CACSDOCTYPE	CACSDOCTYPE	CHAR	1	0	Document Type of Commission Document	TCACS_DOCT
19	POST_DATE	CACSPSTDAT	DATUM	DATS	8	0	Posting Date in Commission Case/Comm Doc. (Acknowledgement)
20	POST_MONTH	CACSPSTMON	MONAT	NUMC	2	0	Period in Posting Year
21	TRI_IMP_DATE	CACSIMPDAT	DATUM	DATS	8	0	Date Commission Case Entered in Commission System
22	TRI_IMP_YEAR	CACSIMPYEAR	KJAHR	NUMC	4	0	Year Commission Case Reported
23	TRI_CASE_ID	CACSTRICASEID	CACSOBJID10	CHAR	10	0	Identification of a Triggering Case
24	TRI_CASE_VERS	CACSCASEVERS	CACSVERSION	NUMC	6	0	Commission Case Version
25	FLG_NOSETTLEMENT	CACSNOSETTLEMENT	BOOLEAN_FLG	CHAR	1	0	Ind.: Remuneration Determined Already Paid Out
26	FLG_NORESETTLE	CACSNORESETTLEMENT	BOOLEAN_FLG	CHAR	1	0	Ind.: Remuneration Cancellation Found is Already Settled
27	FLG_FUTURECHECK	CACSFUTURECHECK	BOOLEAN_FLG	CHAR	1	0	Indicator: Carry Out Check for Future Objects
28	RELEASE_DATE	CACSRELDAT	DATUM	DATS	8	0	Release Date of Operational Sys. for Commission Notification
29	TRI_CASE_TXT	CACSTRIDOCTXT	CACSSHORTTXT	CHAR	40	0	Short Text for Commission Document
30	FLG_ASYNC_DONE	CACSFLGASYNC	XFELD	CHAR	1	0	Indicator: Totals Table Provision Complete
31	ASYNC_LEVEL	CACSASYNCPRIOR	CACSPRIORITY	NUMC	2	0	Level Reached in Asynchronous Update
32	BUSOBJ_TYPE	CACSBUSOBJTYP	CACSBUSOBJTYP	CHAR	3	0	Business Object Category that Triggers Commission
33	BUSOBJ_ID	CACSBUSOBJID	CACSOBJID30	CHAR	30	0	Identification of Triggering Business Object
34	BUSOBJ_VERS	CACSBUSOBJVERS	CACSBUSOBJVERS	NUMC	14	0	Business Object Version
35	BUSOBJ_VERSDATE	CACSVERSDATE	CACSTIMESTAMP	NUMC	14	0	Date Business Object Version Starts
36	REM_BUSCASE_TYP	CACSREMBUSCASTYP	CACSBUSCASTYP	CHAR	3	0	Remunerating Business Transaction in Operational System
37	REM_BUSCASE_ID	CACSREMBUSCASEID	CACSOBJID36	CHAR	36	0	Identification of Triggering Bus. Transaction in Op. System
38	REM_BUSCASE_VERS	CACSREMBUSCASEVERS	CACSREMBUSCASEVERS	NUMC	14	0	Business Transaction Version
39	TRIGGER_SYS	CACSLOGSYSTEM	LOGSYS	CHAR	10	0	Logical Operational System
40	TRIGGER_DATE	CACSTRIDAT	DATUM	DATS	8	0	Trigger Date of Commission Case in Operational System
41	TRI_BUSCASE_TYP	CACSTRIBUSCASTYP	CACSBUSCASTYP	CHAR	3	0	Commission Triggering Business Case in Operational System
42	TRI_BUSCASE_ID	CACSTRIBUSCASEID	CACSOBJID36	CHAR	36	0	Identification of Triggering Bus. Transaction in Op. System
43	TRI_BUSCASE_VERS	CACSVERSIONLONG	CACSVERSIONLONG	NUMC	14	0	Version of Master Data or Customizing Object
44	TRGCAS_TYPE	CACS_TRGCAS_TYPE	CACS_TRGCAS_TYPE	CHAR	4	0	Reason for Additional Commission Case Being Triggered
45	TRGCASAGR_ID	CACS_TRGCASAGR_ID	NUMC12	NUMC	12	0	Identification of Additional Commission Case Agreement
46	TRGCASRU_ID	CACS_TRGCASRU_ID	NUMC12	NUMC	12	0	Rule Identification for Additional Commission Cases
47	PERIODRULE_ID	CACSPRDRULE	CACSPRDRULE	CHAR	7	0	Period Rule
48	PERIOD_NO	CACSPERIOD	NUMC6	NUMC	6	0	Period Number
49	RUN_ID	CACSBATCHID	CACSOBJID10	CHAR	10	0	Identification Number of Processing Run
50	EXT_RUN_ID	CACSBATCHEXT	CACSOBJID10	CHAR	10	0	Identification Number of External Processing Run
51	PAY_REF_ID	CACSPAYREFID	CACSPAYREFID	CHAR	10	0	Reference Number for Payment System
52	REV_DOC_ID	CACSREVDOCID	CACSOBJID10	CHAR	10	0	Document Number of Related Reversal Document
53	REV_POST_YEAR	CACSREVPOSTYEAR	KJAHR	NUMC	4	0	Posting Year of Related Reversal Document
54	LOG_HANDLE	BALLOGHNDL	SYSUUID_22	CHAR	22	0	Application Log: Log Handle
55	CHG_TIMESTAMP	CACSCHGTSTMP	CACSTIMESTAMP	NUMC	14	0	Creation Time Stamp of Object
56	CHG_TCODE	CACSCDTC	TCODE	CHAR	20	0	Transaction in Which the Change Was Made
57	CHG_USR	CACSCHUSR	USNAM	CHAR	12	0	Last user to change object
58	TRI_METH_TYP	CACSTRIMETHTYP	CACSOPTYPE	CHAR	1	0	Triggering Method
59	TRI_METH_TARGET	CACSTRIMETHTAR	CACSTRITARGET	CHAR	1	0	Processing Target of Triggering Method
60	FLG_REVERSED	CACSFLGREV	FLAG	CHAR	1	0	Indicator: Row/Object/Subobject is Invalid or Reversed
61	STATUS_POS	CACSSTATUSPOS	CACSSTATUSVERS	CHAR	1	0	Status of Object/Subobject	TCACS_VALSTAT2
62	STATUS_WORK	CACSSTATUSWORKP	CACSSTATUSWORK	CHAR	1	0	Object Processing Status (Replica)
63	REV_TIMESTAMP	CACSREVTSTMP	CACSTIMESTAMP	NUMC	14	0	Release Time Stamp of Object on Principle of Dual Control
64	REV_TCODE	CACSCDTC	TCODE	CHAR	20	0	Transaction in Which the Change Was Made
65	REV_USR	CACSREVUSR	USNAM	CHAR	12	0	User Who Released Object After Dual Checks
66	UPD_TIMESTAMP	CACSUPDTSTMP	CACSTIMESTAMP	NUMC	14	0	Last Change of Objects
67	FLG_COMPL	CACSFLGCOMPL	BOOLEAN_FLG	CHAR	1	0	Indicator: Document Part Created by Complete Update
68	CTRTBU_ID	CACS_CTRTBU_ID	ISIS_CONTRACT_ID	CHAR	20	0	Commission Contract Number
69	BUCAGR_ID	CACS_BUCAGR_ID	CHAR12	CHAR	12	0	Agreement Number
70	REM_IMP_YEAR	CACSIMPYEAR	KJAHR	NUMC	4	0	Year Commission Case Reported
71	REM_CASE_ID	CACSREMCASEID	CACSOBJID10	CHAR	10	0	Identification of a Case Resulting in Remuneration
72	REM_CASE_VERS	CACSCASEVERS	CACSVERSION	NUMC	6	0	Commission Case Version
73	POW_OBJ_TYPE	CACSPOWOBJ	CACSOBTYID	CHAR	5	0	Subobject Type Where Activity Originates
74	POW_OBJ_ID	CACSPOWOBJID	CACSOBJID12	CHAR	12	0	Identification of Subobject of Activity Provided
75	ACTIVITY	CACSACT	CACSACT	CHAR	4	0	Activity Type
76	ACTGRP	CACSACTGRP	CACSACTGRP	CHAR	4	0	Role	TCACS_ACTGRP
77	REM_OBJ_TYPE	CACSREMOBJ	CACSOBTYID	CHAR	5	0	Remunerating Subobject Type
78	REM_OBJ_ID	CACSREMOBJID	CACSOBJID12	CHAR	12	0	Identification of Subobject Resulting in Remuneration
79	VALUE_TYPE	CACSVALTYPE	CACSVALTYPE	NUMC	1	0	Valuation Result Category
80	REMVAL_LEDAMNT	CACSREMVALAMNT	CACSAMNTITEM	CURR	15	2	Remuneration Value in Commission Model Currency
81	REMVAL_QUAN	CACSREMVALQUAN	CACSEVALQUAN	QUAN	11	2	Remuneration Value (Volume)
82	VALUE_UNIT	CACSEVALUNIT	MEINS	UNIT	3	0	Valuation Unit
83	ROLE	CACSROLE	CACSROLE	CHAR	3	0	Participant Role	TCACS_ROLE
84	ROLE_REMUSHAR	CACSREMUSHARE	CACSPERCENT5	DEC	10	5	Share of Remuneration (in Percent)
85	CONSTELL	CACSCONS	CHAR4	CHAR	4	0	Constellation of Participants
86	DIST_TYPE	CACSDISTTYPE	CACSDISTTYPE	CHAR	1	0	Remuneration Participation Category
87	CON_CURR	CACSCONCURR	WAERS	CUKY	5	0	Contract Currency Key	TCURC
88	LED_CURR	CACSLEDCURR	WAERS	CUKY	5	0	Currency Key	TCURC
89	ALLOCATION	CACSALLOC	CACSALLOC	CHAR	1	0	Offsetting Selectn (Excess/Sub-Threshold Earnings, Advances)
90	REMUNERATION	CACSREM	CACSREM	CHAR	4	0	Remuneration Type	TCACS_REM
91	REM_VERSION	CACSVERSION	CACSVERSION	NUMC	6	0	Version of Master Data or Customizing Object
92	REM_RATE	CACSREMRATE	CACSPERCENT	DEC	8	3	Remuneration Record (For Example, Percentage)
93	REM_CONAMNT	CACSREMUCONAMNT	CACSAMNTITEM	CURR	15	2	Remuneration Entitlement, Amount in Contract Currency
94	DUE_CONAMNT	CACSDUECONAMNT	CACSAMNTITEM	CURR	15	2	Remuneration Amount Ready for Disbursement in Contr Currency
95	REM_LEDAMNT	CACSREMULEDAMNT	CACSAMNTITEM	CURR	15	2	Remunerat. Entitlement, Amount in Commission Model Currency
96	DUE_LEDAMNT	CACSDUELEDAMNT	CACSAMNTITEM	CURR	15	2	Disbursable Partial Remuner.Amount in Comm. Model Currency
97	REM_UNIT	CACSREMUUNIT	MEINS	UNIT	3	0	Remuneration Unit
98	REM_QUAN	CACSREMUQUAN	CACSREMUQUAN	QUAN	11	2	Remuneration Entitlement as Quantity
99	DUE_QUAN	CACSDUEQUAN	CACSREMUQUAN	QUAN	11	2	Remuneration Quantity Ready for Disbursement
100	OFFSET_END_DATE	CACSOFFSEDAT	DATUM	DATS	8	0	End of Offsetting
101	OFFSET_RULE_ID	CACSOFFSETRULE	CACSOFFSETRULE	CHAR	4	0	Offsetting Type	TCACS_OFFS
102	OFFSET_CONAMNT	CACSOFFSCONAMNT	CACSAMNTITEM	CURR	15	2	Remaining Offset Amount in Contract Currency
103	OFFSET_LEDAMNT	CACSOFFSLEDAMNT	CACSAMNTITEM	CURR	15	2	Offsetting/Secondary Liability Amt Remaining in ComModCurr.
104	OFFSET_QUAN	CACSOFFSQUAN	CACSRESPQUAN	QUAN	11	2	Offsetting/Remaining Secondary Liability Quantity
105	CORRBY_DOC_ID	CACSCORRBYDOCID	CACSOBJID10	CHAR	10	0	Document Used to Correct This Row
106	CORRBY_PST_YEAR	CACSCORRBYPSTYEAR	KJAHR	NUMC	4	0	Assignment Year Document Used for Correcting Row
107	CORRBY_PST_DATE	CACSPSTDAT	DATUM	DATS	8	0	Posting Date in Commission Case/Comm Doc. (Acknowledgement)
108	CORRTO_DOC_ID	CACSCORRTODOCID	CACSOBJID10	CHAR	10	0	ID of Corrected Document
109	CORRTO_PST_YEAR	CACSCORRTOPSTYEAR	KJAHR	NUMC	4	0	Assignment Year Document That Corrected This Row
110	CORRTO_REMUN_POS	CACSCORRTOREMUNPOS	CACSDOCLINE	CHAR	4	0	ID of Remuneration Row in Corrected Document
111	FLG_CORR	CACSFLGCORR	BOOLEAN_FLG	CHAR	1	0	Indicator: Document Part Created by a Correction
112	SETTLE_GROUP	CACSSETTLEGROUP	CACSDOCLINE	CHAR	4	0	Settlement Item Grouping in Document
113	TRI_OBJ_ID	CACSTRIOBJID	CACSOBJID12	CHAR	12	0	Identification of Triggering Subobject
114	VALUE	CACSVAL	CACSVAL	CHAR	4	0	Valuation Type	TCACS_VAL
115	VALUE_VERSION	CACSVERSION	CACSVERSION	NUMC	6	0	Version of Master Data or Customizing Object
116	VALUE_QUAN	CACSEVALQUAN	CACSEVALQUAN	QUAN	11	2	Valuation Quantity
117	DVALUE_QUAN	CACSEVALDQUAN	CACSEVALQUAN	QUAN	11	2	Valuation Quantity Change
118	VALUE_AMNT	CACSVALAMNT	CACSAMNTITEM	CURR	15	2	Valuation Amount in Commission Model Currency
119	DVALUE_AMNT	CACSVALDAMNT	CACSAMNTITEM	CURR	15	2	Valuation Amount Change in Commission Model Currency
120	STATUS_VAL	CACSSTATUSVAL	CACSSTATUSVAL	CHAR	1	0	Valuation Status
121	VALUE_AMNT_RUPT	CACSVALAMNTRUPT	CACSAMNTITEM	CURR	15	2	Interrupted Valuation Amount in Commission Model Currency
122	VALUE_QUAN_RUPT	CACSEVALQUANRUPT	CACSEVALQUAN	QUAN	11	2	Interrupted Valuation Quantity
123	PARENT_TYPE	CACSPARTRIOBJ	CACSOBTYID	CHAR	5	0	Higher-Level Subobject That Triggers Commission
124	PARENT_ID	CACSPARTRIOBJID	CACSOBJID12	CHAR	12	0	Internal Identification of Higher-Level Subobject
125	ROLE_COMMSHAR	CACSCOMMSHARE	CACSPERCENT5	DEC	10	5	Share of Direct Remuneration (in Percent)
126	ROLE_PRODSHAR	CACSPRODSHARE	CACSPERCENT5	DEC	10	5	Share of Indirect Remuneration (in Percent)
127	INV_POS_PARENT	CACSINVPOSPARENT	CACSDOCLINE	CHAR	4	0	Position of a Higher-Level Participant in a Participation

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column

1	CACS00_V_XDOCRE	ACTGRP	TCACS_ACTGRP	ACTGRP
2	CACS00_V_XDOCRE	CON_CURR	TCURC	WAERS
3	CACS00_V_XDOCRE	DOC_TYPE	TCACS_DOCT	DOC_TYPE
4	CACS00_V_XDOCRE	LED_CURR	TCURC	WAERS
5	CACS00_V_XDOCRE	OFFSET_RULE_ID	TCACS_OFFS	OFFSET_RULE_ID
6	CACS00_V_XDOCRE	REMUNERATION	TCACS_REM	REMUNERATION
7	CACS00_V_XDOCRE	ROLE	TCACS_ROLE	ROLE
8	CACS00_V_XDOCRE	ROLETYPE	TCACS_CLT	CLAIMOBJTYPE
9	CACS00_V_XDOCRE	STATUS_POS	TCACS_VALSTAT2	STATUS_POS
10	CACS00_V_XDOCRE	VALUE	TCACS_VAL	VALUE