YCRM01_DOCRE SAP (Commission Document, Remuneration and Liability) Table details
Description: Commission Document, Remuneration and Liability
Table field list including key, data, relationships and ABAP select examples
YCRM01_DOCRE is a standard SAP Table which is used to store Commission Document, Remuneration and Liability data and is available within R/3 SAP systems depending on the version and release level.
The YCRM01_DOCRE table consists of various fields, each holding specific information or linking keys about Commission Document, Remuneration and Liability data available in SAP. These include POST_YEAR (Assignment Year of Commission Case/Document), DOC_ID (Document Identification), REMUN_POS (ID of Remuneration Row for Referenced Document), INCENTIVE_BAS (Bonus Basis Value).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced
SAP YCRM01_DOCRE table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
POST_YEAR | Assignment Year of Commission Case/Document | CACSPSTYEAR | NUMC | 4 | KJAHR | CACSPSTYEAR | |||
DOC_ID | Document Identification | CACSDOCID | CHAR | 10 | ALPHA | CACSOBJID10 | CACSDOCID | ||
REMUN_POS | ID of Remuneration Row for Referenced Document | CACSREMUNPOS | CHAR | 4 | ALPHA | CACSDOCLINE | |||
INCENTIVE_BAS | Bonus Basis Value | INCENTIVE_BASIS_VALUE_CUM | CURR | 15(2) | WERTV8 | ||||
COMM_BAS_VAL | Commission Basis Value | CACS_CRM_COMMBAS_VALUE_CUM | CURR | 15(2) | WERTV8 | ||||
GUID | Transaction GUID | CACS_CRM_PROZESS_GUID_32 | CHAR | 32 | SYSUUID_C | ||||
ITEM_GUID | Transaction GUID | CACS_CRM_PROZESS_GUID_32 | CHAR | 32 | SYSUUID_C | ||||
CURRENCY | Currency | CACS_CRM_CURRENCY | CUKY | 5 | Assigned to domain | WAERS | |||
COMM_TRI_DATE | Date of Commission Run Start | CACS_CRM_COMMISS_TRIGGER_DATE | DATS | 8 | |||||
ZACHV | 0 | ||||||||
ZCMBASV | 0 | ||||||||
ZDOCVALUE | 0 | ||||||||
ZINCTPY | 0 | ||||||||
ZORDERVAL | 0 | ||||||||
ZPRDSALES | 0 | ||||||||
ZRTNVALUE | 0 | ||||||||
ZSRVSALES | 0 | ||||||||
ZTGINCT | 0 | ||||||||
VRKME | Sales unit | VRKME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
CURR_YR_TO_DATE | 0 | ||||||||
PREV_YR_TO_DATE | 0 | ||||||||
EXO_MONTHLY | 0 | ||||||||
SUP_MONTHLY | 0 | ||||||||
EXO_QTR_PLAN | 0 | ||||||||
SUP_QTR_ACTUAL | 0 | ||||||||
EXO_QTR_ACTUAL | 0 | ||||||||
SUP_QTR_PLAN | 0 | ||||||||
FLG_COMPL | Indicator: Document Part Created by Complete Update | CACSFLGCOMPL | CHAR | 1 | BOOLEAN_FLG | ||||
FLG_REVERSED | Indicator: Row/Object/Subobject is Invalid or Reversed | CACSFLGREV | CHAR | 1 | FLAG | ||||
STATUS_POS | Status of Object/Subobject | CACSSTATUSPOS | CHAR | 1 | TCACS_VALSTAT2 | CACSSTATUSVERS | |||
STATUS_WORK | Object Processing Status (Replica) | CACSSTATUSWORKP | CHAR | 1 | CACSSTATUSWORK | ||||
PART_POS | Position of Participation in a Commission Case | CACSPARTID | CHAR | 4 | ALPHA | CACSDOCLINE | |||
INV_POS | Participant Position in a Participation | CACSINVPOS | CHAR | 4 | ALPHA | CACSDOCLINE | |||
CTRTBU_ID | Commission Contract Number | CACS_CTRTBU_ID | CHAR | 20 | ALPHA | ISIS_CONTRACT_ID | CACSCTBU | CACS | |
BUCAGR_ID | Agreement Number | CACS_BUCAGR_ID | CHAR | 12 | CHAR12 | ||||
CLAIM_OBJTYPE | Entitlement Object Type | CACSCLAIMOBJTYPE | CHAR | 1 | CACSCLAIMOBJTYPE | ||||
CLAIM_OBJID | ID of Entitlement Object Acc. to Entitlement Object Type | CACSCLAIMOBJID | CHAR | 30 | CACSOBJID30NOCONV | ||||
REM_IMP_YEAR | Year Commission Case Reported | CACSIMPYEAR | NUMC | 4 | KJAHR | CACSIMPYEAR | |||
REM_CASE_ID | Identification of a Case Resulting in Remuneration | CACSREMCASEID | CHAR | 10 | ALPHA | CACSOBJID10 | |||
REM_CASE_VERS | Commission Case Version | CACSCASEVERS | NUMC | 6 | CACSVERSION | CACSCASEVERS | |||
POW_OBJ_TYPE | Subobject Type Where Activity Originates | CACSPOWOBJ | CHAR | 5 | Assigned to domain | CACSOBTYID | |||
POW_OBJ_ID | Identification of Subobject of Activity Provided | CACSPOWOBJID | CHAR | 12 | ALPHA | CACSOBJID12 | |||
ACTIVITY | Activity Type | CACSACT | CHAR | 4 | Assigned to domain | CACSACT | |||
ACT_POS | Identification of an Activity Line | CACSACTPOS | CHAR | 4 | ALPHA | CACSDOCLINE | |||
ACTGRP | Role | CACSACTGRP | CHAR | 4 | TCACS_ACTGRP | CACSACTGRP | CACS_TCACS_ACTGRP | ||
REM_OBJ_TYPE | Remunerating Subobject Type | CACSREMOBJ | CHAR | 5 | Assigned to domain | CACSOBTYID | CACS_OBJDAT | ||
REM_OBJ_ID | Identification of Subobject Resulting in Remuneration | CACSREMOBJID | CHAR | 12 | ALPHA | CACSOBJID12 | |||
VALUE | Valuation Type | CACSVAL | CHAR | 4 | TCACS_VAL | CACSVAL | CACS_VAL | ||
VALUE_TYPE | Valuation Result Category | CACSVALTYPE | NUMC | 1 | CACSVALTYPE | ||||
VALUE_POS | Valuation Row Identification | CACSVALUEPOS | CHAR | 4 | ALPHA | CACSDOCLINE | |||
REMVAL_LEDAMNT | Remuneration Value in Commission Model Currency | CACSREMVALAMNT | CURR | 15(2) | CACSAMNTITEM | ||||
REMVAL_QUAN | Remuneration Value (Volume) | CACSREMVALQUAN | QUAN | 11(2) | CACSEVALQUAN | ||||
VALUE_UNIT | Valuation Unit | CACSEVALUNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ROLE | Participant Role | CACSROLE | CHAR | 3 | TCACS_ROLE | CACSROLE | CACSROLE | ||
ROLE_REMUSHAR | Share of Remuneration (in Percent) | CACSREMUSHARE | DEC | 10(5) | CACSPERCENT5 | ||||
CONSTELL | Constellation of Participants | CACSCONS | CHAR | 4 | CHAR4 | ||||
DIST_TYPE | Remuneration Participation Category | CACSDISTTYPE | CHAR | 1 | CACSDISTTYPE | ||||
CON_CURR | Contract Currency Key | CACSCONCURR | CUKY | 5 | TCURC | WAERS | FWS | ||
LED_CURR | Currency Key | CACSLEDCURR | CUKY | 5 | TCURC | WAERS | |||
ALLOCATION | Offsetting Selectn (Excess/Sub-Threshold Earnings, Advances) | CACSALLOC | CHAR | 1 | CACSALLOC | ||||
REMUNERATION | Remuneration Type | CACSREM | CHAR | 4 | TCACS_REM | CACSREM | CACS_REM | ||
REM_VERSION | Version of Master Data or Customizing Object | CACSVERSION | NUMC | 6 | CACSVERSION | ||||
REM_RATE | Remuneration Record (For Example, Percentage) | CACSREMRATE | DEC | 8(3) | CACSPERCENT | ||||
REM_CONAMNT | Remuneration Entitlement, Amount in Contract Currency | CACSREMUCONAMNT | CURR | 15(2) | CACSAMNTITEM | ||||
DUE_CONAMNT | Remuneration Amount Ready for Disbursement in Contr Currency | CACSDUECONAMNT | CURR | 15(2) | CACSAMNTITEM | ||||
REM_LEDAMNT | Remunerat. Entitlement, Amount in Commission Model Currency | CACSREMULEDAMNT | CURR | 15(2) | CACSAMNTITEM | ||||
DUE_LEDAMNT | Disbursable Partial Remuner.Amount in Comm. Model Currency | CACSDUELEDAMNT | CURR | 15(2) | CACSAMNTITEM | ||||
REM_UNIT | Remuneration Unit | CACSREMUUNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
REM_QUAN | Remuneration Entitlement as Quantity | CACSREMUQUAN | QUAN | 11(2) | CACSREMUQUAN | ||||
DUE_QUAN | Remuneration Quantity Ready for Disbursement | CACSDUEQUAN | QUAN | 11(2) | CACSREMUQUAN | ||||
OFFSET_END_DATE | End of Offsetting | CACSOFFSEDAT | DATS | 8 | DATUM | ||||
OFFSET_RULE_ID | Offsetting Type | CACSOFFSETRULE | CHAR | 4 | TCACS_OFFS | CACSOFFSETRULE | |||
OFFSET_CONAMNT | Remaining Offset Amount in Contract Currency | CACSOFFSCONAMNT | CURR | 15(2) | CACSAMNTITEM | ||||
OFFSET_LEDAMNT | Offsetting/Secondary Liability Amt Remaining in ComModCurr. | CACSOFFSLEDAMNT | CURR | 15(2) | CACSAMNTITEM | ||||
OFFSET_QUAN | Offsetting/Remaining Secondary Liability Quantity | CACSOFFSQUAN | QUAN | 11(2) | CACSRESPQUAN | ||||
RESP_BEGIN_DATE | Liability Start | CACSRESPBDAT | DATS | 8 | DATUM | ||||
RESP_END_DATE | Liability End | CACSRESPEDAT | DATS | 8 | DATUM | ||||
RESP_RULE_ID | Liability Type | CACSRESPRULE | CHAR | 4 | Assigned to domain | CACSRESPRULE | |||
RESP_CONAMNT | Remaining Liability Amount in Contract Currency | CACSRESPCONAMNT | CURR | 15(2) | CACSAMNTITEM | ||||
RESP_LEDAMNT | Remaining Liability Value in Commission Model Currency | CACSRESPLEDAMNT | CURR | 15(2) | CACSAMNTITEM | ||||
RESP_QUAN | Remaining liability Quantity | CACSRESPQUAN | QUAN | 11(2) | CACSRESPQUAN | ||||
RESPVAL_LEDAMNT | Remaining Liability Value in Commission Model Currency | CACSRESPVALAMNT | CURR | 15(2) | CACSAMNTITEM | ||||
RESPVAL_QUAN | Remaining Liability Value (Quantity) | CACSRESPVALQUAN | QUAN | 11(2) | CACSEVALQUAN | ||||
STATUS_RESP | Liability Status | CACSSTATUSRESP | CHAR | 1 | CACSSTATUSVAL | ||||
RESP_RUPT_BEGIN | Date of Interruption Start | CACSRUPTDATE_B | NUMC | 14 | TSTPS | CACSTIMESTAMP | |||
RESP_RUPT_END | Date of Required End of Interruption | CACSRUPTDATE_E | NUMC | 14 | TSTPS | CACSTIMESTAMP | |||
CORRBY_DOC_ID | Document Used to Correct This Row | CACSCORRBYDOCID | CHAR | 10 | ALPHA | CACSOBJID10 | |||
CORRBY_PST_YEAR | Assignment Year Document Used for Correcting Row | CACSCORRBYPSTYEAR | NUMC | 4 | KJAHR | ||||
CORRBY_PST_DATE | Posting Date in Commission Case/Comm Doc. (Acknowledgement) | CACSPSTDAT | DATS | 8 | DATUM | ||||
CORRTO_DOC_ID | ID of Corrected Document | CACSCORRTODOCID | CHAR | 10 | ALPHA | CACSOBJID10 | |||
CORRTO_PST_YEAR | Assignment Year Document That Corrected This Row | CACSCORRTOPSTYEAR | NUMC | 4 | KJAHR | ||||
CORRTO_REMUN_POS | ID of Remuneration Row in Corrected Document | CACSCORRTOREMUNPOS | CHAR | 4 | ALPHA | CACSDOCLINE | |||
FLG_CORR | Indicator: Document Part Created by a Correction | CACSFLGCORR | CHAR | 1 | BOOLEAN_FLG | ||||
SETTLE_GROUP | Settlement Item Grouping in Document | CACSSETTLEGROUP | CHAR | 4 | ALPHA | CACSDOCLINE | |||
UPD_TIMESTAMP | Last Change of Objects | CACSUPDTSTMP | NUMC | 14 | TSTPS | CACSTIMESTAMP |
Key field | Non-key field |
How do I retrieve data from SAP table YCRM01_DOCRE using ABAP code
The following ABAP code Example will allow you to do a basic selection on YCRM01_DOCRE to SELECT all data from the tableDATA: WA_YCRM01_DOCRE TYPE YCRM01_DOCRE.
SELECT SINGLE *
FROM YCRM01_DOCRE
INTO CORRESPONDING FIELDS OF WA_YCRM01_DOCRE
WHERE...
How to access SAP table YCRM01_DOCRE
Within an ECC or HANA version of SAP you can also view further information about YCRM01_DOCRE and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects