1. Home
  2. Resources
  3. SAP Tables
  4. YTEL05_S_DOCREM_XL - Commn: Enhanced Remuneration Row (Used Internally Only)

SAP Table YTEL05_S_DOCREM_XL

Commn: Enhanced Remuneration Row (Used Internally Only)

YTEL05_S_DOCREM_XL (Commn: Enhanced Remuneration Row (Used Internally Only)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link YTEL05_S_DOCREM_XL to other SAP tables.

YTEL05_S_DOCREM_XL table fields

Field Data element Checktable Datatype Length Decimals
P_VERSION Version Date as Timestamp CACS_COND_VERSION NUMC 14 0
P_CTRT_XL Agreement Number Including Contract Type Indicator CACS_COND_CTRTID_XL CHAR 21 0
P_CACSAPPL Commission Application (ICM) CACSAPPL CHAR 6 0
P_STATE Condition Record Status CACSCONDSTATE CHAR 1 0
NULL Valid
P Parked
I Invalid (Active)
O Invalid (Parked)
P_NUM1 Numerical Field (Data Field Condition Technique) CACSCONDNUMC12_1 NUMC 12 0
P_NUM2 Numerical Field 2 (Data Field Condition Technique) CACSCONDNUMC12_2 NUMC 12 0
P_AMNT1 First Amount Field (Data Field Condition Technique) CACSCONDAMNT_1 CURR 15 2
P_AMNT2 Second Amount Field (Data Field Condition Technique) CACSCONDAMNT_2 CURR 15 2
P_CURR1 Currency 1 (Data Field Condition Technique) CACSCONDCURR_1 CUKY 5 0
P_CURR2 Currency 2 (Data Field Condition Technique) CACSCONDCURR_2 CUKY 5 0
P_TEXT1 Description of Conditions CACS_DESC_COND CHAR 30 0
P_TEXT2 Text Field 2 (Data Field Condition Technique) CACSCONDCHAR10_2 CHAR 10 0
INCENTIVE_BAS Bonus Basis Value INCENTIVE_BASIS_VALUE_CUM CURR 15 2
COMM_BAS_VAL Commission Basis Value CACS_CRM_COMMBAS_VALUE_CUM CURR 15 2
CATEGORY_ID Category ID CACS_COM_CATEGORY_ID CHAR 20 0
REM_BUSCASE_TYP Remunerating Business Transaction in Operational System CACSREMBUSCASTYP CHAR 3 0
GUID Transaction GUID CACS_CRM_PROZESS_GUID_32 CHAR 32 0
ITEM_GUID Transaction GUID CACS_CRM_PROZESS_GUID_32 CHAR 32 0
CURRENCY Currency CACS_CRM_CURRENCY CUKY 5 0
COMM_TRI_DATE Date of Commission Run Start CACS_CRM_COMMISS_TRIGGER_DATE DATS 8 0
MANDT Client MANDT CLNT 3 0
POST_YEAR Assignment Year of Commission Case/Document CACSPSTYEAR NUMC 4 0
DOC_ID Document Identification CACSDOCID CHAR 10 0
REMUN_POS ID of Remuneration Row for Referenced Document CACSREMUNPOS CHAR 4 0
FLG_COMPL Indicator: Document Part Created by Complete Update CACSFLGCOMPL CHAR 1 0
X True
NULL False
FLG_REVERSED Indicator: Row/Object/Subobject is Invalid or Reversed CACSFLGREV CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
STATUS_POS Status of Object/Subobject CACSSTATUSPOS CHAR 1 0
/ Unknown
0 Inconsistent (incorrect)
1 Consistent (o.k. - not double checked)
2 Checked consistent (o.k. - double checked)
STATUS_WORK Object Processing Status (Replica) CACSSTATUSWORKP CHAR 1 0
/ Unknown
0 Accepted
1 For Checking (Dual Check)
2 Waiting f. Predecess.
3 Parked
6 For Checking (Triggered by Predec.)
8 Rejected (After Dual Check)
9 Released for Subseq.Processes
- Rejected (Not Stored on DB)
$ Simulated (Not Used in this Release)
PART_POS Position of Participation in a Commission Case CACSPARTID CHAR 4 0
INV_POS Participant Position in a Participation CACSINVPOS CHAR 4 0
CTRTBU_ID Commission Contract Number CACS_CTRTBU_ID CHAR 20 0
BUCAGR_ID Agreement Number CACS_BUCAGR_ID CHAR 12 0
CLAIM_OBJTYPE Entitlement Object Type CACSCLAIMOBJTYPE CHAR 1 0
1 Activities of Participation (Direct Participant)
2 Business Object (Portfolio)
3 Participant (Indirect Participant)
4 Partner/Commission Contract (Indirect Participant)
5 Representative (Direct Participant of Group)
CLAIM_OBJID ID of Entitlement Object Acc. to Entitlement Object Type CACSCLAIMOBJID CHAR 30 0
REM_IMP_YEAR Year Commission Case Reported CACSIMPYEAR NUMC 4 0
REM_CASE_ID Identification of a Case Resulting in Remuneration CACSREMCASEID CHAR 10 0
REM_CASE_VERS Commission Case Version CACSCASEVERS NUMC 6 0
POW_OBJ_TYPE Subobject Type Where Activity Originates CACSPOWOBJ CHAR 5 0
POW_OBJ_ID Identification of Subobject of Activity Provided CACSPOWOBJID CHAR 12 0
ACTIVITY Activity Type CACSACT CHAR 4 0
ACT_POS Identification of an Activity Line CACSACTPOS CHAR 4 0
ACTGRP Role CACSACTGRP CHAR 4 0
REM_OBJ_TYPE Remunerating Subobject Type CACSREMOBJ CHAR 5 0
REM_OBJ_ID Identification of Subobject Resulting in Remuneration CACSREMOBJID CHAR 12 0
VALUE Valuation Type CACSVAL CHAR 4 0
VALUE_TYPE Valuation Result Category CACSVALTYPE NUMC 1 0
1 Absolute Valuation
2 Difference Valuation
VALUE_POS Valuation Row Identification CACSVALUEPOS CHAR 4 0
REMVAL_LEDAMNT Remuneration Value in Commission Model Currency CACSREMVALAMNT CURR 15 2
REMVAL_QUAN Remuneration Value (Volume) CACSREMVALQUAN QUAN 11 2
VALUE_UNIT Valuation Unit CACSEVALUNIT UNIT 3 0
ROLE Participant Role CACSROLE CHAR 3 0
ROLE_REMUSHAR Share of Remuneration (in Percent) CACSREMUSHARE DEC 10 5
CONSTELL Constellation of Participants CACSCONS CHAR 4 0
DIST_TYPE Remuneration Participation Category CACSDISTTYPE CHAR 1 0
NULL Activity participation
1 Base value splitting
2 Results value splitting
CON_CURR Contract Currency Key CACSCONCURR CUKY 5 0
LED_CURR Currency Key CACSLEDCURR CUKY 5 0
ALLOCATION Offsetting Selectn (Excess/Sub-Threshold Earnings, Advances) CACSALLOC CHAR 1 0
1 No Offsetting
2 Offset to Next Period
3 Offset at Agreement End
4 Offset w.o Deadline
REMUNERATION Remuneration Type CACSREM CHAR 4 0
REM_VERSION Version of Master Data or Customizing Object CACSVERSION NUMC 6 0
REM_RATE Remuneration Record (For Example, Percentage) CACSREMRATE DEC 8 3
REM_CONAMNT Remuneration Entitlement, Amount in Contract Currency CACSREMUCONAMNT CURR 15 2
DUE_CONAMNT Remuneration Amount Ready for Disbursement in Contr Currency CACSDUECONAMNT CURR 15 2
REM_LEDAMNT Remunerat. Entitlement, Amount in Commission Model Currency CACSREMULEDAMNT CURR 15 2
DUE_LEDAMNT Disbursable Partial Remuner.Amount in Comm. Model Currency CACSDUELEDAMNT CURR 15 2
REM_UNIT Remuneration Unit CACSREMUUNIT UNIT 3 0
REM_QUAN Remuneration Entitlement as Quantity CACSREMUQUAN QUAN 11 2
DUE_QUAN Remuneration Quantity Ready for Disbursement CACSDUEQUAN QUAN 11 2
OFFSET_END_DATE End of Offsetting CACSOFFSEDAT DATS 8 0
OFFSET_RULE_ID Offsetting Type CACSOFFSETRULE CHAR 4 0
OFFSET_CONAMNT Remaining Offset Amount in Contract Currency CACSOFFSCONAMNT CURR 15 2
OFFSET_LEDAMNT Offsetting/Secondary Liability Amt Remaining in ComModCurr. CACSOFFSLEDAMNT CURR 15 2
OFFSET_QUAN Offsetting/Remaining Secondary Liability Quantity CACSOFFSQUAN QUAN 11 2
RESP_BEGIN_DATE Liability Start CACSRESPBDAT DATS 8 0
RESP_END_DATE Liability End CACSRESPEDAT DATS 8 0
RESP_RULE_ID Liability Type CACSRESPRULE CHAR 4 0
RESP_CONAMNT Remaining Liability Amount in Contract Currency CACSRESPCONAMNT CURR 15 2
RESP_LEDAMNT Remaining Liability Value in Commission Model Currency CACSRESPLEDAMNT CURR 15 2
RESP_QUAN Remaining liability Quantity CACSRESPQUAN QUAN 11 2
RESPVAL_LEDAMNT Remaining Liability Value in Commission Model Currency CACSRESPVALAMNT CURR 15 2
RESPVAL_QUAN Remaining Liability Value (Quantity) CACSRESPVALQUAN QUAN 11 2
STATUS_RESP Liability Status CACSSTATUSRESP CHAR 1 0
NULL Active
1 Interrupted
RESP_RUPT_BEGIN Date of Interruption Start CACSRUPTDATE_B NUMC 14 0
RESP_RUPT_END Date of Required End of Interruption CACSRUPTDATE_E NUMC 14 0
CORRBY_DOC_ID Document Used to Correct This Row CACSCORRBYDOCID CHAR 10 0
CORRBY_PST_YEAR Assignment Year Document Used for Correcting Row CACSCORRBYPSTYEAR NUMC 4 0
CORRBY_PST_DATE Posting Date in Commission Case/Comm Doc. (Acknowledgement) CACSPSTDAT DATS 8 0
CORRTO_DOC_ID ID of Corrected Document CACSCORRTODOCID CHAR 10 0
CORRTO_PST_YEAR Assignment Year Document That Corrected This Row CACSCORRTOPSTYEAR NUMC 4 0
CORRTO_REMUN_POS ID of Remuneration Row in Corrected Document CACSCORRTOREMUNPOS CHAR 4 0
FLG_CORR Indicator: Document Part Created by a Correction CACSFLGCORR CHAR 1 0
X True
NULL False
SETTLE_GROUP Settlement Item Grouping in Document CACSSETTLEGROUP CHAR 4 0
GPART_CTRT Number of The Commission Contract Partner Participating CACS_GPART_CTRT CHAR 10 0
CTRTST_ID Number of Standard Commission Contract CACS_CTRTST_ID CHAR 20 0
CTRT_TYPE Commission Contract Type CACS_CTRT_TYPE CHAR 3 0
AGR_TYP Agreement Type CACS_AGR_TYP CHAR 2 0
STCAGR_ID Standard Agreement Number CACS_STCAGR_ID CHAR 12 0
GPART Number of Commission Contract Partner CACS_GPART CHAR 10 0
QUALIFICATION Suitability of a Participant CACSQUALRATE DEC 8 3
DISTRIBUTE Distribution Key for the Activity Share CACSDISTRIBUTE INT4 10 0
FLG_INDIV_COND Indicates a remuneration row as being individualized CACSFLGINDIVCOND CHAR 1 0
X True
NULL False
POST_DATE Posting Date in Commission Case/Comm Doc. (Acknowledgement) CACSPSTDAT DATS 8 0
POST_MONTH Period in Posting Year CACSPSTMON NUMC 2 0
TRI_OBJ_TYPE Triggering Subobject Type CACSTRIOBJ CHAR 5 0
TRI_OBJ_ID Identification of Triggering Subobject CACSTRIOBJID CHAR 12 0
TRI_OBJ_ID_EXT External Identification of Triggering Subobject CACSTRIOBJIDEXT CHAR 36 0
STATUS_VAL Valuation Status CACSSTATUSVAL CHAR 1 0
NULL Active
1 Interrupted
RESP_DATE Liability Selection Date for Viewing Liability CACSRESPDAT DATS 8 0
VALUE_AMNT_RUPT Interrupted Valuation Amount in Commission Model Currency CACSVALAMNTRUPT CURR 15 2
VALUE_QUAN_RUPT Interrupted Valuation Quantity CACSEVALQUANRUPT QUAN 11 2
EARNED_LEDAMNT Remuneration Earned in Commission Model Currency CACSEARNLEDAMNT CURR 15 2
EARNED_QUAN Share of Earnings (Quantity) CACSEARNQUAN QUAN 11 2
EACLIAB Early Cancellation Liability CACSEARLCANCLIAB CHAR 1 0
NULL No Early Cancellation Liability
X Early Cancellation Liability
ROBJTYPE Calculating Object Type CACSCALCOBJTYPE CHAR 2 0
ROBJID Identification of Calculating Object CACSCALCOBJID CHAR 5 0
LOG_SERVICE Logical Service for Agreement Rules CACS_RULE_LOG_SERVICE CHAR 10 0
SERVICETOOL Service Tool for Agreement Type CACS_RULE_SERVTOOL CHAR 32 0
SERVICE_ID Service Identification for Service Tool CACS_RULE_SERVID CHAR 10 0
SERVICE_PARAM1 Parameter 1 for Agreement Type Service Tool CACS_RULE_PARAMETER1 CHAR 32 0
SERVICE_PARAM2 Parameter 2 for Agreement Type Service Tool CACS_RULE_PARAMETER2 CHAR 32 0
SERVICE_PARAM3 Parameter 3 for Agreement Type Service Tool CACS_RULE_PARAMETER3 CHAR 32 0
SERVICE_PARAM4 Parameter 4 for Agreement Type Service Tool CACS_RULE_PARAMETER4 CHAR 32 0
SERVICE_PARAM5 Parameter 5 for Agreement Type Service Tool CACS_RULE_PARAMETER5 CHAR 32 0
CACSDUMMY Numerical Dummy Field CACSDUMMY DEC 10 0
REM_LEDAMNT_BASE Remunerat. Entitlement, Amount in Commission Model Currency CACSREMULEDAMNT CURR 15 2
REM_QUAN_BASE Remuneration Entitlement as Quantity CACSREMUQUAN QUAN 11 2
OFFSETTING_GROUP Remuneration Group for Remuneration Clearing CACS_OFFSETTING_GROUP INT4 10 0
SEL_ATTRIBUTE Selection Feature CACSSELATTRIBUTE CHAR 4 0