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

History

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