SAP ABAP Table CACS_S_FIELDSALL (All Commission Fields)
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'
⤷ ICM (Application Component) Incentive and Commission Management (ICM)
⤷ CACSCC (Package) ICM: Commission Case 'Light'
Basic Data
Table Category | INTTAB | Structure |
Structure | CACS_S_FIELDSALL | Table Relationship Diagram |
Short Description | All Commission Fields |
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 | POST_YEAR | CACSPSTYEAR | KJAHR | NUMC | 4 | 0 | Assignment Year of Commission Case/Document | ||
2 | DOC_ID | CACSDOCID | CACSOBJID10 | CHAR | 10 | 0 | Document Identification | ||
3 | REMUN_POS | CACSREMUNPOS | CACSDOCLINE | CHAR | 4 | 0 | ID of Remuneration Row for Referenced Document | ||
4 | STATUS | CACSSTATUSM | CACSSTATUS | NUMC | 3 | 0 | Status of commission record | ||
5 | ORG_RELATION | CACS_CTRT_REF | ISIS_CONTRACT_ID | CHAR | 20 | 0 | Number of Assigned Commission Contract | ||
6 | LEAD_CTRT | CACS_CTRT_LEAD | ISIS_CONTRACT_ID | CHAR | 20 | 0 | Number of Main Commission Contract | ||
7 | REM_IMP_YEAR | CACSIMPYEAR | KJAHR | NUMC | 4 | 0 | Year Commission Case Reported | ||
8 | REM_CASE_ID | CACSREMCASEID | CACSOBJID10 | CHAR | 10 | 0 | Identification of a Case Resulting in Remuneration | ||
9 | REM_CASE_VERS | CACSCASEVERS | CACSVERSION | NUMC | 6 | 0 | Commission Case Version | ||
10 | POW_OBJ_TYPE | CACSPOWOBJ | CACSOBTYID | CHAR | 5 | 0 | Subobject Type Where Activity Originates | * | |
11 | POW_OBJ_ID | CACSPOWOBJID | CACSOBJID12 | CHAR | 12 | 0 | Identification of Subobject of Activity Provided | ||
12 | ACTIVITY | CACSACT | CACSACT | CHAR | 4 | 0 | Activity Type | * | |
13 | ACT_POS | CACSACTPOS | CACSDOCLINE | CHAR | 4 | 0 | Identification of an Activity Line | ||
14 | ACTGRP | CACSACTGRP | CACSACTGRP | CHAR | 4 | 0 | Role | * | |
15 | TRI_OBJ_TYPE | CACSTRIOBJ | CACSOBTYID | CHAR | 5 | 0 | Triggering Subobject Type | * | |
16 | TRI_OBJ_ID | CACSTRIOBJID | CACSOBJID12 | CHAR | 12 | 0 | Identification of Triggering Subobject | ||
17 | VALUE | CACSVAL | CACSVAL | CHAR | 4 | 0 | Valuation Type | * | |
18 | VALUE_TYPE | CACSVALTYPE | CACSVALTYPE | NUMC | 1 | 0 | Valuation Result Category | ||
19 | VALUE_POS | CACSVALUEPOS | CACSDOCLINE | CHAR | 4 | 0 | Valuation Row Identification | ||
20 | REMVAL_LEDAMNT | CACSREMVALAMNT | CACSAMNTITEM | CURR | 15 | 2 | Remuneration Value in Commission Model Currency | ||
21 | REMVAL_QUAN | CACSREMVALQUAN | CACSEVALQUAN | QUAN | 11 | 2 | Remuneration Value (Volume) | ||
22 | VALUE_UNIT | CACSEVALUNIT | MEINS | UNIT | 3 | 0 | Valuation Unit | * | |
23 | ROLE | CACSROLE | CACSROLE | CHAR | 3 | 0 | Participant Role | * | |
24 | ROLE_REMUSHAR | CACSREMUSHARE | CACSPERCENT5 | DEC | 10 | 5 | Share of Remuneration (in Percent) | ||
25 | CONSTELL | CACSCONS | CHAR4 | CHAR | 4 | 0 | Constellation of Participants | ||
26 | CON_CURR | CACSCONCURR | WAERS | CUKY | 5 | 0 | Contract Currency Key | * | |
27 | ALLOCATION | CACSALLOC | CACSALLOC | CHAR | 1 | 0 | Offsetting Selectn (Excess/Sub-Threshold Earnings, Advances) | ||
28 | REMUNERATION | CACSREM | CACSREM | CHAR | 4 | 0 | Remuneration Type | * | |
29 | REM_RATE | CACSREMRATE | CACSPERCENT | DEC | 8 | 3 | Remuneration Record (For Example, Percentage) | ||
30 | REM_CONAMNT | CACSREMUCONAMNT | CACSAMNTITEM | CURR | 15 | 2 | Remuneration Entitlement, Amount in Contract Currency | ||
31 | DREM_CONAMNT | CACSREMUDCONAMNT | CACSAMNTITEM | CURR | 15 | 2 | Remuneration Difference in Contract Currency | ||
32 | REM_LEDAMNT | CACSREMULEDAMNT | CACSAMNTITEM | CURR | 15 | 2 | Remunerat. Entitlement, Amount in Commission Model Currency | ||
33 | DREM_LEDAMNT | CACSREMUDLEDAMNT | CACSAMNTITEM | CURR | 15 | 2 | Remuneration Difference Amount in Commission Model Currency | ||
34 | REM_UNIT | CACSREMUUNIT | MEINS | UNIT | 3 | 0 | Remuneration Unit | * | |
35 | REM_QUAN | CACSREMUQUAN | CACSREMUQUAN | QUAN | 11 | 2 | Remuneration Entitlement as Quantity | ||
36 | DREM_QUAN | CACSREMUDQUAN | CACSREMUQUAN | QUAN | 11 | 2 | Remuneration Difference Quantity | ||
37 | OFFSET_RULE_ID | CACSOFFSETRULE | CACSOFFSETRULE | CHAR | 4 | 0 | Offsetting Type | * | |
38 | RESP_BEG_DATE | CACSRESPBDAT | DATUM | DATS | 8 | 0 | Liability Start | ||
39 | RESP_END_DATE | CACSRESPEDAT | DATUM | DATS | 8 | 0 | Liability End | ||
40 | RESP_RULE_ID | CACSRESPRULE | CACSRESPRULE | CHAR | 4 | 0 | Liability Type | * | |
41 | RESP_CONAMNT | CACSRESPCONAMNT | CACSAMNTITEM | CURR | 15 | 2 | Remaining Liability Amount in Contract Currency | ||
42 | RESP_LEDAMNT | CACSRESPLEDAMNT | CACSAMNTITEM | CURR | 15 | 2 | Remaining Liability Value in Commission Model Currency | ||
43 | RESP_QUAN | CACSRESPQUAN | CACSRESPQUAN | QUAN | 11 | 2 | Remaining liability Quantity | ||
44 | CORRBY_DOC_ID | CACSDOCID | CACSOBJID10 | CHAR | 10 | 0 | Document Identification | ||
45 | CORRBY_PST_YEAR | CACSPSTYEAR | KJAHR | NUMC | 4 | 0 | Assignment Year of Commission Case/Document | ||
46 | CORRBY_PST_DATE | CACSPSTDAT | DATUM | DATS | 8 | 0 | Posting Date in Commission Case/Comm Doc. (Acknowledgement) | ||
47 | CORRTO_DOC_ID | CACSDOCID | CACSOBJID10 | CHAR | 10 | 0 | Document Identification | ||
48 | CORRTO_PST_YEAR | CACSPSTYEAR | KJAHR | NUMC | 4 | 0 | Assignment Year of Commission Case/Document | ||
49 | CORRTO_REMUN_POS | CACSREMUNPOS | CACSDOCLINE | CHAR | 4 | 0 | ID of Remuneration Row for Referenced Document | ||
50 | ADDON_TYPE | CACSITEMADD | CACSITEMADD | CHAR | 1 | 0 | Enhancement/Change to a Subobject | ||
51 | ADDON_REF | CACSITEMADDREF | CACSDOCLINE | CHAR | 4 | 0 | Enhancement Reference for Subobject | ||
52 | SETTLE_GROUP | CACSSETTLEGROUP | CACSDOCLINE | CHAR | 4 | 0 | Settlement Item Grouping in Document | ||
53 | FLG_REVERSED | CACSFLGREV | FLAG | CHAR | 1 | 0 | Indicator: Row/Object/Subobject is Invalid or Reversed | ||
54 | COR_DATE | CACSCORDATE | TIMESTAMP | CHAR | 14 | 0 | Date of Correspondance Run | ||
55 | COR_ID | COKEY_KK | COKEY_KK | CHAR | 36 | 0 | Correspondence key | ||
56 | ROBJTYPE | CACSCALCOBJTYPE | CACSCALCOBJTYPE | CHAR | 2 | 0 | Calculating Object Type | TCACS_COT | |
57 | ROBJID | CACSCALCOBJID | CHAR005 | CHAR | 5 | 0 | Identification of Calculating Object | ||
58 | LOG_SERVICE | CACS_RULE_LOG_SERVICE | CHAR10 | CHAR | 10 | 0 | Logical Service for Agreement Rules | ||
59 | SERVICETOOL | CACS_RULE_SERVTOOL | CHAR0010 | CHAR | 32 | 0 | Service Tool for Agreement Type | ||
60 | SERVICE_ID | CACS_RULE_SERVID | CHAR10 | CHAR | 10 | 0 | Service Identification for Service Tool | ||
61 | POST_MONTH | CACSPSTMON | MONAT | NUMC | 2 | 0 | Period in Posting Year | ||
62 | VALUE_QUAN | CACSEVALQUAN | CACSEVALQUAN | QUAN | 11 | 2 | Valuation Quantity | ||
63 | DVALUE_QUAN | CACSEVALDQUAN | CACSEVALQUAN | QUAN | 11 | 2 | Valuation Quantity Change | ||
64 | VALUE_AMNT | CACSVALAMNT | CACSAMNTITEM | CURR | 15 | 2 | Valuation Amount in Commission Model Currency | ||
65 | DVALUE_AMNT | CACSVALDAMNT | CACSAMNTITEM | CURR | 15 | 2 | Valuation Amount Change in Commission Model Currency | ||
66 | LED_CURR | CACSLEDCURR | WAERS | CUKY | 5 | 0 | Currency Key | * | |
67 | CTRTST_ID | CACS_CTRTST_ID | ISIS_CONTRACT_ID | CHAR | 20 | 0 | Number of Standard Commission Contract | ||
68 | CACSDUMMY | CACSDUMMY | CACS_DUMMY | DEC | 10 | 0 | Numerical Dummy Field | ||
69 | SETTL_POS | CACSSETTLPOS | CACSDOCLINE | CHAR | 4 | 0 | Identification of a Settlement Item | ||
70 | CTRTBU_ID | CACS_CTRTBU_ID | ISIS_CONTRACT_ID | CHAR | 20 | 0 | Commission Contract Number | ||
71 | DUE_DATE | CACSDUEDAT | DATUM | DATS | 8 | 0 | Due Date of Line Item | ||
72 | DUE_YEAR | CACSDUEYEAR | KJAHR | NUMC | 4 | 0 | Year Due: Document Item | ||
73 | DUE_MONTH | CACSDUEMON | MONAT | NUMC | 2 | 0 | Period in Year Due | ||
74 | STMTYPE_ID | CACS_STMTYPE_ID | CACSSTMTY | CHAR | 4 | 0 | Identification of Settlement Type | * | |
75 | DUE_CONAMNT | CACSDUECONAMNT | CACSAMNTITEM | CURR | 15 | 2 | Remuneration Amount Ready for Disbursement in Contr Currency | ||
76 | DUE_LEDAMNT | CACSDUELEDAMNT | CACSAMNTITEM | CURR | 15 | 2 | Disbursable Partial Remuner.Amount in Comm. Model Currency | ||
77 | DUE_QUAN | CACSDUEQUAN | CACSREMUQUAN | QUAN | 11 | 2 | Remuneration Quantity Ready for Disbursement | ||
78 | SETTLE_DATE | CACSPSTDAT | DATUM | DATS | 8 | 0 | Posting Date in Commission Case/Comm Doc. (Acknowledgement) | ||
79 | SETTLE_POST_YEAR | CACSDOCYEARSETTLE | KJAHR | NUMC | 4 | 0 | Posting Year of Settlement Document | ||
80 | SETTLE_DOC_ID | CACSDOCIDSETTLE | CACSOBJID10 | CHAR | 10 | 0 | Settlement Document Number | ||
81 | PMNT_BLOCK | DZLSPR | ZAHLS | CHAR | 1 | 0 | Payment Block Key | * | |
82 | REM_CASE_TXT | CACSTRICASETXT | CACSSHORTTXT | CHAR | 40 | 0 | Short Text for Commission Case | ||
83 | DOC_TYPE | CACSDOCTYPE | CACSDOCTYPE | CHAR | 1 | 0 | Document Type of Commission Document | * | |
84 | POST_DATE | CACSPSTDAT | DATUM | DATS | 8 | 0 | Posting Date in Commission Case/Comm Doc. (Acknowledgement) | ||
85 | CLC_DATE | CACSCALCDAT | DATUM | DATS | 8 | 0 | Effective Date of a Document/Case (Effective Status) | ||
86 | CLC_TIME | CACSCALCTIM | UZEIT | TIMS | 6 | 0 | Effective Time of a Document/Case (Effective Status) | ||
87 | KNW_DATE | CACSKNOWDAT | DATUM | DATS | 8 | 0 | Calculation Date of Document/Case (Knowledge Status) | ||
88 | KNW_TIME | CACSKNOWTIM | UZEIT | TIMS | 6 | 0 | Calculation Time Document/Case (Knowledge Status) | ||
89 | CHG_TCODE | CACSCDTC | TCODE | CHAR | 20 | 0 | Transaction in Which the Change Was Made | * | |
90 | CHG_USR | CACSCHUSR | USNAM | CHAR | 12 | 0 | Last user to change object | ||
91 | TRI_IMP_DATE | CACSIMPDAT | DATUM | DATS | 8 | 0 | Date Commission Case Entered in Commission System | ||
92 | TRI_CASE_ID | CACSTRICASEID | CACSOBJID10 | CHAR | 10 | 0 | Identification of a Triggering Case | ||
93 | TRI_CASE_VERS | CACSCASEVERS | CACSVERSION | NUMC | 6 | 0 | Commission Case Version | ||
94 | TRI_CASE_TXT | CACSTRICASETXT | CACSSHORTTXT | CHAR | 40 | 0 | Short Text for Commission Case | ||
95 | FLG_ASYNC_DONE | CACSFLGASYNC | XFELD | CHAR | 1 | 0 | Indicator: Totals Table Provision Complete | ||
96 | CHANGE_TYPE | CACSCASECHGTYP | CACSOPTYPE | CHAR | 1 | 0 | Commission Case Change Category | ||
97 | TRIGGER_DATE | CACSTRIDAT | DATUM | DATS | 8 | 0 | Trigger Date of Commission Case in Operational System | ||
98 | RELEASE_DATE | CACSRELDAT | DATUM | DATS | 8 | 0 | Release Date of Operational Sys. for Commission Notification | ||
99 | RUN_ID | CACSBATCHID | CACSOBJID10 | CHAR | 10 | 0 | Identification Number of Processing Run | ||
100 | TRIGGER_SYS | CACSLOGSYSTEM | LOGSYS | CHAR | 10 | 0 | Logical Operational System | * | |
101 | BUSOBJ_TYPE | CACSBUSOBJTYP | CACSBUSOBJTYP | CHAR | 3 | 0 | Business Object Category that Triggers Commission | * | |
102 | BUSOBJ_ID | CACSBUSOBJID | CACSOBJID30 | CHAR | 30 | 0 | Identification of Triggering Business Object | ||
103 | BUSOBJ_VERS | CACSVERSION | CACSVERSION | NUMC | 6 | 0 | Version of Master Data or Customizing Object | ||
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 | CACSVERSION | CACSVERSION | NUMC | 6 | 0 | Version of Master Data or Customizing Object | ||
107 | REM_BUSCASE_TYP | CACSREMBUSCASTYP | CACSBUSCASTYP | CHAR | 3 | 0 | Remunerating Business Transaction in Operational System | * | |
108 | REM_BUSCASE_ID | CACSREMBUSCASEID | CACSOBJID36 | CHAR | 36 | 0 | Identification of Triggering Bus. Transaction in Op. System | ||
109 | REM_BUSCASE_VERS | CACSVERSION | CACSVERSION | NUMC | 6 | 0 | Version of Master Data or Customizing Object | ||
110 | REV_DOC_ID | CACSREVDOCID | CACSOBJID10 | CHAR | 10 | 0 | Document Number of Related Reversal Document | ||
111 | REV_POST_YEAR | CACSREVPOSTYEAR | KJAHR | NUMC | 4 | 0 | Posting Year of Related Reversal Document |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | CACS_S_FIELDSALL | ROBJTYPE | TCACS_COT | CALCOBJTYPE |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |