YCRM01_DOCVA SAP (Commission Document, Valuation) Table details

Dictionary Type: Table
Description: Commission Document, Valuation




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




Table field list including key, data, relationships and ABAP select examples

YCRM01_DOCVA is a standard SAP Table which is used to store Commission Document, Valuation data and is available within R/3 SAP systems depending on the version and release level.

The YCRM01_DOCVA table consists of various fields, each holding specific information or linking keys about Commission Document, Valuation data available in SAP. These include POST_YEAR (Assignment Year of Commission Case/Document), DOC_ID (Document Identification), VALUE_POS (Valuation Row Identification), INV_VALUE0 ().. 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_DOCVA 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
VALUE_POSValuation Row Identification CACSVALUEPOSCHAR4ALPHACACSDOCLINE
INV_VALUE0 0
INDUSTRYIndustry Sector CACS_CRM_INDUSTRYCHAR4CACS_CRM_INDUSTRY
CATEGORY_IDCategory ID CACS_COM_CATEGORY_IDCHAR20CACS_COM_CATEGORY_ID
STAT_CURR0 0
ZCMBASV 0
ZDOCVALUE 0
ZORDERVAL 0
ZPRDSALES 0
ZQUOTA 0
ZSRVSALES 0
VRKMESales unit VRKMEUNIT3Assigned to domainCUNITMEINS
CURR_YR_TO_DATE 0
PREV_YR_TO_DATE 0
SUP_MONTHLY 0
EXO_MONTHLY 0
SUP_QTR_PLAN 0
EXO_QTR_PLAN 0
SUP_QTR_ACTUAL 0
EXO_QTR_ACTUAL 0
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
FLG_REVERSEDIndicator: Row/Object/Subobject is Invalid or Reversed CACSFLGREVCHAR1FLAG
STATUS_POSStatus of Object/Subobject CACSSTATUSPOSCHAR1TCACS_VALSTAT2CACSSTATUSVERS
STATUS_WORKObject Processing Status (Replica) CACSSTATUSWORKPCHAR1CACSSTATUSWORK
POST_MONTHPeriod in Posting Year CACSPSTMONNUMC2MONAT
REM_IMP_YEARYear Commission Case Reported CACSIMPYEARNUMC4KJAHRCACSIMPYEAR
REM_CASE_IDIdentification of a Case Resulting in Remuneration CACSREMCASEIDCHAR10ALPHACACSOBJID10
REM_CASE_VERSCommission Case Version CACSCASEVERSNUMC6CACSVERSIONCACSCASEVERS
TRI_OBJ_TYPETriggering Subobject Type CACSTRIOBJCHAR5Assigned to domainCACSOBTYIDCACS_OBJDAT
TRI_OBJ_IDIdentification of Triggering Subobject CACSTRIOBJIDCHAR12ALPHACACSOBJID12
VALUEValuation Type CACSVALCHAR4TCACS_VALCACSVALCACS_VAL
VALUE_VERSIONVersion of Master Data or Customizing Object CACSVERSIONNUMC6CACSVERSION
VALUE_QUANValuation Quantity CACSEVALQUANQUAN11(2) CACSEVALQUAN
DVALUE_QUANValuation Quantity Change CACSEVALDQUANQUAN11(2) CACSEVALQUAN
VALUE_UNITValuation Unit CACSEVALUNITUNIT3Assigned to domainCUNITMEINS
VALUE_AMNTValuation Amount in Commission Model Currency CACSVALAMNTCURR15(2) CACSAMNTITEM
DVALUE_AMNTValuation Amount Change in Commission Model Currency CACSVALDAMNTCURR15(2) CACSAMNTITEM
LED_CURRCurrency Key CACSLEDCURRCUKY5TCURCWAERS
STATUS_VALValuation Status CACSSTATUSVALCHAR1CACSSTATUSVAL
VALUE_AMNT_RUPTInterrupted Valuation Amount in Commission Model Currency CACSVALAMNTRUPTCURR15(2) CACSAMNTITEM
VALUE_QUAN_RUPTInterrupted Valuation Quantity CACSEVALQUANRUPTQUAN11(2) CACSEVALQUAN
UPD_TIMESTAMPLast Change of Objects CACSUPDTSTMPNUMC14TSTPSCACSTIMESTAMP

Key field Non-key field



How do I retrieve data from SAP table YCRM01_DOCVA using ABAP code

The following ABAP code Example will allow you to do a basic selection on YCRM01_DOCVA to SELECT all data from the table
DATA: WA_YCRM01_DOCVA TYPE YCRM01_DOCVA.

SELECT SINGLE *
FROM YCRM01_DOCVA
INTO CORRESPONDING FIELDS OF WA_YCRM01_DOCVA
WHERE...

How to access SAP table YCRM01_DOCVA

Within an ECC or HANA version of SAP you can also view further information about YCRM01_DOCVA 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!