SAP ABAP Table CACS00_V_XDOCVA (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	CACS00_V_XDOCVA	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client
2	POST_YEAR	☑	CACSPSTYEAR	KJAHR	NUMC	4	0	Assignment Year of Commission Case/Document
3	DOC_ID	☑	CACSDOCID	CACSOBJID10	CHAR	10	0	Document Identification
4	VALUE_POS	☑	CACSVALUEPOS	CACSDOCLINE	CHAR	4	0	Valuation Row Identification
5	TRI_OBJ_TYPE	☑	CACSTRIOBJ	CACSOBTYID	CHAR	5	0	Triggering Subobject Type
6	TRI_OBJ_ID_EXT	☑	CACSTRIOBJIDEXT	CACSOBJID36	CHAR	36	0	External Identification of Triggering Subobject
7	KNW_TIMESTAMP	☐	CACSKNOWTSTMP	CACSTIMESTAMP	NUMC	14	0	Calculation Time Stamp
8	CLC_TIMESTAMP	☐	CACSCALCTSTMP	CACSTIMESTAMP	NUMC	14	0	Effective Time Stamp (Effective Status)
9	FLG_REVERSOR	☐	CACSFLGREVR	FLAG	CHAR	1	0	Ind.: Object Reverses Other Object
10	DOC_TYPE	☐	CACSDOCTYPE	CACSDOCTYPE	CHAR	1	0	Document Type of Commission Document	TCACS_DOCT
11	POST_DATE	☐	CACSPSTDAT	DATUM	DATS	8	0	Posting Date in Commission Case/Comm Doc. (Acknowledgement)
12	POST_MONTH	☐	CACSPSTMON	MONAT	NUMC	2	0	Period in Posting Year
13	TRI_IMP_DATE	☐	CACSIMPDAT	DATUM	DATS	8	0	Date Commission Case Entered in Commission System
14	TRI_IMP_YEAR	☐	CACSIMPYEAR	KJAHR	NUMC	4	0	Year Commission Case Reported
15	TRI_CASE_ID	☐	CACSTRICASEID	CACSOBJID10	CHAR	10	0	Identification of a Triggering Case
16	TRI_CASE_VERS	☐	CACSCASEVERS	CACSVERSION	NUMC	6	0	Commission Case Version
17	FLG_NOSETTLEMENT	☐	CACSNOSETTLEMENT	BOOLEAN_FLG	CHAR	1	0	Ind.: Remuneration Determined Already Paid Out
18	FLG_NORESETTLE	☐	CACSNORESETTLEMENT	BOOLEAN_FLG	CHAR	1	0	Ind.: Remuneration Cancellation Found is Already Settled
19	FLG_FUTURECHECK	☐	CACSFUTURECHECK	BOOLEAN_FLG	CHAR	1	0	Indicator: Carry Out Check for Future Objects
20	RELEASE_DATE	☐	CACSRELDAT	DATUM	DATS	8	0	Release Date of Operational Sys. for Commission Notification
21	TRI_CASE_TXT	☐	CACSTRIDOCTXT	CACSSHORTTXT	CHAR	40	0	Short Text for Commission Document
22	FLG_ASYNC_DONE	☐	CACSFLGASYNC	XFELD	CHAR	1	0	Indicator: Totals Table Provision Complete
23	ASYNC_LEVEL	☐	CACSASYNCPRIOR	CACSPRIORITY	NUMC	2	0	Level Reached in Asynchronous Update
24	BUSOBJ_TYPE	☐	CACSBUSOBJTYP	CACSBUSOBJTYP	CHAR	3	0	Business Object Category that Triggers Commission
25	BUSOBJ_ID	☐	CACSBUSOBJID	CACSOBJID30	CHAR	30	0	Identification of Triggering Business Object
26	BUSOBJ_VERS	☐	CACSBUSOBJVERS	CACSBUSOBJVERS	NUMC	14	0	Business Object Version
27	BUSOBJ_VERSDATE	☐	CACSVERSDATE	CACSTIMESTAMP	NUMC	14	0	Date Business Object Version Starts
28	TRGCAS_TYPE	☐	CACS_TRGCAS_TYPE	CACS_TRGCAS_TYPE	CHAR	4	0	Reason for Additional Commission Case Being Triggered
29	TRGCASAGR_ID	☐	CACS_TRGCASAGR_ID	NUMC12	NUMC	12	0	Identification of Additional Commission Case Agreement
30	TRGCASRU_ID	☐	CACS_TRGCASRU_ID	NUMC12	NUMC	12	0	Rule Identification for Additional Commission Cases
31	PERIODRULE_ID	☐	CACSPRDRULE	CACSPRDRULE	CHAR	7	0	Period Rule
32	PERIOD_NO	☐	CACSPERIOD	NUMC6	NUMC	6	0	Period Number
33	RUN_ID	☐	CACSBATCHID	CACSOBJID10	CHAR	10	0	Identification Number of Processing Run
34	EXT_RUN_ID	☐	CACSBATCHEXT	CACSOBJID10	CHAR	10	0	Identification Number of External Processing Run
35	PAY_REF_ID	☐	CACSPAYREFID	CACSPAYREFID	CHAR	10	0	Reference Number for Payment System
36	REV_DOC_ID	☐	CACSREVDOCID	CACSOBJID10	CHAR	10	0	Document Number of Related Reversal Document
37	REV_POST_YEAR	☐	CACSREVPOSTYEAR	KJAHR	NUMC	4	0	Posting Year of Related Reversal Document
38	LOG_HANDLE	☐	BALLOGHNDL	SYSUUID_22	CHAR	22	0	Application Log: Log Handle
39	CHG_TIMESTAMP	☐	CACSCHGTSTMP	CACSTIMESTAMP	NUMC	14	0	Creation Time Stamp of Object
40	CHG_TCODE	☐	CACSCDTC	TCODE	CHAR	20	0	Transaction in Which the Change Was Made
41	CHG_USR	☐	CACSCHUSR	USNAM	CHAR	12	0	Last user to change object
42	TRI_METH_TYP	☐	CACSTRIMETHTYP	CACSOPTYPE	CHAR	1	0	Triggering Method
43	TRI_METH_TARGET	☐	CACSTRIMETHTAR	CACSTRITARGET	CHAR	1	0	Processing Target of Triggering Method
44	FLG_REVERSED	☐	CACSFLGREV	FLAG	CHAR	1	0	Indicator: Row/Object/Subobject is Invalid or Reversed
45	STATUS_POS	☐	CACSSTATUSPOS	CACSSTATUSVERS	CHAR	1	0	Status of Object/Subobject	TCACS_VALSTAT2
46	STATUS_WORK	☐	CACSSTATUSWORKP	CACSSTATUSWORK	CHAR	1	0	Object Processing Status (Replica)
47	REV_TIMESTAMP	☐	CACSREVTSTMP	CACSTIMESTAMP	NUMC	14	0	Release Time Stamp of Object on Principle of Dual Control
48	REV_TCODE	☐	CACSCDTC	TCODE	CHAR	20	0	Transaction in Which the Change Was Made
49	REV_USR	☐	CACSREVUSR	USNAM	CHAR	12	0	User Who Released Object After Dual Checks
50	UPD_TIMESTAMP	☐	CACSUPDTSTMP	CACSTIMESTAMP	NUMC	14	0	Last Change of Objects
51	REM_IMP_YEAR	☐	CACSIMPYEAR	KJAHR	NUMC	4	0	Year Commission Case Reported
52	REM_CASE_ID	☐	CACSREMCASEID	CACSOBJID10	CHAR	10	0	Identification of a Case Resulting in Remuneration
53	REM_CASE_VERS	☐	CACSCASEVERS	CACSVERSION	NUMC	6	0	Commission Case Version
54	VALUE	☐	CACSVAL	CACSVAL	CHAR	4	0	Valuation Type	TCACS_VAL
55	VALUE_VERSION	☐	CACSVERSION	CACSVERSION	NUMC	6	0	Version of Master Data or Customizing Object
56	VALUE_QUAN	☐	CACSEVALQUAN	CACSEVALQUAN	QUAN	11	2	Valuation Quantity
57	DVALUE_QUAN	☐	CACSEVALDQUAN	CACSEVALQUAN	QUAN	11	2	Valuation Quantity Change
58	VALUE_UNIT	☐	CACSEVALUNIT	MEINS	UNIT	3	0	Valuation Unit
59	VALUE_AMNT	☐	CACSVALAMNT	CACSAMNTITEM	CURR	15	2	Valuation Amount in Commission Model Currency
60	DVALUE_AMNT	☐	CACSVALDAMNT	CACSAMNTITEM	CURR	15	2	Valuation Amount Change in Commission Model Currency
61	STATUS_VAL	☐	CACSSTATUSVAL	CACSSTATUSVAL	CHAR	1	0	Valuation Status
62	VALUE_AMNT_RUPT	☐	CACSVALAMNTRUPT	CACSAMNTITEM	CURR	15	2	Interrupted Valuation Amount in Commission Model Currency
63	VALUE_QUAN_RUPT	☐	CACSEVALQUANRUPT	CACSEVALQUAN	QUAN	11	2	Interrupted Valuation Quantity
64	PARENT_TYPE	☐	CACSPARTRIOBJ	CACSOBTYID	CHAR	5	0	Higher-Level Subobject That Triggers Commission
65	PARENT_ID	☐	CACSPARTRIOBJID	CACSOBJID12	CHAR	12	0	Internal Identification of Higher-Level Subobject
66	TRI_OBJ_ID	☐	CACSTRIOBJID	CACSOBJID12	CHAR	12	0	Identification of Triggering Subobject
67	LED_CURR	☐	CACSLEDCURR	WAERS	CUKY	5	0	Currency Key	TCURC

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CACS00_V_XDOCVA	DOC_TYPE	TCACS_DOCT	DOC_TYPE
2	CACS00_V_XDOCVA	LED_CURR	TCURC	WAERS
3	CACS00_V_XDOCVA	STATUS_POS	TCACS_VALSTAT2	STATUS_POS
4	CACS00_V_XDOCVA	VALUE	TCACS_VAL	VALUE

History

Last changed by/on	SAP	20130529
SAP Release Created in