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
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