SAP ABAP Table CACS00_SIS_DOCRE (Commission Docs, Remuneration and Doc.Header for Drilldown)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ ICM (Application Component) Incentive and Commission Management (ICM)
     ⤷ CACSCC (Package) ICM: Commission Case 'Light'

Basic Data

Table Category	INTTAB	Structure
Structure	CACS00_SIS_DOCRE	Table Relationship Diagram
Short Description	Commission Docs, Remuneration and Doc.Header for Drilldown

Delivery and Maintenance

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

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLU-_H	☐				0	0	Commission Document Header
2	.INCLUDE	☐				0	0	Commission Document Header (Key)
3	MANDT_H	☐	MANDT	MANDT	CLNT	3	0	Client	*
4	POST_YEAR_H	☐	CACSPSTYEAR	KJAHR	NUMC	4	0	Assignment Year of Commission Case/Document
5	DOC_ID_H	☐	CACSDOCID	CACSOBJID10	CHAR	10	0	Document Identification
6	.INCLUDE	☐				0	0	Access time stamp for Customizing and master data in context
7	KNW_TIMESTAMP_H	☐	CACSKNOWTSTMP	CACSTIMESTAMP	NUMC	14	0	Calculation Time Stamp
8	CLC_TIMESTAMP_H	☐	CACSCALCTSTMP	CACSTIMESTAMP	NUMC	14	0	Effective Time Stamp (Effective Status)
9	.INCLUDE	☐				0	0	Commission Document Header (Data)
10	FLG_REVERSOR_H	☐	CACSFLGREVR	FLAG	CHAR	1	0	Ind.: Object Reverses Other Object
11	DOC_TYPE_H	☐	CACSDOCTYPE	CACSDOCTYPE	CHAR	1	0	Document Type of Commission Document	TCACS_DOCT
12	POST_DATE_H	☐	CACSPSTDAT	DATUM	DATS	8	0	Posting Date in Commission Case/Comm Doc. (Acknowledgement)
13	POST_MONTH_H	☐	CACSPSTMON	MONAT	NUMC	2	0	Period in Posting Year
14	.INCLUDE	☐				0	0	Commission case information
15	TRI_IMP_DATE_H	☐	CACSIMPDAT	DATUM	DATS	8	0	Date Commission Case Entered in Commission System
16	TRI_IMP_YEAR_H	☐	CACSIMPYEAR	KJAHR	NUMC	4	0	Year Commission Case Reported
17	TRI_CASE_ID_H	☐	CACSTRICASEID	CACSOBJID10	CHAR	10	0	Identification of a Triggering Case
18	TRI_CASE_VERS_H	☐	CACSCASEVERS	CACSVERSION	NUMC	6	0	Commission Case Version
19	FLG_NOSETTLEMENT_H	☐	CACSNOSETTLEMENT	BOOLEAN_FLG	CHAR	1	0	Ind.: Remuneration Determined Already Paid Out
20	FLG_NORESETTLE_H	☐	CACSNORESETTLEMENT	BOOLEAN_FLG	CHAR	1	0	Ind.: Remuneration Cancellation Found is Already Settled
21	FLG_FUTURECHECK_H	☐	CACSFUTURECHECK	BOOLEAN_FLG	CHAR	1	0	Indicator: Carry Out Check for Future Objects
22	RELEASE_DATE_H	☐	CACSRELDAT	DATUM	DATS	8	0	Release Date of Operational Sys. for Commission Notification
23	TRI_CASE_TXT_H	☐	CACSTRIDOCTXT	CACSSHORTTXT	CHAR	40	0	Short Text for Commission Document
24	FLG_ASYNC_DONE_H	☐	CACSFLGASYNC	XFELD	CHAR	1	0	Indicator: Totals Table Provision Complete
25	ASYNC_LEVEL_H	☐	CACSASYNCPRIOR	CACSPRIORITY	NUMC	2	0	Level Reached in Asynchronous Update
26	.INCLUDE	☐				0	0	Business Transaction Identification
27	BUSOBJ_TYPE_H	☐	CACSBUSOBJTYP	CACSBUSOBJTYP	CHAR	3	0	Business Object Category that Triggers Commission	*
28	BUSOBJ_ID_H	☐	CACSBUSOBJID	CACSOBJID30	CHAR	30	0	Identification of Triggering Business Object
29	BUSOBJ_VERS_H	☐	CACSBUSOBJVERS	CACSBUSOBJVERS	NUMC	14	0	Business Object Version
30	BUSOBJ_VERSDATE_H	☐	CACSVERSDATE	CACSTIMESTAMP	NUMC	14	0	Date Business Object Version Starts
31	REM_BUSCASE_TYP_H	☐	CACSREMBUSCASTYP	CACSBUSCASTYP	CHAR	3	0	Remunerating Business Transaction in Operational System	*
32	REM_BUSCASE_ID_H	☐	CACSREMBUSCASEID	CACSOBJID36	CHAR	36	0	Identification of Triggering Bus. Transaction in Op. System
33	REM_BUSCASE_VERS_H	☐	CACSREMBUSCASEVERS	CACSREMBUSCASEVERS	NUMC	14	0	Business Transaction Version
34	LED_CURR_H	☐	CACSLEDCURR	WAERS	CUKY	5	0	Currency Key	*
35	.INCLUDE	☐				0	0	Description of Commission Case Trigger
36	TRIGGER_SYS_H	☐	CACSLOGSYSTEM	LOGSYS	CHAR	10	0	Logical Operational System	*
37	TRIGGER_DATE_H	☐	CACSTRIDAT	DATUM	DATS	8	0	Trigger Date of Commission Case in Operational System
38	TRI_BUSCASE_TYP_H	☐	CACSTRIBUSCASTYP	CACSBUSCASTYP	CHAR	3	0	Commission Triggering Business Case in Operational System	*
39	TRI_BUSCASE_ID_H	☐	CACSTRIBUSCASEID	CACSOBJID36	CHAR	36	0	Identification of Triggering Bus. Transaction in Op. System
40	TRI_BUSCASE_VERS_H	☐	CACSVERSIONLONG	CACSVERSIONLONG	NUMC	14	0	Version of Master Data or Customizing Object
41	TRGCAS_TYPE_H	☐	CACS_TRGCAS_TYPE	CACS_TRGCAS_TYPE	CHAR	4	0	Reason for Additional Commission Case Being Triggered	*
42	TRGCASAGR_ID_H	☐	CACS_TRGCASAGR_ID	NUMC12	NUMC	12	0	Identification of Additional Commission Case Agreement
43	TRGCASRU_ID_H	☐	CACS_TRGCASRU_ID	NUMC12	NUMC	12	0	Rule Identification for Additional Commission Cases
44	PERIODRULE_ID_H	☐	CACSPRDRULE	CACSPRDRULE	CHAR	7	0	Period Rule
45	PERIOD_NO_H	☐	CACSPERIOD	NUMC6	NUMC	6	0	Period Number
46	RUN_ID_H	☐	CACSBATCHID	CACSOBJID10	CHAR	10	0	Identification Number of Processing Run
47	EXT_RUN_ID_H	☐	CACSBATCHEXT	CACSOBJID10	CHAR	10	0	Identification Number of External Processing Run
48	.INCLUDE	☐				0	0	Reference Number in Payment System
49	PAY_REF_ID_H	☐	CACSPAYREFID	CACSPAYREFID	CHAR	10	0	Reference Number for Payment System
50	.INCLUDE	☐				0	0	Commissions: Reversal Information for Document Header
51	REV_DOC_ID_H	☐	CACSREVDOCID	CACSOBJID10	CHAR	10	0	Document Number of Related Reversal Document
52	REV_POST_YEAR_H	☐	CACSREVPOSTYEAR	KJAHR	NUMC	4	0	Posting Year of Related Reversal Document
53	LOG_HANDLE_H	☐	BALLOGHNDL	SYSUUID_22	CHAR	22	0	Application Log: Log Handle
54	.INCLUDE	☐				0	0	Status Management for Document Data (Using Header Structure)
55	CHG_TIMESTAMP_H	☐	CACSCHGTSTMP	CACSTIMESTAMP	NUMC	14	0	Creation Time Stamp of Object
56	.INCLUDE	☐				0	0	Comn: Process Management
57	.INCLUDE	☐				0	0	Change Log for Object
58	CHG_TCODE_H	☐	CACSCDTC	TCODE	CHAR	20	0	Transaction in Which the Change Was Made	*
59	CHG_USR_H	☐	CACSCHUSR	USNAM	CHAR	12	0	Last user to change object
60	TRI_METH_TYP_H	☐	CACSTRIMETHTYP	CACSOPTYPE	CHAR	1	0	Triggering Method
61	TRI_METH_TARGET_H	☐	CACSTRIMETHTAR	CACSTRITARGET	CHAR	1	0	Processing Target of Triggering Method
62	.INCLUDE	☐				0	0	Status Management for Document Data Items
63	FLG_REVERSED_H	☐	CACSFLGREV	FLAG	CHAR	1	0	Indicator: Row/Object/Subobject is Invalid or Reversed
64	STATUS_POS_H	☐	CACSSTATUSPOS	CACSSTATUSVERS	CHAR	1	0	Status of Object/Subobject	TCACS_VALSTAT2
65	STATUS_WORK_H	☐	CACSSTATUSWORKP	CACSSTATUSWORK	CHAR	1	0	Object Processing Status (Replica)	*
66	.INCLUDE	☐				0	0	Change Log Double Check for Object
67	REV_TIMESTAMP_H	☐	CACSREVTSTMP	CACSTIMESTAMP	NUMC	14	0	Release Time Stamp of Object on Principle of Dual Control
68	REV_TCODE_H	☐	CACSCDTC	TCODE	CHAR	20	0	Transaction in Which the Change Was Made	*
69	REV_USR_H	☐	CACSREVUSR	USNAM	CHAR	12	0	User Who Released Object After Dual Checks
70	.INCLUDE	☐				0	0	Last Changes to Objects
71	UPD_TIMESTAMP_H	☐	CACSUPDTSTMP	CACSTIMESTAMP	NUMC	14	0	Last Change of Objects
72	.INCLU-_R	☐				0	0	Commission Document, Remuneration and Liability
73	.INCLUDE	☐				0	0	Commission Document, Remuneration and Liability (Key)
74	.INCLUDE	☐				0	0	Commission Document Header (Key)
75	MANDT_R	☐	MANDT	MANDT	CLNT	3	0	Client	*
76	POST_YEAR_R	☐	CACSPSTYEAR	KJAHR	NUMC	4	0	Assignment Year of Commission Case/Document
77	DOC_ID_R	☐	CACSDOCID	CACSOBJID10	CHAR	10	0	Document Identification
78	REMUN_POS_R	☐	CACSREMUNPOS	CACSDOCLINE	CHAR	4	0	ID of Remuneration Row for Referenced Document
79	.INCLUDE	☐				0	0	Commission Document, Remuneration and Liability (Data)
80	FLG_COMPL_R	☐	CACSFLGCOMPL	BOOLEAN_FLG	CHAR	1	0	Indicator: Document Part Created by Complete Update
81	.INCLUDE	☐				0	0	Status Management for Document Data Items
82	FLG_REVERSED_R	☐	CACSFLGREV	FLAG	CHAR	1	0	Indicator: Row/Object/Subobject is Invalid or Reversed
83	STATUS_POS_R	☐	CACSSTATUSPOS	CACSSTATUSVERS	CHAR	1	0	Status of Object/Subobject	TCACS_VALSTAT2
84	STATUS_WORK_R	☐	CACSSTATUSWORKP	CACSSTATUSWORK	CHAR	1	0	Object Processing Status (Replica)	*
85	PART_POS_R	☐	CACSPARTID	CACSDOCLINE	CHAR	4	0	Position of Participation in a Commission Case
86	INV_POS_R	☐	CACSINVPOS	CACSDOCLINE	CHAR	4	0	Participant Position in a Participation
87	CTRTBU_ID_R	☐	CACS_CTRTBU_ID	ISIS_CONTRACT_ID	CHAR	20	0	Commission Contract Number
88	BUCAGR_ID_R	☐	CACS_BUCAGR_ID	CHAR12	CHAR	12	0	Agreement Number
89	CLAIM_OBJTYPE_R	☐	CACSCLAIMOBJTYPE	CACSCLAIMOBJTYPE	CHAR	1	0	Entitlement Object Type
90	CLAIM_OBJID_R	☐	CACSCLAIMOBJID	CACSOBJID30NOCONV	CHAR	30	0	ID of Entitlement Object Acc. to Entitlement Object Type
91	REM_IMP_YEAR_R	☐	CACSIMPYEAR	KJAHR	NUMC	4	0	Year Commission Case Reported
92	REM_CASE_ID_R	☐	CACSREMCASEID	CACSOBJID10	CHAR	10	0	Identification of a Case Resulting in Remuneration
93	REM_CASE_VERS_R	☐	CACSCASEVERS	CACSVERSION	NUMC	6	0	Commission Case Version
94	POW_OBJ_TYPE_R	☐	CACSPOWOBJ	CACSOBTYID	CHAR	5	0	Subobject Type Where Activity Originates	*
95	POW_OBJ_ID_R	☐	CACSPOWOBJID	CACSOBJID12	CHAR	12	0	Identification of Subobject of Activity Provided
96	ACTIVITY_R	☐	CACSACT	CACSACT	CHAR	4	0	Activity Type	*
97	ACT_POS_R	☐	CACSACTPOS	CACSDOCLINE	CHAR	4	0	Identification of an Activity Line
98	ACTGRP_R	☐	CACSACTGRP	CACSACTGRP	CHAR	4	0	Role	TCACS_ACTGRP
99	REM_OBJ_TYPE_R	☐	CACSREMOBJ	CACSOBTYID	CHAR	5	0	Remunerating Subobject Type	*
100	REM_OBJ_ID_R	☐	CACSREMOBJID	CACSOBJID12	CHAR	12	0	Identification of Subobject Resulting in Remuneration
101	VALUE_R	☐	CACSVAL	CACSVAL	CHAR	4	0	Valuation Type	TCACS_VAL
102	VALUE_TYPE_R	☐	CACSVALTYPE	CACSVALTYPE	NUMC	1	0	Valuation Result Category
103	VALUE_POS_R	☐	CACSVALUEPOS	CACSDOCLINE	CHAR	4	0	Valuation Row Identification
104	REMVAL_LEDAMNT_R	☐	CACSREMVALAMNT	CACSAMNTITEM	CURR	15	2	Remuneration Value in Commission Model Currency
105	REMVAL_QUAN_R	☐	CACSREMVALQUAN	CACSEVALQUAN	QUAN	11	2	Remuneration Value (Volume)
106	VALUE_UNIT_R	☐	CACSEVALUNIT	MEINS	UNIT	3	0	Valuation Unit	*
107	ROLE_R	☐	CACSROLE	CACSROLE	CHAR	3	0	Participant Role	TCACS_ROLE
108	ROLE_REMUSHAR_R	☐	CACSREMUSHARE	CACSPERCENT5	DEC	10	5	Share of Remuneration (in Percent)
109	CONSTELL_R	☐	CACSCONS	CHAR4	CHAR	4	0	Constellation of Participants
110	DIST_TYPE_R	☐	CACSDISTTYPE	CACSDISTTYPE	CHAR	1	0	Remuneration Participation Category
111	CON_CURR_R	☐	CACSCONCURR	WAERS	CUKY	5	0	Contract Currency Key	TCURC
112	LED_CURR_R	☐	CACSLEDCURR	WAERS	CUKY	5	0	Currency Key	TCURC
113	ALLOCATION_R	☐	CACSALLOC	CACSALLOC	CHAR	1	0	Offsetting Selectn (Excess/Sub-Threshold Earnings, Advances)
114	REMUNERATION_R	☐	CACSREM	CACSREM	CHAR	4	0	Remuneration Type	TCACS_REM
115	REM_VERSION_R	☐	CACSVERSION	CACSVERSION	NUMC	6	0	Version of Master Data or Customizing Object
116	REM_RATE_R	☐	CACSREMRATE	CACSPERCENT	DEC	8	3	Remuneration Record (For Example, Percentage)
117	REM_CONAMNT_R	☐	CACSREMUCONAMNT	CACSAMNTITEM	CURR	15	2	Remuneration Entitlement, Amount in Contract Currency
118	DUE_CONAMNT_R	☐	CACSDUECONAMNT	CACSAMNTITEM	CURR	15	2	Remuneration Amount Ready for Disbursement in Contr Currency
119	REM_LEDAMNT_R	☐	CACSREMULEDAMNT	CACSAMNTITEM	CURR	15	2	Remunerat. Entitlement, Amount in Commission Model Currency
120	DUE_LEDAMNT_R	☐	CACSDUELEDAMNT	CACSAMNTITEM	CURR	15	2	Disbursable Partial Remuner.Amount in Comm. Model Currency
121	REM_UNIT_R	☐	CACSREMUUNIT	MEINS	UNIT	3	0	Remuneration Unit	*
122	REM_QUAN_R	☐	CACSREMUQUAN	CACSREMUQUAN	QUAN	11	2	Remuneration Entitlement as Quantity
123	DUE_QUAN_R	☐	CACSDUEQUAN	CACSREMUQUAN	QUAN	11	2	Remuneration Quantity Ready for Disbursement
124	OFFSET_END_DATE_R	☐	CACSOFFSEDAT	DATUM	DATS	8	0	End of Offsetting
125	OFFSET_RULE_ID_R	☐	CACSOFFSETRULE	CACSOFFSETRULE	CHAR	4	0	Offsetting Type	TCACS_OFFS
126	OFFSET_CONAMNT_R	☐	CACSOFFSCONAMNT	CACSAMNTITEM	CURR	15	2	Remaining Offset Amount in Contract Currency
127	OFFSET_LEDAMNT_R	☐	CACSOFFSLEDAMNT	CACSAMNTITEM	CURR	15	2	Offsetting/Secondary Liability Amt Remaining in ComModCurr.
128	OFFSET_QUAN_R	☐	CACSOFFSQUAN	CACSRESPQUAN	QUAN	11	2	Offsetting/Remaining Secondary Liability Quantity
129	CORRBY_DOC_ID_R	☐	CACSCORRBYDOCID	CACSOBJID10	CHAR	10	0	Document Used to Correct This Row
130	CORRBY_PST_YEAR_R	☐	CACSCORRBYPSTYEAR	KJAHR	NUMC	4	0	Assignment Year Document Used for Correcting Row
131	CORRBY_PST_DATE_R	☐	CACSPSTDAT	DATUM	DATS	8	0	Posting Date in Commission Case/Comm Doc. (Acknowledgement)
132	CORRTO_DOC_ID_R	☐	CACSCORRTODOCID	CACSOBJID10	CHAR	10	0	ID of Corrected Document
133	CORRTO_PST_YEAR_R	☐	CACSCORRTOPSTYEAR	KJAHR	NUMC	4	0	Assignment Year Document That Corrected This Row
134	CORRTO_REMUN_POS_R	☐	CACSCORRTOREMUNPOS	CACSDOCLINE	CHAR	4	0	ID of Remuneration Row in Corrected Document
135	FLG_CORR_R	☐	CACSFLGCORR	BOOLEAN_FLG	CHAR	1	0	Indicator: Document Part Created by a Correction
136	SETTLE_GROUP_R	☐	CACSSETTLEGROUP	CACSDOCLINE	CHAR	4	0	Settlement Item Grouping in Document
137	.INCLUDE	☐				0	0	Last Changes to Objects
138	UPD_TIMESTAMP_R	☐	CACSUPDTSTMP	CACSTIMESTAMP	NUMC	14	0	Last Change of Objects
139	AUTHORITY_CHECK	☐	CACSAUTHFLAG	CHOICE	CHAR	1	0	Indicator: Authorization Check on Contract Number?

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CACS00_SIS_DOCRE	ACTGRP_R	TCACS_ACTGRP	ACTGRP
2	CACS00_SIS_DOCRE	CON_CURR_R	TCURC	WAERS
3	CACS00_SIS_DOCRE	DOC_TYPE_H	TCACS_DOCT	DOC_TYPE
4	CACS00_SIS_DOCRE	LED_CURR_R	TCURC	WAERS
5	CACS00_SIS_DOCRE	OFFSET_RULE_ID_R	TCACS_OFFS	OFFSET_RULE_ID
6	CACS00_SIS_DOCRE	REMUNERATION_R	TCACS_REM	REMUNERATION
7	CACS00_SIS_DOCRE	ROLE_R	TCACS_ROLE	ROLE
8	CACS00_SIS_DOCRE	STATUS_POS_H	TCACS_VALSTAT2	STATUS_POS
9	CACS00_SIS_DOCRE	STATUS_POS_R	TCACS_VALSTAT2	STATUS_POS
10	CACS00_SIS_DOCRE	VALUE_R	TCACS_VAL	VALUE

History

Last changed by/on	SAP	20131127
SAP Release Created in	462