SAP ABAP Table CACS_CTRTBU (Commission Contract)

Hierarchy

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

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CACS_CTRTBU	Table Relationship Diagram
Short Description	Commission Contract

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	T000
2	APPL	☑	CACSAPPL	CACSAPPL	CHAR	6	0	Commission Application (ICM)	TCACS_APPLDEF
3	CTRTBU_ID	☑	CACS_CTRTBU_ID	ISIS_CONTRACT_ID	CHAR	20	0	Commission Contract Number	CACS_CONTR
4	VERSION	☑	CACSVERSION	CACSVERSION	NUMC	6	0	Version of Master Data or Customizing Object
5	CTRTST_ID	☐	CACS_CTRTST_ID	ISIS_CONTRACT_ID	CHAR	20	0	Number of Standard Commission Contract	CACS_CTRTST
6	GPART	☐	CACS_GPART	BU_PARTNER	CHAR	10	0	Number of Commission Contract Partner	BUT000
7	CTRTBU_BDATE	☐	CACS_CTRTBU_BD	DATS	DATS	8	0	Start Date of Commission Contract
8	CTRTBU_EDATE	☐	CACS_CTRTBU_ED	DATS	DATS	8	0	End Date of Commission Contract
9	ENTR_DATE	☐	CACS_ENTR_DATE	DATS	DATS	8	0	Entry Date of Commission Recipient
10	LEAV_DATE	☐	CACS_LEAV_DATE	DATS	DATS	8	0	Commission Recipient's Leaving Date
11	CON_CURR	☐	CACSCONCURR	WAERS	CUKY	5	0	Contract Currency Key	TCURC
12	CHG_REASON	☐	CACSCHGREASON	CACSCHGREASON	CHAR	3	0	Reason for Changing Contract	TCACS_CTRCH
13	.INCLUDE	☐				0	0	Version Management for Master Data
14	.INCLUDE	☐				0	0	Version Management for Customizing Data
15	BUSI_BEGIN	☐	CACS_BUSITIME_B	CACSTIMESTAMP	NUMC	14	0	Effective from
16	BUSI_END	☐	CACS_BUSITIME_E	CACSTIMESTAMP	NUMC	14	0	Effective Until (Time Stamp: YYYY.MM.DD hh:mm:ss)
17	TECH_BEGIN	☐	CACS_TECHTIME_B	CACSTIMESTAMP	NUMC	14	0	Technically Valid From
18	TECH_END	☐	CACS_TECHTIME_E	CACSTIMESTAMP	NUMC	14	0	Technically Valid To (Time Stamp: JJJJ.MM.TT hh:mm:ss)
19	FLG_CANCEL_OBJ	☐	CACSCANCOBJ	BOOLEAN_FLG	CHAR	1	0	Indicator: Object is Invalid
20	FLG_CANCEL_VERS	☐	CACSCANCVERS	BOOLEAN_FLG	CHAR	1	0	Indicator: Version is Invalid
21	.INCLUDE	☐				0	0	Comn: Process Administration/Version Management
22	.INCLUDE	☐				0	0	Change Log for Object
23	CHG_TCODE	☐	CACSCDTC	TCODE	CHAR	20	0	Transaction in Which the Change Was Made	*
24	CHG_USR	☐	CACSCHUSR	USNAM	CHAR	12	0	Last user to change object
25	TRI_METH_TYP	☐	CACSTRIMETHTYP	CACSOPTYPE	CHAR	1	0	Triggering Method
26	TRI_METH_TARGET	☐	CACSTRIMETHTAR	CACSTRITARGET	CHAR	1	0	Processing Target of Triggering Method
27	STATUS_VERSION	☐	CACSSTATUSVERS	CACSSTATUSVERS	CHAR	1	0	Object Version Status	TCACS_VALSTAT1
28	STATUS_WORK	☐	CACSSTATUSWORK	CACSSTATUSWORK	CHAR	1	0	Object Version Processing Status	TCACS_VALSTAT1
29	.INCLUDE	☐				0	0	Structure: Fields for Correspondence Maintenance in ComnCont
30	RECEIVER	☐	CORR_PARTNER_KK	BU_PARTNER	CHAR	10	0	Correspondence Recipient ID	*
31	RECEIVER_DSC	☐	CACS_PARTNER_KK	CHAR50	CHAR	50	0	Correspondence Recipient: Description
32	IND_RECEIV	☐	CORR_ACKEY_KK	CORR_ACKEY_KK	CHAR	4	0	Correspondence - Activity Key	TFK070L
33	COPRC	☐	COPRC_KK	COPRC_KK	CHAR	4	0	Correspondence Variant	TFK070B
34	INT_TITLE	☐	CACS_ITITLE	CHAR3	CHAR	3	0	Internal Title	TCACS_ITITLE
35	TERM_OF_NOT	☐	CACS_TERM_OF_NOT	CHAR3	CHAR	3	0	Period of notice	TCACS_TOFN
36	TERM_DATE	☐	CACS_TERM_DATE	CHAR3	CHAR	3	0	Cancellation Date	TCACS_TERMD
37	FLG_STOPCASE	☐	CACS_FLG_STOPCASE	BOOLEAN_FLG	CHAR	1	0	Contract Means Commission Case is Set to Pending (Obsolete)
38	XDELE	☐	CACS_XDELE	XFELD	CHAR	1	0	Central Archiving Flag
39	FILTERID	☐	CACSACTFILTER	CACSFILTERIDDO	CHAR	8	0	Identification of an Activity Filter	*
40	CTRTBU_ID_EXT	☐	CACS_CTRTBU_ID_EXT	ISIS_CONTRACT_ID_EXT	CHAR	20	0	External Identification of Commission Contract
41	LVRSID	☐	CACSLVRSID	CHAR02	CHAR	2	0	Termination Reason

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CACS_CTRTBU	APPL	TCACS_APPLDEF	APPL	KEY	1	CN
2	CACS_CTRTBU	CHG_REASON	TCACS_CTRCH	CHG_REASON	KEY	1	CN
3	CACS_CTRTBU	CON_CURR	TCURC	WAERS
4	CACS_CTRTBU	COPRC	TFK070B	COPRC	REF	1	CN
5	CACS_CTRTBU	CTRTBU_ID	CACS_CONTR	CONTRACT_ID	KEY	1	CN
6	CACS_CTRTBU	CTRTST_ID	CACS_CTRTST	CTRTST_ID	KEY	1	CN
7	CACS_CTRTBU	GPART	BUT000	PARTNER	KEY	1	CN
8	CACS_CTRTBU	IND_RECEIV	TFK070L	CORR_ACKEY	REF	1	CN
9	CACS_CTRTBU	INT_TITLE	TCACS_ITITLE	INT_TITLE		1	CN
10	CACS_CTRTBU	MANDT	T000	MANDT	KEY	1	CN
11	CACS_CTRTBU	STATUS_VERSION	TCACS_VALSTAT1	STATUS_VERSION
12	CACS_CTRTBU	STATUS_WORK	TCACS_VALSTAT1	STATUS_WORK
13	CACS_CTRTBU	TERM_DATE	TCACS_TERMD	TERM_DATE		1	CN
14	CACS_CTRTBU	TERM_OF_NOT	TCACS_TOFN	TERM_OF_NOT		1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in