SAP ABAP Table CACS_S_FLDPRC_OPT (Comm.: All Condition Technique-Relevant Commission Fields)
Hierarchy
☛
EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
⤷ ICM (Application Component) Incentive and Commission Management (ICM)
⤷ CACSSD (Package) ICM: SD Condition Technique
⤷ ICM (Application Component) Incentive and Commission Management (ICM)
⤷ CACSSD (Package) ICM: SD Condition Technique
Basic Data
Table Category | INTTAB | Structure |
Structure | CACS_S_FLDPRC_OPT | Table Relationship Diagram |
Short Description | Comm.: All Condition Technique-Relevant 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 | STATUS_VAL | CACSSTATUSVAL | CACSSTATUSVAL | CHAR | 1 | 0 | Valuation Status | ||
23 | VALUE_AMNT_RUPT | CACSVALAMNTRUPT | CACSAMNTITEM | CURR | 15 | 2 | Interrupted Valuation Amount in Commission Model Currency | ||
24 | VALUE_QUAN_RUPT | CACSEVALQUANRUPT | CACSEVALQUAN | QUAN | 11 | 2 | Interrupted Valuation Quantity | ||
25 | VALUE_UNIT | CACSEVALUNIT | MEINS | UNIT | 3 | 0 | Valuation Unit | * | |
26 | ROLE | CACSROLE | CACSROLE | CHAR | 3 | 0 | Participant Role | * | |
27 | ROLE_REMUSHAR | CACSREMUSHARE | CACSPERCENT5 | DEC | 10 | 5 | Share of Remuneration (in Percent) | ||
28 | CONSTELL | CACSCONS | CHAR4 | CHAR | 4 | 0 | Constellation of Participants | ||
29 | CON_CURR | CACSCONCURR | WAERS | CUKY | 5 | 0 | Contract Currency Key | * | |
30 | ALLOCATION | CACSALLOC | CACSALLOC | CHAR | 1 | 0 | Offsetting Selectn (Excess/Sub-Threshold Earnings, Advances) | ||
31 | REMUNERATION | CACSREM | CACSREM | CHAR | 4 | 0 | Remuneration Type | * | |
32 | REM_RATE | CACSREMRATE | CACSPERCENT | DEC | 8 | 3 | Remuneration Record (For Example, Percentage) | ||
33 | REM_CONAMNT | CACSREMUCONAMNT | CACSAMNTITEM | CURR | 15 | 2 | Remuneration Entitlement, Amount in Contract Currency | ||
34 | DREM_CONAMNT | CACSREMUDCONAMNT | CACSAMNTITEM | CURR | 15 | 2 | Remuneration Difference in Contract Currency | ||
35 | REM_LEDAMNT | CACSREMULEDAMNT | CACSAMNTITEM | CURR | 15 | 2 | Remunerat. Entitlement, Amount in Commission Model Currency | ||
36 | DREM_LEDAMNT | CACSREMUDLEDAMNT | CACSAMNTITEM | CURR | 15 | 2 | Remuneration Difference Amount in Commission Model Currency | ||
37 | REM_UNIT | CACSREMUUNIT | MEINS | UNIT | 3 | 0 | Remuneration Unit | * | |
38 | REM_QUAN | CACSREMUQUAN | CACSREMUQUAN | QUAN | 11 | 2 | Remuneration Entitlement as Quantity | ||
39 | DREM_QUAN | CACSREMUDQUAN | CACSREMUQUAN | QUAN | 11 | 2 | Remuneration Difference Quantity | ||
40 | OFFSET_RULE_ID | CACSOFFSETRULE | CACSOFFSETRULE | CHAR | 4 | 0 | Offsetting Type | * | |
41 | RESP_BEGIN_DATE | CACSRESPBDAT | DATUM | DATS | 8 | 0 | Liability Start | ||
42 | RESP_END_DATE | CACSRESPEDAT | DATUM | DATS | 8 | 0 | Liability End | ||
43 | RESP_RULE_ID | CACSRESPRULE | CACSRESPRULE | CHAR | 4 | 0 | Liability Type | * | |
44 | RESP_CONAMNT | CACSRESPCONAMNT | CACSAMNTITEM | CURR | 15 | 2 | Remaining Liability Amount in Contract Currency | ||
45 | RESP_LEDAMNT | CACSRESPLEDAMNT | CACSAMNTITEM | CURR | 15 | 2 | Remaining Liability Value in Commission Model Currency | ||
46 | RESP_QUAN | CACSRESPQUAN | CACSRESPQUAN | QUAN | 11 | 2 | Remaining liability Quantity | ||
47 | STATUS_RESP | CACSSTATUSRESP | CACSSTATUSVAL | CHAR | 1 | 0 | Liability Status | ||
48 | RESP_RUPT_BEGIN | CACSRUPTDATE_B | CACSTIMESTAMP | NUMC | 14 | 0 | Date of Interruption Start | ||
49 | RESP_RUPT_END | CACSRUPTDATE_E | CACSTIMESTAMP | NUMC | 14 | 0 | Date of Required End of Interruption | ||
50 | CORRBY_DOC_ID | CACSCORRBYDOCID | CACSOBJID10 | CHAR | 10 | 0 | Document Used to Correct This Row | ||
51 | CORRBY_PST_YEAR | CACSCORRBYPSTYEAR | KJAHR | NUMC | 4 | 0 | Assignment Year Document Used for Correcting Row | ||
52 | CORRBY_PST_DATE | CACSPSTDAT | DATUM | DATS | 8 | 0 | Posting Date in Commission Case/Comm Doc. (Acknowledgement) | ||
53 | CORRTO_DOC_ID | CACSCORRTODOCID | CACSOBJID10 | CHAR | 10 | 0 | ID of Corrected Document | ||
54 | CORRTO_PST_YEAR | CACSCORRTOPSTYEAR | KJAHR | NUMC | 4 | 0 | Assignment Year Document That Corrected This Row | ||
55 | CORRTO_REMUN_POS | CACSCORRTOREMUNPOS | CACSDOCLINE | CHAR | 4 | 0 | ID of Remuneration Row in Corrected Document | ||
56 | ADDON_TYPE | CACSITEMADD | CACSITEMADD | CHAR | 1 | 0 | Enhancement/Change to a Subobject | ||
57 | ADDON_REF | CACSITEMADDREF | CACSDOCLINE | CHAR | 4 | 0 | Enhancement Reference for Subobject | ||
58 | SETTLE_GROUP | CACSSETTLEGROUP | CACSDOCLINE | CHAR | 4 | 0 | Settlement Item Grouping in Document | ||
59 | FLG_REVERSED | CACSFLGREV | FLAG | CHAR | 1 | 0 | Indicator: Row/Object/Subobject is Invalid or Reversed | ||
60 | COR_DATE | CACSCORDATE | TIMESTAMP | CHAR | 14 | 0 | Date of Correspondance Run | ||
61 | COR_ID | COKEY_KK | COKEY_KK | CHAR | 36 | 0 | Correspondence key | ||
62 | ROBJTYPE | CACSCALCOBJTYPE | CACSCALCOBJTYPE | CHAR | 2 | 0 | Calculating Object Type | TCACS_COT | |
63 | ROBJID | CACSCALCOBJID | CHAR005 | CHAR | 5 | 0 | Identification of Calculating Object | ||
64 | LOG_SERVICE | CACS_RULE_LOG_SERVICE | CHAR10 | CHAR | 10 | 0 | Logical Service for Agreement Rules | ||
65 | SERVICETOOL | CACS_RULE_SERVTOOL | CHAR0010 | CHAR | 32 | 0 | Service Tool for Agreement Type | ||
66 | SERVICE_ID | CACS_RULE_SERVID | CHAR10 | CHAR | 10 | 0 | Service Identification for Service Tool | ||
67 | SERVICE_PARAM1 | CACS_RULE_PARAMETER1 | CHAR32 | CHAR | 32 | 0 | Parameter 1 for Agreement Type Service Tool | ||
68 | SERVICE_PARAM2 | CACS_RULE_PARAMETER2 | CHAR32 | CHAR | 32 | 0 | Parameter 2 for Agreement Type Service Tool | ||
69 | SERVICE_PARAM3 | CACS_RULE_PARAMETER3 | CHAR32 | CHAR | 32 | 0 | Parameter 3 for Agreement Type Service Tool | ||
70 | SERVICE_PARAM4 | CACS_RULE_PARAMETER4 | CHAR32 | CHAR | 32 | 0 | Parameter 4 for Agreement Type Service Tool | ||
71 | SERVICE_PARAM5 | CACS_RULE_PARAMETER5 | CHAR32 | CHAR | 32 | 0 | Parameter 5 for Agreement Type Service Tool | ||
72 | POST_MONTH | CACSPSTMON | MONAT | NUMC | 2 | 0 | Period in Posting Year | ||
73 | VALUE_QUAN | CACSEVALQUAN | CACSEVALQUAN | QUAN | 11 | 2 | Valuation Quantity | ||
74 | DVALUE_QUAN | CACSEVALDQUAN | CACSEVALQUAN | QUAN | 11 | 2 | Valuation Quantity Change | ||
75 | VALUE_AMNT | CACSVALAMNT | CACSAMNTITEM | CURR | 15 | 2 | Valuation Amount in Commission Model Currency | ||
76 | DVALUE_AMNT | CACSVALDAMNT | CACSAMNTITEM | CURR | 15 | 2 | Valuation Amount Change in Commission Model Currency | ||
77 | LED_CURR | CACSLEDCURR | WAERS | CUKY | 5 | 0 | Currency Key | * | |
78 | CACSDUMMY | CACSDUMMY | CACS_DUMMY | DEC | 10 | 0 | Numerical Dummy Field | ||
79 | SETTL_POS | CACSSETTLPOS | CACSDOCLINE | CHAR | 4 | 0 | Identification of a Settlement Item | ||
80 | CTRTBU_ID | CACS_CTRTBU_ID | ISIS_CONTRACT_ID | CHAR | 20 | 0 | Commission Contract Number | ||
81 | DUE_DATE | CACSDUEDAT | DATUM | DATS | 8 | 0 | Due Date of Line Item | ||
82 | DUE_YEAR | CACSDUEYEAR | KJAHR | NUMC | 4 | 0 | Year Due: Document Item | ||
83 | DUE_MONTH | CACSDUEMON | MONAT | NUMC | 2 | 0 | Period in Year Due | ||
84 | STMTYPE_ID | CACS_STMTYPE_ID | CACSSTMTY | CHAR | 4 | 0 | Identification of Settlement Type | * | |
85 | DUE_CONAMNT | CACSDUECONAMNT | CACSAMNTITEM | CURR | 15 | 2 | Remuneration Amount Ready for Disbursement in Contr Currency | ||
86 | DUE_LEDAMNT | CACSDUELEDAMNT | CACSAMNTITEM | CURR | 15 | 2 | Disbursable Partial Remuner.Amount in Comm. Model Currency | ||
87 | DUE_QUAN | CACSDUEQUAN | CACSREMUQUAN | QUAN | 11 | 2 | Remuneration Quantity Ready for Disbursement | ||
88 | SETTLE_DATE | CACSPSTDAT | DATUM | DATS | 8 | 0 | Posting Date in Commission Case/Comm Doc. (Acknowledgement) | ||
89 | SETTLE_POST_YEAR | CACSDOCYEARSETTLE | KJAHR | NUMC | 4 | 0 | Posting Year of Settlement Document | ||
90 | SETTLE_DOC_ID | CACSDOCIDSETTLE | CACSOBJID10 | CHAR | 10 | 0 | Settlement Document Number | ||
91 | PMNT_BLOCK | DZLSPR | ZAHLS | CHAR | 1 | 0 | Payment Block Key | * | |
92 | REM_CASE_TXT | CACSTRICASETXT | CACSSHORTTXT | CHAR | 40 | 0 | Short Text for Commission Case | ||
93 | DOC_TYPE | CACSDOCTYPE | CACSDOCTYPE | CHAR | 1 | 0 | Document Type of Commission Document | * | |
94 | POST_DATE | CACSPSTDAT | DATUM | DATS | 8 | 0 | Posting Date in Commission Case/Comm Doc. (Acknowledgement) | ||
95 | CLC_DATE | CACSCALCDAT | DATUM | DATS | 8 | 0 | Effective Date of a Document/Case (Effective Status) | ||
96 | CLC_TIME | CACSCALCTIM | UZEIT | TIMS | 6 | 0 | Effective Time of a Document/Case (Effective Status) | ||
97 | KNW_DATE | CACSKNOWDAT | DATUM | DATS | 8 | 0 | Calculation Date of Document/Case (Knowledge Status) | ||
98 | KNW_TIME | CACSKNOWTIM | UZEIT | TIMS | 6 | 0 | Calculation Time Document/Case (Knowledge Status) | ||
99 | CHG_TCODE | CACSCDTC | TCODE | CHAR | 20 | 0 | Transaction in Which the Change Was Made | * | |
100 | CHG_USR | CACSCHUSR | USNAM | CHAR | 12 | 0 | Last user to change object | ||
101 | TRI_IMP_DATE | CACSIMPDAT | DATUM | DATS | 8 | 0 | Date Commission Case Entered in Commission System | ||
102 | TRI_CASE_ID | CACSTRICASEID | CACSOBJID10 | CHAR | 10 | 0 | Identification of a Triggering Case | ||
103 | TRI_CASE_VERS | CACSCASEVERS | CACSVERSION | NUMC | 6 | 0 | Commission Case Version | ||
104 | TRI_CASE_TXT | CACSTRICASETXT | CACSSHORTTXT | CHAR | 40 | 0 | Short Text for Commission Case | ||
105 | FLG_ASYNC_DONE | CACSFLGASYNC | XFELD | CHAR | 1 | 0 | Indicator: Totals Table Provision Complete | ||
106 | CHANGE_TYPE | CACSCASECHGTYP | CACSOPTYPE | CHAR | 1 | 0 | Commission Case Change Category | ||
107 | TRIGGER_DATE | CACSTRIDAT | DATUM | DATS | 8 | 0 | Trigger Date of Commission Case in Operational System | ||
108 | RELEASE_DATE | CACSRELDAT | DATUM | DATS | 8 | 0 | Release Date of Operational Sys. for Commission Notification | ||
109 | RUN_ID | CACSBATCHID | CACSOBJID10 | CHAR | 10 | 0 | Identification Number of Processing Run | ||
110 | TRIGGER_SYS | CACSLOGSYSTEM | LOGSYS | CHAR | 10 | 0 | Logical Operational System | * | |
111 | BUSOBJ_TYPE | CACSBUSOBJTYP | CACSBUSOBJTYP | CHAR | 3 | 0 | Business Object Category that Triggers Commission | * | |
112 | BUSOBJ_ID | CACSBUSOBJID | CACSOBJID30 | CHAR | 30 | 0 | Identification of Triggering Business Object | ||
113 | BUSOBJ_VERS | CACSVERSION | CACSVERSION | NUMC | 6 | 0 | Version of Master Data or Customizing Object | ||
114 | TRI_BUSCASE_TYP | CACSTRIBUSCASTYP | CACSBUSCASTYP | CHAR | 3 | 0 | Commission Triggering Business Case in Operational System | * | |
115 | TRI_BUSCASE_ID | CACSTRIBUSCASEID | CACSOBJID36 | CHAR | 36 | 0 | Identification of Triggering Bus. Transaction in Op. System | ||
116 | TRI_BUSCASE_VERS | CACSVERSION | CACSVERSION | NUMC | 6 | 0 | Version of Master Data or Customizing Object | ||
117 | REM_BUSCASE_ID | CACSREMBUSCASEID | CACSOBJID36 | CHAR | 36 | 0 | Identification of Triggering Bus. Transaction in Op. System | ||
118 | REM_BUSCASE_VERS | CACSVERSION | CACSVERSION | NUMC | 6 | 0 | Version of Master Data or Customizing Object | ||
119 | REV_DOC_ID | CACSREVDOCID | CACSOBJID10 | CHAR | 10 | 0 | Document Number of Related Reversal Document | ||
120 | REV_POST_YEAR | CACSREVPOSTYEAR | KJAHR | NUMC | 4 | 0 | Posting Year of Related Reversal Document | ||
121 | RESP_DATE | CACSRESPDAT | DATUM | DATS | 8 | 0 | Liability Selection Date for Viewing Liability | ||
122 | EARNED_LEDAMNT | CACSEARNLEDAMNT | CACSAMNTITEM | CURR | 15 | 2 | Remuneration Earned in Commission Model Currency | ||
123 | EARNED_QUAN | CACSEARNQUAN | CACSREMUQUAN | QUAN | 11 | 2 | Share of Earnings (Quantity) | ||
124 | TRI_OBJ_CHGTYP | CACSOBJCHANGE | CACSOBJCHANGE | CHAR | 1 | 0 | Change Category: Subobject That Triggers Commission | ||
125 | P_NUM1 | CACSCONDNUMC12_1 | CACS_NUMC12 | NUMC | 12 | 0 | Numerical Field (Data Field Condition Technique) | ||
126 | P_NUM2 | CACSCONDNUMC12_2 | CACS_NUMC12 | NUMC | 12 | 0 | Numerical Field 2 (Data Field Condition Technique) | ||
127 | P_AMNT1 | CACSCONDAMNT_1 | CACSAMNTITEM | CURR | 15 | 2 | First Amount Field (Data Field Condition Technique) | ||
128 | P_AMNT2 | CACSCONDAMNT_2 | CACSAMNTITEM | CURR | 15 | 2 | Second Amount Field (Data Field Condition Technique) | ||
129 | P_CURR1 | CACSCONDCURR_1 | WAERS | CUKY | 5 | 0 | Currency 1 (Data Field Condition Technique) | * | |
130 | P_CURR2 | CACSCONDCURR_2 | WAERS | CUKY | 5 | 0 | Currency 2 (Data Field Condition Technique) | * | |
131 | P_TEXT1 | CACS_DESC_COND | CHAR30K | CHAR | 30 | 0 | Description of Conditions | ||
132 | P_TEXT2 | CACSCONDCHAR10_2 | CHAR10 | CHAR | 10 | 0 | Text Field 2 (Data Field Condition Technique) |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | CACS_S_FLDPRC_OPT | ROBJTYPE | TCACS_COT | CALCOBJTYPE |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 200 |