SAP ABAP Table TCACS_STMTY (Settlement Type)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ ICM (Application Component) Incentive and Commission Management (ICM)
     ⤷ CACSPY (Package) ICM: Distribution & Offsetting

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	TCACS_STMTY	Table Relationship Diagram
Short Description	Settlement Type

Delivery and Maintenance

Pool/cluster
Delivery Class	E	Control table, SAP and customer have separate key areas
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

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	STMTYPE_ID	☑	CACS_STMTYPE_ID	CACSSTMTY	CHAR	4	0	Identification of Settlement Type
4	VERSION	☑	CACSVERSION	CACSVERSION	NUMC	6	0	Version of Master Data or Customizing Object
5	STM_TYP	☐	CACS_STM_TYP	CACS_STM_TYP	CHAR	2	0	Settlement Category	TCACS_STMF
6	ACCAS_TYID	☐	CACS_ACCAS_TYID	CACSACCAS	CHAR	4	0	Account Assignment Type Identification	TCACS_ACCAS
7	TARGET_SYS	☐	CACS_TARGET_SYS	CHAR020	CHAR	20	0	Target System (Disbursement System)
8	RES_RATE	☐	CACS_RES_RATE	CACSPERCENT	DEC	8	3	Reserve Rate (Percentage)
9	RES_MAX_AMNT	☐	CACS_RES_AMNT	CACSAMNTSUM	CURR	15	2	Maximum Reserve Amount
10	THRESH_AMNT	☐	CACSTHRESAMNT	CACSAMNTSUM	CURR	15	2	Threshold Value Reserve
11	TRIGID	☐	CACSTRIGID	CACSTRIGID	CHAR	4	0	Identification of Logical Target System of Settlement	TCACS_TRIGID
12	PMNT_BLOCK	☐	DZLSPR	ZAHLS	CHAR	1	0	Payment Block Key	*
13	INCHARGE	☐	CACSINCHARGE	BOOLEAN_FLG	CHAR	1	0	Indicator: Control of Payment Block of Reserve Line Items
14	COMBTP_ID	☐	CACS_COMBTP_ID	CACS_COMBTP_ID	CHAR	12	0	Number of Characteristics Combination Type
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
30	MIN_PAYOUT	☐	CACS_MIN_PAYOUT	CACSAMNTSUM	CURR	15	2	Positive Threshold Value for Settlement
31	MIN_PAYBACK	☐	CACS_MIN_PAYBACK	CACSAMNTSUM	CURR	15	2	Negative Threshold Value for Settlement
32	SKIP_ZERO_VALUE	☐	CACS_SKIP_ZERO	BOOLEAN_FLG	CHAR	1	0	Ignore Due Settlement Items with Zero Amount

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TCACS_STMTY	ACCAS_TYID	TCACS_ACCAS	ACCAS_TYID	KEY
2	TCACS_STMTY	APPL	TCACS_APPLDEF	APPL	KEY
3	TCACS_STMTY	MANDT	T000	MANDT	KEY
4	TCACS_STMTY	STATUS_VERSION	TCACS_VALSTAT1	STATUS_VERSION
5	TCACS_STMTY	STATUS_WORK	TCACS_VALSTAT1	STATUS_WORK
6	TCACS_STMTY	STM_TYP	TCACS_STMF	STM_TYP	KEY	1	CN
7	TCACS_STMTY	TRIGID	TCACS_TRIGID	TRIGID

History

Last changed by/on	SAP	20130529
SAP Release Created in