SAP ABAP Table CACS_STTGAGR (Tgt Agmts: Assignment of Target Types to Standard Agreements)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ ICM (Application Component) Incentive and Commission Management (ICM)
     ⤷ CACST3 (Package) ICM: Target Agreements Persistence

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CACS_STTGAGR	Table Relationship Diagram
Short Description	Tgt Agmts: Assignment of Target Types to Standard Agreements

Delivery and Maintenance

Pool/cluster
Delivery Class	E	Control table, SAP and customer have separate key areas
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	APPL	☑	CACSAPPL	CACSAPPL	CHAR	6	0	Commission Application (ICM)	TCACS_APPLDEF
3	AGR_TYP	☑	CACS_AGR_TYP	CACS_AGR_TYP	CHAR	2	0	Agreement Type	*
4	STCAGR_ID	☑	CACS_STCAGR_ID	CACS_STCAGR_ID	CHAR	12	0	Standard Agreement Number	CACS_STCAGR
5	CTGTTYPE	☑	CACS_TGTTYPE	CACS_TGTTYPE	CHAR	4	0	Target Agreements: Complex Target Type	TCACS_TGT
6	VERSION	☑	CACSVERSION	CACSVERSION	NUMC	6	0	Version of Master Data or Customizing Object
7	.INCLUDE	☐				0	0	Version Management for Customizing Data
8	BUSI_BEGIN	☐	CACS_BUSITIME_B	CACSTIMESTAMP	NUMC	14	0	Effective from
9	BUSI_END	☐	CACS_BUSITIME_E	CACSTIMESTAMP	NUMC	14	0	Effective Until (Time Stamp: YYYY.MM.DD hh:mm:ss)
10	TECH_BEGIN	☐	CACS_TECHTIME_B	CACSTIMESTAMP	NUMC	14	0	Technically Valid From
11	TECH_END	☐	CACS_TECHTIME_E	CACSTIMESTAMP	NUMC	14	0	Technically Valid To (Time Stamp: JJJJ.MM.TT hh:mm:ss)
12	FLG_CANCEL_OBJ	☐	CACSCANCOBJ	BOOLEAN_FLG	CHAR	1	0	Indicator: Object is Invalid
13	FLG_CANCEL_VERS	☐	CACSCANCVERS	BOOLEAN_FLG	CHAR	1	0	Indicator: Version is Invalid
14	.INCLUDE	☐				0	0	Comn: Process Administration/Version Management
15	.INCLUDE	☐				0	0	Change Log for Object
16	CHG_TCODE	☐	CACSCDTC	TCODE	CHAR	20	0	Transaction in Which the Change Was Made	*
17	CHG_USR	☐	CACSCHUSR	USNAM	CHAR	12	0	Last user to change object
18	TRI_METH_TYP	☐	CACSTRIMETHTYP	CACSOPTYPE	CHAR	1	0	Triggering Method
19	TRI_METH_TARGET	☐	CACSTRIMETHTAR	CACSTRITARGET	CHAR	1	0	Processing Target of Triggering Method
20	STATUS_VERSION	☐	CACSSTATUSVERS	CACSSTATUSVERS	CHAR	1	0	Object Version Status	TCACS_VALSTAT1
21	STATUS_WORK	☐	CACSSTATUSWORK	CACSSTATUSWORK	CHAR	1	0	Object Version Processing Status	TCACS_VALSTAT1

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CACS_STTGAGR	APPL	TCACS_APPLDEF	APPL
2	CACS_STTGAGR	CTGTTYPE	TCACS_TGT	CTGTTYPE
3	CACS_STTGAGR	STATUS_VERSION	TCACS_VALSTAT1	STATUS_VERSION
4	CACS_STTGAGR	STATUS_WORK	TCACS_VALSTAT1	STATUS_WORK
5	CACS_STTGAGR	STCAGR_ID	CACS_STCAGR	STCAGR_ID

History

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