YCRM01_DOCRE SAP (Commission Document, Remuneration and Liability) Table details

Dictionary Type: Table
Description: Commission Document, Remuneration and Liability




ABAP Code to SELECT data from YCRM01_DOCRE
Related tables to YCRM01_DOCRE
Access table YCRM01_DOCRE




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
MANDTClient MANDTCLNT3Assigned to domainMANDT
POST_YEARAssignment Year of Commission Case/Document CACSPSTYEARNUMC4KJAHRCACSPSTYEAR
DOC_IDDocument Identification CACSDOCIDCHAR10ALPHACACSOBJID10CACSDOCID
REMUN_POSID of Remuneration Row for Referenced Document CACSREMUNPOSCHAR4ALPHACACSDOCLINE
INCENTIVE_BASBonus Basis Value INCENTIVE_BASIS_VALUE_CUMCURR15(2) WERTV8
COMM_BAS_VALCommission Basis Value CACS_CRM_COMMBAS_VALUE_CUMCURR15(2) WERTV8
GUIDTransaction GUID CACS_CRM_PROZESS_GUID_32CHAR32SYSUUID_C
ITEM_GUIDTransaction GUID CACS_CRM_PROZESS_GUID_32CHAR32SYSUUID_C
CURRENCYCurrency CACS_CRM_CURRENCYCUKY5Assigned to domainWAERS
COMM_TRI_DATEDate of Commission Run Start CACS_CRM_COMMISS_TRIGGER_DATEDATS8
ZACHV 0
ZCMBASV 0
ZDOCVALUE 0
ZINCTPY 0
ZORDERVAL 0
ZPRDSALES 0
ZRTNVALUE 0
ZSRVSALES 0
ZTGINCT 0
VRKMESales unit VRKMEUNIT3Assigned to domainCUNITMEINS
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_COMPLIndicator: Document Part Created by Complete Update CACSFLGCOMPLCHAR1BOOLEAN_FLG
FLG_REVERSEDIndicator: Row/Object/Subobject is Invalid or Reversed CACSFLGREVCHAR1FLAG
STATUS_POSStatus of Object/Subobject CACSSTATUSPOSCHAR1TCACS_VALSTAT2CACSSTATUSVERS
STATUS_WORKObject Processing Status (Replica) CACSSTATUSWORKPCHAR1CACSSTATUSWORK
PART_POSPosition of Participation in a Commission Case CACSPARTIDCHAR4ALPHACACSDOCLINE
INV_POSParticipant Position in a Participation CACSINVPOSCHAR4ALPHACACSDOCLINE
CTRTBU_IDCommission Contract Number CACS_CTRTBU_IDCHAR20ALPHAISIS_CONTRACT_IDCACSCTBUCACS
BUCAGR_IDAgreement Number CACS_BUCAGR_IDCHAR12CHAR12
CLAIM_OBJTYPEEntitlement Object Type CACSCLAIMOBJTYPECHAR1CACSCLAIMOBJTYPE
CLAIM_OBJIDID of Entitlement Object Acc. to Entitlement Object Type CACSCLAIMOBJIDCHAR30CACSOBJID30NOCONV
REM_IMP_YEARYear Commission Case Reported CACSIMPYEARNUMC4KJAHRCACSIMPYEAR
REM_CASE_IDIdentification of a Case Resulting in Remuneration CACSREMCASEIDCHAR10ALPHACACSOBJID10
REM_CASE_VERSCommission Case Version CACSCASEVERSNUMC6CACSVERSIONCACSCASEVERS
POW_OBJ_TYPESubobject Type Where Activity Originates CACSPOWOBJCHAR5Assigned to domainCACSOBTYID
POW_OBJ_IDIdentification of Subobject of Activity Provided CACSPOWOBJIDCHAR12ALPHACACSOBJID12
ACTIVITYActivity Type CACSACTCHAR4Assigned to domainCACSACT
ACT_POSIdentification of an Activity Line CACSACTPOSCHAR4ALPHACACSDOCLINE
ACTGRPRole CACSACTGRPCHAR4TCACS_ACTGRPCACSACTGRPCACS_TCACS_ACTGRP
REM_OBJ_TYPERemunerating Subobject Type CACSREMOBJCHAR5Assigned to domainCACSOBTYIDCACS_OBJDAT
REM_OBJ_IDIdentification of Subobject Resulting in Remuneration CACSREMOBJIDCHAR12ALPHACACSOBJID12
VALUEValuation Type CACSVALCHAR4TCACS_VALCACSVALCACS_VAL
VALUE_TYPEValuation Result Category CACSVALTYPENUMC1CACSVALTYPE
VALUE_POSValuation Row Identification CACSVALUEPOSCHAR4ALPHACACSDOCLINE
REMVAL_LEDAMNTRemuneration Value in Commission Model Currency CACSREMVALAMNTCURR15(2) CACSAMNTITEM
REMVAL_QUANRemuneration Value (Volume) CACSREMVALQUANQUAN11(2) CACSEVALQUAN
VALUE_UNITValuation Unit CACSEVALUNITUNIT3Assigned to domainCUNITMEINS
ROLEParticipant Role CACSROLECHAR3TCACS_ROLECACSROLECACSROLE
ROLE_REMUSHARShare of Remuneration (in Percent) CACSREMUSHAREDEC10(5) CACSPERCENT5
CONSTELLConstellation of Participants CACSCONSCHAR4CHAR4
DIST_TYPERemuneration Participation Category CACSDISTTYPECHAR1CACSDISTTYPE
CON_CURRContract Currency Key CACSCONCURRCUKY5TCURCWAERSFWS
LED_CURRCurrency Key CACSLEDCURRCUKY5TCURCWAERS
ALLOCATIONOffsetting Selectn (Excess/Sub-Threshold Earnings, Advances) CACSALLOCCHAR1CACSALLOC
REMUNERATIONRemuneration Type CACSREMCHAR4TCACS_REMCACSREMCACS_REM
REM_VERSIONVersion of Master Data or Customizing Object CACSVERSIONNUMC6CACSVERSION
REM_RATERemuneration Record (For Example, Percentage) CACSREMRATEDEC8(3) CACSPERCENT
REM_CONAMNTRemuneration Entitlement, Amount in Contract Currency CACSREMUCONAMNTCURR15(2) CACSAMNTITEM
DUE_CONAMNTRemuneration Amount Ready for Disbursement in Contr Currency CACSDUECONAMNTCURR15(2) CACSAMNTITEM
REM_LEDAMNTRemunerat. Entitlement, Amount in Commission Model Currency CACSREMULEDAMNTCURR15(2) CACSAMNTITEM
DUE_LEDAMNTDisbursable Partial Remuner.Amount in Comm. Model Currency CACSDUELEDAMNTCURR15(2) CACSAMNTITEM
REM_UNITRemuneration Unit CACSREMUUNITUNIT3Assigned to domainCUNITMEINS
REM_QUANRemuneration Entitlement as Quantity CACSREMUQUANQUAN11(2) CACSREMUQUAN
DUE_QUANRemuneration Quantity Ready for Disbursement CACSDUEQUANQUAN11(2) CACSREMUQUAN
OFFSET_END_DATEEnd of Offsetting CACSOFFSEDATDATS8DATUM
OFFSET_RULE_IDOffsetting Type CACSOFFSETRULECHAR4TCACS_OFFSCACSOFFSETRULE
OFFSET_CONAMNTRemaining Offset Amount in Contract Currency CACSOFFSCONAMNTCURR15(2) CACSAMNTITEM
OFFSET_LEDAMNTOffsetting/Secondary Liability Amt Remaining in ComModCurr. CACSOFFSLEDAMNTCURR15(2) CACSAMNTITEM
OFFSET_QUANOffsetting/Remaining Secondary Liability Quantity CACSOFFSQUANQUAN11(2) CACSRESPQUAN
RESP_BEGIN_DATELiability Start CACSRESPBDATDATS8DATUM
RESP_END_DATELiability End CACSRESPEDATDATS8DATUM
RESP_RULE_IDLiability Type CACSRESPRULECHAR4Assigned to domainCACSRESPRULE
RESP_CONAMNTRemaining Liability Amount in Contract Currency CACSRESPCONAMNTCURR15(2) CACSAMNTITEM
RESP_LEDAMNTRemaining Liability Value in Commission Model Currency CACSRESPLEDAMNTCURR15(2) CACSAMNTITEM
RESP_QUANRemaining liability Quantity CACSRESPQUANQUAN11(2) CACSRESPQUAN
RESPVAL_LEDAMNTRemaining Liability Value in Commission Model Currency CACSRESPVALAMNTCURR15(2) CACSAMNTITEM
RESPVAL_QUANRemaining Liability Value (Quantity) CACSRESPVALQUANQUAN11(2) CACSEVALQUAN
STATUS_RESPLiability Status CACSSTATUSRESPCHAR1CACSSTATUSVAL
RESP_RUPT_BEGINDate of Interruption Start CACSRUPTDATE_BNUMC14TSTPSCACSTIMESTAMP
RESP_RUPT_ENDDate of Required End of Interruption CACSRUPTDATE_ENUMC14TSTPSCACSTIMESTAMP
CORRBY_DOC_IDDocument Used to Correct This Row CACSCORRBYDOCIDCHAR10ALPHACACSOBJID10
CORRBY_PST_YEARAssignment Year Document Used for Correcting Row CACSCORRBYPSTYEARNUMC4KJAHR
CORRBY_PST_DATEPosting Date in Commission Case/Comm Doc. (Acknowledgement) CACSPSTDATDATS8DATUM
CORRTO_DOC_IDID of Corrected Document CACSCORRTODOCIDCHAR10ALPHACACSOBJID10
CORRTO_PST_YEARAssignment Year Document That Corrected This Row CACSCORRTOPSTYEARNUMC4KJAHR
CORRTO_REMUN_POSID of Remuneration Row in Corrected Document CACSCORRTOREMUNPOSCHAR4ALPHACACSDOCLINE
FLG_CORRIndicator: Document Part Created by a Correction CACSFLGCORRCHAR1BOOLEAN_FLG
SETTLE_GROUPSettlement Item Grouping in Document CACSSETTLEGROUPCHAR4ALPHACACSDOCLINE
UPD_TIMESTAMPLast Change of Objects CACSUPDTSTMPNUMC14TSTPSCACSTIMESTAMP

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 table
DATA: 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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!