CACS00_V_XDOCRE SAP (Generated Table for View) Table View details

Dictionary Type: Table View
Description: Generated Table for View




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




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

CACS00_V_XDOCRE is a standard SAP Table View which is used to store Generated Table for View data and is available within R/3 SAP systems depending on the version and release level.

The CACS00_V_XDOCRE table consists of various fields, each holding specific information or linking keys about Generated Table for View 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), VALUE_POS (Valuation Row Identification).. 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:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP CACS00_V_XDOCRE table view 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 MANDTCLNT3MANDT
POST_YEARAssignment Year of Commission Case/Document CACSPSTYEARNUMC4KJAHRCACSPSTYEAR
DOC_IDDocument Identification CACSDOCIDCHAR10ALPHACACSOBJID10CACSDOCID
REMUN_POSID of Remuneration Row for Referenced Document CACSREMUNPOSCHAR4ALPHACACSDOCLINE
VALUE_POSValuation Row Identification CACSVALUEPOSCHAR4ALPHACACSDOCLINE
TRI_OBJ_TYPETriggering Subobject Type CACSTRIOBJCHAR5CACSOBTYIDCACS_OBJDAT
TRI_OBJ_ID_EXTExternal Identification of Triggering Subobject CACSTRIOBJIDEXTCHAR36ALPHACACSOBJID36
PART_POSPosition of Participation in a Commission Case CACSPARTIDCHAR4ALPHACACSDOCLINE
INV_POSParticipant Position in a Participation CACSINVPOSCHAR4ALPHACACSDOCLINE
ROLETYPEEntitlement Category CACSCLAIMTYPECHAR1TCACS_CLTCACSCLAIMTYPEDO
CLAIM_OBJTYPEEntitlement Object Type CACSCLAIMOBJTYPECHAR1CACSCLAIMOBJTYPE
CLAIM_OBJIDID of Entitlement Object Acc. to Entitlement Object Type CACSCLAIMOBJIDCHAR30CACSOBJID30NOCONV
INV_POS_RELParticipant Position in a Participation CACSINVPOSCHAR4ALPHACACSDOCLINE
ACT_POSIdentification of an Activity Line CACSACTPOSCHAR4ALPHACACSDOCLINE
KNW_TIMESTAMPCalculation Time Stamp CACSKNOWTSTMPNUMC14TSTPSCACSTIMESTAMP
CLC_TIMESTAMPEffective Time Stamp (Effective Status) CACSCALCTSTMPNUMC14TSTPSCACSTIMESTAMP
FLG_REVERSORInd.: Object Reverses Other Object CACSFLGREVRCHAR1FLAG
DOC_TYPEDocument Type of Commission Document CACSDOCTYPECHAR1TCACS_DOCTCACSDOCTYPE
POST_DATEPosting Date in Commission Case/Comm Doc. (Acknowledgement) CACSPSTDATDATS8DATUM
POST_MONTHPeriod in Posting Year CACSPSTMONNUMC2MONAT
TRI_IMP_DATEDate Commission Case Entered in Commission System CACSIMPDATDATS8DATUM
TRI_IMP_YEARYear Commission Case Reported CACSIMPYEARNUMC4KJAHRCACSIMPYEAR
TRI_CASE_IDIdentification of a Triggering Case CACSTRICASEIDCHAR10ALPHACACSOBJID10
TRI_CASE_VERSCommission Case Version CACSCASEVERSNUMC6CACSVERSIONCACSCASEVERS
FLG_NOSETTLEMENTInd.: Remuneration Determined Already Paid Out CACSNOSETTLEMENTCHAR1BOOLEAN_FLG
FLG_NORESETTLEInd.: Remuneration Cancellation Found is Already Settled CACSNORESETTLEMENTCHAR1BOOLEAN_FLG
FLG_FUTURECHECKIndicator: Carry Out Check for Future Objects CACSFUTURECHECKCHAR1BOOLEAN_FLG
RELEASE_DATERelease Date of Operational Sys. for Commission Notification CACSRELDATDATS8DATUM
TRI_CASE_TXTShort Text for Commission Document CACSTRIDOCTXTCHAR40CACSSHORTTXT
FLG_ASYNC_DONEIndicator: Totals Table Provision Complete CACSFLGASYNCCHAR1XFELD
ASYNC_LEVELLevel Reached in Asynchronous Update CACSASYNCPRIORNUMC2CACSPRIORITY
BUSOBJ_TYPEBusiness Object Category that Triggers Commission CACSBUSOBJTYPCHAR3BOBJ0CACSBUSOBJTYPOBJ
BUSOBJ_IDIdentification of Triggering Business Object CACSBUSOBJIDCHAR30BOBJ1CACSOBJID30
BUSOBJ_VERSBusiness Object Version CACSBUSOBJVERSNUMC14CACSBUSOBJVERS
BUSOBJ_VERSDATEDate Business Object Version Starts CACSVERSDATENUMC14TSTPSCACSTIMESTAMP
REM_BUSCASE_TYPRemunerating Business Transaction in Operational System CACSREMBUSCASTYPCHAR3ALPHACACSBUSCASTYP
REM_BUSCASE_IDIdentification of Triggering Bus. Transaction in Op. System CACSREMBUSCASEIDCHAR36ALPHACACSOBJID36
REM_BUSCASE_VERSBusiness Transaction Version CACSREMBUSCASEVERSNUMC14CACSREMBUSCASEVERS
TRIGGER_SYSLogical Operational System CACSLOGSYSTEMCHAR10ALPHALOGSYS
TRIGGER_DATETrigger Date of Commission Case in Operational System CACSTRIDATDATS8DATUM
TRI_BUSCASE_TYPCommission Triggering Business Case in Operational System CACSTRIBUSCASTYPCHAR3ALPHACACSBUSCASTYP
TRI_BUSCASE_IDIdentification of Triggering Bus. Transaction in Op. System CACSTRIBUSCASEIDCHAR36ALPHACACSOBJID36
TRI_BUSCASE_VERSVersion of Master Data or Customizing Object CACSVERSIONLONGNUMC14CACSVERSIONLONG
TRGCAS_TYPEReason for Additional Commission Case Being Triggered CACS_TRGCAS_TYPECHAR4CACS_TRGCAS_TYPE
TRGCASAGR_IDIdentification of Additional Commission Case Agreement CACS_TRGCASAGR_IDNUMC12NUMC12
TRGCASRU_IDRule Identification for Additional Commission Cases CACS_TRGCASRU_IDNUMC12NUMC12
PERIODRULE_IDPeriod Rule CACSPRDRULECHAR7CACSPRDRULE
PERIOD_NOPeriod Number CACSPERIODNUMC6NUMC6
RUN_IDIdentification Number of Processing Run CACSBATCHIDCHAR10ALPHACACSOBJID10
EXT_RUN_IDIdentification Number of External Processing Run CACSBATCHEXTCHAR10ALPHACACSOBJID10
PAY_REF_IDReference Number for Payment System CACSPAYREFIDCHAR10ALPHACACSPAYREFID
REV_DOC_IDDocument Number of Related Reversal Document CACSREVDOCIDCHAR10ALPHACACSOBJID10
REV_POST_YEARPosting Year of Related Reversal Document CACSREVPOSTYEARNUMC4KJAHR
LOG_HANDLEApplication Log: Log Handle BALLOGHNDLCHAR22SYSUUID_22
CHG_TIMESTAMPCreation Time Stamp of Object CACSCHGTSTMPNUMC14TSTPSCACSTIMESTAMP
CHG_TCODETransaction in Which the Change Was Made CACSCDTCCHAR20TCODE
CHG_USRLast user to change object CACSCHUSRCHAR12USNAM
TRI_METH_TYPTriggering Method CACSTRIMETHTYPCHAR1CACSOPTYPE
TRI_METH_TARGETProcessing Target of Triggering Method CACSTRIMETHTARCHAR1CACSTRITARGET
FLG_REVERSEDIndicator: Row/Object/Subobject is Invalid or Reversed CACSFLGREVCHAR1FLAG
STATUS_POSStatus of Object/Subobject CACSSTATUSPOSCHAR1TCACS_VALSTAT2CACSSTATUSVERS
STATUS_WORKObject Processing Status (Replica) CACSSTATUSWORKPCHAR1CACSSTATUSWORK
REV_TIMESTAMPRelease Time Stamp of Object on Principle of Dual Control CACSREVTSTMPNUMC14TSTPSCACSTIMESTAMP
REV_TCODETransaction in Which the Change Was Made CACSCDTCCHAR20TCODE
REV_USRUser Who Released Object After Dual Checks CACSREVUSRCHAR12USNAM
UPD_TIMESTAMPLast Change of Objects CACSUPDTSTMPNUMC14TSTPSCACSTIMESTAMP
FLG_COMPLIndicator: Document Part Created by Complete Update CACSFLGCOMPLCHAR1BOOLEAN_FLG
CTRTBU_IDCommission Contract Number CACS_CTRTBU_IDCHAR20ALPHAISIS_CONTRACT_IDCACSCTBUCACS
BUCAGR_IDAgreement Number CACS_BUCAGR_IDCHAR12CHAR12
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 CACSPOWOBJCHAR5CACSOBTYID
POW_OBJ_IDIdentification of Subobject of Activity Provided CACSPOWOBJIDCHAR12ALPHACACSOBJID12
ACTIVITYActivity Type CACSACTCHAR4CACSACT
ACTGRPRole CACSACTGRPCHAR4TCACS_ACTGRPCACSACTGRPCACS_TCACS_ACTGRP
REM_OBJ_TYPERemunerating Subobject Type CACSREMOBJCHAR5CACSOBTYIDCACS_OBJDAT
REM_OBJ_IDIdentification of Subobject Resulting in Remuneration CACSREMOBJIDCHAR12ALPHACACSOBJID12
VALUE_TYPEValuation Result Category CACSVALTYPENUMC1CACSVALTYPE
REMVAL_LEDAMNTRemuneration Value in Commission Model Currency CACSREMVALAMNTCURR15(2) CACSAMNTITEM
REMVAL_QUANRemuneration Value (Volume) CACSREMVALQUANQUAN11(2) CACSEVALQUAN
VALUE_UNITValuation Unit CACSEVALUNITUNIT3CUNITMEINS
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 CACSREMUUNITUNIT3CUNITMEINS
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
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
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_AMNTValuation Amount in Commission Model Currency CACSVALAMNTCURR15(2) CACSAMNTITEM
DVALUE_AMNTValuation Amount Change in Commission Model Currency CACSVALDAMNTCURR15(2) CACSAMNTITEM
STATUS_VALValuation Status CACSSTATUSVALCHAR1CACSSTATUSVAL
VALUE_AMNT_RUPTInterrupted Valuation Amount in Commission Model Currency CACSVALAMNTRUPTCURR15(2) CACSAMNTITEM
VALUE_QUAN_RUPTInterrupted Valuation Quantity CACSEVALQUANRUPTQUAN11(2) CACSEVALQUAN
PARENT_TYPEHigher-Level Subobject That Triggers Commission CACSPARTRIOBJCHAR5CACSOBTYIDCACS_OBJDAT
PARENT_IDInternal Identification of Higher-Level Subobject CACSPARTRIOBJIDCHAR12ALPHACACSOBJID12
ROLE_COMMSHARShare of Direct Remuneration (in Percent) CACSCOMMSHAREDEC10(5) CACSPERCENT5
ROLE_PRODSHARShare of Indirect Remuneration (in Percent) CACSPRODSHAREDEC10(5) CACSPERCENT5
INV_POS_PARENTPosition of a Higher-Level Participant in a Participation CACSINVPOSPARENTCHAR4ALPHACACSDOCLINE

Key field Non-key field



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

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

SELECT SINGLE *
FROM CACS00_V_XDOCRE
INTO CORRESPONDING FIELDS OF WA_CACS00_V_XDOCRE
WHERE...

How to access SAP table CACS00_V_XDOCRE

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