SAP ABAP Table CACS00_V_DOCX (Generated Table for View)

Basic Data

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CACS00_V_DOCX	ACTGRP	TCACS_ACTGRP	ACTGRP
2	CACS00_V_DOCX	CON_CURR	TCURC	WAERS
3	CACS00_V_DOCX	DOC_TYPE	TCACS_DOCT	DOC_TYPE
4	CACS00_V_DOCX	LED_CURR	TCURC	WAERS
5	CACS00_V_DOCX	OFFSET_RULE_ID	TCACS_OFFS	OFFSET_RULE_ID
6	CACS00_V_DOCX	REMUNERATION	TCACS_REM	REMUNERATION
7	CACS00_V_DOCX	REM_UNIT	T006	MSEHI
8	CACS00_V_DOCX	ROLE	TCACS_ROLE	ROLE
9	CACS00_V_DOCX	STATUS_POS	TCACS_VALSTAT2	STATUS_POS
10	CACS00_V_DOCX	VALUE	TCACS_VAL	VALUE

History

Last changed by/on	SAP	20130529
SAP Release Created in