SAP ABAP Table V_CACS_STWARRU (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_CACS_STWARRU	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
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	STCAGR_ID	☑	CACS_STCAGR_ID	CACS_STCAGR_ID	CHAR	12	0	Standard Agreement Number	CACS_STCAGR
4	AGR_TYP	☑	CACS_AGR_TYP	CACS_AGR_TYP	CHAR	2	0	Agreement Type	TCACS_AGR
5	STWARRU_ID	☑	CACS_STWARRU_ID	NUMC12	NUMC	12	0	Identification of Standard Guarantee Agreement Rule
6	VERSION	☑	CACSVERSION	CACSVERSION	NUMC	6	0	Version of Master Data or Customizing Object
7	REMUNERATION	☐	CACSREM	CACSREM	CHAR	4	0	Remuneration Type	TCACS_REM
8	DURATION	☐	CACS_REMA_DUR	CHAR2	CHAR	2	0	Duration of Guarantee Agreement
9	WAR_AMNT	☐	CACS_WARR_AMNT	WERT15	CURR	15	2	Guarantee Amount
10	MIN_WAR_AMNT	☐	CACS_WAR_MINAMNT	CACSAMNTSUM	CURR	15	2	Minimum Guarantee Amount
11	MAX_WAR_AMNT	☐	CACS_WAR_MAXAMNT	CACSAMNTSUM	CURR	15	2	Maximum Guarantee Amount
12	EXCESS_REM	☐	CACSEXCESSREM	CACSREM	CHAR	4	0	Remuneration Type Excess	TCACS_REM
13	RECALL_REM	☐	CACSRECALLREM	CACSREM	CHAR	4	0	Remuneration Type Recall	TCACS_REM
14	RETAINED_REM	☐	CACSRETAINREM	CACSREM	CHAR	4	0	Remuneration Type for Retained Excess Remuneration	TCACS_REM
15	RETRU_ID	☐	CACSRETRUID	CACSRETRUID	CHAR	4	0	Identification of Retention Rule	TCACS_RETRU
16	EXCESS_OFFSET	☐	CACSGUEXCOFF	BOOLEAN_FLG	CHAR	1	0	Guarantee: Offsetting of Excess with Subthreshold Earnings
17	EXCESS_RETAIN	☐	CACSGUEXCRET	BOOLEAN_FLG	CHAR	1	0	Guarantee: Retain Remaining Excess Earnings
18	RULE_ID	☐	CACSPRDRULE	CACSPRDRULE	CHAR	7	0	Period Rule
19	ALLOCATION	☐	CACSALLOC	CACSALLOC	CHAR	1	0	Offsetting Selectn (Excess/Sub-Threshold Earnings, Advances)
20	REASSIGNMENT	☐	CACSREASSIGN	XFELD	CHAR	1	0	Reassignment
21	DUE_DATEMARK	☐	CACSDUEDATEM	CACSDUEDATEM	CHAR	1	0	Indicator: Due Date at Start or End of Period
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	CHG_TCODE	☐	CACSCDTC	TCODE	CHAR	20	0	Transaction in Which the Change Was Made
29	CHG_USR	☐	CACSCHUSR	USNAM	CHAR	12	0	Last user to change object
30	TRI_METH_TYP	☐	CACSTRIMETHTYP	CACSOPTYPE	CHAR	1	0	Triggering Method
31	TRI_METH_TARGET	☐	CACSTRIMETHTAR	CACSTRITARGET	CHAR	1	0	Processing Target of Triggering Method
32	STATUS_VERSION	☐	CACSSTATUSVERS	CACSSTATUSVERS	CHAR	1	0	Object Version Status	TCACS_VALSTAT1
33	STATUS_WORK	☐	CACSSTATUSWORK	CACSSTATUSWORK	CHAR	1	0	Object Version Processing Status	TCACS_VALSTAT1
34	NAME	☐	CACSSTWARTXT	CACSSHORTTXT	CHAR	40	0	Name of Standard Guarantee Agreement Rule

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_CACS_STWARRU	AGR_TYP	TCACS_AGR	AGRTYP
2	V_CACS_STWARRU	APPL	TCACS_APPLDEF	APPL	KEY
3	V_CACS_STWARRU	EXCESS_REM	TCACS_REM	REMUNERATION	KEY
4	V_CACS_STWARRU	MANDT	T000	MANDT	KEY
5	V_CACS_STWARRU	RECALL_REM	TCACS_REM	REMUNERATION	KEY
6	V_CACS_STWARRU	REMUNERATION	TCACS_REM	REMUNERATION	KEY
7	V_CACS_STWARRU	RETAINED_REM	TCACS_REM	REMUNERATION	KEY
8	V_CACS_STWARRU	RETRU_ID	TCACS_RETRU	RETRU_ID	KEY
9	V_CACS_STWARRU	STATUS_VERSION	TCACS_VALSTAT1	STATUS_VERSION
10	V_CACS_STWARRU	STATUS_WORK	TCACS_VALSTAT1	STATUS_WORK
11	V_CACS_STWARRU	STCAGR_ID	CACS_STCAGR	STCAGR_ID	KEY

History

Last changed by/on	SAP	20130529
SAP Release Created in