SAP ABAP Table TCACS_TGT (Target Agreements: Complex Target Type)

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	TCACS_TGT	Table Relationship Diagram
Short Description	Target Agreements: Complex Target Type

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	CTGTTYPE	☑	CACS_TGTTYPE	CACS_TGTTYPE	CHAR	4	0	Target Agreements: Complex Target Type
4	VERSION	☑	CACSVERSION	CACSVERSION	NUMC	6	0	Version of Master Data or Customizing Object
5	CATEG	☐	CACS_TGTCATEGORY	CACS_TGTCATEGORY	CHAR	4	0	Target Agreement: Target Category	TCACS_TGC
6	TRGCAS_TYPE	☐	CACS_TRGCAS_TYPE	CACS_TRGCAS_TYPE	CHAR	4	0	Reason for Additional Commission Case Being Triggered	V_TCACS_TRCASESS
7	OBJTYPE	☐	CACSTRIOBJ	CACSOBTYID	CHAR	5	0	Triggering Subobject Type	TCACS_OBJTYPES
8	PERRULE	☐	CACSPRDRULE	CACSPRDRULE	CHAR	7	0	Period Rule
9	TGTTYPLOCK	☐	CACS_TGTLOCKIND	CACS_TGTLOCKIND	CHAR	1	0	Target Agreements: Lock Indicator
10	GENTGTIND	☐	CACS_TGTGENTGTIND	CACS_TGTBOOLEAN	CHAR	1	0	Tgt Agrmts: Indicator for Generic Classification of Targets
11	.INCLUDE	☐				0	0	Target Agreements: Include Structure for AES Form
12	TEMPLATE_ID	☐	HAP_TEMPLATE_ID	NUMC08	NUMC	8	0	Appraisal Template
13	.INCLUDE	☐				0	0	Version Management for Customizing Data
14	BUSI_BEGIN	☐	CACS_BUSITIME_B	CACSTIMESTAMP	NUMC	14	0	Effective from
15	BUSI_END	☐	CACS_BUSITIME_E	CACSTIMESTAMP	NUMC	14	0	Effective Until (Time Stamp: YYYY.MM.DD hh:mm:ss)
16	TECH_BEGIN	☐	CACS_TECHTIME_B	CACSTIMESTAMP	NUMC	14	0	Technically Valid From
17	TECH_END	☐	CACS_TECHTIME_E	CACSTIMESTAMP	NUMC	14	0	Technically Valid To (Time Stamp: JJJJ.MM.TT hh:mm:ss)
18	FLG_CANCEL_OBJ	☐	CACSCANCOBJ	BOOLEAN_FLG	CHAR	1	0	Indicator: Object is Invalid
19	FLG_CANCEL_VERS	☐	CACSCANCVERS	BOOLEAN_FLG	CHAR	1	0	Indicator: Version is Invalid
20	.INCLUDE	☐				0	0	Comn: Process Administration/Version Management
21	.INCLUDE	☐				0	0	Change Log for Object
22	CHG_TCODE	☐	CACSCDTC	TCODE	CHAR	20	0	Transaction in Which the Change Was Made	*
23	CHG_USR	☐	CACSCHUSR	USNAM	CHAR	12	0	Last user to change object
24	TRI_METH_TYP	☐	CACSTRIMETHTYP	CACSOPTYPE	CHAR	1	0	Triggering Method
25	TRI_METH_TARGET	☐	CACSTRIMETHTAR	CACSTRITARGET	CHAR	1	0	Processing Target of Triggering Method
26	STATUS_VERSION	☐	CACSSTATUSVERS	CACSSTATUSVERS	CHAR	1	0	Object Version Status	TCACS_VALSTAT1
27	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	TCACS_TGT	APPL	TCACS_APPLDEF	APPL
2	TCACS_TGT	CATEG	TCACS_TGC	CATEG
3	TCACS_TGT	OBJTYPE	TCACS_OBJTYPES	OBTYID
4	TCACS_TGT	STATUS_VERSION	TCACS_VALSTAT1	STATUS_VERSION
5	TCACS_TGT	STATUS_WORK	TCACS_VALSTAT1	STATUS_WORK
6	TCACS_TGT	TRGCAS_TYPE	V_TCACS_TRCASESS	TRGCAS_TYPE

History

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