SAP ABAP View CACS00_V_DOCX (Doc.Header, Remuneration Lines, Settlement Items and Details)

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

View Type	D	Database View
Database View	CACS00_V_DOCX
Short Description	Doc.Header, Remuneration Lines, Settlement Items and Details
Root table	CACS00_DOCHD	Commission Document Header

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	CACS00_DOCHD	CACS00_DOCHD
2	CACS00_DOCRE
3	CACS00_DOCSEDT
4	CACS00_DOCSE

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	CACS00_DOCSE	MANDT	JL	EQ				0	0
2	CACS00_DOCSEDT	MANDT	JR	EQ			AND	0	0
3	CACS00_DOCSE	POST_YEAR	JL	EQ				0	0
4	CACS00_DOCSEDT	POST_YEAR	JR	EQ			AND	0	0
5	CACS00_DOCSE	DOC_ID	JL	EQ				0	0
6	CACS00_DOCSEDT	DOC_ID	JR	EQ			AND	0	0
7	CACS00_DOCSE	SETTL_POS	JL	EQ				0	0
8	CACS00_DOCSEDT	SETTL_POS	JR	EQ			AND	0	0
9	CACS00_DOCSEDT	MANDT	JL	EQ				0	0
10	CACS00_DOCRE	MANDT	JR	EQ			AND	0	0
11	CACS00_DOCSEDT	RE_POST_YEAR	JL	EQ				0	0
12	CACS00_DOCRE	POST_YEAR	JR	EQ			AND	0	0
13	CACS00_DOCSEDT	RE_DOC_ID	JL	EQ				0	0
14	CACS00_DOCRE	DOC_ID	JR	EQ			AND	0	0
15	CACS00_DOCSEDT	RE_REMUN_POS	JL	EQ				0	0
16	CACS00_DOCRE	REMUN_POS	JR	EQ			AND	0	0
17	CACS00_DOCRE	MANDT	JL	EQ				0	0
18	CACS00_DOCHD	MANDT	JR	EQ			AND	0	0
19	CACS00_DOCRE	POST_YEAR	JL	EQ				0	0
20	CACS00_DOCHD	POST_YEAR	JR	EQ			AND	0	0
21	CACS00_DOCRE	DOC_ID	JL	EQ				0	0
22	CACS00_DOCHD	DOC_ID	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	CACS00_DOCHD	MANDT		☐	MANDT	☐	Client
2	POST_YEAR	CACS00_DOCHD	POST_YEAR		☐	CACSPSTYEAR	☐	Assignment Year of Commission Case/Document
3	DOC_ID	CACS00_DOCHD	DOC_ID		☐	CACSDOCID	☐	Document Identification
4	SE_POST_YEAR	CACS00_DOCSE	POST_YEAR		☐	CACSPSTYEAR	☐	Assignment Year of Commission Case/Document
5	SE_DOC_ID	CACS00_DOCSE	DOC_ID		☐	CACSDOCID	☐	Document Identification
6	SETTL_POS	CACS00_DOCSE	SETTL_POS		☐	CACSSETTLPOS	☐	Identification of a Settlement Item
7	DETAIL_POS	CACS00_DOCSEDT	DETAIL_POS		☐	CACSSETTLDTPOS	☐	Number of Detail Line in Settlement Item
8	FLG_REVERSED	CACS00_DOCSE	FLG_REVERSED		☐	CACSFLGREV	☐	Indicator: Row/Object/Subobject is Invalid or Reversed
9	STATUS_POS	CACS00_DOCSE	STATUS_POS		☐	CACSSTATUSPOS	☐	Status of Object/Subobject
10	STATUS_WORK	CACS00_DOCSE	STATUS_WORK		☐	CACSSTATUSWORKP	☐	Object Processing Status (Replica)
11	CTRTBU_ID	CACS00_DOCSE	CTRTBU_ID		☐	CACS_CTRTBU_ID	☐	Commission Contract Number
12	GPART	CACS00_DOCSE	GPART		☐	CACS_GPART_INV	☐	Business Partner to Receive Commission
13	DUE_DATE	CACS00_DOCSE	DUE_DATE		☐	CACSDUEDAT	☐	Due Date of Line Item
14	DUE_YEAR	CACS00_DOCSE	DUE_YEAR		☐	CACSDUEYEAR	☐	Year Due: Document Item
15	DUE_MONTH	CACS00_DOCSE	DUE_MONTH		☐	CACSDUEMON	☐	Period in Year Due
16	STMTYPE_ID	CACS00_DOCSE	STMTYPE_ID		☐	CACS_STMTYPE_ID	☐	Identification of Settlement Type
17	FLG_INTSETTLE	CACS00_DOCSE	FLG_INTSETTLE		☐	CACSINTSETTLEMENT	☐	Settlement Item Serves Immediate Clearing
18	DET_GRP	CACS00_DOCSE	DET_GRP		☐	CACSSETTLEDETGRP	☐	Grouping of Due Line Item Detail in Document
19	CON_CURR	CACS00_DOCSE	CON_CURR		☐	CACSCONCURR	☐	Contract Currency Key
20	REM_UNIT	CACS00_DOCSE	REM_UNIT		☐	CACSREMUUNIT	☐	Remuneration Unit
21	SETTLE_DATE	CACS00_DOCSE	SETTLE_DATE		☐	CACSSETTLEDATE	☐	Settlement Date
22	SETTLE_POST_YEAR	CACS00_DOCSE	SETTLE_POST_YEAR		☐	CACSDOCYEARSETTLE	☐	Posting Year of Settlement Document
23	SETTLE_DOC_ID	CACS00_DOCSE	SETTLE_DOC_ID		☐	CACSDOCIDSETTLE	☐	Settlement Document Number
24	PMNT_BLOCK	CACS00_DOCSE	PMNT_BLOCK		☐	DZLSPR	☐	Payment Block Key
25	REM_CASE_TXT	CACS00_DOCSE	REM_CASE_TXT		☐	CACSSETTLCASETXT	☐	Short Text for Settlement Item
26	REV_POS	CACS00_DOCSE	REV_POS		☐	CACSREVPOS	☐	Reversing Row of Related Reversal Document
27	SETT_LOCK	CACS00_DOCSE	SETT_LOCK		☐	CACSSETTLOCK	☐	Indicator: Item Waiting for Subsequent Process
28	RE_POST_YEAR	CACS00_DOCSEDT	RE_POST_YEAR		☐	CACSPSTYEAR	☐	Assignment Year of Commission Case/Document
29	RE_DOC_ID	CACS00_DOCSEDT	RE_DOC_ID		☐	CACSDOCID	☐	Document Identification
30	RE_REMUN_POS	CACS00_DOCSEDT	RE_REMUN_POS		☐	CACSREMUNPOS	☐	ID of Remuneration Row for Referenced Document
31	DUE_CONAMNT	CACS00_DOCSEDT	DUE_CONAMNT		☐	CACSDUECONAMNT	☐	Remuneration Amount Ready for Disbursement in Contr Currency
32	DUE_LEDAMNT	CACS00_DOCSEDT	DUE_LEDAMNT		☐	CACSDUELEDAMNT	☐	Disbursable Partial Remuner.Amount in Comm. Model Currency
33	DUE_QUAN	CACS00_DOCSEDT	DUE_QUAN		☐	CACSDUEQUAN	☐	Remuneration Quantity Ready for Disbursement
34	REMUN_POS	CACS00_DOCRE	REMUN_POS		☐	CACSREMUNPOS	☐	ID of Remuneration Row for Referenced Document
35	FLG_COMPL	CACS00_DOCRE	FLG_COMPL		☐	CACSFLGCOMPL	☐	Indicator: Document Part Created by Complete Update
36	PART_POS	CACS00_DOCRE	PART_POS		☐	CACSPARTID	☐	Position of Participation in a Commission Case
37	INV_POS	CACS00_DOCRE	INV_POS		☐	CACSINVPOS	☐	Participant Position in a Participation
38	BUCAGR_ID	CACS00_DOCRE	BUCAGR_ID		☐	CACS_BUCAGR_ID	☐	Agreement Number
39	CLAIM_OBJTYPE	CACS00_DOCRE	CLAIM_OBJTYPE		☐	CACSCLAIMOBJTYPE	☐	Entitlement Object Type
40	CLAIM_OBJID	CACS00_DOCRE	CLAIM_OBJID		☐	CACSCLAIMOBJID	☐	ID of Entitlement Object Acc. to Entitlement Object Type
41	REM_IMP_YEAR	CACS00_DOCRE	REM_IMP_YEAR		☐	CACSIMPYEAR	☐	Year Commission Case Reported
42	REM_CASE_ID	CACS00_DOCRE	REM_CASE_ID		☐	CACSREMCASEID	☐	Identification of a Case Resulting in Remuneration
43	REM_CASE_VERS	CACS00_DOCRE	REM_CASE_VERS		☐	CACSCASEVERS	☐	Commission Case Version
44	POW_OBJ_TYPE	CACS00_DOCRE	POW_OBJ_TYPE		☐	CACSPOWOBJ	☐	Subobject Type Where Activity Originates
45	POW_OBJ_ID	CACS00_DOCRE	POW_OBJ_ID		☐	CACSPOWOBJID	☐	Identification of Subobject of Activity Provided
46	ACTIVITY	CACS00_DOCRE	ACTIVITY		☐	CACSACT	☐	Activity Type
47	ACT_POS	CACS00_DOCRE	ACT_POS		☐	CACSACTPOS	☐	Identification of an Activity Line
48	ACTGRP	CACS00_DOCRE	ACTGRP		☐	CACSACTGRP	☐	Role
49	REM_OBJ_TYPE	CACS00_DOCRE	REM_OBJ_TYPE		☐	CACSREMOBJ	☐	Remunerating Subobject Type
50	REM_OBJ_ID	CACS00_DOCRE	REM_OBJ_ID		☐	CACSREMOBJID	☐	Identification of Subobject Resulting in Remuneration
51	VALUE	CACS00_DOCRE	VALUE		☐	CACSVAL	☐	Valuation Type
52	VALUE_TYPE	CACS00_DOCRE	VALUE_TYPE		☐	CACSVALTYPE	☐	Valuation Result Category
53	VALUE_POS	CACS00_DOCRE	VALUE_POS		☐	CACSVALUEPOS	☐	Valuation Row Identification
54	REMVAL_LEDAMNT	CACS00_DOCRE	REMVAL_LEDAMNT		☐	CACSREMVALAMNT	☐	Remuneration Value in Commission Model Currency
55	REMVAL_QUAN	CACS00_DOCRE	REMVAL_QUAN		☐	CACSREMVALQUAN	☐	Remuneration Value (Volume)
56	VALUE_UNIT	CACS00_DOCRE	VALUE_UNIT		☐	CACSEVALUNIT	☐	Valuation Unit
57	ROLE	CACS00_DOCRE	ROLE		☐	CACSROLE	☐	Participant Role
58	ROLE_REMUSHAR	CACS00_DOCRE	ROLE_REMUSHAR		☐	CACSREMUSHARE	☐	Share of Remuneration (in Percent)
59	CONSTELL	CACS00_DOCRE	CONSTELL		☐	CACSCONS	☐	Constellation of Participants
60	DIST_TYPE	CACS00_DOCRE	DIST_TYPE		☐	CACSDISTTYPE	☐	Remuneration Participation Category
61	LED_CURR	CACS00_DOCRE	LED_CURR		☐	CACSLEDCURR	☐	Currency Key
62	ALLOCATION	CACS00_DOCRE	ALLOCATION		☐	CACSALLOC	☐	Offsetting Selectn (Excess/Sub-Threshold Earnings, Advances)
63	REMUNERATION	CACS00_DOCRE	REMUNERATION		☐	CACSREM	☐	Remuneration Type
64	REM_VERSION	CACS00_DOCRE	REM_VERSION		☐	CACSVERSION	☐	Version of Master Data or Customizing Object
65	REM_RATE	CACS00_DOCRE	REM_RATE		☐	CACSREMRATE	☐	Remuneration Record (For Example, Percentage)
66	REM_CONAMNT	CACS00_DOCRE	REM_CONAMNT		☐	CACSREMUCONAMNT	☐	Remuneration Entitlement, Amount in Contract Currency
67	REM_LEDAMNT	CACS00_DOCRE	REM_LEDAMNT		☐	CACSREMULEDAMNT	☐	Remunerat. Entitlement, Amount in Commission Model Currency
68	REM_QUAN	CACS00_DOCRE	REM_QUAN		☐	CACSREMUQUAN	☐	Remuneration Entitlement as Quantity
69	OFFSET_END_DATE	CACS00_DOCRE	OFFSET_END_DATE		☐	CACSOFFSEDAT	☐	End of Offsetting
70	OFFSET_RULE_ID	CACS00_DOCRE	OFFSET_RULE_ID		☐	CACSOFFSETRULE	☐	Offsetting Type
71	OFFSET_CONAMNT	CACS00_DOCRE	OFFSET_CONAMNT		☐	CACSOFFSCONAMNT	☐	Remaining Offset Amount in Contract Currency
72	OFFSET_LEDAMNT	CACS00_DOCRE	OFFSET_LEDAMNT		☐	CACSOFFSLEDAMNT	☐	Offsetting/Secondary Liability Amt Remaining in ComModCurr.
73	OFFSET_QUAN	CACS00_DOCRE	OFFSET_QUAN		☐	CACSOFFSQUAN	☐	Offsetting/Remaining Secondary Liability Quantity
74	CORRBY_DOC_ID	CACS00_DOCRE	CORRBY_DOC_ID		☐	CACSCORRBYDOCID	☐	Document Used to Correct This Row
75	CORRBY_PST_YEAR	CACS00_DOCRE	CORRBY_PST_YEAR		☐	CACSCORRBYPSTYEAR	☐	Assignment Year Document Used for Correcting Row
76	CORRBY_PST_DATE	CACS00_DOCRE	CORRBY_PST_DATE		☐	CACSPSTDAT	☐	Posting Date in Commission Case/Comm Doc. (Acknowledgement)
77	CORRTO_DOC_ID	CACS00_DOCRE	CORRTO_DOC_ID		☐	CACSCORRTODOCID	☐	ID of Corrected Document
78	CORRTO_PST_YEAR	CACS00_DOCRE	CORRTO_PST_YEAR		☐	CACSCORRTOPSTYEAR	☐	Assignment Year Document That Corrected This Row
79	CORRTO_REMUN_POS	CACS00_DOCRE	CORRTO_REMUN_POS		☐	CACSCORRTOREMUNPOS	☐	ID of Remuneration Row in Corrected Document
80	FLG_CORR	CACS00_DOCRE	FLG_CORR		☐	CACSFLGCORR	☐	Indicator: Document Part Created by a Correction
81	FLG_REVERSOR	CACS00_DOCHD	FLG_REVERSOR		☐	CACSFLGREVR	☐	Ind.: Object Reverses Other Object
82	DOC_TYPE	CACS00_DOCHD	DOC_TYPE		☐	CACSDOCTYPE	☐	Document Type of Commission Document
83	POST_DATE	CACS00_DOCHD	POST_DATE		☐	CACSPSTDAT	☐	Posting Date in Commission Case/Comm Doc. (Acknowledgement)
84	POST_MONTH	CACS00_DOCHD	POST_MONTH		☐	CACSPSTMON	☐	Period in Posting Year
85	TRI_IMP_DATE	CACS00_DOCHD	TRI_IMP_DATE		☐	CACSIMPDAT	☐	Date Commission Case Entered in Commission System
86	TRI_CASE_ID	CACS00_DOCHD	TRI_CASE_ID		☐	CACSTRICASEID	☐	Identification of a Triggering Case
87	TRI_CASE_VERS	CACS00_DOCHD	TRI_CASE_VERS		☐	CACSCASEVERS	☐	Commission Case Version
88	FLG_NOSETTLEMENT	CACS00_DOCHD	FLG_NOSETTLEMENT		☐	CACSNOSETTLEMENT	☐	Ind.: Remuneration Determined Already Paid Out
89	FLG_NORESETTLE	CACS00_DOCHD	FLG_NORESETTLE		☐	CACSNORESETTLEMENT	☐	Ind.: Remuneration Cancellation Found is Already Settled
90	FLG_FUTURECHECK	CACS00_DOCHD	FLG_FUTURECHECK		☐	CACSFUTURECHECK	☐	Indicator: Carry Out Check for Future Objects
91	RELEASE_DATE	CACS00_DOCHD	RELEASE_DATE		☐	CACSRELDAT	☐	Release Date of Operational Sys. for Commission Notification
92	TRI_CASE_TXT	CACS00_DOCHD	TRI_CASE_TXT		☐	CACSTRIDOCTXT	☐	Short Text for Commission Document
93	FLG_ASYNC_DONE	CACS00_DOCHD	FLG_ASYNC_DONE		☐	CACSFLGASYNC	☐	Indicator: Totals Table Provision Complete
94	ASYNC_LEVEL	CACS00_DOCHD	ASYNC_LEVEL		☐	CACSASYNCPRIOR	☐	Level Reached in Asynchronous Update
95	BUSOBJ_TYPE	CACS00_DOCHD	BUSOBJ_TYPE		☐	CACSBUSOBJTYP	☐	Business Object Category that Triggers Commission
96	BUSOBJ_ID	CACS00_DOCHD	BUSOBJ_ID		☐	CACSBUSOBJID	☐	Identification of Triggering Business Object
97	BUSOBJ_VERS	CACS00_DOCHD	BUSOBJ_VERS		☐	CACSBUSOBJVERS	☐	Business Object Version
98	BUSOBJ_VERSDATE	CACS00_DOCHD	BUSOBJ_VERSDATE		☐	CACSVERSDATE	☐	Date Business Object Version Starts
99	REM_BUSCASE_TYP	CACS00_DOCHD	REM_BUSCASE_TYP		☐	CACSREMBUSCASTYP	☐	Remunerating Business Transaction in Operational System
100	REM_BUSCASE_ID	CACS00_DOCHD	REM_BUSCASE_ID		☐	CACSREMBUSCASEID	☐	Identification of Triggering Bus. Transaction in Op. System
101	REM_BUSCASE_VERS	CACS00_DOCHD	REM_BUSCASE_VERS		☐	CACSREMBUSCASEVERS	☐	Business Transaction Version
102	TRIGGER_SYS	CACS00_DOCHD	TRIGGER_SYS		☐	CACSLOGSYSTEM	☐	Logical Operational System
103	TRIGGER_DATE	CACS00_DOCHD	TRIGGER_DATE		☐	CACSTRIDAT	☐	Trigger Date of Commission Case in Operational System
104	TRI_BUSCASE_TYP	CACS00_DOCHD	TRI_BUSCASE_TYP		☐	CACSTRIBUSCASTYP	☐	Commission Triggering Business Case in Operational System
105	TRI_BUSCASE_ID	CACS00_DOCHD	TRI_BUSCASE_ID		☐	CACSTRIBUSCASEID	☐	Identification of Triggering Bus. Transaction in Op. System
106	TRI_BUSCASE_VERS	CACS00_DOCHD	TRI_BUSCASE_VERS		☐	CACSVERSIONLONG	☐	Version of Master Data or Customizing Object
107	TRGCAS_TYPE	CACS00_DOCHD	TRGCAS_TYPE		☐	CACS_TRGCAS_TYPE	☐	Reason for Additional Commission Case Being Triggered
108	TRGCASAGR_ID	CACS00_DOCHD	TRGCASAGR_ID		☐	CACS_TRGCASAGR_ID	☐	Identification of Additional Commission Case Agreement
109	TRGCASRU_ID	CACS00_DOCHD	TRGCASRU_ID		☐	CACS_TRGCASRU_ID	☐	Rule Identification for Additional Commission Cases
110	PERIODRULE_ID	CACS00_DOCHD	PERIODRULE_ID		☐	CACSPRDRULE	☐	Period Rule
111	PERIOD_NO	CACS00_DOCHD	PERIOD_NO		☐	CACSPERIOD	☐	Period Number
112	RUN_ID	CACS00_DOCHD	RUN_ID		☐	CACSBATCHID	☐	Identification Number of Processing Run
113	EXT_RUN_ID	CACS00_DOCHD	EXT_RUN_ID		☐	CACSBATCHEXT	☐	Identification Number of External Processing Run
114	PAY_REF_ID	CACS00_DOCHD	PAY_REF_ID		☐	CACSPAYREFID	☐	Reference Number for Payment System
115	REV_DOC_ID	CACS00_DOCHD	REV_DOC_ID		☐	CACSREVDOCID	☐	Document Number of Related Reversal Document
116	REV_POST_YEAR	CACS00_DOCHD	REV_POST_YEAR		☐	CACSREVPOSTYEAR	☐	Posting Year of Related Reversal Document
117	CHG_TCODE	CACS00_DOCHD	CHG_TCODE		☐	CACSCDTC	☐	Transaction in Which the Change Was Made
118	CHG_USR	CACS00_DOCHD	CHG_USR		☐	CACSCHUSR	☐	Last user to change object
119	TRI_METH_TYP	CACS00_DOCHD	TRI_METH_TYP		☐	CACSTRIMETHTYP	☐	Triggering Method
120	TRI_METH_TARGET	CACS00_DOCHD	TRI_METH_TARGET		☐	CACSTRIMETHTAR	☐	Processing Target of Triggering Method
121	REV_TIMESTAMP	CACS00_DOCHD	REV_TIMESTAMP		☐	CACSREVTSTMP	☐	Release Time Stamp of Object on Principle of Dual Control
122	REV_TCODE	CACS00_DOCHD	REV_TCODE		☐	CACSCDTC	☐	Transaction in Which the Change Was Made
123	REV_USR	CACS00_DOCHD	REV_USR		☐	CACSREVUSR	☐	User Who Released Object After Dual Checks
124	LOG_HANDLE	CACS00_DOCHD	LOG_HANDLE		☐	BALLOGHNDL	☐	Application Log: Log Handle
125	SETTLE_GROUP	CACS00_DOCSE	SETTLE_GROUP		☐	CACSSETTLEGROUP	☐	Settlement Item Grouping in Document
126	KNW_TIMESTAMP	CACS00_DOCHD	KNW_TIMESTAMP		☐	CACSKNOWTSTMP	☐	Calculation Time Stamp
127	CLC_TIMESTAMP	CACS00_DOCHD	CLC_TIMESTAMP		☐	CACSCALCTSTMP	☐	Effective Time Stamp (Effective Status)
128	TRI_IMP_YEAR	CACS00_DOCHD	TRI_IMP_YEAR		☐	CACSIMPYEAR	☐	Year Commission Case Reported
129	CHG_TIMESTAMP	CACS00_DOCHD	CHG_TIMESTAMP		☐	CACSCHGTSTMP	☐	Creation Time Stamp of Object

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

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

History

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