SAP ABAP View CACS00_V_XDOCRE (View Through CACS00_DOCHD, PAR, INV, REL, ACT, VA, OBJ, RE)
Hierarchy
☛
EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
⤷
ICM (Application Component) Incentive and Commission Management (ICM)
⤷
CACSDO (Package) ICM: Commission Document 'Light'

⤷

⤷

Basic Data
View Type | D | Database View |
Database View | CACS00_V_XDOCRE | |
Short Description | View Through CACS00_DOCHD, PAR, INV, REL, ACT, VA, OBJ, RE | |
Root table | CACS00_DOCHD | Commission Document Header |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | ![]() |
CACS00_DOCHD | ||
2 | ![]() |
|||
3 | ![]() |
|||
4 | ![]() |
|||
5 | ![]() |
|||
6 | ![]() |
|||
7 | ![]() |
|||
8 | ![]() |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
1 | ![]() |
MANDT | JL | EQ | 0 | 0 | ||||
2 | ![]() |
MANDT | JR | EQ | AND | 0 | 0 | |||
3 | ![]() |
POST_YEAR | JL | EQ | 0 | 0 | ||||
4 | ![]() |
POST_YEAR | JR | EQ | AND | 0 | 0 | |||
5 | ![]() |
DOC_ID | JL | EQ | 0 | 0 | ||||
6 | ![]() |
DOC_ID | JR | EQ | AND | 0 | 0 | |||
7 | ![]() |
MANDT | JL | EQ | 0 | 0 | ||||
8 | ![]() |
MANDT | JR | EQ | AND | 0 | 0 | |||
9 | ![]() |
POST_YEAR | JL | EQ | 0 | 0 | ||||
10 | ![]() |
POST_YEAR | JR | EQ | AND | 0 | 0 | |||
11 | ![]() |
DOC_ID | JL | EQ | 0 | 0 | ||||
12 | ![]() |
DOC_ID | JR | EQ | AND | 0 | 0 | |||
13 | ![]() |
MANDT | JL | EQ | 0 | 0 | ||||
14 | ![]() |
MANDT | JR | EQ | AND | 0 | 0 | |||
15 | ![]() |
POST_YEAR | JL | EQ | 0 | 0 | ||||
16 | ![]() |
POST_YEAR | JR | EQ | AND | 0 | 0 | |||
17 | ![]() |
DOC_ID | JL | EQ | 0 | 0 | ||||
18 | ![]() |
DOC_ID | JR | EQ | AND | 0 | 0 | |||
19 | ![]() |
MANDT | JL | EQ | 0 | 0 | ||||
20 | ![]() |
MANDT | JR | EQ | AND | 0 | 0 | |||
21 | ![]() |
POST_YEAR | JL | EQ | 0 | 0 | ||||
22 | ![]() |
POST_YEAR | JR | EQ | AND | 0 | 0 | |||
23 | ![]() |
DOC_ID | JL | EQ | 0 | 0 | ||||
24 | ![]() |
DOC_ID | JR | EQ | AND | 0 | 0 | |||
25 | ![]() |
MANDT | JL | EQ | 0 | 0 | ||||
26 | ![]() |
MANDT | JR | EQ | AND | 0 | 0 | |||
27 | ![]() |
POST_YEAR | JL | EQ | 0 | 0 | ||||
28 | ![]() |
POST_YEAR | JR | EQ | AND | 0 | 0 | |||
29 | ![]() |
DOC_ID | JL | EQ | 0 | 0 | ||||
30 | ![]() |
DOC_ID | JR | EQ | AND | 0 | 0 | |||
31 | ![]() |
MANDT | JL | EQ | 0 | 0 | ||||
32 | ![]() |
MANDT | JR | EQ | AND | 0 | 0 | |||
33 | ![]() |
POST_YEAR | JL | EQ | 0 | 0 | ||||
34 | ![]() |
POST_YEAR | JR | EQ | AND | 0 | 0 | |||
35 | ![]() |
DOC_ID | JL | EQ | 0 | 0 | ||||
36 | ![]() |
DOC_ID | JR | EQ | AND | 0 | 0 | |||
37 | ![]() |
MANDT | JL | EQ | 0 | 0 | ||||
38 | ![]() |
MANDT | JR | EQ | AND | 0 | 0 | |||
39 | ![]() |
POST_YEAR | JL | EQ | 0 | 0 | ||||
40 | ![]() |
POST_YEAR | JR | EQ | AND | 0 | 0 | |||
41 | ![]() |
DOC_ID | JL | EQ | 0 | 0 | ||||
42 | ![]() |
DOC_ID | JR | EQ | AND | 0 | 0 | |||
43 | ![]() |
TRI_OBJ_ID | JL | EQ | 0 | 0 | ||||
44 | ![]() |
TRI_OBJ_ID | JR | EQ | AND | 0 | 0 | |||
45 | ![]() |
PART_POS | JL | EQ | 0 | 0 | ||||
46 | ![]() |
PART_POS | JR | EQ | AND | 0 | 0 | |||
47 | ![]() |
PART_POS | JL | EQ | 0 | 0 | ||||
48 | ![]() |
PART_POS | JR | EQ | AND | 0 | 0 | |||
49 | ![]() |
PART_POS | JL | EQ | 0 | 0 | ||||
50 | ![]() |
PART_POS | JR | EQ | AND | 0 | 0 | |||
51 | ![]() |
PART_POS | JL | EQ | 0 | 0 | ||||
52 | ![]() |
PART_POS | JR | EQ | AND | 0 | 0 | |||
53 | ![]() |
REM_IMP_YEAR | JL | EQ | 0 | 0 | ||||
54 | ![]() |
REM_IMP_YEAR | JR | EQ | AND | 0 | 0 | |||
55 | ![]() |
REM_CASE_VERS | JL | EQ | 0 | 0 | ||||
56 | ![]() |
REM_CASE_VERS | JR | EQ | AND | 0 | 0 | |||
57 | ![]() |
REM_CASE_ID | JL | EQ | 0 | 0 | ||||
58 | ![]() |
REM_CASE_ID | JR | EQ | AND | 0 | 0 | |||
59 | ![]() |
VALUE | JL | EQ | 0 | 0 | ||||
60 | ![]() |
VALUE | JR | EQ | 0 | 0 | ||||
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | ![]() |
![]() |
MANDT | MANDT | Client | |||
2 | ![]() |
![]() |
POST_YEAR | CACSPSTYEAR | Assignment Year of Commission Case/Document | |||
3 | ![]() |
![]() |
DOC_ID | CACSDOCID | Document Identification | |||
4 | ![]() |
![]() |
REMUN_POS | CACSREMUNPOS | ID of Remuneration Row for Referenced Document | |||
5 | ![]() |
![]() |
VALUE_POS | CACSVALUEPOS | Valuation Row Identification | |||
6 | ![]() |
![]() |
TRI_OBJ_TYPE | CACSTRIOBJ | Triggering Subobject Type | |||
7 | ![]() |
![]() |
TRI_OBJ_ID_EXT | CACSTRIOBJIDEXT | External Identification of Triggering Subobject | |||
8 | ![]() |
![]() |
PART_POS | CACSPARTID | Position of Participation in a Commission Case | |||
9 | ![]() |
![]() |
INV_POS | CACSINVPOS | Participant Position in a Participation | |||
10 | ![]() |
![]() |
ROLETYPE | CACSCLAIMTYPE | Entitlement Category | |||
11 | ![]() |
![]() |
CLAIM_OBJTYPE | CACSCLAIMOBJTYPE | Entitlement Object Type | |||
12 | ![]() |
![]() |
CLAIM_OBJID | CACSCLAIMOBJID | ID of Entitlement Object Acc. to Entitlement Object Type | |||
13 | ![]() |
![]() |
INV_POS | CACSINVPOS | Participant Position in a Participation | |||
14 | ![]() |
![]() |
ACT_POS | CACSACTPOS | Identification of an Activity Line | |||
15 | ![]() |
![]() |
KNW_TIMESTAMP | CACSKNOWTSTMP | Calculation Time Stamp | |||
16 | ![]() |
![]() |
CLC_TIMESTAMP | CACSCALCTSTMP | Effective Time Stamp (Effective Status) | |||
17 | ![]() |
![]() |
FLG_REVERSOR | CACSFLGREVR | Ind.: Object Reverses Other Object | |||
18 | ![]() |
![]() |
DOC_TYPE | CACSDOCTYPE | Document Type of Commission Document | |||
19 | ![]() |
![]() |
POST_DATE | CACSPSTDAT | Posting Date in Commission Case/Comm Doc. (Acknowledgement) | |||
20 | ![]() |
![]() |
POST_MONTH | CACSPSTMON | Period in Posting Year | |||
21 | ![]() |
![]() |
TRI_IMP_DATE | CACSIMPDAT | Date Commission Case Entered in Commission System | |||
22 | ![]() |
![]() |
TRI_IMP_YEAR | CACSIMPYEAR | Year Commission Case Reported | |||
23 | ![]() |
![]() |
TRI_CASE_ID | CACSTRICASEID | Identification of a Triggering Case | |||
24 | ![]() |
![]() |
TRI_CASE_VERS | CACSCASEVERS | Commission Case Version | |||
25 | ![]() |
![]() |
FLG_NOSETTLEMENT | CACSNOSETTLEMENT | Ind.: Remuneration Determined Already Paid Out | |||
26 | ![]() |
![]() |
FLG_NORESETTLE | CACSNORESETTLEMENT | Ind.: Remuneration Cancellation Found is Already Settled | |||
27 | ![]() |
![]() |
FLG_FUTURECHECK | CACSFUTURECHECK | Indicator: Carry Out Check for Future Objects | |||
28 | ![]() |
![]() |
RELEASE_DATE | CACSRELDAT | Release Date of Operational Sys. for Commission Notification | |||
29 | ![]() |
![]() |
TRI_CASE_TXT | CACSTRIDOCTXT | Short Text for Commission Document | |||
30 | ![]() |
![]() |
FLG_ASYNC_DONE | CACSFLGASYNC | Indicator: Totals Table Provision Complete | |||
31 | ![]() |
![]() |
ASYNC_LEVEL | CACSASYNCPRIOR | Level Reached in Asynchronous Update | |||
32 | ![]() |
![]() |
BUSOBJ_TYPE | CACSBUSOBJTYP | Business Object Category that Triggers Commission | |||
33 | ![]() |
![]() |
BUSOBJ_ID | CACSBUSOBJID | Identification of Triggering Business Object | |||
34 | ![]() |
![]() |
BUSOBJ_VERS | CACSBUSOBJVERS | Business Object Version | |||
35 | ![]() |
![]() |
BUSOBJ_VERSDATE | CACSVERSDATE | Date Business Object Version Starts | |||
36 | ![]() |
![]() |
REM_BUSCASE_TYP | CACSREMBUSCASTYP | Remunerating Business Transaction in Operational System | |||
37 | ![]() |
![]() |
REM_BUSCASE_ID | CACSREMBUSCASEID | Identification of Triggering Bus. Transaction in Op. System | |||
38 | ![]() |
![]() |
REM_BUSCASE_VERS | CACSREMBUSCASEVERS | Business Transaction Version | |||
39 | ![]() |
![]() |
TRIGGER_SYS | CACSLOGSYSTEM | Logical Operational System | |||
40 | ![]() |
![]() |
TRIGGER_DATE | CACSTRIDAT | Trigger Date of Commission Case in Operational System | |||
41 | ![]() |
![]() |
TRI_BUSCASE_TYP | CACSTRIBUSCASTYP | Commission Triggering Business Case in Operational System | |||
42 | ![]() |
![]() |
TRI_BUSCASE_ID | CACSTRIBUSCASEID | Identification of Triggering Bus. Transaction in Op. System | |||
43 | ![]() |
![]() |
TRI_BUSCASE_VERS | CACSVERSIONLONG | Version of Master Data or Customizing Object | |||
44 | ![]() |
![]() |
TRGCAS_TYPE | CACS_TRGCAS_TYPE | Reason for Additional Commission Case Being Triggered | |||
45 | ![]() |
![]() |
TRGCASAGR_ID | CACS_TRGCASAGR_ID | Identification of Additional Commission Case Agreement | |||
46 | ![]() |
![]() |
TRGCASRU_ID | CACS_TRGCASRU_ID | Rule Identification for Additional Commission Cases | |||
47 | ![]() |
![]() |
PERIODRULE_ID | CACSPRDRULE | Period Rule | |||
48 | ![]() |
![]() |
PERIOD_NO | CACSPERIOD | Period Number | |||
49 | ![]() |
![]() |
RUN_ID | CACSBATCHID | Identification Number of Processing Run | |||
50 | ![]() |
![]() |
EXT_RUN_ID | CACSBATCHEXT | Identification Number of External Processing Run | |||
51 | ![]() |
![]() |
PAY_REF_ID | CACSPAYREFID | Reference Number for Payment System | |||
52 | ![]() |
![]() |
REV_DOC_ID | CACSREVDOCID | Document Number of Related Reversal Document | |||
53 | ![]() |
![]() |
REV_POST_YEAR | CACSREVPOSTYEAR | Posting Year of Related Reversal Document | |||
54 | ![]() |
![]() |
LOG_HANDLE | BALLOGHNDL | Application Log: Log Handle | |||
55 | ![]() |
![]() |
CHG_TIMESTAMP | CACSCHGTSTMP | Creation Time Stamp of Object | |||
56 | ![]() |
![]() |
CHG_TCODE | CACSCDTC | Transaction in Which the Change Was Made | |||
57 | ![]() |
![]() |
CHG_USR | CACSCHUSR | Last user to change object | |||
58 | ![]() |
![]() |
TRI_METH_TYP | CACSTRIMETHTYP | Triggering Method | |||
59 | ![]() |
![]() |
TRI_METH_TARGET | CACSTRIMETHTAR | Processing Target of Triggering Method | |||
60 | ![]() |
![]() |
FLG_REVERSED | CACSFLGREV | Indicator: Row/Object/Subobject is Invalid or Reversed | |||
61 | ![]() |
![]() |
STATUS_POS | CACSSTATUSPOS | Status of Object/Subobject | |||
62 | ![]() |
![]() |
STATUS_WORK | CACSSTATUSWORKP | Object Processing Status (Replica) | |||
63 | ![]() |
![]() |
REV_TIMESTAMP | CACSREVTSTMP | Release Time Stamp of Object on Principle of Dual Control | |||
64 | ![]() |
![]() |
REV_TCODE | CACSCDTC | Transaction in Which the Change Was Made | |||
65 | ![]() |
![]() |
REV_USR | CACSREVUSR | User Who Released Object After Dual Checks | |||
66 | ![]() |
![]() |
UPD_TIMESTAMP | CACSUPDTSTMP | Last Change of Objects | |||
67 | ![]() |
![]() |
FLG_COMPL | CACSFLGCOMPL | Indicator: Document Part Created by Complete Update | |||
68 | ![]() |
![]() |
CTRTBU_ID | CACS_CTRTBU_ID | Commission Contract Number | |||
69 | ![]() |
![]() |
BUCAGR_ID | CACS_BUCAGR_ID | Agreement Number | |||
70 | ![]() |
![]() |
REM_IMP_YEAR | CACSIMPYEAR | Year Commission Case Reported | |||
71 | ![]() |
![]() |
REM_CASE_ID | CACSREMCASEID | Identification of a Case Resulting in Remuneration | |||
72 | ![]() |
![]() |
REM_CASE_VERS | CACSCASEVERS | Commission Case Version | |||
73 | ![]() |
![]() |
POW_OBJ_TYPE | CACSPOWOBJ | Subobject Type Where Activity Originates | |||
74 | ![]() |
![]() |
POW_OBJ_ID | CACSPOWOBJID | Identification of Subobject of Activity Provided | |||
75 | ![]() |
![]() |
ACTIVITY | CACSACT | Activity Type | |||
76 | ![]() |
![]() |
ACTGRP | CACSACTGRP | Role | |||
77 | ![]() |
![]() |
REM_OBJ_TYPE | CACSREMOBJ | Remunerating Subobject Type | |||
78 | ![]() |
![]() |
REM_OBJ_ID | CACSREMOBJID | Identification of Subobject Resulting in Remuneration | |||
79 | ![]() |
![]() |
VALUE_TYPE | CACSVALTYPE | Valuation Result Category | |||
80 | ![]() |
![]() |
REMVAL_LEDAMNT | CACSREMVALAMNT | Remuneration Value in Commission Model Currency | |||
81 | ![]() |
![]() |
REMVAL_QUAN | CACSREMVALQUAN | Remuneration Value (Volume) | |||
82 | ![]() |
![]() |
VALUE_UNIT | CACSEVALUNIT | Valuation Unit | |||
83 | ![]() |
![]() |
ROLE | CACSROLE | Participant Role | |||
84 | ![]() |
![]() |
ROLE_REMUSHAR | CACSREMUSHARE | Share of Remuneration (in Percent) | |||
85 | ![]() |
![]() |
CONSTELL | CACSCONS | Constellation of Participants | |||
86 | ![]() |
![]() |
DIST_TYPE | CACSDISTTYPE | Remuneration Participation Category | |||
87 | ![]() |
![]() |
CON_CURR | CACSCONCURR | Contract Currency Key | |||
88 | ![]() |
![]() |
LED_CURR | CACSLEDCURR | Currency Key | |||
89 | ![]() |
![]() |
ALLOCATION | CACSALLOC | Offsetting Selectn (Excess/Sub-Threshold Earnings, Advances) | |||
90 | ![]() |
![]() |
REMUNERATION | CACSREM | Remuneration Type | |||
91 | ![]() |
![]() |
REM_VERSION | CACSVERSION | Version of Master Data or Customizing Object | |||
92 | ![]() |
![]() |
REM_RATE | CACSREMRATE | Remuneration Record (For Example, Percentage) | |||
93 | ![]() |
![]() |
REM_CONAMNT | CACSREMUCONAMNT | Remuneration Entitlement, Amount in Contract Currency | |||
94 | ![]() |
![]() |
DUE_CONAMNT | CACSDUECONAMNT | Remuneration Amount Ready for Disbursement in Contr Currency | |||
95 | ![]() |
![]() |
REM_LEDAMNT | CACSREMULEDAMNT | Remunerat. Entitlement, Amount in Commission Model Currency | |||
96 | ![]() |
![]() |
DUE_LEDAMNT | CACSDUELEDAMNT | Disbursable Partial Remuner.Amount in Comm. Model Currency | |||
97 | ![]() |
![]() |
REM_UNIT | CACSREMUUNIT | Remuneration Unit | |||
98 | ![]() |
![]() |
REM_QUAN | CACSREMUQUAN | Remuneration Entitlement as Quantity | |||
99 | ![]() |
![]() |
DUE_QUAN | CACSDUEQUAN | Remuneration Quantity Ready for Disbursement | |||
100 | ![]() |
![]() |
OFFSET_END_DATE | CACSOFFSEDAT | End of Offsetting | |||
101 | ![]() |
![]() |
OFFSET_RULE_ID | CACSOFFSETRULE | Offsetting Type | |||
102 | ![]() |
![]() |
OFFSET_CONAMNT | CACSOFFSCONAMNT | Remaining Offset Amount in Contract Currency | |||
103 | ![]() |
![]() |
OFFSET_LEDAMNT | CACSOFFSLEDAMNT | Offsetting/Secondary Liability Amt Remaining in ComModCurr. | |||
104 | ![]() |
![]() |
OFFSET_QUAN | CACSOFFSQUAN | Offsetting/Remaining Secondary Liability Quantity | |||
105 | ![]() |
![]() |
CORRBY_DOC_ID | CACSCORRBYDOCID | Document Used to Correct This Row | |||
106 | ![]() |
![]() |
CORRBY_PST_YEAR | CACSCORRBYPSTYEAR | Assignment Year Document Used for Correcting Row | |||
107 | ![]() |
![]() |
CORRBY_PST_DATE | CACSPSTDAT | Posting Date in Commission Case/Comm Doc. (Acknowledgement) | |||
108 | ![]() |
![]() |
CORRTO_DOC_ID | CACSCORRTODOCID | ID of Corrected Document | |||
109 | ![]() |
![]() |
CORRTO_PST_YEAR | CACSCORRTOPSTYEAR | Assignment Year Document That Corrected This Row | |||
110 | ![]() |
![]() |
CORRTO_REMUN_POS | CACSCORRTOREMUNPOS | ID of Remuneration Row in Corrected Document | |||
111 | ![]() |
![]() |
FLG_CORR | CACSFLGCORR | Indicator: Document Part Created by a Correction | |||
112 | ![]() |
![]() |
SETTLE_GROUP | CACSSETTLEGROUP | Settlement Item Grouping in Document | |||
113 | ![]() |
![]() |
TRI_OBJ_ID | CACSTRIOBJID | Identification of Triggering Subobject | |||
114 | ![]() |
![]() |
VALUE | CACSVAL | Valuation Type | |||
115 | ![]() |
![]() |
VALUE_VERSION | CACSVERSION | Version of Master Data or Customizing Object | |||
116 | ![]() |
![]() |
VALUE_QUAN | CACSEVALQUAN | Valuation Quantity | |||
117 | ![]() |
![]() |
DVALUE_QUAN | CACSEVALDQUAN | Valuation Quantity Change | |||
118 | ![]() |
![]() |
VALUE_AMNT | CACSVALAMNT | Valuation Amount in Commission Model Currency | |||
119 | ![]() |
![]() |
DVALUE_AMNT | CACSVALDAMNT | Valuation Amount Change in Commission Model Currency | |||
120 | ![]() |
![]() |
STATUS_VAL | CACSSTATUSVAL | Valuation Status | |||
121 | ![]() |
![]() |
VALUE_AMNT_RUPT | CACSVALAMNTRUPT | Interrupted Valuation Amount in Commission Model Currency | |||
122 | ![]() |
![]() |
VALUE_QUAN_RUPT | CACSEVALQUANRUPT | Interrupted Valuation Quantity | |||
123 | ![]() |
![]() |
PARENT_TYPE | CACSPARTRIOBJ | Higher-Level Subobject That Triggers Commission | |||
124 | ![]() |
![]() |
PARENT_ID | CACSPARTRIOBJID | Internal Identification of Higher-Level Subobject | |||
125 | ![]() |
![]() |
ROLE_COMMSHAR | CACSCOMMSHARE | Share of Direct Remuneration (in Percent) | |||
126 | ![]() |
![]() |
ROLE_PRODSHAR | CACSPRODSHARE | Share of Indirect Remuneration (in Percent) | |||
127 | ![]() |
![]() |
INV_POS_PARENT | CACSINVPOSPARENT | Position of a Higher-Level Participant in a Participation | |||
Maintenance Status
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 | 700 |