SAP ABAP Table CACS_TGACV (Target Agreements: Indiv. Actual/Correction/Target Values)

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_TGACV	Table Relationship Diagram
Short Description	Target Agreements: Indiv. Actual/Correction/Target Values

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	*
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_CTRTBU
4	STGTTYPE	☑	CACS_TGTSIMPLETYPE	CACS_TGTSIMPLETYPE	CHAR	4	0	Target Agreements: Elementary Target Types	*
5	RULE_ID	☑	CACSPRDRULE	CACSPRDRULE	CHAR	7	0	Period Rule
6	PERIOD_NO	☑	CACSPERIOD	NUMC6	NUMC	6	0	Period Number
7	VERSION	☑	CACSVERSION	CACSVERSION	NUMC	6	0	Version of Master Data or Customizing Object
8	TAR_QUAN	☐	CACS_TGTTARVALQTY	CACS_TGTQUANTITY	QUAN	13	3	Target Agreements: Target Value (Quantity)
9	TAR_CURR	☐	CACS_TGTTARVALAMT	CACS_TGTAMOUNT	CURR	15	2	Target Agreements: Target Value (Amount)
10	TAR_MAINT	☐	CACS_TGTMAINTFLAG	CACS_TGTBOOLEAN	CHAR	1	0	Target Agreements: Value Maintained Indicator
11	ACT_QUAN	☐	CACS_TGTACTVALQTY	CACS_TGTQUANTITY	QUAN	13	3	Target Agreements: Actual Value (Quantity)
12	ACT_CURR	☐	CACS_TGTACTVALAMT	CACS_TGTAMOUNT	CURR	15	2	Target Agreements: Actual Value (Amount)
13	ACT_MAINT	☐	CACS_TGTMAINTFLAG	CACS_TGTBOOLEAN	CHAR	1	0	Target Agreements: Value Maintained Indicator
14	COR_QUAN	☐	CACS_TGTCORVALQTY	CACS_TGTQUANTITY	QUAN	13	3	Target Agreements: Correction Value (Quantity)
15	COR_CURR	☐	CACS_TGTCORVALAMT	CACS_TGTAMOUNT	CURR	15	2	Target Agreements: Correction Value (Amount)
16	COR_MAINT	☐	CACS_TGTMAINTFLAG	CACS_TGTBOOLEAN	CHAR	1	0	Target Agreements: Value Maintained Indicator
17	COR_OFFSET	☐	CACS_TGTCORRVALOFFSET	CACS_TGTBOOLEAN	CHAR	1	0	Target Agreements: Correction Value Offset Indicator
18	MEINS	☐	CACS_TGTUOM	MEINS	UNIT	3	0	Target Agreement: Unit of Measurement	T006
19	WAERS	☐	CACS_TGTCURRENCY	WAERS	CUKY	5	0	Target Agreement: Currency	TCURC
20	.INCLUDE	☐				0	0	Version Management for Master Data
21	.INCLUDE	☐				0	0	Version Management for Customizing Data
22	BUSI_BEGIN	☐	CACS_BUSITIME_B	CACSTIMESTAMP	NUMC	14	0	Effective from
23	BUSI_END	☐	CACS_BUSITIME_E	CACSTIMESTAMP	NUMC	14	0	Effective Until (Time Stamp: YYYY.MM.DD hh:mm:ss)
24	TECH_BEGIN	☐	CACS_TECHTIME_B	CACSTIMESTAMP	NUMC	14	0	Technically Valid From
25	TECH_END	☐	CACS_TECHTIME_E	CACSTIMESTAMP	NUMC	14	0	Technically Valid To (Time Stamp: JJJJ.MM.TT hh:mm:ss)
26	FLG_CANCEL_OBJ	☐	CACSCANCOBJ	BOOLEAN_FLG	CHAR	1	0	Indicator: Object is Invalid
27	FLG_CANCEL_VERS	☐	CACSCANCVERS	BOOLEAN_FLG	CHAR	1	0	Indicator: Version is Invalid
28	.INCLUDE	☐				0	0	Comn: Process Administration/Version Management
29	.INCLUDE	☐				0	0	Change Log for Object
30	CHG_TCODE	☐	CACSCDTC	TCODE	CHAR	20	0	Transaction in Which the Change Was Made	*
31	CHG_USR	☐	CACSCHUSR	USNAM	CHAR	12	0	Last user to change object
32	TRI_METH_TYP	☐	CACSTRIMETHTYP	CACSOPTYPE	CHAR	1	0	Triggering Method
33	TRI_METH_TARGET	☐	CACSTRIMETHTAR	CACSTRITARGET	CHAR	1	0	Processing Target of Triggering Method
34	STATUS_VERSION	☐	CACSSTATUSVERS	CACSSTATUSVERS	CHAR	1	0	Object Version Status	TCACS_VALSTAT1
35	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_TGACV	APPL	TCACS_APPLDEF	APPL
2	CACS_TGACV	CTRTBU_ID	CACS_CTRTBU	CTRTBU_ID
3	CACS_TGACV	MEINS	T006	MSEHI
4	CACS_TGACV	STATUS_VERSION	TCACS_VALSTAT1	STATUS_VERSION
5	CACS_TGACV	STATUS_WORK	TCACS_VALSTAT1	STATUS_WORK
6	CACS_TGACV	WAERS	TCURC	WAERS

History

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