SAP ABAP View CACS00_V_XDOCVA (View Through CACS00_DOCHD, CACS00_DOCVA and CACS00_DOCOBJ)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ ICM (Application Component) Incentive and Commission Management (ICM)
     ⤷ CACSDO (Package) ICM: Commission Document 'Light'

Basic Data

View Type	D	Database View
Database View	CACS00_V_XDOCVA
Short Description	View Through CACS00_DOCHD, CACS00_DOCVA and CACS00_DOCOBJ
Root table	CACS00_DOCHD	Commission Document Header

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	CACS00_DOCHD	CACS00_DOCHD
2	CACS00_DOCVA
3	CACS00_DOCOBJ

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	CACS00_DOCHD	MANDT	JL	EQ				0	0
2	CACS00_DOCVA	MANDT	JR	EQ			AND	0	0
3	CACS00_DOCHD	POST_YEAR	JL	EQ				0	0
4	CACS00_DOCVA	POST_YEAR	JR	EQ			AND	0	0
5	CACS00_DOCHD	DOC_ID	JL	EQ				0	0
6	CACS00_DOCVA	DOC_ID	JR	EQ			AND	0	0
7	CACS00_DOCHD	MANDT	JL	EQ				0	0
8	CACS00_DOCOBJ	MANDT	JR	EQ			AND	0	0
9	CACS00_DOCHD	POST_YEAR	JL	EQ				0	0
10	CACS00_DOCOBJ	POST_YEAR	JR	EQ			AND	0	0
11	CACS00_DOCHD	DOC_ID	JL	EQ				0	0
12	CACS00_DOCOBJ	DOC_ID	JR	EQ			AND	0	0
13	CACS00_DOCVA	TRI_OBJ_ID	JL	EQ				0	0
14	CACS00_DOCOBJ	TRI_OBJ_ID	JR	EQ				0	0

View Fields

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

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

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

History

Last changed by/on	SAP	20130529
SAP Release Created in	700