SAP ABAP View CACS00_V_XDOCPAR (View Through CACS00_DOCHD, PAR, INV, REL and ACT)

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_XDOCPAR
Short Description	View Through CACS00_DOCHD, PAR, INV, REL and ACT
Root table	CACS00_DOCHD	Commission Document Header

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	CACS00_DOCHD	CACS00_DOCHD
2	CACS00_DOCPAR
3	CACS00_DOCINV
4	CACS00_DOCREL
5	CACS00_DOCACT

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_DOCPAR	MANDT	JR	EQ			AND	0	0
3	CACS00_DOCHD	POST_YEAR	JL	EQ				0	0
4	CACS00_DOCPAR	POST_YEAR	JR	EQ			AND	0	0
5	CACS00_DOCHD	DOC_ID	JL	EQ				0	0
6	CACS00_DOCPAR	DOC_ID	JR	EQ			AND	0	0
7	CACS00_DOCHD	MANDT	JL	EQ				0	0
8	CACS00_DOCINV	MANDT	JR	EQ			AND	0	0
9	CACS00_DOCHD	POST_YEAR	JL	EQ				0	0
10	CACS00_DOCINV	POST_YEAR	JR	EQ			AND	0	0
11	CACS00_DOCHD	DOC_ID	JL	EQ				0	0
12	CACS00_DOCINV	DOC_ID	JR	EQ			AND	0	0
13	CACS00_DOCHD	MANDT	JL	EQ				0	0
14	CACS00_DOCREL	MANDT	JR	EQ			AND	0	0
15	CACS00_DOCHD	POST_YEAR	JL	EQ				0	0
16	CACS00_DOCREL	POST_YEAR	JR	EQ			AND	0	0
17	CACS00_DOCHD	DOC_ID	JL	EQ				0	0
18	CACS00_DOCREL	DOC_ID	JR	EQ			AND	0	0
19	CACS00_DOCHD	MANDT	JL	EQ				0	0
20	CACS00_DOCACT	MANDT	JR	EQ			AND	0	0
21	CACS00_DOCHD	POST_YEAR	JL	EQ				0	0
22	CACS00_DOCACT	POST_YEAR	JR	EQ			AND	0	0
23	CACS00_DOCHD	DOC_ID	JL	EQ				0	0
24	CACS00_DOCACT	DOC_ID	JR	EQ			AND	0	0
25	CACS00_DOCPAR	PART_POS	JL	EQ				0	0
26	CACS00_DOCINV	PART_POS	JR	EQ			AND	0	0
27	CACS00_DOCPAR	PART_POS	JL	EQ				0	0
28	CACS00_DOCREL	PART_POS	JR	EQ			AND	0	0
29	CACS00_DOCPAR	PART_POS	JL	EQ				0	0
30	CACS00_DOCACT	PART_POS	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	PART_POS	CACS00_DOCPAR	PART_POS		☐	CACSPARTID	☐	Position of Participation in a Commission Case
5	INV_POS	CACS00_DOCINV	INV_POS		☐	CACSINVPOS	☐	Participant Position in a Participation
6	ACT_POS	CACS00_DOCACT	ACT_POS		☐	CACSACTPOS	☐	Identification of an Activity Line
7	ROLETYPE	CACS00_DOCREL	ROLETYPE		☐	CACSCLAIMTYPE	☐	Entitlement Category
8	CLAIM_OBJTYPE	CACS00_DOCREL	CLAIM_OBJTYPE		☐	CACSCLAIMOBJTYPE	☐	Entitlement Object Type
9	CLAIM_OBJID	CACS00_DOCREL	CLAIM_OBJID		☐	CACSCLAIMOBJID	☐	ID of Entitlement Object Acc. to Entitlement Object Type
10	INV_POS_REL	CACS00_DOCREL	INV_POS		☐	CACSINVPOS	☐	Participant Position in a Participation
11	KNW_TIMESTAMP	CACS00_DOCHD	KNW_TIMESTAMP		☐	CACSKNOWTSTMP	☐	Calculation Time Stamp
12	CLC_TIMESTAMP	CACS00_DOCHD	CLC_TIMESTAMP		☐	CACSCALCTSTMP	☐	Effective Time Stamp (Effective Status)
13	FLG_REVERSOR	CACS00_DOCHD	FLG_REVERSOR		☐	CACSFLGREVR	☐	Ind.: Object Reverses Other Object
14	DOC_TYPE	CACS00_DOCHD	DOC_TYPE		☐	CACSDOCTYPE	☐	Document Type of Commission Document
15	POST_DATE	CACS00_DOCHD	POST_DATE		☐	CACSPSTDAT	☐	Posting Date in Commission Case/Comm Doc. (Acknowledgement)
16	POST_MONTH	CACS00_DOCHD	POST_MONTH		☐	CACSPSTMON	☐	Period in Posting Year
17	TRI_IMP_DATE	CACS00_DOCHD	TRI_IMP_DATE		☐	CACSIMPDAT	☐	Date Commission Case Entered in Commission System
18	TRI_IMP_YEAR	CACS00_DOCHD	TRI_IMP_YEAR		☐	CACSIMPYEAR	☐	Year Commission Case Reported
19	TRI_CASE_ID	CACS00_DOCHD	TRI_CASE_ID		☐	CACSTRICASEID	☐	Identification of a Triggering Case
20	TRI_CASE_VERS	CACS00_DOCHD	TRI_CASE_VERS		☐	CACSCASEVERS	☐	Commission Case Version
21	FLG_NOSETTLEMENT	CACS00_DOCHD	FLG_NOSETTLEMENT		☐	CACSNOSETTLEMENT	☐	Ind.: Remuneration Determined Already Paid Out
22	FLG_NORESETTLE	CACS00_DOCHD	FLG_NORESETTLE		☐	CACSNORESETTLEMENT	☐	Ind.: Remuneration Cancellation Found is Already Settled
23	FLG_FUTURECHECK	CACS00_DOCHD	FLG_FUTURECHECK		☐	CACSFUTURECHECK	☐	Indicator: Carry Out Check for Future Objects
24	RELEASE_DATE	CACS00_DOCHD	RELEASE_DATE		☐	CACSRELDAT	☐	Release Date of Operational Sys. for Commission Notification
25	TRI_CASE_TXT	CACS00_DOCHD	TRI_CASE_TXT		☐	CACSTRIDOCTXT	☐	Short Text for Commission Document
26	FLG_ASYNC_DONE	CACS00_DOCHD	FLG_ASYNC_DONE		☐	CACSFLGASYNC	☐	Indicator: Totals Table Provision Complete
27	ASYNC_LEVEL	CACS00_DOCHD	ASYNC_LEVEL		☐	CACSASYNCPRIOR	☐	Level Reached in Asynchronous Update
28	BUSOBJ_TYPE	CACS00_DOCHD	BUSOBJ_TYPE		☐	CACSBUSOBJTYP	☐	Business Object Category that Triggers Commission
29	BUSOBJ_ID	CACS00_DOCHD	BUSOBJ_ID		☐	CACSBUSOBJID	☐	Identification of Triggering Business Object
30	BUSOBJ_VERS	CACS00_DOCHD	BUSOBJ_VERS		☐	CACSBUSOBJVERS	☐	Business Object Version
31	BUSOBJ_VERSDATE	CACS00_DOCHD	BUSOBJ_VERSDATE		☐	CACSVERSDATE	☐	Date Business Object Version Starts
32	REM_BUSCASE_TYP	CACS00_DOCHD	REM_BUSCASE_TYP		☐	CACSREMBUSCASTYP	☐	Remunerating Business Transaction in Operational System
33	REM_BUSCASE_ID	CACS00_DOCHD	REM_BUSCASE_ID		☐	CACSREMBUSCASEID	☐	Identification of Triggering Bus. Transaction in Op. System
34	REM_BUSCASE_VERS	CACS00_DOCHD	REM_BUSCASE_VERS		☐	CACSREMBUSCASEVERS	☐	Business Transaction Version
35	LED_CURR	CACS00_DOCHD	LED_CURR		☐	CACSLEDCURR	☐	Currency Key
36	TRIGGER_SYS	CACS00_DOCHD	TRIGGER_SYS		☐	CACSLOGSYSTEM	☐	Logical Operational System
37	TRIGGER_DATE	CACS00_DOCHD	TRIGGER_DATE		☐	CACSTRIDAT	☐	Trigger Date of Commission Case in Operational System
38	TRI_BUSCASE_TYP	CACS00_DOCHD	TRI_BUSCASE_TYP		☐	CACSTRIBUSCASTYP	☐	Commission Triggering Business Case in Operational System
39	TRI_BUSCASE_ID	CACS00_DOCHD	TRI_BUSCASE_ID		☐	CACSTRIBUSCASEID	☐	Identification of Triggering Bus. Transaction in Op. System
40	TRI_BUSCASE_VERS	CACS00_DOCHD	TRI_BUSCASE_VERS		☐	CACSVERSIONLONG	☐	Version of Master Data or Customizing Object
41	TRGCAS_TYPE	CACS00_DOCHD	TRGCAS_TYPE		☐	CACS_TRGCAS_TYPE	☐	Reason for Additional Commission Case Being Triggered
42	TRGCASAGR_ID	CACS00_DOCHD	TRGCASAGR_ID		☐	CACS_TRGCASAGR_ID	☐	Identification of Additional Commission Case Agreement
43	TRGCASRU_ID	CACS00_DOCHD	TRGCASRU_ID		☐	CACS_TRGCASRU_ID	☐	Rule Identification for Additional Commission Cases
44	PERIODRULE_ID	CACS00_DOCHD	PERIODRULE_ID		☐	CACSPRDRULE	☐	Period Rule
45	PERIOD_NO	CACS00_DOCHD	PERIOD_NO		☐	CACSPERIOD	☐	Period Number
46	RUN_ID	CACS00_DOCHD	RUN_ID		☐	CACSBATCHID	☐	Identification Number of Processing Run
47	EXT_RUN_ID	CACS00_DOCHD	EXT_RUN_ID		☐	CACSBATCHEXT	☐	Identification Number of External Processing Run
48	PAY_REF_ID	CACS00_DOCHD	PAY_REF_ID		☐	CACSPAYREFID	☐	Reference Number for Payment System
49	REV_DOC_ID	CACS00_DOCHD	REV_DOC_ID		☐	CACSREVDOCID	☐	Document Number of Related Reversal Document
50	REV_POST_YEAR	CACS00_DOCHD	REV_POST_YEAR		☐	CACSREVPOSTYEAR	☐	Posting Year of Related Reversal Document
51	LOG_HANDLE	CACS00_DOCHD	LOG_HANDLE		☐	BALLOGHNDL	☐	Application Log: Log Handle
52	CHG_TIMESTAMP	CACS00_DOCHD	CHG_TIMESTAMP		☐	CACSCHGTSTMP	☐	Creation Time Stamp of Object
53	CHG_TCODE	CACS00_DOCHD	CHG_TCODE		☐	CACSCDTC	☐	Transaction in Which the Change Was Made
54	CHG_USR	CACS00_DOCHD	CHG_USR		☐	CACSCHUSR	☐	Last user to change object
55	TRI_METH_TYP	CACS00_DOCHD	TRI_METH_TYP		☐	CACSTRIMETHTYP	☐	Triggering Method
56	TRI_METH_TARGET	CACS00_DOCHD	TRI_METH_TARGET		☐	CACSTRIMETHTAR	☐	Processing Target of Triggering Method
57	FLG_REVERSED	CACS00_DOCHD	FLG_REVERSED		☐	CACSFLGREV	☐	Indicator: Row/Object/Subobject is Invalid or Reversed
58	STATUS_POS	CACS00_DOCHD	STATUS_POS		☐	CACSSTATUSPOS	☐	Status of Object/Subobject
59	STATUS_WORK	CACS00_DOCHD	STATUS_WORK		☐	CACSSTATUSWORKP	☐	Object Processing Status (Replica)
60	REV_TIMESTAMP	CACS00_DOCHD	REV_TIMESTAMP		☐	CACSREVTSTMP	☐	Release Time Stamp of Object on Principle of Dual Control
61	REV_TCODE	CACS00_DOCHD	REV_TCODE		☐	CACSCDTC	☐	Transaction in Which the Change Was Made
62	REV_USR	CACS00_DOCHD	REV_USR		☐	CACSREVUSR	☐	User Who Released Object After Dual Checks
63	UPD_TIMESTAMP	CACS00_DOCHD	UPD_TIMESTAMP		☐	CACSUPDTSTMP	☐	Last Change of Objects
64	CTRTBU_ID	CACS00_DOCINV	CTRTBU_ID		☐	CACS_CTRTBU_ID	☐	Commission Contract Number
65	ROLE	CACS00_DOCINV	ROLE		☐	CACSROLE	☐	Participant Role
66	ROLE_COMMSHAR	CACS00_DOCINV	ROLE_COMMSHAR		☐	CACSCOMMSHARE	☐	Share of Direct Remuneration (in Percent)
67	ROLE_PRODSHAR	CACS00_DOCINV	ROLE_PRODSHAR		☐	CACSPRODSHARE	☐	Share of Indirect Remuneration (in Percent)
68	INV_POS_PARENT	CACS00_DOCREL	INV_POS_PARENT		☐	CACSINVPOSPARENT	☐	Position of a Higher-Level Participant in a Participation

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