SAP ABAP Table CACS_S_DOCRE_BW (Commissions: Extraction Structure for Remuneration Row)
Hierarchy
☛
EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
⤷ ICM (Application Component) Incentive and Commission Management (ICM)
⤷ CACSBW (Package) Commissions: Business Warehouse
⤷ ICM (Application Component) Incentive and Commission Management (ICM)
⤷ CACSBW (Package) Commissions: Business Warehouse
Basic Data
Table Category | INTTAB | Structure |
Structure | CACS_S_DOCRE_BW | Table Relationship Diagram |
Short Description | Commissions: Extraction Structure for Remuneration Row |
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_H | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
2 | APPL | CACSAPPL | CACSAPPL | CHAR | 6 | 0 | Commission Application (ICM) | * | |
3 | POST_YEAR_H | CACSPSTYEAR | KJAHR | NUMC | 4 | 0 | Assignment Year of Commission Case/Document | ||
4 | DOC_ID_H | CACSDOCID | CACSOBJID10 | CHAR | 10 | 0 | Document Identification | ||
5 | FLG_REVERSOR_H | CACSFLGREVR | FLAG | CHAR | 1 | 0 | Ind.: Object Reverses Other Object | ||
6 | DOC_TYPE_H | CACSDOCTYPE | CACSDOCTYPE | CHAR | 1 | 0 | Document Type of Commission Document | TCACS_DOCT | |
7 | POST_DATE_H | CACSPSTDAT | DATUM | DATS | 8 | 0 | Posting Date in Commission Case/Comm Doc. (Acknowledgement) | ||
8 | POST_MONTH_H | CACSPSTMON | MONAT | NUMC | 2 | 0 | Period in Posting Year | ||
9 | CLC_DATE_H | CACSCALCDAT | DATUM | DATS | 8 | 0 | Effective Date of a Document/Case (Effective Status) | ||
10 | CLC_TIME_H | CACSCALCTIM | UZEIT | TIMS | 6 | 0 | Effective Time of a Document/Case (Effective Status) | ||
11 | KNW_DATE_H | CACSKNOWDAT | DATUM | DATS | 8 | 0 | Calculation Date of Document/Case (Knowledge Status) | ||
12 | KNW_TIME_H | CACSKNOWTIM | UZEIT | TIMS | 6 | 0 | Calculation Time Document/Case (Knowledge Status) | ||
13 | TRI_IMP_DATE_H | CACSIMPDAT | DATUM | DATS | 8 | 0 | Date Commission Case Entered in Commission System | ||
14 | TRI_CASE_ID_H | CACSTRICASEID | CACSOBJID10 | CHAR | 10 | 0 | Identification of a Triggering Case | ||
15 | TRI_CASE_VERS_H | CACSCASEVERS | CACSVERSION | NUMC | 6 | 0 | Commission Case Version | ||
16 | TRI_CASE_TXT_H | CACSTRIDOCTXT | CACSSHORTTXT | CHAR | 40 | 0 | Short Text for Commission Document | ||
17 | FLG_NOSETTLEMENT | CACSNOSETTLEMENT | BOOLEAN_FLG | CHAR | 1 | 0 | Ind.: Remuneration Determined Already Paid Out | ||
18 | FLG_NORESETTLE_H | CACSNORESETTLEMENT | BOOLEAN_FLG | CHAR | 1 | 0 | Ind.: Remuneration Cancellation Found is Already Settled | ||
19 | FLG_FUTURECHECK | CACSFUTURECHECK | BOOLEAN_FLG | CHAR | 1 | 0 | Indicator: Carry Out Check for Future Objects | ||
20 | FLG_ASYNC_DONE_H | CACSFLGASYNC | XFELD | CHAR | 1 | 0 | Indicator: Totals Table Provision Complete | ||
21 | RELEASE_DATE_H | CACSRELDAT | DATUM | DATS | 8 | 0 | Release Date of Operational Sys. for Commission Notification | ||
22 | BUSOBJ_TYPE_H | CACSBUSOBJTYP | CACSBUSOBJTYP | CHAR | 3 | 0 | Business Object Category that Triggers Commission | * | |
23 | BUSOBJ_ID_H | CACSBUSOBJID | CACSOBJID30 | CHAR | 30 | 0 | Identification of Triggering Business Object | ||
24 | BUSOBJ_VERS_H | CACSVERSIONLONG | CACSVERSIONLONG | NUMC | 14 | 0 | Version of Master Data or Customizing Object | ||
25 | BUSOBJ_VERSDATE | CACSVERSDATE | CACSTIMESTAMP | NUMC | 14 | 0 | Date Business Object Version Starts | ||
26 | REM_BUSCASE_TYP | CACSREMBUSCASTYP | CACSBUSCASTYP | CHAR | 3 | 0 | Remunerating Business Transaction in Operational System | * | |
27 | REM_BUSCASE_ID_H | CACSREMBUSCASEID | CACSOBJID36 | CHAR | 36 | 0 | Identification of Triggering Bus. Transaction in Op. System | ||
28 | REM_BUSCASE_VERS | CACSVERSIONLONG | CACSVERSIONLONG | NUMC | 14 | 0 | Version of Master Data or Customizing Object | ||
29 | LED_CURR_H | CACSLEDCURR | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
30 | REV_DOC_ID_H | CACSREVDOCID | CACSOBJID10 | CHAR | 10 | 0 | Document Number of Related Reversal Document | ||
31 | REV_POST_YEAR_H | CACSREVPOSTYEAR | KJAHR | NUMC | 4 | 0 | Posting Year of Related Reversal Document | ||
32 | CHG_DATE_H | CACSCHGDAT | DATUM | DATS | 8 | 0 | Date on Which Object was Created | ||
33 | CHG_TIME_H | CACSCHGTIM | UZEIT | TIMS | 6 | 0 | Time at Which Object was Created | ||
34 | FLG_REVERSED_H | CACSFLGREV | FLAG | CHAR | 1 | 0 | Indicator: Row/Object/Subobject is Invalid or Reversed | ||
35 | STATUS_POS_H | CACSSTATUSPOS | CACSSTATUSVERS | CHAR | 1 | 0 | Status of Object/Subobject | TCACS_VALSTAT2 | |
36 | STATUS_WORK_H | CACSSTATUSPOSWORK | CACSSTATUSWORK | CHAR | 1 | 0 | Processing Status of an Object Item | TCACS_VALSTAT2 | |
37 | POST_YEAR_R | CACSPSTYEAR | KJAHR | NUMC | 4 | 0 | Assignment Year of Commission Case/Document | ||
38 | DOC_ID_R | CACSDOCID | CACSOBJID10 | CHAR | 10 | 0 | Document Identification | ||
39 | REMUN_POS_R | CACSREMUNPOS | CACSDOCLINE | CHAR | 4 | 0 | ID of Remuneration Row for Referenced Document | ||
40 | FLG_REVERSED_R | CACSFLGREV | FLAG | CHAR | 1 | 0 | Indicator: Row/Object/Subobject is Invalid or Reversed | ||
41 | STATUS_POS_R | CACSSTATUSPOS | CACSSTATUSVERS | CHAR | 1 | 0 | Status of Object/Subobject | TCACS_VALSTAT2 | |
42 | STATUS_WORK_R | CACSSTATUSPOSWORK | CACSSTATUSWORK | CHAR | 1 | 0 | Processing Status of an Object Item | TCACS_VALSTAT2 | |
43 | PART_POS_R | CACSPARTID | CACSDOCLINE | CHAR | 4 | 0 | Position of Participation in a Commission Case | ||
44 | INV_POS_R | CACSINVPOS | CACSDOCLINE | CHAR | 4 | 0 | Participant Position in a Participation | ||
45 | CTRTBU_ID_R | CACS_CTRTBU_ID | ISIS_CONTRACT_ID | CHAR | 20 | 0 | Commission Contract Number | ||
46 | REM_IMP_YEAR_R | CACSIMPYEAR | KJAHR | NUMC | 4 | 0 | Year Commission Case Reported | ||
47 | REM_CASE_ID_R | CACSREMCASEID | CACSOBJID10 | CHAR | 10 | 0 | Identification of a Case Resulting in Remuneration | ||
48 | REM_CASE_VERS_R | CACSCASEVERS | CACSVERSION | NUMC | 6 | 0 | Commission Case Version | ||
49 | POW_OBJ_TYPE_R | CACSPOWOBJ | CACSOBTYID | CHAR | 5 | 0 | Subobject Type Where Activity Originates | * | |
50 | POW_OBJ_ID_R | CACSPOWOBJID | CACSOBJID12 | CHAR | 12 | 0 | Identification of Subobject of Activity Provided | ||
51 | ACTIVITY_R | CACSACT | CACSACT | CHAR | 4 | 0 | Activity Type | * | |
52 | ACT_POS_R | CACSACTPOS | CACSDOCLINE | CHAR | 4 | 0 | Identification of an Activity Line | ||
53 | ACTGRP_R | CACSACTGRP | CACSACTGRP | CHAR | 4 | 0 | Role | * | |
54 | REM_OBJ_TYPE_R | CACSREMOBJ | CACSOBTYID | CHAR | 5 | 0 | Remunerating Subobject Type | * | |
55 | REM_OBJ_ID_R | CACSREMOBJID | CACSOBJID12 | CHAR | 12 | 0 | Identification of Subobject Resulting in Remuneration | ||
56 | VALUE_R | CACSVAL | CACSVAL | CHAR | 4 | 0 | Valuation Type | * | |
57 | VALUE_TYPE_R | CACSVALTYPE | CACSVALTYPE | NUMC | 1 | 0 | Valuation Result Category | ||
58 | VALUE_POS_R | CACSVALUEPOS | CACSDOCLINE | CHAR | 4 | 0 | Valuation Row Identification | ||
59 | REMVAL_LEDAMNT_R | CACSREMVALAMNT | CACSAMNTITEM | CURR | 15 | 2 | Remuneration Value in Commission Model Currency | ||
60 | REMVAL_QUAN_R | CACSREMVALQUAN | CACSEVALQUAN | QUAN | 11 | 2 | Remuneration Value (Volume) | ||
61 | VALUE_UNIT_R | CACSEVALUNIT | MEINS | UNIT | 3 | 0 | Valuation Unit | T006 | |
62 | ROLE_R | CACSROLE | CACSROLE | CHAR | 3 | 0 | Participant Role | * | |
63 | ROLE_REMUSHAR_R | CACSREMUSHARE | CACSPERCENT5 | DEC | 10 | 5 | Share of Remuneration (in Percent) | ||
64 | CONSTELL_R | CACSCONS | CHAR4 | CHAR | 4 | 0 | Constellation of Participants | ||
65 | DIST_TYPE_R | CACSDISTTYPE | CACSDISTTYPE | CHAR | 1 | 0 | Remuneration Participation Category | ||
66 | CON_CURR_R | CACSCONCURR | WAERS | CUKY | 5 | 0 | Contract Currency Key | TCURC | |
67 | LED_CURR_R | CACSLEDCURR | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
68 | ALLOCATION_R | CACSALLOC | CACSALLOC | CHAR | 1 | 0 | Offsetting Selectn (Excess/Sub-Threshold Earnings, Advances) | ||
69 | REMUNERATION_R | CACSREM | CACSREM | CHAR | 4 | 0 | Remuneration Type | * | |
70 | REM_VERSION_R | CACSVERSION | CACSVERSION | NUMC | 6 | 0 | Version of Master Data or Customizing Object | ||
71 | REM_RATE_R | CACSREMRATE | CACSPERCENT | DEC | 8 | 3 | Remuneration Record (For Example, Percentage) | ||
72 | REM_CONAMNT_R | CACSREMUCONAMNT | CACSAMNTITEM | CURR | 15 | 2 | Remuneration Entitlement, Amount in Contract Currency | ||
73 | DUE_CONAMNT_R | CACSDUECONAMNT | CACSAMNTITEM | CURR | 15 | 2 | Remuneration Amount Ready for Disbursement in Contr Currency | ||
74 | REM_LEDAMNT_R | CACSREMULEDAMNT | CACSAMNTITEM | CURR | 15 | 2 | Remunerat. Entitlement, Amount in Commission Model Currency | ||
75 | DUE_LEDAMNT_R | CACSDUELEDAMNT | CACSAMNTITEM | CURR | 15 | 2 | Disbursable Partial Remuner.Amount in Comm. Model Currency | ||
76 | REM_UNIT_R | CACSREMUUNIT | MEINS | UNIT | 3 | 0 | Remuneration Unit | T006 | |
77 | REM_QUAN_R | CACSREMUQUAN | CACSREMUQUAN | QUAN | 11 | 2 | Remuneration Entitlement as Quantity | ||
78 | DUE_QUAN_R | CACSDUEQUAN | CACSREMUQUAN | QUAN | 11 | 2 | Remuneration Quantity Ready for Disbursement | ||
79 | OFFSET_END_DATE | CACSOFFSEDAT | DATUM | DATS | 8 | 0 | End of Offsetting | ||
80 | OFFSET_RULE_ID_R | CACSOFFSETRULE | CACSOFFSETRULE | CHAR | 4 | 0 | Offsetting Type | * | |
81 | OFFSET_CONAMNT_R | CACSOFFSCONAMNT | CACSAMNTITEM | CURR | 15 | 2 | Remaining Offset Amount in Contract Currency | ||
82 | OFFSET_LEDAMNT_R | CACSOFFSLEDAMNT | CACSAMNTITEM | CURR | 15 | 2 | Offsetting/Secondary Liability Amt Remaining in ComModCurr. | ||
83 | OFFSET_QUAN_R | CACSOFFSQUAN | CACSRESPQUAN | QUAN | 11 | 2 | Offsetting/Remaining Secondary Liability Quantity | ||
84 | RESP_BEGIN_DATE | CACSRESPBDAT | DATUM | DATS | 8 | 0 | Liability Start | ||
85 | RESP_END_DATE_R | CACSRESPEDAT | DATUM | DATS | 8 | 0 | Liability End | ||
86 | RESP_RULE_ID_R | CACSRESPRULE | CACSRESPRULE | CHAR | 4 | 0 | Liability Type | * | |
87 | RESP_CONAMNT_R | CACSRESPCONAMNT | CACSAMNTITEM | CURR | 15 | 2 | Remaining Liability Amount in Contract Currency | ||
88 | RESP_LEDAMNT_R | CACSRESPLEDAMNT | CACSAMNTITEM | CURR | 15 | 2 | Remaining Liability Value in Commission Model Currency | ||
89 | RESP_QUAN_R | CACSRESPQUAN | CACSRESPQUAN | QUAN | 11 | 2 | Remaining liability Quantity | ||
90 | RESPVAL_LEDAMNT | CACSRESPVALAMNT | CACSAMNTITEM | CURR | 15 | 2 | Remaining Liability Value in Commission Model Currency | ||
91 | RESPVAL_QUAN_R | CACSRESPVALQUAN | CACSEVALQUAN | QUAN | 11 | 2 | Remaining Liability Value (Quantity) | ||
92 | CORRBY_DOC_ID_R | CACSCORRBYDOCID | CACSOBJID10 | CHAR | 10 | 0 | Document Used to Correct This Row | ||
93 | CORRBY_PST_YEAR | CACSCORRBYPSTYEAR | KJAHR | NUMC | 4 | 0 | Assignment Year Document Used for Correcting Row | ||
94 | CORRBY_PST_DATE | CACSPSTDAT | DATUM | DATS | 8 | 0 | Posting Date in Commission Case/Comm Doc. (Acknowledgement) | ||
95 | CORRTO_DOC_ID_R | CACSCORRTODOCID | CACSOBJID10 | CHAR | 10 | 0 | ID of Corrected Document | ||
96 | CORRTO_PST_YEAR | CACSCORRTOPSTYEAR | KJAHR | NUMC | 4 | 0 | Assignment Year Document That Corrected This Row | ||
97 | CORRTO_REMUN_POS | CACSCORRTOREMUNPOS | CACSDOCLINE | CHAR | 4 | 0 | ID of Remuneration Row in Corrected Document | ||
98 | SETTLE_GROUP_R | CACSSETTLEGROUP | CACSDOCLINE | CHAR | 4 | 0 | Settlement Item Grouping in Document | ||
99 | OE_ID | CACS_OBJID_O | HROBJID | NUMC | 8 | 0 | Organizational Unit (Object Type O) | * |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | CACS_S_DOCRE_BW | CON_CURR_R | TCURC | WAERS | |||
2 | CACS_S_DOCRE_BW | DOC_TYPE_H | TCACS_DOCT | DOC_TYPE | |||
3 | CACS_S_DOCRE_BW | LED_CURR_H | TCURC | WAERS | |||
4 | CACS_S_DOCRE_BW | LED_CURR_R | TCURC | WAERS | |||
5 | CACS_S_DOCRE_BW | REM_UNIT_R | T006 | MSEHI | |||
6 | CACS_S_DOCRE_BW | STATUS_POS_H | TCACS_VALSTAT2 | STATUS_POS | |||
7 | CACS_S_DOCRE_BW | STATUS_POS_R | TCACS_VALSTAT2 | STATUS_POS | |||
8 | CACS_S_DOCRE_BW | STATUS_WORK_H | TCACS_VALSTAT2 | STATUS_WORK | |||
9 | CACS_S_DOCRE_BW | STATUS_WORK_R | TCACS_VALSTAT2 | STATUS_WORK | |||
10 | CACS_S_DOCRE_BW | VALUE_UNIT_R | T006 | MSEHI |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 462 |