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