SAP ABAP Table CACS00_SIS_DOCSE (Commission Docs, Settlement 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_DOCSE	Table Relationship Diagram
Short Description	Commission Docs, Settlement 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-_S	☐				0	0	Commission Document, Settlement
73	.INCLUDE	☐				0	0	Commission Document, Settlement (Key)
74	.INCLUDE	☐				0	0	Commission Document Header (Key)
75	MANDT_S	☐	MANDT	MANDT	CLNT	3	0	Client	*
76	POST_YEAR_S	☐	CACSPSTYEAR	KJAHR	NUMC	4	0	Assignment Year of Commission Case/Document
77	DOC_ID_S	☐	CACSDOCID	CACSOBJID10	CHAR	10	0	Document Identification
78	SETTL_POS_S	☐	CACSSETTLPOS	CACSDOCLINE	CHAR	4	0	Identification of a Settlement Item
79	.INCLUDE	☐				0	0	Commission Document, Settlement (Data)
80	.INCLUDE	☐				0	0	Status Management for Document Data Items
81	FLG_REVERSED_S	☐	CACSFLGREV	FLAG	CHAR	1	0	Indicator: Row/Object/Subobject is Invalid or Reversed
82	STATUS_POS_S	☐	CACSSTATUSPOS	CACSSTATUSVERS	CHAR	1	0	Status of Object/Subobject	TCACS_VALSTAT2
83	STATUS_WORK_S	☐	CACSSTATUSWORKP	CACSSTATUSWORK	CHAR	1	0	Object Processing Status (Replica)	*
84	CTRTBU_ID_S	☐	CACS_CTRTBU_ID	ISIS_CONTRACT_ID	CHAR	20	0	Commission Contract Number
85	GPART_S	☐	CACS_GPART_INV	BU_PARTNER	CHAR	10	0	Business Partner to Receive Commission	*
86	DUE_DATE_S	☐	CACSDUEDAT	DATUM	DATS	8	0	Due Date of Line Item
87	DUE_YEAR_S	☐	CACSDUEYEAR	KJAHR	NUMC	4	0	Year Due: Document Item
88	DUE_MONTH_S	☐	CACSDUEMON	MONAT	NUMC	2	0	Period in Year Due
89	STMTYPE_ID_S	☐	CACS_STMTYPE_ID	CACSSTMTY	CHAR	4	0	Identification of Settlement Type	*
90	REMUNERATION_S	☐	CACSREM	CACSREM	CHAR	4	0	Remuneration Type	TCACS_REM
91	SETTLE_GROUP_S	☐	CACSSETTLEGROUP	CACSDOCLINE	CHAR	4	0	Settlement Item Grouping in Document
92	FLG_INTSETTLE_S	☐	CACSINTSETTLEMENT	BOOLEAN_FLG	CHAR	1	0	Settlement Item Serves Immediate Clearing
93	DET_GRP_S	☐	CACSSETTLEDETGRP	CACSDETGRP	CHAR	4	0	Grouping of Due Line Item Detail in Document
94	CON_CURR_S	☐	CACSCONCURR	WAERS	CUKY	5	0	Contract Currency Key	TCURC
95	DUE_CONAMNT_S	☐	CACSDUECONAMNT	CACSAMNTITEM	CURR	15	2	Remuneration Amount Ready for Disbursement in Contr Currency
96	LED_CURR_S	☐	CACSLEDCURR	WAERS	CUKY	5	0	Currency Key	TCURC
97	DUE_LEDAMNT_S	☐	CACSDUELEDAMNT	CACSAMNTITEM	CURR	15	2	Disbursable Partial Remuner.Amount in Comm. Model Currency
98	REM_UNIT_S	☐	CACSREMUUNIT	MEINS	UNIT	3	0	Remuneration Unit	T006
99	DUE_QUAN_S	☐	CACSDUEQUAN	CACSREMUQUAN	QUAN	11	2	Remuneration Quantity Ready for Disbursement
100	SETTLE_DATE_S	☐	CACSSETTLEDATE	DATUM	DATS	8	0	Settlement Date
101	SETTLE_POST_YEAR_S	☐	CACSDOCYEARSETTLE	KJAHR	NUMC	4	0	Posting Year of Settlement Document
102	SETTLE_DOC_ID_S	☐	CACSDOCIDSETTLE	CACSOBJID10	CHAR	10	0	Settlement Document Number
103	PMNT_BLOCK_S	☐	DZLSPR	ZAHLS	CHAR	1	0	Payment Block Key	*
104	REM_CASE_TXT_S	☐	CACSSETTLCASETXT	CACSSHORTTXT	CHAR	40	0	Short Text for Settlement Item
105	REV_POS_S	☐	CACSREVPOS	CACSDOCLINE	CHAR	4	0	Reversing Row of Related Reversal Document
106	SETT_LOCK_S	☐	CACSSETTLOCK	CACSITMLCK	CHAR	1	0	Indicator: Item Waiting for Subsequent Process	*
107	.INCLUDE	☐				0	0	Last Changes to Objects
108	UPD_TIMESTAMP_S	☐	CACSUPDTSTMP	CACSTIMESTAMP	NUMC	14	0	Last Change of Objects
109	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_DOCSE	CON_CURR_S	TCURC	WAERS
2	CACS00_SIS_DOCSE	DOC_TYPE_H	TCACS_DOCT	DOC_TYPE
3	CACS00_SIS_DOCSE	LED_CURR_S	TCURC	WAERS
4	CACS00_SIS_DOCSE	REMUNERATION_S	TCACS_REM	REMUNERATION
5	CACS00_SIS_DOCSE	REM_UNIT_S	T006	MSEHI
6	CACS00_SIS_DOCSE	STATUS_POS_H	TCACS_VALSTAT2	STATUS_POS
7	CACS00_SIS_DOCSE	STATUS_POS_S	TCACS_VALSTAT2	STATUS_POS

History

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