CACS00_V_XDOCRE SAP (Generated Table for View) Table View details
Dictionary Type: Table View
Description: Generated Table for 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
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 |
MANDT | Client | MANDT | CLNT | 3 | 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 | |||
VALUE_POS | Valuation Row Identification | CACSVALUEPOS | CHAR | 4 | ALPHA | CACSDOCLINE | |||
TRI_OBJ_TYPE | Triggering Subobject Type | CACSTRIOBJ | CHAR | 5 | CACSOBTYID | CACS_OBJDAT | |||
TRI_OBJ_ID_EXT | External Identification of Triggering Subobject | CACSTRIOBJIDEXT | CHAR | 36 | ALPHA | CACSOBJID36 | |||
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 | |||
ROLETYPE | Entitlement Category | CACSCLAIMTYPE | CHAR | 1 | TCACS_CLT | CACSCLAIMTYPEDO | |||
CLAIM_OBJTYPE | Entitlement Object Type | CACSCLAIMOBJTYPE | CHAR | 1 | CACSCLAIMOBJTYPE | ||||
CLAIM_OBJID | ID of Entitlement Object Acc. to Entitlement Object Type | CACSCLAIMOBJID | CHAR | 30 | CACSOBJID30NOCONV | ||||
INV_POS_REL | Participant Position in a Participation | CACSINVPOS | CHAR | 4 | ALPHA | CACSDOCLINE | |||
ACT_POS | Identification of an Activity Line | CACSACTPOS | CHAR | 4 | ALPHA | CACSDOCLINE | |||
KNW_TIMESTAMP | Calculation Time Stamp | CACSKNOWTSTMP | NUMC | 14 | TSTPS | CACSTIMESTAMP | |||
CLC_TIMESTAMP | Effective Time Stamp (Effective Status) | CACSCALCTSTMP | NUMC | 14 | TSTPS | CACSTIMESTAMP | |||
FLG_REVERSOR | Ind.: Object Reverses Other Object | CACSFLGREVR | CHAR | 1 | FLAG | ||||
DOC_TYPE | Document Type of Commission Document | CACSDOCTYPE | CHAR | 1 | TCACS_DOCT | CACSDOCTYPE | |||
POST_DATE | Posting Date in Commission Case/Comm Doc. (Acknowledgement) | CACSPSTDAT | DATS | 8 | DATUM | ||||
POST_MONTH | Period in Posting Year | CACSPSTMON | NUMC | 2 | MONAT | ||||
TRI_IMP_DATE | Date Commission Case Entered in Commission System | CACSIMPDAT | DATS | 8 | DATUM | ||||
TRI_IMP_YEAR | Year Commission Case Reported | CACSIMPYEAR | NUMC | 4 | KJAHR | CACSIMPYEAR | |||
TRI_CASE_ID | Identification of a Triggering Case | CACSTRICASEID | CHAR | 10 | ALPHA | CACSOBJID10 | |||
TRI_CASE_VERS | Commission Case Version | CACSCASEVERS | NUMC | 6 | CACSVERSION | CACSCASEVERS | |||
FLG_NOSETTLEMENT | Ind.: Remuneration Determined Already Paid Out | CACSNOSETTLEMENT | CHAR | 1 | BOOLEAN_FLG | ||||
FLG_NORESETTLE | Ind.: Remuneration Cancellation Found is Already Settled | CACSNORESETTLEMENT | CHAR | 1 | BOOLEAN_FLG | ||||
FLG_FUTURECHECK | Indicator: Carry Out Check for Future Objects | CACSFUTURECHECK | CHAR | 1 | BOOLEAN_FLG | ||||
RELEASE_DATE | Release Date of Operational Sys. for Commission Notification | CACSRELDAT | DATS | 8 | DATUM | ||||
TRI_CASE_TXT | Short Text for Commission Document | CACSTRIDOCTXT | CHAR | 40 | CACSSHORTTXT | ||||
FLG_ASYNC_DONE | Indicator: Totals Table Provision Complete | CACSFLGASYNC | CHAR | 1 | XFELD | ||||
ASYNC_LEVEL | Level Reached in Asynchronous Update | CACSASYNCPRIOR | NUMC | 2 | CACSPRIORITY | ||||
BUSOBJ_TYPE | Business Object Category that Triggers Commission | CACSBUSOBJTYP | CHAR | 3 | BOBJ0 | CACSBUSOBJTYP | OBJ | ||
BUSOBJ_ID | Identification of Triggering Business Object | CACSBUSOBJID | CHAR | 30 | BOBJ1 | CACSOBJID30 | |||
BUSOBJ_VERS | Business Object Version | CACSBUSOBJVERS | NUMC | 14 | CACSBUSOBJVERS | ||||
BUSOBJ_VERSDATE | Date Business Object Version Starts | CACSVERSDATE | NUMC | 14 | TSTPS | CACSTIMESTAMP | |||
REM_BUSCASE_TYP | Remunerating Business Transaction in Operational System | CACSREMBUSCASTYP | CHAR | 3 | ALPHA | CACSBUSCASTYP | |||
REM_BUSCASE_ID | Identification of Triggering Bus. Transaction in Op. System | CACSREMBUSCASEID | CHAR | 36 | ALPHA | CACSOBJID36 | |||
REM_BUSCASE_VERS | Business Transaction Version | CACSREMBUSCASEVERS | NUMC | 14 | CACSREMBUSCASEVERS | ||||
TRIGGER_SYS | Logical Operational System | CACSLOGSYSTEM | CHAR | 10 | ALPHA | LOGSYS | |||
TRIGGER_DATE | Trigger Date of Commission Case in Operational System | CACSTRIDAT | DATS | 8 | DATUM | ||||
TRI_BUSCASE_TYP | Commission Triggering Business Case in Operational System | CACSTRIBUSCASTYP | CHAR | 3 | ALPHA | CACSBUSCASTYP | |||
TRI_BUSCASE_ID | Identification of Triggering Bus. Transaction in Op. System | CACSTRIBUSCASEID | CHAR | 36 | ALPHA | CACSOBJID36 | |||
TRI_BUSCASE_VERS | Version of Master Data or Customizing Object | CACSVERSIONLONG | NUMC | 14 | CACSVERSIONLONG | ||||
TRGCAS_TYPE | Reason for Additional Commission Case Being Triggered | CACS_TRGCAS_TYPE | CHAR | 4 | CACS_TRGCAS_TYPE | ||||
TRGCASAGR_ID | Identification of Additional Commission Case Agreement | CACS_TRGCASAGR_ID | NUMC | 12 | NUMC12 | ||||
TRGCASRU_ID | Rule Identification for Additional Commission Cases | CACS_TRGCASRU_ID | NUMC | 12 | NUMC12 | ||||
PERIODRULE_ID | Period Rule | CACSPRDRULE | CHAR | 7 | CACSPRDRULE | ||||
PERIOD_NO | Period Number | CACSPERIOD | NUMC | 6 | NUMC6 | ||||
RUN_ID | Identification Number of Processing Run | CACSBATCHID | CHAR | 10 | ALPHA | CACSOBJID10 | |||
EXT_RUN_ID | Identification Number of External Processing Run | CACSBATCHEXT | CHAR | 10 | ALPHA | CACSOBJID10 | |||
PAY_REF_ID | Reference Number for Payment System | CACSPAYREFID | CHAR | 10 | ALPHA | CACSPAYREFID | |||
REV_DOC_ID | Document Number of Related Reversal Document | CACSREVDOCID | CHAR | 10 | ALPHA | CACSOBJID10 | |||
REV_POST_YEAR | Posting Year of Related Reversal Document | CACSREVPOSTYEAR | NUMC | 4 | KJAHR | ||||
LOG_HANDLE | Application Log: Log Handle | BALLOGHNDL | CHAR | 22 | SYSUUID_22 | ||||
CHG_TIMESTAMP | Creation Time Stamp of Object | CACSCHGTSTMP | NUMC | 14 | TSTPS | CACSTIMESTAMP | |||
CHG_TCODE | Transaction in Which the Change Was Made | CACSCDTC | CHAR | 20 | TCODE | ||||
CHG_USR | Last user to change object | CACSCHUSR | CHAR | 12 | USNAM | ||||
TRI_METH_TYP | Triggering Method | CACSTRIMETHTYP | CHAR | 1 | CACSOPTYPE | ||||
TRI_METH_TARGET | Processing Target of Triggering Method | CACSTRIMETHTAR | CHAR | 1 | CACSTRITARGET | ||||
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 | ||||
REV_TIMESTAMP | Release Time Stamp of Object on Principle of Dual Control | CACSREVTSTMP | NUMC | 14 | TSTPS | CACSTIMESTAMP | |||
REV_TCODE | Transaction in Which the Change Was Made | CACSCDTC | CHAR | 20 | TCODE | ||||
REV_USR | User Who Released Object After Dual Checks | CACSREVUSR | CHAR | 12 | USNAM | ||||
UPD_TIMESTAMP | Last Change of Objects | CACSUPDTSTMP | NUMC | 14 | TSTPS | CACSTIMESTAMP | |||
FLG_COMPL | Indicator: Document Part Created by Complete Update | CACSFLGCOMPL | CHAR | 1 | BOOLEAN_FLG | ||||
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 | ||||
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 | CACSOBTYID | ||||
POW_OBJ_ID | Identification of Subobject of Activity Provided | CACSPOWOBJID | CHAR | 12 | ALPHA | CACSOBJID12 | |||
ACTIVITY | Activity Type | CACSACT | CHAR | 4 | CACSACT | ||||
ACTGRP | Role | CACSACTGRP | CHAR | 4 | TCACS_ACTGRP | CACSACTGRP | CACS_TCACS_ACTGRP | ||
REM_OBJ_TYPE | Remunerating Subobject Type | CACSREMOBJ | CHAR | 5 | CACSOBTYID | CACS_OBJDAT | |||
REM_OBJ_ID | Identification of Subobject Resulting in Remuneration | CACSREMOBJID | CHAR | 12 | ALPHA | CACSOBJID12 | |||
VALUE_TYPE | Valuation Result Category | CACSVALTYPE | NUMC | 1 | CACSVALTYPE | ||||
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 | 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 | 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 | ||||
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 | |||
TRI_OBJ_ID | Identification of Triggering Subobject | CACSTRIOBJID | CHAR | 12 | ALPHA | CACSOBJID12 | |||
VALUE | Valuation Type | CACSVAL | CHAR | 4 | TCACS_VAL | CACSVAL | CACS_VAL | ||
VALUE_VERSION | Version of Master Data or Customizing Object | CACSVERSION | NUMC | 6 | CACSVERSION | ||||
VALUE_QUAN | Valuation Quantity | CACSEVALQUAN | QUAN | 11(2) | CACSEVALQUAN | ||||
DVALUE_QUAN | Valuation Quantity Change | CACSEVALDQUAN | QUAN | 11(2) | CACSEVALQUAN | ||||
VALUE_AMNT | Valuation Amount in Commission Model Currency | CACSVALAMNT | CURR | 15(2) | CACSAMNTITEM | ||||
DVALUE_AMNT | Valuation Amount Change in Commission Model Currency | CACSVALDAMNT | CURR | 15(2) | CACSAMNTITEM | ||||
STATUS_VAL | Valuation Status | CACSSTATUSVAL | CHAR | 1 | CACSSTATUSVAL | ||||
VALUE_AMNT_RUPT | Interrupted Valuation Amount in Commission Model Currency | CACSVALAMNTRUPT | CURR | 15(2) | CACSAMNTITEM | ||||
VALUE_QUAN_RUPT | Interrupted Valuation Quantity | CACSEVALQUANRUPT | QUAN | 11(2) | CACSEVALQUAN | ||||
PARENT_TYPE | Higher-Level Subobject That Triggers Commission | CACSPARTRIOBJ | CHAR | 5 | CACSOBTYID | CACS_OBJDAT | |||
PARENT_ID | Internal Identification of Higher-Level Subobject | CACSPARTRIOBJID | CHAR | 12 | ALPHA | CACSOBJID12 | |||
ROLE_COMMSHAR | Share of Direct Remuneration (in Percent) | CACSCOMMSHARE | DEC | 10(5) | CACSPERCENT5 | ||||
ROLE_PRODSHAR | Share of Indirect Remuneration (in Percent) | CACSPRODSHARE | DEC | 10(5) | CACSPERCENT5 | ||||
INV_POS_PARENT | Position of a Higher-Level Participant in a Participation | CACSINVPOSPARENT | CHAR | 4 | ALPHA | CACSDOCLINE |
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 tableDATA: 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 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