SAP ABAP Table CACS_S_BW_DOCRE (Commissions: Extraction Structure for Remuneration Row)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ ICM (Application Component) Incentive and Commission Management (ICM)
     ⤷ CACSBW (Package) Commissions: Business Warehouse

Basic Data

Table Category	INTTAB	Structure
Structure	CACS_S_BW_DOCRE	Table Relationship Diagram
Short Description	Commissions: Extraction Structure for Remuneration Row

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	MANDT_H	☐	MANDT	MANDT	CLNT	3	0	Client	*
2	APPL	☐	CACSAPPL	CACSAPPL	CHAR	6	0	Commission Application (ICM)	*
3	POST_YEAR_H	☐	CACSPSTYEAR	KJAHR	NUMC	4	0	Assignment Year of Commission Case/Document
4	DOC_ID_H	☐	CACSDOCID	CACSOBJID10	CHAR	10	0	Document Identification
5	FLG_REVERSOR_H	☐	CACSFLGREVR	FLAG	CHAR	1	0	Ind.: Object Reverses Other Object
6	DOC_TYPE_H	☐	CACSDOCTYPE	CACSDOCTYPE	CHAR	1	0	Document Type of Commission Document	TCACS_DOCT
7	POST_DATE_H	☐	CACSPSTDAT	DATUM	DATS	8	0	Posting Date in Commission Case/Comm Doc. (Acknowledgement)
8	POST_MONTH_H	☐	CACSPSTMON	MONAT	NUMC	2	0	Period in Posting Year
9	CLC_DATE_H	☐	CACSCALCDAT	DATUM	DATS	8	0	Effective Date of a Document/Case (Effective Status)
10	CLC_TIME_H	☐	CACSCALCTIM	UZEIT	TIMS	6	0	Effective Time of a Document/Case (Effective Status)
11	KNW_DATE_H	☐	CACSKNOWDAT	DATUM	DATS	8	0	Calculation Date of Document/Case (Knowledge Status)
12	KNW_TIME_H	☐	CACSKNOWTIM	UZEIT	TIMS	6	0	Calculation Time Document/Case (Knowledge Status)
13	TRI_IMP_DATE_H	☐	CACSIMPDAT	DATUM	DATS	8	0	Date Commission Case Entered in Commission System
14	TRI_CASE_ID_H	☐	CACSTRICASEID	CACSOBJID10	CHAR	10	0	Identification of a Triggering Case
15	TRI_CASE_VERS_H	☐	CACSCASEVERS	CACSVERSION	NUMC	6	0	Commission Case Version
16	TRI_CASE_TXT_H	☐	CACSTRIDOCTXT	CACSSHORTTXT	CHAR	40	0	Short Text for Commission Document
17	FLG_NOSETTLEMENT_H	☐	CACSNOSETTLEMENT	BOOLEAN_FLG	CHAR	1	0	Ind.: Remuneration Determined Already Paid Out
18	FLG_NORESETTLE_H	☐	CACSNORESETTLEMENT	BOOLEAN_FLG	CHAR	1	0	Ind.: Remuneration Cancellation Found is Already Settled
19	FLG_FUTURECHECK_H	☐	CACSFUTURECHECK	BOOLEAN_FLG	CHAR	1	0	Indicator: Carry Out Check for Future Objects
20	FLG_ASYNC_DONE_H	☐	CACSFLGASYNC	XFELD	CHAR	1	0	Indicator: Totals Table Provision Complete
21	RELEASE_DATE_H	☐	CACSRELDAT	DATUM	DATS	8	0	Release Date of Operational Sys. for Commission Notification
22	BUSOBJ_TYPE_H	☐	CACSBUSOBJTYP	CACSBUSOBJTYP	CHAR	3	0	Business Object Category that Triggers Commission	*
23	BUSOBJ_ID_H	☐	CACSBUSOBJID	CACSOBJID30	CHAR	30	0	Identification of Triggering Business Object
24	BUSOBJ_VERS_H	☐	CACSVERSIONLONG	CACSVERSIONLONG	NUMC	14	0	Version of Master Data or Customizing Object
25	BUSOBJ_VERSDATE_H	☐	CACSVERSDATE	CACSTIMESTAMP	NUMC	14	0	Date Business Object Version Starts
26	REM_BUSCASE_TYP_H	☐	CACSREMBUSCASTYP	CACSBUSCASTYP	CHAR	3	0	Remunerating Business Transaction in Operational System	*
27	REM_BUSCASE_ID_H	☐	CACSREMBUSCASEID	CACSOBJID36	CHAR	36	0	Identification of Triggering Bus. Transaction in Op. System
28	REM_BUSCASE_VERS_H	☐	CACSVERSIONLONG	CACSVERSIONLONG	NUMC	14	0	Version of Master Data or Customizing Object
29	LED_CURR_H	☐	CACSLEDCURR	WAERS	CUKY	5	0	Currency Key	TCURC
30	REV_DOC_ID_H	☐	CACSREVDOCID	CACSOBJID10	CHAR	10	0	Document Number of Related Reversal Document
31	REV_POST_YEAR_H	☐	CACSREVPOSTYEAR	KJAHR	NUMC	4	0	Posting Year of Related Reversal Document
32	CHG_DATE_H	☐	CACSCHGDAT	DATUM	DATS	8	0	Date on Which Object was Created
33	CHG_TIME_H	☐	CACSCHGTIM	UZEIT	TIMS	6	0	Time at Which Object was Created
34	FLG_REVERSED_H	☐	CACSFLGREV	FLAG	CHAR	1	0	Indicator: Row/Object/Subobject is Invalid or Reversed
35	STATUS_POS_H	☐	CACSSTATUSPOS	CACSSTATUSVERS	CHAR	1	0	Status of Object/Subobject	TCACS_VALSTAT2
36	STATUS_WORK_H	☐	CACSSTATUSPOSWORK	CACSSTATUSWORK	CHAR	1	0	Processing Status of an Object Item	TCACS_VALSTAT2
37	POST_YEAR_R	☐	CACSPSTYEAR	KJAHR	NUMC	4	0	Assignment Year of Commission Case/Document
38	DOC_ID_R	☐	CACSDOCID	CACSOBJID10	CHAR	10	0	Document Identification
39	REMUN_POS_R	☐	CACSREMUNPOS	CACSDOCLINE	CHAR	4	0	ID of Remuneration Row for Referenced Document
40	FLG_REVERSED_R	☐	CACSFLGREV	FLAG	CHAR	1	0	Indicator: Row/Object/Subobject is Invalid or Reversed
41	STATUS_POS_R	☐	CACSSTATUSPOS	CACSSTATUSVERS	CHAR	1	0	Status of Object/Subobject	TCACS_VALSTAT2
42	STATUS_WORK_R	☐	CACSSTATUSPOSWORK	CACSSTATUSWORK	CHAR	1	0	Processing Status of an Object Item	TCACS_VALSTAT2
43	PART_POS_R	☐	CACSPARTID	CACSDOCLINE	CHAR	4	0	Position of Participation in a Commission Case
44	INV_POS_R	☐	CACSINVPOS	CACSDOCLINE	CHAR	4	0	Participant Position in a Participation
45	CTRTBU_ID_R	☐	CACS_CTRTBU_ID	ISIS_CONTRACT_ID	CHAR	20	0	Commission Contract Number
46	REM_IMP_YEAR_R	☐	CACSIMPYEAR	KJAHR	NUMC	4	0	Year Commission Case Reported
47	REM_CASE_ID_R	☐	CACSREMCASEID	CACSOBJID10	CHAR	10	0	Identification of a Case Resulting in Remuneration
48	REM_CASE_VERS_R	☐	CACSCASEVERS	CACSVERSION	NUMC	6	0	Commission Case Version
49	POW_OBJ_TYPE_R	☐	CACSPOWOBJ	CACSOBTYID	CHAR	5	0	Subobject Type Where Activity Originates	*
50	POW_OBJ_ID_R	☐	CACSPOWOBJID	CACSOBJID12	CHAR	12	0	Identification of Subobject of Activity Provided
51	ACTIVITY_R	☐	CACSACT	CACSACT	CHAR	4	0	Activity Type	*
52	ACT_POS_R	☐	CACSACTPOS	CACSDOCLINE	CHAR	4	0	Identification of an Activity Line
53	ACTGRP_R	☐	CACSACTGRP	CACSACTGRP	CHAR	4	0	Role	*
54	REM_OBJ_TYPE_R	☐	CACSREMOBJ	CACSOBTYID	CHAR	5	0	Remunerating Subobject Type	*
55	REM_OBJ_ID_R	☐	CACSREMOBJID	CACSOBJID12	CHAR	12	0	Identification of Subobject Resulting in Remuneration
56	VALUE_R	☐	CACSVAL	CACSVAL	CHAR	4	0	Valuation Type	*
57	VALUE_TYPE_R	☐	CACSVALTYPE	CACSVALTYPE	NUMC	1	0	Valuation Result Category
58	VALUE_POS_R	☐	CACSVALUEPOS	CACSDOCLINE	CHAR	4	0	Valuation Row Identification
59	REMVAL_LEDAMNT_R	☐	CACSREMVALAMNT	CACSAMNTITEM	CURR	15	2	Remuneration Value in Commission Model Currency
60	REMVAL_QUAN_R	☐	CACSREMVALQUAN	CACSEVALQUAN	QUAN	11	2	Remuneration Value (Volume)
61	VALUE_UNIT_R	☐	CACSEVALUNIT	MEINS	UNIT	3	0	Valuation Unit	T006
62	ROLE_R	☐	CACSROLE	CACSROLE	CHAR	3	0	Participant Role	*
63	ROLE_REMUSHAR_R	☐	CACSREMUSHARE	CACSPERCENT5	DEC	10	5	Share of Remuneration (in Percent)
64	CONSTELL_R	☐	CACSCONS	CHAR4	CHAR	4	0	Constellation of Participants
65	DIST_TYPE_R	☐	CACSDISTTYPE	CACSDISTTYPE	CHAR	1	0	Remuneration Participation Category
66	CON_CURR_R	☐	CACSCONCURR	WAERS	CUKY	5	0	Contract Currency Key	TCURC
67	LED_CURR_R	☐	CACSLEDCURR	WAERS	CUKY	5	0	Currency Key	TCURC
68	ALLOCATION_R	☐	CACSALLOC	CACSALLOC	CHAR	1	0	Offsetting Selectn (Excess/Sub-Threshold Earnings, Advances)
69	REMUNERATION_R	☐	CACSREM	CACSREM	CHAR	4	0	Remuneration Type	*
70	REM_VERSION_R	☐	CACSVERSION	CACSVERSION	NUMC	6	0	Version of Master Data or Customizing Object
71	REM_RATE_R	☐	CACSREMRATE	CACSPERCENT	DEC	8	3	Remuneration Record (For Example, Percentage)
72	REM_CONAMNT_R	☐	CACSREMUCONAMNT	CACSAMNTITEM	CURR	15	2	Remuneration Entitlement, Amount in Contract Currency
73	DUE_CONAMNT_R	☐	CACSDUECONAMNT	CACSAMNTITEM	CURR	15	2	Remuneration Amount Ready for Disbursement in Contr Currency
74	REM_LEDAMNT_R	☐	CACSREMULEDAMNT	CACSAMNTITEM	CURR	15	2	Remunerat. Entitlement, Amount in Commission Model Currency
75	DUE_LEDAMNT_R	☐	CACSDUELEDAMNT	CACSAMNTITEM	CURR	15	2	Disbursable Partial Remuner.Amount in Comm. Model Currency
76	REM_UNIT_R	☐	CACSREMUUNIT	MEINS	UNIT	3	0	Remuneration Unit	T006
77	REM_QUAN_R	☐	CACSREMUQUAN	CACSREMUQUAN	QUAN	11	2	Remuneration Entitlement as Quantity
78	DUE_QUAN_R	☐	CACSDUEQUAN	CACSREMUQUAN	QUAN	11	2	Remuneration Quantity Ready for Disbursement
79	OFFSET_END_DATE_R	☐	CACSOFFSEDAT	DATUM	DATS	8	0	End of Offsetting
80	OFFSET_RULE_ID_R	☐	CACSOFFSETRULE	CACSOFFSETRULE	CHAR	4	0	Offsetting Type	*
81	OFFSET_CONAMNT_R	☐	CACSOFFSCONAMNT	CACSAMNTITEM	CURR	15	2	Remaining Offset Amount in Contract Currency
82	OFFSET_LEDAMNT_R	☐	CACSOFFSLEDAMNT	CACSAMNTITEM	CURR	15	2	Offsetting/Secondary Liability Amt Remaining in ComModCurr.
83	OFFSET_QUAN_R	☐	CACSOFFSQUAN	CACSRESPQUAN	QUAN	11	2	Offsetting/Remaining Secondary Liability Quantity
84	RESP_BEGIN_DATE_R	☐	CACSRESPBDAT	DATUM	DATS	8	0	Liability Start
85	RESP_END_DATE_R	☐	CACSRESPEDAT	DATUM	DATS	8	0	Liability End
86	RESP_RULE_ID_R	☐	CACSRESPRULE	CACSRESPRULE	CHAR	4	0	Liability Type	*
87	RESP_CONAMNT_R	☐	CACSRESPCONAMNT	CACSAMNTITEM	CURR	15	2	Remaining Liability Amount in Contract Currency
88	RESP_LEDAMNT_R	☐	CACSRESPLEDAMNT	CACSAMNTITEM	CURR	15	2	Remaining Liability Value in Commission Model Currency
89	RESP_QUAN_R	☐	CACSRESPQUAN	CACSRESPQUAN	QUAN	11	2	Remaining liability Quantity
90	RESPVAL_LEDAMNT_R	☐	CACSRESPVALAMNT	CACSAMNTITEM	CURR	15	2	Remaining Liability Value in Commission Model Currency
91	RESPVAL_QUAN_R	☐	CACSRESPVALQUAN	CACSEVALQUAN	QUAN	11	2	Remaining Liability Value (Quantity)
92	CORRBY_DOC_ID_R	☐	CACSCORRBYDOCID	CACSOBJID10	CHAR	10	0	Document Used to Correct This Row
93	CORRBY_PST_YEAR_R	☐	CACSCORRBYPSTYEAR	KJAHR	NUMC	4	0	Assignment Year Document Used for Correcting Row
94	CORRBY_PST_DATE_R	☐	CACSPSTDAT	DATUM	DATS	8	0	Posting Date in Commission Case/Comm Doc. (Acknowledgement)
95	CORRTO_DOC_ID_R	☐	CACSCORRTODOCID	CACSOBJID10	CHAR	10	0	ID of Corrected Document
96	CORRTO_PST_YEAR_R	☐	CACSCORRTOPSTYEAR	KJAHR	NUMC	4	0	Assignment Year Document That Corrected This Row
97	CORRTO_REMUN_POS_R	☐	CACSCORRTOREMUNPOS	CACSDOCLINE	CHAR	4	0	ID of Remuneration Row in Corrected Document
98	SETTLE_GROUP_R	☐	CACSSETTLEGROUP	CACSDOCLINE	CHAR	4	0	Settlement Item Grouping in Document
99	OE_ID	☐	CACS_OBJID_O	HROBJID	NUMC	8	0	Organizational Unit (Object Type O)	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CACS_S_BW_DOCRE	CON_CURR_R	TCURC	WAERS
2	CACS_S_BW_DOCRE	DOC_TYPE_H	TCACS_DOCT	DOC_TYPE
3	CACS_S_BW_DOCRE	LED_CURR_H	TCURC	WAERS
4	CACS_S_BW_DOCRE	LED_CURR_R	TCURC	WAERS
5	CACS_S_BW_DOCRE	REM_UNIT_R	T006	MSEHI
6	CACS_S_BW_DOCRE	STATUS_POS_H	TCACS_VALSTAT2	STATUS_POS
7	CACS_S_BW_DOCRE	STATUS_POS_R	TCACS_VALSTAT2	STATUS_POS
8	CACS_S_BW_DOCRE	STATUS_WORK_H	TCACS_VALSTAT2	STATUS_WORK
9	CACS_S_BW_DOCRE	STATUS_WORK_R	TCACS_VALSTAT2	STATUS_WORK
10	CACS_S_BW_DOCRE	VALUE_UNIT_R	T006	MSEHI

History

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